PREVIEW / futures_1hour / 2021-01-24
file: by_date/futures_1hour/2021/2021-01-24.parquet size: 17 KB rows: 388
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-01-24 18:00:00 | ES | Futures | 4305.98 | 4315.81 | 4304.3 | 4312.72 | 10291.0 |
| 2021-01-24 19:00:00 | ES | Futures | 4312.44 | 4319.46 | 4308.51 | 4318.33 | 11802.0 |
| 2021-01-24 20:00:00 | ES | Futures | 4318.33 | 4320.02 | 4316.37 | 4317.21 | 6897.0 |
| 2021-01-24 21:00:00 | ES | Futures | 4317.21 | 4324.23 | 4317.21 | 4323.67 | 8906.0 |
| 2021-01-24 22:00:00 | ES | Futures | 4323.67 | 4323.95 | 4321.14 | 4321.14 | 5120.0 |
| 2021-01-24 23:00:00 | ES | Futures | 4321.42 | 4322.54 | 4320.58 | 4321.42 | 3509.0 |
| 2021-01-24 18:00:00 | NQ | Futures | 15478.92 | 15523.49 | 15477.47 | 15511.62 | 5076.0 |
| 2021-01-24 19:00:00 | NQ | Futures | 15511.62 | 15562.85 | 15500.91 | 15556.77 | 7257.0 |
| 2021-01-24 20:00:00 | NQ | Futures | 15556.77 | 15568.35 | 15547.22 | 15558.22 | 3601.0 |
| 2021-01-24 21:00:00 | NQ | Futures | 15559.09 | 15584.85 | 15557.64 | 15582.53 | 3795.0 |
| 2021-01-24 22:00:00 | NQ | Futures | 15583.4 | 15588.03 | 15575.01 | 15577.03 | 2167.0 |
| 2021-01-24 23:00:00 | NQ | Futures | 15577.03 | 15584.56 | 15577.03 | 15580.8 | 1489.0 |
| 2021-01-24 18:00:00 | YM | Futures | 34296.3 | 34370.6 | 34288.5 | 34341.8 | 1760.0 |
| 2021-01-24 19:00:00 | YM | Futures | 34341.8 | 34377.3 | 34306.3 | 34365.1 | 2320.0 |
| 2021-01-24 20:00:00 | YM | Futures | 34366.2 | 34377.3 | 34341.8 | 34347.3 | 1428.0 |
| 2021-01-24 21:00:00 | YM | Futures | 34348.4 | 34401.7 | 34347.3 | 34392.8 | 1544.0 |
| 2021-01-24 22:00:00 | YM | Futures | 34393.9 | 34396.1 | 34371.7 | 34374.0 | 1030.0 |
| 2021-01-24 23:00:00 | YM | Futures | 34374.0 | 34382.8 | 34367.3 | 34371.7 | 778.0 |
| 2021-01-24 18:00:00 | CL | Futures | 35.31 | 35.43 | 35.22 | 35.4 | 4214.0 |
| 2021-01-24 19:00:00 | CL | Futures | 35.39 | 35.43 | 35.32 | 35.42 | 2597.0 |
| 2021-01-24 20:00:00 | CL | Futures | 35.43 | 35.48 | 35.3 | 35.32 | 5168.0 |
| 2021-01-24 21:00:00 | CL | Futures | 35.33 | 35.42 | 35.28 | 35.33 | 4002.0 |
| 2021-01-24 22:00:00 | CL | Futures | 35.34 | 35.36 | 35.3 | 35.3 | 1440.0 |
| 2021-01-24 23:00:00 | CL | Futures | 35.31 | 35.38 | 35.31 | 35.36 | 1246.0 |
| 2021-01-24 18:00:00 | GC | Futures | 2248.6 | 2252.5 | 2245.9 | 2249.5 | 2385.0 |
| 2021-01-24 19:00:00 | GC | Futures | 2249.8 | 2253.7 | 2247.9 | 2251.6 | 2663.0 |
| 2021-01-24 20:00:00 | GC | Futures | 2251.5 | 2253.8 | 2245.0 | 2247.5 | 6939.0 |
| 2021-01-24 21:00:00 | GC | Futures | 2247.6 | 2248.9 | 2245.9 | 2246.7 | 3456.0 |
| 2021-01-24 22:00:00 | GC | Futures | 2246.9 | 2248.2 | 2245.5 | 2246.1 | 1811.0 |
| 2021-01-24 23:00:00 | GC | Futures | 2246.1 | 2247.4 | 2245.7 | 2246.7 | 1016.0 |
| 2021-01-24 18:00:00 | ZN | Futures | 137.288917 | 137.304572 | 137.2263 | 137.2263 | 14311.0 |
| 2021-01-24 19:00:00 | ZN | Futures | 137.241954 | 137.257609 | 137.210645 | 137.241954 | 10568.0 |
| 2021-01-24 20:00:00 | ZN | Futures | 137.2263 | 137.257609 | 137.2263 | 137.257609 | 4447.0 |
| 2021-01-24 21:00:00 | ZN | Futures | 137.257609 | 137.257609 | 137.194991 | 137.210645 | 9159.0 |
| 2021-01-24 22:00:00 | ZN | Futures | 137.210645 | 137.257609 | 137.210645 | 137.241954 | 4848.0 |
| 2021-01-24 23:00:00 | ZN | Futures | 137.257609 | 137.257609 | 137.2263 | 137.2263 | 1288.0 |
> showing 36 of 388 rows — these rows as CSV