PREVIEW / futures_30min / 2010-04-26
file: by_date/futures_30min/2010/2010-04-26.parquet size: 68 KB rows: 2,543
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-26 00:00:00 | ES | Futures | 1186.69 | 1186.93 | 1186.45 | 1186.45 | 1075.0 |
| 2010-04-26 00:30:00 | ES | Futures | 1186.2 | 1186.45 | 1185.47 | 1185.71 | 3530.0 |
| 2010-04-26 01:00:00 | ES | Futures | 1185.96 | 1186.93 | 1185.47 | 1186.93 | 2069.0 |
| 2010-04-26 01:30:00 | ES | Futures | 1186.69 | 1187.18 | 1186.45 | 1186.69 | 1556.0 |
| 2010-04-26 02:00:00 | ES | Futures | 1186.45 | 1188.4 | 1186.2 | 1187.18 | 9350.0 |
| 2010-04-26 02:30:00 | ES | Futures | 1187.18 | 1187.42 | 1185.96 | 1186.93 | 5079.0 |
| 2010-04-26 03:00:00 | ES | Futures | 1186.93 | 1188.4 | 1186.69 | 1188.4 | 12363.0 |
| 2010-04-26 03:30:00 | ES | Futures | 1188.4 | 1189.62 | 1187.91 | 1188.16 | 12692.0 |
| 2010-04-26 04:00:00 | ES | Futures | 1188.16 | 1188.64 | 1187.42 | 1187.67 | 10140.0 |
| 2010-04-26 04:30:00 | ES | Futures | 1187.67 | 1188.4 | 1187.42 | 1187.67 | 5168.0 |
| 2010-04-26 05:00:00 | ES | Futures | 1187.91 | 1187.91 | 1186.2 | 1186.45 | 10258.0 |
| 2010-04-26 05:30:00 | ES | Futures | 1186.2 | 1186.45 | 1185.47 | 1185.96 | 7030.0 |
| 2010-04-26 06:00:00 | ES | Futures | 1185.96 | 1187.18 | 1185.22 | 1186.93 | 9465.0 |
| 2010-04-26 06:30:00 | ES | Futures | 1187.18 | 1187.42 | 1186.69 | 1187.18 | 4116.0 |
| 2010-04-26 07:00:00 | ES | Futures | 1187.18 | 1188.4 | 1186.93 | 1187.42 | 7529.0 |
| 2010-04-26 07:30:00 | ES | Futures | 1187.18 | 1187.91 | 1186.45 | 1187.18 | 25875.0 |
| 2010-04-26 08:00:00 | ES | Futures | 1187.18 | 1188.4 | 1187.18 | 1187.67 | 27419.0 |
| 2010-04-26 08:30:00 | ES | Futures | 1187.67 | 1187.67 | 1185.71 | 1187.18 | 20937.0 |
| 2010-04-26 09:00:00 | ES | Futures | 1187.18 | 1187.42 | 1185.96 | 1186.45 | 26771.0 |
| 2010-04-26 09:30:00 | ES | Futures | 1186.45 | 1189.13 | 1185.22 | 1185.71 | 212485.0 |
| 2010-04-26 10:00:00 | ES | Futures | 1185.71 | 1188.16 | 1184.49 | 1185.71 | 161262.0 |
| 2010-04-26 10:30:00 | ES | Futures | 1185.96 | 1188.4 | 1184.73 | 1187.67 | 128330.0 |
| 2010-04-26 11:00:00 | ES | Futures | 1187.91 | 1189.38 | 1187.18 | 1187.67 | 71606.0 |
| 2010-04-26 11:30:00 | ES | Futures | 1187.67 | 1187.91 | 1185.22 | 1185.71 | 74459.0 |
| 2010-04-26 12:00:00 | ES | Futures | 1185.47 | 1186.45 | 1184.49 | 1185.22 | 83093.0 |
| 2010-04-26 12:30:00 | ES | Futures | 1185.47 | 1186.69 | 1184.98 | 1186.45 | 47127.0 |
| 2010-04-26 13:00:00 | ES | Futures | 1186.45 | 1186.69 | 1185.47 | 1185.71 | 31764.0 |
| 2010-04-26 13:30:00 | ES | Futures | 1185.71 | 1185.96 | 1184.25 | 1185.22 | 69644.0 |
| 2010-04-26 14:00:00 | ES | Futures | 1184.98 | 1186.93 | 1184.25 | 1186.45 | 60708.0 |
| 2010-04-26 14:30:00 | ES | Futures | 1186.69 | 1186.69 | 1184.0 | 1184.0 | 55024.0 |
| 2010-04-26 15:00:00 | ES | Futures | 1184.0 | 1184.98 | 1180.58 | 1182.05 | 142017.0 |
| 2010-04-26 15:30:00 | ES | Futures | 1182.05 | 1183.76 | 1181.07 | 1181.56 | 163659.0 |
| 2010-04-26 16:00:00 | ES | Futures | 1181.56 | 1182.29 | 1180.58 | 1180.58 | 90752.0 |
| 2010-04-26 16:30:00 | ES | Futures | 1180.82 | 1181.56 | 1180.33 | 1181.07 | 6042.0 |
| 2010-04-26 17:00:00 | ES | Futures | 1181.07 | 1181.31 | 1179.6 | 1180.09 | 4692.0 |
| 2010-04-26 18:00:00 | ES | Futures | 1180.58 | 1181.31 | 1179.6 | 1181.07 | 5919.0 |
| 2010-04-26 18:30:00 | ES | Futures | 1181.07 | 1181.31 | 1180.33 | 1180.33 | 802.0 |
| 2010-04-26 19:00:00 | ES | Futures | 1180.58 | 1180.58 | 1179.85 | 1179.85 | 1648.0 |
| 2010-04-26 19:30:00 | ES | Futures | 1180.09 | 1181.31 | 1179.85 | 1180.82 | 2397.0 |
| 2010-04-26 20:00:00 | ES | Futures | 1180.82 | 1182.05 | 1180.58 | 1181.56 | 3164.0 |
| 2010-04-26 20:30:00 | ES | Futures | 1181.56 | 1182.05 | 1181.31 | 1182.05 | 1757.0 |
| 2010-04-26 21:00:00 | ES | Futures | 1181.8 | 1182.78 | 1181.8 | 1182.29 | 3045.0 |
| 2010-04-26 21:30:00 | ES | Futures | 1182.53 | 1182.78 | 1182.05 | 1182.05 | 2479.0 |
| 2010-04-26 22:00:00 | ES | Futures | 1182.05 | 1182.29 | 1180.82 | 1181.31 | 3693.0 |
| 2010-04-26 22:30:00 | ES | Futures | 1181.31 | 1181.56 | 1180.58 | 1180.82 | 2026.0 |
| 2010-04-26 23:00:00 | ES | Futures | 1180.82 | 1181.8 | 1180.82 | 1181.8 | 1023.0 |
| 2010-04-26 23:30:00 | ES | Futures | 1181.8 | 1182.78 | 1181.56 | 1182.53 | 2325.0 |
| 2010-04-26 00:00:00 | NQ | Futures | 2353.7 | 2353.98 | 2353.41 | 2353.7 | 49.0 |
| 2010-04-26 00:30:00 | NQ | Futures | 2353.41 | 2353.41 | 2352.26 | 2352.26 | 174.0 |
| 2010-04-26 01:00:00 | NQ | Futures | 2352.26 | 2353.98 | 2351.69 | 2353.98 | 100.0 |
> showing 50 of 2,543 rows — these rows as CSV