PREVIEW / futures_1hour / 2023-12-13
file: by_date/futures_1hour/2023/2023-12-13.parquet size: 68 KB rows: 2,060
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 |
|---|---|---|---|---|---|---|---|
| 2023-12-13 00:00:00 | ES | Futures | 5053.43 | 5054.24 | 5051.8 | 5052.89 | 1276.0 |
| 2023-12-13 01:00:00 | ES | Futures | 5052.61 | 5053.16 | 5050.99 | 5051.53 | 1244.0 |
| 2023-12-13 02:00:00 | ES | Futures | 5051.26 | 5054.24 | 5050.99 | 5051.26 | 3700.0 |
| 2023-12-13 03:00:00 | ES | Futures | 5051.26 | 5054.52 | 5051.26 | 5054.52 | 3582.0 |
| 2023-12-13 04:00:00 | ES | Futures | 5054.52 | 5055.06 | 5051.53 | 5052.61 | 2199.0 |
| 2023-12-13 05:00:00 | ES | Futures | 5052.61 | 5053.16 | 5050.99 | 5051.53 | 2638.0 |
| 2023-12-13 06:00:00 | ES | Futures | 5051.26 | 5054.52 | 5049.63 | 5052.89 | 2657.0 |
| 2023-12-13 07:00:00 | ES | Futures | 5052.89 | 5053.43 | 5050.44 | 5050.99 | 2223.0 |
| 2023-12-13 08:00:00 | ES | Futures | 5050.99 | 5059.13 | 5050.71 | 5057.77 | 9211.0 |
| 2023-12-13 09:00:00 | ES | Futures | 5058.05 | 5058.59 | 5047.73 | 5049.63 | 36165.0 |
| 2023-12-13 10:00:00 | ES | Futures | 5049.63 | 5059.13 | 5046.91 | 5056.96 | 29047.0 |
| 2023-12-13 11:00:00 | ES | Futures | 5056.96 | 5059.13 | 5051.26 | 5051.26 | 16158.0 |
| 2023-12-13 12:00:00 | ES | Futures | 5051.26 | 5052.07 | 5048.0 | 5049.63 | 12736.0 |
| 2023-12-13 13:00:00 | ES | Futures | 5049.63 | 5051.8 | 5045.55 | 5048.27 | 14331.0 |
| 2023-12-13 14:00:00 | ES | Futures | 5049.63 | 5110.73 | 5049.63 | 5107.2 | 74488.0 |
| 2023-12-13 15:00:00 | ES | Futures | 5107.47 | 5118.06 | 5089.55 | 5114.53 | 82151.0 |
| 2023-12-13 16:00:00 | ES | Futures | 5114.53 | 5117.52 | 5112.36 | 5112.36 | 19084.0 |
| 2023-12-13 18:00:00 | ES | Futures | 5113.99 | 5124.31 | 5113.72 | 5123.76 | 3901.0 |
| 2023-12-13 19:00:00 | ES | Futures | 5123.49 | 5131.91 | 5123.49 | 5131.37 | 6895.0 |
| 2023-12-13 20:00:00 | ES | Futures | 5131.37 | 5134.9 | 5130.01 | 5133.27 | 3155.0 |
| 2023-12-13 21:00:00 | ES | Futures | 5133.27 | 5136.8 | 5133.0 | 5134.08 | 3120.0 |
| 2023-12-13 22:00:00 | ES | Futures | 5134.08 | 5134.63 | 5129.47 | 5131.37 | 1857.0 |
| 2023-12-13 23:00:00 | ES | Futures | 5131.64 | 5136.53 | 5131.37 | 5136.53 | 1027.0 |
| 2023-12-13 00:00:00 | NQ | Futures | 18012.75 | 18017.42 | 18005.89 | 18010.28 | 432.0 |
| 2023-12-13 01:00:00 | NQ | Futures | 18010.28 | 18013.85 | 17999.29 | 18002.59 | 427.0 |
| 2023-12-13 02:00:00 | NQ | Futures | 18000.39 | 18022.37 | 17997.65 | 18013.3 | 979.0 |
| 2023-12-13 03:00:00 | NQ | Futures | 18013.3 | 18024.56 | 18000.12 | 18014.4 | 1295.0 |
| 2023-12-13 04:00:00 | NQ | Futures | 18014.4 | 18015.5 | 18003.14 | 18005.06 | 719.0 |
| 2023-12-13 05:00:00 | NQ | Futures | 18006.44 | 18010.83 | 17998.47 | 18004.24 | 704.0 |
| 2023-12-13 06:00:00 | NQ | Futures | 18004.24 | 18020.99 | 18001.77 | 18018.52 | 1015.0 |
| 2023-12-13 07:00:00 | NQ | Futures | 18017.42 | 18021.82 | 18009.18 | 18012.75 | 1285.0 |
| 2023-12-13 08:00:00 | NQ | Futures | 18012.75 | 18050.66 | 18011.1 | 18039.67 | 2975.0 |
| 2023-12-13 09:00:00 | NQ | Futures | 18038.85 | 18069.06 | 18003.41 | 18017.7 | 17391.0 |
| 2023-12-13 10:00:00 | NQ | Futures | 18017.7 | 18058.35 | 18009.73 | 18038.57 | 10020.0 |
| 2023-12-13 11:00:00 | NQ | Futures | 18038.02 | 18049.56 | 18002.59 | 18007.53 | 7038.0 |
| 2023-12-13 12:00:00 | NQ | Futures | 18008.36 | 18021.54 | 17993.25 | 17998.47 | 4782.0 |
| 2023-12-13 13:00:00 | NQ | Futures | 17998.47 | 18012.48 | 17980.07 | 17998.47 | 4066.0 |
| 2023-12-13 14:00:00 | NQ | Futures | 17994.9 | 18214.08 | 17994.9 | 18192.38 | 24080.0 |
| 2023-12-13 15:00:00 | NQ | Futures | 18193.76 | 18230.01 | 18095.43 | 18201.17 | 21133.0 |
| 2023-12-13 16:00:00 | NQ | Futures | 18200.07 | 18207.49 | 18173.16 | 18183.04 | 3274.0 |
| 2023-12-13 18:00:00 | NQ | Futures | 18195.4 | 18245.12 | 18195.4 | 18243.74 | 1656.0 |
| 2023-12-13 19:00:00 | NQ | Futures | 18243.47 | 18291.54 | 18243.2 | 18291.54 | 2139.0 |
| 2023-12-13 20:00:00 | NQ | Futures | 18290.71 | 18315.43 | 18286.87 | 18311.86 | 1280.0 |
| 2023-12-13 21:00:00 | NQ | Futures | 18311.86 | 18319.55 | 18296.21 | 18301.97 | 930.0 |
| 2023-12-13 22:00:00 | NQ | Futures | 18301.97 | 18308.57 | 18281.1 | 18291.81 | 743.0 |
| 2023-12-13 23:00:00 | NQ | Futures | 18290.99 | 18307.74 | 18290.44 | 18307.19 | 494.0 |
| 2023-12-13 00:00:00 | YM | Futures | 39753.8 | 39761.3 | 39750.5 | 39753.8 | 613.0 |
| 2023-12-13 01:00:00 | YM | Futures | 39753.8 | 39755.9 | 39738.7 | 39741.9 | 516.0 |
| 2023-12-13 02:00:00 | YM | Futures | 39743.0 | 39759.1 | 39733.4 | 39738.7 | 1211.0 |
| 2023-12-13 03:00:00 | YM | Futures | 39738.7 | 39777.4 | 39734.4 | 39777.4 | 2029.0 |
> showing 50 of 2,060 rows — these rows as CSV