PREVIEW / futures_1hour / 2024-05-30
file: by_date/futures_1hour/2024/2024-05-30.parquet size: 67 KB rows: 2,073
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-30 00:00:00 | ES | Futures | 5579.96 | 5580.23 | 5575.45 | 5577.84 | 4889.0 |
| 2024-05-30 01:00:00 | ES | Futures | 5577.58 | 5577.58 | 5571.74 | 5575.19 | 9802.0 |
| 2024-05-30 02:00:00 | ES | Futures | 5575.45 | 5578.11 | 5572.01 | 5572.27 | 11146.0 |
| 2024-05-30 03:00:00 | ES | Futures | 5572.27 | 5582.09 | 5572.27 | 5580.76 | 21942.0 |
| 2024-05-30 04:00:00 | ES | Futures | 5580.76 | 5586.07 | 5578.9 | 5585.27 | 17035.0 |
| 2024-05-30 05:00:00 | ES | Futures | 5585.27 | 5586.6 | 5581.29 | 5583.15 | 10111.0 |
| 2024-05-30 06:00:00 | ES | Futures | 5583.15 | 5587.92 | 5579.96 | 5586.6 | 13035.0 |
| 2024-05-30 07:00:00 | ES | Futures | 5586.6 | 5588.19 | 5583.94 | 5585.01 | 17051.0 |
| 2024-05-30 08:00:00 | ES | Futures | 5584.74 | 5595.09 | 5583.94 | 5590.84 | 47965.0 |
| 2024-05-30 09:00:00 | ES | Futures | 5590.84 | 5596.94 | 5585.27 | 5592.7 | 174875.0 |
| 2024-05-30 10:00:00 | ES | Futures | 5592.7 | 5595.35 | 5576.25 | 5579.96 | 246031.0 |
| 2024-05-30 11:00:00 | ES | Futures | 5579.96 | 5590.58 | 5574.39 | 5583.41 | 128657.0 |
| 2024-05-30 12:00:00 | ES | Futures | 5583.41 | 5594.56 | 5583.15 | 5594.03 | 99256.0 |
| 2024-05-30 13:00:00 | ES | Futures | 5594.03 | 5599.86 | 5591.9 | 5595.09 | 83824.0 |
| 2024-05-30 14:00:00 | ES | Futures | 5595.09 | 5595.88 | 5582.62 | 5587.66 | 103272.0 |
| 2024-05-30 15:00:00 | ES | Futures | 5587.66 | 5589.52 | 5558.74 | 5572.8 | 295685.0 |
| 2024-05-30 16:00:00 | ES | Futures | 5572.8 | 5573.07 | 5563.78 | 5571.74 | 63823.0 |
| 2024-05-30 18:00:00 | ES | Futures | 5571.74 | 5572.01 | 5563.78 | 5566.43 | 8965.0 |
| 2024-05-30 19:00:00 | ES | Futures | 5566.43 | 5567.5 | 5562.46 | 5563.78 | 4467.0 |
| 2024-05-30 20:00:00 | ES | Futures | 5563.52 | 5565.9 | 5554.76 | 5560.07 | 12715.0 |
| 2024-05-30 21:00:00 | ES | Futures | 5560.07 | 5565.37 | 5559.54 | 5564.84 | 9709.0 |
| 2024-05-30 22:00:00 | ES | Futures | 5565.11 | 5566.17 | 5559.01 | 5559.54 | 5865.0 |
| 2024-05-30 23:00:00 | ES | Futures | 5559.54 | 5568.56 | 5559.54 | 5566.97 | 6938.0 |
| 2024-05-30 00:00:00 | NQ | Futures | 19994.59 | 19995.12 | 19976.93 | 19988.44 | 2902.0 |
| 2024-05-30 01:00:00 | NQ | Futures | 19987.9 | 19987.9 | 19965.43 | 19981.75 | 4449.0 |
| 2024-05-30 02:00:00 | NQ | Futures | 19982.28 | 19987.9 | 19964.09 | 19967.3 | 5642.0 |
| 2024-05-30 03:00:00 | NQ | Futures | 19966.5 | 20012.51 | 19965.43 | 20007.43 | 10692.0 |
| 2024-05-30 04:00:00 | NQ | Futures | 20007.96 | 20049.96 | 20007.16 | 20046.75 | 8499.0 |
| 2024-05-30 05:00:00 | NQ | Futures | 20047.02 | 20049.96 | 20030.43 | 20041.94 | 6121.0 |
| 2024-05-30 06:00:00 | NQ | Futures | 20041.13 | 20071.9 | 20025.35 | 20068.42 | 8528.0 |
| 2024-05-30 07:00:00 | NQ | Futures | 20069.22 | 20074.84 | 20052.64 | 20058.25 | 7652.0 |
| 2024-05-30 08:00:00 | NQ | Futures | 20057.45 | 20102.39 | 20050.5 | 20078.85 | 19563.0 |
| 2024-05-30 09:00:00 | NQ | Futures | 20079.12 | 20087.68 | 20006.09 | 20051.03 | 81206.0 |
| 2024-05-30 10:00:00 | NQ | Futures | 20050.76 | 20065.74 | 19950.99 | 19964.9 | 103407.0 |
| 2024-05-30 11:00:00 | NQ | Futures | 19964.63 | 20007.7 | 19927.71 | 19976.13 | 60206.0 |
| 2024-05-30 12:00:00 | NQ | Futures | 19976.13 | 20015.72 | 19975.33 | 20005.56 | 42471.0 |
| 2024-05-30 13:00:00 | NQ | Futures | 20005.82 | 20040.33 | 19994.86 | 20012.24 | 39716.0 |
| 2024-05-30 14:00:00 | NQ | Futures | 20012.24 | 20014.65 | 19956.6 | 19977.47 | 45071.0 |
| 2024-05-30 15:00:00 | NQ | Futures | 19977.74 | 19982.55 | 19844.79 | 19906.58 | 112475.0 |
| 2024-05-30 16:00:00 | NQ | Futures | 19906.31 | 19912.73 | 19853.35 | 19898.02 | 23110.0 |
| 2024-05-30 18:00:00 | NQ | Futures | 19892.4 | 19894.27 | 19856.82 | 19870.2 | 5362.0 |
| 2024-05-30 19:00:00 | NQ | Futures | 19869.93 | 19879.56 | 19854.15 | 19858.16 | 3812.0 |
| 2024-05-30 20:00:00 | NQ | Futures | 19857.89 | 19868.59 | 19797.97 | 19821.78 | 10145.0 |
| 2024-05-30 21:00:00 | NQ | Futures | 19821.78 | 19857.09 | 19819.64 | 19854.42 | 6099.0 |
| 2024-05-30 22:00:00 | NQ | Futures | 19854.42 | 19861.37 | 19823.92 | 19823.92 | 4036.0 |
| 2024-05-30 23:00:00 | NQ | Futures | 19823.39 | 19867.52 | 19823.39 | 19861.37 | 4180.0 |
| 2024-05-30 00:00:00 | YM | Futures | 40584.6 | 40587.8 | 40549.6 | 40562.3 | 1044.0 |
| 2024-05-30 01:00:00 | YM | Futures | 40560.2 | 40560.2 | 40524.1 | 40541.1 | 1471.0 |
| 2024-05-30 02:00:00 | YM | Futures | 40542.2 | 40560.2 | 40493.3 | 40498.6 | 2260.0 |
| 2024-05-30 03:00:00 | YM | Futures | 40498.6 | 40581.4 | 40498.6 | 40576.1 | 2327.0 |
> showing 50 of 2,073 rows — these rows as CSV