PREVIEW / etf_30min / 2021-02-08
file: by_date/etf_30min/2021/2021-02-08.parquet size: 644 KB rows: 24,766
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-08 04:00:00 | SPY | ETF | 388.63 | 388.81 | 388.44 | 388.44 | 32555.0 |
| 2021-02-08 04:30:00 | SPY | ETF | 388.39 | 388.88 | 388.31 | 388.75 | 21323.0 |
| 2021-02-08 05:00:00 | SPY | ETF | 388.76 | 388.79 | 388.64 | 388.68 | 3385.0 |
| 2021-02-08 05:30:00 | SPY | ETF | 388.64 | 388.64 | 388.48 | 388.59 | 22095.0 |
| 2021-02-08 06:00:00 | SPY | ETF | 388.61 | 389.07 | 388.5 | 389.0 | 14735.0 |
| 2021-02-08 06:30:00 | SPY | ETF | 388.99 | 389.08 | 388.96 | 389.04 | 42774.0 |
| 2021-02-08 07:00:00 | SPY | ETF | 388.98 | 389.04 | 388.82 | 388.9 | 29121.0 |
| 2021-02-08 07:30:00 | SPY | ETF | 388.93 | 389.06 | 388.73 | 389.05 | 37290.0 |
| 2021-02-08 08:00:00 | SPY | ETF | 388.8699 | 389.5 | 388.56 | 389.2 | 56805.0 |
| 2021-02-08 08:30:00 | SPY | ETF | 389.16 | 389.28 | 389.05 | 389.2 | 66484.0 |
| 2021-02-08 09:00:00 | SPY | ETF | 389.23 | 389.46 | 389.18 | 389.3 | 100501.0 |
| 2021-02-08 09:30:00 | SPY | ETF | 389.27 | 389.82 | 389.1 | 389.63 | 3722853.0 |
| 2021-02-08 10:00:00 | SPY | ETF | 389.6399 | 389.87 | 389.24 | 389.525 | 2037800.0 |
| 2021-02-08 10:30:00 | SPY | ETF | 389.53 | 389.95 | 389.333 | 389.55 | 1861523.0 |
| 2021-02-08 11:00:00 | SPY | ETF | 389.55 | 389.6399 | 388.9 | 389.125 | 1675305.0 |
| 2021-02-08 11:30:00 | SPY | ETF | 389.127 | 389.18 | 388.35 | 388.891 | 2259743.0 |
| 2021-02-08 12:00:00 | SPY | ETF | 388.91 | 389.38 | 388.91 | 389.295 | 1247730.0 |
| 2021-02-08 12:30:00 | SPY | ETF | 389.2911 | 389.31 | 388.91 | 389.03 | 1038767.0 |
| 2021-02-08 13:00:00 | SPY | ETF | 389.03 | 389.17 | 388.82 | 389.04 | 980219.0 |
| 2021-02-08 13:30:00 | SPY | ETF | 389.045 | 389.31 | 388.59 | 388.8 | 1931228.0 |
| 2021-02-08 14:00:00 | SPY | ETF | 388.805 | 389.17 | 388.77 | 389.02 | 1186124.0 |
| 2021-02-08 14:30:00 | SPY | ETF | 389.015 | 389.35 | 388.82 | 389.33 | 999221.0 |
| 2021-02-08 15:00:00 | SPY | ETF | 389.32 | 389.55 | 389.24 | 389.53 | 1555458.0 |
| 2021-02-08 15:30:00 | SPY | ETF | 389.52 | 390.54 | 389.4 | 390.53 | 4868386.0 |
| 2021-02-08 16:00:00 | SPY | ETF | 390.545 | 390.62 | 390.29 | 390.41 | 2074942.0 |
| 2021-02-08 16:30:00 | SPY | ETF | 390.44 | 390.75 | 390.43 | 390.65 | 194600.0 |
| 2021-02-08 17:00:00 | SPY | ETF | 390.65 | 390.75 | 390.56 | 390.56 | 77470.0 |
| 2021-02-08 17:30:00 | SPY | ETF | 390.6 | 390.69 | 390.55 | 390.66 | 34392.0 |
| 2021-02-08 18:00:00 | SPY | ETF | 390.69 | 390.9 | 390.35 | 390.37 | 150675.0 |
| 2021-02-08 18:30:00 | SPY | ETF | 390.51 | 390.59 | 390.35 | 390.59 | 53649.0 |
| 2021-02-08 19:00:00 | SPY | ETF | 390.51 | 390.57 | 390.09 | 390.13 | 61733.0 |
| 2021-02-08 19:30:00 | SPY | ETF | 390.12 | 390.69 | 390.11 | 390.5 | 194465.0 |
| 2021-02-08 04:00:00 | QQQ | ETF | 332.53 | 332.67 | 332.33 | 332.35 | 19820.0 |
| 2021-02-08 04:30:00 | QQQ | ETF | 332.28 | 332.77 | 332.22 | 332.67 | 14062.0 |
| 2021-02-08 05:00:00 | QQQ | ETF | 332.63 | 332.72 | 332.6 | 332.7 | 5246.0 |
| 2021-02-08 05:30:00 | QQQ | ETF | 332.6 | 332.78 | 332.43 | 332.54 | 8922.0 |
| 2021-02-08 06:00:00 | QQQ | ETF | 332.51 | 332.92 | 332.46 | 332.84 | 9805.0 |
| 2021-02-08 06:30:00 | QQQ | ETF | 332.91 | 333.01 | 332.76 | 332.8 | 27039.0 |
| 2021-02-08 07:00:00 | QQQ | ETF | 332.79 | 332.81 | 332.28 | 332.34 | 54184.0 |
| 2021-02-08 07:30:00 | QQQ | ETF | 332.27 | 332.65 | 332.21 | 332.62 | 43564.0 |
| 2021-02-08 08:00:00 | QQQ | ETF | 332.81 | 333.4 | 331.36 | 332.88 | 92751.0 |
| 2021-02-08 08:30:00 | QQQ | ETF | 332.84 | 332.96 | 332.75 | 332.91 | 64274.0 |
| 2021-02-08 09:00:00 | QQQ | ETF | 332.9 | 333.28 | 332.86 | 333.13 | 94633.0 |
| 2021-02-08 09:30:00 | QQQ | ETF | 333.1 | 333.27 | 332.3 | 333.05 | 2647618.0 |
| 2021-02-08 10:00:00 | QQQ | ETF | 333.02 | 333.74 | 332.42 | 332.63 | 1574642.0 |
| 2021-02-08 10:30:00 | QQQ | ETF | 332.62 | 333.3 | 332.51 | 333.27 | 1145528.0 |
| 2021-02-08 11:00:00 | QQQ | ETF | 333.28 | 333.35 | 332.26 | 332.4372 | 886501.0 |
| 2021-02-08 11:30:00 | QQQ | ETF | 332.43 | 332.48 | 331.41 | 332.24 | 1236710.0 |
| 2021-02-08 12:00:00 | QQQ | ETF | 332.28 | 332.74 | 332.22 | 332.6113 | 663842.0 |
| 2021-02-08 12:30:00 | QQQ | ETF | 332.63 | 332.74 | 332.17 | 332.361 | 680178.0 |
> showing 50 of 24,766 rows — these rows as CSV