PREVIEW / futures_1hour / 2021-12-24
file: by_date/futures_1hour/2021/2021-12-24.parquet size: 7 KB rows: 61
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2021-12-24 00:00:00 | B | Futures | 46.93 | 47.04 | 46.9 | 46.99 | 554.0 |
| 2021-12-24 00:00:00 | FTUK | Futures | 7498.6 | 7515.1 | 7478.1 | 7507.4 | 89.0 |
| 2021-12-24 00:00:00 | JB | Futures | 139.47 | 139.47 | 139.46 | 139.47 | 13.0 |
| 2021-12-24 01:00:00 | B | Futures | 46.97 | 47.05 | 46.91 | 47.04 | 316.0 |
| 2021-12-24 01:00:00 | FTUK | Futures | 7506.4 | 7508.4 | 7505.8 | 7507.9 | 9.0 |
| 2021-12-24 01:00:00 | JB | Futures | 139.46 | 139.46 | 139.46 | 139.46 | 8.0 |
| 2021-12-24 02:00:00 | B | Futures | 47.01 | 47.05 | 46.94 | 46.94 | 130.0 |
| 2021-12-24 02:00:00 | ER | Futures | 98.515 | 98.515 | 98.515 | 98.515 | 319.0 |
| 2021-12-24 02:00:00 | FCE | Futures | 7274.3 | 7278.4 | 7266.1 | 7266.1 | 284.0 |
| 2021-12-24 02:00:00 | FTI | Futures | 788.02 | 789.11 | 787.17 | 788.91 | 143.0 |
| 2021-12-24 02:00:00 | FTUK | Futures | 7505.3 | 7520.2 | 7490.9 | 7519.7 | 518.0 |
| 2021-12-24 02:00:00 | JB | Futures | 139.47 | 139.47 | 139.46 | 139.46 | 6.0 |
| 2021-12-24 02:00:00 | SO3 | Futures | 96.96 | 96.96 | 96.96 | 96.96 | 1.0 |
| 2021-12-24 03:00:00 | B | Futures | 46.94 | 46.94 | 46.68 | 46.79 | 1376.0 |
| 2021-12-24 03:00:00 | ER | Futures | 98.51 | 98.515 | 98.51 | 98.515 | 134.0 |
| 2021-12-24 03:00:00 | FCE | Futures | 7267.1 | 7285.0 | 7259.4 | 7284.0 | 1090.0 |
| 2021-12-24 03:00:00 | FTI | Futures | 788.96 | 790.61 | 788.52 | 789.81 | 520.0 |
| 2021-12-24 03:00:00 | FTUK | Futures | 7519.7 | 7537.7 | 7517.1 | 7537.2 | 2386.0 |
| 2021-12-24 03:00:00 | G | Futures | 120.72 | 120.82 | 120.54 | 120.68 | 2583.0 |
| 2021-12-24 03:00:00 | JB | Futures | 139.46 | 139.46 | 139.46 | 139.46 | 1.0 |
| 2021-12-24 03:00:00 | SO3 | Futures | 96.96 | 96.96 | 96.95 | 96.96 | 236.0 |
| 2021-12-24 04:00:00 | B | Futures | 46.8 | 46.9 | 46.55 | 46.58 | 1358.0 |
| 2021-12-24 04:00:00 | EBM | Futures | 433.31 | 433.31 | 430.7 | 430.7 | 113.0 |
| 2021-12-24 04:00:00 | ER | Futures | 98.515 | 98.52 | 98.515 | 98.52 | 326.0 |
| 2021-12-24 04:00:00 | FCE | Futures | 7283.0 | 7292.7 | 7279.9 | 7283.0 | 842.0 |
| 2021-12-24 04:00:00 | FTI | Futures | 789.76 | 791.16 | 789.46 | 790.71 | 313.0 |
| 2021-12-24 04:00:00 | FTUK | Futures | 7537.2 | 7549.5 | 7537.2 | 7545.4 | 1729.0 |
| 2021-12-24 04:00:00 | G | Futures | 120.67 | 120.79 | 120.6 | 120.7 | 2102.0 |
| 2021-12-24 04:00:00 | JB | Futures | 139.48 | 139.48 | 139.48 | 139.48 | 1.0 |
| 2021-12-24 04:00:00 | SO3 | Futures | 96.96 | 96.96 | 96.95 | 96.96 | 295.0 |
| 2021-12-24 05:00:00 | B | Futures | 46.58 | 46.85 | 46.57 | 46.79 | 863.0 |
| 2021-12-24 05:00:00 | EBM | Futures | 430.7 | 432.94 | 429.96 | 432.56 | 302.0 |
| 2021-12-24 05:00:00 | ER | Futures | 98.52 | 98.52 | 98.515 | 98.515 | 96.0 |
| 2021-12-24 05:00:00 | FCE | Futures | 7282.5 | 7288.1 | 7277.4 | 7283.0 | 625.0 |
| 2021-12-24 05:00:00 | FTI | Futures | 790.76 | 790.81 | 790.11 | 790.11 | 215.0 |
| 2021-12-24 05:00:00 | FTUK | Futures | 7545.4 | 7551.6 | 7543.4 | 7543.4 | 906.0 |
| 2021-12-24 05:00:00 | G | Futures | 120.71 | 120.77 | 120.64 | 120.71 | 1148.0 |
| 2021-12-24 05:00:00 | JB | Futures | 139.48 | 139.49 | 139.48 | 139.49 | 5.0 |
| 2021-12-24 05:00:00 | SO3 | Futures | 96.96 | 96.96 | 96.95 | 96.95 | 18.0 |
| 2021-12-24 06:00:00 | B | Futures | 46.79 | 46.94 | 46.63 | 46.93 | 1258.0 |
| 2021-12-24 06:00:00 | EBM | Futures | 432.19 | 434.05 | 432.19 | 433.31 | 473.0 |
| 2021-12-24 06:00:00 | ER | Futures | 98.52 | 98.52 | 98.515 | 98.515 | 431.0 |
| 2021-12-24 06:00:00 | FCE | Futures | 7282.5 | 7282.5 | 7269.7 | 7269.7 | 688.0 |
| 2021-12-24 06:00:00 | FTI | Futures | 790.06 | 790.06 | 789.36 | 789.71 | 221.0 |
| 2021-12-24 06:00:00 | FTUK | Futures | 7542.8 | 7548.5 | 7540.8 | 7548.0 | 953.0 |
| 2021-12-24 06:00:00 | G | Futures | 120.71 | 120.71 | 120.61 | 120.65 | 1355.0 |
| 2021-12-24 06:00:00 | JB | Futures | 139.48 | 139.48 | 139.48 | 139.48 | 3.0 |
| 2021-12-24 06:00:00 | SO3 | Futures | 96.95 | 96.96 | 96.95 | 96.95 | 474.0 |
| 2021-12-24 07:00:00 | B | Futures | 46.93 | 47.13 | 46.55 | 46.62 | 4914.0 |
| 2021-12-24 07:00:00 | EBM | Futures | 433.31 | 433.68 | 431.82 | 433.31 | 184.0 |
> showing 50 of 61 rows — these rows as CSV