PREVIEW / futures_30min / 2013-03-08
file: by_date/futures_30min/2013/2013-03-08.parquet size: 66 KB rows: 2,331
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-03-08 00:00:00 | ES | Futures | 1583.94 | 1584.45 | 1583.68 | 1584.19 | 891.0 |
| 2013-03-08 00:30:00 | ES | Futures | 1584.19 | 1584.71 | 1583.94 | 1584.71 | 675.0 |
| 2013-03-08 01:00:00 | ES | Futures | 1584.71 | 1584.96 | 1584.19 | 1584.96 | 1258.0 |
| 2013-03-08 01:30:00 | ES | Futures | 1584.71 | 1584.96 | 1583.94 | 1584.19 | 772.0 |
| 2013-03-08 02:00:00 | ES | Futures | 1584.45 | 1586.25 | 1584.19 | 1585.22 | 3803.0 |
| 2013-03-08 02:30:00 | ES | Futures | 1585.22 | 1586.25 | 1585.22 | 1585.73 | 2481.0 |
| 2013-03-08 03:00:00 | ES | Futures | 1585.73 | 1588.81 | 1585.48 | 1587.27 | 10786.0 |
| 2013-03-08 03:30:00 | ES | Futures | 1587.53 | 1588.3 | 1586.5 | 1587.79 | 5254.0 |
| 2013-03-08 04:00:00 | ES | Futures | 1587.53 | 1588.56 | 1587.27 | 1587.79 | 5155.0 |
| 2013-03-08 04:30:00 | ES | Futures | 1587.79 | 1588.04 | 1587.53 | 1587.79 | 1577.0 |
| 2013-03-08 05:00:00 | ES | Futures | 1587.53 | 1588.81 | 1587.53 | 1588.56 | 2498.0 |
| 2013-03-08 05:30:00 | ES | Futures | 1588.56 | 1589.58 | 1588.04 | 1589.07 | 3795.0 |
| 2013-03-08 06:00:00 | ES | Futures | 1588.81 | 1589.07 | 1587.79 | 1588.3 | 3735.0 |
| 2013-03-08 06:30:00 | ES | Futures | 1588.04 | 1589.58 | 1588.04 | 1589.07 | 4727.0 |
| 2013-03-08 07:00:00 | ES | Futures | 1589.07 | 1589.33 | 1587.53 | 1588.04 | 4942.0 |
| 2013-03-08 07:30:00 | ES | Futures | 1587.79 | 1588.56 | 1587.27 | 1587.79 | 5163.0 |
| 2013-03-08 08:00:00 | ES | Futures | 1587.79 | 1588.56 | 1587.27 | 1588.3 | 11660.0 |
| 2013-03-08 08:30:00 | ES | Futures | 1588.04 | 1594.46 | 1587.53 | 1589.33 | 90500.0 |
| 2013-03-08 09:00:00 | ES | Futures | 1589.33 | 1591.63 | 1589.07 | 1590.86 | 21747.0 |
| 2013-03-08 09:30:00 | ES | Futures | 1590.86 | 1592.4 | 1585.22 | 1586.76 | 99312.0 |
| 2013-03-08 10:00:00 | ES | Futures | 1586.5 | 1586.76 | 1582.91 | 1586.25 | 69126.0 |
| 2013-03-08 10:30:00 | ES | Futures | 1585.99 | 1587.79 | 1585.22 | 1586.76 | 36369.0 |
| 2013-03-08 11:00:00 | ES | Futures | 1586.5 | 1588.3 | 1585.22 | 1587.53 | 28611.0 |
| 2013-03-08 11:30:00 | ES | Futures | 1587.79 | 1589.33 | 1587.53 | 1589.07 | 32160.0 |
| 2013-03-08 12:00:00 | ES | Futures | 1589.07 | 1589.84 | 1586.5 | 1586.5 | 32583.0 |
| 2013-03-08 12:30:00 | ES | Futures | 1586.5 | 1588.04 | 1585.73 | 1588.04 | 18558.0 |
| 2013-03-08 13:00:00 | ES | Futures | 1587.79 | 1589.07 | 1587.02 | 1588.04 | 13306.0 |
| 2013-03-08 13:30:00 | ES | Futures | 1588.04 | 1589.58 | 1587.79 | 1589.07 | 10799.0 |
| 2013-03-08 14:00:00 | ES | Futures | 1589.33 | 1589.58 | 1588.3 | 1589.58 | 7070.0 |
| 2013-03-08 14:30:00 | ES | Futures | 1589.33 | 1590.09 | 1588.81 | 1589.84 | 10981.0 |
| 2013-03-08 15:00:00 | ES | Futures | 1589.58 | 1591.63 | 1589.58 | 1591.12 | 17831.0 |
| 2013-03-08 15:30:00 | ES | Futures | 1591.12 | 1592.92 | 1590.35 | 1590.61 | 49007.0 |
| 2013-03-08 16:00:00 | ES | Futures | 1590.61 | 1591.12 | 1589.84 | 1590.61 | 31570.0 |
| 2013-03-08 16:30:00 | ES | Futures | 1590.86 | 1591.38 | 1590.35 | 1590.61 | 3301.0 |
| 2013-03-08 17:00:00 | ES | Futures | 1590.61 | 1591.63 | 1590.61 | 1591.12 | 1117.0 |
| 2013-03-08 00:00:00 | NQ | Futures | 3259.97 | 3259.97 | 3259.1 | 3259.97 | 169.0 |
| 2013-03-08 00:30:00 | NQ | Futures | 3259.97 | 3260.85 | 3259.68 | 3260.85 | 14.0 |
| 2013-03-08 01:00:00 | NQ | Futures | 3260.85 | 3261.43 | 3259.68 | 3261.43 | 163.0 |
| 2013-03-08 01:30:00 | NQ | Futures | 3261.72 | 3261.72 | 3260.56 | 3261.14 | 47.0 |
| 2013-03-08 02:00:00 | NQ | Futures | 3261.14 | 3264.92 | 3261.14 | 3263.47 | 237.0 |
| 2013-03-08 02:30:00 | NQ | Futures | 3263.47 | 3264.63 | 3263.18 | 3264.05 | 80.0 |
| 2013-03-08 03:00:00 | NQ | Futures | 3263.76 | 3268.12 | 3262.88 | 3264.92 | 496.0 |
| 2013-03-08 03:30:00 | NQ | Futures | 3264.92 | 3266.38 | 3263.47 | 3265.5 | 269.0 |
| 2013-03-08 04:00:00 | NQ | Futures | 3265.5 | 3266.67 | 3263.76 | 3263.76 | 615.0 |
| 2013-03-08 04:30:00 | NQ | Futures | 3263.47 | 3264.92 | 3263.18 | 3264.63 | 365.0 |
| 2013-03-08 05:00:00 | NQ | Futures | 3264.34 | 3265.8 | 3263.76 | 3264.92 | 432.0 |
| 2013-03-08 05:30:00 | NQ | Futures | 3265.21 | 3269.58 | 3264.63 | 3268.41 | 497.0 |
| 2013-03-08 06:00:00 | NQ | Futures | 3268.12 | 3268.41 | 3266.09 | 3266.67 | 299.0 |
| 2013-03-08 06:30:00 | NQ | Futures | 3266.96 | 3269.0 | 3266.67 | 3268.12 | 221.0 |
| 2013-03-08 07:00:00 | NQ | Futures | 3267.83 | 3268.71 | 3266.09 | 3266.38 | 436.0 |
> showing 50 of 2,331 rows — these rows as CSV