PREVIEW / futures_1hour / 2023-07-28
file: by_date/futures_1hour/2023/2023-07-28.parquet size: 57 KB rows: 1,667
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-07-28 00:00:00 | ES | Futures | 5018.07 | 5023.28 | 5004.89 | 5020.81 | 23089.0 |
| 2023-07-28 01:00:00 | ES | Futures | 5020.81 | 5030.15 | 5020.26 | 5028.77 | 15173.0 |
| 2023-07-28 02:00:00 | ES | Futures | 5028.5 | 5030.97 | 5023.83 | 5026.3 | 13020.0 |
| 2023-07-28 03:00:00 | ES | Futures | 5026.3 | 5037.56 | 5025.21 | 5029.32 | 32970.0 |
| 2023-07-28 04:00:00 | ES | Futures | 5029.32 | 5030.97 | 5022.19 | 5027.68 | 17712.0 |
| 2023-07-28 05:00:00 | ES | Futures | 5027.68 | 5035.09 | 5025.75 | 5032.89 | 17567.0 |
| 2023-07-28 06:00:00 | ES | Futures | 5033.17 | 5033.99 | 5027.95 | 5031.79 | 13859.0 |
| 2023-07-28 07:00:00 | ES | Futures | 5031.79 | 5039.21 | 5029.6 | 5038.38 | 20621.0 |
| 2023-07-28 08:00:00 | ES | Futures | 5038.11 | 5046.89 | 5037.01 | 5046.62 | 45568.0 |
| 2023-07-28 09:00:00 | ES | Futures | 5046.62 | 5055.95 | 5039.75 | 5050.74 | 187850.0 |
| 2023-07-28 10:00:00 | ES | Futures | 5050.74 | 5058.97 | 5048.54 | 5058.15 | 205396.0 |
| 2023-07-28 11:00:00 | ES | Futures | 5058.15 | 5069.13 | 5055.68 | 5068.03 | 143071.0 |
| 2023-07-28 12:00:00 | ES | Futures | 5068.03 | 5068.03 | 5058.97 | 5060.62 | 101173.0 |
| 2023-07-28 13:00:00 | ES | Futures | 5060.62 | 5060.62 | 5038.66 | 5052.11 | 171928.0 |
| 2023-07-28 14:00:00 | ES | Futures | 5052.11 | 5064.19 | 5051.01 | 5060.34 | 134246.0 |
| 2023-07-28 15:00:00 | ES | Futures | 5060.62 | 5063.64 | 5052.11 | 5058.42 | 216744.0 |
| 2023-07-28 16:00:00 | ES | Futures | 5058.7 | 5059.79 | 5056.5 | 5058.7 | 56829.0 |
| 2023-07-28 00:00:00 | NQ | Futures | 17369.85 | 17378.75 | 17295.58 | 17372.91 | 14786.0 |
| 2023-07-28 01:00:00 | NQ | Futures | 17372.91 | 17413.51 | 17372.91 | 17407.12 | 6612.0 |
| 2023-07-28 02:00:00 | NQ | Futures | 17405.72 | 17415.18 | 17372.63 | 17394.32 | 6826.0 |
| 2023-07-28 03:00:00 | NQ | Futures | 17394.04 | 17467.75 | 17389.04 | 17435.21 | 13072.0 |
| 2023-07-28 04:00:00 | NQ | Futures | 17434.65 | 17451.62 | 17411.84 | 17432.15 | 7503.0 |
| 2023-07-28 05:00:00 | NQ | Futures | 17432.15 | 17465.52 | 17420.74 | 17462.19 | 6386.0 |
| 2023-07-28 06:00:00 | NQ | Futures | 17462.46 | 17476.09 | 17441.88 | 17463.3 | 7062.0 |
| 2023-07-28 07:00:00 | NQ | Futures | 17462.74 | 17487.22 | 17449.95 | 17483.32 | 9885.0 |
| 2023-07-28 08:00:00 | NQ | Futures | 17482.77 | 17522.26 | 17479.43 | 17514.2 | 24162.0 |
| 2023-07-28 09:00:00 | NQ | Futures | 17513.64 | 17599.86 | 17484.16 | 17565.09 | 103769.0 |
| 2023-07-28 10:00:00 | NQ | Futures | 17565.37 | 17619.89 | 17558.14 | 17595.97 | 101403.0 |
| 2023-07-28 11:00:00 | NQ | Futures | 17596.24 | 17684.41 | 17593.19 | 17683.3 | 70549.0 |
| 2023-07-28 12:00:00 | NQ | Futures | 17683.3 | 17684.69 | 17630.73 | 17639.36 | 51099.0 |
| 2023-07-28 13:00:00 | NQ | Futures | 17639.63 | 17639.63 | 17549.52 | 17616.27 | 71160.0 |
| 2023-07-28 14:00:00 | NQ | Futures | 17616.55 | 17668.84 | 17600.97 | 17650.48 | 55582.0 |
| 2023-07-28 15:00:00 | NQ | Futures | 17650.76 | 17666.61 | 17611.26 | 17633.24 | 71263.0 |
| 2023-07-28 16:00:00 | NQ | Futures | 17632.96 | 17634.63 | 17615.16 | 17629.06 | 14198.0 |
| 2023-07-28 00:00:00 | YM | Futures | 38830.5 | 38876.5 | 38756.0 | 38861.2 | 2962.0 |
| 2023-07-28 01:00:00 | YM | Futures | 38859.0 | 38929.1 | 38857.9 | 38917.1 | 1895.0 |
| 2023-07-28 02:00:00 | YM | Futures | 38914.9 | 38933.5 | 38886.4 | 38899.5 | 2540.0 |
| 2023-07-28 03:00:00 | YM | Futures | 38897.3 | 38967.4 | 38883.1 | 38903.9 | 3897.0 |
| 2023-07-28 04:00:00 | YM | Futures | 38903.9 | 38908.3 | 38832.7 | 38868.8 | 2930.0 |
| 2023-07-28 05:00:00 | YM | Futures | 38867.8 | 38918.1 | 38856.8 | 38900.6 | 2104.0 |
| 2023-07-28 06:00:00 | YM | Futures | 38901.7 | 38909.4 | 38856.8 | 38890.8 | 2261.0 |
| 2023-07-28 07:00:00 | YM | Futures | 38890.8 | 38948.8 | 38884.2 | 38942.3 | 3094.0 |
| 2023-07-28 08:00:00 | YM | Futures | 38941.2 | 39008.0 | 38932.4 | 39006.9 | 6290.0 |
| 2023-07-28 09:00:00 | YM | Futures | 39004.7 | 39050.7 | 38920.3 | 38964.2 | 21717.0 |
| 2023-07-28 10:00:00 | YM | Futures | 38965.3 | 39057.3 | 38954.3 | 39057.3 | 18954.0 |
| 2023-07-28 11:00:00 | YM | Futures | 39058.4 | 39119.7 | 39023.3 | 39082.5 | 12612.0 |
| 2023-07-28 12:00:00 | YM | Futures | 39082.5 | 39082.5 | 39022.2 | 39044.1 | 9659.0 |
| 2023-07-28 13:00:00 | YM | Futures | 39045.2 | 39045.2 | 38879.8 | 38964.2 | 14321.0 |
| 2023-07-28 14:00:00 | YM | Futures | 38964.2 | 39031.0 | 38944.4 | 38999.2 | 10516.0 |
| 2023-07-28 15:00:00 | YM | Futures | 38999.2 | 39023.3 | 38957.6 | 38991.6 | 14518.0 |
> showing 50 of 1,667 rows — these rows as CSV