PREVIEW / futures_30min / 2008-06-10
file: by_date/futures_30min/2008/2008-06-10.parquet size: 63 KB rows: 2,101
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-06-10 00:00:00 | ES | Futures | 1263.64 | 1264.34 | 1262.01 | 1263.18 | 1564.0 |
| 2008-06-10 00:30:00 | ES | Futures | 1263.18 | 1264.34 | 1262.71 | 1262.71 | 699.0 |
| 2008-06-10 01:00:00 | ES | Futures | 1262.94 | 1263.41 | 1262.25 | 1263.41 | 679.0 |
| 2008-06-10 01:30:00 | ES | Futures | 1263.41 | 1264.57 | 1263.18 | 1263.41 | 1213.0 |
| 2008-06-10 02:00:00 | ES | Futures | 1263.41 | 1263.88 | 1259.68 | 1260.38 | 6300.0 |
| 2008-06-10 02:30:00 | ES | Futures | 1260.38 | 1262.01 | 1259.92 | 1260.15 | 5816.0 |
| 2008-06-10 03:00:00 | ES | Futures | 1259.92 | 1262.48 | 1259.22 | 1259.92 | 10518.0 |
| 2008-06-10 03:30:00 | ES | Futures | 1259.92 | 1261.31 | 1257.59 | 1261.08 | 13266.0 |
| 2008-06-10 04:00:00 | ES | Futures | 1261.08 | 1261.31 | 1257.82 | 1258.75 | 9153.0 |
| 2008-06-10 04:30:00 | ES | Futures | 1258.52 | 1258.75 | 1254.79 | 1256.89 | 17762.0 |
| 2008-06-10 05:00:00 | ES | Futures | 1256.89 | 1259.45 | 1256.66 | 1259.45 | 7710.0 |
| 2008-06-10 05:30:00 | ES | Futures | 1259.45 | 1262.94 | 1259.45 | 1261.31 | 14601.0 |
| 2008-06-10 06:00:00 | ES | Futures | 1261.31 | 1263.88 | 1260.62 | 1260.85 | 11980.0 |
| 2008-06-10 06:30:00 | ES | Futures | 1261.08 | 1261.31 | 1258.99 | 1261.31 | 7111.0 |
| 2008-06-10 07:00:00 | ES | Futures | 1261.55 | 1262.71 | 1260.38 | 1260.38 | 11073.0 |
| 2008-06-10 07:30:00 | ES | Futures | 1260.38 | 1260.85 | 1258.29 | 1259.45 | 14279.0 |
| 2008-06-10 08:00:00 | ES | Futures | 1259.45 | 1259.92 | 1255.26 | 1258.75 | 23668.0 |
| 2008-06-10 08:30:00 | ES | Futures | 1258.75 | 1260.15 | 1256.89 | 1258.75 | 19084.0 |
| 2008-06-10 09:00:00 | ES | Futures | 1258.52 | 1260.15 | 1256.19 | 1259.92 | 35488.0 |
| 2008-06-10 09:30:00 | ES | Futures | 1260.15 | 1263.88 | 1258.52 | 1261.08 | 221502.0 |
| 2008-06-10 10:00:00 | ES | Futures | 1261.08 | 1267.83 | 1259.92 | 1266.2 | 204286.0 |
| 2008-06-10 10:30:00 | ES | Futures | 1266.44 | 1266.9 | 1262.25 | 1264.11 | 144492.0 |
| 2008-06-10 11:00:00 | ES | Futures | 1264.11 | 1266.44 | 1260.62 | 1262.71 | 129806.0 |
| 2008-06-10 11:30:00 | ES | Futures | 1262.94 | 1269.0 | 1261.78 | 1265.27 | 158146.0 |
| 2008-06-10 12:00:00 | ES | Futures | 1265.04 | 1270.63 | 1262.94 | 1268.77 | 122466.0 |
| 2008-06-10 12:30:00 | ES | Futures | 1269.0 | 1270.86 | 1267.6 | 1269.0 | 85615.0 |
| 2008-06-10 13:00:00 | ES | Futures | 1269.0 | 1273.42 | 1267.14 | 1272.49 | 124382.0 |
| 2008-06-10 13:30:00 | ES | Futures | 1272.49 | 1272.49 | 1267.6 | 1267.83 | 69776.0 |
| 2008-06-10 14:00:00 | ES | Futures | 1267.83 | 1268.53 | 1261.55 | 1264.57 | 147901.0 |
| 2008-06-10 14:30:00 | ES | Futures | 1264.57 | 1267.37 | 1263.64 | 1266.67 | 87071.0 |
| 2008-06-10 15:00:00 | ES | Futures | 1266.9 | 1268.77 | 1265.27 | 1267.6 | 104670.0 |
| 2008-06-10 15:30:00 | ES | Futures | 1267.83 | 1269.23 | 1264.11 | 1264.34 | 146131.0 |
| 2008-06-10 16:00:00 | ES | Futures | 1264.34 | 1264.57 | 1262.01 | 1263.18 | 89653.0 |
| 2008-06-10 16:30:00 | ES | Futures | 1263.18 | 1263.64 | 1262.25 | 1262.25 | 5871.0 |
| 2008-06-10 17:00:00 | ES | Futures | 1262.25 | 1263.18 | 1262.25 | 1262.71 | 727.0 |
| 2008-06-10 18:00:00 | ES | Futures | 1262.01 | 1262.71 | 1260.62 | 1261.31 | 2113.0 |
| 2008-06-10 18:30:00 | ES | Futures | 1261.31 | 1262.71 | 1261.08 | 1262.48 | 355.0 |
| 2008-06-10 19:00:00 | ES | Futures | 1262.71 | 1262.94 | 1262.01 | 1262.48 | 543.0 |
| 2008-06-10 19:30:00 | ES | Futures | 1262.48 | 1263.64 | 1262.25 | 1263.64 | 856.0 |
| 2008-06-10 20:00:00 | ES | Futures | 1263.64 | 1263.88 | 1263.41 | 1263.88 | 589.0 |
| 2008-06-10 20:30:00 | ES | Futures | 1263.88 | 1264.34 | 1263.64 | 1263.88 | 614.0 |
| 2008-06-10 21:00:00 | ES | Futures | 1264.11 | 1264.11 | 1263.18 | 1263.88 | 755.0 |
| 2008-06-10 21:30:00 | ES | Futures | 1263.88 | 1264.11 | 1261.31 | 1261.55 | 1203.0 |
| 2008-06-10 22:00:00 | ES | Futures | 1261.78 | 1261.78 | 1260.85 | 1261.78 | 761.0 |
| 2008-06-10 22:30:00 | ES | Futures | 1261.78 | 1262.94 | 1261.31 | 1262.94 | 679.0 |
| 2008-06-10 23:00:00 | ES | Futures | 1262.94 | 1264.34 | 1262.48 | 1264.34 | 1298.0 |
| 2008-06-10 23:30:00 | ES | Futures | 1264.34 | 1265.04 | 1263.88 | 1264.81 | 1219.0 |
| 2008-06-10 00:00:00 | NQ | Futures | 2237.46 | 2238.87 | 2233.78 | 2236.33 | 234.0 |
| 2008-06-10 00:30:00 | NQ | Futures | 2237.17 | 2238.31 | 2235.19 | 2235.19 | 119.0 |
| 2008-06-10 01:00:00 | NQ | Futures | 2236.89 | 2237.46 | 2234.91 | 2236.89 | 55.0 |
> showing 50 of 2,101 rows — these rows as CSV