PREVIEW / futures_1hour / 2017-04-21
file: by_date/futures_1hour/2017/2017-04-21.parquet size: 45 KB rows: 1,346
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 |
|---|---|---|---|---|---|---|---|
| 2017-04-21 00:00:00 | ES | Futures | 2569.46 | 2570.55 | 2569.46 | 2570.0 | 2148.0 |
| 2017-04-21 01:00:00 | ES | Futures | 2570.28 | 2573.55 | 2570.0 | 2573.28 | 6191.0 |
| 2017-04-21 02:00:00 | ES | Futures | 2573.01 | 2574.1 | 2572.19 | 2573.55 | 9823.0 |
| 2017-04-21 03:00:00 | ES | Futures | 2573.83 | 2574.1 | 2571.37 | 2573.01 | 21126.0 |
| 2017-04-21 04:00:00 | ES | Futures | 2573.28 | 2573.55 | 2570.55 | 2572.19 | 10514.0 |
| 2017-04-21 05:00:00 | ES | Futures | 2571.91 | 2573.01 | 2570.28 | 2571.91 | 14316.0 |
| 2017-04-21 06:00:00 | ES | Futures | 2571.64 | 2572.73 | 2570.55 | 2572.46 | 10497.0 |
| 2017-04-21 07:00:00 | ES | Futures | 2572.46 | 2573.83 | 2572.19 | 2572.46 | 11969.0 |
| 2017-04-21 08:00:00 | ES | Futures | 2572.19 | 2573.55 | 2571.37 | 2571.64 | 18522.0 |
| 2017-04-21 09:00:00 | ES | Futures | 2571.64 | 2571.91 | 2566.18 | 2567.54 | 173595.0 |
| 2017-04-21 10:00:00 | ES | Futures | 2567.82 | 2569.46 | 2564.27 | 2565.91 | 140181.0 |
| 2017-04-21 11:00:00 | ES | Futures | 2565.91 | 2568.36 | 2562.35 | 2567.0 | 144830.0 |
| 2017-04-21 12:00:00 | ES | Futures | 2567.27 | 2567.27 | 2562.9 | 2563.99 | 99697.0 |
| 2017-04-21 13:00:00 | ES | Futures | 2563.99 | 2565.63 | 2557.16 | 2564.81 | 168349.0 |
| 2017-04-21 14:00:00 | ES | Futures | 2564.54 | 2567.0 | 2563.17 | 2565.09 | 104508.0 |
| 2017-04-21 15:00:00 | ES | Futures | 2565.09 | 2566.18 | 2560.99 | 2562.35 | 211415.0 |
| 2017-04-21 16:00:00 | ES | Futures | 2562.63 | 2565.09 | 2561.81 | 2562.35 | 89134.0 |
| 2017-04-21 00:00:00 | NQ | Futures | 6494.98 | 6497.37 | 6494.98 | 6497.07 | 299.0 |
| 2017-04-21 01:00:00 | NQ | Futures | 6497.07 | 6503.33 | 6496.18 | 6502.14 | 1163.0 |
| 2017-04-21 02:00:00 | NQ | Futures | 6501.84 | 6505.12 | 6501.25 | 6503.93 | 1838.0 |
| 2017-04-21 03:00:00 | NQ | Futures | 6503.93 | 6504.52 | 6498.56 | 6503.63 | 3729.0 |
| 2017-04-21 04:00:00 | NQ | Futures | 6503.33 | 6504.52 | 6498.56 | 6501.84 | 2545.0 |
| 2017-04-21 05:00:00 | NQ | Futures | 6501.25 | 6504.82 | 6497.97 | 6502.74 | 2246.0 |
| 2017-04-21 06:00:00 | NQ | Futures | 6502.74 | 6504.23 | 6498.86 | 6502.44 | 2137.0 |
| 2017-04-21 07:00:00 | NQ | Futures | 6502.44 | 6505.12 | 6499.75 | 6500.05 | 1958.0 |
| 2017-04-21 08:00:00 | NQ | Futures | 6500.65 | 6501.84 | 6496.47 | 6496.77 | 4581.0 |
| 2017-04-21 09:00:00 | NQ | Futures | 6497.07 | 6498.26 | 6479.48 | 6485.44 | 30926.0 |
| 2017-04-21 10:00:00 | NQ | Futures | 6485.44 | 6492.9 | 6481.57 | 6485.44 | 23249.0 |
| 2017-04-21 11:00:00 | NQ | Futures | 6485.74 | 6499.16 | 6481.27 | 6496.47 | 23078.0 |
| 2017-04-21 12:00:00 | NQ | Futures | 6496.47 | 6497.67 | 6485.74 | 6487.53 | 13968.0 |
| 2017-04-21 13:00:00 | NQ | Futures | 6487.83 | 6489.62 | 6472.62 | 6486.64 | 24240.0 |
| 2017-04-21 14:00:00 | NQ | Futures | 6486.64 | 6488.13 | 6480.08 | 6484.55 | 14766.0 |
| 2017-04-21 15:00:00 | NQ | Futures | 6484.85 | 6490.51 | 6477.1 | 6487.53 | 25992.0 |
| 2017-04-21 16:00:00 | NQ | Futures | 6487.53 | 6491.7 | 6482.76 | 6482.76 | 6651.0 |
| 2017-04-21 00:00:00 | YM | Futures | 22295.5 | 22304.2 | 22294.4 | 22303.1 | 380.0 |
| 2017-04-21 01:00:00 | YM | Futures | 22303.1 | 22330.3 | 22301.0 | 22327.0 | 1559.0 |
| 2017-04-21 02:00:00 | YM | Futures | 22327.0 | 22336.8 | 22317.3 | 22329.2 | 2097.0 |
| 2017-04-21 03:00:00 | YM | Futures | 22329.2 | 22330.3 | 22306.4 | 22317.3 | 3470.0 |
| 2017-04-21 04:00:00 | YM | Futures | 22317.3 | 22324.9 | 22301.0 | 22315.1 | 2187.0 |
| 2017-04-21 05:00:00 | YM | Futures | 22314.0 | 22320.5 | 22298.8 | 22310.7 | 2101.0 |
| 2017-04-21 06:00:00 | YM | Futures | 22311.8 | 22317.3 | 22301.0 | 22317.3 | 1458.0 |
| 2017-04-21 07:00:00 | YM | Futures | 22317.3 | 22329.2 | 22315.1 | 22320.5 | 1802.0 |
| 2017-04-21 08:00:00 | YM | Futures | 22320.5 | 22332.5 | 22311.8 | 22311.8 | 2564.0 |
| 2017-04-21 09:00:00 | YM | Futures | 22312.9 | 22320.5 | 22277.0 | 22287.9 | 16604.0 |
| 2017-04-21 10:00:00 | YM | Futures | 22289.0 | 22309.6 | 22273.8 | 22286.8 | 12838.0 |
| 2017-04-21 11:00:00 | YM | Futures | 22287.9 | 22319.4 | 22264.0 | 22307.5 | 12524.0 |
| 2017-04-21 12:00:00 | YM | Futures | 22307.5 | 22308.6 | 22273.8 | 22279.2 | 8152.0 |
| 2017-04-21 13:00:00 | YM | Futures | 22278.1 | 22298.8 | 22217.3 | 22290.1 | 15380.0 |
| 2017-04-21 14:00:00 | YM | Futures | 22290.1 | 22312.9 | 22282.5 | 22299.9 | 9321.0 |
| 2017-04-21 15:00:00 | YM | Futures | 22299.9 | 22302.0 | 22265.1 | 22268.4 | 15486.0 |
> showing 50 of 1,346 rows — these rows as CSV