PREVIEW / futures_1hour / 2024-05-22
file: by_date/futures_1hour/2024/2024-05-22.parquet size: 66 KB rows: 2,071
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-22 00:00:00 | ES | Futures | 5672.82 | 5673.61 | 5672.29 | 5672.55 | 1390.0 |
| 2024-05-22 01:00:00 | ES | Futures | 5672.82 | 5674.41 | 5672.29 | 5673.88 | 2016.0 |
| 2024-05-22 02:00:00 | ES | Futures | 5674.14 | 5674.14 | 5668.84 | 5669.9 | 6918.0 |
| 2024-05-22 03:00:00 | ES | Futures | 5669.9 | 5669.9 | 5664.86 | 5669.1 | 12338.0 |
| 2024-05-22 04:00:00 | ES | Futures | 5668.84 | 5670.17 | 5665.39 | 5666.72 | 7208.0 |
| 2024-05-22 05:00:00 | ES | Futures | 5666.72 | 5668.04 | 5662.74 | 5664.33 | 6721.0 |
| 2024-05-22 06:00:00 | ES | Futures | 5664.59 | 5665.66 | 5660.88 | 5662.21 | 9727.0 |
| 2024-05-22 07:00:00 | ES | Futures | 5662.47 | 5668.04 | 5661.15 | 5661.41 | 15594.0 |
| 2024-05-22 08:00:00 | ES | Futures | 5661.41 | 5664.86 | 5660.61 | 5664.06 | 16993.0 |
| 2024-05-22 09:00:00 | ES | Futures | 5663.8 | 5669.9 | 5661.41 | 5669.37 | 99661.0 |
| 2024-05-22 10:00:00 | ES | Futures | 5669.1 | 5670.96 | 5665.66 | 5669.1 | 102938.0 |
| 2024-05-22 11:00:00 | ES | Futures | 5669.1 | 5672.02 | 5658.76 | 5664.59 | 91027.0 |
| 2024-05-22 12:00:00 | ES | Futures | 5664.33 | 5669.63 | 5663.8 | 5666.45 | 68293.0 |
| 2024-05-22 13:00:00 | ES | Futures | 5666.19 | 5670.43 | 5651.06 | 5657.17 | 124328.0 |
| 2024-05-22 14:00:00 | ES | Futures | 5656.9 | 5656.9 | 5631.43 | 5641.78 | 236645.0 |
| 2024-05-22 15:00:00 | ES | Futures | 5641.78 | 5655.84 | 5633.55 | 5655.31 | 262892.0 |
| 2024-05-22 16:00:00 | ES | Futures | 5655.31 | 5674.14 | 5635.15 | 5657.17 | 110881.0 |
| 2024-05-22 18:00:00 | ES | Futures | 5665.66 | 5669.1 | 5660.35 | 5663.53 | 9319.0 |
| 2024-05-22 19:00:00 | ES | Futures | 5663.53 | 5668.31 | 5663.0 | 5667.78 | 4048.0 |
| 2024-05-22 20:00:00 | ES | Futures | 5668.04 | 5668.84 | 5665.66 | 5666.72 | 5810.0 |
| 2024-05-22 21:00:00 | ES | Futures | 5666.72 | 5674.14 | 5665.12 | 5672.29 | 8727.0 |
| 2024-05-22 22:00:00 | ES | Futures | 5672.29 | 5684.23 | 5671.23 | 5684.23 | 10093.0 |
| 2024-05-22 23:00:00 | ES | Futures | 5684.23 | 5689.8 | 5682.1 | 5689.0 | 12754.0 |
| 2024-05-22 00:00:00 | NQ | Futures | 20127.0 | 20130.75 | 20124.86 | 20126.2 | 854.0 |
| 2024-05-22 01:00:00 | NQ | Futures | 20126.47 | 20138.24 | 20126.2 | 20136.9 | 1379.0 |
| 2024-05-22 02:00:00 | NQ | Futures | 20137.7 | 20138.51 | 20117.64 | 20123.53 | 3887.0 |
| 2024-05-22 03:00:00 | NQ | Futures | 20123.53 | 20125.4 | 20104.53 | 20116.3 | 7522.0 |
| 2024-05-22 04:00:00 | NQ | Futures | 20116.04 | 20124.6 | 20101.32 | 20108.55 | 3913.0 |
| 2024-05-22 05:00:00 | NQ | Futures | 20108.28 | 20114.43 | 20085.27 | 20093.57 | 5164.0 |
| 2024-05-22 06:00:00 | NQ | Futures | 20094.37 | 20097.58 | 20068.15 | 20089.55 | 6813.0 |
| 2024-05-22 07:00:00 | NQ | Futures | 20089.82 | 20128.61 | 20089.29 | 20108.28 | 13147.0 |
| 2024-05-22 08:00:00 | NQ | Futures | 20108.81 | 20121.65 | 20101.59 | 20119.51 | 11379.0 |
| 2024-05-22 09:00:00 | NQ | Futures | 20119.25 | 20148.94 | 20104.27 | 20142.52 | 68842.0 |
| 2024-05-22 10:00:00 | NQ | Futures | 20141.72 | 20151.35 | 20117.91 | 20137.97 | 60322.0 |
| 2024-05-22 11:00:00 | NQ | Futures | 20138.24 | 20157.77 | 20116.3 | 20136.9 | 41785.0 |
| 2024-05-22 12:00:00 | NQ | Futures | 20136.63 | 20151.08 | 20106.14 | 20120.32 | 35757.0 |
| 2024-05-22 13:00:00 | NQ | Futures | 20120.05 | 20144.12 | 20058.52 | 20086.07 | 60222.0 |
| 2024-05-22 14:00:00 | NQ | Futures | 20086.07 | 20086.07 | 19992.45 | 20041.4 | 105243.0 |
| 2024-05-22 15:00:00 | NQ | Futures | 20041.13 | 20110.15 | 20003.15 | 20109.62 | 88479.0 |
| 2024-05-22 16:00:00 | NQ | Futures | 20109.88 | 20213.67 | 19999.94 | 20133.69 | 43561.0 |
| 2024-05-22 18:00:00 | NQ | Futures | 20181.04 | 20194.95 | 20162.58 | 20174.35 | 6306.0 |
| 2024-05-22 19:00:00 | NQ | Futures | 20174.89 | 20198.69 | 20172.75 | 20196.55 | 2716.0 |
| 2024-05-22 20:00:00 | NQ | Futures | 20197.09 | 20198.43 | 20182.64 | 20188.8 | 3128.0 |
| 2024-05-22 21:00:00 | NQ | Futures | 20189.06 | 20234.54 | 20183.98 | 20224.64 | 6619.0 |
| 2024-05-22 22:00:00 | NQ | Futures | 20224.37 | 20271.72 | 20221.16 | 20270.92 | 5313.0 |
| 2024-05-22 23:00:00 | NQ | Futures | 20269.85 | 20293.66 | 20260.22 | 20289.11 | 6926.0 |
| 2024-05-22 00:00:00 | YM | Futures | 42479.8 | 42480.8 | 42469.2 | 42475.5 | 351.0 |
| 2024-05-22 01:00:00 | YM | Futures | 42476.6 | 42486.1 | 42470.2 | 42484.0 | 460.0 |
| 2024-05-22 02:00:00 | YM | Futures | 42484.0 | 42485.1 | 42438.4 | 42440.5 | 1184.0 |
| 2024-05-22 03:00:00 | YM | Futures | 42441.6 | 42455.4 | 42409.7 | 42452.2 | 1709.0 |
> showing 50 of 2,071 rows — these rows as CSV