PREVIEW / etf_30min / 2022-02-17
file: by_date/etf_30min/2022/2022-02-17.parquet size: 658 KB rows: 25,674
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-17 04:00:00 | SPY | ETF | 445.69 | 445.69 | 443.9 | 444.37 | 35658.0 |
| 2022-02-17 04:30:00 | SPY | ETF | 444.41 | 444.41 | 443.55 | 444.05 | 7541.0 |
| 2022-02-17 05:00:00 | SPY | ETF | 443.96 | 444.44 | 443.84 | 444.4 | 3462.0 |
| 2022-02-17 05:30:00 | SPY | ETF | 444.4 | 444.79 | 444.36 | 444.5 | 6251.0 |
| 2022-02-17 06:00:00 | SPY | ETF | 444.46 | 444.46 | 444.05 | 444.3 | 38574.0 |
| 2022-02-17 06:30:00 | SPY | ETF | 444.23 | 444.54 | 444.0 | 444.47 | 29509.0 |
| 2022-02-17 07:00:00 | SPY | ETF | 444.44 | 445.28 | 444.43 | 445.07 | 193163.0 |
| 2022-02-17 07:30:00 | SPY | ETF | 445.1 | 445.67 | 444.97 | 445.47 | 172961.0 |
| 2022-02-17 08:00:00 | SPY | ETF | 445.0 | 446.03 | 443.8896 | 444.66 | 517544.0 |
| 2022-02-17 08:30:00 | SPY | ETF | 444.59 | 444.8 | 442.8 | 442.98 | 537363.0 |
| 2022-02-17 09:00:00 | SPY | ETF | 442.92 | 444.51 | 442.92 | 443.17 | 946370.0 |
| 2022-02-17 09:30:00 | SPY | ETF | 443.22 | 443.8 | 440.54 | 440.7899 | 8933687.0 |
| 2022-02-17 10:00:00 | SPY | ETF | 440.77 | 441.6697 | 439.89 | 440.02 | 5629875.0 |
| 2022-02-17 10:30:00 | SPY | ETF | 440.01 | 441.15 | 439.8 | 440.92 | 5228086.0 |
| 2022-02-17 11:00:00 | SPY | ETF | 440.9 | 441.84 | 440.63 | 441.48 | 3755191.0 |
| 2022-02-17 11:30:00 | SPY | ETF | 441.47 | 442.12 | 440.95 | 441.2 | 2901617.0 |
| 2022-02-17 12:00:00 | SPY | ETF | 441.21 | 441.66 | 440.72 | 441.42 | 2583302.0 |
| 2022-02-17 12:30:00 | SPY | ETF | 441.41 | 441.85 | 440.77 | 441.15 | 2022284.0 |
| 2022-02-17 13:00:00 | SPY | ETF | 441.14 | 441.27 | 440.2 | 440.475 | 2385716.0 |
| 2022-02-17 13:30:00 | SPY | ETF | 440.46 | 440.9 | 439.97 | 440.33 | 2407515.0 |
| 2022-02-17 14:00:00 | SPY | ETF | 440.32 | 440.32 | 439.0101 | 439.17 | 3452083.0 |
| 2022-02-17 14:30:00 | SPY | ETF | 439.17 | 439.33 | 438.295 | 438.38 | 3750072.0 |
| 2022-02-17 15:00:00 | SPY | ETF | 438.36 | 438.61 | 436.91 | 437.65 | 6688084.0 |
| 2022-02-17 15:30:00 | SPY | ETF | 437.65 | 438.69 | 436.42 | 437.11 | 20128133.0 |
| 2022-02-17 16:00:00 | SPY | ETF | 437.11 | 437.58 | 436.37 | 436.92 | 5494959.0 |
| 2022-02-17 16:30:00 | SPY | ETF | 436.92 | 437.35 | 436.83 | 437.12 | 165653.0 |
| 2022-02-17 17:00:00 | SPY | ETF | 437.28 | 437.28 | 436.97 | 437.02 | 66664.0 |
| 2022-02-17 17:30:00 | SPY | ETF | 437.02 | 437.08 | 436.92 | 437.08 | 46250.0 |
| 2022-02-17 18:00:00 | SPY | ETF | 437.08 | 437.44 | 436.52 | 437.43 | 105753.0 |
| 2022-02-17 18:30:00 | SPY | ETF | 437.06 | 437.67 | 437.06 | 437.44 | 45516.0 |
| 2022-02-17 19:00:00 | SPY | ETF | 437.44 | 437.79 | 436.94 | 437.2 | 39532.0 |
| 2022-02-17 19:30:00 | SPY | ETF | 437.2 | 437.29 | 436.09 | 437.18 | 80518.0 |
| 2022-02-17 04:00:00 | QQQ | ETF | 352.0 | 354.21 | 350.0 | 353.88 | 186774.0 |
| 2022-02-17 04:30:00 | QQQ | ETF | 353.86 | 353.86 | 353.09 | 353.65 | 194366.0 |
| 2022-02-17 05:00:00 | QQQ | ETF | 353.54 | 353.97 | 353.54 | 353.85 | 6441.0 |
| 2022-02-17 05:30:00 | QQQ | ETF | 353.72 | 354.11 | 353.71 | 353.94 | 13699.0 |
| 2022-02-17 06:00:00 | QQQ | ETF | 353.8 | 353.85 | 353.44 | 353.49 | 15690.0 |
| 2022-02-17 06:30:00 | QQQ | ETF | 353.54 | 354.0 | 353.28 | 353.93 | 41056.0 |
| 2022-02-17 07:00:00 | QQQ | ETF | 353.82 | 354.52 | 353.78 | 354.37 | 51242.0 |
| 2022-02-17 07:30:00 | QQQ | ETF | 354.41 | 354.93 | 354.3 | 354.78 | 71420.0 |
| 2022-02-17 08:00:00 | QQQ | ETF | 354.3101 | 355.3 | 353.18 | 353.86 | 509193.0 |
| 2022-02-17 08:30:00 | QQQ | ETF | 353.9 | 354.27 | 352.31 | 352.57 | 446051.0 |
| 2022-02-17 09:00:00 | QQQ | ETF | 352.56 | 353.65 | 352.47 | 352.64 | 549678.0 |
| 2022-02-17 09:30:00 | QQQ | ETF | 352.69 | 353.46 | 350.54 | 351.2563 | 6815111.0 |
| 2022-02-17 10:00:00 | QQQ | ETF | 351.23 | 351.9 | 349.6477 | 349.77 | 3806409.0 |
| 2022-02-17 10:30:00 | QQQ | ETF | 349.75 | 350.59 | 349.26 | 350.24 | 3544688.0 |
| 2022-02-17 11:00:00 | QQQ | ETF | 350.22 | 351.388 | 349.93 | 351.07 | 2878569.0 |
| 2022-02-17 11:30:00 | QQQ | ETF | 351.1 | 351.32 | 350.08 | 350.18 | 2379212.0 |
| 2022-02-17 12:00:00 | QQQ | ETF | 350.1894 | 350.405 | 349.07 | 349.8 | 2077006.0 |
| 2022-02-17 12:30:00 | QQQ | ETF | 349.79 | 350.39 | 349.53 | 349.92 | 1161851.0 |
> showing 50 of 25,674 rows — these rows as CSV