PREVIEW / futures_30min / 2013-01-10
file: by_date/futures_30min/2013/2013-01-10.parquet size: 79 KB rows: 2,927
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 |
|---|---|---|---|---|---|---|---|
| 2013-01-10 00:00:00 | ES | Futures | 1497.47 | 1497.98 | 1497.47 | 1497.72 | 694.0 |
| 2013-01-10 00:30:00 | ES | Futures | 1497.72 | 1498.24 | 1497.21 | 1497.47 | 1589.0 |
| 2013-01-10 01:00:00 | ES | Futures | 1497.47 | 1497.72 | 1496.95 | 1497.21 | 1523.0 |
| 2013-01-10 01:30:00 | ES | Futures | 1497.47 | 1497.98 | 1496.95 | 1497.98 | 1339.0 |
| 2013-01-10 02:00:00 | ES | Futures | 1497.98 | 1497.98 | 1497.21 | 1497.72 | 1533.0 |
| 2013-01-10 02:30:00 | ES | Futures | 1497.72 | 1498.49 | 1496.95 | 1497.21 | 3609.0 |
| 2013-01-10 03:00:00 | ES | Futures | 1497.21 | 1497.47 | 1495.67 | 1495.93 | 7908.0 |
| 2013-01-10 03:30:00 | ES | Futures | 1495.93 | 1496.7 | 1495.41 | 1496.7 | 6439.0 |
| 2013-01-10 04:00:00 | ES | Futures | 1496.7 | 1498.24 | 1496.7 | 1497.47 | 8034.0 |
| 2013-01-10 04:30:00 | ES | Futures | 1497.72 | 1499.26 | 1497.47 | 1499.01 | 12215.0 |
| 2013-01-10 05:00:00 | ES | Futures | 1499.26 | 1499.52 | 1498.24 | 1498.49 | 10063.0 |
| 2013-01-10 05:30:00 | ES | Futures | 1498.24 | 1499.01 | 1497.98 | 1498.24 | 6880.0 |
| 2013-01-10 06:00:00 | ES | Futures | 1497.98 | 1498.24 | 1497.72 | 1497.72 | 7203.0 |
| 2013-01-10 06:30:00 | ES | Futures | 1497.98 | 1498.49 | 1497.72 | 1497.98 | 6703.0 |
| 2013-01-10 07:00:00 | ES | Futures | 1497.98 | 1498.49 | 1497.21 | 1497.72 | 11475.0 |
| 2013-01-10 07:30:00 | ES | Futures | 1497.98 | 1499.77 | 1497.98 | 1499.52 | 12855.0 |
| 2013-01-10 08:00:00 | ES | Futures | 1499.77 | 1500.8 | 1499.26 | 1500.54 | 22490.0 |
| 2013-01-10 08:30:00 | ES | Futures | 1500.54 | 1503.62 | 1500.03 | 1501.83 | 66902.0 |
| 2013-01-10 09:00:00 | ES | Futures | 1502.08 | 1502.6 | 1501.06 | 1502.08 | 24030.0 |
| 2013-01-10 09:30:00 | ES | Futures | 1502.08 | 1503.37 | 1499.01 | 1501.31 | 157854.0 |
| 2013-01-10 10:00:00 | ES | Futures | 1501.06 | 1502.08 | 1499.52 | 1499.52 | 117873.0 |
| 2013-01-10 10:30:00 | ES | Futures | 1499.77 | 1499.77 | 1495.93 | 1496.18 | 196524.0 |
| 2013-01-10 11:00:00 | ES | Futures | 1496.18 | 1497.21 | 1494.13 | 1496.7 | 128632.0 |
| 2013-01-10 11:30:00 | ES | Futures | 1496.7 | 1497.98 | 1496.18 | 1497.47 | 55360.0 |
| 2013-01-10 12:00:00 | ES | Futures | 1497.47 | 1498.75 | 1496.7 | 1498.24 | 52458.0 |
| 2013-01-10 12:30:00 | ES | Futures | 1498.24 | 1500.8 | 1497.98 | 1500.54 | 67087.0 |
| 2013-01-10 13:00:00 | ES | Futures | 1500.54 | 1501.06 | 1498.75 | 1499.26 | 46327.0 |
| 2013-01-10 13:30:00 | ES | Futures | 1499.26 | 1501.06 | 1499.01 | 1500.03 | 39191.0 |
| 2013-01-10 14:00:00 | ES | Futures | 1500.29 | 1500.8 | 1498.75 | 1499.52 | 45854.0 |
| 2013-01-10 14:30:00 | ES | Futures | 1499.26 | 1503.62 | 1499.01 | 1503.11 | 90023.0 |
| 2013-01-10 15:00:00 | ES | Futures | 1503.11 | 1504.91 | 1502.85 | 1504.65 | 86108.0 |
| 2013-01-10 15:30:00 | ES | Futures | 1504.65 | 1505.93 | 1504.14 | 1505.68 | 117055.0 |
| 2013-01-10 16:00:00 | ES | Futures | 1505.68 | 1506.19 | 1504.91 | 1505.42 | 70050.0 |
| 2013-01-10 16:30:00 | ES | Futures | 1505.68 | 1507.47 | 1505.42 | 1507.22 | 10648.0 |
| 2013-01-10 17:00:00 | ES | Futures | 1507.22 | 1509.01 | 1506.96 | 1508.76 | 6936.0 |
| 2013-01-10 18:00:00 | ES | Futures | 1508.5 | 1510.3 | 1507.47 | 1507.99 | 11752.0 |
| 2013-01-10 18:30:00 | ES | Futures | 1507.99 | 1509.27 | 1507.99 | 1508.5 | 2392.0 |
| 2013-01-10 19:00:00 | ES | Futures | 1508.5 | 1508.5 | 1507.47 | 1507.73 | 4178.0 |
| 2013-01-10 19:30:00 | ES | Futures | 1507.73 | 1507.99 | 1506.96 | 1507.47 | 1699.0 |
| 2013-01-10 20:00:00 | ES | Futures | 1507.47 | 1507.47 | 1506.19 | 1506.96 | 2929.0 |
| 2013-01-10 20:30:00 | ES | Futures | 1506.7 | 1507.22 | 1506.19 | 1506.19 | 2933.0 |
| 2013-01-10 21:00:00 | ES | Futures | 1506.45 | 1506.7 | 1505.93 | 1506.19 | 2112.0 |
| 2013-01-10 21:30:00 | ES | Futures | 1506.19 | 1506.96 | 1505.68 | 1506.7 | 2794.0 |
| 2013-01-10 22:00:00 | ES | Futures | 1506.96 | 1506.96 | 1506.19 | 1506.45 | 1746.0 |
| 2013-01-10 22:30:00 | ES | Futures | 1506.45 | 1506.7 | 1505.93 | 1506.19 | 1530.0 |
| 2013-01-10 23:00:00 | ES | Futures | 1505.93 | 1506.7 | 1505.68 | 1505.93 | 2023.0 |
| 2013-01-10 23:30:00 | ES | Futures | 1505.93 | 1506.45 | 1505.68 | 1506.19 | 1452.0 |
| 2013-01-10 00:00:00 | NQ | Futures | 3177.89 | 3178.47 | 3177.31 | 3178.18 | 122.0 |
| 2013-01-10 00:30:00 | NQ | Futures | 3178.18 | 3178.47 | 3177.02 | 3177.31 | 94.0 |
| 2013-01-10 01:00:00 | NQ | Futures | 3177.31 | 3178.18 | 3176.44 | 3177.31 | 138.0 |
> showing 50 of 2,927 rows — these rows as CSV