PREVIEW / futures_1hour / 2023-11-15
file: by_date/futures_1hour/2023/2023-11-15.parquet size: 69 KB rows: 2,114
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 |
|---|---|---|---|---|---|---|---|
| 2023-11-15 00:00:00 | ES | Futures | 4910.59 | 4915.48 | 4910.32 | 4913.31 | 7941.0 |
| 2023-11-15 01:00:00 | ES | Futures | 4913.03 | 4916.29 | 4911.68 | 4914.12 | 8974.0 |
| 2023-11-15 02:00:00 | ES | Futures | 4914.12 | 4915.21 | 4908.15 | 4909.23 | 14108.0 |
| 2023-11-15 03:00:00 | ES | Futures | 4909.23 | 4920.09 | 4908.96 | 4919.28 | 25693.0 |
| 2023-11-15 04:00:00 | ES | Futures | 4919.28 | 4919.82 | 4908.42 | 4910.59 | 19690.0 |
| 2023-11-15 05:00:00 | ES | Futures | 4910.32 | 4919.82 | 4909.5 | 4918.47 | 16670.0 |
| 2023-11-15 06:00:00 | ES | Futures | 4918.47 | 4921.45 | 4914.12 | 4920.91 | 16391.0 |
| 2023-11-15 07:00:00 | ES | Futures | 4920.91 | 4924.71 | 4917.92 | 4923.9 | 23559.0 |
| 2023-11-15 08:00:00 | ES | Futures | 4923.62 | 4932.86 | 4909.23 | 4916.02 | 86413.0 |
| 2023-11-15 09:00:00 | ES | Futures | 4916.29 | 4921.18 | 4906.24 | 4911.68 | 207942.0 |
| 2023-11-15 10:00:00 | ES | Futures | 4911.95 | 4927.97 | 4910.05 | 4924.71 | 185388.0 |
| 2023-11-15 11:00:00 | ES | Futures | 4924.98 | 4927.97 | 4908.96 | 4911.13 | 178310.0 |
| 2023-11-15 12:00:00 | ES | Futures | 4911.13 | 4916.84 | 4907.87 | 4910.05 | 113868.0 |
| 2023-11-15 13:00:00 | ES | Futures | 4910.05 | 4916.02 | 4899.73 | 4915.48 | 148912.0 |
| 2023-11-15 14:00:00 | ES | Futures | 4915.48 | 4920.09 | 4908.42 | 4915.48 | 113449.0 |
| 2023-11-15 15:00:00 | ES | Futures | 4915.21 | 4917.11 | 4904.07 | 4909.23 | 231448.0 |
| 2023-11-15 16:00:00 | ES | Futures | 4909.23 | 4909.23 | 4901.09 | 4903.26 | 65489.0 |
| 2023-11-15 18:00:00 | ES | Futures | 4903.53 | 4906.24 | 4902.44 | 4905.97 | 5329.0 |
| 2023-11-15 19:00:00 | ES | Futures | 4905.97 | 4909.78 | 4905.16 | 4908.15 | 7818.0 |
| 2023-11-15 20:00:00 | ES | Futures | 4908.15 | 4908.42 | 4898.1 | 4898.37 | 11689.0 |
| 2023-11-15 21:00:00 | ES | Futures | 4898.64 | 4901.36 | 4895.65 | 4897.83 | 12876.0 |
| 2023-11-15 22:00:00 | ES | Futures | 4897.83 | 4900.81 | 4897.28 | 4897.83 | 5280.0 |
| 2023-11-15 23:00:00 | ES | Futures | 4898.1 | 4902.44 | 4897.83 | 4901.63 | 5006.0 |
| 2023-11-15 00:00:00 | NQ | Futures | 17492.26 | 17510.39 | 17488.97 | 17498.58 | 4709.0 |
| 2023-11-15 01:00:00 | NQ | Futures | 17498.31 | 17512.59 | 17491.44 | 17502.43 | 5013.0 |
| 2023-11-15 02:00:00 | NQ | Futures | 17502.43 | 17505.45 | 17482.38 | 17488.69 | 6424.0 |
| 2023-11-15 03:00:00 | NQ | Futures | 17488.69 | 17540.6 | 17486.22 | 17534.56 | 13172.0 |
| 2023-11-15 04:00:00 | NQ | Futures | 17534.84 | 17535.11 | 17496.38 | 17504.35 | 10385.0 |
| 2023-11-15 05:00:00 | NQ | Futures | 17504.62 | 17546.1 | 17501.33 | 17540.06 | 8715.0 |
| 2023-11-15 06:00:00 | NQ | Futures | 17540.33 | 17552.42 | 17527.42 | 17549.94 | 8157.0 |
| 2023-11-15 07:00:00 | NQ | Futures | 17549.39 | 17567.52 | 17541.15 | 17565.87 | 12923.0 |
| 2023-11-15 08:00:00 | NQ | Futures | 17566.42 | 17632.89 | 17509.57 | 17540.06 | 43167.0 |
| 2023-11-15 09:00:00 | NQ | Futures | 17540.33 | 17549.39 | 17475.23 | 17488.42 | 93610.0 |
| 2023-11-15 10:00:00 | NQ | Futures | 17488.14 | 17553.51 | 17478.53 | 17535.11 | 96305.0 |
| 2023-11-15 11:00:00 | NQ | Futures | 17535.39 | 17545.27 | 17460.68 | 17467.27 | 78910.0 |
| 2023-11-15 12:00:00 | NQ | Futures | 17467.54 | 17487.32 | 17451.06 | 17458.75 | 53297.0 |
| 2023-11-15 13:00:00 | NQ | Futures | 17458.75 | 17477.71 | 17394.48 | 17477.71 | 69978.0 |
| 2023-11-15 14:00:00 | NQ | Futures | 17477.71 | 17500.23 | 17443.92 | 17479.63 | 58887.0 |
| 2023-11-15 15:00:00 | NQ | Futures | 17480.18 | 17483.75 | 17438.98 | 17458.21 | 67255.0 |
| 2023-11-15 16:00:00 | NQ | Futures | 17457.93 | 17459.85 | 17394.21 | 17408.49 | 21611.0 |
| 2023-11-15 18:00:00 | NQ | Futures | 17410.14 | 17430.74 | 17407.67 | 17429.91 | 3832.0 |
| 2023-11-15 19:00:00 | NQ | Futures | 17429.91 | 17447.77 | 17427.99 | 17440.9 | 4721.0 |
| 2023-11-15 20:00:00 | NQ | Futures | 17440.35 | 17440.35 | 17395.31 | 17395.58 | 7265.0 |
| 2023-11-15 21:00:00 | NQ | Futures | 17396.13 | 17413.71 | 17385.14 | 17394.21 | 8373.0 |
| 2023-11-15 22:00:00 | NQ | Futures | 17394.21 | 17410.14 | 17393.66 | 17399.7 | 3266.0 |
| 2023-11-15 23:00:00 | NQ | Futures | 17399.98 | 17415.91 | 17397.23 | 17414.53 | 2753.0 |
| 2023-11-15 00:00:00 | YM | Futures | 37900.5 | 37930.9 | 37898.3 | 37919.0 | 1249.0 |
| 2023-11-15 01:00:00 | YM | Futures | 37919.0 | 37943.9 | 37908.1 | 37929.8 | 1399.0 |
| 2023-11-15 02:00:00 | YM | Futures | 37930.9 | 37937.4 | 37890.8 | 37899.4 | 2385.0 |
| 2023-11-15 03:00:00 | YM | Futures | 37899.4 | 37966.7 | 37895.1 | 37963.4 | 4064.0 |
> showing 50 of 2,114 rows — these rows as CSV