PREVIEW / futures_1hour / 2023-02-17
file: by_date/futures_1hour/2023/2023-02-17.parquet size: 58 KB rows: 1,660
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-02-17 00:00:00 | ES | Futures | 4566.81 | 4567.09 | 4561.78 | 4563.18 | 5908.0 |
| 2023-02-17 01:00:00 | ES | Futures | 4563.46 | 4564.86 | 4558.71 | 4560.38 | 7875.0 |
| 2023-02-17 02:00:00 | ES | Futures | 4560.66 | 4567.09 | 4557.87 | 4561.78 | 14842.0 |
| 2023-02-17 03:00:00 | ES | Futures | 4562.06 | 4562.06 | 4544.45 | 4555.35 | 40335.0 |
| 2023-02-17 04:00:00 | ES | Futures | 4555.35 | 4564.02 | 4550.6 | 4557.87 | 24995.0 |
| 2023-02-17 05:00:00 | ES | Futures | 4558.15 | 4559.26 | 4550.6 | 4551.44 | 19615.0 |
| 2023-02-17 06:00:00 | ES | Futures | 4551.16 | 4555.07 | 4546.96 | 4552.55 | 20245.0 |
| 2023-02-17 07:00:00 | ES | Futures | 4552.27 | 4561.5 | 4551.16 | 4558.15 | 31829.0 |
| 2023-02-17 08:00:00 | ES | Futures | 4557.87 | 4562.62 | 4552.27 | 4560.1 | 45896.0 |
| 2023-02-17 09:00:00 | ES | Futures | 4559.82 | 4567.09 | 4537.46 | 4543.61 | 305873.0 |
| 2023-02-17 10:00:00 | ES | Futures | 4543.61 | 4571.85 | 4542.49 | 4545.84 | 374002.0 |
| 2023-02-17 11:00:00 | ES | Futures | 4545.84 | 4552.83 | 4536.9 | 4544.45 | 208225.0 |
| 2023-02-17 12:00:00 | ES | Futures | 4544.17 | 4557.87 | 4536.06 | 4540.53 | 148413.0 |
| 2023-02-17 13:00:00 | ES | Futures | 4540.81 | 4551.99 | 4538.29 | 4548.36 | 125665.0 |
| 2023-02-17 14:00:00 | ES | Futures | 4548.64 | 4572.13 | 4547.8 | 4570.45 | 181896.0 |
| 2023-02-17 15:00:00 | ES | Futures | 4570.45 | 4574.92 | 4562.34 | 4572.41 | 278740.0 |
| 2023-02-17 16:00:00 | ES | Futures | 4572.13 | 4573.24 | 4569.05 | 4569.61 | 46196.0 |
| 2023-02-17 00:00:00 | NQ | Futures | 14126.27 | 14126.55 | 14104.36 | 14110.91 | 3382.0 |
| 2023-02-17 01:00:00 | NQ | Futures | 14110.91 | 14118.3 | 14087.86 | 14099.24 | 4357.0 |
| 2023-02-17 02:00:00 | NQ | Futures | 14099.53 | 14129.68 | 14084.16 | 14112.33 | 8123.0 |
| 2023-02-17 03:00:00 | NQ | Futures | 14112.9 | 14116.88 | 14040.35 | 14080.46 | 18294.0 |
| 2023-02-17 04:00:00 | NQ | Futures | 14081.03 | 14120.29 | 14069.37 | 14087.29 | 12152.0 |
| 2023-02-17 05:00:00 | NQ | Futures | 14087.58 | 14092.13 | 14061.4 | 14062.54 | 8145.0 |
| 2023-02-17 06:00:00 | NQ | Futures | 14062.26 | 14080.75 | 14046.61 | 14075.91 | 9063.0 |
| 2023-02-17 07:00:00 | NQ | Futures | 14075.91 | 14104.08 | 14069.08 | 14089.57 | 11407.0 |
| 2023-02-17 08:00:00 | NQ | Futures | 14089.0 | 14112.9 | 14065.67 | 14099.24 | 17303.0 |
| 2023-02-17 09:00:00 | NQ | Futures | 14099.53 | 14137.93 | 13992.84 | 14030.68 | 95159.0 |
| 2023-02-17 10:00:00 | NQ | Futures | 14030.11 | 14120.86 | 14014.46 | 14017.88 | 102721.0 |
| 2023-02-17 11:00:00 | NQ | Futures | 14018.44 | 14040.92 | 13968.66 | 14000.24 | 67339.0 |
| 2023-02-17 12:00:00 | NQ | Futures | 14000.24 | 14051.45 | 13958.13 | 13976.91 | 54870.0 |
| 2023-02-17 13:00:00 | NQ | Futures | 13977.76 | 14018.44 | 13968.94 | 14005.64 | 41729.0 |
| 2023-02-17 14:00:00 | NQ | Futures | 14006.5 | 14107.49 | 14002.51 | 14100.38 | 56662.0 |
| 2023-02-17 15:00:00 | NQ | Futures | 14100.95 | 14119.72 | 14059.41 | 14101.8 | 70404.0 |
| 2023-02-17 16:00:00 | NQ | Futures | 14101.8 | 14104.93 | 14088.43 | 14092.7 | 10260.0 |
| 2023-02-17 00:00:00 | YM | Futures | 37498.9 | 37500.0 | 37467.7 | 37482.2 | 1062.0 |
| 2023-02-17 01:00:00 | YM | Futures | 37483.3 | 37491.1 | 37448.8 | 37458.8 | 1557.0 |
| 2023-02-17 02:00:00 | YM | Futures | 37459.9 | 37506.7 | 37443.2 | 37471.0 | 2492.0 |
| 2023-02-17 03:00:00 | YM | Futures | 37468.8 | 37471.0 | 37340.7 | 37413.1 | 5554.0 |
| 2023-02-17 04:00:00 | YM | Futures | 37414.2 | 37481.1 | 37374.1 | 37448.8 | 4075.0 |
| 2023-02-17 05:00:00 | YM | Futures | 37449.9 | 37456.6 | 37391.9 | 37405.3 | 2797.0 |
| 2023-02-17 06:00:00 | YM | Futures | 37404.2 | 37419.8 | 37365.2 | 37390.8 | 2353.0 |
| 2023-02-17 07:00:00 | YM | Futures | 37391.9 | 37463.2 | 37384.1 | 37435.4 | 3409.0 |
| 2023-02-17 08:00:00 | YM | Futures | 37434.3 | 37475.5 | 37398.6 | 37465.5 | 4941.0 |
| 2023-02-17 09:00:00 | YM | Futures | 37464.4 | 37515.6 | 37375.2 | 37434.3 | 25407.0 |
| 2023-02-17 10:00:00 | YM | Futures | 37434.3 | 37706.1 | 37428.7 | 37510.0 | 36905.0 |
| 2023-02-17 11:00:00 | YM | Futures | 37505.6 | 37568.0 | 37446.5 | 37504.5 | 17623.0 |
| 2023-02-17 12:00:00 | YM | Futures | 37503.4 | 37627.0 | 37466.6 | 37508.9 | 14707.0 |
| 2023-02-17 13:00:00 | YM | Futures | 37510.0 | 37584.7 | 37491.1 | 37554.6 | 10617.0 |
| 2023-02-17 14:00:00 | YM | Futures | 37555.7 | 37724.0 | 37555.7 | 37713.9 | 13778.0 |
| 2023-02-17 15:00:00 | YM | Futures | 37715.1 | 37758.5 | 37668.3 | 37736.2 | 23693.0 |
> showing 50 of 1,660 rows — these rows as CSV