PREVIEW / futures_1hour / 2024-05-14
file: by_date/futures_1hour/2024/2024-05-14.parquet size: 66 KB rows: 2,081
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 |
|---|---|---|---|---|---|---|---|
| 2024-05-14 00:00:00 | ES | Futures | 5562.19 | 5564.05 | 5561.66 | 5562.99 | 2559.0 |
| 2024-05-14 01:00:00 | ES | Futures | 5563.25 | 5566.7 | 5562.99 | 5566.17 | 4020.0 |
| 2024-05-14 02:00:00 | ES | Futures | 5566.17 | 5567.23 | 5565.11 | 5565.9 | 4363.0 |
| 2024-05-14 03:00:00 | ES | Futures | 5566.17 | 5567.76 | 5564.31 | 5566.97 | 6501.0 |
| 2024-05-14 04:00:00 | ES | Futures | 5566.97 | 5569.09 | 5565.9 | 5568.56 | 5320.0 |
| 2024-05-14 05:00:00 | ES | Futures | 5568.29 | 5569.62 | 5565.9 | 5568.82 | 5911.0 |
| 2024-05-14 06:00:00 | ES | Futures | 5568.82 | 5569.35 | 5566.43 | 5569.09 | 7569.0 |
| 2024-05-14 07:00:00 | ES | Futures | 5569.09 | 5569.62 | 5566.43 | 5567.76 | 9228.0 |
| 2024-05-14 08:00:00 | ES | Futures | 5567.76 | 5571.21 | 5535.93 | 5565.11 | 105651.0 |
| 2024-05-14 09:00:00 | ES | Futures | 5564.84 | 5574.13 | 5560.86 | 5569.62 | 146773.0 |
| 2024-05-14 10:00:00 | ES | Futures | 5569.62 | 5581.82 | 5562.99 | 5574.92 | 249808.0 |
| 2024-05-14 11:00:00 | ES | Futures | 5574.66 | 5578.9 | 5566.17 | 5567.5 | 116591.0 |
| 2024-05-14 12:00:00 | ES | Futures | 5567.5 | 5569.88 | 5563.25 | 5566.43 | 68207.0 |
| 2024-05-14 13:00:00 | ES | Futures | 5566.43 | 5571.74 | 5561.92 | 5569.62 | 70905.0 |
| 2024-05-14 14:00:00 | ES | Futures | 5569.88 | 5594.03 | 5569.09 | 5590.84 | 143603.0 |
| 2024-05-14 15:00:00 | ES | Futures | 5591.11 | 5596.94 | 5587.92 | 5590.84 | 177654.0 |
| 2024-05-14 16:00:00 | ES | Futures | 5591.11 | 5592.43 | 5588.98 | 5591.37 | 46535.0 |
| 2024-05-14 18:00:00 | ES | Futures | 5590.84 | 5596.41 | 5588.45 | 5595.88 | 5665.0 |
| 2024-05-14 19:00:00 | ES | Futures | 5595.88 | 5596.15 | 5593.76 | 5594.03 | 2729.0 |
| 2024-05-14 20:00:00 | ES | Futures | 5594.03 | 5596.15 | 5591.37 | 5593.76 | 5322.0 |
| 2024-05-14 21:00:00 | ES | Futures | 5593.76 | 5597.21 | 5592.96 | 5596.68 | 4061.0 |
| 2024-05-14 22:00:00 | ES | Futures | 5596.68 | 5600.39 | 5596.41 | 5598.27 | 4073.0 |
| 2024-05-14 23:00:00 | ES | Futures | 5598.27 | 5599.86 | 5598.0 | 5598.0 | 2320.0 |
| 2024-05-14 00:00:00 | NQ | Futures | 19544.91 | 19554.54 | 19542.77 | 19549.73 | 1598.0 |
| 2024-05-14 01:00:00 | NQ | Futures | 19548.93 | 19563.91 | 19548.93 | 19562.57 | 2542.0 |
| 2024-05-14 02:00:00 | NQ | Futures | 19562.3 | 19572.2 | 19559.89 | 19570.33 | 2285.0 |
| 2024-05-14 03:00:00 | NQ | Futures | 19570.33 | 19578.89 | 19563.37 | 19570.06 | 4583.0 |
| 2024-05-14 04:00:00 | NQ | Futures | 19569.79 | 19590.39 | 19566.05 | 19587.45 | 3906.0 |
| 2024-05-14 05:00:00 | NQ | Futures | 19587.45 | 19590.66 | 19569.52 | 19582.36 | 3891.0 |
| 2024-05-14 06:00:00 | NQ | Futures | 19582.36 | 19585.84 | 19570.59 | 19583.97 | 4593.0 |
| 2024-05-14 07:00:00 | NQ | Futures | 19583.97 | 19585.31 | 19559.89 | 19566.85 | 5383.0 |
| 2024-05-14 08:00:00 | NQ | Futures | 19566.85 | 19585.57 | 19437.38 | 19540.37 | 42304.0 |
| 2024-05-14 09:00:00 | NQ | Futures | 19540.1 | 19609.92 | 19528.33 | 19570.59 | 87014.0 |
| 2024-05-14 10:00:00 | NQ | Futures | 19570.06 | 19657.0 | 19553.74 | 19623.29 | 118837.0 |
| 2024-05-14 11:00:00 | NQ | Futures | 19623.03 | 19653.25 | 19586.38 | 19603.5 | 58795.0 |
| 2024-05-14 12:00:00 | NQ | Futures | 19602.96 | 19615.0 | 19579.15 | 19599.75 | 35525.0 |
| 2024-05-14 13:00:00 | NQ | Futures | 19599.75 | 19623.56 | 19579.69 | 19614.73 | 33516.0 |
| 2024-05-14 14:00:00 | NQ | Futures | 19614.73 | 19705.15 | 19611.79 | 19698.73 | 58991.0 |
| 2024-05-14 15:00:00 | NQ | Futures | 19698.73 | 19723.61 | 19685.35 | 19700.6 | 58818.0 |
| 2024-05-14 16:00:00 | NQ | Futures | 19700.07 | 19707.82 | 19690.97 | 19699.53 | 13164.0 |
| 2024-05-14 18:00:00 | NQ | Futures | 19698.73 | 19716.65 | 19690.97 | 19714.78 | 2809.0 |
| 2024-05-14 19:00:00 | NQ | Futures | 19714.24 | 19715.58 | 19704.08 | 19706.75 | 1794.0 |
| 2024-05-14 20:00:00 | NQ | Futures | 19706.49 | 19716.38 | 19688.03 | 19697.93 | 4343.0 |
| 2024-05-14 21:00:00 | NQ | Futures | 19697.66 | 19713.98 | 19697.12 | 19710.5 | 2604.0 |
| 2024-05-14 22:00:00 | NQ | Futures | 19710.77 | 19729.22 | 19708.63 | 19717.45 | 3195.0 |
| 2024-05-14 23:00:00 | NQ | Futures | 19716.92 | 19723.07 | 19713.17 | 19713.71 | 2073.0 |
| 2024-05-14 00:00:00 | YM | Futures | 41990.3 | 41995.6 | 41984.0 | 41991.4 | 525.0 |
| 2024-05-14 01:00:00 | YM | Futures | 41991.4 | 42011.6 | 41986.1 | 42008.4 | 740.0 |
| 2024-05-14 02:00:00 | YM | Futures | 42008.4 | 42011.6 | 41996.7 | 41998.8 | 873.0 |
| 2024-05-14 03:00:00 | YM | Futures | 41998.8 | 42014.7 | 41981.8 | 42011.6 | 896.0 |
> showing 50 of 2,081 rows — these rows as CSV