PREVIEW / etf_30min / 2022-02-15
file: by_date/etf_30min/2022/2022-02-15.parquet size: 662 KB rows: 26,129
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-15 04:00:00 | SPY | ETF | 443.9 | 444.95 | 441.4 | 444.5 | 90376.0 |
| 2022-02-15 04:30:00 | SPY | ETF | 444.5 | 444.67 | 444.2 | 444.3 | 25244.0 |
| 2022-02-15 05:00:00 | SPY | ETF | 444.6 | 445.3 | 443.63 | 444.11 | 73541.0 |
| 2022-02-15 05:30:00 | SPY | ETF | 444.25 | 445.1 | 444.11 | 444.81 | 80119.0 |
| 2022-02-15 06:00:00 | SPY | ETF | 445.05 | 445.69 | 445.05 | 445.11 | 61990.0 |
| 2022-02-15 06:30:00 | SPY | ETF | 445.14 | 446.01 | 445.13 | 445.49 | 139048.0 |
| 2022-02-15 07:00:00 | SPY | ETF | 445.35 | 446.3 | 444.89 | 446.0 | 464648.0 |
| 2022-02-15 07:30:00 | SPY | ETF | 445.99 | 446.0 | 445.26 | 445.77 | 346277.0 |
| 2022-02-15 08:00:00 | SPY | ETF | 445.79 | 446.28 | 437.94 | 445.23 | 399176.0 |
| 2022-02-15 08:30:00 | SPY | ETF | 445.12 | 445.16 | 443.93 | 444.01 | 565763.0 |
| 2022-02-15 09:00:00 | SPY | ETF | 444.05 | 444.45 | 443.45 | 443.74 | 388943.0 |
| 2022-02-15 09:30:00 | SPY | ETF | 443.73 | 445.78 | 443.45 | 444.03 | 8352013.0 |
| 2022-02-15 10:00:00 | SPY | ETF | 444.04 | 444.98 | 443.5 | 444.97 | 5208561.0 |
| 2022-02-15 10:30:00 | SPY | ETF | 444.97 | 445.92 | 444.61 | 445.52 | 4249725.0 |
| 2022-02-15 11:00:00 | SPY | ETF | 445.51 | 445.99 | 444.76 | 444.98 | 4324224.0 |
| 2022-02-15 11:30:00 | SPY | ETF | 444.99 | 445.9 | 444.9667 | 445.6 | 3083007.0 |
| 2022-02-15 12:00:00 | SPY | ETF | 445.61 | 445.91 | 443.85 | 444.34 | 3217258.0 |
| 2022-02-15 12:30:00 | SPY | ETF | 444.36 | 444.59 | 443.18 | 443.8618 | 3176608.0 |
| 2022-02-15 13:00:00 | SPY | ETF | 443.87 | 445.49 | 443.76 | 445.38 | 2805104.0 |
| 2022-02-15 13:30:00 | SPY | ETF | 445.38 | 445.6 | 445.13 | 445.49 | 2261486.0 |
| 2022-02-15 14:00:00 | SPY | ETF | 445.495 | 445.6 | 444.46 | 445.34 | 3329918.0 |
| 2022-02-15 14:30:00 | SPY | ETF | 445.34 | 445.73 | 444.65 | 445.35 | 3138269.0 |
| 2022-02-15 15:00:00 | SPY | ETF | 445.35 | 445.97 | 445.24 | 445.59 | 2973079.0 |
| 2022-02-15 15:30:00 | SPY | ETF | 445.6 | 446.28 | 443.86 | 446.07 | 16466571.0 |
| 2022-02-15 16:00:00 | SPY | ETF | 446.07 | 446.1 | 444.83 | 445.66 | 3994258.0 |
| 2022-02-15 16:30:00 | SPY | ETF | 445.67 | 446.1 | 445.01 | 445.37 | 271863.0 |
| 2022-02-15 17:00:00 | SPY | ETF | 445.45 | 445.45 | 445.1 | 445.11 | 89829.0 |
| 2022-02-15 17:30:00 | SPY | ETF | 446.1 | 446.1 | 445.1 | 445.42 | 49604.0 |
| 2022-02-15 18:00:00 | SPY | ETF | 445.4 | 445.54 | 445.01 | 445.01 | 87006.0 |
| 2022-02-15 18:30:00 | SPY | ETF | 445.12 | 445.35 | 444.75 | 444.85 | 42253.0 |
| 2022-02-15 19:00:00 | SPY | ETF | 444.85 | 444.99 | 444.66 | 444.68 | 53219.0 |
| 2022-02-15 19:30:00 | SPY | ETF | 444.73 | 444.8 | 444.62 | 444.69 | 29242.0 |
| 2022-02-15 04:00:00 | QQQ | ETF | 349.95 | 354.37 | 349.95 | 353.73 | 136826.0 |
| 2022-02-15 04:30:00 | QQQ | ETF | 353.75 | 353.89 | 353.32 | 353.63 | 40943.0 |
| 2022-02-15 05:00:00 | QQQ | ETF | 353.75 | 354.59 | 353.35 | 353.69 | 79460.0 |
| 2022-02-15 05:30:00 | QQQ | ETF | 353.67 | 354.5 | 353.59 | 354.17 | 56183.0 |
| 2022-02-15 06:00:00 | QQQ | ETF | 354.01 | 354.7 | 353.99 | 354.26 | 101347.0 |
| 2022-02-15 06:30:00 | QQQ | ETF | 354.4 | 355.32 | 354.33 | 354.77 | 159810.0 |
| 2022-02-15 07:00:00 | QQQ | ETF | 354.75 | 355.32 | 354.32 | 355.05 | 269900.0 |
| 2022-02-15 07:30:00 | QQQ | ETF | 355.0 | 355.02 | 354.39 | 354.75 | 242867.0 |
| 2022-02-15 08:00:00 | QQQ | ETF | 354.86 | 355.3396 | 347.24 | 354.03 | 391880.0 |
| 2022-02-15 08:30:00 | QQQ | ETF | 354.03 | 354.05 | 352.65 | 352.89 | 647025.0 |
| 2022-02-15 09:00:00 | QQQ | ETF | 352.85 | 353.64 | 352.65 | 352.81 | 408909.0 |
| 2022-02-15 09:30:00 | QQQ | ETF | 352.91 | 354.07 | 352.22 | 353.599 | 6183851.0 |
| 2022-02-15 10:00:00 | QQQ | ETF | 353.6333 | 354.06 | 352.392 | 353.52 | 3890947.0 |
| 2022-02-15 10:30:00 | QQQ | ETF | 353.53 | 354.7 | 352.96 | 354.09 | 3404111.0 |
| 2022-02-15 11:00:00 | QQQ | ETF | 354.11 | 354.73 | 353.82 | 354.055 | 2946739.0 |
| 2022-02-15 11:30:00 | QQQ | ETF | 354.05 | 355.0974 | 354.05 | 354.77 | 2513376.0 |
| 2022-02-15 12:00:00 | QQQ | ETF | 354.78 | 355.01 | 352.53 | 353.0314 | 2818945.0 |
| 2022-02-15 12:30:00 | QQQ | ETF | 353.03 | 353.25 | 351.82 | 352.79 | 2644760.0 |
> showing 50 of 26,129 rows — these rows as CSV