PREVIEW / futures_1hour / 2024-04-09
file: by_date/futures_1hour/2024/2024-04-09.parquet size: 65 KB rows: 2,067
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-04-09 00:00:00 | ES | Futures | 5576.25 | 5579.17 | 5575.99 | 5578.64 | 2747.0 |
| 2024-04-09 01:00:00 | ES | Futures | 5578.9 | 5580.76 | 5577.58 | 5577.58 | 2951.0 |
| 2024-04-09 02:00:00 | ES | Futures | 5577.58 | 5579.96 | 5576.25 | 5577.05 | 5648.0 |
| 2024-04-09 03:00:00 | ES | Futures | 5576.52 | 5579.17 | 5569.62 | 5570.15 | 17119.0 |
| 2024-04-09 04:00:00 | ES | Futures | 5570.41 | 5575.45 | 5569.35 | 5574.39 | 14063.0 |
| 2024-04-09 05:00:00 | ES | Futures | 5574.66 | 5581.03 | 5573.33 | 5577.84 | 13795.0 |
| 2024-04-09 06:00:00 | ES | Futures | 5577.84 | 5580.23 | 5566.97 | 5570.94 | 20417.0 |
| 2024-04-09 07:00:00 | ES | Futures | 5571.21 | 5583.41 | 5570.94 | 5582.88 | 17780.0 |
| 2024-04-09 08:00:00 | ES | Futures | 5582.88 | 5590.84 | 5582.88 | 5588.19 | 34708.0 |
| 2024-04-09 09:00:00 | ES | Futures | 5588.19 | 5596.94 | 5575.45 | 5576.52 | 185390.0 |
| 2024-04-09 10:00:00 | ES | Futures | 5576.78 | 5580.76 | 5526.91 | 5539.9 | 361337.0 |
| 2024-04-09 11:00:00 | ES | Futures | 5539.9 | 5557.68 | 5536.19 | 5554.23 | 204375.0 |
| 2024-04-09 12:00:00 | ES | Futures | 5554.5 | 5565.11 | 5551.84 | 5553.97 | 121091.0 |
| 2024-04-09 13:00:00 | ES | Futures | 5554.23 | 5563.52 | 5552.11 | 5552.9 | 92698.0 |
| 2024-04-09 14:00:00 | ES | Futures | 5553.17 | 5559.8 | 5548.13 | 5551.58 | 95557.0 |
| 2024-04-09 15:00:00 | ES | Futures | 5551.31 | 5583.68 | 5542.56 | 5581.82 | 265970.0 |
| 2024-04-09 16:00:00 | ES | Futures | 5581.82 | 5594.56 | 5581.03 | 5587.66 | 115081.0 |
| 2024-04-09 18:00:00 | ES | Futures | 5586.33 | 5587.66 | 5583.94 | 5585.54 | 4944.0 |
| 2024-04-09 19:00:00 | ES | Futures | 5585.54 | 5586.07 | 5583.68 | 5583.94 | 2218.0 |
| 2024-04-09 20:00:00 | ES | Futures | 5583.94 | 5587.39 | 5583.15 | 5586.86 | 4696.0 |
| 2024-04-09 21:00:00 | ES | Futures | 5586.33 | 5587.39 | 5583.68 | 5587.13 | 3311.0 |
| 2024-04-09 22:00:00 | ES | Futures | 5587.13 | 5587.39 | 5585.01 | 5586.86 | 3166.0 |
| 2024-04-09 23:00:00 | ES | Futures | 5586.86 | 5587.13 | 5585.54 | 5586.33 | 2245.0 |
| 2024-04-09 00:00:00 | NQ | Futures | 19585.04 | 19600.02 | 19583.17 | 19596.54 | 1924.0 |
| 2024-04-09 01:00:00 | NQ | Futures | 19596.54 | 19607.51 | 19592.8 | 19594.94 | 2661.0 |
| 2024-04-09 02:00:00 | NQ | Futures | 19594.94 | 19608.05 | 19591.73 | 19600.82 | 2817.0 |
| 2024-04-09 03:00:00 | NQ | Futures | 19600.56 | 19618.48 | 19544.91 | 19556.15 | 11062.0 |
| 2024-04-09 04:00:00 | NQ | Futures | 19555.61 | 19594.14 | 19548.93 | 19586.91 | 8548.0 |
| 2024-04-09 05:00:00 | NQ | Futures | 19585.57 | 19618.75 | 19575.14 | 19601.36 | 7766.0 |
| 2024-04-09 06:00:00 | NQ | Futures | 19600.82 | 19608.58 | 19531.54 | 19563.37 | 12929.0 |
| 2024-04-09 07:00:00 | NQ | Futures | 19564.44 | 19628.91 | 19564.17 | 19624.9 | 13134.0 |
| 2024-04-09 08:00:00 | NQ | Futures | 19624.36 | 19657.8 | 19620.62 | 19647.64 | 16350.0 |
| 2024-04-09 09:00:00 | NQ | Futures | 19647.64 | 19693.65 | 19619.01 | 19626.77 | 95640.0 |
| 2024-04-09 10:00:00 | NQ | Futures | 19626.77 | 19656.2 | 19432.3 | 19492.48 | 162722.0 |
| 2024-04-09 11:00:00 | NQ | Futures | 19492.22 | 19554.28 | 19478.31 | 19539.56 | 81529.0 |
| 2024-04-09 12:00:00 | NQ | Futures | 19539.83 | 19585.31 | 19533.68 | 19541.97 | 51739.0 |
| 2024-04-09 13:00:00 | NQ | Futures | 19543.31 | 19577.28 | 19528.86 | 19533.14 | 42191.0 |
| 2024-04-09 14:00:00 | NQ | Futures | 19533.41 | 19564.17 | 19514.15 | 19529.93 | 48434.0 |
| 2024-04-09 15:00:00 | NQ | Futures | 19529.4 | 19651.11 | 19490.88 | 19647.9 | 92974.0 |
| 2024-04-09 16:00:00 | NQ | Futures | 19647.37 | 19696.05 | 19644.96 | 19671.98 | 25863.0 |
| 2024-04-09 18:00:00 | NQ | Futures | 19667.97 | 19671.18 | 19657.27 | 19661.55 | 2622.0 |
| 2024-04-09 19:00:00 | NQ | Futures | 19662.35 | 19663.95 | 19653.25 | 19654.59 | 1342.0 |
| 2024-04-09 20:00:00 | NQ | Futures | 19655.13 | 19669.57 | 19652.72 | 19666.09 | 1994.0 |
| 2024-04-09 21:00:00 | NQ | Futures | 19665.83 | 19672.51 | 19653.52 | 19667.43 | 2304.0 |
| 2024-04-09 22:00:00 | NQ | Futures | 19667.43 | 19669.3 | 19658.07 | 19667.97 | 1464.0 |
| 2024-04-09 23:00:00 | NQ | Futures | 19668.23 | 19670.11 | 19662.08 | 19665.02 | 1239.0 |
| 2024-04-09 00:00:00 | YM | Futures | 41628.3 | 41646.3 | 41625.1 | 41641.0 | 335.0 |
| 2024-04-09 01:00:00 | YM | Futures | 41643.2 | 41654.8 | 41632.5 | 41632.5 | 504.0 |
| 2024-04-09 02:00:00 | YM | Futures | 41632.5 | 41646.3 | 41617.7 | 41623.0 | 1095.0 |
| 2024-04-09 03:00:00 | YM | Futures | 41623.0 | 41634.7 | 41589.0 | 41590.1 | 2159.0 |
> showing 50 of 2,067 rows — these rows as CSV