PREVIEW / futures_1hour / 2024-11-06
file: by_date/futures_1hour/2024/2024-11-06.parquet size: 73 KB rows: 2,189
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 |
|---|---|---|---|---|---|---|---|
| 2024-11-06 00:00:00 | ES | Futures | 6111.26 | 6111.78 | 6089.72 | 6108.14 | 30190.0 |
| 2024-11-06 01:00:00 | ES | Futures | 6107.88 | 6134.35 | 6102.17 | 6126.31 | 35198.0 |
| 2024-11-06 02:00:00 | ES | Futures | 6126.31 | 6155.64 | 6126.31 | 6144.74 | 57137.0 |
| 2024-11-06 03:00:00 | ES | Futures | 6144.48 | 6180.81 | 6140.06 | 6171.73 | 59403.0 |
| 2024-11-06 04:00:00 | ES | Futures | 6171.73 | 6175.1 | 6158.49 | 6175.1 | 34569.0 |
| 2024-11-06 05:00:00 | ES | Futures | 6175.1 | 6176.4 | 6166.02 | 6169.39 | 23954.0 |
| 2024-11-06 06:00:00 | ES | Futures | 6169.13 | 6173.8 | 6145.0 | 6150.7 | 36820.0 |
| 2024-11-06 07:00:00 | ES | Futures | 6150.96 | 6178.47 | 6147.33 | 6170.43 | 42732.0 |
| 2024-11-06 08:00:00 | ES | Futures | 6170.43 | 6176.14 | 6157.71 | 6159.53 | 47029.0 |
| 2024-11-06 09:00:00 | ES | Futures | 6159.27 | 6167.57 | 6125.53 | 6133.58 | 281823.0 |
| 2024-11-06 10:00:00 | ES | Futures | 6133.32 | 6164.98 | 6133.32 | 6142.66 | 285602.0 |
| 2024-11-06 11:00:00 | ES | Futures | 6142.92 | 6162.9 | 6135.65 | 6162.38 | 153159.0 |
| 2024-11-06 12:00:00 | ES | Futures | 6162.12 | 6169.39 | 6157.19 | 6167.05 | 90435.0 |
| 2024-11-06 13:00:00 | ES | Futures | 6166.8 | 6181.85 | 6165.76 | 6177.18 | 103932.0 |
| 2024-11-06 14:00:00 | ES | Futures | 6177.18 | 6183.66 | 6171.99 | 6179.77 | 93560.0 |
| 2024-11-06 15:00:00 | ES | Futures | 6179.77 | 6194.3 | 6178.73 | 6184.44 | 248977.0 |
| 2024-11-06 16:00:00 | ES | Futures | 6184.44 | 6193.79 | 6182.63 | 6193.53 | 65030.0 |
| 2024-11-06 18:00:00 | ES | Futures | 6190.67 | 6191.45 | 6182.63 | 6183.66 | 8470.0 |
| 2024-11-06 19:00:00 | ES | Futures | 6183.92 | 6188.85 | 6177.7 | 6179.25 | 8726.0 |
| 2024-11-06 20:00:00 | ES | Futures | 6179.51 | 6190.41 | 6178.47 | 6187.56 | 8894.0 |
| 2024-11-06 21:00:00 | ES | Futures | 6187.56 | 6189.37 | 6184.18 | 6185.74 | 6458.0 |
| 2024-11-06 22:00:00 | ES | Futures | 6185.74 | 6194.82 | 6185.22 | 6191.19 | 7736.0 |
| 2024-11-06 23:00:00 | ES | Futures | 6191.45 | 6196.12 | 6189.37 | 6194.05 | 5077.0 |
| 2024-11-06 00:00:00 | NQ | Futures | 21495.26 | 21500.74 | 21350.72 | 21482.22 | 13294.0 |
| 2024-11-06 01:00:00 | NQ | Futures | 21484.04 | 21571.45 | 21471.78 | 21547.44 | 10279.0 |
| 2024-11-06 02:00:00 | NQ | Futures | 21549.27 | 21615.28 | 21548.23 | 21583.45 | 13522.0 |
| 2024-11-06 03:00:00 | NQ | Futures | 21582.41 | 21636.15 | 21552.92 | 21602.76 | 13279.0 |
| 2024-11-06 04:00:00 | NQ | Futures | 21601.45 | 21633.81 | 21565.19 | 21632.5 | 10645.0 |
| 2024-11-06 05:00:00 | NQ | Futures | 21632.5 | 21633.55 | 21580.84 | 21587.89 | 7007.0 |
| 2024-11-06 06:00:00 | NQ | Futures | 21587.1 | 21594.93 | 21478.3 | 21505.18 | 12885.0 |
| 2024-11-06 07:00:00 | NQ | Futures | 21508.05 | 21613.19 | 21498.39 | 21588.67 | 13588.0 |
| 2024-11-06 08:00:00 | NQ | Futures | 21591.28 | 21622.85 | 21562.06 | 21589.97 | 15741.0 |
| 2024-11-06 09:00:00 | NQ | Futures | 21589.71 | 21713.38 | 21545.1 | 21577.97 | 89912.0 |
| 2024-11-06 10:00:00 | NQ | Futures | 21577.97 | 21730.87 | 21567.53 | 21628.85 | 96676.0 |
| 2024-11-06 11:00:00 | NQ | Futures | 21628.85 | 21717.3 | 21595.19 | 21706.08 | 55022.0 |
| 2024-11-06 12:00:00 | NQ | Futures | 21706.08 | 21735.04 | 21685.21 | 21726.43 | 34567.0 |
| 2024-11-06 13:00:00 | NQ | Futures | 21725.91 | 21788.27 | 21718.6 | 21771.57 | 38050.0 |
| 2024-11-06 14:00:00 | NQ | Futures | 21772.09 | 21807.57 | 21758.52 | 21801.83 | 34296.0 |
| 2024-11-06 15:00:00 | NQ | Futures | 21802.09 | 21844.62 | 21789.31 | 21806.01 | 64832.0 |
| 2024-11-06 16:00:00 | NQ | Futures | 21805.49 | 21849.06 | 21797.14 | 21835.75 | 20164.0 |
| 2024-11-06 18:00:00 | NQ | Futures | 21836.8 | 21836.8 | 21800.79 | 21802.62 | 3528.0 |
| 2024-11-06 19:00:00 | NQ | Futures | 21803.4 | 21822.45 | 21772.09 | 21785.14 | 4849.0 |
| 2024-11-06 20:00:00 | NQ | Futures | 21785.14 | 21833.93 | 21777.31 | 21824.79 | 5262.0 |
| 2024-11-06 21:00:00 | NQ | Futures | 21824.01 | 21829.75 | 21807.57 | 21821.92 | 3225.0 |
| 2024-11-06 22:00:00 | NQ | Futures | 21822.45 | 21846.71 | 21816.44 | 21830.01 | 3706.0 |
| 2024-11-06 23:00:00 | NQ | Futures | 21830.27 | 21844.36 | 21820.36 | 21834.97 | 2387.0 |
| 2024-11-06 00:00:00 | YM | Futures | 44683.7 | 44717.0 | 44592.1 | 44706.6 | 3231.0 |
| 2024-11-06 01:00:00 | YM | Futures | 44708.6 | 44888.7 | 44658.7 | 44835.6 | 3420.0 |
| 2024-11-06 02:00:00 | YM | Futures | 44837.7 | 45118.7 | 44832.5 | 44993.8 | 6187.0 |
| 2024-11-06 03:00:00 | YM | Futures | 44994.8 | 45324.8 | 44974.0 | 45281.1 | 7949.0 |
> showing 50 of 2,189 rows — these rows as CSV