PREVIEW / futures_30min / 2010-10-29
file: by_date/futures_30min/2010/2010-10-29.parquet size: 63 KB rows: 2,148
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-29 00:00:00 | ES | Futures | 1158.94 | 1159.44 | 1158.45 | 1158.7 | 1435.0 |
| 2010-10-29 00:30:00 | ES | Futures | 1158.7 | 1159.19 | 1157.96 | 1157.96 | 1041.0 |
| 2010-10-29 01:00:00 | ES | Futures | 1158.2 | 1159.19 | 1157.96 | 1158.45 | 2801.0 |
| 2010-10-29 01:30:00 | ES | Futures | 1158.45 | 1158.94 | 1157.96 | 1157.96 | 2218.0 |
| 2010-10-29 02:00:00 | ES | Futures | 1157.96 | 1158.2 | 1157.46 | 1157.96 | 3161.0 |
| 2010-10-29 02:30:00 | ES | Futures | 1157.71 | 1159.68 | 1157.71 | 1158.94 | 6497.0 |
| 2010-10-29 03:00:00 | ES | Futures | 1158.94 | 1160.18 | 1157.46 | 1159.93 | 15698.0 |
| 2010-10-29 03:30:00 | ES | Futures | 1159.68 | 1160.67 | 1159.44 | 1159.68 | 11437.0 |
| 2010-10-29 04:00:00 | ES | Futures | 1159.44 | 1159.68 | 1157.46 | 1157.96 | 12768.0 |
| 2010-10-29 04:30:00 | ES | Futures | 1157.96 | 1158.2 | 1155.74 | 1156.73 | 17295.0 |
| 2010-10-29 05:00:00 | ES | Futures | 1156.97 | 1157.71 | 1155.49 | 1155.99 | 9769.0 |
| 2010-10-29 05:30:00 | ES | Futures | 1155.99 | 1156.97 | 1155.99 | 1156.23 | 6859.0 |
| 2010-10-29 06:00:00 | ES | Futures | 1156.23 | 1157.71 | 1155.74 | 1157.71 | 6586.0 |
| 2010-10-29 06:30:00 | ES | Futures | 1157.46 | 1158.7 | 1157.22 | 1158.45 | 7474.0 |
| 2010-10-29 07:00:00 | ES | Futures | 1158.2 | 1158.2 | 1156.48 | 1156.73 | 12456.0 |
| 2010-10-29 07:30:00 | ES | Futures | 1156.48 | 1158.45 | 1155.99 | 1157.96 | 12463.0 |
| 2010-10-29 08:00:00 | ES | Futures | 1157.96 | 1159.19 | 1157.46 | 1157.96 | 18135.0 |
| 2010-10-29 08:30:00 | ES | Futures | 1157.96 | 1162.64 | 1155.74 | 1161.41 | 58059.0 |
| 2010-10-29 09:00:00 | ES | Futures | 1161.65 | 1162.39 | 1159.93 | 1161.41 | 36476.0 |
| 2010-10-29 09:30:00 | ES | Futures | 1161.65 | 1164.12 | 1159.93 | 1160.42 | 174690.0 |
| 2010-10-29 10:00:00 | ES | Futures | 1160.67 | 1165.85 | 1159.68 | 1164.37 | 179925.0 |
| 2010-10-29 10:30:00 | ES | Futures | 1164.37 | 1164.37 | 1161.16 | 1163.38 | 104785.0 |
| 2010-10-29 11:00:00 | ES | Futures | 1163.63 | 1164.61 | 1162.39 | 1162.64 | 72465.0 |
| 2010-10-29 11:30:00 | ES | Futures | 1162.64 | 1162.89 | 1159.19 | 1161.65 | 176966.0 |
| 2010-10-29 12:00:00 | ES | Futures | 1161.41 | 1163.87 | 1161.41 | 1163.38 | 97365.0 |
| 2010-10-29 12:30:00 | ES | Futures | 1163.38 | 1164.37 | 1162.64 | 1163.87 | 54320.0 |
| 2010-10-29 13:00:00 | ES | Futures | 1163.63 | 1164.12 | 1162.39 | 1163.87 | 39365.0 |
| 2010-10-29 13:30:00 | ES | Futures | 1163.87 | 1165.35 | 1162.89 | 1164.86 | 61825.0 |
| 2010-10-29 14:00:00 | ES | Futures | 1164.86 | 1165.85 | 1163.87 | 1163.87 | 60938.0 |
| 2010-10-29 14:30:00 | ES | Futures | 1164.12 | 1164.37 | 1162.15 | 1162.39 | 62445.0 |
| 2010-10-29 15:00:00 | ES | Futures | 1162.39 | 1164.37 | 1161.9 | 1163.63 | 83611.0 |
| 2010-10-29 15:30:00 | ES | Futures | 1163.87 | 1165.6 | 1163.13 | 1163.63 | 192080.0 |
| 2010-10-29 16:00:00 | ES | Futures | 1163.63 | 1163.87 | 1161.9 | 1163.87 | 109126.0 |
| 2010-10-29 00:00:00 | NQ | Futures | 2433.51 | 2435.23 | 2433.51 | 2434.94 | 150.0 |
| 2010-10-29 00:30:00 | NQ | Futures | 2434.08 | 2434.94 | 2433.51 | 2433.51 | 36.0 |
| 2010-10-29 01:00:00 | NQ | Futures | 2433.79 | 2435.23 | 2433.51 | 2434.37 | 82.0 |
| 2010-10-29 01:30:00 | NQ | Futures | 2434.37 | 2434.94 | 2433.22 | 2433.22 | 27.0 |
| 2010-10-29 02:00:00 | NQ | Futures | 2433.22 | 2434.37 | 2432.65 | 2433.51 | 212.0 |
| 2010-10-29 02:30:00 | NQ | Futures | 2433.51 | 2436.09 | 2433.51 | 2434.65 | 375.0 |
| 2010-10-29 03:00:00 | NQ | Futures | 2434.65 | 2437.24 | 2432.93 | 2436.38 | 1004.0 |
| 2010-10-29 03:30:00 | NQ | Futures | 2436.38 | 2437.52 | 2435.52 | 2436.38 | 515.0 |
| 2010-10-29 04:00:00 | NQ | Futures | 2435.8 | 2436.09 | 2432.36 | 2432.65 | 446.0 |
| 2010-10-29 04:30:00 | NQ | Futures | 2433.22 | 2433.22 | 2429.2 | 2431.21 | 933.0 |
| 2010-10-29 05:00:00 | NQ | Futures | 2431.5 | 2432.93 | 2429.78 | 2429.78 | 317.0 |
| 2010-10-29 05:30:00 | NQ | Futures | 2430.06 | 2431.5 | 2429.49 | 2430.06 | 494.0 |
| 2010-10-29 06:00:00 | NQ | Futures | 2429.78 | 2432.65 | 2429.78 | 2432.65 | 415.0 |
| 2010-10-29 06:30:00 | NQ | Futures | 2432.65 | 2434.94 | 2432.36 | 2434.65 | 488.0 |
| 2010-10-29 07:00:00 | NQ | Futures | 2434.37 | 2434.37 | 2432.07 | 2432.07 | 973.0 |
| 2010-10-29 07:30:00 | NQ | Futures | 2432.36 | 2434.37 | 2431.21 | 2433.79 | 663.0 |
| 2010-10-29 08:00:00 | NQ | Futures | 2433.51 | 2436.66 | 2432.93 | 2432.93 | 2784.0 |
> showing 50 of 2,148 rows — these rows as CSV