PREVIEW / futures_30min / 2010-10-26
file: by_date/futures_30min/2010/2010-10-26.parquet size: 76 KB rows: 2,730
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-26 00:00:00 | ES | Futures | 1166.58 | 1167.32 | 1166.34 | 1166.83 | 1536.0 |
| 2010-10-26 00:30:00 | ES | Futures | 1166.83 | 1167.08 | 1166.09 | 1166.83 | 1009.0 |
| 2010-10-26 01:00:00 | ES | Futures | 1166.58 | 1167.08 | 1166.58 | 1166.83 | 820.0 |
| 2010-10-26 01:30:00 | ES | Futures | 1166.83 | 1167.08 | 1166.09 | 1166.83 | 2766.0 |
| 2010-10-26 02:00:00 | ES | Futures | 1166.83 | 1167.32 | 1165.11 | 1165.85 | 4967.0 |
| 2010-10-26 02:30:00 | ES | Futures | 1165.85 | 1166.34 | 1165.11 | 1165.35 | 6059.0 |
| 2010-10-26 03:00:00 | ES | Futures | 1165.35 | 1167.57 | 1165.11 | 1167.32 | 12013.0 |
| 2010-10-26 03:30:00 | ES | Futures | 1167.32 | 1167.32 | 1163.13 | 1163.63 | 24478.0 |
| 2010-10-26 04:00:00 | ES | Futures | 1163.87 | 1164.37 | 1163.13 | 1164.12 | 13451.0 |
| 2010-10-26 04:30:00 | ES | Futures | 1164.12 | 1165.6 | 1163.87 | 1164.61 | 13905.0 |
| 2010-10-26 05:00:00 | ES | Futures | 1164.37 | 1164.61 | 1162.64 | 1163.13 | 11761.0 |
| 2010-10-26 05:30:00 | ES | Futures | 1163.13 | 1164.61 | 1162.39 | 1164.37 | 11941.0 |
| 2010-10-26 06:00:00 | ES | Futures | 1164.12 | 1166.09 | 1164.12 | 1165.6 | 9944.0 |
| 2010-10-26 06:30:00 | ES | Futures | 1165.85 | 1166.58 | 1165.11 | 1165.85 | 5348.0 |
| 2010-10-26 07:00:00 | ES | Futures | 1165.85 | 1166.34 | 1163.13 | 1163.87 | 15540.0 |
| 2010-10-26 07:30:00 | ES | Futures | 1163.87 | 1164.61 | 1161.9 | 1163.38 | 14273.0 |
| 2010-10-26 08:00:00 | ES | Futures | 1163.38 | 1163.38 | 1160.67 | 1161.65 | 32051.0 |
| 2010-10-26 08:30:00 | ES | Futures | 1161.9 | 1162.64 | 1160.92 | 1161.41 | 31963.0 |
| 2010-10-26 09:00:00 | ES | Futures | 1161.16 | 1161.9 | 1158.94 | 1159.93 | 54094.0 |
| 2010-10-26 09:30:00 | ES | Futures | 1159.93 | 1161.16 | 1157.46 | 1160.67 | 194810.0 |
| 2010-10-26 10:00:00 | ES | Futures | 1160.67 | 1166.09 | 1160.18 | 1164.37 | 226418.0 |
| 2010-10-26 10:30:00 | ES | Futures | 1164.12 | 1165.11 | 1161.9 | 1164.86 | 114481.0 |
| 2010-10-26 11:00:00 | ES | Futures | 1164.86 | 1166.34 | 1161.65 | 1165.35 | 144851.0 |
| 2010-10-26 11:30:00 | ES | Futures | 1165.11 | 1165.6 | 1163.87 | 1165.35 | 60504.0 |
| 2010-10-26 12:00:00 | ES | Futures | 1165.6 | 1166.58 | 1164.86 | 1165.35 | 53601.0 |
| 2010-10-26 12:30:00 | ES | Futures | 1165.6 | 1165.85 | 1164.12 | 1165.11 | 39979.0 |
| 2010-10-26 13:00:00 | ES | Futures | 1164.86 | 1166.58 | 1163.87 | 1164.37 | 52102.0 |
| 2010-10-26 13:30:00 | ES | Futures | 1164.12 | 1165.85 | 1162.39 | 1162.89 | 67901.0 |
| 2010-10-26 14:00:00 | ES | Futures | 1162.89 | 1163.87 | 1161.16 | 1163.38 | 94619.0 |
| 2010-10-26 14:30:00 | ES | Futures | 1163.13 | 1165.11 | 1161.9 | 1164.12 | 85314.0 |
| 2010-10-26 15:00:00 | ES | Futures | 1164.12 | 1167.08 | 1163.87 | 1165.6 | 85709.0 |
| 2010-10-26 15:30:00 | ES | Futures | 1165.6 | 1166.34 | 1163.87 | 1165.6 | 146759.0 |
| 2010-10-26 16:00:00 | ES | Futures | 1165.85 | 1166.83 | 1165.35 | 1166.58 | 79033.0 |
| 2010-10-26 16:30:00 | ES | Futures | 1166.58 | 1167.57 | 1166.58 | 1166.58 | 5316.0 |
| 2010-10-26 17:00:00 | ES | Futures | 1166.58 | 1167.08 | 1166.34 | 1166.83 | 1262.0 |
| 2010-10-26 18:00:00 | ES | Futures | 1166.58 | 1166.83 | 1166.34 | 1166.58 | 958.0 |
| 2010-10-26 18:30:00 | ES | Futures | 1166.58 | 1167.08 | 1166.34 | 1166.83 | 686.0 |
| 2010-10-26 19:00:00 | ES | Futures | 1166.58 | 1167.08 | 1166.34 | 1167.08 | 702.0 |
| 2010-10-26 19:30:00 | ES | Futures | 1167.08 | 1167.57 | 1166.58 | 1167.32 | 1292.0 |
| 2010-10-26 20:00:00 | ES | Futures | 1167.32 | 1169.54 | 1166.58 | 1168.8 | 6519.0 |
| 2010-10-26 20:30:00 | ES | Futures | 1168.8 | 1169.05 | 1167.08 | 1167.82 | 4828.0 |
| 2010-10-26 21:00:00 | ES | Futures | 1168.06 | 1168.31 | 1166.09 | 1166.34 | 4914.0 |
| 2010-10-26 21:30:00 | ES | Futures | 1166.34 | 1167.08 | 1165.85 | 1166.83 | 1854.0 |
| 2010-10-26 22:00:00 | ES | Futures | 1166.83 | 1167.32 | 1165.6 | 1166.09 | 3872.0 |
| 2010-10-26 22:30:00 | ES | Futures | 1165.85 | 1166.09 | 1164.86 | 1165.11 | 3107.0 |
| 2010-10-26 23:00:00 | ES | Futures | 1165.11 | 1165.35 | 1162.89 | 1163.63 | 6983.0 |
| 2010-10-26 23:30:00 | ES | Futures | 1163.63 | 1163.63 | 1161.16 | 1161.65 | 7356.0 |
| 2010-10-26 00:00:00 | NQ | Futures | 2421.17 | 2422.03 | 2420.31 | 2420.88 | 250.0 |
| 2010-10-26 00:30:00 | NQ | Futures | 2421.17 | 2421.17 | 2419.16 | 2419.74 | 164.0 |
| 2010-10-26 01:00:00 | NQ | Futures | 2419.74 | 2420.88 | 2419.74 | 2420.6 | 196.0 |
> showing 50 of 2,730 rows — these rows as CSV