PREVIEW / futures_30min / 2013-01-21
file: by_date/futures_30min/2013/2013-01-21.parquet size: 52 KB rows: 1,998
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-21 00:00:00 | ES | Futures | 1519.53 | 1519.79 | 1518.51 | 1518.76 | 2064.0 |
| 2013-01-21 00:30:00 | ES | Futures | 1518.76 | 1519.53 | 1518.51 | 1519.02 | 1758.0 |
| 2013-01-21 01:00:00 | ES | Futures | 1519.02 | 1519.28 | 1517.99 | 1518.25 | 1483.0 |
| 2013-01-21 01:30:00 | ES | Futures | 1517.99 | 1518.51 | 1517.74 | 1517.99 | 859.0 |
| 2013-01-21 02:00:00 | ES | Futures | 1517.99 | 1518.25 | 1517.48 | 1518.25 | 2062.0 |
| 2013-01-21 02:30:00 | ES | Futures | 1517.99 | 1519.02 | 1517.48 | 1518.76 | 2845.0 |
| 2013-01-21 03:00:00 | ES | Futures | 1518.76 | 1519.79 | 1518.76 | 1519.02 | 8991.0 |
| 2013-01-21 03:30:00 | ES | Futures | 1519.02 | 1519.28 | 1517.48 | 1517.74 | 4976.0 |
| 2013-01-21 04:00:00 | ES | Futures | 1517.48 | 1518.76 | 1517.22 | 1518.51 | 4562.0 |
| 2013-01-21 04:30:00 | ES | Futures | 1518.51 | 1519.02 | 1518.25 | 1518.76 | 2191.0 |
| 2013-01-21 05:00:00 | ES | Futures | 1518.51 | 1519.02 | 1518.25 | 1519.02 | 2892.0 |
| 2013-01-21 05:30:00 | ES | Futures | 1518.76 | 1519.02 | 1518.51 | 1518.76 | 2177.0 |
| 2013-01-21 06:00:00 | ES | Futures | 1518.51 | 1519.02 | 1518.25 | 1518.76 | 1678.0 |
| 2013-01-21 06:30:00 | ES | Futures | 1518.51 | 1519.02 | 1518.25 | 1518.76 | 1658.0 |
| 2013-01-21 07:00:00 | ES | Futures | 1519.02 | 1519.02 | 1518.51 | 1519.02 | 2122.0 |
| 2013-01-21 07:30:00 | ES | Futures | 1519.02 | 1519.28 | 1517.99 | 1517.99 | 3923.0 |
| 2013-01-21 08:00:00 | ES | Futures | 1518.25 | 1519.28 | 1517.74 | 1518.76 | 7047.0 |
| 2013-01-21 08:30:00 | ES | Futures | 1518.76 | 1519.79 | 1518.51 | 1519.02 | 5870.0 |
| 2013-01-21 09:00:00 | ES | Futures | 1519.02 | 1519.53 | 1518.51 | 1519.02 | 5427.0 |
| 2013-01-21 09:30:00 | ES | Futures | 1518.76 | 1519.79 | 1518.76 | 1519.79 | 5302.0 |
| 2013-01-21 10:00:00 | ES | Futures | 1519.79 | 1521.59 | 1519.53 | 1521.33 | 8494.0 |
| 2013-01-21 10:30:00 | ES | Futures | 1521.33 | 1522.61 | 1521.07 | 1521.59 | 9041.0 |
| 2013-01-21 11:00:00 | ES | Futures | 1521.59 | 1522.87 | 1521.59 | 1522.61 | 9599.0 |
| 2013-01-21 18:00:00 | ES | Futures | 1522.1 | 1522.61 | 1521.33 | 1522.1 | 2479.0 |
| 2013-01-21 18:30:00 | ES | Futures | 1521.84 | 1522.1 | 1521.59 | 1521.84 | 955.0 |
| 2013-01-21 19:00:00 | ES | Futures | 1521.59 | 1521.84 | 1520.56 | 1521.33 | 2190.0 |
| 2013-01-21 19:30:00 | ES | Futures | 1521.59 | 1521.59 | 1521.07 | 1521.07 | 854.0 |
| 2013-01-21 20:00:00 | ES | Futures | 1521.07 | 1521.33 | 1520.3 | 1520.82 | 2295.0 |
| 2013-01-21 20:30:00 | ES | Futures | 1520.82 | 1521.07 | 1519.53 | 1520.3 | 2521.0 |
| 2013-01-21 21:00:00 | ES | Futures | 1520.3 | 1520.56 | 1519.53 | 1520.3 | 1818.0 |
| 2013-01-21 21:30:00 | ES | Futures | 1520.56 | 1521.07 | 1519.79 | 1519.79 | 1165.0 |
| 2013-01-21 22:00:00 | ES | Futures | 1519.79 | 1521.84 | 1519.79 | 1521.33 | 1469.0 |
| 2013-01-21 22:30:00 | ES | Futures | 1521.07 | 1523.38 | 1521.07 | 1521.59 | 6899.0 |
| 2013-01-21 23:00:00 | ES | Futures | 1521.59 | 1523.12 | 1518.51 | 1518.76 | 10806.0 |
| 2013-01-21 23:30:00 | ES | Futures | 1518.76 | 1520.3 | 1518.51 | 1519.28 | 3471.0 |
| 2013-01-21 00:00:00 | NQ | Futures | 3188.95 | 3189.53 | 3187.79 | 3188.37 | 137.0 |
| 2013-01-21 00:30:00 | NQ | Futures | 3187.79 | 3189.53 | 3187.5 | 3188.66 | 65.0 |
| 2013-01-21 01:00:00 | NQ | Futures | 3188.66 | 3188.66 | 3186.92 | 3187.5 | 89.0 |
| 2013-01-21 01:30:00 | NQ | Futures | 3187.5 | 3187.79 | 3186.62 | 3187.21 | 57.0 |
| 2013-01-21 02:00:00 | NQ | Futures | 3186.92 | 3187.21 | 3185.75 | 3186.62 | 206.0 |
| 2013-01-21 02:30:00 | NQ | Futures | 3186.04 | 3187.79 | 3185.17 | 3186.92 | 185.0 |
| 2013-01-21 03:00:00 | NQ | Futures | 3186.62 | 3188.95 | 3186.62 | 3186.92 | 621.0 |
| 2013-01-21 03:30:00 | NQ | Futures | 3186.92 | 3187.5 | 3184.3 | 3184.59 | 465.0 |
| 2013-01-21 04:00:00 | NQ | Futures | 3184.3 | 3185.17 | 3183.71 | 3184.3 | 911.0 |
| 2013-01-21 04:30:00 | NQ | Futures | 3184.59 | 3184.88 | 3183.42 | 3184.0 | 318.0 |
| 2013-01-21 05:00:00 | NQ | Futures | 3184.0 | 3184.0 | 3182.55 | 3183.42 | 333.0 |
| 2013-01-21 05:30:00 | NQ | Futures | 3183.71 | 3184.3 | 3183.71 | 3184.0 | 237.0 |
| 2013-01-21 06:00:00 | NQ | Futures | 3184.3 | 3184.3 | 3181.39 | 3182.26 | 333.0 |
| 2013-01-21 06:30:00 | NQ | Futures | 3182.26 | 3183.42 | 3182.26 | 3183.13 | 153.0 |
| 2013-01-21 07:00:00 | NQ | Futures | 3182.84 | 3183.71 | 3182.84 | 3183.71 | 156.0 |
> showing 50 of 1,998 rows — these rows as CSV