PREVIEW / etf_30min / 2022-02-08
file: by_date/etf_30min/2022/2022-02-08.parquet size: 655 KB rows: 25,611
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-08 04:00:00 | SPY | ETF | 448.5 | 448.81 | 448.01 | 448.63 | 12291.0 |
| 2022-02-08 04:30:00 | SPY | ETF | 448.41 | 449.12 | 447.76 | 447.76 | 21248.0 |
| 2022-02-08 05:00:00 | SPY | ETF | 447.7 | 447.8 | 447.18 | 447.47 | 21529.0 |
| 2022-02-08 05:30:00 | SPY | ETF | 447.5 | 447.9 | 447.5 | 447.63 | 5588.0 |
| 2022-02-08 06:00:00 | SPY | ETF | 447.53 | 447.63 | 446.69 | 446.87 | 26265.0 |
| 2022-02-08 06:30:00 | SPY | ETF | 446.93 | 447.21 | 446.25 | 446.44 | 77410.0 |
| 2022-02-08 07:00:00 | SPY | ETF | 446.57 | 446.76 | 445.94 | 446.28 | 57948.0 |
| 2022-02-08 07:30:00 | SPY | ETF | 446.25 | 446.61 | 446.14 | 446.58 | 65777.0 |
| 2022-02-08 08:00:00 | SPY | ETF | 446.22 | 447.8996 | 446.0 | 446.82 | 157451.0 |
| 2022-02-08 08:30:00 | SPY | ETF | 446.938 | 447.5 | 446.38 | 446.86 | 315213.0 |
| 2022-02-08 09:00:00 | SPY | ETF | 446.8 | 447.03 | 446.46 | 446.66 | 372595.0 |
| 2022-02-08 09:30:00 | SPY | ETF | 446.73 | 447.47 | 446.06 | 446.43 | 6073203.0 |
| 2022-02-08 10:00:00 | SPY | ETF | 446.41 | 447.23 | 445.22 | 446.3 | 5010860.0 |
| 2022-02-08 10:30:00 | SPY | ETF | 446.32 | 448.31 | 445.82 | 447.9 | 4290077.0 |
| 2022-02-08 11:00:00 | SPY | ETF | 447.92 | 449.35 | 447.87 | 448.98 | 4371228.0 |
| 2022-02-08 11:30:00 | SPY | ETF | 449.01 | 450.26 | 449.01 | 450.07 | 3897952.0 |
| 2022-02-08 12:00:00 | SPY | ETF | 450.08 | 450.47 | 449.47 | 450.11 | 2663076.0 |
| 2022-02-08 12:30:00 | SPY | ETF | 450.12 | 451.27 | 450.12 | 450.6 | 3261698.0 |
| 2022-02-08 13:00:00 | SPY | ETF | 450.6 | 450.645 | 449.621 | 449.85 | 2850002.0 |
| 2022-02-08 13:30:00 | SPY | ETF | 449.85 | 450.53 | 449.64 | 450.3599 | 2593090.0 |
| 2022-02-08 14:00:00 | SPY | ETF | 450.36 | 450.83 | 448.79 | 448.92 | 2818948.0 |
| 2022-02-08 14:30:00 | SPY | ETF | 448.92 | 449.44 | 448.17 | 448.71 | 4371662.0 |
| 2022-02-08 15:00:00 | SPY | ETF | 448.71 | 450.8 | 448.09 | 450.17 | 4990668.0 |
| 2022-02-08 15:30:00 | SPY | ETF | 450.18 | 451.92 | 450.01 | 450.89 | 11063666.0 |
| 2022-02-08 16:00:00 | SPY | ETF | 450.89 | 451.68 | 450.67 | 451.34 | 4057125.0 |
| 2022-02-08 16:30:00 | SPY | ETF | 451.35 | 451.46 | 450.94 | 451.38 | 127786.0 |
| 2022-02-08 17:00:00 | SPY | ETF | 451.31 | 451.51 | 451.2 | 451.25 | 41612.0 |
| 2022-02-08 17:30:00 | SPY | ETF | 451.22 | 451.31 | 451.22 | 451.3 | 4898.0 |
| 2022-02-08 18:00:00 | SPY | ETF | 451.3 | 452.2 | 451.3 | 452.11 | 53773.0 |
| 2022-02-08 18:30:00 | SPY | ETF | 450.94 | 452.09 | 450.94 | 452.09 | 12937.0 |
| 2022-02-08 19:00:00 | SPY | ETF | 451.98 | 452.17 | 451.6 | 451.6 | 24041.0 |
| 2022-02-08 19:30:00 | SPY | ETF | 451.54 | 451.73 | 451.42 | 451.58 | 24641.0 |
| 2022-02-08 04:00:00 | QQQ | ETF | 355.65 | 356.21 | 355.65 | 355.78 | 34307.0 |
| 2022-02-08 04:30:00 | QQQ | ETF | 355.85 | 356.39 | 355.16 | 355.37 | 20239.0 |
| 2022-02-08 05:00:00 | QQQ | ETF | 355.2 | 355.2 | 354.64 | 355.15 | 43740.0 |
| 2022-02-08 05:30:00 | QQQ | ETF | 355.24 | 355.64 | 355.2 | 355.2 | 18496.0 |
| 2022-02-08 06:00:00 | QQQ | ETF | 354.93 | 355.53 | 354.46 | 354.59 | 32346.0 |
| 2022-02-08 06:30:00 | QQQ | ETF | 354.7 | 354.94 | 353.94 | 354.26 | 64235.0 |
| 2022-02-08 07:00:00 | QQQ | ETF | 354.36 | 354.38 | 353.21 | 353.67 | 170970.0 |
| 2022-02-08 07:30:00 | QQQ | ETF | 353.62 | 354.12 | 353.44 | 354.06 | 111583.0 |
| 2022-02-08 08:00:00 | QQQ | ETF | 354.1911 | 356.2104 | 353.3 | 354.22 | 245446.0 |
| 2022-02-08 08:30:00 | QQQ | ETF | 354.24 | 354.37 | 353.58 | 354.28 | 187909.0 |
| 2022-02-08 09:00:00 | QQQ | ETF | 354.3 | 354.4 | 353.79 | 353.96 | 249225.0 |
| 2022-02-08 09:30:00 | QQQ | ETF | 354.01 | 355.72 | 353.59 | 354.0999 | 6226576.0 |
| 2022-02-08 10:00:00 | QQQ | ETF | 354.08 | 354.93 | 352.8 | 353.62 | 4804778.0 |
| 2022-02-08 10:30:00 | QQQ | ETF | 353.65 | 356.63 | 352.9 | 356.15 | 3993275.0 |
| 2022-02-08 11:00:00 | QQQ | ETF | 356.14 | 357.96 | 356.1088 | 357.56 | 3289447.0 |
| 2022-02-08 11:30:00 | QQQ | ETF | 357.5788 | 358.52 | 357.51 | 358.14 | 2565874.0 |
| 2022-02-08 12:00:00 | QQQ | ETF | 358.19 | 358.73 | 357.42 | 358.4111 | 2178568.0 |
| 2022-02-08 12:30:00 | QQQ | ETF | 358.42 | 359.82 | 358.42 | 359.01 | 2468275.0 |
> showing 50 of 25,611 rows — these rows as CSV