PREVIEW / etf_30min / 2022-02-10
file: by_date/etf_30min/2022/2022-02-10.parquet size: 685 KB rows: 26,890
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-10 04:00:00 | SPY | ETF | 456.7 | 456.7 | 456.0 | 456.55 | 21506.0 |
| 2022-02-10 04:30:00 | SPY | ETF | 456.56 | 456.7 | 456.3 | 456.4 | 15539.0 |
| 2022-02-10 05:00:00 | SPY | ETF | 456.37 | 456.53 | 456.17 | 456.46 | 2395.0 |
| 2022-02-10 05:30:00 | SPY | ETF | 456.42 | 456.9 | 456.41 | 456.82 | 15328.0 |
| 2022-02-10 06:00:00 | SPY | ETF | 456.94 | 457.0 | 456.8 | 456.89 | 40351.0 |
| 2022-02-10 06:30:00 | SPY | ETF | 456.85 | 456.87 | 456.54 | 456.54 | 99721.0 |
| 2022-02-10 07:00:00 | SPY | ETF | 456.56 | 457.38 | 456.56 | 457.11 | 39747.0 |
| 2022-02-10 07:30:00 | SPY | ETF | 457.16 | 457.25 | 457.01 | 457.13 | 57403.0 |
| 2022-02-10 08:00:00 | SPY | ETF | 457.17 | 457.883 | 456.3196 | 457.31 | 239180.0 |
| 2022-02-10 08:30:00 | SPY | ETF | 457.23 | 457.23 | 451.99 | 453.1 | 2383862.0 |
| 2022-02-10 09:00:00 | SPY | ETF | 453.1 | 453.1 | 450.86 | 451.32 | 980761.0 |
| 2022-02-10 09:30:00 | SPY | ETF | 451.34 | 455.55 | 451.29 | 455.17 | 11907106.0 |
| 2022-02-10 10:00:00 | SPY | ETF | 455.17 | 456.935 | 455.0 | 455.97 | 7957811.0 |
| 2022-02-10 10:30:00 | SPY | ETF | 455.99 | 457.71 | 455.1 | 455.51 | 6972772.0 |
| 2022-02-10 11:00:00 | SPY | ETF | 455.51 | 456.24 | 454.56 | 455.16 | 5238545.0 |
| 2022-02-10 11:30:00 | SPY | ETF | 455.13 | 456.34 | 454.27 | 456.21 | 3980856.0 |
| 2022-02-10 12:00:00 | SPY | ETF | 456.2 | 456.44 | 455.5101 | 456.17 | 2612700.0 |
| 2022-02-10 12:30:00 | SPY | ETF | 456.16 | 456.535 | 452.75 | 453.72 | 7923754.0 |
| 2022-02-10 13:00:00 | SPY | ETF | 453.68 | 454.38 | 451.5 | 451.51 | 6470918.0 |
| 2022-02-10 13:30:00 | SPY | ETF | 451.505 | 452.12 | 450.0 | 452.07 | 7127838.0 |
| 2022-02-10 14:00:00 | SPY | ETF | 452.06 | 452.22 | 449.47 | 450.72 | 6038405.0 |
| 2022-02-10 14:30:00 | SPY | ETF | 450.73 | 451.7 | 449.46 | 449.87 | 4428675.0 |
| 2022-02-10 15:00:00 | SPY | ETF | 449.86 | 451.15 | 449.12 | 449.805 | 6327363.0 |
| 2022-02-10 15:30:00 | SPY | ETF | 449.81 | 449.97 | 447.2 | 449.38 | 16490839.0 |
| 2022-02-10 16:00:00 | SPY | ETF | 449.39 | 449.44 | 448.04 | 448.53 | 4821177.0 |
| 2022-02-10 16:30:00 | SPY | ETF | 448.56 | 449.32 | 448.3 | 449.08 | 197413.0 |
| 2022-02-10 17:00:00 | SPY | ETF | 449.07 | 449.13 | 448.85 | 448.86 | 43305.0 |
| 2022-02-10 17:30:00 | SPY | ETF | 448.86 | 449.02 | 448.8 | 449.0 | 57533.0 |
| 2022-02-10 18:00:00 | SPY | ETF | 448.99 | 449.33 | 448.59 | 448.63 | 106102.0 |
| 2022-02-10 18:30:00 | SPY | ETF | 449.32 | 449.32 | 447.93 | 448.0 | 77980.0 |
| 2022-02-10 19:00:00 | SPY | ETF | 448.03 | 448.13 | 446.99 | 447.06 | 51393.0 |
| 2022-02-10 19:30:00 | SPY | ETF | 447.17 | 447.58 | 447.12 | 447.5 | 54769.0 |
| 2022-02-10 04:00:00 | QQQ | ETF | 365.2 | 365.44 | 364.99 | 365.21 | 38301.0 |
| 2022-02-10 04:30:00 | QQQ | ETF | 365.28 | 365.49 | 365.2 | 365.47 | 20385.0 |
| 2022-02-10 05:00:00 | QQQ | ETF | 365.38 | 365.56 | 365.32 | 365.5 | 6322.0 |
| 2022-02-10 05:30:00 | QQQ | ETF | 365.56 | 365.78 | 365.54 | 365.75 | 7297.0 |
| 2022-02-10 06:00:00 | QQQ | ETF | 365.79 | 365.83 | 365.44 | 365.8 | 13717.0 |
| 2022-02-10 06:30:00 | QQQ | ETF | 365.75 | 365.9 | 365.53 | 365.63 | 24992.0 |
| 2022-02-10 07:00:00 | QQQ | ETF | 365.64 | 366.39 | 365.62 | 366.2 | 88460.0 |
| 2022-02-10 07:30:00 | QQQ | ETF | 366.21 | 366.36 | 366.04 | 366.26 | 77051.0 |
| 2022-02-10 08:00:00 | QQQ | ETF | 365.8105 | 367.03 | 365.15 | 366.5 | 257416.0 |
| 2022-02-10 08:30:00 | QQQ | ETF | 366.37 | 366.37 | 360.83 | 361.0 | 3119382.0 |
| 2022-02-10 09:00:00 | QQQ | ETF | 360.9 | 360.96 | 359.0 | 359.51 | 1652964.0 |
| 2022-02-10 09:30:00 | QQQ | ETF | 359.52 | 364.15 | 359.32 | 363.57 | 12879732.0 |
| 2022-02-10 10:00:00 | QQQ | ETF | 363.58 | 365.55 | 363.22 | 364.55 | 7414716.0 |
| 2022-02-10 10:30:00 | QQQ | ETF | 364.57 | 366.4885 | 363.42 | 363.8699 | 6874338.0 |
| 2022-02-10 11:00:00 | QQQ | ETF | 363.85 | 364.56 | 362.83 | 363.45 | 5422396.0 |
| 2022-02-10 11:30:00 | QQQ | ETF | 363.44 | 364.86 | 362.1808 | 364.68 | 4625501.0 |
| 2022-02-10 12:00:00 | QQQ | ETF | 364.69 | 365.15 | 363.94 | 364.81 | 2665551.0 |
| 2022-02-10 12:30:00 | QQQ | ETF | 364.8 | 365.24 | 360.98 | 362.689 | 7307782.0 |
> showing 50 of 26,890 rows — these rows as CSV