PREVIEW / futures_30min / 2021-04-18
file: by_date/futures_30min/2021/2021-04-18.parquet size: 26 KB rows: 722
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-04-18 18:00:00 | ES | Futures | 4680.95 | 4683.76 | 4678.7 | 4682.63 | 6385.0 |
| 2021-04-18 18:30:00 | ES | Futures | 4682.63 | 4684.88 | 4682.63 | 4684.32 | 1975.0 |
| 2021-04-18 19:00:00 | ES | Futures | 4684.6 | 4685.16 | 4683.48 | 4683.48 | 2271.0 |
| 2021-04-18 19:30:00 | ES | Futures | 4683.48 | 4684.04 | 4680.11 | 4680.39 | 2830.0 |
| 2021-04-18 20:00:00 | ES | Futures | 4680.39 | 4681.23 | 4676.17 | 4679.83 | 7474.0 |
| 2021-04-18 20:30:00 | ES | Futures | 4679.83 | 4682.92 | 4678.42 | 4682.07 | 4500.0 |
| 2021-04-18 21:00:00 | ES | Futures | 4682.07 | 4683.48 | 4679.26 | 4680.39 | 4125.0 |
| 2021-04-18 21:30:00 | ES | Futures | 4680.67 | 4684.88 | 4678.42 | 4683.76 | 6969.0 |
| 2021-04-18 22:00:00 | ES | Futures | 4683.48 | 4686.85 | 4682.92 | 4686.57 | 4539.0 |
| 2021-04-18 22:30:00 | ES | Futures | 4686.29 | 4686.85 | 4684.6 | 4685.73 | 2968.0 |
| 2021-04-18 23:00:00 | ES | Futures | 4685.73 | 4688.54 | 4685.44 | 4687.41 | 3872.0 |
| 2021-04-18 23:30:00 | ES | Futures | 4687.41 | 4688.25 | 4685.73 | 4686.57 | 2565.0 |
| 2021-04-18 18:00:00 | NQ | Futures | 16199.0 | 16208.55 | 16180.76 | 16205.08 | 3837.0 |
| 2021-04-18 18:30:00 | NQ | Futures | 16205.37 | 16209.42 | 16202.76 | 16202.76 | 934.0 |
| 2021-04-18 19:00:00 | NQ | Futures | 16203.34 | 16218.68 | 16201.31 | 16213.18 | 1607.0 |
| 2021-04-18 19:30:00 | NQ | Futures | 16213.47 | 16216.66 | 16197.55 | 16202.18 | 1481.0 |
| 2021-04-18 20:00:00 | NQ | Futures | 16201.02 | 16206.24 | 16185.1 | 16204.21 | 3244.0 |
| 2021-04-18 20:30:00 | NQ | Futures | 16204.5 | 16221.29 | 16200.74 | 16217.24 | 2474.0 |
| 2021-04-18 21:00:00 | NQ | Futures | 16217.24 | 16225.34 | 16206.52 | 16210.0 | 2372.0 |
| 2021-04-18 21:30:00 | NQ | Futures | 16210.29 | 16235.76 | 16197.84 | 16227.66 | 3740.0 |
| 2021-04-18 22:00:00 | NQ | Futures | 16227.08 | 16250.53 | 16224.47 | 16247.34 | 3157.0 |
| 2021-04-18 22:30:00 | NQ | Futures | 16246.76 | 16254.29 | 16244.16 | 16251.4 | 1751.0 |
| 2021-04-18 23:00:00 | NQ | Futures | 16251.69 | 16272.24 | 16247.05 | 16265.58 | 2939.0 |
| 2021-04-18 23:30:00 | NQ | Futures | 16265.58 | 16270.21 | 16259.5 | 16261.82 | 1501.0 |
| 2021-04-18 18:00:00 | YM | Futures | 37886.5 | 37914.4 | 37867.6 | 37898.8 | 1166.0 |
| 2021-04-18 18:30:00 | YM | Futures | 37898.8 | 37908.8 | 37888.8 | 37904.4 | 384.0 |
| 2021-04-18 19:00:00 | YM | Futures | 37904.4 | 37904.4 | 37873.2 | 37873.2 | 556.0 |
| 2021-04-18 19:30:00 | YM | Futures | 37875.4 | 37885.4 | 37853.1 | 37855.3 | 754.0 |
| 2021-04-18 20:00:00 | YM | Futures | 37854.2 | 37859.8 | 37826.4 | 37846.4 | 1449.0 |
| 2021-04-18 20:30:00 | YM | Futures | 37846.4 | 37872.1 | 37835.3 | 37858.7 | 746.0 |
| 2021-04-18 21:00:00 | YM | Futures | 37859.8 | 37867.6 | 37833.1 | 37845.3 | 661.0 |
| 2021-04-18 21:30:00 | YM | Futures | 37846.4 | 37869.8 | 37832.0 | 37859.8 | 916.0 |
| 2021-04-18 22:00:00 | YM | Futures | 37858.7 | 37877.6 | 37855.3 | 37870.9 | 802.0 |
| 2021-04-18 22:30:00 | YM | Futures | 37869.8 | 37873.2 | 37844.2 | 37854.2 | 729.0 |
| 2021-04-18 23:00:00 | YM | Futures | 37854.2 | 37872.1 | 37848.7 | 37858.7 | 682.0 |
| 2021-04-18 23:30:00 | YM | Futures | 37858.7 | 37867.6 | 37848.7 | 37854.2 | 550.0 |
| 2021-04-18 18:00:00 | CL | Futures | 42.71 | 42.83 | 42.59 | 42.65 | 3345.0 |
| 2021-04-18 18:30:00 | CL | Futures | 42.66 | 42.67 | 42.6 | 42.62 | 456.0 |
| 2021-04-18 19:00:00 | CL | Futures | 42.62 | 42.66 | 42.6 | 42.65 | 621.0 |
| 2021-04-18 19:30:00 | CL | Futures | 42.65 | 42.69 | 42.62 | 42.62 | 707.0 |
| 2021-04-18 20:00:00 | CL | Futures | 42.61 | 42.67 | 42.58 | 42.66 | 1688.0 |
| 2021-04-18 20:30:00 | CL | Futures | 42.65 | 42.66 | 42.59 | 42.62 | 1189.0 |
| 2021-04-18 21:00:00 | CL | Futures | 42.62 | 42.66 | 42.48 | 42.52 | 3278.0 |
| 2021-04-18 21:30:00 | CL | Futures | 42.52 | 42.68 | 42.51 | 42.66 | 2779.0 |
| 2021-04-18 22:00:00 | CL | Futures | 42.66 | 42.72 | 42.63 | 42.64 | 1889.0 |
| 2021-04-18 22:30:00 | CL | Futures | 42.64 | 42.77 | 42.62 | 42.71 | 1732.0 |
| 2021-04-18 23:00:00 | CL | Futures | 42.71 | 42.75 | 42.66 | 42.68 | 1160.0 |
| 2021-04-18 23:30:00 | CL | Futures | 42.67 | 42.71 | 42.65 | 42.68 | 537.0 |
| 2021-04-18 18:00:00 | GC | Futures | 2148.9 | 2149.0 | 2146.0 | 2146.1 | 1156.0 |
| 2021-04-18 18:30:00 | GC | Futures | 2146.2 | 2146.9 | 2145.4 | 2145.6 | 453.0 |
> showing 50 of 722 rows — these rows as CSV