PREVIEW / futures_1hour / 2024-03-07
file: by_date/futures_1hour/2024/2024-03-07.parquet size: 66 KB rows: 2,041
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-03-07 00:00:00 | ES | Futures | 5480.59 | 5484.08 | 5479.79 | 5481.4 | 6902.0 |
| 2024-03-07 01:00:00 | ES | Futures | 5481.13 | 5484.89 | 5477.1 | 5477.64 | 7311.0 |
| 2024-03-07 02:00:00 | ES | Futures | 5477.64 | 5478.71 | 5471.46 | 5472.0 | 11726.0 |
| 2024-03-07 03:00:00 | ES | Futures | 5472.0 | 5478.98 | 5464.74 | 5478.44 | 23570.0 |
| 2024-03-07 04:00:00 | ES | Futures | 5478.44 | 5493.21 | 5476.83 | 5492.14 | 22721.0 |
| 2024-03-07 05:00:00 | ES | Futures | 5492.14 | 5504.5 | 5492.14 | 5503.96 | 21095.0 |
| 2024-03-07 06:00:00 | ES | Futures | 5503.96 | 5505.03 | 5499.93 | 5502.08 | 12091.0 |
| 2024-03-07 07:00:00 | ES | Futures | 5502.08 | 5509.06 | 5501.81 | 5504.76 | 17729.0 |
| 2024-03-07 08:00:00 | ES | Futures | 5504.5 | 5518.19 | 5501.54 | 5514.43 | 42315.0 |
| 2024-03-07 09:00:00 | ES | Futures | 5514.43 | 5530.82 | 5512.82 | 5528.4 | 244291.0 |
| 2024-03-07 10:00:00 | ES | Futures | 5528.13 | 5543.98 | 5523.57 | 5538.61 | 227775.0 |
| 2024-03-07 11:00:00 | ES | Futures | 5538.34 | 5542.64 | 5531.62 | 5541.56 | 146830.0 |
| 2024-03-07 12:00:00 | ES | Futures | 5541.56 | 5545.05 | 5534.85 | 5540.76 | 116114.0 |
| 2024-03-07 13:00:00 | ES | Futures | 5540.49 | 5554.99 | 5537.0 | 5553.11 | 124027.0 |
| 2024-03-07 14:00:00 | ES | Futures | 5553.11 | 5554.72 | 5542.64 | 5544.25 | 134944.0 |
| 2024-03-07 15:00:00 | ES | Futures | 5544.25 | 5552.04 | 5535.12 | 5543.44 | 273023.0 |
| 2024-03-07 16:00:00 | ES | Futures | 5543.17 | 5543.71 | 5526.25 | 5540.76 | 94681.0 |
| 2024-03-07 18:00:00 | ES | Futures | 5542.9 | 5546.13 | 5541.02 | 5543.44 | 9273.0 |
| 2024-03-07 19:00:00 | ES | Futures | 5543.17 | 5545.86 | 5539.14 | 5543.98 | 6930.0 |
| 2024-03-07 20:00:00 | ES | Futures | 5543.71 | 5545.32 | 5541.29 | 5544.25 | 5720.0 |
| 2024-03-07 21:00:00 | ES | Futures | 5544.25 | 5544.25 | 5541.56 | 5542.1 | 2826.0 |
| 2024-03-07 22:00:00 | ES | Futures | 5542.1 | 5546.93 | 5541.02 | 5546.13 | 4827.0 |
| 2024-03-07 23:00:00 | ES | Futures | 5546.4 | 5551.5 | 5546.13 | 5546.66 | 6392.0 |
| 2024-03-07 00:00:00 | NQ | Futures | 19498.06 | 19517.31 | 19496.97 | 19504.02 | 3998.0 |
| 2024-03-07 01:00:00 | NQ | Futures | 19503.48 | 19518.13 | 19475.55 | 19483.95 | 5145.0 |
| 2024-03-07 02:00:00 | NQ | Futures | 19483.14 | 19489.11 | 19458.19 | 19472.02 | 7700.0 |
| 2024-03-07 03:00:00 | NQ | Futures | 19472.29 | 19508.63 | 19435.41 | 19502.12 | 12610.0 |
| 2024-03-07 04:00:00 | NQ | Futures | 19502.4 | 19609.79 | 19498.6 | 19602.47 | 16722.0 |
| 2024-03-07 05:00:00 | NQ | Futures | 19602.47 | 19658.61 | 19602.47 | 19655.63 | 11572.0 |
| 2024-03-07 06:00:00 | NQ | Futures | 19655.08 | 19662.95 | 19629.05 | 19645.86 | 10108.0 |
| 2024-03-07 07:00:00 | NQ | Futures | 19647.22 | 19675.7 | 19639.9 | 19656.71 | 9610.0 |
| 2024-03-07 08:00:00 | NQ | Futures | 19656.71 | 19702.27 | 19640.98 | 19692.24 | 23603.0 |
| 2024-03-07 09:00:00 | NQ | Futures | 19691.7 | 19771.7 | 19655.63 | 19735.9 | 132799.0 |
| 2024-03-07 10:00:00 | NQ | Futures | 19735.36 | 19833.27 | 19715.83 | 19798.55 | 113630.0 |
| 2024-03-07 11:00:00 | NQ | Futures | 19798.82 | 19859.84 | 19788.79 | 19853.88 | 67606.0 |
| 2024-03-07 12:00:00 | NQ | Futures | 19853.61 | 19883.98 | 19837.33 | 19862.29 | 55204.0 |
| 2024-03-07 13:00:00 | NQ | Futures | 19862.56 | 19917.34 | 19842.76 | 19910.29 | 47628.0 |
| 2024-03-07 14:00:00 | NQ | Futures | 19910.29 | 19915.71 | 19875.85 | 19881.27 | 45542.0 |
| 2024-03-07 15:00:00 | NQ | Futures | 19881.54 | 19895.64 | 19839.78 | 19862.29 | 92220.0 |
| 2024-03-07 16:00:00 | NQ | Futures | 19861.74 | 19866.08 | 19699.29 | 19802.35 | 46596.0 |
| 2024-03-07 18:00:00 | NQ | Futures | 19829.47 | 19841.4 | 19804.79 | 19815.37 | 6273.0 |
| 2024-03-07 19:00:00 | NQ | Futures | 19815.91 | 19828.93 | 19796.11 | 19816.72 | 4571.0 |
| 2024-03-07 20:00:00 | NQ | Futures | 19816.45 | 19827.57 | 19806.15 | 19823.23 | 3076.0 |
| 2024-03-07 21:00:00 | NQ | Futures | 19822.69 | 19823.77 | 19810.76 | 19815.1 | 2001.0 |
| 2024-03-07 22:00:00 | NQ | Futures | 19814.55 | 19843.84 | 19810.21 | 19837.61 | 3664.0 |
| 2024-03-07 23:00:00 | NQ | Futures | 19838.69 | 19863.1 | 19830.01 | 19833.81 | 5187.0 |
| 2024-03-07 00:00:00 | YM | Futures | 41523.8 | 41545.3 | 41515.2 | 41523.8 | 807.0 |
| 2024-03-07 01:00:00 | YM | Futures | 41523.8 | 41548.5 | 41503.4 | 41506.7 | 574.0 |
| 2024-03-07 02:00:00 | YM | Futures | 41506.7 | 41509.9 | 41449.7 | 41449.7 | 1807.0 |
| 2024-03-07 03:00:00 | YM | Futures | 41449.7 | 41488.4 | 41403.5 | 41482.0 | 3278.0 |
> showing 50 of 2,041 rows — these rows as CSV