PREVIEW / futures_30min / 2010-01-11
file: by_date/futures_30min/2010/2010-01-11.parquet size: 69 KB rows: 2,499
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 |
|---|---|---|---|---|---|---|---|
| 2010-01-11 00:00:00 | ES | Futures | 1115.83 | 1116.07 | 1115.58 | 1115.58 | 647.0 |
| 2010-01-11 00:30:00 | ES | Futures | 1115.58 | 1115.83 | 1115.1 | 1115.34 | 1023.0 |
| 2010-01-11 01:00:00 | ES | Futures | 1115.1 | 1115.34 | 1114.37 | 1114.61 | 1817.0 |
| 2010-01-11 01:30:00 | ES | Futures | 1114.61 | 1115.34 | 1114.37 | 1114.61 | 1563.0 |
| 2010-01-11 02:00:00 | ES | Futures | 1114.61 | 1114.86 | 1113.4 | 1114.86 | 6773.0 |
| 2010-01-11 02:30:00 | ES | Futures | 1114.86 | 1115.1 | 1113.88 | 1113.88 | 4573.0 |
| 2010-01-11 03:00:00 | ES | Futures | 1113.88 | 1116.31 | 1113.4 | 1116.07 | 12125.0 |
| 2010-01-11 03:30:00 | ES | Futures | 1115.83 | 1117.04 | 1115.1 | 1116.8 | 8983.0 |
| 2010-01-11 04:00:00 | ES | Futures | 1116.56 | 1117.04 | 1116.07 | 1116.8 | 5031.0 |
| 2010-01-11 04:30:00 | ES | Futures | 1116.8 | 1117.04 | 1115.83 | 1116.56 | 5797.0 |
| 2010-01-11 05:00:00 | ES | Futures | 1116.56 | 1116.8 | 1115.83 | 1116.56 | 5370.0 |
| 2010-01-11 05:30:00 | ES | Futures | 1116.56 | 1117.04 | 1116.31 | 1116.56 | 2721.0 |
| 2010-01-11 06:00:00 | ES | Futures | 1116.8 | 1117.04 | 1114.13 | 1115.58 | 9600.0 |
| 2010-01-11 06:30:00 | ES | Futures | 1115.34 | 1115.58 | 1114.86 | 1115.1 | 2436.0 |
| 2010-01-11 07:00:00 | ES | Futures | 1115.34 | 1115.34 | 1113.64 | 1114.61 | 8006.0 |
| 2010-01-11 07:30:00 | ES | Futures | 1114.61 | 1115.1 | 1114.13 | 1114.13 | 7876.0 |
| 2010-01-11 08:00:00 | ES | Futures | 1114.13 | 1115.83 | 1114.13 | 1115.1 | 10811.0 |
| 2010-01-11 08:30:00 | ES | Futures | 1115.1 | 1115.34 | 1113.88 | 1114.86 | 13161.0 |
| 2010-01-11 09:00:00 | ES | Futures | 1114.86 | 1115.34 | 1114.37 | 1115.34 | 20455.0 |
| 2010-01-11 09:30:00 | ES | Futures | 1115.34 | 1115.83 | 1110.72 | 1111.21 | 193328.0 |
| 2010-01-11 10:00:00 | ES | Futures | 1110.96 | 1112.18 | 1108.53 | 1110.48 | 158308.0 |
| 2010-01-11 10:30:00 | ES | Futures | 1110.48 | 1111.69 | 1109.5 | 1110.96 | 105456.0 |
| 2010-01-11 11:00:00 | ES | Futures | 1110.72 | 1110.96 | 1107.56 | 1108.53 | 122776.0 |
| 2010-01-11 11:30:00 | ES | Futures | 1108.53 | 1110.48 | 1108.29 | 1110.48 | 66024.0 |
| 2010-01-11 12:00:00 | ES | Futures | 1110.48 | 1110.72 | 1109.5 | 1109.99 | 36342.0 |
| 2010-01-11 12:30:00 | ES | Futures | 1109.75 | 1110.23 | 1107.07 | 1108.29 | 90497.0 |
| 2010-01-11 13:00:00 | ES | Futures | 1108.53 | 1109.02 | 1107.8 | 1109.02 | 37547.0 |
| 2010-01-11 13:30:00 | ES | Futures | 1109.02 | 1110.23 | 1108.53 | 1109.99 | 44877.0 |
| 2010-01-11 14:00:00 | ES | Futures | 1109.75 | 1110.72 | 1109.02 | 1109.75 | 52213.0 |
| 2010-01-11 14:30:00 | ES | Futures | 1109.75 | 1110.48 | 1109.26 | 1109.99 | 52918.0 |
| 2010-01-11 15:00:00 | ES | Futures | 1109.99 | 1112.91 | 1109.99 | 1112.67 | 116868.0 |
| 2010-01-11 15:30:00 | ES | Futures | 1112.67 | 1113.4 | 1111.69 | 1112.18 | 135847.0 |
| 2010-01-11 16:00:00 | ES | Futures | 1111.94 | 1112.42 | 1111.69 | 1111.69 | 72623.0 |
| 2010-01-11 16:30:00 | ES | Futures | 1110.48 | 1110.72 | 1108.77 | 1109.26 | 19237.0 |
| 2010-01-11 17:00:00 | ES | Futures | 1109.26 | 1109.75 | 1108.77 | 1109.75 | 3774.0 |
| 2010-01-11 18:00:00 | ES | Futures | 1109.5 | 1109.75 | 1109.02 | 1109.5 | 1920.0 |
| 2010-01-11 18:30:00 | ES | Futures | 1109.26 | 1109.5 | 1108.29 | 1108.77 | 3469.0 |
| 2010-01-11 19:00:00 | ES | Futures | 1109.02 | 1110.96 | 1108.77 | 1110.72 | 3202.0 |
| 2010-01-11 19:30:00 | ES | Futures | 1110.96 | 1111.21 | 1110.48 | 1110.96 | 2813.0 |
| 2010-01-11 20:00:00 | ES | Futures | 1110.96 | 1111.21 | 1109.75 | 1110.48 | 2941.0 |
| 2010-01-11 20:30:00 | ES | Futures | 1110.48 | 1110.96 | 1109.75 | 1109.75 | 1708.0 |
| 2010-01-11 21:00:00 | ES | Futures | 1109.99 | 1109.99 | 1107.8 | 1108.53 | 6980.0 |
| 2010-01-11 21:30:00 | ES | Futures | 1108.53 | 1108.77 | 1107.56 | 1108.53 | 2479.0 |
| 2010-01-11 22:00:00 | ES | Futures | 1108.53 | 1108.77 | 1108.29 | 1108.53 | 763.0 |
| 2010-01-11 22:30:00 | ES | Futures | 1108.77 | 1109.5 | 1108.29 | 1108.77 | 1816.0 |
| 2010-01-11 23:00:00 | ES | Futures | 1108.77 | 1109.02 | 1108.29 | 1108.77 | 647.0 |
| 2010-01-11 23:30:00 | ES | Futures | 1108.77 | 1109.02 | 1108.53 | 1108.53 | 753.0 |
| 2010-01-11 00:00:00 | NQ | Futures | 2169.64 | 2169.92 | 2169.07 | 2169.07 | 20.0 |
| 2010-01-11 00:30:00 | NQ | Futures | 2169.35 | 2169.35 | 2168.21 | 2168.21 | 25.0 |
| 2010-01-11 01:00:00 | NQ | Futures | 2168.21 | 2168.5 | 2166.5 | 2166.78 | 131.0 |
> showing 50 of 2,499 rows — these rows as CSV