PREVIEW / futures_30min / 2023-05-07
file: by_date/futures_30min/2023/2023-05-07.parquet size: 29 KB rows: 790
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-05-07 18:00:00 | ES | Futures | 4605.18 | 4609.06 | 4603.51 | 4607.39 | 4982.0 |
| 2023-05-07 18:30:00 | ES | Futures | 4607.39 | 4607.39 | 4604.62 | 4605.45 | 1691.0 |
| 2023-05-07 19:00:00 | ES | Futures | 4605.45 | 4608.78 | 4604.9 | 4606.01 | 2459.0 |
| 2023-05-07 19:30:00 | ES | Futures | 4606.29 | 4606.84 | 4599.63 | 4599.91 | 3519.0 |
| 2023-05-07 20:00:00 | ES | Futures | 4599.91 | 4602.12 | 4595.75 | 4600.18 | 7073.0 |
| 2023-05-07 20:30:00 | ES | Futures | 4599.91 | 4601.02 | 4598.24 | 4599.35 | 2834.0 |
| 2023-05-07 21:00:00 | ES | Futures | 4599.07 | 4600.18 | 4596.58 | 4600.18 | 3036.0 |
| 2023-05-07 21:30:00 | ES | Futures | 4600.18 | 4603.23 | 4600.18 | 4601.29 | 4787.0 |
| 2023-05-07 22:00:00 | ES | Futures | 4601.29 | 4604.62 | 4599.91 | 4604.34 | 3591.0 |
| 2023-05-07 22:30:00 | ES | Futures | 4604.34 | 4605.18 | 4602.4 | 4604.07 | 2935.0 |
| 2023-05-07 23:00:00 | ES | Futures | 4604.34 | 4606.84 | 4603.23 | 4604.34 | 3450.0 |
| 2023-05-07 23:30:00 | ES | Futures | 4604.07 | 4604.34 | 4599.91 | 4600.18 | 2332.0 |
| 2023-05-07 18:00:00 | NQ | Futures | 14996.64 | 15012.13 | 14990.73 | 15009.87 | 2729.0 |
| 2023-05-07 18:30:00 | NQ | Futures | 15009.59 | 15010.15 | 14995.51 | 14999.46 | 1068.0 |
| 2023-05-07 19:00:00 | NQ | Futures | 14999.46 | 15015.5 | 14998.33 | 15003.12 | 1562.0 |
| 2023-05-07 19:30:00 | NQ | Futures | 15003.4 | 15005.09 | 14980.03 | 14982.56 | 2185.0 |
| 2023-05-07 20:00:00 | NQ | Futures | 14983.41 | 14993.26 | 14972.14 | 14985.1 | 2797.0 |
| 2023-05-07 20:30:00 | NQ | Futures | 14985.66 | 14989.88 | 14981.15 | 14985.38 | 1045.0 |
| 2023-05-07 21:00:00 | NQ | Futures | 14985.38 | 14988.19 | 14975.24 | 14988.19 | 1058.0 |
| 2023-05-07 21:30:00 | NQ | Futures | 14988.47 | 14997.77 | 14985.38 | 14988.19 | 2279.0 |
| 2023-05-07 22:00:00 | NQ | Futures | 14988.47 | 15004.8 | 14984.53 | 15002.55 | 1809.0 |
| 2023-05-07 22:30:00 | NQ | Futures | 15002.83 | 15007.9 | 14997.2 | 15004.52 | 1720.0 |
| 2023-05-07 23:00:00 | NQ | Futures | 15003.96 | 15012.41 | 14998.89 | 15001.99 | 1531.0 |
| 2023-05-07 23:30:00 | NQ | Futures | 15002.83 | 15003.68 | 14992.14 | 14993.26 | 925.0 |
| 2023-05-07 18:00:00 | YM | Futures | 37307.5 | 37332.9 | 37294.2 | 37319.6 | 548.0 |
| 2023-05-07 18:30:00 | YM | Futures | 37318.5 | 37318.5 | 37300.8 | 37304.2 | 198.0 |
| 2023-05-07 19:00:00 | YM | Futures | 37304.2 | 37325.2 | 37300.8 | 37309.7 | 345.0 |
| 2023-05-07 19:30:00 | YM | Futures | 37311.9 | 37315.2 | 37271.0 | 37275.4 | 543.0 |
| 2023-05-07 20:00:00 | YM | Futures | 37276.5 | 37285.4 | 37245.6 | 37269.9 | 1014.0 |
| 2023-05-07 20:30:00 | YM | Futures | 37268.8 | 37276.5 | 37256.6 | 37263.3 | 312.0 |
| 2023-05-07 21:00:00 | YM | Futures | 37262.2 | 37268.8 | 37246.7 | 37266.6 | 323.0 |
| 2023-05-07 21:30:00 | YM | Futures | 37269.9 | 37285.4 | 37262.2 | 37269.9 | 453.0 |
| 2023-05-07 22:00:00 | YM | Futures | 37271.0 | 37287.6 | 37256.6 | 37285.4 | 568.0 |
| 2023-05-07 22:30:00 | YM | Futures | 37286.5 | 37292.0 | 37274.3 | 37285.4 | 240.0 |
| 2023-05-07 23:00:00 | YM | Futures | 37285.4 | 37297.5 | 37278.7 | 37285.4 | 333.0 |
| 2023-05-07 23:30:00 | YM | Futures | 37286.5 | 37286.5 | 37262.2 | 37264.4 | 332.0 |
| 2023-05-07 18:00:00 | CL | Futures | 57.99 | 58.43 | 57.97 | 58.31 | 3255.0 |
| 2023-05-07 18:30:00 | CL | Futures | 58.31 | 58.32 | 58.13 | 58.15 | 896.0 |
| 2023-05-07 19:00:00 | CL | Futures | 58.15 | 58.23 | 58.13 | 58.21 | 564.0 |
| 2023-05-07 19:30:00 | CL | Futures | 58.2 | 58.21 | 58.01 | 58.04 | 820.0 |
| 2023-05-07 20:00:00 | CL | Futures | 58.04 | 58.09 | 57.97 | 58.04 | 1018.0 |
| 2023-05-07 20:30:00 | CL | Futures | 58.04 | 58.09 | 58.01 | 58.02 | 805.0 |
| 2023-05-07 21:00:00 | CL | Futures | 58.03 | 58.13 | 57.95 | 57.98 | 2104.0 |
| 2023-05-07 21:30:00 | CL | Futures | 57.99 | 58.06 | 57.73 | 57.8 | 1712.0 |
| 2023-05-07 22:00:00 | CL | Futures | 57.8 | 57.96 | 57.79 | 57.96 | 914.0 |
| 2023-05-07 22:30:00 | CL | Futures | 57.96 | 58.2 | 57.94 | 58.11 | 1101.0 |
| 2023-05-07 23:00:00 | CL | Futures | 58.11 | 58.15 | 58.02 | 58.04 | 622.0 |
| 2023-05-07 23:30:00 | CL | Futures | 58.04 | 58.07 | 58.01 | 58.06 | 375.0 |
| 2023-05-07 18:00:00 | GC | Futures | 2328.3 | 2330.4 | 2325.3 | 2326.8 | 1218.0 |
| 2023-05-07 18:30:00 | GC | Futures | 2326.5 | 2326.8 | 2325.6 | 2325.8 | 430.0 |
> showing 50 of 790 rows — these rows as CSV