PREVIEW / etf_30min / 2022-04-11
file: by_date/etf_30min/2022/2022-04-11.parquet size: 670 KB rows: 26,717
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-04-11 04:00:00 | SPY | ETF | 446.71 | 446.71 | 444.25 | 444.43 | 44952.0 |
| 2022-04-11 04:30:00 | SPY | ETF | 444.38 | 444.98 | 444.22 | 444.72 | 11042.0 |
| 2022-04-11 05:00:00 | SPY | ETF | 444.72 | 445.27 | 444.69 | 445.17 | 8535.0 |
| 2022-04-11 05:30:00 | SPY | ETF | 445.1 | 446.0 | 445.04 | 445.86 | 24171.0 |
| 2022-04-11 06:00:00 | SPY | ETF | 445.93 | 446.33 | 445.68 | 445.73 | 14665.0 |
| 2022-04-11 06:30:00 | SPY | ETF | 445.82 | 446.03 | 445.17 | 446.03 | 20735.0 |
| 2022-04-11 07:00:00 | SPY | ETF | 446.07 | 446.18 | 445.33 | 445.56 | 29625.0 |
| 2022-04-11 07:30:00 | SPY | ETF | 445.53 | 445.53 | 444.43 | 444.45 | 133683.0 |
| 2022-04-11 08:00:00 | SPY | ETF | 445.7501 | 446.92 | 443.7 | 443.86 | 173399.0 |
| 2022-04-11 08:30:00 | SPY | ETF | 443.98 | 444.45 | 443.76 | 444.23 | 226649.0 |
| 2022-04-11 09:00:00 | SPY | ETF | 444.22 | 444.59 | 444.02 | 444.14 | 268543.0 |
| 2022-04-11 09:30:00 | SPY | ETF | 444.11 | 445.0 | 442.89 | 444.1 | 8874748.0 |
| 2022-04-11 10:00:00 | SPY | ETF | 444.06 | 444.49 | 442.405 | 442.765 | 5523465.0 |
| 2022-04-11 10:30:00 | SPY | ETF | 442.765 | 442.83 | 441.98 | 442.35 | 3980195.0 |
| 2022-04-11 11:00:00 | SPY | ETF | 442.32 | 442.64 | 441.605 | 442.0 | 3110073.0 |
| 2022-04-11 11:30:00 | SPY | ETF | 442.0 | 442.75 | 441.85 | 442.1507 | 2995606.0 |
| 2022-04-11 12:00:00 | SPY | ETF | 442.15 | 442.34 | 441.73 | 441.735 | 1907380.0 |
| 2022-04-11 12:30:00 | SPY | ETF | 441.72 | 442.03 | 441.35 | 441.85 | 3076532.0 |
| 2022-04-11 13:00:00 | SPY | ETF | 441.82 | 442.57 | 441.43 | 441.73 | 3143635.0 |
| 2022-04-11 13:30:00 | SPY | ETF | 441.72 | 442.31 | 441.61 | 442.1891 | 1828599.0 |
| 2022-04-11 14:00:00 | SPY | ETF | 442.18 | 442.58 | 441.31 | 441.545 | 3053873.0 |
| 2022-04-11 14:30:00 | SPY | ETF | 441.53 | 442.79 | 441.18 | 442.44 | 3396484.0 |
| 2022-04-11 15:00:00 | SPY | ETF | 442.46 | 443.0 | 440.86 | 440.96 | 3927861.0 |
| 2022-04-11 15:30:00 | SPY | ETF | 440.95 | 441.02 | 439.39 | 439.97 | 14964250.0 |
| 2022-04-11 16:00:00 | SPY | ETF | 439.96 | 440.17 | 439.6 | 439.71 | 5737812.0 |
| 2022-04-11 16:30:00 | SPY | ETF | 439.7 | 440.04 | 439.6 | 440.02 | 605980.0 |
| 2022-04-11 17:00:00 | SPY | ETF | 440.02 | 440.12 | 439.91 | 440.1 | 134894.0 |
| 2022-04-11 17:30:00 | SPY | ETF | 440.02 | 440.1 | 439.95 | 440.059 | 41900.0 |
| 2022-04-11 18:00:00 | SPY | ETF | 440.09 | 440.32 | 440.07 | 440.21 | 57743.0 |
| 2022-04-11 18:30:00 | SPY | ETF | 440.24 | 440.39 | 440.2 | 440.36 | 44377.0 |
| 2022-04-11 19:00:00 | SPY | ETF | 440.36 | 440.36 | 439.78 | 439.9 | 31863.0 |
| 2022-04-11 19:30:00 | SPY | ETF | 439.88 | 440.0 | 439.45 | 439.66 | 48525.0 |
| 2022-04-11 20:00:00 | SPY | ETF | 439.67 | 439.67 | 439.67 | 439.67 | 600.0 |
| 2022-04-11 04:00:00 | QQQ | ETF | 348.0 | 348.0 | 344.81 | 345.26 | 150654.0 |
| 2022-04-11 04:30:00 | QQQ | ETF | 345.24 | 345.66 | 344.96 | 345.28 | 46124.0 |
| 2022-04-11 05:00:00 | QQQ | ETF | 345.25 | 345.75 | 345.11 | 345.75 | 64630.0 |
| 2022-04-11 05:30:00 | QQQ | ETF | 345.58 | 346.37 | 345.33 | 346.25 | 107773.0 |
| 2022-04-11 06:00:00 | QQQ | ETF | 346.23 | 346.79 | 345.93 | 346.03 | 74584.0 |
| 2022-04-11 06:30:00 | QQQ | ETF | 346.21 | 346.53 | 345.4 | 346.53 | 55997.0 |
| 2022-04-11 07:00:00 | QQQ | ETF | 346.59 | 346.76 | 345.77 | 346.1 | 138983.0 |
| 2022-04-11 07:30:00 | QQQ | ETF | 346.03 | 346.03 | 345.17 | 345.2 | 190327.0 |
| 2022-04-11 08:00:00 | QQQ | ETF | 346.55 | 349.411 | 344.11 | 344.32 | 510520.0 |
| 2022-04-11 08:30:00 | QQQ | ETF | 344.36 | 345.164 | 344.19 | 344.8 | 461871.0 |
| 2022-04-11 09:00:00 | QQQ | ETF | 344.76 | 345.14 | 344.55 | 344.79 | 348232.0 |
| 2022-04-11 09:30:00 | QQQ | ETF | 344.81 | 345.75 | 343.375 | 344.35 | 7135723.0 |
| 2022-04-11 10:00:00 | QQQ | ETF | 344.33 | 345.5 | 342.4696 | 342.89 | 4860144.0 |
| 2022-04-11 10:30:00 | QQQ | ETF | 342.89 | 343.79 | 341.78 | 342.15 | 4327260.0 |
| 2022-04-11 11:00:00 | QQQ | ETF | 342.13 | 342.73 | 341.89 | 342.39 | 2093614.0 |
| 2022-04-11 11:30:00 | QQQ | ETF | 342.39 | 343.33 | 342.28 | 342.73 | 2698021.0 |
| 2022-04-11 12:00:00 | QQQ | ETF | 342.73 | 342.83 | 342.09 | 342.16 | 1471653.0 |
> showing 50 of 26,717 rows — these rows as CSV