PREVIEW / futures_30min / 2013-06-12
file: by_date/futures_30min/2013/2013-06-12.parquet size: 76 KB rows: 2,695
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-06-12 00:00:00 | ES | Futures | 1678.93 | 1679.19 | 1678.42 | 1679.19 | 1164.0 |
| 2013-06-12 00:30:00 | ES | Futures | 1679.19 | 1679.97 | 1679.19 | 1679.71 | 1985.0 |
| 2013-06-12 01:00:00 | ES | Futures | 1679.71 | 1680.74 | 1679.45 | 1680.22 | 3433.0 |
| 2013-06-12 01:30:00 | ES | Futures | 1680.48 | 1681.25 | 1679.97 | 1680.48 | 3657.0 |
| 2013-06-12 02:00:00 | ES | Futures | 1680.22 | 1681.25 | 1679.45 | 1679.45 | 3403.0 |
| 2013-06-12 02:30:00 | ES | Futures | 1679.45 | 1680.74 | 1678.16 | 1680.22 | 4285.0 |
| 2013-06-12 03:00:00 | ES | Futures | 1680.22 | 1683.06 | 1680.22 | 1682.54 | 13501.0 |
| 2013-06-12 03:30:00 | ES | Futures | 1682.54 | 1685.37 | 1682.54 | 1683.57 | 18227.0 |
| 2013-06-12 04:00:00 | ES | Futures | 1683.57 | 1684.34 | 1679.97 | 1681.77 | 14927.0 |
| 2013-06-12 04:30:00 | ES | Futures | 1681.77 | 1683.31 | 1681.0 | 1683.06 | 8493.0 |
| 2013-06-12 05:00:00 | ES | Futures | 1682.8 | 1685.12 | 1682.54 | 1684.09 | 13773.0 |
| 2013-06-12 05:30:00 | ES | Futures | 1684.09 | 1684.6 | 1682.8 | 1683.06 | 10744.0 |
| 2013-06-12 06:00:00 | ES | Futures | 1683.06 | 1685.89 | 1683.06 | 1685.89 | 10444.0 |
| 2013-06-12 06:30:00 | ES | Futures | 1685.89 | 1686.66 | 1684.6 | 1686.15 | 14255.0 |
| 2013-06-12 07:00:00 | ES | Futures | 1686.15 | 1686.4 | 1683.83 | 1685.12 | 13678.0 |
| 2013-06-12 07:30:00 | ES | Futures | 1684.86 | 1686.4 | 1684.6 | 1685.63 | 10790.0 |
| 2013-06-12 08:00:00 | ES | Futures | 1685.63 | 1686.15 | 1683.57 | 1684.6 | 18569.0 |
| 2013-06-12 08:30:00 | ES | Futures | 1684.34 | 1685.89 | 1683.06 | 1685.37 | 31349.0 |
| 2013-06-12 09:00:00 | ES | Futures | 1685.12 | 1687.69 | 1685.12 | 1686.15 | 34858.0 |
| 2013-06-12 09:30:00 | ES | Futures | 1686.15 | 1687.95 | 1681.0 | 1682.03 | 263477.0 |
| 2013-06-12 10:00:00 | ES | Futures | 1682.28 | 1682.28 | 1675.59 | 1679.71 | 266646.0 |
| 2013-06-12 10:30:00 | ES | Futures | 1679.71 | 1681.0 | 1673.01 | 1674.04 | 176297.0 |
| 2013-06-12 11:00:00 | ES | Futures | 1674.04 | 1676.1 | 1671.72 | 1674.3 | 135531.0 |
| 2013-06-12 11:30:00 | ES | Futures | 1674.3 | 1676.1 | 1665.28 | 1667.09 | 187520.0 |
| 2013-06-12 12:00:00 | ES | Futures | 1667.09 | 1668.63 | 1663.48 | 1666.06 | 109550.0 |
| 2013-06-12 12:30:00 | ES | Futures | 1666.31 | 1668.63 | 1662.96 | 1668.37 | 99592.0 |
| 2013-06-12 13:00:00 | ES | Futures | 1668.12 | 1671.46 | 1666.83 | 1668.89 | 97149.0 |
| 2013-06-12 13:30:00 | ES | Futures | 1669.15 | 1670.43 | 1665.54 | 1669.4 | 66107.0 |
| 2013-06-12 14:00:00 | ES | Futures | 1669.4 | 1669.4 | 1662.19 | 1663.99 | 97095.0 |
| 2013-06-12 14:30:00 | ES | Futures | 1663.99 | 1664.77 | 1660.9 | 1663.22 | 101427.0 |
| 2013-06-12 15:00:00 | ES | Futures | 1663.22 | 1663.48 | 1658.84 | 1662.45 | 133988.0 |
| 2013-06-12 15:30:00 | ES | Futures | 1662.45 | 1664.25 | 1659.87 | 1660.65 | 180382.0 |
| 2013-06-12 16:00:00 | ES | Futures | 1660.9 | 1661.42 | 1658.33 | 1658.84 | 93573.0 |
| 2013-06-12 16:30:00 | ES | Futures | 1659.62 | 1660.65 | 1659.36 | 1659.87 | 8343.0 |
| 2013-06-12 17:00:00 | ES | Futures | 1659.87 | 1659.87 | 1658.59 | 1658.59 | 1932.0 |
| 2013-06-12 18:00:00 | ES | Futures | 1659.62 | 1660.9 | 1659.36 | 1659.87 | 2956.0 |
| 2013-06-12 18:30:00 | ES | Futures | 1659.62 | 1659.87 | 1658.84 | 1658.84 | 3729.0 |
| 2013-06-12 19:00:00 | ES | Futures | 1658.84 | 1659.36 | 1658.59 | 1659.1 | 2045.0 |
| 2013-06-12 19:30:00 | ES | Futures | 1658.84 | 1660.39 | 1658.84 | 1659.36 | 1802.0 |
| 2013-06-12 20:00:00 | ES | Futures | 1659.62 | 1660.13 | 1657.81 | 1658.07 | 2970.0 |
| 2013-06-12 20:30:00 | ES | Futures | 1658.33 | 1659.36 | 1658.07 | 1658.59 | 2753.0 |
| 2013-06-12 21:00:00 | ES | Futures | 1658.59 | 1659.1 | 1654.72 | 1654.98 | 12955.0 |
| 2013-06-12 21:30:00 | ES | Futures | 1654.72 | 1656.27 | 1650.6 | 1651.12 | 17647.0 |
| 2013-06-12 22:00:00 | ES | Futures | 1650.86 | 1652.4 | 1649.83 | 1651.12 | 11452.0 |
| 2013-06-12 22:30:00 | ES | Futures | 1651.12 | 1653.18 | 1651.12 | 1652.66 | 6023.0 |
| 2013-06-12 23:00:00 | ES | Futures | 1652.66 | 1652.92 | 1651.12 | 1651.63 | 2742.0 |
| 2013-06-12 23:30:00 | ES | Futures | 1651.63 | 1653.43 | 1651.12 | 1653.18 | 4675.0 |
| 2013-06-12 00:00:00 | NQ | Futures | 3463.56 | 3464.72 | 3462.68 | 3464.14 | 199.0 |
| 2013-06-12 00:30:00 | NQ | Futures | 3464.43 | 3466.18 | 3464.43 | 3466.18 | 203.0 |
| 2013-06-12 01:00:00 | NQ | Futures | 3466.47 | 3467.06 | 3465.02 | 3466.47 | 512.0 |
> showing 50 of 2,695 rows — these rows as CSV