PREVIEW / futures_1hour / 2021-03-21
file: by_date/futures_1hour/2021/2021-03-21.parquet size: 18 KB rows: 380
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-03-21 18:00:00 | ES | Futures | 4375.82 | 4376.94 | 4367.95 | 4375.82 | 13876.0 |
| 2021-03-21 19:00:00 | ES | Futures | 4376.1 | 4381.72 | 4375.82 | 4378.91 | 9130.0 |
| 2021-03-21 20:00:00 | ES | Futures | 4379.19 | 4380.31 | 4373.57 | 4373.85 | 11231.0 |
| 2021-03-21 21:00:00 | ES | Futures | 4373.85 | 4383.68 | 4366.26 | 4382.0 | 19247.0 |
| 2021-03-21 22:00:00 | ES | Futures | 4382.28 | 4382.56 | 4374.69 | 4380.31 | 10788.0 |
| 2021-03-21 23:00:00 | ES | Futures | 4380.31 | 4382.28 | 4378.06 | 4380.03 | 5693.0 |
| 2021-03-21 18:00:00 | NQ | Futures | 14830.26 | 14875.14 | 14808.84 | 14869.64 | 7768.0 |
| 2021-03-21 19:00:00 | NQ | Futures | 14870.5 | 14903.8 | 14865.58 | 14893.95 | 4908.0 |
| 2021-03-21 20:00:00 | NQ | Futures | 14894.24 | 14902.64 | 14877.45 | 14882.08 | 5791.0 |
| 2021-03-21 21:00:00 | NQ | Futures | 14881.79 | 14955.33 | 14844.74 | 14940.85 | 11919.0 |
| 2021-03-21 22:00:00 | NQ | Futures | 14940.27 | 14953.88 | 14915.38 | 14948.38 | 7206.0 |
| 2021-03-21 23:00:00 | NQ | Futures | 14947.51 | 14950.69 | 14931.3 | 14938.83 | 3249.0 |
| 2021-03-21 18:00:00 | YM | Futures | 36162.3 | 36173.5 | 36110.0 | 36150.1 | 2207.0 |
| 2021-03-21 19:00:00 | YM | Futures | 36151.2 | 36194.6 | 36146.7 | 36162.3 | 1763.0 |
| 2021-03-21 20:00:00 | YM | Futures | 36164.6 | 36170.1 | 36106.6 | 36110.0 | 1770.0 |
| 2021-03-21 21:00:00 | YM | Futures | 36111.1 | 36166.8 | 36054.3 | 36152.3 | 3933.0 |
| 2021-03-21 22:00:00 | YM | Futures | 36152.3 | 36154.5 | 36081.0 | 36122.2 | 2307.0 |
| 2021-03-21 23:00:00 | YM | Futures | 36122.2 | 36144.5 | 36107.8 | 36114.4 | 1092.0 |
| 2021-03-21 18:00:00 | CL | Futures | 41.78 | 41.84 | 41.35 | 41.41 | 4618.0 |
| 2021-03-21 19:00:00 | CL | Futures | 41.41 | 41.47 | 41.28 | 41.32 | 2578.0 |
| 2021-03-21 20:00:00 | CL | Futures | 41.31 | 41.32 | 41.11 | 41.17 | 5778.0 |
| 2021-03-21 21:00:00 | CL | Futures | 41.18 | 41.44 | 41.11 | 41.4 | 6479.0 |
| 2021-03-21 22:00:00 | CL | Futures | 41.41 | 41.63 | 41.31 | 41.6 | 8263.0 |
| 2021-03-21 23:00:00 | CL | Futures | 41.6 | 41.63 | 41.41 | 41.44 | 3657.0 |
| 2021-03-21 18:00:00 | GC | Futures | 2111.4 | 2113.1 | 2101.2 | 2101.4 | 4413.0 |
| 2021-03-21 19:00:00 | GC | Futures | 2101.2 | 2104.8 | 2101.2 | 2101.6 | 1800.0 |
| 2021-03-21 20:00:00 | GC | Futures | 2101.6 | 2105.0 | 2099.8 | 2103.0 | 3953.0 |
| 2021-03-21 21:00:00 | GC | Futures | 2103.1 | 2103.1 | 2094.4 | 2097.5 | 9890.0 |
| 2021-03-21 22:00:00 | GC | Futures | 2097.5 | 2101.5 | 2097.3 | 2101.3 | 3694.0 |
| 2021-03-21 23:00:00 | GC | Futures | 2101.4 | 2104.5 | 2100.7 | 2103.7 | 3374.0 |
| 2021-03-21 18:00:00 | ZN | Futures | 132.633088 | 132.68044 | 132.554168 | 132.648872 | 21488.0 |
| 2021-03-21 19:00:00 | ZN | Futures | 132.648872 | 132.712009 | 132.633088 | 132.712009 | 9807.0 |
| 2021-03-21 20:00:00 | ZN | Futures | 132.696225 | 132.806713 | 132.68044 | 132.775145 | 24751.0 |
| 2021-03-21 21:00:00 | ZN | Futures | 132.775145 | 132.869849 | 132.759361 | 132.854065 | 32603.0 |
| 2021-03-21 22:00:00 | ZN | Futures | 132.838281 | 132.885633 | 132.822497 | 132.854065 | 23589.0 |
| 2021-03-21 23:00:00 | ZN | Futures | 132.854065 | 132.917201 | 132.838281 | 132.901417 | 9588.0 |
> showing 36 of 380 rows — these rows as CSV