PREVIEW / futures_1hour / 2021-11-28
file: by_date/futures_1hour/2021/2021-11-28.parquet size: 20 KB rows: 434
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-11-28 18:00:00 | ES | Futures | 5180.29 | 5227.98 | 5180.01 | 5221.21 | 64616.0 |
| 2021-11-28 19:00:00 | ES | Futures | 5221.21 | 5233.63 | 5217.83 | 5227.7 | 37108.0 |
| 2021-11-28 20:00:00 | ES | Futures | 5227.98 | 5237.58 | 5220.93 | 5235.6 | 22488.0 |
| 2021-11-28 21:00:00 | ES | Futures | 5235.6 | 5240.97 | 5232.78 | 5236.17 | 19889.0 |
| 2021-11-28 22:00:00 | ES | Futures | 5236.17 | 5238.99 | 5231.37 | 5235.04 | 9398.0 |
| 2021-11-28 23:00:00 | ES | Futures | 5235.04 | 5238.99 | 5224.88 | 5227.7 | 11179.0 |
| 2021-11-28 18:00:00 | NQ | Futures | 18602.2 | 18755.23 | 18592.35 | 18744.21 | 21650.0 |
| 2021-11-28 19:00:00 | NQ | Futures | 18744.79 | 18809.42 | 18742.77 | 18786.24 | 12031.0 |
| 2021-11-28 20:00:00 | NQ | Futures | 18786.24 | 18830.58 | 18772.62 | 18821.02 | 8257.0 |
| 2021-11-28 21:00:00 | NQ | Futures | 18822.18 | 18839.27 | 18806.52 | 18820.44 | 7250.0 |
| 2021-11-28 22:00:00 | NQ | Futures | 18821.02 | 18836.09 | 18809.13 | 18823.62 | 3724.0 |
| 2021-11-28 23:00:00 | NQ | Futures | 18823.91 | 18838.11 | 18800.15 | 18804.79 | 4314.0 |
| 2021-11-28 18:00:00 | YM | Futures | 38941.4 | 39328.2 | 38940.3 | 39255.3 | 14433.0 |
| 2021-11-28 19:00:00 | YM | Futures | 39254.2 | 39322.6 | 39200.4 | 39290.0 | 6183.0 |
| 2021-11-28 20:00:00 | YM | Futures | 39292.3 | 39349.5 | 39220.6 | 39325.9 | 5207.0 |
| 2021-11-28 21:00:00 | YM | Futures | 39329.3 | 39386.4 | 39316.9 | 39346.1 | 3250.0 |
| 2021-11-28 22:00:00 | YM | Futures | 39345.0 | 39368.5 | 39308.0 | 39339.4 | 1816.0 |
| 2021-11-28 23:00:00 | YM | Futures | 39339.4 | 39370.8 | 39245.2 | 39259.8 | 2160.0 |
| 2021-11-28 18:00:00 | CL | Futures | 49.05 | 50.82 | 49.05 | 50.58 | 33021.0 |
| 2021-11-28 19:00:00 | CL | Futures | 50.57 | 51.12 | 50.18 | 51.1 | 16177.0 |
| 2021-11-28 20:00:00 | CL | Futures | 51.1 | 51.13 | 50.12 | 50.78 | 18926.0 |
| 2021-11-28 21:00:00 | CL | Futures | 50.78 | 51.02 | 50.58 | 50.83 | 11385.0 |
| 2021-11-28 22:00:00 | CL | Futures | 50.82 | 50.99 | 50.73 | 50.82 | 7272.0 |
| 2021-11-28 23:00:00 | CL | Futures | 50.8 | 50.82 | 50.31 | 50.37 | 8807.0 |
| 2021-11-28 18:00:00 | GC | Futures | 2158.0 | 2161.3 | 2142.8 | 2161.0 | 5371.0 |
| 2021-11-28 19:00:00 | GC | Futures | 2161.0 | 2161.8 | 2154.5 | 2158.4 | 3957.0 |
| 2021-11-28 20:00:00 | GC | Futures | 2158.6 | 2161.2 | 2154.1 | 2160.4 | 3580.0 |
| 2021-11-28 21:00:00 | GC | Futures | 2160.3 | 2160.6 | 2156.6 | 2160.3 | 3191.0 |
| 2021-11-28 22:00:00 | GC | Futures | 2160.1 | 2161.8 | 2158.4 | 2159.1 | 2039.0 |
| 2021-11-28 23:00:00 | GC | Futures | 2159.1 | 2159.2 | 2155.0 | 2157.5 | 2029.0 |
| 2021-11-28 18:00:00 | ZN | Futures | 133.803156 | 133.898935 | 133.46793 | 133.659488 | 29473.0 |
| 2021-11-28 19:00:00 | ZN | Futures | 133.659488 | 133.707378 | 133.579672 | 133.611599 | 10104.0 |
| 2021-11-28 20:00:00 | ZN | Futures | 133.611599 | 133.675451 | 133.579672 | 133.595635 | 11872.0 |
| 2021-11-28 21:00:00 | ZN | Futures | 133.595635 | 133.595635 | 133.483893 | 133.595635 | 13639.0 |
| 2021-11-28 22:00:00 | ZN | Futures | 133.579672 | 133.627562 | 133.531783 | 133.595635 | 8742.0 |
| 2021-11-28 23:00:00 | ZN | Futures | 133.595635 | 133.643525 | 133.547746 | 133.627562 | 5157.0 |
> showing 36 of 434 rows — these rows as CSV