PREVIEW / futures_1hour / 2010-02-05
file: by_date/futures_1hour/2010/2010-02-05.parquet size: 41 KB rows: 1,165
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 |
|---|---|---|---|---|---|---|---|
| 2010-02-05 00:00:00 | ES | Futures | 1035.55 | 1035.55 | 1034.82 | 1035.31 | 2268.0 |
| 2010-02-05 01:00:00 | ES | Futures | 1035.55 | 1036.28 | 1035.07 | 1036.04 | 3760.0 |
| 2010-02-05 02:00:00 | ES | Futures | 1036.04 | 1036.28 | 1033.36 | 1033.61 | 13450.0 |
| 2010-02-05 03:00:00 | ES | Futures | 1033.61 | 1034.09 | 1028.5 | 1032.39 | 71923.0 |
| 2010-02-05 04:00:00 | ES | Futures | 1032.39 | 1033.61 | 1026.31 | 1026.31 | 52792.0 |
| 2010-02-05 05:00:00 | ES | Futures | 1026.07 | 1027.04 | 1022.66 | 1023.15 | 65653.0 |
| 2010-02-05 06:00:00 | ES | Futures | 1023.15 | 1028.98 | 1022.17 | 1028.5 | 60639.0 |
| 2010-02-05 07:00:00 | ES | Futures | 1028.25 | 1029.47 | 1025.58 | 1026.31 | 52328.0 |
| 2010-02-05 08:00:00 | ES | Futures | 1026.31 | 1035.07 | 1023.15 | 1034.82 | 275631.0 |
| 2010-02-05 09:00:00 | ES | Futures | 1034.58 | 1035.31 | 1026.07 | 1026.8 | 480135.0 |
| 2010-02-05 10:00:00 | ES | Futures | 1026.8 | 1034.34 | 1023.88 | 1030.69 | 507871.0 |
| 2010-02-05 11:00:00 | ES | Futures | 1030.93 | 1031.42 | 1022.42 | 1025.34 | 361828.0 |
| 2010-02-05 12:00:00 | ES | Futures | 1025.09 | 1028.25 | 1023.15 | 1025.82 | 223809.0 |
| 2010-02-05 13:00:00 | ES | Futures | 1025.82 | 1025.82 | 1012.69 | 1013.42 | 436850.0 |
| 2010-02-05 14:00:00 | ES | Futures | 1013.42 | 1020.71 | 1013.42 | 1019.74 | 380732.0 |
| 2010-02-05 15:00:00 | ES | Futures | 1019.5 | 1035.31 | 1019.5 | 1033.85 | 780385.0 |
| 2010-02-05 16:00:00 | ES | Futures | 1034.09 | 1034.09 | 1030.69 | 1030.93 | 142312.0 |
| 2010-02-05 00:00:00 | NQ | Futures | 1985.12 | 1987.12 | 1984.27 | 1987.12 | 256.0 |
| 2010-02-05 01:00:00 | NQ | Futures | 1987.12 | 1988.84 | 1986.55 | 1987.69 | 270.0 |
| 2010-02-05 02:00:00 | NQ | Futures | 1987.98 | 1988.26 | 1984.27 | 1984.27 | 831.0 |
| 2010-02-05 03:00:00 | NQ | Futures | 1984.27 | 1985.69 | 1976.55 | 1984.84 | 7430.0 |
| 2010-02-05 04:00:00 | NQ | Futures | 1984.84 | 1987.12 | 1976.55 | 1976.55 | 4020.0 |
| 2010-02-05 05:00:00 | NQ | Futures | 1976.55 | 1979.7 | 1974.27 | 1974.84 | 5726.0 |
| 2010-02-05 06:00:00 | NQ | Futures | 1974.84 | 1982.55 | 1973.41 | 1982.27 | 3701.0 |
| 2010-02-05 07:00:00 | NQ | Futures | 1982.27 | 1984.27 | 1978.27 | 1979.12 | 4982.0 |
| 2010-02-05 08:00:00 | NQ | Futures | 1978.84 | 1992.55 | 1971.41 | 1991.41 | 24267.0 |
| 2010-02-05 09:00:00 | NQ | Futures | 1991.69 | 1991.69 | 1969.13 | 1971.98 | 86106.0 |
| 2010-02-05 10:00:00 | NQ | Futures | 1971.98 | 1991.98 | 1966.56 | 1983.98 | 90631.0 |
| 2010-02-05 11:00:00 | NQ | Futures | 1983.98 | 1985.12 | 1970.27 | 1977.12 | 53006.0 |
| 2010-02-05 12:00:00 | NQ | Futures | 1977.12 | 1981.69 | 1973.98 | 1978.84 | 29912.0 |
| 2010-02-05 13:00:00 | NQ | Futures | 1978.84 | 1979.12 | 1954.56 | 1956.56 | 56622.0 |
| 2010-02-05 14:00:00 | NQ | Futures | 1956.56 | 1970.27 | 1956.56 | 1968.56 | 54128.0 |
| 2010-02-05 15:00:00 | NQ | Futures | 1968.56 | 1996.26 | 1968.27 | 1991.98 | 116437.0 |
| 2010-02-05 16:00:00 | NQ | Futures | 1991.98 | 1996.83 | 1991.41 | 1993.12 | 15655.0 |
| 2010-02-05 00:00:00 | YM | Futures | 9355.3 | 9359.1 | 9351.6 | 9357.2 | 331.0 |
| 2010-02-05 01:00:00 | YM | Futures | 9357.2 | 9361.9 | 9353.4 | 9358.1 | 256.0 |
| 2010-02-05 02:00:00 | YM | Futures | 9360.0 | 9361.9 | 9343.1 | 9346.9 | 1336.0 |
| 2010-02-05 03:00:00 | YM | Futures | 9346.0 | 9348.8 | 9302.0 | 9334.7 | 7010.0 |
| 2010-02-05 04:00:00 | YM | Futures | 9334.7 | 9343.1 | 9287.0 | 9290.7 | 3746.0 |
| 2010-02-05 05:00:00 | YM | Futures | 9289.8 | 9296.4 | 9259.9 | 9265.5 | 5083.0 |
| 2010-02-05 06:00:00 | YM | Futures | 9263.6 | 9302.9 | 9255.2 | 9302.0 | 2398.0 |
| 2010-02-05 07:00:00 | YM | Futures | 9301.0 | 9309.5 | 9279.5 | 9284.2 | 2119.0 |
| 2010-02-05 08:00:00 | YM | Futures | 9283.3 | 9357.2 | 9266.4 | 9354.4 | 10587.0 |
| 2010-02-05 09:00:00 | YM | Futures | 9354.4 | 9355.3 | 9271.1 | 9276.7 | 36650.0 |
| 2010-02-05 10:00:00 | YM | Futures | 9277.6 | 9334.7 | 9250.5 | 9305.7 | 31860.0 |
| 2010-02-05 11:00:00 | YM | Futures | 9306.6 | 9310.4 | 9240.2 | 9262.7 | 25576.0 |
| 2010-02-05 12:00:00 | YM | Futures | 9263.6 | 9292.6 | 9252.4 | 9273.9 | 15724.0 |
| 2010-02-05 13:00:00 | YM | Futures | 9274.8 | 9275.8 | 9162.5 | 9169.1 | 23993.0 |
| 2010-02-05 14:00:00 | YM | Futures | 9169.1 | 9226.2 | 9169.1 | 9214.0 | 25016.0 |
| 2010-02-05 15:00:00 | YM | Futures | 9214.9 | 9337.5 | 9214.0 | 9330.0 | 43361.0 |
> showing 50 of 1,165 rows — these rows as CSV