PREVIEW / futures_30min / 2024-04-21
file: by_date/futures_30min/2024/2024-04-21.parquet size: 30 KB rows: 830
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-04-21 18:00:00 | ES | Futures | 5321.04 | 5327.14 | 5315.73 | 5324.75 | 12442.0 |
| 2024-04-21 18:30:00 | ES | Futures | 5324.75 | 5328.46 | 5323.16 | 5327.14 | 9524.0 |
| 2024-04-21 19:00:00 | ES | Futures | 5326.87 | 5328.2 | 5323.16 | 5325.02 | 5982.0 |
| 2024-04-21 19:30:00 | ES | Futures | 5325.28 | 5330.06 | 5324.48 | 5328.99 | 3131.0 |
| 2024-04-21 20:00:00 | ES | Futures | 5328.73 | 5331.12 | 5327.14 | 5328.46 | 5964.0 |
| 2024-04-21 20:30:00 | ES | Futures | 5328.46 | 5328.73 | 5316.26 | 5317.85 | 10448.0 |
| 2024-04-21 21:00:00 | ES | Futures | 5318.12 | 5325.81 | 5316.0 | 5321.83 | 6381.0 |
| 2024-04-21 21:30:00 | ES | Futures | 5321.57 | 5323.95 | 5317.32 | 5323.95 | 5172.0 |
| 2024-04-21 22:00:00 | ES | Futures | 5323.95 | 5325.81 | 5321.57 | 5324.75 | 3790.0 |
| 2024-04-21 22:30:00 | ES | Futures | 5325.02 | 5326.08 | 5322.36 | 5323.69 | 2350.0 |
| 2024-04-21 23:00:00 | ES | Futures | 5323.69 | 5326.08 | 5323.69 | 5324.75 | 1747.0 |
| 2024-04-21 23:30:00 | ES | Futures | 5324.75 | 5325.02 | 5321.57 | 5322.36 | 2220.0 |
| 2024-04-21 18:00:00 | NQ | Futures | 18434.51 | 18463.4 | 18399.73 | 18455.64 | 5032.0 |
| 2024-04-21 18:30:00 | NQ | Futures | 18455.91 | 18471.42 | 18445.21 | 18465.8 | 3305.0 |
| 2024-04-21 19:00:00 | NQ | Futures | 18465.54 | 18473.83 | 18451.63 | 18460.99 | 2492.0 |
| 2024-04-21 19:30:00 | NQ | Futures | 18460.99 | 18482.39 | 18456.98 | 18478.91 | 2121.0 |
| 2024-04-21 20:00:00 | NQ | Futures | 18478.91 | 18480.25 | 18464.47 | 18467.41 | 2680.0 |
| 2024-04-21 20:30:00 | NQ | Futures | 18467.41 | 18468.21 | 18405.08 | 18423.8 | 5953.0 |
| 2024-04-21 21:00:00 | NQ | Futures | 18423.8 | 18462.59 | 18418.45 | 18439.59 | 4607.0 |
| 2024-04-21 21:30:00 | NQ | Futures | 18440.12 | 18457.24 | 18425.14 | 18454.84 | 3971.0 |
| 2024-04-21 22:00:00 | NQ | Futures | 18455.64 | 18466.07 | 18447.61 | 18459.65 | 2395.0 |
| 2024-04-21 22:30:00 | NQ | Futures | 18459.65 | 18463.4 | 18442.26 | 18448.68 | 1892.0 |
| 2024-04-21 23:00:00 | NQ | Futures | 18447.08 | 18459.92 | 18446.81 | 18454.3 | 1281.0 |
| 2024-04-21 23:30:00 | NQ | Futures | 18453.77 | 18456.71 | 18442.0 | 18446.81 | 1575.0 |
| 2024-04-21 18:00:00 | YM | Futures | 40632.4 | 40683.4 | 40615.4 | 40640.9 | 1248.0 |
| 2024-04-21 18:30:00 | YM | Futures | 40640.9 | 40683.4 | 40634.5 | 40675.9 | 740.0 |
| 2024-04-21 19:00:00 | YM | Futures | 40672.8 | 40680.2 | 40651.5 | 40661.1 | 473.0 |
| 2024-04-21 19:30:00 | YM | Futures | 40662.1 | 40700.4 | 40656.8 | 40692.9 | 518.0 |
| 2024-04-21 20:00:00 | YM | Futures | 40691.9 | 40722.7 | 40683.4 | 40705.7 | 833.0 |
| 2024-04-21 20:30:00 | YM | Futures | 40706.7 | 40707.8 | 40626.0 | 40629.2 | 1276.0 |
| 2024-04-21 21:00:00 | YM | Futures | 40632.4 | 40671.7 | 40613.3 | 40645.2 | 933.0 |
| 2024-04-21 21:30:00 | YM | Futures | 40644.1 | 40657.9 | 40616.5 | 40655.8 | 460.0 |
| 2024-04-21 22:00:00 | YM | Futures | 40657.9 | 40667.4 | 40640.9 | 40660.0 | 271.0 |
| 2024-04-21 22:30:00 | YM | Futures | 40662.1 | 40665.3 | 40643.0 | 40651.5 | 329.0 |
| 2024-04-21 23:00:00 | YM | Futures | 40652.6 | 40662.1 | 40650.5 | 40653.6 | 251.0 |
| 2024-04-21 23:30:00 | YM | Futures | 40654.7 | 40655.8 | 40632.4 | 40638.8 | 260.0 |
| 2024-04-21 18:00:00 | CL | Futures | 69.23 | 69.4 | 69.18 | 69.35 | 1899.0 |
| 2024-04-21 18:30:00 | CL | Futures | 69.36 | 69.37 | 69.27 | 69.27 | 523.0 |
| 2024-04-21 19:00:00 | CL | Futures | 69.27 | 69.46 | 69.27 | 69.41 | 722.0 |
| 2024-04-21 19:30:00 | CL | Futures | 69.41 | 69.46 | 69.3 | 69.3 | 707.0 |
| 2024-04-21 20:00:00 | CL | Futures | 69.3 | 69.31 | 69.07 | 69.16 | 1838.0 |
| 2024-04-21 20:30:00 | CL | Futures | 69.16 | 69.25 | 69.11 | 69.17 | 883.0 |
| 2024-04-21 21:00:00 | CL | Futures | 69.17 | 69.22 | 68.99 | 69.07 | 3274.0 |
| 2024-04-21 21:30:00 | CL | Futures | 69.06 | 69.1 | 68.89 | 68.93 | 2056.0 |
| 2024-04-21 22:00:00 | CL | Futures | 68.94 | 69.05 | 68.89 | 69.01 | 1429.0 |
| 2024-04-21 22:30:00 | CL | Futures | 69.02 | 69.13 | 69.01 | 69.08 | 1101.0 |
| 2024-04-21 23:00:00 | CL | Futures | 69.08 | 69.09 | 68.91 | 68.99 | 1051.0 |
| 2024-04-21 23:30:00 | CL | Futures | 68.99 | 69.05 | 68.99 | 69.0 | 605.0 |
| 2024-04-21 18:00:00 | GC | Futures | 2608.4 | 2609.0 | 2600.0 | 2602.5 | 4759.0 |
| 2024-04-21 18:30:00 | GC | Futures | 2602.4 | 2604.9 | 2601.8 | 2602.5 | 661.0 |
> showing 50 of 830 rows — these rows as CSV