PREVIEW / futures_30min / 2008-02-21
file: by_date/futures_30min/2008/2008-02-21.parquet size: 51 KB rows: 1,672
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-02-21 00:00:00 | ES | Futures | 1270.93 | 1270.93 | 1270.0 | 1270.47 | 230.0 |
| 2008-02-21 00:30:00 | ES | Futures | 1270.7 | 1272.1 | 1270.23 | 1271.63 | 872.0 |
| 2008-02-21 01:00:00 | ES | Futures | 1271.63 | 1271.87 | 1271.17 | 1271.63 | 370.0 |
| 2008-02-21 01:30:00 | ES | Futures | 1271.63 | 1271.87 | 1269.77 | 1270.47 | 549.0 |
| 2008-02-21 02:00:00 | ES | Futures | 1270.23 | 1271.17 | 1267.2 | 1267.44 | 3235.0 |
| 2008-02-21 02:30:00 | ES | Futures | 1267.2 | 1269.54 | 1266.5 | 1267.9 | 3099.0 |
| 2008-02-21 03:00:00 | ES | Futures | 1267.9 | 1269.07 | 1266.04 | 1266.97 | 10135.0 |
| 2008-02-21 03:30:00 | ES | Futures | 1266.97 | 1268.14 | 1265.11 | 1267.9 | 6739.0 |
| 2008-02-21 04:00:00 | ES | Futures | 1267.67 | 1269.3 | 1266.97 | 1267.44 | 5857.0 |
| 2008-02-21 04:30:00 | ES | Futures | 1267.44 | 1270.47 | 1266.74 | 1270.47 | 6122.0 |
| 2008-02-21 05:00:00 | ES | Futures | 1270.47 | 1271.87 | 1268.84 | 1271.17 | 6675.0 |
| 2008-02-21 05:30:00 | ES | Futures | 1271.4 | 1271.87 | 1269.54 | 1269.77 | 4243.0 |
| 2008-02-21 06:00:00 | ES | Futures | 1269.77 | 1273.03 | 1269.77 | 1272.33 | 6842.0 |
| 2008-02-21 06:30:00 | ES | Futures | 1272.33 | 1275.83 | 1272.33 | 1274.9 | 20325.0 |
| 2008-02-21 07:00:00 | ES | Futures | 1274.66 | 1276.3 | 1273.73 | 1276.06 | 13108.0 |
| 2008-02-21 07:30:00 | ES | Futures | 1276.06 | 1276.06 | 1273.03 | 1273.5 | 16193.0 |
| 2008-02-21 08:00:00 | ES | Futures | 1273.73 | 1274.43 | 1272.33 | 1273.27 | 12475.0 |
| 2008-02-21 08:30:00 | ES | Futures | 1273.03 | 1275.83 | 1271.87 | 1274.2 | 27480.0 |
| 2008-02-21 09:00:00 | ES | Futures | 1274.2 | 1274.43 | 1272.57 | 1273.5 | 17308.0 |
| 2008-02-21 09:30:00 | ES | Futures | 1273.5 | 1277.0 | 1271.63 | 1273.27 | 154135.0 |
| 2008-02-21 10:00:00 | ES | Futures | 1273.27 | 1273.73 | 1267.44 | 1270.23 | 220245.0 |
| 2008-02-21 10:30:00 | ES | Futures | 1270.23 | 1271.17 | 1262.31 | 1262.54 | 180417.0 |
| 2008-02-21 11:00:00 | ES | Futures | 1262.54 | 1266.04 | 1262.07 | 1265.34 | 137917.0 |
| 2008-02-21 11:30:00 | ES | Futures | 1265.34 | 1268.6 | 1265.11 | 1267.9 | 94257.0 |
| 2008-02-21 12:00:00 | ES | Futures | 1267.67 | 1267.9 | 1260.44 | 1261.84 | 111895.0 |
| 2008-02-21 12:30:00 | ES | Futures | 1262.07 | 1263.71 | 1259.74 | 1262.07 | 76827.0 |
| 2008-02-21 13:00:00 | ES | Futures | 1262.31 | 1262.54 | 1256.01 | 1259.04 | 121176.0 |
| 2008-02-21 13:30:00 | ES | Futures | 1259.04 | 1259.28 | 1254.38 | 1257.41 | 101454.0 |
| 2008-02-21 14:00:00 | ES | Futures | 1257.41 | 1261.14 | 1255.78 | 1260.91 | 112022.0 |
| 2008-02-21 14:30:00 | ES | Futures | 1260.91 | 1261.37 | 1255.55 | 1256.94 | 91841.0 |
| 2008-02-21 15:00:00 | ES | Futures | 1256.71 | 1256.94 | 1250.65 | 1253.68 | 159418.0 |
| 2008-02-21 15:30:00 | ES | Futures | 1253.45 | 1255.55 | 1249.02 | 1253.21 | 191639.0 |
| 2008-02-21 16:00:00 | ES | Futures | 1253.21 | 1256.48 | 1252.05 | 1255.55 | 78424.0 |
| 2008-02-21 16:30:00 | ES | Futures | 1255.78 | 1255.78 | 1254.15 | 1254.38 | 5270.0 |
| 2008-02-21 17:00:00 | ES | Futures | 1254.15 | 1254.61 | 1252.75 | 1253.68 | 3465.0 |
| 2008-02-21 18:00:00 | ES | Futures | 1253.68 | 1253.68 | 1252.51 | 1252.98 | 1872.0 |
| 2008-02-21 18:30:00 | ES | Futures | 1252.98 | 1253.91 | 1252.51 | 1253.45 | 1188.0 |
| 2008-02-21 19:00:00 | ES | Futures | 1253.68 | 1254.38 | 1253.21 | 1254.15 | 1779.0 |
| 2008-02-21 19:30:00 | ES | Futures | 1253.91 | 1254.15 | 1252.75 | 1252.98 | 2108.0 |
| 2008-02-21 20:00:00 | ES | Futures | 1252.75 | 1253.21 | 1252.51 | 1252.75 | 966.0 |
| 2008-02-21 20:30:00 | ES | Futures | 1252.75 | 1253.91 | 1252.51 | 1253.45 | 792.0 |
| 2008-02-21 21:00:00 | ES | Futures | 1253.45 | 1253.91 | 1252.98 | 1253.45 | 574.0 |
| 2008-02-21 21:30:00 | ES | Futures | 1253.21 | 1253.68 | 1252.75 | 1253.68 | 562.0 |
| 2008-02-21 22:00:00 | ES | Futures | 1253.91 | 1254.38 | 1252.28 | 1252.51 | 1125.0 |
| 2008-02-21 22:30:00 | ES | Futures | 1252.51 | 1253.45 | 1252.51 | 1252.75 | 708.0 |
| 2008-02-21 23:00:00 | ES | Futures | 1252.75 | 1253.68 | 1252.05 | 1253.68 | 1336.0 |
| 2008-02-21 23:30:00 | ES | Futures | 1253.21 | 1253.91 | 1252.28 | 1252.75 | 721.0 |
| 2008-02-21 00:00:00 | NQ | Futures | 2037.43 | 2037.43 | 2034.59 | 2036.01 | 52.0 |
| 2008-02-21 00:30:00 | NQ | Futures | 2036.29 | 2038.57 | 2036.01 | 2038.28 | 170.0 |
| 2008-02-21 01:00:00 | NQ | Futures | 2038.0 | 2038.57 | 2036.86 | 2037.71 | 69.0 |
> showing 50 of 1,672 rows — these rows as CSV