PREVIEW / futures_30min / 2010-04-07
file: by_date/futures_30min/2010/2010-04-07.parquet size: 71 KB rows: 2,556
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-07 00:00:00 | ES | Futures | 1157.36 | 1157.6 | 1156.87 | 1157.36 | 1304.0 |
| 2010-04-07 00:30:00 | ES | Futures | 1157.6 | 1157.6 | 1157.11 | 1157.6 | 492.0 |
| 2010-04-07 01:00:00 | ES | Futures | 1157.36 | 1157.6 | 1156.87 | 1156.87 | 1259.0 |
| 2010-04-07 01:30:00 | ES | Futures | 1156.87 | 1157.36 | 1156.63 | 1156.87 | 2064.0 |
| 2010-04-07 02:00:00 | ES | Futures | 1156.87 | 1157.6 | 1156.63 | 1156.87 | 2407.0 |
| 2010-04-07 02:30:00 | ES | Futures | 1156.63 | 1157.36 | 1156.63 | 1156.87 | 2547.0 |
| 2010-04-07 03:00:00 | ES | Futures | 1157.11 | 1157.36 | 1156.14 | 1156.63 | 9552.0 |
| 2010-04-07 03:30:00 | ES | Futures | 1156.63 | 1156.63 | 1155.4 | 1156.38 | 7217.0 |
| 2010-04-07 04:00:00 | ES | Futures | 1156.38 | 1156.63 | 1155.16 | 1155.89 | 6696.0 |
| 2010-04-07 04:30:00 | ES | Futures | 1155.89 | 1156.14 | 1155.4 | 1155.65 | 4057.0 |
| 2010-04-07 05:00:00 | ES | Futures | 1155.89 | 1157.36 | 1155.4 | 1157.11 | 5344.0 |
| 2010-04-07 05:30:00 | ES | Futures | 1157.11 | 1157.6 | 1157.11 | 1157.11 | 2562.0 |
| 2010-04-07 06:00:00 | ES | Futures | 1157.11 | 1157.36 | 1156.63 | 1156.87 | 3129.0 |
| 2010-04-07 06:30:00 | ES | Futures | 1156.87 | 1157.6 | 1156.14 | 1156.38 | 4110.0 |
| 2010-04-07 07:00:00 | ES | Futures | 1156.38 | 1156.63 | 1155.65 | 1156.14 | 5229.0 |
| 2010-04-07 07:30:00 | ES | Futures | 1156.14 | 1156.38 | 1155.16 | 1155.4 | 15142.0 |
| 2010-04-07 08:00:00 | ES | Futures | 1155.4 | 1155.89 | 1153.69 | 1154.43 | 35589.0 |
| 2010-04-07 08:30:00 | ES | Futures | 1154.18 | 1155.89 | 1153.94 | 1155.89 | 21701.0 |
| 2010-04-07 09:00:00 | ES | Futures | 1155.89 | 1157.11 | 1155.4 | 1156.87 | 29174.0 |
| 2010-04-07 09:30:00 | ES | Futures | 1156.87 | 1158.58 | 1155.16 | 1157.11 | 160049.0 |
| 2010-04-07 10:00:00 | ES | Futures | 1157.11 | 1158.34 | 1155.65 | 1157.36 | 97937.0 |
| 2010-04-07 10:30:00 | ES | Futures | 1157.11 | 1157.6 | 1152.71 | 1154.18 | 207846.0 |
| 2010-04-07 11:00:00 | ES | Futures | 1153.94 | 1157.11 | 1152.47 | 1156.63 | 160140.0 |
| 2010-04-07 11:30:00 | ES | Futures | 1156.63 | 1157.11 | 1155.16 | 1156.38 | 82058.0 |
| 2010-04-07 12:00:00 | ES | Futures | 1156.14 | 1156.87 | 1155.4 | 1155.4 | 43791.0 |
| 2010-04-07 12:30:00 | ES | Futures | 1155.65 | 1156.87 | 1155.16 | 1156.87 | 36452.0 |
| 2010-04-07 13:00:00 | ES | Futures | 1156.87 | 1159.8 | 1156.63 | 1159.07 | 113457.0 |
| 2010-04-07 13:30:00 | ES | Futures | 1159.07 | 1159.07 | 1156.63 | 1157.85 | 81085.0 |
| 2010-04-07 14:00:00 | ES | Futures | 1158.09 | 1158.09 | 1154.18 | 1154.91 | 118916.0 |
| 2010-04-07 14:30:00 | ES | Futures | 1154.91 | 1155.16 | 1152.23 | 1153.2 | 175340.0 |
| 2010-04-07 15:00:00 | ES | Futures | 1153.2 | 1153.2 | 1147.09 | 1149.78 | 350815.0 |
| 2010-04-07 15:30:00 | ES | Futures | 1149.78 | 1152.96 | 1148.8 | 1152.96 | 220484.0 |
| 2010-04-07 16:00:00 | ES | Futures | 1152.96 | 1153.2 | 1152.23 | 1152.23 | 111173.0 |
| 2010-04-07 16:30:00 | ES | Futures | 1152.23 | 1152.96 | 1151.74 | 1152.47 | 4065.0 |
| 2010-04-07 17:00:00 | ES | Futures | 1152.47 | 1152.96 | 1151.74 | 1151.74 | 2006.0 |
| 2010-04-07 18:00:00 | ES | Futures | 1152.23 | 1152.71 | 1151.98 | 1152.23 | 1147.0 |
| 2010-04-07 18:30:00 | ES | Futures | 1152.23 | 1152.71 | 1151.74 | 1151.74 | 874.0 |
| 2010-04-07 19:00:00 | ES | Futures | 1151.74 | 1151.74 | 1151.0 | 1151.25 | 2441.0 |
| 2010-04-07 19:30:00 | ES | Futures | 1151.25 | 1151.25 | 1150.76 | 1151.0 | 1188.0 |
| 2010-04-07 20:00:00 | ES | Futures | 1151.0 | 1151.25 | 1150.51 | 1151.0 | 1886.0 |
| 2010-04-07 20:30:00 | ES | Futures | 1151.0 | 1151.0 | 1150.27 | 1150.76 | 1731.0 |
| 2010-04-07 21:00:00 | ES | Futures | 1150.51 | 1151.0 | 1150.51 | 1150.76 | 1039.0 |
| 2010-04-07 21:30:00 | ES | Futures | 1150.76 | 1151.0 | 1149.78 | 1150.03 | 2621.0 |
| 2010-04-07 22:00:00 | ES | Futures | 1150.03 | 1150.76 | 1149.78 | 1150.27 | 2034.0 |
| 2010-04-07 22:30:00 | ES | Futures | 1150.51 | 1151.25 | 1150.03 | 1151.0 | 1696.0 |
| 2010-04-07 23:00:00 | ES | Futures | 1150.76 | 1151.0 | 1150.51 | 1150.51 | 683.0 |
| 2010-04-07 23:30:00 | ES | Futures | 1150.51 | 1150.51 | 1149.54 | 1149.54 | 1723.0 |
| 2010-04-07 00:00:00 | NQ | Futures | 2263.78 | 2264.06 | 2262.92 | 2263.49 | 46.0 |
| 2010-04-07 00:30:00 | NQ | Futures | 2263.2 | 2264.06 | 2263.2 | 2264.06 | 35.0 |
| 2010-04-07 01:00:00 | NQ | Futures | 2264.06 | 2264.06 | 2263.2 | 2263.2 | 154.0 |
> showing 50 of 2,556 rows — these rows as CSV