PREVIEW / futures_30min / 2008-03-31
file: by_date/futures_30min/2008/2008-03-31.parquet size: 65 KB rows: 2,213
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-31 00:00:00 | ES | Futures | 1228.25 | 1228.25 | 1226.15 | 1226.39 | 2025.0 |
| 2008-03-31 00:30:00 | ES | Futures | 1226.39 | 1227.32 | 1226.15 | 1226.62 | 598.0 |
| 2008-03-31 01:00:00 | ES | Futures | 1226.62 | 1228.48 | 1226.62 | 1228.02 | 483.0 |
| 2008-03-31 01:30:00 | ES | Futures | 1228.02 | 1229.41 | 1228.02 | 1229.18 | 1125.0 |
| 2008-03-31 02:00:00 | ES | Futures | 1228.95 | 1229.41 | 1225.22 | 1226.39 | 3995.0 |
| 2008-03-31 02:30:00 | ES | Futures | 1226.39 | 1226.39 | 1224.53 | 1224.76 | 2988.0 |
| 2008-03-31 03:00:00 | ES | Futures | 1224.99 | 1225.69 | 1223.83 | 1224.76 | 7224.0 |
| 2008-03-31 03:30:00 | ES | Futures | 1224.76 | 1225.22 | 1221.5 | 1222.2 | 8380.0 |
| 2008-03-31 04:00:00 | ES | Futures | 1222.2 | 1222.2 | 1219.64 | 1221.5 | 12739.0 |
| 2008-03-31 04:30:00 | ES | Futures | 1221.5 | 1222.9 | 1220.1 | 1222.9 | 4794.0 |
| 2008-03-31 05:00:00 | ES | Futures | 1222.9 | 1223.83 | 1221.96 | 1223.59 | 4708.0 |
| 2008-03-31 05:30:00 | ES | Futures | 1223.83 | 1224.99 | 1222.66 | 1223.83 | 5917.0 |
| 2008-03-31 06:00:00 | ES | Futures | 1224.06 | 1227.09 | 1223.83 | 1226.39 | 6390.0 |
| 2008-03-31 06:30:00 | ES | Futures | 1226.39 | 1227.55 | 1224.76 | 1227.09 | 6038.0 |
| 2008-03-31 07:00:00 | ES | Futures | 1227.09 | 1228.25 | 1225.22 | 1226.85 | 10164.0 |
| 2008-03-31 07:30:00 | ES | Futures | 1226.85 | 1229.41 | 1226.62 | 1229.41 | 11927.0 |
| 2008-03-31 08:00:00 | ES | Futures | 1229.41 | 1230.11 | 1227.32 | 1227.55 | 15861.0 |
| 2008-03-31 08:30:00 | ES | Futures | 1227.32 | 1228.02 | 1224.53 | 1225.46 | 21803.0 |
| 2008-03-31 09:00:00 | ES | Futures | 1225.69 | 1227.09 | 1223.59 | 1225.69 | 22195.0 |
| 2008-03-31 09:30:00 | ES | Futures | 1225.69 | 1232.67 | 1223.36 | 1230.81 | 183999.0 |
| 2008-03-31 10:00:00 | ES | Futures | 1230.81 | 1231.28 | 1226.15 | 1227.09 | 115590.0 |
| 2008-03-31 10:30:00 | ES | Futures | 1227.32 | 1231.04 | 1226.15 | 1230.81 | 80376.0 |
| 2008-03-31 11:00:00 | ES | Futures | 1230.58 | 1233.37 | 1228.48 | 1232.21 | 87085.0 |
| 2008-03-31 11:30:00 | ES | Futures | 1232.21 | 1235.47 | 1231.98 | 1234.07 | 99336.0 |
| 2008-03-31 12:00:00 | ES | Futures | 1233.84 | 1235.0 | 1231.28 | 1232.67 | 49044.0 |
| 2008-03-31 12:30:00 | ES | Futures | 1232.91 | 1236.17 | 1231.74 | 1235.7 | 50491.0 |
| 2008-03-31 13:00:00 | ES | Futures | 1235.7 | 1238.03 | 1235.24 | 1237.56 | 81347.0 |
| 2008-03-31 13:30:00 | ES | Futures | 1237.56 | 1239.19 | 1235.24 | 1235.47 | 67260.0 |
| 2008-03-31 14:00:00 | ES | Futures | 1235.47 | 1235.7 | 1233.14 | 1234.54 | 82817.0 |
| 2008-03-31 14:30:00 | ES | Futures | 1234.54 | 1236.4 | 1229.88 | 1232.67 | 89871.0 |
| 2008-03-31 15:00:00 | ES | Futures | 1232.67 | 1235.0 | 1230.58 | 1232.21 | 83567.0 |
| 2008-03-31 15:30:00 | ES | Futures | 1232.21 | 1237.56 | 1231.04 | 1231.74 | 241958.0 |
| 2008-03-31 16:00:00 | ES | Futures | 1231.51 | 1233.14 | 1228.72 | 1231.04 | 139738.0 |
| 2008-03-31 16:30:00 | ES | Futures | 1230.58 | 1232.67 | 1230.11 | 1231.98 | 8444.0 |
| 2008-03-31 17:00:00 | ES | Futures | 1231.98 | 1232.21 | 1231.04 | 1231.28 | 1843.0 |
| 2008-03-31 18:00:00 | ES | Futures | 1231.28 | 1231.51 | 1230.58 | 1231.04 | 1395.0 |
| 2008-03-31 18:30:00 | ES | Futures | 1231.04 | 1232.67 | 1230.58 | 1232.44 | 1272.0 |
| 2008-03-31 19:00:00 | ES | Futures | 1232.44 | 1232.67 | 1231.74 | 1232.44 | 708.0 |
| 2008-03-31 19:30:00 | ES | Futures | 1232.44 | 1232.44 | 1230.58 | 1230.81 | 593.0 |
| 2008-03-31 20:00:00 | ES | Futures | 1230.81 | 1232.91 | 1230.58 | 1232.67 | 945.0 |
| 2008-03-31 20:30:00 | ES | Futures | 1232.67 | 1232.91 | 1231.51 | 1232.67 | 813.0 |
| 2008-03-31 21:00:00 | ES | Futures | 1232.67 | 1234.54 | 1231.98 | 1233.84 | 2490.0 |
| 2008-03-31 21:30:00 | ES | Futures | 1234.07 | 1235.24 | 1233.61 | 1233.84 | 1729.0 |
| 2008-03-31 22:00:00 | ES | Futures | 1234.07 | 1235.0 | 1233.61 | 1234.3 | 428.0 |
| 2008-03-31 22:30:00 | ES | Futures | 1234.54 | 1235.24 | 1234.3 | 1235.0 | 509.0 |
| 2008-03-31 23:00:00 | ES | Futures | 1235.24 | 1235.47 | 1234.77 | 1234.77 | 528.0 |
| 2008-03-31 23:30:00 | ES | Futures | 1234.77 | 1235.47 | 1233.37 | 1233.37 | 856.0 |
| 2008-03-31 00:00:00 | NQ | Futures | 2013.74 | 2015.15 | 2011.76 | 2011.76 | 195.0 |
| 2008-03-31 00:30:00 | NQ | Futures | 2012.61 | 2013.46 | 2012.04 | 2013.17 | 68.0 |
| 2008-03-31 01:00:00 | NQ | Futures | 2013.17 | 2016.57 | 2012.89 | 2016.57 | 35.0 |
> showing 50 of 2,213 rows — these rows as CSV