PREVIEW / futures_30min / 2010-04-13
file: by_date/futures_30min/2010/2010-04-13.parquet size: 68 KB rows: 2,547
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-13 00:00:00 | ES | Futures | 1161.76 | 1162.25 | 1161.51 | 1162.25 | 2436.0 |
| 2010-04-13 00:30:00 | ES | Futures | 1162.25 | 1162.25 | 1161.76 | 1162.0 | 1068.0 |
| 2010-04-13 01:00:00 | ES | Futures | 1162.0 | 1162.49 | 1161.76 | 1162.25 | 1360.0 |
| 2010-04-13 01:30:00 | ES | Futures | 1162.0 | 1162.98 | 1162.0 | 1162.74 | 2312.0 |
| 2010-04-13 02:00:00 | ES | Futures | 1162.74 | 1164.2 | 1162.25 | 1162.98 | 4785.0 |
| 2010-04-13 02:30:00 | ES | Futures | 1162.74 | 1163.96 | 1162.74 | 1163.71 | 3471.0 |
| 2010-04-13 03:00:00 | ES | Futures | 1163.71 | 1165.42 | 1163.71 | 1164.45 | 9638.0 |
| 2010-04-13 03:30:00 | ES | Futures | 1164.45 | 1164.94 | 1162.98 | 1163.22 | 9167.0 |
| 2010-04-13 04:00:00 | ES | Futures | 1163.22 | 1163.96 | 1162.98 | 1163.47 | 5108.0 |
| 2010-04-13 04:30:00 | ES | Futures | 1163.47 | 1163.71 | 1162.25 | 1162.25 | 5807.0 |
| 2010-04-13 05:00:00 | ES | Futures | 1162.49 | 1162.74 | 1161.76 | 1162.0 | 9942.0 |
| 2010-04-13 05:30:00 | ES | Futures | 1162.25 | 1162.98 | 1162.0 | 1162.98 | 3855.0 |
| 2010-04-13 06:00:00 | ES | Futures | 1162.98 | 1163.96 | 1162.74 | 1163.47 | 5085.0 |
| 2010-04-13 06:30:00 | ES | Futures | 1163.47 | 1163.96 | 1162.74 | 1162.98 | 4357.0 |
| 2010-04-13 07:00:00 | ES | Futures | 1163.22 | 1163.71 | 1162.49 | 1163.22 | 6062.0 |
| 2010-04-13 07:30:00 | ES | Futures | 1163.22 | 1163.71 | 1162.74 | 1162.98 | 8049.0 |
| 2010-04-13 08:00:00 | ES | Futures | 1162.98 | 1165.67 | 1162.98 | 1164.94 | 20408.0 |
| 2010-04-13 08:30:00 | ES | Futures | 1165.18 | 1166.16 | 1164.2 | 1165.91 | 19402.0 |
| 2010-04-13 09:00:00 | ES | Futures | 1165.67 | 1165.67 | 1164.2 | 1164.94 | 17856.0 |
| 2010-04-13 09:30:00 | ES | Futures | 1164.94 | 1165.91 | 1162.74 | 1164.2 | 160774.0 |
| 2010-04-13 10:00:00 | ES | Futures | 1164.2 | 1164.94 | 1160.29 | 1160.54 | 182680.0 |
| 2010-04-13 10:30:00 | ES | Futures | 1160.78 | 1161.76 | 1158.58 | 1161.02 | 213789.0 |
| 2010-04-13 11:00:00 | ES | Futures | 1161.02 | 1162.25 | 1160.05 | 1162.0 | 91495.0 |
| 2010-04-13 11:30:00 | ES | Futures | 1161.76 | 1162.49 | 1161.02 | 1161.76 | 54452.0 |
| 2010-04-13 12:00:00 | ES | Futures | 1162.0 | 1164.45 | 1161.27 | 1163.71 | 88076.0 |
| 2010-04-13 12:30:00 | ES | Futures | 1163.71 | 1164.69 | 1162.98 | 1164.2 | 39140.0 |
| 2010-04-13 13:00:00 | ES | Futures | 1164.2 | 1165.42 | 1164.2 | 1164.45 | 55180.0 |
| 2010-04-13 13:30:00 | ES | Futures | 1164.45 | 1166.89 | 1164.2 | 1166.4 | 84577.0 |
| 2010-04-13 14:00:00 | ES | Futures | 1166.65 | 1166.89 | 1165.18 | 1165.42 | 48962.0 |
| 2010-04-13 14:30:00 | ES | Futures | 1165.18 | 1167.14 | 1164.94 | 1165.91 | 56833.0 |
| 2010-04-13 15:00:00 | ES | Futures | 1165.91 | 1169.09 | 1165.42 | 1168.36 | 116073.0 |
| 2010-04-13 15:30:00 | ES | Futures | 1168.11 | 1168.85 | 1166.65 | 1167.14 | 117705.0 |
| 2010-04-13 16:00:00 | ES | Futures | 1167.38 | 1167.38 | 1165.91 | 1166.16 | 71578.0 |
| 2010-04-13 16:30:00 | ES | Futures | 1168.85 | 1169.58 | 1168.36 | 1169.09 | 20920.0 |
| 2010-04-13 17:00:00 | ES | Futures | 1169.09 | 1169.34 | 1168.85 | 1169.09 | 1995.0 |
| 2010-04-13 18:00:00 | ES | Futures | 1168.85 | 1169.09 | 1168.36 | 1168.6 | 2133.0 |
| 2010-04-13 18:30:00 | ES | Futures | 1168.6 | 1168.6 | 1167.87 | 1168.36 | 1482.0 |
| 2010-04-13 19:00:00 | ES | Futures | 1168.36 | 1168.6 | 1168.11 | 1168.11 | 368.0 |
| 2010-04-13 19:30:00 | ES | Futures | 1168.11 | 1168.85 | 1168.11 | 1168.6 | 1100.0 |
| 2010-04-13 20:00:00 | ES | Futures | 1168.36 | 1168.85 | 1168.11 | 1168.11 | 1840.0 |
| 2010-04-13 20:30:00 | ES | Futures | 1168.11 | 1169.34 | 1168.11 | 1169.09 | 1574.0 |
| 2010-04-13 21:00:00 | ES | Futures | 1168.85 | 1169.09 | 1168.6 | 1168.85 | 1133.0 |
| 2010-04-13 21:30:00 | ES | Futures | 1168.85 | 1168.85 | 1168.11 | 1168.11 | 1110.0 |
| 2010-04-13 22:00:00 | ES | Futures | 1168.11 | 1168.36 | 1167.87 | 1168.36 | 1392.0 |
| 2010-04-13 22:30:00 | ES | Futures | 1168.36 | 1168.6 | 1167.87 | 1168.11 | 862.0 |
| 2010-04-13 23:00:00 | ES | Futures | 1168.11 | 1168.36 | 1167.87 | 1168.11 | 515.0 |
| 2010-04-13 23:30:00 | ES | Futures | 1168.36 | 1168.6 | 1167.87 | 1168.36 | 1712.0 |
| 2010-04-13 00:00:00 | NQ | Futures | 2275.52 | 2275.8 | 2274.94 | 2275.52 | 71.0 |
| 2010-04-13 00:30:00 | NQ | Futures | 2275.23 | 2275.8 | 2274.94 | 2275.23 | 62.0 |
| 2010-04-13 01:00:00 | NQ | Futures | 2275.23 | 2276.38 | 2275.23 | 2275.8 | 67.0 |
> showing 50 of 2,547 rows — these rows as CSV