PREVIEW / futures_30min / 2010-10-22
file: by_date/futures_30min/2010/2010-10-22.parquet size: 60 KB rows: 2,127
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-10-22 00:00:00 | ES | Futures | 1159.93 | 1160.67 | 1159.93 | 1160.42 | 477.0 |
| 2010-10-22 00:30:00 | ES | Futures | 1160.18 | 1161.9 | 1160.18 | 1161.41 | 1926.0 |
| 2010-10-22 01:00:00 | ES | Futures | 1161.65 | 1162.39 | 1161.41 | 1161.9 | 2011.0 |
| 2010-10-22 01:30:00 | ES | Futures | 1161.9 | 1162.39 | 1161.41 | 1161.9 | 1733.0 |
| 2010-10-22 02:00:00 | ES | Futures | 1161.9 | 1162.15 | 1161.41 | 1162.15 | 3035.0 |
| 2010-10-22 02:30:00 | ES | Futures | 1162.15 | 1162.15 | 1160.42 | 1160.92 | 4404.0 |
| 2010-10-22 03:00:00 | ES | Futures | 1160.67 | 1161.41 | 1158.45 | 1158.45 | 16495.0 |
| 2010-10-22 03:30:00 | ES | Futures | 1158.45 | 1159.44 | 1157.71 | 1158.94 | 15420.0 |
| 2010-10-22 04:00:00 | ES | Futures | 1159.19 | 1160.18 | 1156.73 | 1157.96 | 16537.0 |
| 2010-10-22 04:30:00 | ES | Futures | 1158.2 | 1158.2 | 1156.73 | 1157.71 | 9153.0 |
| 2010-10-22 05:00:00 | ES | Futures | 1157.71 | 1158.7 | 1157.46 | 1157.71 | 5282.0 |
| 2010-10-22 05:30:00 | ES | Futures | 1157.96 | 1158.45 | 1157.71 | 1158.2 | 4308.0 |
| 2010-10-22 06:00:00 | ES | Futures | 1158.2 | 1158.45 | 1157.71 | 1157.96 | 3509.0 |
| 2010-10-22 06:30:00 | ES | Futures | 1157.96 | 1160.42 | 1157.71 | 1160.18 | 7747.0 |
| 2010-10-22 07:00:00 | ES | Futures | 1160.18 | 1161.16 | 1159.44 | 1160.92 | 8075.0 |
| 2010-10-22 07:30:00 | ES | Futures | 1160.67 | 1162.89 | 1160.42 | 1162.39 | 20993.0 |
| 2010-10-22 08:00:00 | ES | Futures | 1162.64 | 1162.89 | 1160.92 | 1161.41 | 17043.0 |
| 2010-10-22 08:30:00 | ES | Futures | 1161.65 | 1163.63 | 1161.41 | 1163.38 | 27299.0 |
| 2010-10-22 09:00:00 | ES | Futures | 1163.38 | 1164.37 | 1161.65 | 1161.65 | 34176.0 |
| 2010-10-22 09:30:00 | ES | Futures | 1161.65 | 1164.12 | 1159.44 | 1159.93 | 199407.0 |
| 2010-10-22 10:00:00 | ES | Futures | 1159.93 | 1162.15 | 1158.94 | 1162.15 | 133356.0 |
| 2010-10-22 10:30:00 | ES | Futures | 1162.15 | 1162.89 | 1160.42 | 1162.15 | 82441.0 |
| 2010-10-22 11:00:00 | ES | Futures | 1161.9 | 1162.64 | 1159.93 | 1160.67 | 68979.0 |
| 2010-10-22 11:30:00 | ES | Futures | 1160.67 | 1162.15 | 1159.68 | 1160.18 | 56574.0 |
| 2010-10-22 12:00:00 | ES | Futures | 1160.18 | 1162.39 | 1159.93 | 1162.15 | 45064.0 |
| 2010-10-22 12:30:00 | ES | Futures | 1162.15 | 1162.39 | 1160.92 | 1161.65 | 26381.0 |
| 2010-10-22 13:00:00 | ES | Futures | 1161.65 | 1162.39 | 1160.67 | 1161.41 | 35379.0 |
| 2010-10-22 13:30:00 | ES | Futures | 1161.41 | 1161.65 | 1159.68 | 1159.93 | 25087.0 |
| 2010-10-22 14:00:00 | ES | Futures | 1159.93 | 1162.15 | 1159.68 | 1161.9 | 34702.0 |
| 2010-10-22 14:30:00 | ES | Futures | 1161.9 | 1161.9 | 1160.42 | 1160.92 | 40821.0 |
| 2010-10-22 15:00:00 | ES | Futures | 1160.92 | 1162.64 | 1160.18 | 1161.41 | 52374.0 |
| 2010-10-22 15:30:00 | ES | Futures | 1161.41 | 1163.13 | 1160.67 | 1162.64 | 104613.0 |
| 2010-10-22 16:00:00 | ES | Futures | 1162.39 | 1164.86 | 1162.39 | 1164.61 | 72750.0 |
| 2010-10-22 00:00:00 | NQ | Futures | 2391.33 | 2391.62 | 2390.76 | 2390.76 | 26.0 |
| 2010-10-22 00:30:00 | NQ | Futures | 2390.76 | 2393.34 | 2390.76 | 2393.34 | 167.0 |
| 2010-10-22 01:00:00 | NQ | Futures | 2393.34 | 2395.06 | 2393.34 | 2394.49 | 148.0 |
| 2010-10-22 01:30:00 | NQ | Futures | 2394.78 | 2394.78 | 2393.91 | 2394.78 | 56.0 |
| 2010-10-22 02:00:00 | NQ | Futures | 2394.2 | 2394.78 | 2393.63 | 2394.49 | 122.0 |
| 2010-10-22 02:30:00 | NQ | Futures | 2394.2 | 2394.78 | 2391.33 | 2392.19 | 198.0 |
| 2010-10-22 03:00:00 | NQ | Futures | 2391.91 | 2393.34 | 2387.03 | 2387.32 | 1106.0 |
| 2010-10-22 03:30:00 | NQ | Futures | 2387.03 | 2388.46 | 2385.02 | 2387.6 | 1108.0 |
| 2010-10-22 04:00:00 | NQ | Futures | 2387.89 | 2389.32 | 2383.59 | 2385.88 | 1294.0 |
| 2010-10-22 04:30:00 | NQ | Futures | 2385.88 | 2386.17 | 2383.87 | 2385.31 | 663.0 |
| 2010-10-22 05:00:00 | NQ | Futures | 2385.59 | 2387.89 | 2385.59 | 2387.03 | 461.0 |
| 2010-10-22 05:30:00 | NQ | Futures | 2387.32 | 2387.6 | 2386.46 | 2386.74 | 296.0 |
| 2010-10-22 06:00:00 | NQ | Futures | 2387.03 | 2388.46 | 2386.46 | 2387.32 | 375.0 |
| 2010-10-22 06:30:00 | NQ | Futures | 2387.32 | 2391.05 | 2387.32 | 2390.47 | 710.0 |
| 2010-10-22 07:00:00 | NQ | Futures | 2390.76 | 2393.34 | 2389.61 | 2392.77 | 1087.0 |
| 2010-10-22 07:30:00 | NQ | Futures | 2392.77 | 2397.07 | 2391.91 | 2395.92 | 1992.0 |
| 2010-10-22 08:00:00 | NQ | Futures | 2396.21 | 2397.36 | 2393.91 | 2395.35 | 1950.0 |
> showing 50 of 2,127 rows — these rows as CSV