PREVIEW / etf_30min / 2022-02-11
file: by_date/etf_30min/2022/2022-02-11.parquet size: 675 KB rows: 26,869
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-02-11 04:00:00 | SPY | ETF | 446.72 | 447.73 | 446.7 | 447.18 | 22832.0 |
| 2022-02-11 04:30:00 | SPY | ETF | 447.1 | 447.1 | 446.38 | 446.79 | 24186.0 |
| 2022-02-11 05:00:00 | SPY | ETF | 446.75 | 447.08 | 446.75 | 446.89 | 7532.0 |
| 2022-02-11 05:30:00 | SPY | ETF | 447.05 | 447.39 | 446.97 | 447.39 | 7078.0 |
| 2022-02-11 06:00:00 | SPY | ETF | 447.1 | 447.15 | 446.56 | 446.9 | 25520.0 |
| 2022-02-11 06:30:00 | SPY | ETF | 446.93 | 447.18 | 446.69 | 446.93 | 11302.0 |
| 2022-02-11 07:00:00 | SPY | ETF | 446.91 | 449.05 | 446.91 | 448.96 | 182662.0 |
| 2022-02-11 07:30:00 | SPY | ETF | 448.91 | 449.3 | 448.17 | 448.35 | 147597.0 |
| 2022-02-11 08:00:00 | SPY | ETF | 448.35 | 449.5 | 445.41 | 449.15 | 379531.0 |
| 2022-02-11 08:30:00 | SPY | ETF | 449.15 | 450.24 | 449.11 | 449.86 | 384553.0 |
| 2022-02-11 09:00:00 | SPY | ETF | 449.87 | 450.28 | 449.03 | 449.38 | 459200.0 |
| 2022-02-11 09:30:00 | SPY | ETF | 449.41 | 451.605 | 448.79 | 449.1883 | 8523757.0 |
| 2022-02-11 10:00:00 | SPY | ETF | 449.16 | 450.82 | 448.28 | 449.7018 | 6968855.0 |
| 2022-02-11 10:30:00 | SPY | ETF | 449.72 | 450.58 | 448.7 | 449.0 | 3785588.0 |
| 2022-02-11 11:00:00 | SPY | ETF | 449.03 | 450.143 | 447.75 | 448.16 | 4552397.0 |
| 2022-02-11 11:30:00 | SPY | ETF | 448.15 | 448.6 | 446.82 | 447.92 | 5365181.0 |
| 2022-02-11 12:00:00 | SPY | ETF | 447.91 | 448.67 | 447.2661 | 447.92 | 3215287.0 |
| 2022-02-11 12:30:00 | SPY | ETF | 447.93 | 448.32 | 446.39 | 446.685 | 3042836.0 |
| 2022-02-11 13:00:00 | SPY | ETF | 446.68 | 447.7 | 445.68 | 445.69 | 3887776.0 |
| 2022-02-11 13:30:00 | SPY | ETF | 445.68 | 445.75 | 441.0 | 441.76 | 15628221.0 |
| 2022-02-11 14:00:00 | SPY | ETF | 441.72 | 443.9 | 440.48 | 441.22 | 16298301.0 |
| 2022-02-11 14:30:00 | SPY | ETF | 441.23 | 443.12 | 439.43 | 440.94 | 11040629.0 |
| 2022-02-11 15:00:00 | SPY | ETF | 440.95 | 442.79 | 440.01 | 441.08 | 9934540.0 |
| 2022-02-11 15:30:00 | SPY | ETF | 441.08 | 442.52 | 438.94 | 440.51 | 19663445.0 |
| 2022-02-11 16:00:00 | SPY | ETF | 440.51 | 441.64 | 439.95 | 441.6 | 7935139.0 |
| 2022-02-11 16:30:00 | SPY | ETF | 441.6 | 442.0 | 441.36 | 441.47 | 300376.0 |
| 2022-02-11 17:00:00 | SPY | ETF | 441.44 | 441.6 | 440.46 | 441.6 | 72746.0 |
| 2022-02-11 17:30:00 | SPY | ETF | 441.63 | 441.7 | 441.4 | 441.4 | 18810.0 |
| 2022-02-11 18:00:00 | SPY | ETF | 441.41 | 441.64 | 441.1 | 441.2 | 37942.0 |
| 2022-02-11 18:30:00 | SPY | ETF | 440.46 | 441.24 | 440.46 | 440.8 | 33407.0 |
| 2022-02-11 19:00:00 | SPY | ETF | 440.88 | 440.89 | 440.55 | 440.6 | 27926.0 |
| 2022-02-11 19:30:00 | SPY | ETF | 440.51 | 440.55 | 440.4 | 440.5 | 55040.0 |
| 2022-02-11 04:00:00 | QQQ | ETF | 356.58 | 357.02 | 355.8 | 356.57 | 56161.0 |
| 2022-02-11 04:30:00 | QQQ | ETF | 356.49 | 356.49 | 355.4 | 355.7 | 36524.0 |
| 2022-02-11 05:00:00 | QQQ | ETF | 355.63 | 356.0 | 355.63 | 355.97 | 9212.0 |
| 2022-02-11 05:30:00 | QQQ | ETF | 355.98 | 356.33 | 355.89 | 356.25 | 18119.0 |
| 2022-02-11 06:00:00 | QQQ | ETF | 356.34 | 356.35 | 355.41 | 355.88 | 30342.0 |
| 2022-02-11 06:30:00 | QQQ | ETF | 355.85 | 356.05 | 355.62 | 356.0 | 38181.0 |
| 2022-02-11 07:00:00 | QQQ | ETF | 356.08 | 358.21 | 356.0 | 358.17 | 287113.0 |
| 2022-02-11 07:30:00 | QQQ | ETF | 358.12 | 358.47 | 357.41 | 357.7 | 267962.0 |
| 2022-02-11 08:00:00 | QQQ | ETF | 356.2128 | 358.79 | 354.5 | 358.32 | 442889.0 |
| 2022-02-11 08:30:00 | QQQ | ETF | 358.3 | 359.38 | 358.3 | 358.93 | 563231.0 |
| 2022-02-11 09:00:00 | QQQ | ETF | 358.95 | 359.32 | 358.07 | 358.43 | 389088.0 |
| 2022-02-11 09:30:00 | QQQ | ETF | 358.46 | 360.07 | 356.62 | 356.95 | 8232683.0 |
| 2022-02-11 10:00:00 | QQQ | ETF | 356.95 | 359.04 | 355.7611 | 357.15 | 6808500.0 |
| 2022-02-11 10:30:00 | QQQ | ETF | 357.15 | 358.36 | 356.16 | 356.47 | 4242279.0 |
| 2022-02-11 11:00:00 | QQQ | ETF | 356.48 | 357.7499 | 354.96 | 355.4 | 4537293.0 |
| 2022-02-11 11:30:00 | QQQ | ETF | 355.41 | 355.87 | 354.16 | 355.1 | 4897972.0 |
| 2022-02-11 12:00:00 | QQQ | ETF | 355.05 | 355.96 | 354.47 | 355.3299 | 2695081.0 |
| 2022-02-11 12:30:00 | QQQ | ETF | 355.33 | 355.78 | 353.69 | 353.8 | 2646171.0 |
> showing 50 of 26,869 rows — these rows as CSV