PREVIEW / futures_1hour / 2021-09-12
file: by_date/futures_1hour/2021/2021-09-12.parquet size: 18 KB rows: 381
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-09-12 18:00:00 | ES | Futures | 5024.55 | 5036.66 | 5023.15 | 5035.82 | 7197.0 |
| 2021-09-12 19:00:00 | ES | Futures | 5035.82 | 5041.17 | 5033.28 | 5039.76 | 5411.0 |
| 2021-09-12 20:00:00 | ES | Futures | 5040.04 | 5041.45 | 5031.59 | 5032.44 | 6795.0 |
| 2021-09-12 21:00:00 | ES | Futures | 5032.44 | 5034.97 | 5027.09 | 5027.65 | 7397.0 |
| 2021-09-12 22:00:00 | ES | Futures | 5027.93 | 5032.44 | 5027.09 | 5030.18 | 4045.0 |
| 2021-09-12 23:00:00 | ES | Futures | 5030.47 | 5034.97 | 5029.62 | 5029.9 | 3800.0 |
| 2021-09-12 18:00:00 | NQ | Futures | 17905.2 | 17941.12 | 17896.51 | 17937.64 | 3690.0 |
| 2021-09-12 19:00:00 | NQ | Futures | 17937.64 | 17955.02 | 17929.82 | 17950.39 | 2214.0 |
| 2021-09-12 20:00:00 | NQ | Futures | 17951.26 | 17955.6 | 17919.97 | 17923.74 | 3703.0 |
| 2021-09-12 21:00:00 | NQ | Futures | 17924.03 | 17929.24 | 17890.71 | 17894.19 | 4939.0 |
| 2021-09-12 22:00:00 | NQ | Futures | 17894.19 | 17913.6 | 17890.71 | 17902.3 | 2490.0 |
| 2021-09-12 23:00:00 | NQ | Futures | 17902.88 | 17917.08 | 17897.09 | 17902.3 | 2151.0 |
| 2021-09-12 18:00:00 | YM | Futures | 38704.9 | 38778.9 | 38684.8 | 38768.8 | 1928.0 |
| 2021-09-12 19:00:00 | YM | Futures | 38769.9 | 38823.7 | 38756.5 | 38814.8 | 1263.0 |
| 2021-09-12 20:00:00 | YM | Futures | 38815.9 | 38831.6 | 38731.8 | 38741.9 | 2793.0 |
| 2021-09-12 21:00:00 | YM | Futures | 38743.0 | 38765.5 | 38717.3 | 38725.1 | 2399.0 |
| 2021-09-12 22:00:00 | YM | Futures | 38725.1 | 38761.0 | 38720.6 | 38745.3 | 1141.0 |
| 2021-09-12 23:00:00 | YM | Futures | 38746.4 | 38783.4 | 38741.9 | 38745.3 | 1309.0 |
| 2021-09-12 18:00:00 | CL | Futures | 48.18 | 48.47 | 48.02 | 48.35 | 4932.0 |
| 2021-09-12 19:00:00 | CL | Futures | 48.35 | 48.46 | 48.33 | 48.43 | 2081.0 |
| 2021-09-12 20:00:00 | CL | Futures | 48.42 | 48.58 | 48.42 | 48.49 | 3702.0 |
| 2021-09-12 21:00:00 | CL | Futures | 48.49 | 48.6 | 48.47 | 48.5 | 4886.0 |
| 2021-09-12 22:00:00 | CL | Futures | 48.5 | 48.51 | 48.36 | 48.45 | 3139.0 |
| 2021-09-12 23:00:00 | CL | Futures | 48.45 | 48.49 | 48.33 | 48.33 | 2209.0 |
| 2021-09-12 18:00:00 | GC | Futures | 2154.5 | 2155.4 | 2153.0 | 2154.7 | 1299.0 |
| 2021-09-12 19:00:00 | GC | Futures | 2154.7 | 2154.8 | 2153.0 | 2153.3 | 981.0 |
| 2021-09-12 20:00:00 | GC | Futures | 2153.5 | 2153.7 | 2151.7 | 2153.1 | 2606.0 |
| 2021-09-12 21:00:00 | GC | Futures | 2153.2 | 2156.6 | 2148.0 | 2154.4 | 5979.0 |
| 2021-09-12 22:00:00 | GC | Futures | 2154.4 | 2156.8 | 2153.9 | 2156.5 | 2624.0 |
| 2021-09-12 23:00:00 | GC | Futures | 2156.6 | 2159.6 | 2156.3 | 2159.4 | 1675.0 |
| 2021-09-12 18:00:00 | ZN | Futures | 136.022035 | 136.053961 | 136.022035 | 136.053961 | 5851.0 |
| 2021-09-12 19:00:00 | ZN | Futures | 136.053961 | 136.053961 | 136.037998 | 136.053961 | 1252.0 |
| 2021-09-12 20:00:00 | ZN | Futures | 136.053961 | 136.053961 | 135.974145 | 136.053961 | 17152.0 |
| 2021-09-12 21:00:00 | ZN | Futures | 136.053961 | 136.069924 | 136.037998 | 136.069924 | 12569.0 |
| 2021-09-12 22:00:00 | ZN | Futures | 136.069924 | 136.101851 | 136.053961 | 136.101851 | 8377.0 |
| 2021-09-12 23:00:00 | ZN | Futures | 136.085887 | 136.101851 | 136.069924 | 136.085887 | 6582.0 |
> showing 36 of 381 rows — these rows as CSV