PREVIEW / futures_30min / 2010-04-22
file: by_date/futures_30min/2010/2010-04-22.parquet size: 72 KB rows: 2,551
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-04-22 00:00:00 | ES | Futures | 1170.56 | 1170.8 | 1170.31 | 1170.56 | 1051.0 |
| 2010-04-22 00:30:00 | ES | Futures | 1170.8 | 1171.05 | 1170.56 | 1171.05 | 1764.0 |
| 2010-04-22 01:00:00 | ES | Futures | 1171.05 | 1171.05 | 1170.56 | 1170.8 | 1054.0 |
| 2010-04-22 01:30:00 | ES | Futures | 1170.8 | 1171.54 | 1170.8 | 1171.29 | 2027.0 |
| 2010-04-22 02:00:00 | ES | Futures | 1171.05 | 1171.54 | 1170.56 | 1171.29 | 3559.0 |
| 2010-04-22 02:30:00 | ES | Futures | 1171.05 | 1171.78 | 1171.05 | 1171.29 | 2281.0 |
| 2010-04-22 03:00:00 | ES | Futures | 1171.29 | 1173.25 | 1171.05 | 1173.0 | 12464.0 |
| 2010-04-22 03:30:00 | ES | Futures | 1172.76 | 1174.71 | 1172.51 | 1174.71 | 12510.0 |
| 2010-04-22 04:00:00 | ES | Futures | 1174.71 | 1177.16 | 1174.47 | 1175.93 | 21375.0 |
| 2010-04-22 04:30:00 | ES | Futures | 1176.18 | 1176.42 | 1175.2 | 1176.18 | 5742.0 |
| 2010-04-22 05:00:00 | ES | Futures | 1176.18 | 1176.18 | 1167.87 | 1169.34 | 40814.0 |
| 2010-04-22 05:30:00 | ES | Futures | 1169.34 | 1170.31 | 1167.38 | 1169.34 | 33229.0 |
| 2010-04-22 06:00:00 | ES | Futures | 1169.34 | 1169.34 | 1166.65 | 1168.6 | 26370.0 |
| 2010-04-22 06:30:00 | ES | Futures | 1168.6 | 1169.09 | 1165.67 | 1167.38 | 23669.0 |
| 2010-04-22 07:00:00 | ES | Futures | 1167.14 | 1168.11 | 1166.16 | 1166.65 | 15159.0 |
| 2010-04-22 07:30:00 | ES | Futures | 1166.4 | 1168.85 | 1165.91 | 1168.36 | 20808.0 |
| 2010-04-22 08:00:00 | ES | Futures | 1168.36 | 1169.09 | 1167.62 | 1168.11 | 21814.0 |
| 2010-04-22 08:30:00 | ES | Futures | 1167.87 | 1168.36 | 1166.89 | 1167.14 | 34452.0 |
| 2010-04-22 09:00:00 | ES | Futures | 1167.14 | 1167.38 | 1165.67 | 1166.89 | 48436.0 |
| 2010-04-22 09:30:00 | ES | Futures | 1166.89 | 1167.14 | 1159.8 | 1162.98 | 324513.0 |
| 2010-04-22 10:00:00 | ES | Futures | 1162.98 | 1168.11 | 1161.76 | 1166.4 | 256517.0 |
| 2010-04-22 10:30:00 | ES | Futures | 1166.4 | 1168.6 | 1162.98 | 1166.16 | 283991.0 |
| 2010-04-22 11:00:00 | ES | Futures | 1166.16 | 1167.62 | 1164.2 | 1165.42 | 128384.0 |
| 2010-04-22 11:30:00 | ES | Futures | 1165.42 | 1165.67 | 1162.74 | 1165.18 | 122021.0 |
| 2010-04-22 12:00:00 | ES | Futures | 1165.18 | 1167.38 | 1164.2 | 1166.89 | 87505.0 |
| 2010-04-22 12:30:00 | ES | Futures | 1166.89 | 1168.11 | 1165.91 | 1167.14 | 50998.0 |
| 2010-04-22 13:00:00 | ES | Futures | 1167.14 | 1173.73 | 1166.89 | 1172.76 | 221517.0 |
| 2010-04-22 13:30:00 | ES | Futures | 1172.51 | 1174.71 | 1171.29 | 1174.71 | 124772.0 |
| 2010-04-22 14:00:00 | ES | Futures | 1174.71 | 1176.67 | 1173.0 | 1176.18 | 117386.0 |
| 2010-04-22 14:30:00 | ES | Futures | 1176.42 | 1176.67 | 1173.73 | 1174.96 | 107615.0 |
| 2010-04-22 15:00:00 | ES | Futures | 1174.96 | 1178.13 | 1174.22 | 1178.13 | 99348.0 |
| 2010-04-22 15:30:00 | ES | Futures | 1178.13 | 1180.09 | 1177.16 | 1178.38 | 189994.0 |
| 2010-04-22 16:00:00 | ES | Futures | 1178.38 | 1178.38 | 1173.49 | 1175.45 | 176408.0 |
| 2010-04-22 16:30:00 | ES | Futures | 1174.47 | 1176.18 | 1173.98 | 1175.93 | 13640.0 |
| 2010-04-22 17:00:00 | ES | Futures | 1175.93 | 1176.18 | 1174.96 | 1175.93 | 2018.0 |
| 2010-04-22 18:00:00 | ES | Futures | 1175.69 | 1175.69 | 1174.47 | 1174.96 | 2962.0 |
| 2010-04-22 18:30:00 | ES | Futures | 1174.96 | 1174.96 | 1174.22 | 1174.71 | 1486.0 |
| 2010-04-22 19:00:00 | ES | Futures | 1174.71 | 1174.96 | 1173.73 | 1173.98 | 2980.0 |
| 2010-04-22 19:30:00 | ES | Futures | 1173.98 | 1174.47 | 1173.73 | 1174.22 | 2651.0 |
| 2010-04-22 20:00:00 | ES | Futures | 1174.47 | 1174.96 | 1173.49 | 1174.96 | 5388.0 |
| 2010-04-22 20:30:00 | ES | Futures | 1174.96 | 1175.69 | 1174.71 | 1175.2 | 2862.0 |
| 2010-04-22 21:00:00 | ES | Futures | 1175.2 | 1175.69 | 1175.2 | 1175.69 | 1041.0 |
| 2010-04-22 21:30:00 | ES | Futures | 1175.45 | 1175.69 | 1174.47 | 1175.2 | 2363.0 |
| 2010-04-22 22:00:00 | ES | Futures | 1175.2 | 1175.69 | 1174.96 | 1175.45 | 1724.0 |
| 2010-04-22 22:30:00 | ES | Futures | 1175.2 | 1175.93 | 1175.2 | 1175.45 | 2012.0 |
| 2010-04-22 23:00:00 | ES | Futures | 1175.45 | 1175.45 | 1173.49 | 1173.98 | 4245.0 |
| 2010-04-22 23:30:00 | ES | Futures | 1173.98 | 1174.22 | 1172.51 | 1173.0 | 3906.0 |
| 2010-04-22 00:00:00 | NQ | Futures | 2315.04 | 2315.61 | 2315.04 | 2315.61 | 33.0 |
| 2010-04-22 00:30:00 | NQ | Futures | 2315.61 | 2315.9 | 2314.75 | 2315.61 | 89.0 |
| 2010-04-22 01:00:00 | NQ | Futures | 2315.61 | 2316.18 | 2315.61 | 2315.9 | 94.0 |
> showing 50 of 2,551 rows — these rows as CSV