PREVIEW / futures_30min / 2010-04-12
file: by_date/futures_30min/2010/2010-04-12.parquet size: 68 KB rows: 2,486
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-12 00:00:00 | ES | Futures | 1169.82 | 1170.31 | 1169.58 | 1169.82 | 1709.0 |
| 2010-04-12 00:30:00 | ES | Futures | 1169.58 | 1170.07 | 1169.58 | 1169.82 | 1904.0 |
| 2010-04-12 01:00:00 | ES | Futures | 1170.07 | 1170.07 | 1169.34 | 1169.58 | 962.0 |
| 2010-04-12 01:30:00 | ES | Futures | 1169.58 | 1170.07 | 1169.34 | 1169.82 | 1188.0 |
| 2010-04-12 02:00:00 | ES | Futures | 1169.82 | 1170.56 | 1168.36 | 1168.85 | 10496.0 |
| 2010-04-12 02:30:00 | ES | Futures | 1168.85 | 1168.85 | 1167.87 | 1168.36 | 6933.0 |
| 2010-04-12 03:00:00 | ES | Futures | 1168.36 | 1169.09 | 1167.62 | 1167.62 | 10553.0 |
| 2010-04-12 03:30:00 | ES | Futures | 1167.87 | 1168.11 | 1167.14 | 1167.62 | 8627.0 |
| 2010-04-12 04:00:00 | ES | Futures | 1167.87 | 1168.11 | 1166.65 | 1168.11 | 9795.0 |
| 2010-04-12 04:30:00 | ES | Futures | 1168.11 | 1168.36 | 1167.38 | 1168.11 | 3162.0 |
| 2010-04-12 05:00:00 | ES | Futures | 1168.11 | 1168.6 | 1167.14 | 1168.36 | 4338.0 |
| 2010-04-12 05:30:00 | ES | Futures | 1168.6 | 1168.6 | 1166.65 | 1167.38 | 5279.0 |
| 2010-04-12 06:00:00 | ES | Futures | 1167.14 | 1167.38 | 1166.4 | 1166.65 | 4407.0 |
| 2010-04-12 06:30:00 | ES | Futures | 1166.89 | 1166.89 | 1165.91 | 1166.65 | 7236.0 |
| 2010-04-12 07:00:00 | ES | Futures | 1166.65 | 1167.14 | 1164.69 | 1164.69 | 15260.0 |
| 2010-04-12 07:30:00 | ES | Futures | 1164.94 | 1166.16 | 1164.45 | 1166.16 | 9867.0 |
| 2010-04-12 08:00:00 | ES | Futures | 1166.16 | 1166.65 | 1164.69 | 1165.18 | 16861.0 |
| 2010-04-12 08:30:00 | ES | Futures | 1165.42 | 1165.91 | 1164.45 | 1165.18 | 21412.0 |
| 2010-04-12 09:00:00 | ES | Futures | 1165.18 | 1166.65 | 1164.69 | 1165.67 | 19793.0 |
| 2010-04-12 09:30:00 | ES | Futures | 1165.42 | 1168.11 | 1164.45 | 1164.69 | 155389.0 |
| 2010-04-12 10:00:00 | ES | Futures | 1164.69 | 1167.38 | 1164.2 | 1167.38 | 92078.0 |
| 2010-04-12 10:30:00 | ES | Futures | 1167.38 | 1167.62 | 1165.42 | 1167.38 | 106205.0 |
| 2010-04-12 11:00:00 | ES | Futures | 1167.38 | 1167.87 | 1165.67 | 1165.67 | 43914.0 |
| 2010-04-12 11:30:00 | ES | Futures | 1165.91 | 1167.38 | 1165.18 | 1166.89 | 54888.0 |
| 2010-04-12 12:00:00 | ES | Futures | 1166.89 | 1167.38 | 1166.4 | 1166.65 | 31035.0 |
| 2010-04-12 12:30:00 | ES | Futures | 1166.89 | 1167.62 | 1166.16 | 1167.62 | 36910.0 |
| 2010-04-12 13:00:00 | ES | Futures | 1167.38 | 1169.09 | 1167.38 | 1168.11 | 54093.0 |
| 2010-04-12 13:30:00 | ES | Futures | 1167.87 | 1168.6 | 1166.65 | 1166.65 | 51341.0 |
| 2010-04-12 14:00:00 | ES | Futures | 1166.89 | 1167.87 | 1166.16 | 1167.62 | 48480.0 |
| 2010-04-12 14:30:00 | ES | Futures | 1167.87 | 1168.36 | 1166.4 | 1167.62 | 46862.0 |
| 2010-04-12 15:00:00 | ES | Futures | 1167.87 | 1168.36 | 1165.18 | 1166.16 | 105571.0 |
| 2010-04-12 15:30:00 | ES | Futures | 1166.16 | 1166.89 | 1164.45 | 1166.4 | 143422.0 |
| 2010-04-12 16:00:00 | ES | Futures | 1166.16 | 1166.89 | 1164.94 | 1166.16 | 79706.0 |
| 2010-04-12 16:30:00 | ES | Futures | 1165.67 | 1166.16 | 1164.94 | 1165.91 | 7860.0 |
| 2010-04-12 17:00:00 | ES | Futures | 1165.91 | 1165.91 | 1165.18 | 1165.18 | 1747.0 |
| 2010-04-12 18:00:00 | ES | Futures | 1165.42 | 1165.91 | 1165.18 | 1165.42 | 696.0 |
| 2010-04-12 18:30:00 | ES | Futures | 1165.42 | 1165.42 | 1164.94 | 1165.18 | 563.0 |
| 2010-04-12 19:00:00 | ES | Futures | 1165.42 | 1165.42 | 1164.69 | 1164.69 | 1330.0 |
| 2010-04-12 19:30:00 | ES | Futures | 1164.94 | 1165.18 | 1164.69 | 1164.69 | 860.0 |
| 2010-04-12 20:00:00 | ES | Futures | 1164.69 | 1165.18 | 1162.98 | 1163.47 | 4321.0 |
| 2010-04-12 20:30:00 | ES | Futures | 1163.47 | 1163.47 | 1162.49 | 1162.74 | 2237.0 |
| 2010-04-12 21:00:00 | ES | Futures | 1162.74 | 1163.22 | 1162.49 | 1162.49 | 2046.0 |
| 2010-04-12 21:30:00 | ES | Futures | 1162.49 | 1163.22 | 1162.0 | 1163.22 | 3074.0 |
| 2010-04-12 22:00:00 | ES | Futures | 1162.98 | 1163.71 | 1162.74 | 1163.71 | 1299.0 |
| 2010-04-12 22:30:00 | ES | Futures | 1163.71 | 1163.96 | 1163.22 | 1163.22 | 826.0 |
| 2010-04-12 23:00:00 | ES | Futures | 1163.22 | 1163.47 | 1162.0 | 1162.0 | 1490.0 |
| 2010-04-12 23:30:00 | ES | Futures | 1162.0 | 1162.25 | 1161.51 | 1161.76 | 3721.0 |
| 2010-04-12 00:00:00 | NQ | Futures | 2289.84 | 2290.12 | 2289.55 | 2289.84 | 31.0 |
| 2010-04-12 00:30:00 | NQ | Futures | 2289.55 | 2290.41 | 2289.26 | 2290.12 | 81.0 |
| 2010-04-12 01:00:00 | NQ | Futures | 2290.12 | 2290.12 | 2288.69 | 2288.98 | 95.0 |
> showing 50 of 2,486 rows — these rows as CSV