PREVIEW / etf_30min / 2021-02-12
file: by_date/etf_30min/2021/2021-02-12.parquet size: 625 KB rows: 23,369
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-12 04:00:00 | SPY | ETF | 389.3 | 389.68 | 389.3 | 389.67 | 15222.0 |
| 2021-02-12 04:30:00 | SPY | ETF | 389.66 | 389.91 | 389.6 | 389.69 | 24649.0 |
| 2021-02-12 05:00:00 | SPY | ETF | 389.94 | 390.0 | 389.83 | 389.96 | 4690.0 |
| 2021-02-12 05:30:00 | SPY | ETF | 389.99 | 390.04 | 389.89 | 390.04 | 3700.0 |
| 2021-02-12 06:00:00 | SPY | ETF | 390.03 | 390.03 | 389.7 | 389.7 | 14865.0 |
| 2021-02-12 06:30:00 | SPY | ETF | 389.74 | 390.03 | 389.73 | 389.99 | 23851.0 |
| 2021-02-12 07:00:00 | SPY | ETF | 390.04 | 390.36 | 389.97 | 390.06 | 41828.0 |
| 2021-02-12 07:30:00 | SPY | ETF | 390.1 | 390.35 | 389.99 | 390.13 | 46095.0 |
| 2021-02-12 08:00:00 | SPY | ETF | 390.2701 | 390.36 | 389.7 | 390.16 | 72599.0 |
| 2021-02-12 08:30:00 | SPY | ETF | 390.13 | 390.17 | 389.59 | 389.69 | 59046.0 |
| 2021-02-12 09:00:00 | SPY | ETF | 389.67 | 389.85 | 389.61 | 389.85 | 174153.0 |
| 2021-02-12 09:30:00 | SPY | ETF | 389.85 | 390.64 | 389.77 | 390.35 | 3238409.0 |
| 2021-02-12 10:00:00 | SPY | ETF | 390.32 | 390.74 | 390.27 | 390.495 | 1633163.0 |
| 2021-02-12 10:30:00 | SPY | ETF | 390.495 | 391.48 | 390.05 | 391.28 | 2300888.0 |
| 2021-02-12 11:00:00 | SPY | ETF | 391.2719 | 391.44 | 391.03 | 391.33 | 1347511.0 |
| 2021-02-12 11:30:00 | SPY | ETF | 391.33 | 391.63 | 391.22 | 391.37 | 1224259.0 |
| 2021-02-12 12:00:00 | SPY | ETF | 391.37 | 391.62 | 391.22 | 391.23 | 868280.0 |
| 2021-02-12 12:30:00 | SPY | ETF | 391.2313 | 391.29 | 390.965 | 391.185 | 1069092.0 |
| 2021-02-12 13:00:00 | SPY | ETF | 391.185 | 391.26 | 390.51 | 390.945 | 1608592.0 |
| 2021-02-12 13:30:00 | SPY | ETF | 390.945 | 391.22 | 390.65 | 390.85 | 927641.0 |
| 2021-02-12 14:00:00 | SPY | ETF | 390.8482 | 390.93 | 390.55 | 390.9143 | 1525826.0 |
| 2021-02-12 14:30:00 | SPY | ETF | 390.901 | 391.18 | 390.64 | 391.1 | 1112940.0 |
| 2021-02-12 15:00:00 | SPY | ETF | 391.1 | 391.44 | 391.03 | 391.41 | 1355208.0 |
| 2021-02-12 15:30:00 | SPY | ETF | 391.41 | 392.9 | 391.36 | 392.69 | 11987030.0 |
| 2021-02-12 16:00:00 | SPY | ETF | 392.7 | 393.12 | 392.606 | 393.11 | 3489603.0 |
| 2021-02-12 16:30:00 | SPY | ETF | 393.1 | 393.2 | 393.04 | 393.15 | 260699.0 |
| 2021-02-12 17:00:00 | SPY | ETF | 393.15 | 393.16 | 392.64 | 393.07 | 614602.0 |
| 2021-02-12 17:30:00 | SPY | ETF | 393.0601 | 393.11 | 393.01 | 393.01 | 143606.0 |
| 2021-02-12 18:00:00 | SPY | ETF | 393.01 | 393.1 | 392.73 | 392.96 | 113630.0 |
| 2021-02-12 18:30:00 | SPY | ETF | 392.93 | 393.1 | 392.93 | 393.08 | 1666.0 |
| 2021-02-12 19:00:00 | SPY | ETF | 393.1 | 393.1 | 392.98 | 393.03 | 5588.0 |
| 2021-02-12 19:30:00 | SPY | ETF | 393.03 | 393.2 | 392.99 | 393.1 | 13003.0 |
| 2021-02-12 04:00:00 | QQQ | ETF | 333.56 | 333.95 | 333.52 | 333.94 | 11252.0 |
| 2021-02-12 04:30:00 | QQQ | ETF | 333.92 | 334.08 | 333.9 | 334.04 | 4300.0 |
| 2021-02-12 05:00:00 | QQQ | ETF | 334.08 | 334.09 | 334.0 | 334.04 | 5448.0 |
| 2021-02-12 05:30:00 | QQQ | ETF | 334.12 | 334.17 | 334.05 | 334.1 | 6335.0 |
| 2021-02-12 06:00:00 | QQQ | ETF | 334.02 | 334.1 | 333.87 | 333.9 | 6550.0 |
| 2021-02-12 06:30:00 | QQQ | ETF | 333.97 | 334.07 | 333.96 | 334.04 | 4191.0 |
| 2021-02-12 07:00:00 | QQQ | ETF | 334.19 | 334.36 | 334.11 | 334.15 | 39318.0 |
| 2021-02-12 07:30:00 | QQQ | ETF | 334.16 | 334.33 | 334.06 | 334.19 | 49598.0 |
| 2021-02-12 08:00:00 | QQQ | ETF | 334.2 | 334.48 | 333.97 | 334.14 | 75941.0 |
| 2021-02-12 08:30:00 | QQQ | ETF | 334.11 | 334.15 | 333.56 | 333.63 | 67610.0 |
| 2021-02-12 09:00:00 | QQQ | ETF | 333.55 | 333.85 | 333.518 | 333.74 | 68798.0 |
| 2021-02-12 09:30:00 | QQQ | ETF | 333.76 | 334.07 | 332.63 | 333.79 | 2275907.0 |
| 2021-02-12 10:00:00 | QQQ | ETF | 333.76 | 334.17 | 333.45 | 333.63 | 829936.0 |
| 2021-02-12 10:30:00 | QQQ | ETF | 333.6301 | 334.81 | 333.09 | 334.509 | 1274898.0 |
| 2021-02-12 11:00:00 | QQQ | ETF | 334.52 | 335.07 | 334.39 | 335.004 | 953458.0 |
| 2021-02-12 11:30:00 | QQQ | ETF | 335.07 | 335.19 | 334.63 | 334.91 | 602328.0 |
| 2021-02-12 12:00:00 | QQQ | ETF | 334.94 | 335.28 | 334.83 | 334.92 | 630028.0 |
| 2021-02-12 12:30:00 | QQQ | ETF | 334.9207 | 335.09 | 334.62 | 334.955 | 606271.0 |
> showing 50 of 23,369 rows — these rows as CSV