PREVIEW / futures_30min / 2019-08-18
file: by_date/futures_30min/2019/2019-08-18.parquet size: 24 KB rows: 679
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 |
|---|---|---|---|---|---|---|---|
| 2019-08-18 18:00:00 | ES | Futures | 3132.6 | 3148.57 | 3132.06 | 3143.7 | 14454.0 |
| 2019-08-18 18:30:00 | ES | Futures | 3143.7 | 3145.86 | 3143.16 | 3144.24 | 3060.0 |
| 2019-08-18 19:00:00 | ES | Futures | 3143.97 | 3145.32 | 3142.34 | 3143.97 | 2610.0 |
| 2019-08-18 19:30:00 | ES | Futures | 3143.97 | 3147.76 | 3142.89 | 3146.68 | 5713.0 |
| 2019-08-18 20:00:00 | ES | Futures | 3146.41 | 3148.03 | 3141.8 | 3142.89 | 10139.0 |
| 2019-08-18 20:30:00 | ES | Futures | 3143.16 | 3144.78 | 3140.72 | 3143.97 | 5519.0 |
| 2019-08-18 21:00:00 | ES | Futures | 3143.97 | 3146.68 | 3143.43 | 3146.41 | 5211.0 |
| 2019-08-18 21:30:00 | ES | Futures | 3146.41 | 3147.76 | 3143.97 | 3145.32 | 4439.0 |
| 2019-08-18 22:00:00 | ES | Futures | 3145.59 | 3146.13 | 3144.24 | 3144.51 | 4443.0 |
| 2019-08-18 22:30:00 | ES | Futures | 3144.51 | 3147.76 | 3144.24 | 3147.49 | 3371.0 |
| 2019-08-18 23:00:00 | ES | Futures | 3147.49 | 3147.76 | 3146.13 | 3146.95 | 1982.0 |
| 2019-08-18 23:30:00 | ES | Futures | 3147.22 | 3147.49 | 3146.13 | 3146.41 | 1592.0 |
| 2019-08-18 18:00:00 | NQ | Futures | 8840.35 | 8885.9 | 8838.9 | 8872.27 | 5781.0 |
| 2019-08-18 18:30:00 | NQ | Futures | 8871.98 | 8876.04 | 8865.88 | 8870.81 | 1695.0 |
| 2019-08-18 19:00:00 | NQ | Futures | 8869.94 | 8875.17 | 8867.04 | 8872.56 | 1058.0 |
| 2019-08-18 19:30:00 | NQ | Futures | 8872.27 | 8883.0 | 8869.36 | 8880.39 | 1900.0 |
| 2019-08-18 20:00:00 | NQ | Futures | 8880.1 | 8884.45 | 8868.2 | 8871.4 | 4670.0 |
| 2019-08-18 20:30:00 | NQ | Futures | 8871.98 | 8877.2 | 8862.4 | 8872.56 | 2564.0 |
| 2019-08-18 21:00:00 | NQ | Futures | 8872.27 | 8881.55 | 8869.94 | 8878.65 | 3849.0 |
| 2019-08-18 21:30:00 | NQ | Futures | 8879.23 | 8886.48 | 8876.62 | 8882.42 | 3221.0 |
| 2019-08-18 22:00:00 | NQ | Futures | 8882.71 | 8884.16 | 8877.2 | 8879.23 | 2401.0 |
| 2019-08-18 22:30:00 | NQ | Futures | 8879.23 | 8888.51 | 8876.91 | 8886.77 | 1792.0 |
| 2019-08-18 23:00:00 | NQ | Futures | 8887.35 | 8888.51 | 8884.16 | 8887.35 | 1160.0 |
| 2019-08-18 23:30:00 | NQ | Futures | 8887.93 | 8888.8 | 8884.16 | 8885.03 | 1004.0 |
| 2019-08-18 18:00:00 | YM | Futures | 28179.3 | 28335.9 | 28179.3 | 28310.9 | 2742.0 |
| 2019-08-18 18:30:00 | YM | Futures | 28315.2 | 28333.7 | 28307.6 | 28315.2 | 740.0 |
| 2019-08-18 19:00:00 | YM | Futures | 28314.2 | 28323.9 | 28298.9 | 28310.9 | 469.0 |
| 2019-08-18 19:30:00 | YM | Futures | 28313.1 | 28342.4 | 28294.6 | 28327.2 | 1051.0 |
| 2019-08-18 20:00:00 | YM | Futures | 28326.1 | 28338.1 | 28280.4 | 28289.1 | 1449.0 |
| 2019-08-18 20:30:00 | YM | Futures | 28292.4 | 28312.0 | 28277.2 | 28298.9 | 1123.0 |
| 2019-08-18 21:00:00 | YM | Futures | 28297.8 | 28325.0 | 28297.8 | 28319.6 | 921.0 |
| 2019-08-18 21:30:00 | YM | Futures | 28321.8 | 28332.6 | 28298.9 | 28309.8 | 793.0 |
| 2019-08-18 22:00:00 | YM | Futures | 28309.8 | 28316.3 | 28296.8 | 28302.2 | 691.0 |
| 2019-08-18 22:30:00 | YM | Futures | 28301.1 | 28338.1 | 28297.8 | 28329.4 | 896.0 |
| 2019-08-18 23:00:00 | YM | Futures | 28330.5 | 28331.6 | 28314.2 | 28322.9 | 356.0 |
| 2019-08-18 23:30:00 | YM | Futures | 28322.9 | 28326.1 | 28313.1 | 28318.5 | 414.0 |
| 2019-08-18 18:00:00 | CL | Futures | 48.78 | 48.93 | 48.64 | 48.76 | 3837.0 |
| 2019-08-18 18:30:00 | CL | Futures | 48.76 | 48.85 | 48.74 | 48.83 | 1484.0 |
| 2019-08-18 19:00:00 | CL | Futures | 48.84 | 48.97 | 48.82 | 48.93 | 1519.0 |
| 2019-08-18 19:30:00 | CL | Futures | 48.92 | 49.04 | 48.9 | 48.99 | 1772.0 |
| 2019-08-18 20:00:00 | CL | Futures | 48.99 | 49.05 | 48.94 | 49.02 | 2799.0 |
| 2019-08-18 20:30:00 | CL | Futures | 49.02 | 49.08 | 48.95 | 48.97 | 1807.0 |
| 2019-08-18 21:00:00 | CL | Futures | 48.97 | 49.12 | 48.97 | 49.11 | 3470.0 |
| 2019-08-18 21:30:00 | CL | Futures | 49.11 | 49.17 | 49.07 | 49.08 | 2854.0 |
| 2019-08-18 22:00:00 | CL | Futures | 49.09 | 49.16 | 49.04 | 49.13 | 2696.0 |
| 2019-08-18 22:30:00 | CL | Futures | 49.12 | 49.18 | 49.09 | 49.15 | 1811.0 |
| 2019-08-18 23:00:00 | CL | Futures | 49.14 | 49.15 | 49.09 | 49.13 | 1467.0 |
| 2019-08-18 23:30:00 | CL | Futures | 49.12 | 49.16 | 49.06 | 49.07 | 1395.0 |
| 2019-08-18 18:00:00 | GC | Futures | 1929.4 | 1930.2 | 1923.5 | 1927.3 | 4913.0 |
| 2019-08-18 18:30:00 | GC | Futures | 1927.3 | 1927.4 | 1924.4 | 1925.5 | 1610.0 |
> showing 50 of 679 rows — these rows as CSV