PREVIEW / etf_30min / 2021-02-11
file: by_date/etf_30min/2021/2021-02-11.parquet size: 627 KB rows: 23,654
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-11 04:00:00 | SPY | ETF | 391.04 | 391.26 | 390.9 | 391.26 | 15760.0 |
| 2021-02-11 04:30:00 | SPY | ETF | 391.09 | 391.27 | 391.07 | 391.22 | 32427.0 |
| 2021-02-11 05:00:00 | SPY | ETF | 391.2 | 391.32 | 391.0 | 391.03 | 9256.0 |
| 2021-02-11 05:30:00 | SPY | ETF | 391.04 | 391.2 | 391.03 | 391.2 | 9548.0 |
| 2021-02-11 06:00:00 | SPY | ETF | 391.12 | 391.44 | 391.08 | 391.38 | 33824.0 |
| 2021-02-11 06:30:00 | SPY | ETF | 391.3 | 391.3 | 391.0 | 391.09 | 38008.0 |
| 2021-02-11 07:00:00 | SPY | ETF | 391.07 | 391.16 | 390.93 | 391.11 | 42764.0 |
| 2021-02-11 07:30:00 | SPY | ETF | 391.15 | 391.2 | 390.9 | 390.99 | 38462.0 |
| 2021-02-11 08:00:00 | SPY | ETF | 391.1 | 391.47 | 390.28 | 391.35 | 84830.0 |
| 2021-02-11 08:30:00 | SPY | ETF | 391.3 | 391.44 | 391.11 | 391.13 | 91091.0 |
| 2021-02-11 09:00:00 | SPY | ETF | 391.17 | 391.41 | 391.05 | 391.27 | 212499.0 |
| 2021-02-11 09:30:00 | SPY | ETF | 391.25 | 391.69 | 390.36 | 390.42 | 3742588.0 |
| 2021-02-11 10:00:00 | SPY | ETF | 390.44 | 391.21 | 390.3201 | 391.0119 | 1838192.0 |
| 2021-02-11 10:30:00 | SPY | ETF | 391.02 | 391.37 | 390.38 | 390.62 | 2009510.0 |
| 2021-02-11 11:00:00 | SPY | ETF | 390.62 | 390.79 | 390.15 | 390.635 | 1824162.0 |
| 2021-02-11 11:30:00 | SPY | ETF | 390.63 | 390.94 | 390.3227 | 390.51 | 1077239.0 |
| 2021-02-11 12:00:00 | SPY | ETF | 390.515 | 390.7099 | 388.66 | 388.697 | 2872555.0 |
| 2021-02-11 12:30:00 | SPY | ETF | 388.68 | 389.45 | 388.1 | 389.335 | 3529321.0 |
| 2021-02-11 13:00:00 | SPY | ETF | 389.3313 | 389.8715 | 388.7 | 389.7 | 1891201.0 |
| 2021-02-11 13:30:00 | SPY | ETF | 389.7044 | 389.99 | 389.46 | 389.51 | 1004376.0 |
| 2021-02-11 14:00:00 | SPY | ETF | 389.51 | 389.51 | 388.79 | 389.34 | 1774607.0 |
| 2021-02-11 14:30:00 | SPY | ETF | 389.33 | 389.84 | 389.01 | 389.7887 | 1428551.0 |
| 2021-02-11 15:00:00 | SPY | ETF | 389.78 | 390.47 | 389.66 | 390.13 | 2425238.0 |
| 2021-02-11 15:30:00 | SPY | ETF | 390.14 | 390.98 | 389.9 | 390.73 | 5765077.0 |
| 2021-02-11 16:00:00 | SPY | ETF | 390.72 | 390.76 | 390.26 | 390.55 | 1931561.0 |
| 2021-02-11 16:30:00 | SPY | ETF | 390.55 | 390.71 | 390.2 | 390.27 | 238734.0 |
| 2021-02-11 17:00:00 | SPY | ETF | 390.38 | 390.45 | 390.21 | 390.21 | 37263.0 |
| 2021-02-11 17:30:00 | SPY | ETF | 390.21 | 390.21 | 390.03 | 390.11 | 154181.0 |
| 2021-02-11 18:00:00 | SPY | ETF | 390.15 | 390.45 | 389.98 | 390.34 | 126395.0 |
| 2021-02-11 18:30:00 | SPY | ETF | 390.71 | 390.71 | 390.3 | 390.7 | 49848.0 |
| 2021-02-11 19:00:00 | SPY | ETF | 390.71 | 390.98 | 390.57 | 390.58 | 53803.0 |
| 2021-02-11 19:30:00 | SPY | ETF | 390.56 | 390.7 | 390.31 | 390.45 | 34081.0 |
| 2021-02-11 04:00:00 | QQQ | ETF | 333.74 | 334.03 | 333.68 | 333.92 | 16591.0 |
| 2021-02-11 04:30:00 | QQQ | ETF | 333.9 | 334.16 | 333.89 | 334.1 | 12382.0 |
| 2021-02-11 05:00:00 | QQQ | ETF | 334.1 | 334.33 | 334.06 | 334.06 | 10833.0 |
| 2021-02-11 05:30:00 | QQQ | ETF | 334.08 | 334.19 | 334.0 | 334.08 | 4000.0 |
| 2021-02-11 06:00:00 | QQQ | ETF | 334.05 | 334.42 | 334.03 | 334.3 | 9369.0 |
| 2021-02-11 06:30:00 | QQQ | ETF | 334.18 | 334.22 | 334.05 | 334.05 | 9587.0 |
| 2021-02-11 07:00:00 | QQQ | ETF | 334.0 | 334.12 | 333.83 | 334.0 | 38870.0 |
| 2021-02-11 07:30:00 | QQQ | ETF | 334.01 | 334.16 | 333.98 | 334.16 | 36127.0 |
| 2021-02-11 08:00:00 | QQQ | ETF | 334.2 | 334.49 | 333.12 | 334.4 | 83303.0 |
| 2021-02-11 08:30:00 | QQQ | ETF | 334.4 | 334.45 | 334.17 | 334.22 | 71034.0 |
| 2021-02-11 09:00:00 | QQQ | ETF | 334.22 | 334.5 | 334.12 | 334.36 | 58920.0 |
| 2021-02-11 09:30:00 | QQQ | ETF | 334.33 | 334.87 | 333.52 | 333.61 | 2374882.0 |
| 2021-02-11 10:00:00 | QQQ | ETF | 333.62 | 334.38 | 333.54 | 334.05 | 1128490.0 |
| 2021-02-11 10:30:00 | QQQ | ETF | 334.095 | 335.0 | 333.55 | 334.152 | 1920661.0 |
| 2021-02-11 11:00:00 | QQQ | ETF | 334.15 | 334.63 | 333.8 | 334.48 | 920202.0 |
| 2021-02-11 11:30:00 | QQQ | ETF | 334.471 | 334.941 | 334.21 | 334.4728 | 860194.0 |
| 2021-02-11 12:00:00 | QQQ | ETF | 334.4857 | 334.8 | 332.63 | 332.7025 | 1478686.0 |
| 2021-02-11 12:30:00 | QQQ | ETF | 332.71 | 333.5999 | 332.12 | 333.57 | 2140233.0 |
> showing 50 of 23,654 rows — these rows as CSV