PREVIEW / futures_30min / 2021-07-02
file: by_date/futures_30min/2021/2021-07-02.parquet size: 87 KB rows: 2,941
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-07-02 00:00:00 | ES | Futures | 4857.29 | 4858.7 | 4857.01 | 4858.14 | 1321.0 |
| 2021-07-02 00:30:00 | ES | Futures | 4858.14 | 4858.42 | 4857.29 | 4857.86 | 994.0 |
| 2021-07-02 01:00:00 | ES | Futures | 4857.86 | 4858.14 | 4855.6 | 4857.01 | 2085.0 |
| 2021-07-02 01:30:00 | ES | Futures | 4857.29 | 4857.29 | 4854.76 | 4855.32 | 2361.0 |
| 2021-07-02 02:00:00 | ES | Futures | 4855.6 | 4855.89 | 4853.35 | 4854.2 | 4991.0 |
| 2021-07-02 02:30:00 | ES | Futures | 4854.48 | 4856.17 | 4853.91 | 4855.6 | 3372.0 |
| 2021-07-02 03:00:00 | ES | Futures | 4855.89 | 4863.49 | 4853.91 | 4863.21 | 16087.0 |
| 2021-07-02 03:30:00 | ES | Futures | 4863.49 | 4863.77 | 4858.98 | 4861.24 | 11364.0 |
| 2021-07-02 04:00:00 | ES | Futures | 4860.95 | 4862.36 | 4854.48 | 4856.17 | 8624.0 |
| 2021-07-02 04:30:00 | ES | Futures | 4856.45 | 4857.29 | 4853.91 | 4855.32 | 6034.0 |
| 2021-07-02 05:00:00 | ES | Futures | 4855.32 | 4857.86 | 4854.48 | 4855.89 | 4059.0 |
| 2021-07-02 05:30:00 | ES | Futures | 4855.6 | 4858.98 | 4855.04 | 4856.73 | 5442.0 |
| 2021-07-02 06:00:00 | ES | Futures | 4856.73 | 4859.83 | 4856.45 | 4857.29 | 5294.0 |
| 2021-07-02 06:30:00 | ES | Futures | 4857.01 | 4858.42 | 4855.32 | 4857.57 | 4127.0 |
| 2021-07-02 07:00:00 | ES | Futures | 4857.57 | 4860.39 | 4857.57 | 4860.11 | 7663.0 |
| 2021-07-02 07:30:00 | ES | Futures | 4859.83 | 4861.24 | 4859.55 | 4860.11 | 7535.0 |
| 2021-07-02 08:00:00 | ES | Futures | 4860.39 | 4862.36 | 4858.42 | 4859.83 | 11650.0 |
| 2021-07-02 08:30:00 | ES | Futures | 4859.55 | 4871.09 | 4857.01 | 4867.99 | 50449.0 |
| 2021-07-02 09:00:00 | ES | Futures | 4867.99 | 4872.22 | 4867.15 | 4868.27 | 25986.0 |
| 2021-07-02 09:30:00 | ES | Futures | 4868.27 | 4871.37 | 4864.61 | 4869.96 | 100130.0 |
| 2021-07-02 10:00:00 | ES | Futures | 4870.25 | 4871.94 | 4867.71 | 4870.81 | 54503.0 |
| 2021-07-02 10:30:00 | ES | Futures | 4870.81 | 4871.94 | 4869.12 | 4871.09 | 39732.0 |
| 2021-07-02 11:00:00 | ES | Futures | 4871.37 | 4873.91 | 4870.25 | 4873.63 | 40364.0 |
| 2021-07-02 11:30:00 | ES | Futures | 4873.34 | 4880.1 | 4872.5 | 4877.29 | 49710.0 |
| 2021-07-02 12:00:00 | ES | Futures | 4877.29 | 4878.41 | 4876.16 | 4877.85 | 26437.0 |
| 2021-07-02 12:30:00 | ES | Futures | 4877.85 | 4887.14 | 4877.57 | 4886.58 | 55001.0 |
| 2021-07-02 13:00:00 | ES | Futures | 4886.86 | 4889.39 | 4884.33 | 4885.45 | 46902.0 |
| 2021-07-02 13:30:00 | ES | Futures | 4885.45 | 4887.99 | 4884.04 | 4887.42 | 28047.0 |
| 2021-07-02 14:00:00 | ES | Futures | 4887.42 | 4890.24 | 4886.58 | 4889.96 | 30229.0 |
| 2021-07-02 14:30:00 | ES | Futures | 4889.96 | 4890.24 | 4885.73 | 4886.58 | 33017.0 |
| 2021-07-02 15:00:00 | ES | Futures | 4886.58 | 4891.36 | 4885.73 | 4890.8 | 43157.0 |
| 2021-07-02 15:30:00 | ES | Futures | 4890.52 | 4896.15 | 4888.55 | 4891.65 | 129175.0 |
| 2021-07-02 16:00:00 | ES | Futures | 4891.93 | 4891.93 | 4887.42 | 4889.11 | 45126.0 |
| 2021-07-02 16:30:00 | ES | Futures | 4888.83 | 4889.11 | 4885.73 | 4886.86 | 4778.0 |
| 2021-07-02 00:00:00 | NQ | Futures | 16829.32 | 16835.12 | 16828.74 | 16831.64 | 713.0 |
| 2021-07-02 00:30:00 | NQ | Futures | 16831.35 | 16833.67 | 16829.03 | 16830.77 | 591.0 |
| 2021-07-02 01:00:00 | NQ | Futures | 16830.77 | 16834.25 | 16820.92 | 16828.45 | 1039.0 |
| 2021-07-02 01:30:00 | NQ | Futures | 16828.45 | 16829.03 | 16819.18 | 16820.92 | 830.0 |
| 2021-07-02 02:00:00 | NQ | Futures | 16820.92 | 16827.0 | 16816.87 | 16821.21 | 1394.0 |
| 2021-07-02 02:30:00 | NQ | Futures | 16822.37 | 16836.85 | 16820.63 | 16834.25 | 1593.0 |
| 2021-07-02 03:00:00 | NQ | Futures | 16834.25 | 16893.34 | 16833.38 | 16893.34 | 7595.0 |
| 2021-07-02 03:30:00 | NQ | Futures | 16893.34 | 16906.09 | 16880.31 | 16886.39 | 4986.0 |
| 2021-07-02 04:00:00 | NQ | Futures | 16887.26 | 16893.05 | 16865.82 | 16874.8 | 3608.0 |
| 2021-07-02 04:30:00 | NQ | Futures | 16875.09 | 16877.7 | 16866.4 | 16874.51 | 1995.0 |
| 2021-07-02 05:00:00 | NQ | Futures | 16873.06 | 16884.36 | 16870.75 | 16875.67 | 1792.0 |
| 2021-07-02 05:30:00 | NQ | Futures | 16875.67 | 16892.47 | 16873.35 | 16880.89 | 2530.0 |
| 2021-07-02 06:00:00 | NQ | Futures | 16881.75 | 16889.29 | 16878.28 | 16883.78 | 2661.0 |
| 2021-07-02 06:30:00 | NQ | Futures | 16883.78 | 16896.24 | 16880.89 | 16887.84 | 1910.0 |
| 2021-07-02 07:00:00 | NQ | Futures | 16887.55 | 16899.14 | 16887.55 | 16897.69 | 2760.0 |
| 2021-07-02 07:30:00 | NQ | Futures | 16897.98 | 16919.41 | 16897.11 | 16913.33 | 5590.0 |
> showing 50 of 2,941 rows — these rows as CSV