PREVIEW / futures_30min / 2024-02-18
file: by_date/futures_30min/2024/2024-02-18.parquet size: 25 KB rows: 706
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-02-18 18:00:00 | ES | Futures | 5389.54 | 5399.21 | 5389.27 | 5394.91 | 5910.0 |
| 2024-02-18 18:30:00 | ES | Futures | 5395.18 | 5398.13 | 5394.11 | 5398.13 | 2551.0 |
| 2024-02-18 19:00:00 | ES | Futures | 5398.13 | 5400.28 | 5396.25 | 5399.21 | 3659.0 |
| 2024-02-18 19:30:00 | ES | Futures | 5399.48 | 5401.63 | 5399.21 | 5401.09 | 2442.0 |
| 2024-02-18 20:00:00 | ES | Futures | 5401.36 | 5403.51 | 5397.33 | 5398.4 | 4331.0 |
| 2024-02-18 20:30:00 | ES | Futures | 5398.13 | 5398.67 | 5392.22 | 5395.72 | 5361.0 |
| 2024-02-18 21:00:00 | ES | Futures | 5395.72 | 5397.06 | 5394.11 | 5395.72 | 2780.0 |
| 2024-02-18 21:30:00 | ES | Futures | 5395.99 | 5397.33 | 5394.91 | 5395.99 | 1166.0 |
| 2024-02-18 22:00:00 | ES | Futures | 5395.72 | 5397.6 | 5395.45 | 5395.72 | 1091.0 |
| 2024-02-18 22:30:00 | ES | Futures | 5395.72 | 5396.79 | 5394.37 | 5395.72 | 1257.0 |
| 2024-02-18 23:00:00 | ES | Futures | 5395.72 | 5396.52 | 5395.18 | 5395.99 | 1114.0 |
| 2024-02-18 23:30:00 | ES | Futures | 5395.99 | 5398.13 | 5395.72 | 5397.6 | 813.0 |
| 2024-02-18 18:00:00 | NQ | Futures | 19233.09 | 19301.97 | 19229.83 | 19281.09 | 5194.0 |
| 2024-02-18 18:30:00 | NQ | Futures | 19281.63 | 19286.52 | 19272.68 | 19284.89 | 1292.0 |
| 2024-02-18 19:00:00 | NQ | Futures | 19285.7 | 19304.14 | 19280.55 | 19296.55 | 2013.0 |
| 2024-02-18 19:30:00 | NQ | Futures | 19297.64 | 19305.5 | 19296.55 | 19303.33 | 1327.0 |
| 2024-02-18 20:00:00 | NQ | Futures | 19303.33 | 19313.64 | 19281.09 | 19286.52 | 2503.0 |
| 2024-02-18 20:30:00 | NQ | Futures | 19285.97 | 19288.96 | 19252.07 | 19275.94 | 3714.0 |
| 2024-02-18 21:00:00 | NQ | Futures | 19274.31 | 19281.63 | 19266.18 | 19275.13 | 1483.0 |
| 2024-02-18 21:30:00 | NQ | Futures | 19275.4 | 19284.89 | 19269.43 | 19272.96 | 1231.0 |
| 2024-02-18 22:00:00 | NQ | Futures | 19273.23 | 19283.53 | 19271.87 | 19274.58 | 983.0 |
| 2024-02-18 22:30:00 | NQ | Futures | 19274.04 | 19280.82 | 19271.33 | 19275.4 | 900.0 |
| 2024-02-18 23:00:00 | NQ | Futures | 19275.13 | 19279.46 | 19272.96 | 19276.21 | 658.0 |
| 2024-02-18 23:30:00 | NQ | Futures | 19276.21 | 19291.67 | 19275.67 | 19286.52 | 960.0 |
| 2024-02-18 18:00:00 | YM | Futures | 41521.7 | 41588.3 | 41521.7 | 41562.5 | 834.0 |
| 2024-02-18 18:30:00 | YM | Futures | 41562.5 | 41582.9 | 41561.4 | 41580.8 | 262.0 |
| 2024-02-18 19:00:00 | YM | Futures | 41580.8 | 41596.9 | 41572.2 | 41591.5 | 333.0 |
| 2024-02-18 19:30:00 | YM | Futures | 41592.6 | 41602.2 | 41592.6 | 41601.2 | 330.0 |
| 2024-02-18 20:00:00 | YM | Futures | 41602.2 | 41613.0 | 41582.9 | 41586.1 | 501.0 |
| 2024-02-18 20:30:00 | YM | Futures | 41587.2 | 41593.7 | 41565.7 | 41587.2 | 636.0 |
| 2024-02-18 21:00:00 | YM | Futures | 41586.1 | 41589.4 | 41576.5 | 41581.8 | 271.0 |
| 2024-02-18 21:30:00 | YM | Futures | 41582.9 | 41587.2 | 41576.5 | 41580.8 | 141.0 |
| 2024-02-18 22:00:00 | YM | Futures | 41582.9 | 41590.4 | 41580.8 | 41582.9 | 162.0 |
| 2024-02-18 22:30:00 | YM | Futures | 41581.8 | 41589.4 | 41572.2 | 41574.3 | 222.0 |
| 2024-02-18 23:00:00 | YM | Futures | 41574.3 | 41584.0 | 41574.3 | 41578.6 | 145.0 |
| 2024-02-18 23:30:00 | YM | Futures | 41577.5 | 41589.4 | 41575.4 | 41587.2 | 115.0 |
| 2024-02-18 18:00:00 | CL | Futures | 65.57 | 65.57 | 65.29 | 65.39 | 1496.0 |
| 2024-02-18 18:30:00 | CL | Futures | 65.39 | 65.43 | 65.38 | 65.42 | 574.0 |
| 2024-02-18 19:00:00 | CL | Futures | 65.41 | 65.47 | 65.4 | 65.45 | 612.0 |
| 2024-02-18 19:30:00 | CL | Futures | 65.45 | 65.46 | 65.33 | 65.34 | 865.0 |
| 2024-02-18 20:00:00 | CL | Futures | 65.35 | 65.35 | 65.0 | 65.31 | 4255.0 |
| 2024-02-18 20:30:00 | CL | Futures | 65.3 | 65.31 | 65.13 | 65.23 | 1503.0 |
| 2024-02-18 21:00:00 | CL | Futures | 65.24 | 65.24 | 65.12 | 65.17 | 1080.0 |
| 2024-02-18 21:30:00 | CL | Futures | 65.17 | 65.21 | 65.14 | 65.17 | 652.0 |
| 2024-02-18 22:00:00 | CL | Futures | 65.18 | 65.27 | 65.18 | 65.2 | 726.0 |
| 2024-02-18 22:30:00 | CL | Futures | 65.2 | 65.21 | 65.16 | 65.17 | 333.0 |
| 2024-02-18 23:00:00 | CL | Futures | 65.18 | 65.2 | 65.17 | 65.17 | 193.0 |
| 2024-02-18 23:30:00 | CL | Futures | 65.17 | 65.19 | 65.15 | 65.16 | 410.0 |
| 2024-02-18 18:00:00 | GC | Futures | 2222.5 | 2222.8 | 2218.3 | 2220.1 | 2822.0 |
| 2024-02-18 18:30:00 | GC | Futures | 2220.0 | 2221.0 | 2219.7 | 2220.3 | 1457.0 |
> showing 50 of 706 rows — these rows as CSV