PREVIEW / futures_30min / 2023-07-04
file: by_date/futures_30min/2023/2023-07-04.parquet size: 78 KB rows: 3,005
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-04 00:00:00 | ES | Futures | 4931.6 | 4932.7 | 4931.05 | 4932.15 | 915.0 |
| 2023-07-04 00:30:00 | ES | Futures | 4932.15 | 4933.79 | 4931.87 | 4932.15 | 1742.0 |
| 2023-07-04 01:00:00 | ES | Futures | 4932.42 | 4933.52 | 4932.15 | 4932.15 | 1288.0 |
| 2023-07-04 01:30:00 | ES | Futures | 4932.15 | 4932.7 | 4931.05 | 4931.32 | 1673.0 |
| 2023-07-04 02:00:00 | ES | Futures | 4931.32 | 4932.15 | 4929.95 | 4931.6 | 2589.0 |
| 2023-07-04 02:30:00 | ES | Futures | 4931.87 | 4932.7 | 4929.68 | 4932.7 | 1851.0 |
| 2023-07-04 03:00:00 | ES | Futures | 4932.7 | 4933.79 | 4931.05 | 4931.6 | 4226.0 |
| 2023-07-04 03:30:00 | ES | Futures | 4931.6 | 4934.34 | 4931.6 | 4933.24 | 3235.0 |
| 2023-07-04 04:00:00 | ES | Futures | 4933.52 | 4933.52 | 4931.87 | 4932.15 | 2496.0 |
| 2023-07-04 04:30:00 | ES | Futures | 4932.42 | 4932.42 | 4927.21 | 4928.58 | 3672.0 |
| 2023-07-04 05:00:00 | ES | Futures | 4928.58 | 4930.22 | 4928.03 | 4929.13 | 2450.0 |
| 2023-07-04 05:30:00 | ES | Futures | 4929.13 | 4930.77 | 4927.48 | 4930.22 | 3039.0 |
| 2023-07-04 06:00:00 | ES | Futures | 4930.22 | 4930.5 | 4928.85 | 4929.13 | 1990.0 |
| 2023-07-04 06:30:00 | ES | Futures | 4928.85 | 4929.13 | 4926.11 | 4928.85 | 2864.0 |
| 2023-07-04 07:00:00 | ES | Futures | 4928.85 | 4930.22 | 4928.3 | 4929.68 | 1678.0 |
| 2023-07-04 07:30:00 | ES | Futures | 4929.68 | 4931.87 | 4929.68 | 4930.22 | 1949.0 |
| 2023-07-04 08:00:00 | ES | Futures | 4930.22 | 4931.87 | 4929.68 | 4930.77 | 2296.0 |
| 2023-07-04 08:30:00 | ES | Futures | 4931.05 | 4932.15 | 4930.22 | 4930.5 | 2195.0 |
| 2023-07-04 09:00:00 | ES | Futures | 4930.5 | 4931.87 | 4927.75 | 4931.6 | 3949.0 |
| 2023-07-04 09:30:00 | ES | Futures | 4931.6 | 4932.15 | 4929.95 | 4931.05 | 3543.0 |
| 2023-07-04 10:00:00 | ES | Futures | 4931.05 | 4931.6 | 4928.3 | 4928.85 | 3551.0 |
| 2023-07-04 10:30:00 | ES | Futures | 4928.58 | 4930.77 | 4928.58 | 4930.22 | 3438.0 |
| 2023-07-04 11:00:00 | ES | Futures | 4929.95 | 4931.05 | 4929.68 | 4930.77 | 2299.0 |
| 2023-07-04 11:30:00 | ES | Futures | 4930.5 | 4931.6 | 4930.22 | 4930.5 | 2017.0 |
| 2023-07-04 12:00:00 | ES | Futures | 4930.5 | 4930.77 | 4929.68 | 4930.22 | 1928.0 |
| 2023-07-04 12:30:00 | ES | Futures | 4930.5 | 4931.32 | 4929.4 | 4930.77 | 2218.0 |
| 2023-07-04 18:00:00 | ES | Futures | 4930.22 | 4931.05 | 4929.13 | 4929.13 | 1627.0 |
| 2023-07-04 18:30:00 | ES | Futures | 4929.13 | 4930.22 | 4928.3 | 4929.4 | 1351.0 |
| 2023-07-04 19:00:00 | ES | Futures | 4929.13 | 4929.4 | 4928.03 | 4928.58 | 896.0 |
| 2023-07-04 19:30:00 | ES | Futures | 4928.58 | 4929.95 | 4928.03 | 4929.4 | 965.0 |
| 2023-07-04 20:00:00 | ES | Futures | 4929.4 | 4931.32 | 4927.75 | 4930.77 | 3940.0 |
| 2023-07-04 20:30:00 | ES | Futures | 4930.77 | 4931.32 | 4929.95 | 4931.32 | 2045.0 |
| 2023-07-04 21:00:00 | ES | Futures | 4931.32 | 4932.7 | 4930.22 | 4932.42 | 2556.0 |
| 2023-07-04 21:30:00 | ES | Futures | 4932.42 | 4933.24 | 4931.05 | 4932.42 | 3393.0 |
| 2023-07-04 22:00:00 | ES | Futures | 4932.15 | 4932.42 | 4930.5 | 4930.77 | 2002.0 |
| 2023-07-04 22:30:00 | ES | Futures | 4930.5 | 4931.6 | 4929.4 | 4929.68 | 2157.0 |
| 2023-07-04 23:00:00 | ES | Futures | 4929.68 | 4929.68 | 4928.03 | 4928.03 | 1781.0 |
| 2023-07-04 23:30:00 | ES | Futures | 4928.03 | 4929.95 | 4928.03 | 4929.13 | 1718.0 |
| 2023-07-04 00:00:00 | NQ | Futures | 17076.7 | 17081.42 | 17074.19 | 17080.59 | 497.0 |
| 2023-07-04 00:30:00 | NQ | Futures | 17081.15 | 17084.21 | 17076.42 | 17076.7 | 984.0 |
| 2023-07-04 01:00:00 | NQ | Futures | 17077.25 | 17081.7 | 17075.03 | 17076.14 | 643.0 |
| 2023-07-04 01:30:00 | NQ | Futures | 17075.86 | 17079.48 | 17072.8 | 17074.75 | 785.0 |
| 2023-07-04 02:00:00 | NQ | Futures | 17074.47 | 17076.14 | 17067.24 | 17069.19 | 1194.0 |
| 2023-07-04 02:30:00 | NQ | Futures | 17068.91 | 17075.31 | 17063.62 | 17075.03 | 1218.0 |
| 2023-07-04 03:00:00 | NQ | Futures | 17075.31 | 17081.7 | 17073.64 | 17076.14 | 1688.0 |
| 2023-07-04 03:30:00 | NQ | Futures | 17076.42 | 17089.49 | 17075.86 | 17086.71 | 1284.0 |
| 2023-07-04 04:00:00 | NQ | Futures | 17086.43 | 17087.26 | 17078.64 | 17084.76 | 988.0 |
| 2023-07-04 04:30:00 | NQ | Futures | 17084.48 | 17085.6 | 17068.63 | 17071.97 | 1319.0 |
| 2023-07-04 05:00:00 | NQ | Futures | 17072.8 | 17078.64 | 17070.58 | 17075.31 | 856.0 |
| 2023-07-04 05:30:00 | NQ | Futures | 17075.03 | 17080.87 | 17070.58 | 17078.64 | 761.0 |
> showing 50 of 3,005 rows — these rows as CSV