PREVIEW / futures_30min / 2024-07-02
file: by_date/futures_30min/2024/2024-07-02.parquet size: 107 KB rows: 3,934
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 |
|---|---|---|---|---|---|---|---|
| 2024-07-02 00:00:00 | ES | Futures | 5790.42 | 5791.99 | 5789.89 | 5791.73 | 1877.0 |
| 2024-07-02 00:30:00 | ES | Futures | 5791.73 | 5792.77 | 5790.68 | 5791.46 | 1263.0 |
| 2024-07-02 01:00:00 | ES | Futures | 5791.73 | 5793.04 | 5790.42 | 5793.04 | 1505.0 |
| 2024-07-02 01:30:00 | ES | Futures | 5792.77 | 5796.44 | 5792.77 | 5795.4 | 3046.0 |
| 2024-07-02 02:00:00 | ES | Futures | 5795.4 | 5796.71 | 5790.94 | 5793.56 | 4500.0 |
| 2024-07-02 02:30:00 | ES | Futures | 5793.56 | 5793.56 | 5788.58 | 5790.15 | 4520.0 |
| 2024-07-02 03:00:00 | ES | Futures | 5790.15 | 5790.15 | 5780.45 | 5781.24 | 15801.0 |
| 2024-07-02 03:30:00 | ES | Futures | 5781.5 | 5783.86 | 5776.78 | 5782.81 | 11926.0 |
| 2024-07-02 04:00:00 | ES | Futures | 5782.81 | 5784.65 | 5778.36 | 5778.36 | 9233.0 |
| 2024-07-02 04:30:00 | ES | Futures | 5778.36 | 5782.55 | 5776.0 | 5781.5 | 6774.0 |
| 2024-07-02 05:00:00 | ES | Futures | 5781.76 | 5784.12 | 5777.04 | 5780.72 | 7325.0 |
| 2024-07-02 05:30:00 | ES | Futures | 5780.72 | 5782.03 | 5777.04 | 5779.93 | 6531.0 |
| 2024-07-02 06:00:00 | ES | Futures | 5780.19 | 5781.24 | 5778.62 | 5780.45 | 5218.0 |
| 2024-07-02 06:30:00 | ES | Futures | 5780.19 | 5783.34 | 5778.88 | 5781.5 | 4497.0 |
| 2024-07-02 07:00:00 | ES | Futures | 5781.5 | 5782.03 | 5773.37 | 5776.0 | 9747.0 |
| 2024-07-02 07:30:00 | ES | Futures | 5776.26 | 5777.83 | 5770.49 | 5776.52 | 13787.0 |
| 2024-07-02 08:00:00 | ES | Futures | 5776.52 | 5780.45 | 5774.95 | 5779.67 | 13671.0 |
| 2024-07-02 08:30:00 | ES | Futures | 5779.67 | 5781.76 | 5776.26 | 5779.67 | 15762.0 |
| 2024-07-02 09:00:00 | ES | Futures | 5779.4 | 5786.22 | 5779.14 | 5784.39 | 29517.0 |
| 2024-07-02 09:30:00 | ES | Futures | 5784.39 | 5805.1 | 5783.34 | 5799.59 | 170130.0 |
| 2024-07-02 10:00:00 | ES | Futures | 5799.59 | 5805.62 | 5792.51 | 5801.69 | 121878.0 |
| 2024-07-02 10:30:00 | ES | Futures | 5801.69 | 5808.5 | 5799.07 | 5806.14 | 85549.0 |
| 2024-07-02 11:00:00 | ES | Futures | 5805.88 | 5810.08 | 5802.74 | 5809.55 | 55287.0 |
| 2024-07-02 11:30:00 | ES | Futures | 5809.55 | 5814.01 | 5803.79 | 5805.1 | 72392.0 |
| 2024-07-02 12:00:00 | ES | Futures | 5804.83 | 5807.72 | 5799.33 | 5806.93 | 59319.0 |
| 2024-07-02 12:30:00 | ES | Futures | 5806.67 | 5808.77 | 5804.31 | 5808.24 | 28370.0 |
| 2024-07-02 13:00:00 | ES | Futures | 5808.24 | 5818.47 | 5807.46 | 5815.32 | 67747.0 |
| 2024-07-02 13:30:00 | ES | Futures | 5815.58 | 5824.23 | 5813.22 | 5821.87 | 50224.0 |
| 2024-07-02 14:00:00 | ES | Futures | 5822.14 | 5828.69 | 5821.61 | 5826.86 | 41393.0 |
| 2024-07-02 14:30:00 | ES | Futures | 5826.86 | 5829.74 | 5825.02 | 5825.81 | 36837.0 |
| 2024-07-02 15:00:00 | ES | Futures | 5825.81 | 5830.53 | 5824.23 | 5829.22 | 43923.0 |
| 2024-07-02 15:30:00 | ES | Futures | 5828.95 | 5840.75 | 5827.38 | 5840.49 | 157158.0 |
| 2024-07-02 16:00:00 | ES | Futures | 5840.49 | 5840.75 | 5832.89 | 5834.46 | 45108.0 |
| 2024-07-02 16:30:00 | ES | Futures | 5834.2 | 5834.72 | 5831.31 | 5833.41 | 8086.0 |
| 2024-07-02 18:00:00 | ES | Futures | 5834.46 | 5835.77 | 5831.57 | 5835.25 | 2952.0 |
| 2024-07-02 18:30:00 | ES | Futures | 5835.25 | 5836.56 | 5834.98 | 5835.77 | 1192.0 |
| 2024-07-02 19:00:00 | ES | Futures | 5835.77 | 5836.56 | 5832.89 | 5833.15 | 1216.0 |
| 2024-07-02 19:30:00 | ES | Futures | 5833.15 | 5833.41 | 5831.57 | 5832.62 | 2077.0 |
| 2024-07-02 20:00:00 | ES | Futures | 5832.89 | 5837.34 | 5832.62 | 5836.03 | 3174.0 |
| 2024-07-02 20:30:00 | ES | Futures | 5835.77 | 5837.34 | 5835.25 | 5835.77 | 1447.0 |
| 2024-07-02 21:00:00 | ES | Futures | 5835.51 | 5835.77 | 5833.67 | 5834.98 | 2103.0 |
| 2024-07-02 21:30:00 | ES | Futures | 5834.72 | 5834.72 | 5832.1 | 5833.67 | 2911.0 |
| 2024-07-02 22:00:00 | ES | Futures | 5833.41 | 5835.25 | 5833.41 | 5834.98 | 2194.0 |
| 2024-07-02 22:30:00 | ES | Futures | 5834.72 | 5834.98 | 5831.84 | 5834.2 | 1583.0 |
| 2024-07-02 23:00:00 | ES | Futures | 5834.2 | 5835.77 | 5830.26 | 5830.53 | 3932.0 |
| 2024-07-02 23:30:00 | ES | Futures | 5830.53 | 5832.89 | 5830.53 | 5831.84 | 1609.0 |
| 2024-07-02 00:00:00 | NQ | Futures | 21099.59 | 21105.67 | 21096.16 | 21102.76 | 1120.0 |
| 2024-07-02 00:30:00 | NQ | Futures | 21103.29 | 21108.83 | 21095.63 | 21099.86 | 980.0 |
| 2024-07-02 01:00:00 | NQ | Futures | 21100.12 | 21110.15 | 21093.52 | 21109.1 | 1115.0 |
| 2024-07-02 01:30:00 | NQ | Futures | 21109.1 | 21133.38 | 21109.1 | 21129.42 | 2113.0 |
> showing 50 of 3,934 rows — these rows as CSV