PREVIEW / futures_30min / 2008-06-06
file: by_date/futures_30min/2008/2008-06-06.parquet size: 59 KB rows: 1,848
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-06 00:00:00 | ES | Futures | 1308.58 | 1309.05 | 1308.58 | 1308.58 | 236.0 |
| 2008-06-06 00:30:00 | ES | Futures | 1308.58 | 1308.81 | 1308.35 | 1308.35 | 138.0 |
| 2008-06-06 01:00:00 | ES | Futures | 1308.35 | 1309.28 | 1308.35 | 1308.81 | 192.0 |
| 2008-06-06 01:30:00 | ES | Futures | 1309.05 | 1309.05 | 1308.12 | 1308.12 | 985.0 |
| 2008-06-06 02:00:00 | ES | Futures | 1308.12 | 1308.12 | 1307.18 | 1307.42 | 2757.0 |
| 2008-06-06 02:30:00 | ES | Futures | 1307.18 | 1308.35 | 1306.95 | 1307.18 | 2486.0 |
| 2008-06-06 03:00:00 | ES | Futures | 1307.18 | 1314.17 | 1307.18 | 1312.31 | 13451.0 |
| 2008-06-06 03:30:00 | ES | Futures | 1312.31 | 1312.54 | 1311.14 | 1311.38 | 4437.0 |
| 2008-06-06 04:00:00 | ES | Futures | 1311.14 | 1311.84 | 1309.98 | 1310.44 | 4974.0 |
| 2008-06-06 04:30:00 | ES | Futures | 1310.44 | 1310.44 | 1309.28 | 1310.44 | 2887.0 |
| 2008-06-06 05:00:00 | ES | Futures | 1310.21 | 1310.44 | 1308.12 | 1309.05 | 6857.0 |
| 2008-06-06 05:30:00 | ES | Futures | 1308.81 | 1309.28 | 1306.49 | 1308.35 | 9013.0 |
| 2008-06-06 06:00:00 | ES | Futures | 1308.35 | 1308.35 | 1306.25 | 1307.42 | 5879.0 |
| 2008-06-06 06:30:00 | ES | Futures | 1307.42 | 1310.21 | 1306.25 | 1310.21 | 5663.0 |
| 2008-06-06 07:00:00 | ES | Futures | 1309.98 | 1310.21 | 1306.95 | 1307.65 | 5353.0 |
| 2008-06-06 07:30:00 | ES | Futures | 1307.65 | 1309.28 | 1306.95 | 1309.05 | 9352.0 |
| 2008-06-06 08:00:00 | ES | Futures | 1309.05 | 1312.31 | 1308.58 | 1308.81 | 22881.0 |
| 2008-06-06 08:30:00 | ES | Futures | 1308.81 | 1313.24 | 1299.97 | 1302.29 | 128208.0 |
| 2008-06-06 09:00:00 | ES | Futures | 1302.29 | 1302.29 | 1296.01 | 1296.71 | 76509.0 |
| 2008-06-06 09:30:00 | ES | Futures | 1296.94 | 1299.04 | 1294.61 | 1295.31 | 234235.0 |
| 2008-06-06 10:00:00 | ES | Futures | 1295.54 | 1295.54 | 1287.39 | 1289.02 | 294450.0 |
| 2008-06-06 10:30:00 | ES | Futures | 1289.02 | 1291.12 | 1286.23 | 1288.32 | 165553.0 |
| 2008-06-06 11:00:00 | ES | Futures | 1288.32 | 1288.56 | 1281.34 | 1281.8 | 206719.0 |
| 2008-06-06 11:30:00 | ES | Futures | 1282.04 | 1286.93 | 1281.57 | 1284.83 | 112131.0 |
| 2008-06-06 12:00:00 | ES | Futures | 1284.83 | 1286.0 | 1282.27 | 1282.97 | 94875.0 |
| 2008-06-06 12:30:00 | ES | Futures | 1282.97 | 1286.93 | 1282.74 | 1284.13 | 64645.0 |
| 2008-06-06 13:00:00 | ES | Futures | 1284.37 | 1284.83 | 1279.94 | 1282.27 | 133763.0 |
| 2008-06-06 13:30:00 | ES | Futures | 1282.5 | 1285.3 | 1280.17 | 1282.5 | 103523.0 |
| 2008-06-06 14:00:00 | ES | Futures | 1282.5 | 1282.5 | 1273.89 | 1277.38 | 222070.0 |
| 2008-06-06 14:30:00 | ES | Futures | 1277.15 | 1279.24 | 1274.12 | 1274.35 | 116145.0 |
| 2008-06-06 15:00:00 | ES | Futures | 1274.35 | 1282.04 | 1271.56 | 1273.19 | 214284.0 |
| 2008-06-06 15:30:00 | ES | Futures | 1273.19 | 1275.05 | 1266.2 | 1266.67 | 296578.0 |
| 2008-06-06 16:00:00 | ES | Futures | 1266.67 | 1267.6 | 1265.27 | 1265.97 | 127635.0 |
| 2008-06-06 00:00:00 | NQ | Futures | 2326.27 | 2326.27 | 2324.29 | 2324.57 | 127.0 |
| 2008-06-06 00:30:00 | NQ | Futures | 2324.57 | 2325.7 | 2324.29 | 2325.13 | 80.0 |
| 2008-06-06 01:00:00 | NQ | Futures | 2324.85 | 2325.98 | 2324.57 | 2325.13 | 49.0 |
| 2008-06-06 01:30:00 | NQ | Futures | 2325.98 | 2325.98 | 2323.72 | 2324.85 | 150.0 |
| 2008-06-06 02:00:00 | NQ | Futures | 2324.85 | 2324.85 | 2322.31 | 2322.87 | 237.0 |
| 2008-06-06 02:30:00 | NQ | Futures | 2322.59 | 2324.29 | 2322.31 | 2322.31 | 305.0 |
| 2008-06-06 03:00:00 | NQ | Futures | 2322.59 | 2333.62 | 2322.59 | 2332.49 | 1557.0 |
| 2008-06-06 03:30:00 | NQ | Futures | 2332.2 | 2332.49 | 2330.23 | 2331.07 | 845.0 |
| 2008-06-06 04:00:00 | NQ | Futures | 2330.79 | 2331.07 | 2328.53 | 2329.09 | 1032.0 |
| 2008-06-06 04:30:00 | NQ | Futures | 2329.09 | 2329.09 | 2326.83 | 2328.81 | 392.0 |
| 2008-06-06 05:00:00 | NQ | Futures | 2328.81 | 2330.23 | 2324.57 | 2327.11 | 739.0 |
| 2008-06-06 05:30:00 | NQ | Futures | 2326.55 | 2327.11 | 2322.59 | 2325.7 | 527.0 |
| 2008-06-06 06:00:00 | NQ | Futures | 2325.7 | 2325.98 | 2322.31 | 2324.57 | 319.0 |
| 2008-06-06 06:30:00 | NQ | Futures | 2324.57 | 2329.38 | 2322.87 | 2329.09 | 121.0 |
| 2008-06-06 07:00:00 | NQ | Futures | 2329.09 | 2329.09 | 2322.87 | 2323.15 | 380.0 |
| 2008-06-06 07:30:00 | NQ | Futures | 2323.15 | 2327.68 | 2322.59 | 2327.68 | 423.0 |
| 2008-06-06 08:00:00 | NQ | Futures | 2327.4 | 2332.2 | 2326.83 | 2328.81 | 2643.0 |
> showing 50 of 1,848 rows — these rows as CSV