PREVIEW / futures_30min / 2008-07-29
file: by_date/futures_30min/2008/2008-07-29.parquet size: 66 KB rows: 2,212
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-29 00:00:00 | ES | Futures | 1149.53 | 1150.46 | 1149.06 | 1149.76 | 1317.0 |
| 2008-07-29 00:30:00 | ES | Futures | 1149.76 | 1149.99 | 1149.06 | 1149.29 | 290.0 |
| 2008-07-29 01:00:00 | ES | Futures | 1149.29 | 1149.99 | 1149.29 | 1149.76 | 506.0 |
| 2008-07-29 01:30:00 | ES | Futures | 1149.99 | 1149.99 | 1148.83 | 1148.83 | 537.0 |
| 2008-07-29 02:00:00 | ES | Futures | 1148.83 | 1149.53 | 1146.97 | 1147.2 | 3519.0 |
| 2008-07-29 02:30:00 | ES | Futures | 1147.2 | 1150.22 | 1146.97 | 1147.9 | 5353.0 |
| 2008-07-29 03:00:00 | ES | Futures | 1147.9 | 1149.06 | 1146.27 | 1147.67 | 10700.0 |
| 2008-07-29 03:30:00 | ES | Futures | 1147.67 | 1149.99 | 1147.2 | 1149.76 | 7006.0 |
| 2008-07-29 04:00:00 | ES | Futures | 1149.53 | 1150.69 | 1148.83 | 1150.22 | 6372.0 |
| 2008-07-29 04:30:00 | ES | Futures | 1150.22 | 1151.39 | 1149.53 | 1149.53 | 4389.0 |
| 2008-07-29 05:00:00 | ES | Futures | 1149.53 | 1151.62 | 1148.83 | 1151.39 | 3963.0 |
| 2008-07-29 05:30:00 | ES | Futures | 1151.39 | 1151.85 | 1146.97 | 1147.2 | 8368.0 |
| 2008-07-29 06:00:00 | ES | Futures | 1147.2 | 1147.67 | 1144.88 | 1147.43 | 9902.0 |
| 2008-07-29 06:30:00 | ES | Futures | 1147.43 | 1149.29 | 1146.5 | 1149.06 | 3715.0 |
| 2008-07-29 07:00:00 | ES | Futures | 1149.29 | 1152.78 | 1148.6 | 1150.92 | 19602.0 |
| 2008-07-29 07:30:00 | ES | Futures | 1150.92 | 1153.71 | 1150.46 | 1153.25 | 19408.0 |
| 2008-07-29 08:00:00 | ES | Futures | 1153.25 | 1154.41 | 1151.62 | 1152.55 | 25393.0 |
| 2008-07-29 08:30:00 | ES | Futures | 1152.55 | 1153.48 | 1151.85 | 1152.32 | 13006.0 |
| 2008-07-29 09:00:00 | ES | Futures | 1152.32 | 1152.78 | 1150.46 | 1151.62 | 23429.0 |
| 2008-07-29 09:30:00 | ES | Futures | 1151.62 | 1156.27 | 1150.22 | 1156.27 | 221882.0 |
| 2008-07-29 10:00:00 | ES | Futures | 1156.27 | 1160.91 | 1156.27 | 1159.06 | 240662.0 |
| 2008-07-29 10:30:00 | ES | Futures | 1159.06 | 1162.31 | 1159.06 | 1160.45 | 144183.0 |
| 2008-07-29 11:00:00 | ES | Futures | 1160.22 | 1161.38 | 1158.13 | 1160.22 | 95863.0 |
| 2008-07-29 11:30:00 | ES | Futures | 1160.45 | 1164.63 | 1159.29 | 1163.01 | 118671.0 |
| 2008-07-29 12:00:00 | ES | Futures | 1163.24 | 1165.1 | 1162.54 | 1164.87 | 102156.0 |
| 2008-07-29 12:30:00 | ES | Futures | 1164.87 | 1165.33 | 1161.61 | 1164.4 | 94023.0 |
| 2008-07-29 13:00:00 | ES | Futures | 1164.63 | 1166.26 | 1162.54 | 1166.03 | 58866.0 |
| 2008-07-29 13:30:00 | ES | Futures | 1166.03 | 1168.35 | 1165.33 | 1168.12 | 114720.0 |
| 2008-07-29 14:00:00 | ES | Futures | 1168.12 | 1168.58 | 1164.17 | 1166.73 | 120056.0 |
| 2008-07-29 14:30:00 | ES | Futures | 1166.73 | 1167.65 | 1161.84 | 1165.33 | 125227.0 |
| 2008-07-29 15:00:00 | ES | Futures | 1165.33 | 1170.91 | 1164.63 | 1170.21 | 132797.0 |
| 2008-07-29 15:30:00 | ES | Futures | 1170.21 | 1173.7 | 1169.05 | 1173.47 | 228736.0 |
| 2008-07-29 16:00:00 | ES | Futures | 1173.47 | 1174.39 | 1172.77 | 1173.0 | 103819.0 |
| 2008-07-29 16:30:00 | ES | Futures | 1172.77 | 1173.23 | 1172.54 | 1173.0 | 4904.0 |
| 2008-07-29 17:00:00 | ES | Futures | 1173.0 | 1173.93 | 1172.3 | 1173.7 | 2902.0 |
| 2008-07-29 18:00:00 | ES | Futures | 1173.47 | 1174.39 | 1173.47 | 1173.7 | 1296.0 |
| 2008-07-29 18:30:00 | ES | Futures | 1173.7 | 1174.16 | 1173.0 | 1173.0 | 707.0 |
| 2008-07-29 19:00:00 | ES | Futures | 1173.0 | 1173.23 | 1172.77 | 1173.23 | 304.0 |
| 2008-07-29 19:30:00 | ES | Futures | 1173.0 | 1173.7 | 1172.77 | 1173.23 | 1660.0 |
| 2008-07-29 20:00:00 | ES | Futures | 1173.23 | 1173.23 | 1172.3 | 1172.77 | 1048.0 |
| 2008-07-29 20:30:00 | ES | Futures | 1172.77 | 1173.47 | 1172.77 | 1173.23 | 593.0 |
| 2008-07-29 21:00:00 | ES | Futures | 1173.0 | 1173.47 | 1172.54 | 1173.23 | 503.0 |
| 2008-07-29 21:30:00 | ES | Futures | 1173.23 | 1173.23 | 1172.77 | 1172.77 | 861.0 |
| 2008-07-29 22:00:00 | ES | Futures | 1172.54 | 1172.77 | 1172.3 | 1172.54 | 630.0 |
| 2008-07-29 22:30:00 | ES | Futures | 1172.54 | 1172.77 | 1172.07 | 1172.77 | 584.0 |
| 2008-07-29 23:00:00 | ES | Futures | 1172.54 | 1172.77 | 1172.07 | 1172.3 | 627.0 |
| 2008-07-29 23:30:00 | ES | Futures | 1172.3 | 1172.77 | 1172.07 | 1172.77 | 259.0 |
| 2008-07-29 00:00:00 | NQ | Futures | 2041.03 | 2042.16 | 2039.91 | 2041.03 | 89.0 |
| 2008-07-29 00:30:00 | NQ | Futures | 2041.03 | 2041.31 | 2039.34 | 2039.34 | 16.0 |
| 2008-07-29 01:00:00 | NQ | Futures | 2040.75 | 2043.0 | 2040.75 | 2043.0 | 65.0 |
> showing 50 of 2,212 rows — these rows as CSV