PREVIEW / futures_1hour / 2021-11-21
file: by_date/futures_1hour/2021/2021-11-21.parquet size: 18 KB rows: 397
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-11-21 18:00:00 | ES | Futures | 5306.72 | 5310.67 | 5302.21 | 5302.49 | 8699.0 |
| 2021-11-21 19:00:00 | ES | Futures | 5302.49 | 5309.26 | 5300.23 | 5308.13 | 7564.0 |
| 2021-11-21 20:00:00 | ES | Futures | 5308.13 | 5313.78 | 5308.13 | 5311.8 | 7568.0 |
| 2021-11-21 21:00:00 | ES | Futures | 5311.8 | 5313.78 | 5311.8 | 5313.5 | 3657.0 |
| 2021-11-21 22:00:00 | ES | Futures | 5313.78 | 5315.19 | 5312.65 | 5313.78 | 3512.0 |
| 2021-11-21 23:00:00 | ES | Futures | 5313.78 | 5316.88 | 5312.93 | 5312.93 | 5612.0 |
| 2021-11-21 18:00:00 | NQ | Futures | 19244.15 | 19266.17 | 19229.66 | 19230.82 | 4545.0 |
| 2021-11-21 19:00:00 | NQ | Futures | 19230.82 | 19262.41 | 19223.86 | 19259.8 | 4403.0 |
| 2021-11-21 20:00:00 | NQ | Futures | 19259.51 | 19281.25 | 19258.35 | 19270.23 | 5038.0 |
| 2021-11-21 21:00:00 | NQ | Futures | 19271.1 | 19276.32 | 19263.57 | 19274.87 | 2144.0 |
| 2021-11-21 22:00:00 | NQ | Futures | 19274.0 | 19277.19 | 19267.33 | 19272.55 | 1464.0 |
| 2021-11-21 23:00:00 | NQ | Futures | 19272.84 | 19278.64 | 19256.32 | 19257.48 | 2618.0 |
| 2021-11-21 18:00:00 | YM | Futures | 39895.3 | 39925.6 | 39869.6 | 39880.8 | 1794.0 |
| 2021-11-21 19:00:00 | YM | Futures | 39880.8 | 39916.6 | 39861.7 | 39912.2 | 2129.0 |
| 2021-11-21 20:00:00 | YM | Futures | 39911.0 | 39960.3 | 39909.9 | 39939.1 | 2031.0 |
| 2021-11-21 21:00:00 | YM | Futures | 39937.9 | 39966.0 | 39937.9 | 39954.7 | 765.0 |
| 2021-11-21 22:00:00 | YM | Futures | 39955.9 | 39972.7 | 39946.9 | 39963.7 | 702.0 |
| 2021-11-21 23:00:00 | YM | Futures | 39964.8 | 39995.1 | 39964.8 | 39969.3 | 1026.0 |
| 2021-11-21 18:00:00 | CL | Futures | 53.67 | 53.72 | 52.97 | 53.53 | 9369.0 |
| 2021-11-21 19:00:00 | CL | Futures | 53.52 | 53.59 | 53.37 | 53.57 | 3580.0 |
| 2021-11-21 20:00:00 | CL | Futures | 53.57 | 53.81 | 53.43 | 53.47 | 8094.0 |
| 2021-11-21 21:00:00 | CL | Futures | 53.47 | 53.63 | 53.38 | 53.55 | 4429.0 |
| 2021-11-21 22:00:00 | CL | Futures | 53.55 | 53.82 | 53.48 | 53.8 | 3922.0 |
| 2021-11-21 23:00:00 | CL | Futures | 53.8 | 53.9 | 53.72 | 53.77 | 3113.0 |
| 2021-11-21 18:00:00 | GC | Futures | 2225.0 | 2225.2 | 2214.9 | 2222.2 | 5358.0 |
| 2021-11-21 19:00:00 | GC | Futures | 2222.3 | 2225.0 | 2221.7 | 2223.8 | 2464.0 |
| 2021-11-21 20:00:00 | GC | Futures | 2223.9 | 2226.6 | 2221.4 | 2223.6 | 4190.0 |
| 2021-11-21 21:00:00 | GC | Futures | 2223.8 | 2225.1 | 2222.1 | 2224.4 | 2370.0 |
| 2021-11-21 22:00:00 | GC | Futures | 2224.1 | 2225.2 | 2222.6 | 2225.1 | 1422.0 |
| 2021-11-21 23:00:00 | GC | Futures | 2225.0 | 2227.5 | 2224.7 | 2225.4 | 2006.0 |
| 2021-11-21 18:00:00 | ZN | Futures | 133.579672 | 133.579672 | 133.451967 | 133.483893 | 32548.0 |
| 2021-11-21 19:00:00 | ZN | Futures | 133.483893 | 133.51582 | 133.436004 | 133.46793 | 13032.0 |
| 2021-11-21 20:00:00 | ZN | Futures | 133.46793 | 133.499857 | 133.436004 | 133.436004 | 12759.0 |
| 2021-11-21 21:00:00 | ZN | Futures | 133.451967 | 133.499857 | 133.404078 | 133.46793 | 12429.0 |
| 2021-11-21 22:00:00 | ZN | Futures | 133.483893 | 133.499857 | 133.451967 | 133.499857 | 5450.0 |
| 2021-11-21 23:00:00 | ZN | Futures | 133.483893 | 133.531783 | 133.46793 | 133.499857 | 12583.0 |
> showing 36 of 397 rows — these rows as CSV