PREVIEW / futures_30min / 2013-04-05
file: by_date/futures_30min/2013/2013-04-05.parquet size: 71 KB rows: 2,400
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-04-05 00:00:00 | ES | Futures | 1598.31 | 1598.57 | 1597.54 | 1598.05 | 3195.0 |
| 2013-04-05 00:30:00 | ES | Futures | 1598.05 | 1598.31 | 1597.54 | 1597.8 | 2088.0 |
| 2013-04-05 01:00:00 | ES | Futures | 1597.54 | 1598.31 | 1597.28 | 1597.54 | 3446.0 |
| 2013-04-05 01:30:00 | ES | Futures | 1597.54 | 1598.57 | 1597.54 | 1598.05 | 1962.0 |
| 2013-04-05 02:00:00 | ES | Futures | 1598.31 | 1599.34 | 1597.8 | 1599.08 | 5303.0 |
| 2013-04-05 02:30:00 | ES | Futures | 1599.08 | 1599.6 | 1598.31 | 1599.08 | 4702.0 |
| 2013-04-05 03:00:00 | ES | Futures | 1599.08 | 1599.6 | 1598.05 | 1599.08 | 10296.0 |
| 2013-04-05 03:30:00 | ES | Futures | 1598.83 | 1599.08 | 1597.54 | 1598.83 | 9217.0 |
| 2013-04-05 04:00:00 | ES | Futures | 1598.83 | 1599.86 | 1598.57 | 1599.08 | 8055.0 |
| 2013-04-05 04:30:00 | ES | Futures | 1599.08 | 1599.6 | 1598.05 | 1598.31 | 9622.0 |
| 2013-04-05 05:00:00 | ES | Futures | 1598.31 | 1599.08 | 1597.54 | 1597.8 | 7642.0 |
| 2013-04-05 05:30:00 | ES | Futures | 1597.8 | 1598.57 | 1595.22 | 1595.73 | 20200.0 |
| 2013-04-05 06:00:00 | ES | Futures | 1595.99 | 1597.28 | 1594.45 | 1595.22 | 21201.0 |
| 2013-04-05 06:30:00 | ES | Futures | 1595.22 | 1595.22 | 1592.64 | 1592.9 | 35059.0 |
| 2013-04-05 07:00:00 | ES | Futures | 1592.9 | 1593.93 | 1590.84 | 1591.61 | 29129.0 |
| 2013-04-05 07:30:00 | ES | Futures | 1591.61 | 1593.16 | 1590.07 | 1592.64 | 30084.0 |
| 2013-04-05 08:00:00 | ES | Futures | 1592.39 | 1592.9 | 1590.84 | 1591.87 | 37052.0 |
| 2013-04-05 08:30:00 | ES | Futures | 1591.36 | 1591.61 | 1579.76 | 1581.31 | 242807.0 |
| 2013-04-05 09:00:00 | ES | Futures | 1581.31 | 1584.66 | 1580.28 | 1581.57 | 86695.0 |
| 2013-04-05 09:30:00 | ES | Futures | 1581.83 | 1585.43 | 1579.76 | 1581.57 | 274491.0 |
| 2013-04-05 10:00:00 | ES | Futures | 1581.83 | 1585.43 | 1580.02 | 1584.92 | 181285.0 |
| 2013-04-05 10:30:00 | ES | Futures | 1584.92 | 1587.49 | 1583.11 | 1585.95 | 197387.0 |
| 2013-04-05 11:00:00 | ES | Futures | 1586.2 | 1589.3 | 1585.69 | 1587.75 | 157162.0 |
| 2013-04-05 11:30:00 | ES | Futures | 1587.75 | 1588.27 | 1585.95 | 1585.95 | 87723.0 |
| 2013-04-05 12:00:00 | ES | Futures | 1585.69 | 1586.72 | 1584.92 | 1585.69 | 86961.0 |
| 2013-04-05 12:30:00 | ES | Futures | 1585.69 | 1588.27 | 1585.43 | 1586.2 | 56868.0 |
| 2013-04-05 13:00:00 | ES | Futures | 1586.2 | 1589.81 | 1585.69 | 1589.04 | 59362.0 |
| 2013-04-05 13:30:00 | ES | Futures | 1589.3 | 1590.58 | 1588.01 | 1588.27 | 69433.0 |
| 2013-04-05 14:00:00 | ES | Futures | 1588.27 | 1589.81 | 1587.23 | 1589.55 | 61703.0 |
| 2013-04-05 14:30:00 | ES | Futures | 1589.3 | 1591.1 | 1589.04 | 1590.58 | 69743.0 |
| 2013-04-05 15:00:00 | ES | Futures | 1590.58 | 1590.84 | 1588.52 | 1589.3 | 67628.0 |
| 2013-04-05 15:30:00 | ES | Futures | 1589.55 | 1596.25 | 1588.52 | 1594.45 | 205438.0 |
| 2013-04-05 16:00:00 | ES | Futures | 1594.7 | 1594.96 | 1592.13 | 1592.9 | 87629.0 |
| 2013-04-05 16:30:00 | ES | Futures | 1592.9 | 1594.19 | 1592.64 | 1594.19 | 7608.0 |
| 2013-04-05 17:00:00 | ES | Futures | 1593.93 | 1594.45 | 1593.93 | 1593.93 | 1501.0 |
| 2013-04-05 00:00:00 | NQ | Futures | 3243.35 | 3243.64 | 3241.89 | 3242.18 | 315.0 |
| 2013-04-05 00:30:00 | NQ | Futures | 3242.18 | 3242.76 | 3241.31 | 3241.6 | 212.0 |
| 2013-04-05 01:00:00 | NQ | Futures | 3241.6 | 3242.18 | 3239.85 | 3240.72 | 232.0 |
| 2013-04-05 01:30:00 | NQ | Futures | 3240.72 | 3242.76 | 3240.14 | 3242.76 | 312.0 |
| 2013-04-05 02:00:00 | NQ | Futures | 3242.18 | 3244.22 | 3241.6 | 3243.93 | 294.0 |
| 2013-04-05 02:30:00 | NQ | Futures | 3244.51 | 3245.39 | 3243.06 | 3243.93 | 351.0 |
| 2013-04-05 03:00:00 | NQ | Futures | 3243.93 | 3245.97 | 3241.01 | 3244.51 | 921.0 |
| 2013-04-05 03:30:00 | NQ | Futures | 3244.22 | 3244.51 | 3240.43 | 3243.35 | 775.0 |
| 2013-04-05 04:00:00 | NQ | Futures | 3243.64 | 3245.97 | 3242.76 | 3243.64 | 852.0 |
| 2013-04-05 04:30:00 | NQ | Futures | 3243.64 | 3243.64 | 3240.14 | 3241.31 | 967.0 |
| 2013-04-05 05:00:00 | NQ | Futures | 3241.31 | 3242.18 | 3238.68 | 3239.56 | 842.0 |
| 2013-04-05 05:30:00 | NQ | Futures | 3239.56 | 3240.72 | 3234.01 | 3235.18 | 2241.0 |
| 2013-04-05 06:00:00 | NQ | Futures | 3235.18 | 3237.22 | 3231.68 | 3233.14 | 2008.0 |
| 2013-04-05 06:30:00 | NQ | Futures | 3233.14 | 3233.14 | 3228.18 | 3229.93 | 3860.0 |
| 2013-04-05 07:00:00 | NQ | Futures | 3229.93 | 3231.97 | 3226.14 | 3226.72 | 2282.0 |
> showing 50 of 2,400 rows — these rows as CSV