PREVIEW / futures_30min / 2010-03-19
file: by_date/futures_30min/2010/2010-03-19.parquet size: 58 KB rows: 1,997
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-03-19 00:00:00 | ES | Futures | 1135.36 | 1135.6 | 1135.36 | 1135.36 | 295.0 |
| 2010-03-19 00:30:00 | ES | Futures | 1135.36 | 1135.85 | 1135.12 | 1135.6 | 881.0 |
| 2010-03-19 01:00:00 | ES | Futures | 1135.36 | 1136.09 | 1135.36 | 1135.6 | 614.0 |
| 2010-03-19 01:30:00 | ES | Futures | 1135.6 | 1135.85 | 1135.12 | 1135.36 | 795.0 |
| 2010-03-19 02:00:00 | ES | Futures | 1135.36 | 1135.6 | 1135.12 | 1135.36 | 515.0 |
| 2010-03-19 02:30:00 | ES | Futures | 1135.12 | 1136.09 | 1135.12 | 1136.09 | 822.0 |
| 2010-03-19 03:00:00 | ES | Futures | 1135.85 | 1136.34 | 1135.36 | 1136.09 | 2432.0 |
| 2010-03-19 03:30:00 | ES | Futures | 1136.09 | 1136.34 | 1135.6 | 1135.85 | 2410.0 |
| 2010-03-19 04:00:00 | ES | Futures | 1135.85 | 1136.58 | 1135.12 | 1136.34 | 7034.0 |
| 2010-03-19 04:30:00 | ES | Futures | 1136.34 | 1136.58 | 1134.38 | 1135.12 | 7009.0 |
| 2010-03-19 05:00:00 | ES | Futures | 1135.12 | 1135.6 | 1133.89 | 1135.36 | 6664.0 |
| 2010-03-19 05:30:00 | ES | Futures | 1135.6 | 1136.09 | 1134.87 | 1135.12 | 5445.0 |
| 2010-03-19 06:00:00 | ES | Futures | 1135.12 | 1136.83 | 1134.63 | 1136.09 | 8104.0 |
| 2010-03-19 06:30:00 | ES | Futures | 1136.34 | 1136.58 | 1135.85 | 1136.34 | 9835.0 |
| 2010-03-19 07:00:00 | ES | Futures | 1136.34 | 1136.58 | 1134.87 | 1135.12 | 7966.0 |
| 2010-03-19 07:30:00 | ES | Futures | 1135.12 | 1135.85 | 1134.38 | 1135.6 | 8659.0 |
| 2010-03-19 08:00:00 | ES | Futures | 1135.6 | 1136.58 | 1135.36 | 1135.85 | 20345.0 |
| 2010-03-19 08:30:00 | ES | Futures | 1136.09 | 1137.56 | 1135.36 | 1137.56 | 29543.0 |
| 2010-03-19 09:00:00 | ES | Futures | 1137.32 | 1139.03 | 1136.34 | 1138.78 | 80540.0 |
| 2010-03-19 09:30:00 | ES | Futures | 1138.78 | 1139.03 | 1134.63 | 1135.6 | 269691.0 |
| 2010-03-19 10:00:00 | ES | Futures | 1135.85 | 1135.85 | 1129.98 | 1130.96 | 239116.0 |
| 2010-03-19 10:30:00 | ES | Futures | 1130.96 | 1131.45 | 1128.76 | 1129.98 | 161582.0 |
| 2010-03-19 11:00:00 | ES | Futures | 1130.23 | 1130.47 | 1126.32 | 1127.54 | 200246.0 |
| 2010-03-19 11:30:00 | ES | Futures | 1127.29 | 1129.25 | 1126.56 | 1128.76 | 103706.0 |
| 2010-03-19 12:00:00 | ES | Futures | 1128.52 | 1129.49 | 1126.81 | 1128.03 | 95010.0 |
| 2010-03-19 12:30:00 | ES | Futures | 1128.03 | 1128.76 | 1127.29 | 1128.03 | 53231.0 |
| 2010-03-19 13:00:00 | ES | Futures | 1128.03 | 1129.25 | 1127.78 | 1128.76 | 34652.0 |
| 2010-03-19 13:30:00 | ES | Futures | 1128.76 | 1128.76 | 1126.81 | 1128.76 | 59713.0 |
| 2010-03-19 14:00:00 | ES | Futures | 1128.52 | 1130.47 | 1128.03 | 1129.98 | 82043.0 |
| 2010-03-19 14:30:00 | ES | Futures | 1129.98 | 1129.98 | 1127.78 | 1128.03 | 72364.0 |
| 2010-03-19 15:00:00 | ES | Futures | 1128.03 | 1129.0 | 1127.78 | 1128.03 | 53057.0 |
| 2010-03-19 15:30:00 | ES | Futures | 1127.78 | 1129.25 | 1124.61 | 1129.25 | 339206.0 |
| 2010-03-19 16:00:00 | ES | Futures | 1129.0 | 1130.96 | 1128.76 | 1130.47 | 141202.0 |
| 2010-03-19 00:00:00 | NQ | Futures | 2223.11 | 2223.68 | 2223.11 | 2223.4 | 22.0 |
| 2010-03-19 00:30:00 | NQ | Futures | 2223.4 | 2223.97 | 2223.4 | 2223.97 | 46.0 |
| 2010-03-19 01:00:00 | NQ | Futures | 2223.68 | 2224.26 | 2223.11 | 2223.97 | 62.0 |
| 2010-03-19 01:30:00 | NQ | Futures | 2223.97 | 2224.26 | 2223.11 | 2223.4 | 33.0 |
| 2010-03-19 02:00:00 | NQ | Futures | 2223.68 | 2224.26 | 2223.68 | 2223.97 | 55.0 |
| 2010-03-19 02:30:00 | NQ | Futures | 2223.97 | 2224.54 | 2223.68 | 2224.26 | 37.0 |
| 2010-03-19 03:00:00 | NQ | Futures | 2224.26 | 2224.26 | 2223.11 | 2224.26 | 204.0 |
| 2010-03-19 03:30:00 | NQ | Futures | 2224.26 | 2224.26 | 2223.11 | 2223.68 | 161.0 |
| 2010-03-19 04:00:00 | NQ | Futures | 2223.68 | 2224.83 | 2222.82 | 2224.26 | 730.0 |
| 2010-03-19 04:30:00 | NQ | Futures | 2224.54 | 2224.83 | 2221.39 | 2222.54 | 496.0 |
| 2010-03-19 05:00:00 | NQ | Futures | 2222.54 | 2223.4 | 2220.82 | 2222.54 | 800.0 |
| 2010-03-19 05:30:00 | NQ | Futures | 2222.82 | 2224.54 | 2221.96 | 2222.25 | 616.0 |
| 2010-03-19 06:00:00 | NQ | Futures | 2222.54 | 2225.69 | 2221.96 | 2224.54 | 823.0 |
| 2010-03-19 06:30:00 | NQ | Futures | 2224.54 | 2225.69 | 2223.97 | 2225.4 | 661.0 |
| 2010-03-19 07:00:00 | NQ | Futures | 2225.4 | 2225.69 | 2223.68 | 2224.26 | 562.0 |
| 2010-03-19 07:30:00 | NQ | Futures | 2224.26 | 2225.69 | 2222.82 | 2225.4 | 834.0 |
| 2010-03-19 08:00:00 | NQ | Futures | 2225.4 | 2226.55 | 2225.12 | 2226.26 | 1837.0 |
> showing 50 of 1,997 rows — these rows as CSV