PREVIEW / futures_30min / 2010-04-19
file: by_date/futures_30min/2010/2010-04-19.parquet size: 70 KB rows: 2,544
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-19 00:00:00 | ES | Futures | 1158.58 | 1159.56 | 1158.58 | 1159.07 | 1591.0 |
| 2010-04-19 00:30:00 | ES | Futures | 1159.07 | 1160.05 | 1158.58 | 1158.82 | 3176.0 |
| 2010-04-19 01:00:00 | ES | Futures | 1158.82 | 1159.07 | 1158.58 | 1158.58 | 1869.0 |
| 2010-04-19 01:30:00 | ES | Futures | 1158.82 | 1159.56 | 1158.58 | 1159.07 | 2660.0 |
| 2010-04-19 02:00:00 | ES | Futures | 1159.31 | 1160.29 | 1158.58 | 1158.58 | 8673.0 |
| 2010-04-19 02:30:00 | ES | Futures | 1158.82 | 1158.82 | 1157.6 | 1157.85 | 11022.0 |
| 2010-04-19 03:00:00 | ES | Futures | 1157.85 | 1160.54 | 1156.87 | 1160.29 | 23932.0 |
| 2010-04-19 03:30:00 | ES | Futures | 1160.29 | 1161.51 | 1159.07 | 1159.56 | 21768.0 |
| 2010-04-19 04:00:00 | ES | Futures | 1159.56 | 1160.05 | 1158.82 | 1158.82 | 9798.0 |
| 2010-04-19 04:30:00 | ES | Futures | 1159.07 | 1159.07 | 1156.38 | 1156.63 | 21783.0 |
| 2010-04-19 05:00:00 | ES | Futures | 1156.63 | 1158.09 | 1156.38 | 1156.63 | 15419.0 |
| 2010-04-19 05:30:00 | ES | Futures | 1156.63 | 1158.09 | 1156.63 | 1157.85 | 9472.0 |
| 2010-04-19 06:00:00 | ES | Futures | 1157.85 | 1158.58 | 1157.36 | 1158.09 | 7415.0 |
| 2010-04-19 06:30:00 | ES | Futures | 1157.85 | 1158.58 | 1157.36 | 1158.34 | 6555.0 |
| 2010-04-19 07:00:00 | ES | Futures | 1158.34 | 1158.34 | 1155.16 | 1157.85 | 21848.0 |
| 2010-04-19 07:30:00 | ES | Futures | 1157.85 | 1158.34 | 1156.63 | 1157.36 | 13072.0 |
| 2010-04-19 08:00:00 | ES | Futures | 1157.6 | 1158.82 | 1156.38 | 1157.11 | 36541.0 |
| 2010-04-19 08:30:00 | ES | Futures | 1157.11 | 1159.31 | 1156.87 | 1159.07 | 34259.0 |
| 2010-04-19 09:00:00 | ES | Futures | 1159.07 | 1159.8 | 1158.58 | 1158.82 | 30281.0 |
| 2010-04-19 09:30:00 | ES | Futures | 1158.82 | 1165.42 | 1158.58 | 1163.71 | 281801.0 |
| 2010-04-19 10:00:00 | ES | Futures | 1163.71 | 1166.65 | 1162.98 | 1163.47 | 179270.0 |
| 2010-04-19 10:30:00 | ES | Futures | 1163.71 | 1164.2 | 1160.78 | 1162.0 | 167735.0 |
| 2010-04-19 11:00:00 | ES | Futures | 1161.76 | 1162.74 | 1159.31 | 1160.05 | 132160.0 |
| 2010-04-19 11:30:00 | ES | Futures | 1160.05 | 1161.27 | 1154.91 | 1156.38 | 199995.0 |
| 2010-04-19 12:00:00 | ES | Futures | 1156.14 | 1157.36 | 1153.45 | 1156.14 | 198396.0 |
| 2010-04-19 12:30:00 | ES | Futures | 1156.14 | 1158.34 | 1155.4 | 1157.85 | 72763.0 |
| 2010-04-19 13:00:00 | ES | Futures | 1157.6 | 1158.58 | 1155.89 | 1158.09 | 75077.0 |
| 2010-04-19 13:30:00 | ES | Futures | 1158.09 | 1158.34 | 1155.16 | 1155.65 | 65442.0 |
| 2010-04-19 14:00:00 | ES | Futures | 1155.65 | 1162.0 | 1154.67 | 1161.27 | 145328.0 |
| 2010-04-19 14:30:00 | ES | Futures | 1161.51 | 1164.45 | 1160.78 | 1164.2 | 147613.0 |
| 2010-04-19 15:00:00 | ES | Futures | 1164.2 | 1166.16 | 1163.71 | 1165.42 | 159120.0 |
| 2010-04-19 15:30:00 | ES | Futures | 1165.42 | 1167.87 | 1163.71 | 1167.14 | 174259.0 |
| 2010-04-19 16:00:00 | ES | Futures | 1166.89 | 1169.82 | 1166.4 | 1169.34 | 137273.0 |
| 2010-04-19 16:30:00 | ES | Futures | 1169.09 | 1169.09 | 1168.11 | 1168.11 | 5572.0 |
| 2010-04-19 17:00:00 | ES | Futures | 1168.36 | 1169.09 | 1168.11 | 1169.09 | 1712.0 |
| 2010-04-19 18:00:00 | ES | Futures | 1168.85 | 1169.09 | 1168.36 | 1168.85 | 1054.0 |
| 2010-04-19 18:30:00 | ES | Futures | 1168.85 | 1169.58 | 1168.36 | 1169.34 | 1918.0 |
| 2010-04-19 19:00:00 | ES | Futures | 1169.34 | 1169.34 | 1168.85 | 1169.34 | 727.0 |
| 2010-04-19 19:30:00 | ES | Futures | 1169.34 | 1169.58 | 1169.09 | 1169.58 | 2320.0 |
| 2010-04-19 20:00:00 | ES | Futures | 1169.82 | 1170.31 | 1169.34 | 1170.07 | 3049.0 |
| 2010-04-19 20:30:00 | ES | Futures | 1169.82 | 1170.31 | 1169.82 | 1169.82 | 2358.0 |
| 2010-04-19 21:00:00 | ES | Futures | 1169.82 | 1170.07 | 1169.09 | 1169.34 | 2893.0 |
| 2010-04-19 21:30:00 | ES | Futures | 1169.09 | 1169.58 | 1167.87 | 1168.11 | 3315.0 |
| 2010-04-19 22:00:00 | ES | Futures | 1168.36 | 1168.6 | 1167.87 | 1168.36 | 1846.0 |
| 2010-04-19 22:30:00 | ES | Futures | 1168.6 | 1168.85 | 1168.36 | 1168.36 | 909.0 |
| 2010-04-19 23:00:00 | ES | Futures | 1168.36 | 1168.6 | 1168.36 | 1168.6 | 274.0 |
| 2010-04-19 23:30:00 | ES | Futures | 1168.36 | 1169.34 | 1168.36 | 1169.34 | 971.0 |
| 2010-04-19 00:00:00 | NQ | Futures | 2294.13 | 2295.28 | 2294.13 | 2294.99 | 73.0 |
| 2010-04-19 00:30:00 | NQ | Futures | 2294.99 | 2296.14 | 2293.84 | 2293.84 | 51.0 |
| 2010-04-19 01:00:00 | NQ | Futures | 2294.13 | 2294.42 | 2293.84 | 2293.84 | 70.0 |
> showing 50 of 2,544 rows — these rows as CSV