PREVIEW / futures_1hour / 2021-12-30
file: by_date/futures_1hour/2021/2021-12-30.parquet size: 63 KB rows: 1,943
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-30 00:00:00 | ES | Futures | 5410.57 | 5411.42 | 5406.33 | 5406.33 | 2416.0 |
| 2021-12-30 01:00:00 | ES | Futures | 5406.04 | 5411.42 | 5405.48 | 5410.57 | 2551.0 |
| 2021-12-30 02:00:00 | ES | Futures | 5410.85 | 5415.09 | 5407.74 | 5410.57 | 5137.0 |
| 2021-12-30 03:00:00 | ES | Futures | 5410.57 | 5417.07 | 5410.0 | 5416.51 | 6482.0 |
| 2021-12-30 04:00:00 | ES | Futures | 5416.79 | 5421.32 | 5414.53 | 5418.77 | 7118.0 |
| 2021-12-30 05:00:00 | ES | Futures | 5419.05 | 5419.62 | 5414.25 | 5417.64 | 5551.0 |
| 2021-12-30 06:00:00 | ES | Futures | 5417.36 | 5423.86 | 5415.94 | 5422.45 | 6001.0 |
| 2021-12-30 07:00:00 | ES | Futures | 5422.45 | 5423.86 | 5419.34 | 5419.34 | 7537.0 |
| 2021-12-30 08:00:00 | ES | Futures | 5419.62 | 5421.88 | 5415.66 | 5419.05 | 12363.0 |
| 2021-12-30 09:00:00 | ES | Futures | 5419.05 | 5428.67 | 5414.25 | 5420.47 | 110111.0 |
| 2021-12-30 10:00:00 | ES | Futures | 5420.47 | 5429.52 | 5417.64 | 5420.19 | 98405.0 |
| 2021-12-30 11:00:00 | ES | Futures | 5420.19 | 5423.3 | 5418.49 | 5421.32 | 56987.0 |
| 2021-12-30 12:00:00 | ES | Futures | 5421.03 | 5423.3 | 5415.94 | 5422.16 | 43318.0 |
| 2021-12-30 13:00:00 | ES | Futures | 5422.16 | 5422.45 | 5417.36 | 5421.03 | 35577.0 |
| 2021-12-30 14:00:00 | ES | Futures | 5421.03 | 5421.88 | 5415.38 | 5419.9 | 46902.0 |
| 2021-12-30 15:00:00 | ES | Futures | 5419.9 | 5419.9 | 5392.75 | 5398.41 | 201338.0 |
| 2021-12-30 16:00:00 | ES | Futures | 5398.41 | 5401.8 | 5395.3 | 5398.69 | 37190.0 |
| 2021-12-30 18:00:00 | ES | Futures | 5400.11 | 5402.65 | 5397.28 | 5399.54 | 4252.0 |
| 2021-12-30 19:00:00 | ES | Futures | 5399.54 | 5400.11 | 5373.81 | 5378.9 | 17275.0 |
| 2021-12-30 20:00:00 | ES | Futures | 5378.9 | 5395.58 | 5378.9 | 5395.3 | 13662.0 |
| 2021-12-30 21:00:00 | ES | Futures | 5395.58 | 5395.86 | 5385.97 | 5388.51 | 6677.0 |
| 2021-12-30 22:00:00 | ES | Futures | 5388.79 | 5389.08 | 5382.01 | 5385.12 | 5705.0 |
| 2021-12-30 23:00:00 | ES | Futures | 5385.4 | 5388.51 | 5385.12 | 5388.23 | 2014.0 |
| 2021-12-30 00:00:00 | NQ | Futures | 19111.7 | 19114.6 | 19094.31 | 19095.47 | 2202.0 |
| 2021-12-30 01:00:00 | NQ | Futures | 19094.6 | 19111.7 | 19091.71 | 19109.38 | 2151.0 |
| 2021-12-30 02:00:00 | NQ | Futures | 19109.67 | 19135.47 | 19096.34 | 19125.9 | 3361.0 |
| 2021-12-30 03:00:00 | NQ | Futures | 19126.77 | 19149.38 | 19119.82 | 19148.22 | 4018.0 |
| 2021-12-30 04:00:00 | NQ | Futures | 19147.93 | 19173.43 | 19139.24 | 19166.19 | 3568.0 |
| 2021-12-30 05:00:00 | NQ | Futures | 19167.06 | 19169.38 | 19144.45 | 19154.89 | 2582.0 |
| 2021-12-30 06:00:00 | NQ | Futures | 19155.17 | 19171.4 | 19140.39 | 19166.19 | 3481.0 |
| 2021-12-30 07:00:00 | NQ | Futures | 19165.61 | 19177.2 | 19153.15 | 19154.6 | 4050.0 |
| 2021-12-30 08:00:00 | NQ | Futures | 19154.89 | 19163.58 | 19128.22 | 19138.66 | 8071.0 |
| 2021-12-30 09:00:00 | NQ | Futures | 19138.95 | 19148.8 | 19069.1 | 19127.64 | 53603.0 |
| 2021-12-30 10:00:00 | NQ | Futures | 19127.93 | 19206.18 | 19125.61 | 19161.26 | 53098.0 |
| 2021-12-30 11:00:00 | NQ | Futures | 19160.39 | 19187.63 | 19150.83 | 19179.23 | 28495.0 |
| 2021-12-30 12:00:00 | NQ | Futures | 19179.23 | 19196.62 | 19163.0 | 19180.97 | 18973.0 |
| 2021-12-30 13:00:00 | NQ | Futures | 19181.26 | 19185.32 | 19162.71 | 19167.93 | 14216.0 |
| 2021-12-30 14:00:00 | NQ | Futures | 19167.93 | 19168.8 | 19133.15 | 19155.46 | 19939.0 |
| 2021-12-30 15:00:00 | NQ | Futures | 19156.04 | 19156.04 | 19025.05 | 19045.04 | 52110.0 |
| 2021-12-30 16:00:00 | NQ | Futures | 19045.33 | 19062.72 | 19040.41 | 19048.81 | 8889.0 |
| 2021-12-30 18:00:00 | NQ | Futures | 19047.94 | 19065.04 | 19047.07 | 19055.77 | 2509.0 |
| 2021-12-30 19:00:00 | NQ | Futures | 19055.77 | 19057.8 | 18954.91 | 18985.34 | 8140.0 |
| 2021-12-30 20:00:00 | NQ | Futures | 18985.05 | 19039.25 | 18985.05 | 19036.06 | 7143.0 |
| 2021-12-30 21:00:00 | NQ | Futures | 19035.48 | 19038.09 | 19001.28 | 19015.19 | 4208.0 |
| 2021-12-30 22:00:00 | NQ | Futures | 19014.9 | 19017.8 | 18987.08 | 19006.21 | 3509.0 |
| 2021-12-30 23:00:00 | NQ | Futures | 19006.21 | 19024.18 | 19005.05 | 19022.15 | 1821.0 |
| 2021-12-30 00:00:00 | YM | Futures | 40868.1 | 40874.9 | 40843.4 | 40843.4 | 560.0 |
| 2021-12-30 01:00:00 | YM | Futures | 40842.3 | 40880.5 | 40837.8 | 40876.0 | 1014.0 |
| 2021-12-30 02:00:00 | YM | Futures | 40878.2 | 40905.2 | 40849.0 | 40864.7 | 2088.0 |
| 2021-12-30 03:00:00 | YM | Futures | 40864.7 | 40909.7 | 40859.1 | 40903.0 | 2266.0 |
> showing 50 of 1,943 rows — these rows as CSV