PREVIEW / futures_1hour / 2024-04-21
file: by_date/futures_1hour/2024/2024-04-21.parquet size: 20 KB rows: 437
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 | 5328.46 | 5315.73 | 5327.14 | 21966.0 |
| 2024-04-21 19:00:00 | ES | Futures | 5326.87 | 5330.06 | 5323.16 | 5328.99 | 9113.0 |
| 2024-04-21 20:00:00 | ES | Futures | 5328.73 | 5331.12 | 5316.26 | 5317.85 | 16412.0 |
| 2024-04-21 21:00:00 | ES | Futures | 5318.12 | 5325.81 | 5316.0 | 5323.95 | 11553.0 |
| 2024-04-21 22:00:00 | ES | Futures | 5323.95 | 5326.08 | 5321.57 | 5323.69 | 6140.0 |
| 2024-04-21 23:00:00 | ES | Futures | 5323.69 | 5326.08 | 5321.57 | 5322.36 | 3967.0 |
| 2024-04-21 18:00:00 | NQ | Futures | 18434.51 | 18471.42 | 18399.73 | 18465.8 | 8337.0 |
| 2024-04-21 19:00:00 | NQ | Futures | 18465.54 | 18482.39 | 18451.63 | 18478.91 | 4613.0 |
| 2024-04-21 20:00:00 | NQ | Futures | 18478.91 | 18480.25 | 18405.08 | 18423.8 | 8633.0 |
| 2024-04-21 21:00:00 | NQ | Futures | 18423.8 | 18462.59 | 18418.45 | 18454.84 | 8578.0 |
| 2024-04-21 22:00:00 | NQ | Futures | 18455.64 | 18466.07 | 18442.26 | 18448.68 | 4287.0 |
| 2024-04-21 23:00:00 | NQ | Futures | 18447.08 | 18459.92 | 18442.0 | 18446.81 | 2856.0 |
| 2024-04-21 18:00:00 | YM | Futures | 40632.4 | 40683.4 | 40615.4 | 40675.9 | 1988.0 |
| 2024-04-21 19:00:00 | YM | Futures | 40672.8 | 40700.4 | 40651.5 | 40692.9 | 991.0 |
| 2024-04-21 20:00:00 | YM | Futures | 40691.9 | 40722.7 | 40626.0 | 40629.2 | 2109.0 |
| 2024-04-21 21:00:00 | YM | Futures | 40632.4 | 40671.7 | 40613.3 | 40655.8 | 1393.0 |
| 2024-04-21 22:00:00 | YM | Futures | 40657.9 | 40667.4 | 40640.9 | 40651.5 | 600.0 |
| 2024-04-21 23:00:00 | YM | Futures | 40652.6 | 40662.1 | 40632.4 | 40638.8 | 511.0 |
| 2024-04-21 18:00:00 | CL | Futures | 69.23 | 69.4 | 69.18 | 69.27 | 2422.0 |
| 2024-04-21 19:00:00 | CL | Futures | 69.27 | 69.46 | 69.27 | 69.3 | 1429.0 |
| 2024-04-21 20:00:00 | CL | Futures | 69.3 | 69.31 | 69.07 | 69.17 | 2721.0 |
| 2024-04-21 21:00:00 | CL | Futures | 69.17 | 69.22 | 68.89 | 68.93 | 5330.0 |
| 2024-04-21 22:00:00 | CL | Futures | 68.94 | 69.13 | 68.89 | 69.08 | 2530.0 |
| 2024-04-21 23:00:00 | CL | Futures | 69.08 | 69.09 | 68.91 | 69.0 | 1656.0 |
| 2024-04-21 18:00:00 | GC | Futures | 2608.4 | 2609.0 | 2600.0 | 2602.5 | 5420.0 |
| 2024-04-21 19:00:00 | GC | Futures | 2602.5 | 2606.5 | 2601.6 | 2605.1 | 5152.0 |
| 2024-04-21 20:00:00 | GC | Futures | 2605.1 | 2605.1 | 2599.4 | 2600.6 | 4031.0 |
| 2024-04-21 21:00:00 | GC | Futures | 2600.6 | 2603.0 | 2594.0 | 2596.0 | 8244.0 |
| 2024-04-21 22:00:00 | GC | Futures | 2596.1 | 2596.1 | 2589.9 | 2590.1 | 5316.0 |
| 2024-04-21 23:00:00 | GC | Futures | 2590.1 | 2590.1 | 2576.2 | 2586.0 | 14359.0 |
| 2024-04-21 18:00:00 | ZN | Futures | 108.529391 | 108.623874 | 108.466402 | 108.560885 | 25190.0 |
| 2024-04-21 19:00:00 | ZN | Futures | 108.576633 | 108.639621 | 108.560885 | 108.608127 | 15599.0 |
| 2024-04-21 20:00:00 | ZN | Futures | 108.608127 | 108.639621 | 108.450655 | 108.513644 | 35531.0 |
| 2024-04-21 21:00:00 | ZN | Futures | 108.513644 | 108.529391 | 108.434908 | 108.48215 | 22248.0 |
| 2024-04-21 22:00:00 | ZN | Futures | 108.497897 | 108.513644 | 108.434908 | 108.450655 | 11258.0 |
| 2024-04-21 23:00:00 | ZN | Futures | 108.450655 | 108.450655 | 108.387667 | 108.434908 | 9715.0 |
> showing 36 of 437 rows — these rows as CSV