PREVIEW / futures_30min / 2023-06-09
file: by_date/futures_30min/2023/2023-06-09.parquet size: 89 KB rows: 3,093
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 |
|---|---|---|---|---|---|---|---|
| 2023-06-09 00:00:00 | ES | Futures | 4764.93 | 4764.93 | 4762.99 | 4763.82 | 1110.0 |
| 2023-06-09 00:30:00 | ES | Futures | 4763.54 | 4764.1 | 4762.16 | 4762.44 | 1018.0 |
| 2023-06-09 01:00:00 | ES | Futures | 4762.44 | 4763.27 | 4762.16 | 4762.44 | 1707.0 |
| 2023-06-09 01:30:00 | ES | Futures | 4762.44 | 4765.76 | 4762.44 | 4765.21 | 3275.0 |
| 2023-06-09 02:00:00 | ES | Futures | 4765.21 | 4765.21 | 4761.05 | 4762.44 | 3795.0 |
| 2023-06-09 02:30:00 | ES | Futures | 4762.44 | 4762.71 | 4760.49 | 4761.88 | 1948.0 |
| 2023-06-09 03:00:00 | ES | Futures | 4761.88 | 4762.16 | 4753.56 | 4754.39 | 11223.0 |
| 2023-06-09 03:30:00 | ES | Futures | 4754.39 | 4760.77 | 4752.73 | 4759.94 | 9590.0 |
| 2023-06-09 04:00:00 | ES | Futures | 4760.22 | 4760.77 | 4756.61 | 4760.77 | 5962.0 |
| 2023-06-09 04:30:00 | ES | Futures | 4760.77 | 4764.38 | 4759.11 | 4764.1 | 5530.0 |
| 2023-06-09 05:00:00 | ES | Futures | 4764.1 | 4767.7 | 4763.82 | 4767.7 | 6503.0 |
| 2023-06-09 05:30:00 | ES | Futures | 4767.7 | 4767.7 | 4761.05 | 4762.44 | 7059.0 |
| 2023-06-09 06:00:00 | ES | Futures | 4762.16 | 4764.65 | 4758.83 | 4763.27 | 6379.0 |
| 2023-06-09 06:30:00 | ES | Futures | 4763.27 | 4764.1 | 4759.94 | 4762.44 | 6139.0 |
| 2023-06-09 07:00:00 | ES | Futures | 4762.71 | 4767.7 | 4761.88 | 4766.04 | 7977.0 |
| 2023-06-09 07:30:00 | ES | Futures | 4766.04 | 4769.92 | 4764.93 | 4767.15 | 9793.0 |
| 2023-06-09 08:00:00 | ES | Futures | 4767.15 | 4771.87 | 4766.87 | 4768.26 | 14132.0 |
| 2023-06-09 08:30:00 | ES | Futures | 4768.26 | 4772.42 | 4766.32 | 4772.42 | 15365.0 |
| 2023-06-09 09:00:00 | ES | Futures | 4772.7 | 4776.58 | 4770.2 | 4776.3 | 18984.0 |
| 2023-06-09 09:30:00 | ES | Futures | 4776.3 | 4791.56 | 4776.03 | 4787.4 | 174076.0 |
| 2023-06-09 10:00:00 | ES | Futures | 4787.4 | 4798.21 | 4787.4 | 4796.83 | 123585.0 |
| 2023-06-09 10:30:00 | ES | Futures | 4796.83 | 4798.77 | 4782.13 | 4788.78 | 133602.0 |
| 2023-06-09 11:00:00 | ES | Futures | 4789.06 | 4795.16 | 4773.53 | 4775.19 | 118954.0 |
| 2023-06-09 11:30:00 | ES | Futures | 4775.19 | 4779.63 | 4768.81 | 4770.48 | 128763.0 |
| 2023-06-09 12:00:00 | ES | Futures | 4770.76 | 4776.03 | 4763.82 | 4767.98 | 85998.0 |
| 2023-06-09 12:30:00 | ES | Futures | 4767.7 | 4774.64 | 4764.1 | 4774.64 | 61073.0 |
| 2023-06-09 13:00:00 | ES | Futures | 4774.36 | 4778.52 | 4772.7 | 4778.52 | 52153.0 |
| 2023-06-09 13:30:00 | ES | Futures | 4778.52 | 4783.51 | 4777.69 | 4783.24 | 51147.0 |
| 2023-06-09 14:00:00 | ES | Futures | 4783.24 | 4785.46 | 4779.08 | 4781.3 | 51962.0 |
| 2023-06-09 14:30:00 | ES | Futures | 4781.3 | 4781.57 | 4775.19 | 4779.63 | 50390.0 |
| 2023-06-09 15:00:00 | ES | Futures | 4779.91 | 4782.4 | 4773.81 | 4778.24 | 61701.0 |
| 2023-06-09 15:30:00 | ES | Futures | 4777.97 | 4780.19 | 4772.7 | 4776.03 | 114782.0 |
| 2023-06-09 16:00:00 | ES | Futures | 4776.3 | 4780.46 | 4775.75 | 4780.46 | 34387.0 |
| 2023-06-09 16:30:00 | ES | Futures | 4780.46 | 4780.46 | 4775.19 | 4775.75 | 16246.0 |
| 2023-06-09 00:00:00 | NQ | Futures | 16329.79 | 16330.07 | 16317.12 | 16322.75 | 786.0 |
| 2023-06-09 00:30:00 | NQ | Futures | 16323.04 | 16325.01 | 16316.28 | 16316.84 | 606.0 |
| 2023-06-09 01:00:00 | NQ | Futures | 16317.12 | 16326.98 | 16316.84 | 16320.5 | 968.0 |
| 2023-06-09 01:30:00 | NQ | Futures | 16320.78 | 16339.08 | 16319.94 | 16332.33 | 1793.0 |
| 2023-06-09 02:00:00 | NQ | Futures | 16332.89 | 16334.02 | 16316.84 | 16330.07 | 1381.0 |
| 2023-06-09 02:30:00 | NQ | Futures | 16330.92 | 16332.05 | 16320.78 | 16327.82 | 840.0 |
| 2023-06-09 03:00:00 | NQ | Futures | 16328.1 | 16330.07 | 16294.88 | 16302.48 | 3377.0 |
| 2023-06-09 03:30:00 | NQ | Futures | 16303.33 | 16316.56 | 16285.31 | 16307.27 | 3858.0 |
| 2023-06-09 04:00:00 | NQ | Futures | 16307.27 | 16321.91 | 16301.36 | 16320.22 | 2810.0 |
| 2023-06-09 04:30:00 | NQ | Futures | 16319.94 | 16336.27 | 16314.87 | 16332.61 | 2433.0 |
| 2023-06-09 05:00:00 | NQ | Futures | 16332.61 | 16348.94 | 16331.48 | 16348.66 | 2539.0 |
| 2023-06-09 05:30:00 | NQ | Futures | 16348.09 | 16348.94 | 16321.07 | 16328.95 | 2277.0 |
| 2023-06-09 06:00:00 | NQ | Futures | 16328.39 | 16347.81 | 16319.94 | 16341.34 | 2708.0 |
| 2023-06-09 06:30:00 | NQ | Futures | 16340.77 | 16341.9 | 16312.06 | 16325.57 | 3337.0 |
| 2023-06-09 07:00:00 | NQ | Futures | 16325.85 | 16354.01 | 16325.85 | 16345.84 | 3159.0 |
| 2023-06-09 07:30:00 | NQ | Futures | 16345.56 | 16363.86 | 16341.06 | 16350.07 | 4032.0 |
> showing 50 of 3,093 rows — these rows as CSV