PREVIEW / etf_30min / 2022-10-26
file: by_date/etf_30min/2022/2022-10-26.parquet size: 684 KB rows: 27,753
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 |
|---|---|---|---|---|---|---|---|
| 2022-10-26 04:00:00 | SPY | ETF | 382.15 | 382.94 | 381.86 | 382.73 | 75905.0 |
| 2022-10-26 04:30:00 | SPY | ETF | 382.71 | 383.22 | 382.47 | 383.13 | 33467.0 |
| 2022-10-26 05:00:00 | SPY | ETF | 382.9 | 382.96 | 382.0 | 382.07 | 27649.0 |
| 2022-10-26 05:30:00 | SPY | ETF | 382.0 | 382.36 | 381.8 | 381.81 | 14818.0 |
| 2022-10-26 06:00:00 | SPY | ETF | 381.86 | 382.28 | 381.54 | 382.14 | 96700.0 |
| 2022-10-26 06:30:00 | SPY | ETF | 382.1 | 382.73 | 382.09 | 382.55 | 57210.0 |
| 2022-10-26 07:00:00 | SPY | ETF | 382.53 | 383.1 | 382.2 | 382.77 | 115435.0 |
| 2022-10-26 07:30:00 | SPY | ETF | 382.96 | 383.27 | 381.77 | 382.03 | 212164.0 |
| 2022-10-26 08:00:00 | SPY | ETF | 382.48 | 383.27 | 381.2 | 381.73 | 274210.0 |
| 2022-10-26 08:30:00 | SPY | ETF | 381.73 | 381.85 | 381.06 | 381.7 | 300539.0 |
| 2022-10-26 09:00:00 | SPY | ETF | 381.63 | 382.2983 | 381.44 | 381.65 | 256127.0 |
| 2022-10-26 09:30:00 | SPY | ETF | 381.61 | 383.15 | 381.35 | 381.69 | 7431317.0 |
| 2022-10-26 10:00:00 | SPY | ETF | 381.72 | 384.9 | 381.72 | 384.61 | 6842980.0 |
| 2022-10-26 10:30:00 | SPY | ETF | 384.6125 | 385.95 | 384.09 | 385.04 | 4410747.0 |
| 2022-10-26 11:00:00 | SPY | ETF | 385.03 | 387.1493 | 385.03 | 386.845 | 4141709.0 |
| 2022-10-26 11:30:00 | SPY | ETF | 386.845 | 387.58 | 386.48 | 386.82 | 3352817.0 |
| 2022-10-26 12:00:00 | SPY | ETF | 386.81 | 387.24 | 386.02 | 386.21 | 3142673.0 |
| 2022-10-26 12:30:00 | SPY | ETF | 386.21 | 386.75 | 384.05 | 384.34 | 4041431.0 |
| 2022-10-26 13:00:00 | SPY | ETF | 384.33 | 384.4499 | 383.1 | 383.2199 | 4441894.0 |
| 2022-10-26 13:30:00 | SPY | ETF | 383.215 | 383.92 | 382.72 | 383.78 | 4037645.0 |
| 2022-10-26 14:00:00 | SPY | ETF | 383.7778 | 384.3399 | 382.67 | 382.77 | 3668255.0 |
| 2022-10-26 14:30:00 | SPY | ETF | 382.77 | 383.22 | 381.97 | 382.4099 | 3750889.0 |
| 2022-10-26 15:00:00 | SPY | ETF | 382.4 | 382.62 | 381.47 | 382.3088 | 4632357.0 |
| 2022-10-26 15:30:00 | SPY | ETF | 382.3099 | 383.01 | 381.73 | 382.08 | 10972430.0 |
| 2022-10-26 16:00:00 | SPY | ETF | 382.09 | 383.44 | 381.91 | 382.69 | 4915808.0 |
| 2022-10-26 16:30:00 | SPY | ETF | 382.65 | 383.56 | 382.65 | 383.17 | 270605.0 |
| 2022-10-26 17:00:00 | SPY | ETF | 383.17 | 383.17 | 382.02 | 382.71 | 288689.0 |
| 2022-10-26 17:30:00 | SPY | ETF | 382.75 | 383.0 | 382.35 | 382.5518 | 88590.0 |
| 2022-10-26 18:00:00 | SPY | ETF | 382.55 | 382.92 | 382.02 | 382.92 | 178296.0 |
| 2022-10-26 18:30:00 | SPY | ETF | 382.94 | 383.081 | 382.68 | 382.95 | 50445.0 |
| 2022-10-26 19:00:00 | SPY | ETF | 383.05 | 383.77 | 383.0 | 383.48 | 64895.0 |
| 2022-10-26 19:30:00 | SPY | ETF | 383.44 | 384.04 | 383.43 | 383.86 | 59986.0 |
| 2022-10-26 04:00:00 | QQQ | ETF | 279.32 | 280.58 | 279.32 | 280.2 | 135449.0 |
| 2022-10-26 04:30:00 | QQQ | ETF | 280.2 | 280.72 | 280.04 | 280.58 | 67636.0 |
| 2022-10-26 05:00:00 | QQQ | ETF | 280.49 | 280.49 | 279.44 | 279.48 | 40726.0 |
| 2022-10-26 05:30:00 | QQQ | ETF | 279.49 | 279.88 | 279.38 | 279.58 | 46549.0 |
| 2022-10-26 06:00:00 | QQQ | ETF | 279.53 | 279.77 | 279.29 | 279.68 | 95334.0 |
| 2022-10-26 06:30:00 | QQQ | ETF | 279.72 | 280.03 | 279.61 | 279.88 | 62124.0 |
| 2022-10-26 07:00:00 | QQQ | ETF | 279.89 | 280.1 | 279.27 | 279.97 | 193589.0 |
| 2022-10-26 07:30:00 | QQQ | ETF | 279.99 | 280.4 | 279.16 | 279.46 | 251146.0 |
| 2022-10-26 08:00:00 | QQQ | ETF | 279.86 | 284.423 | 278.6 | 279.04 | 396778.0 |
| 2022-10-26 08:30:00 | QQQ | ETF | 279.04 | 279.25 | 278.58 | 279.21 | 433623.0 |
| 2022-10-26 09:00:00 | QQQ | ETF | 279.2 | 279.55 | 278.45 | 278.47 | 754079.0 |
| 2022-10-26 09:30:00 | QQQ | ETF | 278.46 | 279.79 | 277.43 | 278.6601 | 7133910.0 |
| 2022-10-26 10:00:00 | QQQ | ETF | 278.64 | 281.55 | 278.64 | 280.96 | 5965121.0 |
| 2022-10-26 10:30:00 | QQQ | ETF | 280.97 | 282.8 | 280.55 | 281.595 | 3540202.0 |
| 2022-10-26 11:00:00 | QQQ | ETF | 281.59 | 283.8 | 281.59 | 283.44 | 3284666.0 |
| 2022-10-26 11:30:00 | QQQ | ETF | 283.435 | 283.98 | 282.79 | 283.08 | 2785111.0 |
| 2022-10-26 12:00:00 | QQQ | ETF | 283.0701 | 283.41 | 282.28 | 282.46 | 2611650.0 |
| 2022-10-26 12:30:00 | QQQ | ETF | 282.434 | 282.96 | 280.19 | 280.44 | 2965356.0 |
> showing 50 of 27,753 rows — these rows as CSV