PREVIEW / etf_30min / 2021-02-26
file: by_date/etf_30min/2021/2021-02-26.parquet size: 643 KB rows: 24,971
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 |
|---|---|---|---|---|---|---|---|
| 2021-02-26 04:00:00 | SPY | ETF | 384.1 | 384.1 | 383.19 | 383.58 | 31901.0 |
| 2021-02-26 04:30:00 | SPY | ETF | 383.13 | 383.99 | 382.94 | 383.25 | 23580.0 |
| 2021-02-26 05:00:00 | SPY | ETF | 383.37 | 383.54 | 382.58 | 383.2 | 30167.0 |
| 2021-02-26 05:30:00 | SPY | ETF | 383.3 | 383.69 | 382.39 | 382.46 | 21472.0 |
| 2021-02-26 06:00:00 | SPY | ETF | 382.2 | 382.81 | 381.65 | 381.67 | 20365.0 |
| 2021-02-26 06:30:00 | SPY | ETF | 381.77 | 381.77 | 380.52 | 381.42 | 75046.0 |
| 2021-02-26 07:00:00 | SPY | ETF | 381.48 | 383.18 | 381.45 | 382.7 | 251390.0 |
| 2021-02-26 07:30:00 | SPY | ETF | 382.88 | 383.52 | 382.05 | 382.12 | 357503.0 |
| 2021-02-26 08:00:00 | SPY | ETF | 382.15 | 384.5 | 380.4 | 382.48 | 321827.0 |
| 2021-02-26 08:30:00 | SPY | ETF | 382.42 | 384.22 | 382.37 | 384.19 | 595235.0 |
| 2021-02-26 09:00:00 | SPY | ETF | 384.15 | 384.54 | 383.72 | 384.4 | 499643.0 |
| 2021-02-26 09:30:00 | SPY | ETF | 384.36 | 384.88 | 381.91 | 382.07 | 14232265.0 |
| 2021-02-26 10:00:00 | SPY | ETF | 382.06 | 382.4 | 378.23 | 378.53 | 17902893.0 |
| 2021-02-26 10:30:00 | SPY | ETF | 378.49 | 382.95 | 378.49 | 382.37 | 12952635.0 |
| 2021-02-26 11:00:00 | SPY | ETF | 382.37 | 383.73 | 381.41 | 381.87 | 6508153.0 |
| 2021-02-26 11:30:00 | SPY | ETF | 381.87 | 384.23 | 381.74 | 383.51 | 4715286.0 |
| 2021-02-26 12:00:00 | SPY | ETF | 383.505 | 385.58 | 382.95 | 384.7 | 4305104.0 |
| 2021-02-26 12:30:00 | SPY | ETF | 384.7 | 385.22 | 383.44 | 383.58 | 3078157.0 |
| 2021-02-26 13:00:00 | SPY | ETF | 383.58 | 384.71 | 382.67 | 384.52 | 3653232.0 |
| 2021-02-26 13:30:00 | SPY | ETF | 384.53 | 384.67 | 381.9 | 382.19 | 5822573.0 |
| 2021-02-26 14:00:00 | SPY | ETF | 382.1905 | 382.89 | 381.02 | 381.815 | 7156344.0 |
| 2021-02-26 14:30:00 | SPY | ETF | 381.815 | 383.27 | 381.47 | 382.95 | 4906976.0 |
| 2021-02-26 15:00:00 | SPY | ETF | 382.94 | 384.41 | 382.47 | 382.523 | 5735110.0 |
| 2021-02-26 15:30:00 | SPY | ETF | 382.52 | 384.81 | 380.2 | 380.32 | 20495343.0 |
| 2021-02-26 16:00:00 | SPY | ETF | 380.32 | 380.9 | 378.83 | 379.94 | 8108089.0 |
| 2021-02-26 16:30:00 | SPY | ETF | 379.94 | 380.72 | 379.68 | 380.54 | 940298.0 |
| 2021-02-26 17:00:00 | SPY | ETF | 380.59 | 380.59 | 379.97 | 380.27 | 219776.0 |
| 2021-02-26 17:30:00 | SPY | ETF | 380.36 | 380.38 | 380.1 | 380.27 | 70677.0 |
| 2021-02-26 18:00:00 | SPY | ETF | 380.27 | 380.34 | 380.12 | 380.3 | 19773.0 |
| 2021-02-26 18:30:00 | SPY | ETF | 380.29 | 380.3 | 379.67 | 380.1 | 88533.0 |
| 2021-02-26 19:00:00 | SPY | ETF | 380.1 | 380.1 | 379.85 | 379.89 | 17567.0 |
| 2021-02-26 19:30:00 | SPY | ETF | 379.89 | 379.96 | 379.67 | 379.71 | 34203.0 |
| 2021-02-26 04:00:00 | QQQ | ETF | 314.27 | 314.33 | 313.08 | 313.22 | 200379.0 |
| 2021-02-26 04:30:00 | QQQ | ETF | 313.18 | 314.32 | 312.93 | 313.8 | 130042.0 |
| 2021-02-26 05:00:00 | QQQ | ETF | 313.6 | 313.6 | 312.25 | 312.86 | 68021.0 |
| 2021-02-26 05:30:00 | QQQ | ETF | 313.13 | 313.55 | 311.81 | 311.84 | 234689.0 |
| 2021-02-26 06:00:00 | QQQ | ETF | 311.77 | 312.71 | 311.64 | 311.77 | 40370.0 |
| 2021-02-26 06:30:00 | QQQ | ETF | 311.68 | 311.68 | 310.14 | 311.2 | 173864.0 |
| 2021-02-26 07:00:00 | QQQ | ETF | 311.23 | 313.59 | 311.19 | 313.06 | 639642.0 |
| 2021-02-26 07:30:00 | QQQ | ETF | 313.12 | 314.4 | 312.83 | 313.04 | 455451.0 |
| 2021-02-26 08:00:00 | QQQ | ETF | 313.08 | 314.6 | 308.91 | 313.72 | 1039600.0 |
| 2021-02-26 08:30:00 | QQQ | ETF | 313.83 | 316.19 | 313.69 | 315.93 | 1261349.0 |
| 2021-02-26 09:00:00 | QQQ | ETF | 315.9 | 316.46 | 314.9 | 315.81 | 744294.0 |
| 2021-02-26 09:30:00 | QQQ | ETF | 315.84 | 317.75 | 313.54 | 313.94 | 11081655.0 |
| 2021-02-26 10:00:00 | QQQ | ETF | 313.97 | 314.77 | 310.88 | 311.12 | 10797442.0 |
| 2021-02-26 10:30:00 | QQQ | ETF | 311.08 | 316.4 | 311.06 | 315.9599 | 8450563.0 |
| 2021-02-26 11:00:00 | QQQ | ETF | 315.94 | 316.91 | 314.43 | 315.3 | 5346423.0 |
| 2021-02-26 11:30:00 | QQQ | ETF | 315.33 | 317.605 | 315.15 | 317.3 | 3561798.0 |
| 2021-02-26 12:00:00 | QQQ | ETF | 317.29 | 319.11 | 316.33 | 318.055 | 4484812.0 |
| 2021-02-26 12:30:00 | QQQ | ETF | 318.08 | 318.7 | 316.62 | 316.86 | 3161407.0 |
> showing 50 of 24,971 rows — these rows as CSV