38 Commits

Author SHA1 Message Date
Michael Silberling
7cbfd0e533 Update receipts.sql
fee scalar to decimal
2023-07-06 17:19:27 -04:00
Michael Silberling
6599a438a0 add to sql 2023-05-26 13:05:22 -04:00
Anton Bryzgalov @ CoinStats
4ee070627c schemas/aws: removed debug queries
Sponsored by CoinStats.app
2022-06-10 14:36:42 +04:00
Anton Bryzgalov @ CoinStats
7a337e724a schemas: aws_partition_by_date -> aws
Sponsored by CoinStats.app
2022-06-10 13:56:43 +04:00
Anton Bryzgalov @ CoinStats
ac812a0f36 schemas/aws_partition_by_date: schemas updated to JSON format
Sponsored by CoinStats.app
2022-06-10 13:56:02 +04:00
Evgeny Medvedev
ff1068208a Remove GCP schemas 2018-08-17 23:00:13 +07:00
Evgeny Medvedev
0dcbe6b00c Update table and column descriptions 2018-08-14 15:44:40 +07:00
Evgeny Medvedev
5402611739 Add enrich contracts sql 2018-08-14 15:19:27 +07:00
medvedev1088
f1e8e93f56 Merge pull request #87 from tokusyu/develop
I made AWS schemas for partition by date.
2018-08-14 12:18:53 +07:00
tokusyu
9a19eab23f delete mismaked schemas 2018-08-14 05:51:42 +09:00
tokusyu
190384fe50 Add date partitionized version of aws schemas 2018-08-14 05:49:11 +09:00
Evgeny Medvedev
1dd2d810d9 Add scripts for enriching tables in BigQuery 2018-08-14 02:02:46 +07:00
Evgeny Medvedev
a2a6cc660f Use STRING type for tokens.total_supply 2018-08-12 15:30:01 +07:00
Evgeny Medvedev
66ecaabd0c Update column descriptions 2018-08-07 12:59:38 +07:00
Evgeny Medvedev
d8cee8c3ea Change column description for token_transfers 2018-08-05 01:37:58 +07:00
Evgeny Medvedev
2b59852a2e Fix typo in column description 2018-08-05 01:36:45 +07:00
Evgeny Medvedev
1cb2f4e943 Add receipts_root to blocks.csv 2018-08-05 00:30:03 +07:00
Evgeny Medvedev
e321fe5b93 Remove contract_ prefix from CSVs and tables 2018-08-04 23:49:11 +07:00
Evgeny Medvedev
7b2ed63d91 Remove log_prefix from CSVs and tables 2018-08-04 23:44:21 +07:00
Evgeny Medvedev
2219046f5e Rename index to transaction_index 2018-08-04 23:36:04 +07:00
Evgeny Medvedev
b37bedc7e9 Remove receipt_ prefix from CSV and tables 2018-08-04 23:30:58 +07:00
Evgeny Medvedev
2b255412bd Remove tx_ prefix from CSV and tables, rename tx_hash to transaction_hash 2018-08-04 23:25:34 +07:00
Evgeny Medvedev
dc2c3ff1b3 Remove block_ prefix from CSV and tables 2018-08-04 23:10:01 +07:00
Evgeny Medvedev
468b7b4fe0 Rename erc20_token to token 2018-08-04 22:31:12 +07:00
Evgeny Medvedev
74882c5880 Rename erc20_transfer to token_transfer 2018-08-04 22:00:23 +07:00
Evgeny Medvedev
42e0e33862 Add new fields to README 2018-07-29 23:33:36 +07:00
Evgeny Medvedev
d0aeb3e3ea Add json support 2018-07-25 21:52:47 +07:00
Evgeny Medvedev
3cf902a368 Change erc20_value type to STRING 2018-07-25 20:51:21 +07:00
Evgeny Medvedev
cd3921dad8 Fix MSCK REPAIR in aws schema files 2018-07-22 15:25:33 +07:00
Yoshinori Seki
e9fecd3d05 erc20_tokens, logs, receipts, contracts table definitions are added. 2018-07-21 22:25:36 +00:00
Evgeny Medvedev
d4fc784183 Add erc20_token schema 2018-07-11 00:29:30 +07:00
evgeny
e8575c9101 Change transactions_join_receipts schema 2018-07-03 18:26:49 +07:00
evgeny
c8ffc04436 Add transactions_join_receipts tables 2018-07-02 19:26:53 +07:00
evgeny
256600fb94 Add contracts and blocks_join_transactions_join_receipts tables 2018-07-02 18:12:50 +07:00
evgeny
e8b6376103 Add blocks_join_transactions_join_receipts table 2018-07-02 17:27:26 +07:00
Evgeny Medvedev
85672b22b9 Fix error in schema 2018-06-30 16:21:54 +07:00
Evgeny Medvedev
320ea74e92 Add BigQuery schemas for receipts and logs 2018-06-28 23:48:33 +07:00
Evgeny Medvedev
9251ea1cc3 Update README 2018-06-26 22:57:06 +07:00