PREVIEW / etf_30min / 2024-11-11
file: by_date/etf_30min/2024/2024-11-11.parquet size: 923 KB rows: 36,766
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-11-11 04:00:00 | SPY | ETF | 599.22 | 600.03 | 599.0 | 599.88 | 46597.0 |
| 2024-11-11 04:30:00 | SPY | ETF | 599.91 | 600.0 | 599.8 | 599.83 | 6309.0 |
| 2024-11-11 05:00:00 | SPY | ETF | 599.86 | 599.95 | 599.81 | 599.86 | 3964.0 |
| 2024-11-11 05:30:00 | SPY | ETF | 599.93 | 599.93 | 599.65 | 599.65 | 2191.0 |
| 2024-11-11 06:00:00 | SPY | ETF | 599.62 | 599.78 | 599.62 | 599.78 | 1781.0 |
| 2024-11-11 06:30:00 | SPY | ETF | 599.75 | 600.0 | 599.75 | 599.89 | 18719.0 |
| 2024-11-11 07:00:00 | SPY | ETF | 599.9 | 600.429 | 599.9 | 600.381 | 26998.0 |
| 2024-11-11 07:30:00 | SPY | ETF | 600.38 | 600.98 | 600.38 | 600.67 | 96590.0 |
| 2024-11-11 08:00:00 | SPY | ETF | 599.9006 | 601.0 | 599.22 | 600.41 | 155596.0 |
| 2024-11-11 08:30:00 | SPY | ETF | 600.44 | 600.44 | 599.75 | 599.86 | 159496.0 |
| 2024-11-11 09:00:00 | SPY | ETF | 599.88 | 599.94 | 599.63 | 599.85 | 129743.0 |
| 2024-11-11 09:30:00 | SPY | ETF | 599.82 | 600.17 | 598.8901 | 599.162 | 3331392.0 |
| 2024-11-11 10:00:00 | SPY | ETF | 599.17 | 599.25 | 598.53 | 598.87 | 1893255.0 |
| 2024-11-11 10:30:00 | SPY | ETF | 598.88 | 599.95 | 598.88 | 599.68 | 1571298.0 |
| 2024-11-11 11:00:00 | SPY | ETF | 599.69 | 599.9599 | 599.015 | 599.09 | 944781.0 |
| 2024-11-11 11:30:00 | SPY | ETF | 599.1 | 599.53 | 598.93 | 599.445 | 757099.0 |
| 2024-11-11 12:00:00 | SPY | ETF | 599.41 | 599.56 | 598.685 | 598.8091 | 725709.0 |
| 2024-11-11 12:30:00 | SPY | ETF | 598.8 | 599.03 | 598.2106 | 598.23 | 1059528.0 |
| 2024-11-11 13:00:00 | SPY | ETF | 598.21 | 598.215 | 597.0 | 597.85 | 1724186.0 |
| 2024-11-11 13:30:00 | SPY | ETF | 597.85 | 598.64 | 597.5702 | 598.23 | 1004154.0 |
| 2024-11-11 14:00:00 | SPY | ETF | 598.24 | 598.3499 | 598.0 | 598.1437 | 808855.0 |
| 2024-11-11 14:30:00 | SPY | ETF | 598.16 | 598.41 | 598.01 | 598.2885 | 862952.0 |
| 2024-11-11 15:00:00 | SPY | ETF | 598.29 | 598.5888 | 598.04 | 598.2799 | 1348388.0 |
| 2024-11-11 15:30:00 | SPY | ETF | 598.27 | 598.84 | 597.98 | 598.72 | 4778767.0 |
| 2024-11-11 16:00:00 | SPY | ETF | 598.73 | 598.81 | 598.17 | 598.56 | 2720193.0 |
| 2024-11-11 16:30:00 | SPY | ETF | 598.51 | 598.76 | 598.38 | 598.38 | 424206.0 |
| 2024-11-11 17:00:00 | SPY | ETF | 598.37 | 598.76 | 598.2 | 598.3376 | 180350.0 |
| 2024-11-11 17:30:00 | SPY | ETF | 598.3498 | 598.39 | 598.2 | 598.39 | 11203.0 |
| 2024-11-11 18:00:00 | SPY | ETF | 598.39 | 598.4 | 598.03 | 598.31 | 22709.0 |
| 2024-11-11 18:30:00 | SPY | ETF | 598.25 | 598.271 | 598.06 | 598.271 | 8808.0 |
| 2024-11-11 19:00:00 | SPY | ETF | 598.31 | 598.34 | 598.01 | 598.09 | 6956.0 |
| 2024-11-11 19:30:00 | SPY | ETF | 598.06 | 598.14 | 597.82 | 598.14 | 38707.0 |
| 2024-11-11 04:00:00 | QQQ | ETF | 515.52 | 515.93 | 515.22 | 515.73 | 51469.0 |
| 2024-11-11 04:30:00 | QQQ | ETF | 515.78 | 515.86 | 515.54 | 515.61 | 17998.0 |
| 2024-11-11 05:00:00 | QQQ | ETF | 515.6 | 515.77 | 515.35 | 515.35 | 9672.0 |
| 2024-11-11 05:30:00 | QQQ | ETF | 515.23 | 515.45 | 515.1 | 515.1 | 9564.0 |
| 2024-11-11 06:00:00 | QQQ | ETF | 515.05 | 515.39 | 515.0 | 515.3 | 14904.0 |
| 2024-11-11 06:30:00 | QQQ | ETF | 515.44 | 515.49 | 515.26 | 515.41 | 19228.0 |
| 2024-11-11 07:00:00 | QQQ | ETF | 515.41 | 516.04 | 515.37 | 516.03 | 53449.0 |
| 2024-11-11 07:30:00 | QQQ | ETF | 516.06 | 516.6 | 516.0 | 516.42 | 33077.0 |
| 2024-11-11 08:00:00 | QQQ | ETF | 515.65 | 516.68 | 514.525 | 515.92 | 91491.0 |
| 2024-11-11 08:30:00 | QQQ | ETF | 515.91 | 515.99 | 515.4612 | 515.8 | 60387.0 |
| 2024-11-11 09:00:00 | QQQ | ETF | 515.78 | 515.929 | 515.341 | 515.3696 | 117653.0 |
| 2024-11-11 09:30:00 | QQQ | ETF | 515.36 | 515.58 | 512.43 | 512.6297 | 2829388.0 |
| 2024-11-11 10:00:00 | QQQ | ETF | 512.64 | 513.49 | 512.24 | 513.11 | 1423592.0 |
| 2024-11-11 10:30:00 | QQQ | ETF | 513.09 | 514.43 | 513.09 | 513.92 | 1345938.0 |
| 2024-11-11 11:00:00 | QQQ | ETF | 513.93 | 514.1494 | 513.38 | 513.5168 | 736345.0 |
| 2024-11-11 11:30:00 | QQQ | ETF | 513.56 | 513.81 | 513.13 | 513.41 | 649749.0 |
| 2024-11-11 12:00:00 | QQQ | ETF | 513.4099 | 513.68 | 512.48 | 512.67 | 879339.0 |
| 2024-11-11 12:30:00 | QQQ | ETF | 512.66 | 513.09 | 512.31 | 512.34 | 718738.0 |
> showing 50 of 36,766 rows — these rows as CSV