PREVIEW / futures_30min / 2008-03-18
file: by_date/futures_30min/2008/2008-03-18.parquet size: 73 KB rows: 2,329
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-03-18 00:00:00 | ES | Futures | 1193.09 | 1193.32 | 1191.46 | 1193.32 | 1193.0 |
| 2008-03-18 00:30:00 | ES | Futures | 1193.09 | 1197.52 | 1193.09 | 1196.35 | 854.0 |
| 2008-03-18 01:00:00 | ES | Futures | 1196.58 | 1197.05 | 1195.89 | 1196.82 | 470.0 |
| 2008-03-18 01:30:00 | ES | Futures | 1196.58 | 1197.52 | 1195.89 | 1196.35 | 562.0 |
| 2008-03-18 02:00:00 | ES | Futures | 1196.35 | 1197.28 | 1195.65 | 1195.89 | 536.0 |
| 2008-03-18 02:30:00 | ES | Futures | 1196.35 | 1198.45 | 1196.12 | 1198.21 | 1649.0 |
| 2008-03-18 03:00:00 | ES | Futures | 1198.45 | 1203.8 | 1197.52 | 1201.47 | 7101.0 |
| 2008-03-18 03:30:00 | ES | Futures | 1201.71 | 1203.1 | 1199.84 | 1202.4 | 5203.0 |
| 2008-03-18 04:00:00 | ES | Futures | 1202.17 | 1202.17 | 1199.38 | 1199.84 | 10834.0 |
| 2008-03-18 04:30:00 | ES | Futures | 1199.61 | 1201.71 | 1199.38 | 1201.47 | 7726.0 |
| 2008-03-18 05:00:00 | ES | Futures | 1201.47 | 1204.97 | 1201.01 | 1203.8 | 11605.0 |
| 2008-03-18 05:30:00 | ES | Futures | 1204.03 | 1204.73 | 1201.24 | 1201.94 | 7034.0 |
| 2008-03-18 06:00:00 | ES | Futures | 1201.94 | 1204.03 | 1201.47 | 1202.64 | 8512.0 |
| 2008-03-18 06:30:00 | ES | Futures | 1202.64 | 1206.36 | 1202.4 | 1205.9 | 13902.0 |
| 2008-03-18 07:00:00 | ES | Futures | 1205.66 | 1206.83 | 1204.97 | 1206.13 | 12449.0 |
| 2008-03-18 07:30:00 | ES | Futures | 1206.36 | 1209.39 | 1204.03 | 1207.99 | 35196.0 |
| 2008-03-18 08:00:00 | ES | Futures | 1207.99 | 1212.65 | 1207.06 | 1210.32 | 88135.0 |
| 2008-03-18 08:30:00 | ES | Futures | 1210.32 | 1211.49 | 1207.06 | 1211.02 | 49244.0 |
| 2008-03-18 09:00:00 | ES | Futures | 1211.25 | 1214.51 | 1211.02 | 1213.35 | 44909.0 |
| 2008-03-18 09:30:00 | ES | Futures | 1213.35 | 1216.84 | 1211.72 | 1215.21 | 200221.0 |
| 2008-03-18 10:00:00 | ES | Futures | 1215.21 | 1217.77 | 1213.58 | 1214.98 | 125503.0 |
| 2008-03-18 10:30:00 | ES | Futures | 1215.21 | 1220.1 | 1213.58 | 1219.4 | 124439.0 |
| 2008-03-18 11:00:00 | ES | Futures | 1219.64 | 1221.96 | 1218.7 | 1221.5 | 102413.0 |
| 2008-03-18 11:30:00 | ES | Futures | 1221.5 | 1223.59 | 1220.1 | 1220.33 | 86552.0 |
| 2008-03-18 12:00:00 | ES | Futures | 1220.57 | 1221.96 | 1218.94 | 1221.73 | 66109.0 |
| 2008-03-18 12:30:00 | ES | Futures | 1221.73 | 1224.99 | 1221.5 | 1223.83 | 73707.0 |
| 2008-03-18 13:00:00 | ES | Futures | 1223.83 | 1227.32 | 1222.9 | 1225.69 | 83731.0 |
| 2008-03-18 13:30:00 | ES | Futures | 1225.69 | 1227.55 | 1224.06 | 1225.92 | 61849.0 |
| 2008-03-18 14:00:00 | ES | Futures | 1225.92 | 1227.55 | 1211.72 | 1216.14 | 364779.0 |
| 2008-03-18 14:30:00 | ES | Futures | 1215.91 | 1232.91 | 1207.29 | 1231.51 | 412365.0 |
| 2008-03-18 15:00:00 | ES | Futures | 1231.51 | 1233.61 | 1226.62 | 1230.81 | 213140.0 |
| 2008-03-18 15:30:00 | ES | Futures | 1230.81 | 1240.13 | 1229.65 | 1239.66 | 324258.0 |
| 2008-03-18 16:00:00 | ES | Futures | 1239.43 | 1242.92 | 1238.96 | 1242.45 | 127271.0 |
| 2008-03-18 16:30:00 | ES | Futures | 1241.52 | 1242.22 | 1241.06 | 1241.76 | 8777.0 |
| 2008-03-18 17:00:00 | ES | Futures | 1241.76 | 1242.45 | 1241.29 | 1241.99 | 2354.0 |
| 2008-03-18 18:00:00 | ES | Futures | 1241.99 | 1242.22 | 1241.06 | 1241.76 | 1551.0 |
| 2008-03-18 18:30:00 | ES | Futures | 1241.52 | 1241.99 | 1240.59 | 1241.06 | 1289.0 |
| 2008-03-18 19:00:00 | ES | Futures | 1240.82 | 1241.52 | 1240.59 | 1241.29 | 750.0 |
| 2008-03-18 19:30:00 | ES | Futures | 1241.29 | 1241.99 | 1240.59 | 1241.52 | 1461.0 |
| 2008-03-18 20:00:00 | ES | Futures | 1241.52 | 1241.99 | 1240.13 | 1241.52 | 1561.0 |
| 2008-03-18 20:30:00 | ES | Futures | 1241.52 | 1243.39 | 1241.52 | 1242.22 | 2375.0 |
| 2008-03-18 21:00:00 | ES | Futures | 1242.45 | 1245.48 | 1241.76 | 1245.02 | 2255.0 |
| 2008-03-18 21:30:00 | ES | Futures | 1245.25 | 1245.48 | 1243.15 | 1243.39 | 3098.0 |
| 2008-03-18 22:00:00 | ES | Futures | 1243.62 | 1243.85 | 1241.76 | 1242.45 | 1562.0 |
| 2008-03-18 22:30:00 | ES | Futures | 1242.22 | 1243.15 | 1241.99 | 1242.45 | 1060.0 |
| 2008-03-18 23:00:00 | ES | Futures | 1242.45 | 1243.15 | 1241.52 | 1242.69 | 810.0 |
| 2008-03-18 23:30:00 | ES | Futures | 1242.92 | 1243.15 | 1241.76 | 1241.76 | 508.0 |
| 2008-03-18 00:00:00 | NQ | Futures | 1920.12 | 1920.12 | 1917.01 | 1919.84 | 77.0 |
| 2008-03-18 00:30:00 | NQ | Futures | 1920.41 | 1926.63 | 1920.41 | 1925.21 | 122.0 |
| 2008-03-18 01:00:00 | NQ | Futures | 1925.21 | 1926.06 | 1923.52 | 1925.78 | 30.0 |
> showing 50 of 2,329 rows — these rows as CSV