PREVIEW / futures_30min / 2010-10-28
file: by_date/futures_30min/2010/2010-10-28.parquet size: 73 KB rows: 2,693
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-28 00:00:00 | ES | Futures | 1164.12 | 1164.61 | 1163.63 | 1164.12 | 1875.0 |
| 2010-10-28 00:30:00 | ES | Futures | 1164.12 | 1164.86 | 1163.87 | 1163.87 | 1993.0 |
| 2010-10-28 01:00:00 | ES | Futures | 1163.87 | 1164.61 | 1163.87 | 1164.12 | 1183.0 |
| 2010-10-28 01:30:00 | ES | Futures | 1164.12 | 1164.61 | 1163.13 | 1163.87 | 1920.0 |
| 2010-10-28 02:00:00 | ES | Futures | 1163.87 | 1164.37 | 1163.13 | 1164.12 | 5287.0 |
| 2010-10-28 02:30:00 | ES | Futures | 1164.12 | 1165.6 | 1163.63 | 1164.12 | 8740.0 |
| 2010-10-28 03:00:00 | ES | Futures | 1164.12 | 1165.35 | 1162.89 | 1163.13 | 16458.0 |
| 2010-10-28 03:30:00 | ES | Futures | 1163.13 | 1164.37 | 1162.39 | 1163.38 | 14237.0 |
| 2010-10-28 04:00:00 | ES | Futures | 1163.38 | 1163.87 | 1162.89 | 1163.87 | 7605.0 |
| 2010-10-28 04:30:00 | ES | Futures | 1163.87 | 1164.61 | 1163.63 | 1164.37 | 7594.0 |
| 2010-10-28 05:00:00 | ES | Futures | 1164.37 | 1166.09 | 1164.12 | 1165.6 | 13513.0 |
| 2010-10-28 05:30:00 | ES | Futures | 1165.6 | 1165.85 | 1165.11 | 1165.35 | 4760.0 |
| 2010-10-28 06:00:00 | ES | Futures | 1165.11 | 1165.35 | 1164.37 | 1164.37 | 6447.0 |
| 2010-10-28 06:30:00 | ES | Futures | 1164.37 | 1164.86 | 1164.12 | 1164.12 | 7770.0 |
| 2010-10-28 07:00:00 | ES | Futures | 1164.37 | 1164.61 | 1163.63 | 1164.12 | 11896.0 |
| 2010-10-28 07:30:00 | ES | Futures | 1164.37 | 1164.37 | 1162.89 | 1164.12 | 13640.0 |
| 2010-10-28 08:00:00 | ES | Futures | 1163.87 | 1167.82 | 1163.87 | 1167.32 | 36991.0 |
| 2010-10-28 08:30:00 | ES | Futures | 1167.57 | 1170.77 | 1166.83 | 1168.56 | 74985.0 |
| 2010-10-28 09:00:00 | ES | Futures | 1168.8 | 1169.54 | 1168.06 | 1169.05 | 22435.0 |
| 2010-10-28 09:30:00 | ES | Futures | 1169.05 | 1169.79 | 1165.85 | 1166.83 | 174855.0 |
| 2010-10-28 10:00:00 | ES | Futures | 1166.58 | 1167.82 | 1160.42 | 1160.92 | 248348.0 |
| 2010-10-28 10:30:00 | ES | Futures | 1160.92 | 1161.9 | 1158.94 | 1161.16 | 182179.0 |
| 2010-10-28 11:00:00 | ES | Futures | 1161.41 | 1163.87 | 1160.67 | 1163.13 | 118903.0 |
| 2010-10-28 11:30:00 | ES | Futures | 1163.13 | 1163.13 | 1159.93 | 1159.93 | 94447.0 |
| 2010-10-28 12:00:00 | ES | Futures | 1159.93 | 1160.18 | 1157.46 | 1157.96 | 134392.0 |
| 2010-10-28 12:30:00 | ES | Futures | 1157.96 | 1159.19 | 1156.97 | 1157.71 | 67908.0 |
| 2010-10-28 13:00:00 | ES | Futures | 1157.96 | 1163.87 | 1157.22 | 1160.67 | 139110.0 |
| 2010-10-28 13:30:00 | ES | Futures | 1160.67 | 1161.9 | 1159.44 | 1160.67 | 70682.0 |
| 2010-10-28 14:00:00 | ES | Futures | 1160.67 | 1163.13 | 1160.42 | 1161.9 | 70691.0 |
| 2010-10-28 14:30:00 | ES | Futures | 1161.9 | 1163.38 | 1161.16 | 1162.15 | 67391.0 |
| 2010-10-28 15:00:00 | ES | Futures | 1162.15 | 1164.12 | 1160.42 | 1161.9 | 86357.0 |
| 2010-10-28 15:30:00 | ES | Futures | 1162.15 | 1165.6 | 1161.41 | 1163.13 | 180522.0 |
| 2010-10-28 16:00:00 | ES | Futures | 1163.38 | 1164.37 | 1162.15 | 1162.39 | 82219.0 |
| 2010-10-28 16:30:00 | ES | Futures | 1162.64 | 1163.63 | 1162.39 | 1163.13 | 4803.0 |
| 2010-10-28 17:00:00 | ES | Futures | 1163.38 | 1163.38 | 1162.39 | 1162.89 | 1221.0 |
| 2010-10-28 18:00:00 | ES | Futures | 1162.64 | 1163.13 | 1162.15 | 1162.64 | 1796.0 |
| 2010-10-28 18:30:00 | ES | Futures | 1162.39 | 1163.13 | 1162.15 | 1162.89 | 677.0 |
| 2010-10-28 19:00:00 | ES | Futures | 1163.13 | 1163.13 | 1162.15 | 1162.64 | 744.0 |
| 2010-10-28 19:30:00 | ES | Futures | 1162.39 | 1163.13 | 1161.65 | 1162.39 | 1657.0 |
| 2010-10-28 20:00:00 | ES | Futures | 1162.64 | 1162.64 | 1159.19 | 1159.19 | 4685.0 |
| 2010-10-28 20:30:00 | ES | Futures | 1159.19 | 1160.18 | 1158.2 | 1158.7 | 4036.0 |
| 2010-10-28 21:00:00 | ES | Futures | 1158.7 | 1158.94 | 1156.97 | 1157.96 | 6389.0 |
| 2010-10-28 21:30:00 | ES | Futures | 1157.96 | 1159.44 | 1157.96 | 1159.19 | 3282.0 |
| 2010-10-28 22:00:00 | ES | Futures | 1159.19 | 1159.44 | 1158.2 | 1158.94 | 1609.0 |
| 2010-10-28 22:30:00 | ES | Futures | 1158.94 | 1158.94 | 1156.73 | 1156.97 | 4664.0 |
| 2010-10-28 23:00:00 | ES | Futures | 1156.97 | 1158.2 | 1156.73 | 1158.2 | 1488.0 |
| 2010-10-28 23:30:00 | ES | Futures | 1157.96 | 1159.19 | 1157.46 | 1159.19 | 1906.0 |
| 2010-10-28 00:00:00 | NQ | Futures | 2438.38 | 2438.96 | 2437.81 | 2438.1 | 48.0 |
| 2010-10-28 00:30:00 | NQ | Futures | 2437.81 | 2438.96 | 2437.81 | 2438.1 | 90.0 |
| 2010-10-28 01:00:00 | NQ | Futures | 2438.1 | 2439.25 | 2437.81 | 2438.38 | 79.0 |
> showing 50 of 2,693 rows — these rows as CSV