PREVIEW / futures_1hour / 2008-10-14
file: by_date/futures_1hour/2008/2008-10-14.parquet size: 46 KB rows: 1,272
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 |
|---|---|---|---|---|---|---|---|
| 2008-10-14 00:00:00 | ES | Futures | 984.7 | 985.65 | 981.15 | 982.1 | 7313.0 |
| 2008-10-14 01:00:00 | ES | Futures | 982.33 | 989.2 | 980.68 | 989.2 | 9039.0 |
| 2008-10-14 02:00:00 | ES | Futures | 989.2 | 989.2 | 971.21 | 972.63 | 43811.0 |
| 2008-10-14 03:00:00 | ES | Futures | 972.63 | 978.55 | 967.19 | 978.07 | 49482.0 |
| 2008-10-14 04:00:00 | ES | Futures | 978.31 | 983.99 | 970.03 | 971.68 | 44157.0 |
| 2008-10-14 05:00:00 | ES | Futures | 971.68 | 978.07 | 970.03 | 977.6 | 26825.0 |
| 2008-10-14 06:00:00 | ES | Futures | 977.36 | 992.27 | 976.65 | 988.96 | 41307.0 |
| 2008-10-14 07:00:00 | ES | Futures | 989.2 | 993.93 | 987.54 | 989.2 | 46567.0 |
| 2008-10-14 08:00:00 | ES | Futures | 989.43 | 1010.02 | 987.3 | 997.95 | 190635.0 |
| 2008-10-14 09:00:00 | ES | Futures | 997.95 | 1001.03 | 963.64 | 963.64 | 622749.0 |
| 2008-10-14 10:00:00 | ES | Futures | 963.64 | 978.55 | 941.87 | 956.06 | 728251.0 |
| 2008-10-14 11:00:00 | ES | Futures | 956.06 | 966.0 | 942.58 | 958.9 | 411411.0 |
| 2008-10-14 12:00:00 | ES | Futures | 959.14 | 968.37 | 950.62 | 959.85 | 243324.0 |
| 2008-10-14 13:00:00 | ES | Futures | 959.85 | 962.45 | 947.07 | 949.67 | 232753.0 |
| 2008-10-14 14:00:00 | ES | Futures | 949.67 | 952.28 | 922.22 | 926.48 | 542492.0 |
| 2008-10-14 15:00:00 | ES | Futures | 926.72 | 957.48 | 923.88 | 948.73 | 576629.0 |
| 2008-10-14 16:00:00 | ES | Futures | 948.73 | 954.17 | 945.65 | 953.46 | 95372.0 |
| 2008-10-14 17:00:00 | ES | Futures | 953.46 | 953.7 | 948.02 | 948.49 | 3592.0 |
| 2008-10-14 18:00:00 | ES | Futures | 949.44 | 952.28 | 947.78 | 949.2 | 3840.0 |
| 2008-10-14 19:00:00 | ES | Futures | 949.2 | 949.44 | 927.67 | 936.66 | 13899.0 |
| 2008-10-14 20:00:00 | ES | Futures | 936.66 | 940.68 | 933.35 | 937.37 | 7591.0 |
| 2008-10-14 21:00:00 | ES | Futures | 937.61 | 940.45 | 932.64 | 938.79 | 5329.0 |
| 2008-10-14 22:00:00 | ES | Futures | 938.79 | 938.79 | 930.74 | 932.87 | 3318.0 |
| 2008-10-14 23:00:00 | ES | Futures | 932.87 | 945.89 | 932.4 | 941.87 | 6361.0 |
| 2008-10-14 00:00:00 | NQ | Futures | 1682.22 | 1687.59 | 1680.8 | 1683.35 | 617.0 |
| 2008-10-14 01:00:00 | NQ | Futures | 1683.92 | 1694.95 | 1681.93 | 1693.25 | 723.0 |
| 2008-10-14 02:00:00 | NQ | Futures | 1693.82 | 1694.38 | 1666.09 | 1669.48 | 1828.0 |
| 2008-10-14 03:00:00 | NQ | Futures | 1668.92 | 1670.9 | 1657.32 | 1670.9 | 2422.0 |
| 2008-10-14 04:00:00 | NQ | Futures | 1670.62 | 1677.97 | 1664.96 | 1666.65 | 3697.0 |
| 2008-10-14 05:00:00 | NQ | Futures | 1666.09 | 1674.86 | 1664.96 | 1669.77 | 1948.0 |
| 2008-10-14 06:00:00 | NQ | Futures | 1670.05 | 1694.67 | 1670.05 | 1692.97 | 2223.0 |
| 2008-10-14 07:00:00 | NQ | Futures | 1692.97 | 1693.25 | 1679.95 | 1684.76 | 2644.0 |
| 2008-10-14 08:00:00 | NQ | Futures | 1684.76 | 1696.65 | 1677.41 | 1681.93 | 16667.0 |
| 2008-10-14 09:00:00 | NQ | Futures | 1681.93 | 1682.5 | 1592.52 | 1593.37 | 100423.0 |
| 2008-10-14 10:00:00 | NQ | Futures | 1593.08 | 1617.42 | 1567.62 | 1591.39 | 122308.0 |
| 2008-10-14 11:00:00 | NQ | Futures | 1591.1 | 1608.08 | 1563.37 | 1594.78 | 66417.0 |
| 2008-10-14 12:00:00 | NQ | Futures | 1594.78 | 1613.17 | 1580.92 | 1594.22 | 44501.0 |
| 2008-10-14 13:00:00 | NQ | Futures | 1594.5 | 1600.44 | 1569.88 | 1576.11 | 41499.0 |
| 2008-10-14 14:00:00 | NQ | Futures | 1576.11 | 1579.78 | 1531.68 | 1541.87 | 94137.0 |
| 2008-10-14 15:00:00 | NQ | Futures | 1541.58 | 1581.2 | 1536.21 | 1550.36 | 102129.0 |
| 2008-10-14 16:00:00 | NQ | Futures | 1550.36 | 1573.28 | 1537.62 | 1572.14 | 19256.0 |
| 2008-10-14 17:00:00 | NQ | Futures | 1572.71 | 1574.69 | 1558.56 | 1561.39 | 1602.0 |
| 2008-10-14 18:00:00 | NQ | Futures | 1563.09 | 1567.9 | 1559.98 | 1565.35 | 1005.0 |
| 2008-10-14 19:00:00 | NQ | Futures | 1564.79 | 1565.35 | 1537.06 | 1542.43 | 1240.0 |
| 2008-10-14 20:00:00 | NQ | Futures | 1541.3 | 1548.66 | 1538.19 | 1541.58 | 716.0 |
| 2008-10-14 21:00:00 | NQ | Futures | 1542.43 | 1548.09 | 1538.75 | 1542.43 | 722.0 |
| 2008-10-14 22:00:00 | NQ | Futures | 1543.57 | 1544.98 | 1538.75 | 1539.32 | 843.0 |
| 2008-10-14 23:00:00 | NQ | Futures | 1540.17 | 1556.3 | 1540.17 | 1550.92 | 433.0 |
| 2008-10-14 00:00:00 | YM | Futures | 8810.5 | 8813.2 | 8778.7 | 8790.5 | 496.0 |
| 2008-10-14 01:00:00 | YM | Futures | 8792.3 | 8849.6 | 8778.7 | 8847.8 | 640.0 |
> showing 50 of 1,272 rows — these rows as CSV