PREVIEW / futures_30min / 2013-01-04
file: by_date/futures_30min/2013/2013-01-04.parquet size: 69 KB rows: 2,357
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-04 00:00:00 | ES | Futures | 1490.02 | 1491.31 | 1489.77 | 1491.31 | 2987.0 |
| 2013-01-04 00:30:00 | ES | Futures | 1491.05 | 1491.82 | 1490.79 | 1491.56 | 2157.0 |
| 2013-01-04 01:00:00 | ES | Futures | 1491.56 | 1491.56 | 1490.79 | 1490.79 | 1335.0 |
| 2013-01-04 01:30:00 | ES | Futures | 1491.05 | 1491.31 | 1490.54 | 1491.05 | 1176.0 |
| 2013-01-04 02:00:00 | ES | Futures | 1490.79 | 1491.31 | 1490.54 | 1491.05 | 2476.0 |
| 2013-01-04 02:30:00 | ES | Futures | 1491.05 | 1492.85 | 1490.79 | 1492.33 | 5829.0 |
| 2013-01-04 03:00:00 | ES | Futures | 1492.08 | 1493.36 | 1491.31 | 1492.59 | 10038.0 |
| 2013-01-04 03:30:00 | ES | Futures | 1492.59 | 1494.9 | 1492.59 | 1493.87 | 8619.0 |
| 2013-01-04 04:00:00 | ES | Futures | 1493.87 | 1494.39 | 1493.36 | 1493.87 | 6366.0 |
| 2013-01-04 04:30:00 | ES | Futures | 1493.87 | 1494.13 | 1491.82 | 1492.33 | 7544.0 |
| 2013-01-04 05:00:00 | ES | Futures | 1492.33 | 1492.59 | 1491.31 | 1491.82 | 8245.0 |
| 2013-01-04 05:30:00 | ES | Futures | 1491.82 | 1492.59 | 1491.56 | 1492.33 | 4304.0 |
| 2013-01-04 06:00:00 | ES | Futures | 1492.08 | 1492.59 | 1491.31 | 1491.82 | 5227.0 |
| 2013-01-04 06:30:00 | ES | Futures | 1492.08 | 1492.33 | 1491.31 | 1492.08 | 7581.0 |
| 2013-01-04 07:00:00 | ES | Futures | 1492.08 | 1493.1 | 1491.82 | 1492.85 | 6598.0 |
| 2013-01-04 07:30:00 | ES | Futures | 1492.59 | 1493.1 | 1491.56 | 1491.82 | 10287.0 |
| 2013-01-04 08:00:00 | ES | Futures | 1491.82 | 1494.64 | 1491.31 | 1493.87 | 25987.0 |
| 2013-01-04 08:30:00 | ES | Futures | 1493.87 | 1495.93 | 1489.51 | 1494.9 | 96499.0 |
| 2013-01-04 09:00:00 | ES | Futures | 1494.9 | 1496.18 | 1494.13 | 1494.64 | 36268.0 |
| 2013-01-04 09:30:00 | ES | Futures | 1494.9 | 1496.7 | 1491.56 | 1496.18 | 139273.0 |
| 2013-01-04 10:00:00 | ES | Futures | 1496.44 | 1497.47 | 1493.1 | 1495.93 | 140266.0 |
| 2013-01-04 10:30:00 | ES | Futures | 1495.93 | 1496.18 | 1492.33 | 1493.62 | 111378.0 |
| 2013-01-04 11:00:00 | ES | Futures | 1493.36 | 1495.93 | 1493.36 | 1494.9 | 78430.0 |
| 2013-01-04 11:30:00 | ES | Futures | 1495.16 | 1497.98 | 1494.64 | 1495.93 | 113808.0 |
| 2013-01-04 12:00:00 | ES | Futures | 1495.93 | 1497.47 | 1495.93 | 1497.21 | 31334.0 |
| 2013-01-04 12:30:00 | ES | Futures | 1497.21 | 1497.72 | 1495.93 | 1496.44 | 33568.0 |
| 2013-01-04 13:00:00 | ES | Futures | 1496.44 | 1497.47 | 1495.67 | 1497.21 | 32232.0 |
| 2013-01-04 13:30:00 | ES | Futures | 1496.95 | 1498.24 | 1496.18 | 1497.21 | 46345.0 |
| 2013-01-04 14:00:00 | ES | Futures | 1497.21 | 1498.24 | 1496.7 | 1497.98 | 58265.0 |
| 2013-01-04 14:30:00 | ES | Futures | 1497.72 | 1498.49 | 1496.7 | 1498.49 | 54894.0 |
| 2013-01-04 15:00:00 | ES | Futures | 1498.49 | 1501.57 | 1497.72 | 1501.06 | 121980.0 |
| 2013-01-04 15:30:00 | ES | Futures | 1500.8 | 1501.31 | 1498.75 | 1499.26 | 154755.0 |
| 2013-01-04 16:00:00 | ES | Futures | 1499.26 | 1499.52 | 1495.93 | 1497.21 | 99929.0 |
| 2013-01-04 16:30:00 | ES | Futures | 1496.95 | 1498.75 | 1496.7 | 1497.72 | 5322.0 |
| 2013-01-04 17:00:00 | ES | Futures | 1497.72 | 1498.24 | 1497.21 | 1498.24 | 1628.0 |
| 2013-01-04 00:00:00 | NQ | Futures | 3169.74 | 3172.07 | 3169.74 | 3171.49 | 170.0 |
| 2013-01-04 00:30:00 | NQ | Futures | 3172.07 | 3173.53 | 3171.49 | 3173.53 | 88.0 |
| 2013-01-04 01:00:00 | NQ | Futures | 3172.94 | 3172.94 | 3171.49 | 3171.78 | 76.0 |
| 2013-01-04 01:30:00 | NQ | Futures | 3171.78 | 3171.78 | 3170.62 | 3170.91 | 41.0 |
| 2013-01-04 02:00:00 | NQ | Futures | 3170.91 | 3172.36 | 3170.62 | 3171.49 | 134.0 |
| 2013-01-04 02:30:00 | NQ | Futures | 3171.49 | 3174.11 | 3171.49 | 3172.94 | 650.0 |
| 2013-01-04 03:00:00 | NQ | Futures | 3172.65 | 3176.73 | 3171.78 | 3176.15 | 1243.0 |
| 2013-01-04 03:30:00 | NQ | Futures | 3175.85 | 3179.93 | 3174.98 | 3178.77 | 884.0 |
| 2013-01-04 04:00:00 | NQ | Futures | 3178.47 | 3180.51 | 3177.6 | 3179.35 | 799.0 |
| 2013-01-04 04:30:00 | NQ | Futures | 3179.35 | 3179.64 | 3174.69 | 3175.85 | 783.0 |
| 2013-01-04 05:00:00 | NQ | Futures | 3175.85 | 3177.02 | 3174.98 | 3175.56 | 725.0 |
| 2013-01-04 05:30:00 | NQ | Futures | 3175.85 | 3177.6 | 3175.85 | 3176.73 | 385.0 |
| 2013-01-04 06:00:00 | NQ | Futures | 3176.73 | 3177.89 | 3175.27 | 3176.15 | 694.0 |
| 2013-01-04 06:30:00 | NQ | Futures | 3176.15 | 3176.73 | 3174.69 | 3176.15 | 706.0 |
| 2013-01-04 07:00:00 | NQ | Futures | 3176.15 | 3179.06 | 3175.85 | 3178.18 | 660.0 |
> showing 50 of 2,357 rows — these rows as CSV