PREVIEW / futures_30min / 2008-02-27
file: by_date/futures_30min/2008/2008-02-27.parquet size: 62 KB rows: 2,113
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-27 00:00:00 | ES | Futures | 1289.12 | 1290.05 | 1288.89 | 1289.59 | 243.0 |
| 2008-02-27 00:30:00 | ES | Futures | 1289.35 | 1290.05 | 1288.89 | 1289.12 | 202.0 |
| 2008-02-27 01:00:00 | ES | Futures | 1288.89 | 1289.82 | 1288.65 | 1289.82 | 415.0 |
| 2008-02-27 01:30:00 | ES | Futures | 1289.82 | 1290.05 | 1288.42 | 1288.65 | 681.0 |
| 2008-02-27 02:00:00 | ES | Futures | 1288.65 | 1289.82 | 1288.19 | 1288.19 | 1976.0 |
| 2008-02-27 02:30:00 | ES | Futures | 1287.95 | 1290.05 | 1287.95 | 1289.59 | 2905.0 |
| 2008-02-27 03:00:00 | ES | Futures | 1289.35 | 1291.45 | 1287.95 | 1287.95 | 11189.0 |
| 2008-02-27 03:30:00 | ES | Futures | 1287.95 | 1288.65 | 1286.56 | 1286.56 | 11871.0 |
| 2008-02-27 04:00:00 | ES | Futures | 1286.79 | 1287.49 | 1284.92 | 1286.32 | 13066.0 |
| 2008-02-27 04:30:00 | ES | Futures | 1286.32 | 1287.49 | 1284.69 | 1285.39 | 8435.0 |
| 2008-02-27 05:00:00 | ES | Futures | 1285.16 | 1285.62 | 1283.99 | 1285.16 | 8388.0 |
| 2008-02-27 05:30:00 | ES | Futures | 1284.92 | 1287.72 | 1284.69 | 1286.56 | 6076.0 |
| 2008-02-27 06:00:00 | ES | Futures | 1286.56 | 1287.95 | 1285.86 | 1287.02 | 5632.0 |
| 2008-02-27 06:30:00 | ES | Futures | 1286.79 | 1288.65 | 1285.62 | 1287.72 | 10590.0 |
| 2008-02-27 07:00:00 | ES | Futures | 1287.72 | 1288.19 | 1285.62 | 1287.02 | 8611.0 |
| 2008-02-27 07:30:00 | ES | Futures | 1287.26 | 1287.49 | 1283.99 | 1284.69 | 14956.0 |
| 2008-02-27 08:00:00 | ES | Futures | 1284.69 | 1285.86 | 1280.03 | 1282.36 | 44776.0 |
| 2008-02-27 08:30:00 | ES | Futures | 1282.36 | 1283.76 | 1278.63 | 1281.43 | 58217.0 |
| 2008-02-27 09:00:00 | ES | Futures | 1281.43 | 1282.13 | 1279.79 | 1281.43 | 20539.0 |
| 2008-02-27 09:30:00 | ES | Futures | 1281.43 | 1286.32 | 1280.03 | 1285.62 | 169976.0 |
| 2008-02-27 10:00:00 | ES | Futures | 1285.62 | 1288.19 | 1281.43 | 1281.43 | 183748.0 |
| 2008-02-27 10:30:00 | ES | Futures | 1281.43 | 1296.35 | 1281.19 | 1291.92 | 265954.0 |
| 2008-02-27 11:00:00 | ES | Futures | 1291.69 | 1294.72 | 1290.29 | 1291.45 | 119386.0 |
| 2008-02-27 11:30:00 | ES | Futures | 1291.45 | 1295.65 | 1290.29 | 1295.18 | 80586.0 |
| 2008-02-27 12:00:00 | ES | Futures | 1295.18 | 1295.18 | 1290.52 | 1291.45 | 75889.0 |
| 2008-02-27 12:30:00 | ES | Futures | 1291.69 | 1295.18 | 1290.99 | 1293.78 | 51975.0 |
| 2008-02-27 13:00:00 | ES | Futures | 1293.55 | 1295.18 | 1291.45 | 1292.85 | 51274.0 |
| 2008-02-27 13:30:00 | ES | Futures | 1293.08 | 1294.02 | 1288.19 | 1288.89 | 84568.0 |
| 2008-02-27 14:00:00 | ES | Futures | 1288.89 | 1289.35 | 1282.13 | 1283.29 | 124198.0 |
| 2008-02-27 14:30:00 | ES | Futures | 1283.29 | 1288.65 | 1283.06 | 1288.19 | 94365.0 |
| 2008-02-27 15:00:00 | ES | Futures | 1288.42 | 1290.99 | 1285.39 | 1290.52 | 105957.0 |
| 2008-02-27 15:30:00 | ES | Futures | 1290.52 | 1290.99 | 1285.39 | 1286.79 | 117527.0 |
| 2008-02-27 16:00:00 | ES | Futures | 1286.79 | 1287.72 | 1285.39 | 1287.26 | 50579.0 |
| 2008-02-27 16:30:00 | ES | Futures | 1287.02 | 1288.19 | 1286.56 | 1287.95 | 4598.0 |
| 2008-02-27 17:00:00 | ES | Futures | 1287.72 | 1288.42 | 1287.49 | 1287.95 | 3121.0 |
| 2008-02-27 18:00:00 | ES | Futures | 1288.19 | 1288.42 | 1285.62 | 1286.56 | 3192.0 |
| 2008-02-27 18:30:00 | ES | Futures | 1286.56 | 1286.79 | 1284.46 | 1285.16 | 1536.0 |
| 2008-02-27 19:00:00 | ES | Futures | 1285.16 | 1285.62 | 1283.52 | 1283.99 | 2844.0 |
| 2008-02-27 19:30:00 | ES | Futures | 1283.99 | 1284.46 | 1283.29 | 1283.52 | 975.0 |
| 2008-02-27 20:00:00 | ES | Futures | 1283.76 | 1284.46 | 1283.52 | 1284.22 | 672.0 |
| 2008-02-27 20:30:00 | ES | Futures | 1284.46 | 1284.46 | 1282.83 | 1283.06 | 2022.0 |
| 2008-02-27 21:00:00 | ES | Futures | 1283.06 | 1283.06 | 1282.36 | 1282.83 | 1538.0 |
| 2008-02-27 21:30:00 | ES | Futures | 1282.59 | 1283.52 | 1282.36 | 1283.29 | 580.0 |
| 2008-02-27 22:00:00 | ES | Futures | 1283.29 | 1283.29 | 1282.59 | 1282.83 | 718.0 |
| 2008-02-27 22:30:00 | ES | Futures | 1283.06 | 1284.46 | 1282.59 | 1283.99 | 1488.0 |
| 2008-02-27 23:00:00 | ES | Futures | 1284.22 | 1284.92 | 1283.52 | 1283.99 | 1647.0 |
| 2008-02-27 23:30:00 | ES | Futures | 1283.99 | 1284.22 | 1282.59 | 1282.83 | 972.0 |
| 2008-02-27 00:00:00 | NQ | Futures | 2042.82 | 2042.82 | 2041.12 | 2041.4 | 35.0 |
| 2008-02-27 00:30:00 | NQ | Futures | 2041.69 | 2041.97 | 2041.12 | 2041.12 | 17.0 |
| 2008-02-27 01:00:00 | NQ | Futures | 2040.84 | 2042.54 | 2039.7 | 2042.54 | 80.0 |
> showing 50 of 2,113 rows — these rows as CSV