PREVIEW / futures_1hour / 2021-12-16
file: by_date/futures_1hour/2021/2021-12-16.parquet size: 66 KB rows: 2,025
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 |
|---|---|---|---|---|---|---|---|
| 2021-12-16 00:00:00 | ES | Futures | 5328.56 | 5334.21 | 5264.93 | 5333.65 | 6025.0 |
| 2021-12-16 01:00:00 | ES | Futures | 5333.65 | 5339.3 | 5332.52 | 5338.17 | 7980.0 |
| 2021-12-16 02:00:00 | ES | Futures | 5337.89 | 5353.16 | 5335.91 | 5344.68 | 19708.0 |
| 2021-12-16 03:00:00 | ES | Futures | 5344.39 | 5350.62 | 5335.91 | 5348.07 | 25802.0 |
| 2021-12-16 04:00:00 | ES | Futures | 5348.07 | 5348.07 | 5341.0 | 5345.81 | 19647.0 |
| 2021-12-16 05:00:00 | ES | Futures | 5345.81 | 5354.86 | 5343.26 | 5354.29 | 15760.0 |
| 2021-12-16 06:00:00 | ES | Futures | 5354.29 | 5365.6 | 5352.6 | 5360.51 | 30210.0 |
| 2021-12-16 07:00:00 | ES | Futures | 5360.51 | 5360.51 | 5351.18 | 5352.88 | 33050.0 |
| 2021-12-16 08:00:00 | ES | Futures | 5353.16 | 5354.01 | 5339.3 | 5344.96 | 47178.0 |
| 2021-12-16 09:00:00 | ES | Futures | 5344.96 | 5345.24 | 5319.51 | 5320.07 | 276330.0 |
| 2021-12-16 10:00:00 | ES | Futures | 5320.36 | 5336.76 | 5308.2 | 5328.56 | 261079.0 |
| 2021-12-16 11:00:00 | ES | Futures | 5328.84 | 5329.69 | 5303.39 | 5304.24 | 192758.0 |
| 2021-12-16 12:00:00 | ES | Futures | 5303.95 | 5309.33 | 5283.87 | 5284.16 | 171209.0 |
| 2021-12-16 13:00:00 | ES | Futures | 5284.16 | 5301.69 | 5284.16 | 5290.38 | 123812.0 |
| 2021-12-16 14:00:00 | ES | Futures | 5290.66 | 5294.9 | 5251.07 | 5263.8 | 229750.0 |
| 2021-12-16 15:00:00 | ES | Futures | 5263.8 | 5291.51 | 5253.33 | 5269.17 | 386081.0 |
| 2021-12-16 16:00:00 | ES | Futures | 5268.89 | 5279.92 | 5266.34 | 5277.37 | 75953.0 |
| 2021-12-16 18:00:00 | ES | Futures | 5275.96 | 5277.37 | 5263.23 | 5269.17 | 14814.0 |
| 2021-12-16 19:00:00 | ES | Futures | 5269.45 | 5277.94 | 5269.45 | 5275.67 | 10747.0 |
| 2021-12-16 20:00:00 | ES | Futures | 5275.39 | 5280.48 | 5273.41 | 5277.94 | 12268.0 |
| 2021-12-16 21:00:00 | ES | Futures | 5277.94 | 5279.63 | 5273.69 | 5275.39 | 3537.0 |
| 2021-12-16 22:00:00 | ES | Futures | 5275.39 | 5275.39 | 5251.92 | 5254.75 | 12956.0 |
| 2021-12-16 23:00:00 | ES | Futures | 5254.75 | 5266.34 | 5252.48 | 5264.93 | 8068.0 |
| 2021-12-16 00:00:00 | NQ | Futures | 18928.83 | 18960.71 | 18922.16 | 18958.97 | 3781.0 |
| 2021-12-16 01:00:00 | NQ | Futures | 18957.81 | 18987.37 | 18954.62 | 18986.5 | 4442.0 |
| 2021-12-16 02:00:00 | NQ | Futures | 18985.92 | 19048.52 | 18979.26 | 19014.03 | 10283.0 |
| 2021-12-16 03:00:00 | NQ | Futures | 19013.16 | 19026.79 | 18970.27 | 19016.35 | 13189.0 |
| 2021-12-16 04:00:00 | NQ | Futures | 19017.51 | 19018.38 | 18973.46 | 18993.75 | 7314.0 |
| 2021-12-16 05:00:00 | NQ | Futures | 18992.88 | 19029.1 | 18984.47 | 19026.79 | 5338.0 |
| 2021-12-16 06:00:00 | NQ | Futures | 19027.37 | 19078.08 | 19018.67 | 19052.0 | 10517.0 |
| 2021-12-16 07:00:00 | NQ | Futures | 19051.71 | 19052.29 | 18992.88 | 18998.38 | 13109.0 |
| 2021-12-16 08:00:00 | NQ | Futures | 18999.25 | 19003.31 | 18923.32 | 18946.8 | 23483.0 |
| 2021-12-16 09:00:00 | NQ | Futures | 18947.67 | 18947.96 | 18741.61 | 18745.08 | 111639.0 |
| 2021-12-16 10:00:00 | NQ | Futures | 18745.08 | 18772.91 | 18653.5 | 18689.73 | 109002.0 |
| 2021-12-16 11:00:00 | NQ | Futures | 18690.6 | 18699.58 | 18515.26 | 18524.53 | 86856.0 |
| 2021-12-16 12:00:00 | NQ | Futures | 18523.95 | 18546.27 | 18433.24 | 18434.98 | 67548.0 |
| 2021-12-16 13:00:00 | NQ | Futures | 18434.69 | 18523.95 | 18434.69 | 18462.51 | 51949.0 |
| 2021-12-16 14:00:00 | NQ | Futures | 18462.8 | 18482.22 | 18308.33 | 18355.28 | 81149.0 |
| 2021-12-16 15:00:00 | NQ | Futures | 18355.28 | 18478.74 | 18324.85 | 18388.61 | 111403.0 |
| 2021-12-16 16:00:00 | NQ | Futures | 18388.32 | 18416.43 | 18352.38 | 18409.77 | 19960.0 |
| 2021-12-16 18:00:00 | NQ | Futures | 18406.87 | 18406.87 | 18329.49 | 18361.66 | 9005.0 |
| 2021-12-16 19:00:00 | NQ | Futures | 18361.08 | 18402.52 | 18360.79 | 18392.38 | 5481.0 |
| 2021-12-16 20:00:00 | NQ | Futures | 18391.8 | 18429.47 | 18388.32 | 18419.62 | 7079.0 |
| 2021-12-16 21:00:00 | NQ | Futures | 18419.04 | 18423.1 | 18392.09 | 18398.46 | 2783.0 |
| 2021-12-16 22:00:00 | NQ | Futures | 18399.91 | 18400.78 | 18276.16 | 18289.78 | 10112.0 |
| 2021-12-16 23:00:00 | NQ | Futures | 18290.65 | 18359.05 | 18281.38 | 18354.12 | 7822.0 |
| 2021-12-16 00:00:00 | YM | Futures | 40308.5 | 40345.6 | 40292.7 | 40338.8 | 1193.0 |
| 2021-12-16 01:00:00 | YM | Futures | 40337.7 | 40380.4 | 40330.9 | 40366.9 | 1405.0 |
| 2021-12-16 02:00:00 | YM | Futures | 40368.0 | 40456.8 | 40355.7 | 40408.5 | 4345.0 |
| 2021-12-16 03:00:00 | YM | Futures | 40407.4 | 40456.8 | 40353.4 | 40437.7 | 4880.0 |
> showing 50 of 2,025 rows — these rows as CSV