PREVIEW / futures_30min / 2014-06-08
file: by_date/futures_30min/2014/2014-06-08.parquet size: 17 KB rows: 467
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 |
|---|---|---|---|---|---|---|---|
| 2014-06-08 18:00:00 | ES | Futures | 2024.66 | 2025.18 | 2023.88 | 2024.4 | 3970.0 |
| 2014-06-08 18:30:00 | ES | Futures | 2024.4 | 2024.4 | 2023.62 | 2023.88 | 2049.0 |
| 2014-06-08 19:00:00 | ES | Futures | 2023.88 | 2024.4 | 2023.88 | 2024.14 | 317.0 |
| 2014-06-08 19:30:00 | ES | Futures | 2024.14 | 2024.4 | 2023.88 | 2023.88 | 742.0 |
| 2014-06-08 20:00:00 | ES | Futures | 2023.88 | 2024.66 | 2023.62 | 2024.66 | 1088.0 |
| 2014-06-08 20:30:00 | ES | Futures | 2024.4 | 2024.92 | 2024.14 | 2024.4 | 1456.0 |
| 2014-06-08 21:00:00 | ES | Futures | 2024.66 | 2024.66 | 2023.88 | 2024.14 | 879.0 |
| 2014-06-08 21:30:00 | ES | Futures | 2024.14 | 2024.92 | 2023.88 | 2024.4 | 1416.0 |
| 2014-06-08 22:00:00 | ES | Futures | 2024.4 | 2025.18 | 2024.4 | 2024.92 | 2179.0 |
| 2014-06-08 22:30:00 | ES | Futures | 2024.92 | 2025.44 | 2024.66 | 2024.92 | 808.0 |
| 2014-06-08 23:00:00 | ES | Futures | 2024.92 | 2025.18 | 2024.66 | 2024.92 | 407.0 |
| 2014-06-08 23:30:00 | ES | Futures | 2024.92 | 2025.18 | 2023.88 | 2023.88 | 1493.0 |
| 2014-06-08 18:00:00 | NQ | Futures | 4426.58 | 4426.58 | 4423.67 | 4424.25 | 338.0 |
| 2014-06-08 18:30:00 | NQ | Futures | 4423.96 | 4424.25 | 4423.08 | 4424.25 | 199.0 |
| 2014-06-08 19:00:00 | NQ | Futures | 4423.96 | 4424.25 | 4423.67 | 4423.96 | 37.0 |
| 2014-06-08 19:30:00 | NQ | Futures | 4423.96 | 4424.25 | 4423.38 | 4423.96 | 71.0 |
| 2014-06-08 20:00:00 | NQ | Futures | 4423.67 | 4425.12 | 4423.08 | 4424.54 | 131.0 |
| 2014-06-08 20:30:00 | NQ | Futures | 4424.83 | 4425.12 | 4424.25 | 4424.54 | 154.0 |
| 2014-06-08 21:00:00 | NQ | Futures | 4424.54 | 4425.12 | 4423.67 | 4423.96 | 134.0 |
| 2014-06-08 21:30:00 | NQ | Futures | 4423.96 | 4425.7 | 4423.67 | 4424.25 | 221.0 |
| 2014-06-08 22:00:00 | NQ | Futures | 4424.25 | 4426.0 | 4424.25 | 4425.41 | 299.0 |
| 2014-06-08 22:30:00 | NQ | Futures | 4425.41 | 4426.0 | 4424.54 | 4424.54 | 115.0 |
| 2014-06-08 23:00:00 | NQ | Futures | 4424.54 | 4425.41 | 4424.54 | 4425.41 | 72.0 |
| 2014-06-08 23:30:00 | NQ | Futures | 4425.41 | 4425.41 | 4423.08 | 4423.38 | 281.0 |
| 2014-06-08 18:00:00 | YM | Futures | 17445.8 | 17445.8 | 17434.5 | 17437.6 | 323.0 |
| 2014-06-08 18:30:00 | YM | Futures | 17437.6 | 17437.6 | 17432.4 | 17433.5 | 217.0 |
| 2014-06-08 19:00:00 | YM | Futures | 17433.5 | 17438.6 | 17433.5 | 17437.6 | 42.0 |
| 2014-06-08 19:30:00 | YM | Futures | 17435.5 | 17435.5 | 17433.5 | 17434.5 | 32.0 |
| 2014-06-08 20:00:00 | YM | Futures | 17434.5 | 17437.6 | 17432.4 | 17436.6 | 118.0 |
| 2014-06-08 20:30:00 | YM | Futures | 17437.6 | 17441.7 | 17435.5 | 17438.6 | 145.0 |
| 2014-06-08 21:00:00 | YM | Futures | 17437.6 | 17438.6 | 17434.5 | 17435.5 | 98.0 |
| 2014-06-08 21:30:00 | YM | Futures | 17435.5 | 17441.7 | 17435.5 | 17438.6 | 306.0 |
| 2014-06-08 22:00:00 | YM | Futures | 17439.6 | 17443.8 | 17438.6 | 17443.8 | 272.0 |
| 2014-06-08 22:30:00 | YM | Futures | 17444.8 | 17446.9 | 17440.7 | 17442.7 | 483.0 |
| 2014-06-08 23:00:00 | YM | Futures | 17442.7 | 17444.8 | 17440.7 | 17444.8 | 120.0 |
| 2014-06-08 23:30:00 | YM | Futures | 17444.8 | 17444.8 | 17435.5 | 17437.6 | 204.0 |
| 2014-06-08 18:00:00 | CL | Futures | 165.91 | 165.91 | 165.65 | 165.78 | 696.0 |
| 2014-06-08 18:30:00 | CL | Futures | 165.8 | 165.8 | 165.68 | 165.7 | 146.0 |
| 2014-06-08 19:00:00 | CL | Futures | 165.7 | 165.85 | 165.68 | 165.83 | 315.0 |
| 2014-06-08 19:30:00 | CL | Futures | 165.83 | 165.83 | 165.7 | 165.8 | 210.0 |
| 2014-06-08 20:00:00 | CL | Futures | 165.81 | 165.91 | 165.81 | 165.86 | 164.0 |
| 2014-06-08 20:30:00 | CL | Futures | 165.88 | 165.96 | 165.86 | 165.96 | 255.0 |
| 2014-06-08 21:00:00 | CL | Futures | 165.96 | 166.06 | 165.94 | 165.99 | 291.0 |
| 2014-06-08 21:30:00 | CL | Futures | 165.99 | 166.02 | 165.86 | 165.94 | 171.0 |
| 2014-06-08 22:00:00 | CL | Futures | 165.94 | 165.96 | 165.86 | 165.93 | 118.0 |
| 2014-06-08 22:30:00 | CL | Futures | 165.91 | 166.01 | 165.85 | 165.94 | 346.0 |
| 2014-06-08 23:00:00 | CL | Futures | 165.93 | 166.1 | 165.93 | 165.99 | 401.0 |
| 2014-06-08 23:30:00 | CL | Futures | 165.99 | 165.99 | 165.85 | 165.98 | 203.0 |
| 2014-06-08 18:00:00 | GC | Futures | 1716.2 | 1716.3 | 1714.4 | 1716.1 | 340.0 |
| 2014-06-08 18:30:00 | GC | Futures | 1715.9 | 1717.2 | 1715.7 | 1716.6 | 186.0 |
> showing 50 of 467 rows — these rows as CSV