PREVIEW / futures_30min / 2010-04-01
file: by_date/futures_30min/2010/2010-04-01.parquet size: 64 KB rows: 2,334
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-04-01 00:00:00 | ES | Futures | 1140.98 | 1142.45 | 1140.98 | 1142.2 | 2004.0 |
| 2010-04-01 00:30:00 | ES | Futures | 1142.2 | 1143.43 | 1142.2 | 1143.18 | 3441.0 |
| 2010-04-01 01:00:00 | ES | Futures | 1143.18 | 1143.43 | 1142.2 | 1142.94 | 3284.0 |
| 2010-04-01 01:30:00 | ES | Futures | 1142.94 | 1143.43 | 1142.69 | 1142.94 | 1025.0 |
| 2010-04-01 02:00:00 | ES | Futures | 1142.94 | 1143.43 | 1142.2 | 1142.94 | 4061.0 |
| 2010-04-01 02:30:00 | ES | Futures | 1142.69 | 1143.67 | 1142.2 | 1142.94 | 4738.0 |
| 2010-04-01 03:00:00 | ES | Futures | 1143.18 | 1144.65 | 1142.69 | 1143.67 | 10524.0 |
| 2010-04-01 03:30:00 | ES | Futures | 1143.43 | 1145.63 | 1143.43 | 1145.38 | 11402.0 |
| 2010-04-01 04:00:00 | ES | Futures | 1145.14 | 1145.63 | 1144.65 | 1145.38 | 8136.0 |
| 2010-04-01 04:30:00 | ES | Futures | 1145.38 | 1145.87 | 1144.4 | 1145.87 | 10594.0 |
| 2010-04-01 05:00:00 | ES | Futures | 1145.63 | 1145.87 | 1144.4 | 1144.89 | 6572.0 |
| 2010-04-01 05:30:00 | ES | Futures | 1144.65 | 1144.89 | 1144.16 | 1144.4 | 4774.0 |
| 2010-04-01 06:00:00 | ES | Futures | 1144.65 | 1144.65 | 1144.16 | 1144.4 | 2944.0 |
| 2010-04-01 06:30:00 | ES | Futures | 1144.4 | 1144.4 | 1143.67 | 1144.16 | 4508.0 |
| 2010-04-01 07:00:00 | ES | Futures | 1144.16 | 1144.89 | 1143.67 | 1144.4 | 8154.0 |
| 2010-04-01 07:30:00 | ES | Futures | 1144.4 | 1144.89 | 1144.16 | 1144.4 | 7935.0 |
| 2010-04-01 08:00:00 | ES | Futures | 1144.16 | 1145.38 | 1143.91 | 1144.4 | 18261.0 |
| 2010-04-01 08:30:00 | ES | Futures | 1144.65 | 1147.09 | 1144.16 | 1146.11 | 41996.0 |
| 2010-04-01 09:00:00 | ES | Futures | 1146.36 | 1147.34 | 1145.87 | 1147.09 | 31208.0 |
| 2010-04-01 09:30:00 | ES | Futures | 1147.09 | 1151.0 | 1146.85 | 1149.54 | 240209.0 |
| 2010-04-01 10:00:00 | ES | Futures | 1149.78 | 1151.25 | 1147.58 | 1149.05 | 183133.0 |
| 2010-04-01 10:30:00 | ES | Futures | 1148.8 | 1150.03 | 1146.6 | 1147.58 | 124689.0 |
| 2010-04-01 11:00:00 | ES | Futures | 1147.58 | 1148.31 | 1146.11 | 1148.31 | 114236.0 |
| 2010-04-01 11:30:00 | ES | Futures | 1148.31 | 1149.54 | 1147.83 | 1148.31 | 73026.0 |
| 2010-04-01 12:00:00 | ES | Futures | 1148.56 | 1148.8 | 1147.34 | 1147.83 | 43566.0 |
| 2010-04-01 12:30:00 | ES | Futures | 1147.58 | 1148.31 | 1147.09 | 1147.58 | 47261.0 |
| 2010-04-01 13:00:00 | ES | Futures | 1147.58 | 1148.07 | 1147.09 | 1147.83 | 30320.0 |
| 2010-04-01 13:30:00 | ES | Futures | 1148.07 | 1148.56 | 1143.91 | 1144.65 | 127408.0 |
| 2010-04-01 14:00:00 | ES | Futures | 1144.89 | 1145.63 | 1142.94 | 1143.67 | 126819.0 |
| 2010-04-01 14:30:00 | ES | Futures | 1143.67 | 1144.65 | 1140.25 | 1143.18 | 220140.0 |
| 2010-04-01 15:00:00 | ES | Futures | 1143.18 | 1144.4 | 1142.2 | 1143.67 | 98372.0 |
| 2010-04-01 15:30:00 | ES | Futures | 1143.43 | 1147.58 | 1143.43 | 1147.34 | 171711.0 |
| 2010-04-01 16:00:00 | ES | Futures | 1147.34 | 1147.83 | 1146.85 | 1147.58 | 105633.0 |
| 2010-04-01 16:30:00 | ES | Futures | 1147.34 | 1147.83 | 1147.09 | 1147.58 | 3414.0 |
| 2010-04-01 17:00:00 | ES | Futures | 1147.58 | 1148.8 | 1147.34 | 1148.56 | 2693.0 |
| 2010-04-01 18:00:00 | ES | Futures | 1148.31 | 1148.31 | 1147.34 | 1147.83 | 1185.0 |
| 2010-04-01 18:30:00 | ES | Futures | 1147.83 | 1148.07 | 1147.34 | 1147.58 | 695.0 |
| 2010-04-01 19:00:00 | ES | Futures | 1147.58 | 1147.83 | 1147.58 | 1147.83 | 252.0 |
| 2010-04-01 19:30:00 | ES | Futures | 1147.58 | 1147.83 | 1146.36 | 1146.85 | 1546.0 |
| 2010-04-01 20:00:00 | ES | Futures | 1146.6 | 1146.6 | 1145.14 | 1145.63 | 2092.0 |
| 2010-04-01 20:30:00 | ES | Futures | 1145.63 | 1145.87 | 1145.38 | 1145.63 | 586.0 |
| 2010-04-01 21:00:00 | ES | Futures | 1145.63 | 1145.87 | 1144.65 | 1144.89 | 1801.0 |
| 2010-04-01 21:30:00 | ES | Futures | 1144.89 | 1145.38 | 1144.4 | 1145.14 | 931.0 |
| 2010-04-01 22:00:00 | ES | Futures | 1145.14 | 1145.14 | 1144.65 | 1145.14 | 579.0 |
| 2010-04-01 22:30:00 | ES | Futures | 1145.14 | 1145.14 | 1144.65 | 1145.14 | 217.0 |
| 2010-04-01 23:00:00 | ES | Futures | 1145.14 | 1145.38 | 1144.89 | 1145.14 | 296.0 |
| 2010-04-01 23:30:00 | ES | Futures | 1145.38 | 1145.63 | 1144.89 | 1145.14 | 421.0 |
| 2010-04-01 00:00:00 | NQ | Futures | 2242.58 | 2244.02 | 2242.58 | 2244.02 | 90.0 |
| 2010-04-01 00:30:00 | NQ | Futures | 2243.73 | 2246.02 | 2243.73 | 2245.73 | 275.0 |
| 2010-04-01 01:00:00 | NQ | Futures | 2245.73 | 2246.59 | 2244.59 | 2246.31 | 246.0 |
> showing 50 of 2,334 rows — these rows as CSV