PREVIEW / futures_30min / 2010-10-25
file: by_date/futures_30min/2010/2010-10-25.parquet size: 71 KB rows: 2,624
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-25 00:00:00 | ES | Futures | 1172.5 | 1176.2 | 1172.25 | 1173.98 | 13358.0 |
| 2010-10-25 00:30:00 | ES | Futures | 1173.98 | 1175.95 | 1173.49 | 1174.23 | 6408.0 |
| 2010-10-25 01:00:00 | ES | Futures | 1173.98 | 1174.47 | 1173.49 | 1173.73 | 1606.0 |
| 2010-10-25 01:30:00 | ES | Futures | 1173.73 | 1174.23 | 1172.25 | 1172.99 | 3705.0 |
| 2010-10-25 02:00:00 | ES | Futures | 1172.99 | 1173.24 | 1171.76 | 1172.75 | 7733.0 |
| 2010-10-25 02:30:00 | ES | Futures | 1172.99 | 1172.99 | 1171.51 | 1172.25 | 5952.0 |
| 2010-10-25 03:00:00 | ES | Futures | 1172.25 | 1172.25 | 1170.77 | 1171.02 | 14026.0 |
| 2010-10-25 03:30:00 | ES | Futures | 1171.02 | 1171.51 | 1169.79 | 1170.04 | 13407.0 |
| 2010-10-25 04:00:00 | ES | Futures | 1170.28 | 1172.25 | 1170.04 | 1172.25 | 11246.0 |
| 2010-10-25 04:30:00 | ES | Futures | 1172.01 | 1172.5 | 1171.51 | 1171.76 | 6893.0 |
| 2010-10-25 05:00:00 | ES | Futures | 1172.01 | 1172.25 | 1171.02 | 1171.51 | 6178.0 |
| 2010-10-25 05:30:00 | ES | Futures | 1171.51 | 1171.76 | 1170.53 | 1171.51 | 3916.0 |
| 2010-10-25 06:00:00 | ES | Futures | 1171.27 | 1172.5 | 1171.27 | 1172.25 | 6563.0 |
| 2010-10-25 06:30:00 | ES | Futures | 1172.25 | 1172.99 | 1172.01 | 1172.25 | 8145.0 |
| 2010-10-25 07:00:00 | ES | Futures | 1172.25 | 1172.5 | 1171.27 | 1172.01 | 5333.0 |
| 2010-10-25 07:30:00 | ES | Futures | 1171.76 | 1172.01 | 1170.53 | 1171.51 | 8105.0 |
| 2010-10-25 08:00:00 | ES | Futures | 1171.27 | 1171.76 | 1170.28 | 1170.28 | 15278.0 |
| 2010-10-25 08:30:00 | ES | Futures | 1170.28 | 1170.77 | 1169.3 | 1169.79 | 29012.0 |
| 2010-10-25 09:00:00 | ES | Futures | 1170.04 | 1171.02 | 1169.79 | 1170.04 | 17980.0 |
| 2010-10-25 09:30:00 | ES | Futures | 1170.04 | 1175.21 | 1169.3 | 1174.72 | 200890.0 |
| 2010-10-25 10:00:00 | ES | Futures | 1174.72 | 1176.2 | 1172.75 | 1172.99 | 192841.0 |
| 2010-10-25 10:30:00 | ES | Futures | 1172.99 | 1173.98 | 1168.31 | 1169.54 | 185193.0 |
| 2010-10-25 11:00:00 | ES | Futures | 1169.54 | 1170.53 | 1167.57 | 1170.28 | 121651.0 |
| 2010-10-25 11:30:00 | ES | Futures | 1170.28 | 1171.27 | 1168.8 | 1169.3 | 68234.0 |
| 2010-10-25 12:00:00 | ES | Futures | 1169.3 | 1169.54 | 1165.85 | 1167.32 | 82783.0 |
| 2010-10-25 12:30:00 | ES | Futures | 1167.57 | 1168.06 | 1166.58 | 1166.83 | 43610.0 |
| 2010-10-25 13:00:00 | ES | Futures | 1166.83 | 1170.04 | 1166.34 | 1169.3 | 61414.0 |
| 2010-10-25 13:30:00 | ES | Futures | 1169.3 | 1169.79 | 1167.82 | 1168.56 | 43168.0 |
| 2010-10-25 14:00:00 | ES | Futures | 1168.56 | 1169.79 | 1168.31 | 1169.05 | 39889.0 |
| 2010-10-25 14:30:00 | ES | Futures | 1169.05 | 1170.04 | 1166.34 | 1168.06 | 90320.0 |
| 2010-10-25 15:00:00 | ES | Futures | 1168.06 | 1171.51 | 1168.06 | 1171.02 | 90849.0 |
| 2010-10-25 15:30:00 | ES | Futures | 1171.02 | 1171.27 | 1164.61 | 1165.6 | 220681.0 |
| 2010-10-25 16:00:00 | ES | Futures | 1165.35 | 1166.83 | 1164.86 | 1166.58 | 77317.0 |
| 2010-10-25 16:30:00 | ES | Futures | 1165.35 | 1166.09 | 1165.11 | 1165.6 | 5018.0 |
| 2010-10-25 17:00:00 | ES | Futures | 1165.85 | 1166.58 | 1165.6 | 1166.34 | 2353.0 |
| 2010-10-25 17:30:00 | ES | Futures | 1166.34 | 1166.34 | 1166.34 | 1166.34 | 2.0 |
| 2010-10-25 18:00:00 | ES | Futures | 1165.85 | 1166.09 | 1164.86 | 1165.6 | 2002.0 |
| 2010-10-25 18:30:00 | ES | Futures | 1165.85 | 1166.09 | 1165.35 | 1165.85 | 600.0 |
| 2010-10-25 19:00:00 | ES | Futures | 1165.6 | 1165.6 | 1164.86 | 1165.35 | 1925.0 |
| 2010-10-25 19:30:00 | ES | Futures | 1165.35 | 1165.85 | 1164.61 | 1165.6 | 1663.0 |
| 2010-10-25 20:00:00 | ES | Futures | 1165.85 | 1166.58 | 1165.35 | 1166.09 | 3074.0 |
| 2010-10-25 20:30:00 | ES | Futures | 1166.09 | 1166.34 | 1165.6 | 1166.09 | 1642.0 |
| 2010-10-25 21:00:00 | ES | Futures | 1166.34 | 1166.83 | 1165.6 | 1166.09 | 1555.0 |
| 2010-10-25 21:30:00 | ES | Futures | 1166.09 | 1166.09 | 1165.6 | 1166.09 | 403.0 |
| 2010-10-25 22:00:00 | ES | Futures | 1165.85 | 1165.85 | 1164.86 | 1164.86 | 2060.0 |
| 2010-10-25 22:30:00 | ES | Futures | 1165.11 | 1165.35 | 1164.37 | 1164.86 | 1946.0 |
| 2010-10-25 23:00:00 | ES | Futures | 1164.86 | 1165.6 | 1164.37 | 1164.61 | 1401.0 |
| 2010-10-25 23:30:00 | ES | Futures | 1164.61 | 1167.32 | 1164.61 | 1166.58 | 4057.0 |
| 2010-10-25 00:00:00 | NQ | Futures | 2428.34 | 2436.38 | 2428.34 | 2432.07 | 959.0 |
| 2010-10-25 00:30:00 | NQ | Futures | 2431.21 | 2436.09 | 2431.21 | 2433.22 | 349.0 |
> showing 50 of 2,624 rows — these rows as CSV