PREVIEW / futures_30min / 2013-05-07
file: by_date/futures_30min/2013/2013-05-07.parquet size: 75 KB rows: 2,863
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-05-07 00:00:00 | ES | Futures | 1660.9 | 1660.9 | 1659.87 | 1660.13 | 921.0 |
| 2013-05-07 00:30:00 | ES | Futures | 1659.87 | 1660.9 | 1659.87 | 1660.39 | 2265.0 |
| 2013-05-07 01:00:00 | ES | Futures | 1660.65 | 1661.42 | 1660.39 | 1660.9 | 2101.0 |
| 2013-05-07 01:30:00 | ES | Futures | 1660.9 | 1661.42 | 1660.9 | 1661.16 | 1557.0 |
| 2013-05-07 02:00:00 | ES | Futures | 1661.16 | 1661.68 | 1659.87 | 1660.13 | 4209.0 |
| 2013-05-07 02:30:00 | ES | Futures | 1660.13 | 1660.9 | 1660.13 | 1660.39 | 3398.0 |
| 2013-05-07 03:00:00 | ES | Futures | 1660.39 | 1661.68 | 1659.87 | 1661.16 | 10037.0 |
| 2013-05-07 03:30:00 | ES | Futures | 1660.9 | 1661.42 | 1660.13 | 1660.9 | 4728.0 |
| 2013-05-07 04:00:00 | ES | Futures | 1660.9 | 1662.19 | 1660.9 | 1661.68 | 6095.0 |
| 2013-05-07 04:30:00 | ES | Futures | 1661.68 | 1662.45 | 1661.42 | 1662.19 | 5445.0 |
| 2013-05-07 05:00:00 | ES | Futures | 1662.19 | 1663.48 | 1661.68 | 1663.22 | 9241.0 |
| 2013-05-07 05:30:00 | ES | Futures | 1663.22 | 1663.74 | 1662.71 | 1663.74 | 4181.0 |
| 2013-05-07 06:00:00 | ES | Futures | 1663.74 | 1664.25 | 1663.22 | 1663.99 | 11625.0 |
| 2013-05-07 06:30:00 | ES | Futures | 1663.99 | 1665.03 | 1663.99 | 1664.25 | 13214.0 |
| 2013-05-07 07:00:00 | ES | Futures | 1664.51 | 1665.03 | 1663.99 | 1664.25 | 9019.0 |
| 2013-05-07 07:30:00 | ES | Futures | 1664.51 | 1665.54 | 1664.25 | 1665.03 | 15623.0 |
| 2013-05-07 08:00:00 | ES | Futures | 1665.03 | 1666.06 | 1664.51 | 1665.54 | 27183.0 |
| 2013-05-07 08:30:00 | ES | Futures | 1665.54 | 1665.54 | 1663.99 | 1664.25 | 19221.0 |
| 2013-05-07 09:00:00 | ES | Futures | 1664.25 | 1666.06 | 1663.99 | 1665.28 | 17480.0 |
| 2013-05-07 09:30:00 | ES | Futures | 1665.54 | 1668.37 | 1664.25 | 1668.12 | 209252.0 |
| 2013-05-07 10:00:00 | ES | Futures | 1668.12 | 1668.63 | 1660.65 | 1663.74 | 246521.0 |
| 2013-05-07 10:30:00 | ES | Futures | 1663.74 | 1666.06 | 1662.96 | 1664.51 | 105787.0 |
| 2013-05-07 11:00:00 | ES | Futures | 1664.77 | 1667.09 | 1664.51 | 1666.06 | 91616.0 |
| 2013-05-07 11:30:00 | ES | Futures | 1665.8 | 1666.57 | 1664.25 | 1665.28 | 58209.0 |
| 2013-05-07 12:00:00 | ES | Futures | 1665.28 | 1667.09 | 1665.28 | 1666.83 | 45863.0 |
| 2013-05-07 12:30:00 | ES | Futures | 1666.83 | 1669.15 | 1666.31 | 1668.63 | 71138.0 |
| 2013-05-07 13:00:00 | ES | Futures | 1668.63 | 1669.4 | 1668.12 | 1669.15 | 66802.0 |
| 2013-05-07 13:30:00 | ES | Futures | 1669.15 | 1670.69 | 1668.63 | 1669.92 | 70150.0 |
| 2013-05-07 14:00:00 | ES | Futures | 1669.92 | 1670.69 | 1669.4 | 1669.66 | 54201.0 |
| 2013-05-07 14:30:00 | ES | Futures | 1669.66 | 1670.95 | 1668.63 | 1670.69 | 63293.0 |
| 2013-05-07 15:00:00 | ES | Futures | 1670.69 | 1670.95 | 1669.92 | 1670.43 | 51187.0 |
| 2013-05-07 15:30:00 | ES | Futures | 1670.43 | 1670.95 | 1669.4 | 1670.43 | 99207.0 |
| 2013-05-07 16:00:00 | ES | Futures | 1670.43 | 1670.95 | 1669.4 | 1670.43 | 58432.0 |
| 2013-05-07 16:30:00 | ES | Futures | 1670.18 | 1670.43 | 1669.15 | 1670.18 | 6783.0 |
| 2013-05-07 17:00:00 | ES | Futures | 1670.43 | 1670.69 | 1669.92 | 1670.43 | 2390.0 |
| 2013-05-07 18:00:00 | ES | Futures | 1669.92 | 1669.92 | 1667.6 | 1667.6 | 7324.0 |
| 2013-05-07 18:30:00 | ES | Futures | 1667.86 | 1668.12 | 1667.09 | 1667.86 | 3332.0 |
| 2013-05-07 19:00:00 | ES | Futures | 1667.6 | 1668.12 | 1667.34 | 1667.6 | 1127.0 |
| 2013-05-07 19:30:00 | ES | Futures | 1667.6 | 1668.12 | 1667.6 | 1668.12 | 564.0 |
| 2013-05-07 20:00:00 | ES | Futures | 1667.86 | 1668.12 | 1667.6 | 1668.12 | 1105.0 |
| 2013-05-07 20:30:00 | ES | Futures | 1668.12 | 1668.37 | 1667.86 | 1668.37 | 760.0 |
| 2013-05-07 21:00:00 | ES | Futures | 1668.12 | 1669.4 | 1668.12 | 1669.4 | 2415.0 |
| 2013-05-07 21:30:00 | ES | Futures | 1669.15 | 1670.18 | 1668.63 | 1669.66 | 2746.0 |
| 2013-05-07 22:00:00 | ES | Futures | 1669.66 | 1670.18 | 1668.63 | 1669.4 | 2101.0 |
| 2013-05-07 22:30:00 | ES | Futures | 1669.4 | 1669.92 | 1669.15 | 1669.4 | 993.0 |
| 2013-05-07 23:00:00 | ES | Futures | 1669.4 | 1669.66 | 1669.15 | 1669.4 | 853.0 |
| 2013-05-07 23:30:00 | ES | Futures | 1669.4 | 1669.66 | 1669.15 | 1669.4 | 774.0 |
| 2013-05-07 00:00:00 | NQ | Futures | 3437.89 | 3437.89 | 3436.43 | 3437.31 | 96.0 |
| 2013-05-07 00:30:00 | NQ | Futures | 3437.31 | 3438.47 | 3436.72 | 3437.6 | 152.0 |
| 2013-05-07 01:00:00 | NQ | Futures | 3437.6 | 3439.06 | 3437.31 | 3438.77 | 114.0 |
> showing 50 of 2,863 rows — these rows as CSV