PREVIEW / etf_30min / 2021-02-04
file: by_date/etf_30min/2021/2021-02-04.parquet size: 625 KB rows: 23,590
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-04 04:00:00 | SPY | ETF | 382.7 | 382.75 | 382.4 | 382.54 | 142816.0 |
| 2021-02-04 04:30:00 | SPY | ETF | 382.54 | 382.59 | 382.35 | 382.35 | 3300.0 |
| 2021-02-04 05:00:00 | SPY | ETF | 382.33 | 382.57 | 382.31 | 382.57 | 5100.0 |
| 2021-02-04 05:30:00 | SPY | ETF | 382.58 | 382.67 | 382.53 | 382.62 | 7380.0 |
| 2021-02-04 06:00:00 | SPY | ETF | 382.63 | 382.78 | 382.6 | 382.6 | 7469.0 |
| 2021-02-04 06:30:00 | SPY | ETF | 382.57 | 382.61 | 381.83 | 381.88 | 78458.0 |
| 2021-02-04 07:00:00 | SPY | ETF | 381.88 | 382.56 | 381.88 | 382.32 | 206280.0 |
| 2021-02-04 07:30:00 | SPY | ETF | 382.32 | 382.77 | 382.27 | 382.77 | 46638.0 |
| 2021-02-04 08:00:00 | SPY | ETF | 382.15 | 382.98 | 381.4 | 382.89 | 166304.0 |
| 2021-02-04 08:30:00 | SPY | ETF | 382.91 | 383.12 | 382.74 | 382.92 | 122272.0 |
| 2021-02-04 09:00:00 | SPY | ETF | 382.89 | 383.07 | 382.7 | 382.97 | 112553.0 |
| 2021-02-04 09:30:00 | SPY | ETF | 382.96 | 383.92 | 382.78 | 383.9011 | 4322144.0 |
| 2021-02-04 10:00:00 | SPY | ETF | 383.9 | 384.43 | 383.55 | 383.76 | 4072886.0 |
| 2021-02-04 10:30:00 | SPY | ETF | 383.76 | 384.41 | 383.63 | 384.275 | 2152436.0 |
| 2021-02-04 11:00:00 | SPY | ETF | 384.27 | 384.75 | 384.18 | 384.52 | 1661592.0 |
| 2021-02-04 11:30:00 | SPY | ETF | 384.52 | 384.78 | 384.3 | 384.5819 | 1143057.0 |
| 2021-02-04 12:00:00 | SPY | ETF | 384.58 | 384.92 | 384.57 | 384.765 | 1060219.0 |
| 2021-02-04 12:30:00 | SPY | ETF | 384.7697 | 385.01 | 384.61 | 384.75 | 1185932.0 |
| 2021-02-04 13:00:00 | SPY | ETF | 384.76 | 385.23 | 384.71 | 385.12 | 1188625.0 |
| 2021-02-04 13:30:00 | SPY | ETF | 385.125 | 385.35 | 385.12 | 385.19 | 990721.0 |
| 2021-02-04 14:00:00 | SPY | ETF | 385.2 | 385.43 | 385.07 | 385.2 | 1438645.0 |
| 2021-02-04 14:30:00 | SPY | ETF | 385.2 | 385.46 | 385.12 | 385.335 | 2235557.0 |
| 2021-02-04 15:00:00 | SPY | ETF | 385.325 | 385.36 | 384.97 | 385.11 | 1874465.0 |
| 2021-02-04 15:30:00 | SPY | ETF | 385.115 | 386.24 | 384.97 | 386.17 | 6520262.0 |
| 2021-02-04 16:00:00 | SPY | ETF | 386.16 | 386.5 | 386.0 | 386.44 | 3698016.0 |
| 2021-02-04 16:30:00 | SPY | ETF | 386.44 | 386.58 | 386.17 | 386.31 | 290137.0 |
| 2021-02-04 17:00:00 | SPY | ETF | 386.3 | 386.43 | 386.19 | 386.4 | 64633.0 |
| 2021-02-04 17:30:00 | SPY | ETF | 386.28 | 386.28 | 386.0 | 386.09 | 152311.0 |
| 2021-02-04 18:00:00 | SPY | ETF | 386.1 | 386.34 | 386.06 | 386.08 | 115393.0 |
| 2021-02-04 18:30:00 | SPY | ETF | 386.19 | 386.32 | 385.91 | 386.27 | 31044.0 |
| 2021-02-04 19:00:00 | SPY | ETF | 386.21 | 386.36 | 386.04 | 386.06 | 21822.0 |
| 2021-02-04 19:30:00 | SPY | ETF | 386.11 | 386.11 | 385.8 | 385.97 | 51251.0 |
| 2021-02-04 04:00:00 | QQQ | ETF | 327.72 | 327.77 | 327.5 | 327.61 | 35387.0 |
| 2021-02-04 04:30:00 | QQQ | ETF | 327.63 | 327.76 | 327.57 | 327.6 | 17312.0 |
| 2021-02-04 05:00:00 | QQQ | ETF | 327.57 | 327.71 | 327.46 | 327.71 | 6196.0 |
| 2021-02-04 05:30:00 | QQQ | ETF | 327.7 | 327.92 | 327.67 | 327.8 | 10721.0 |
| 2021-02-04 06:00:00 | QQQ | ETF | 327.74 | 327.86 | 327.72 | 327.8 | 7182.0 |
| 2021-02-04 06:30:00 | QQQ | ETF | 327.78 | 327.81 | 327.12 | 327.23 | 94187.0 |
| 2021-02-04 07:00:00 | QQQ | ETF | 327.38 | 327.93 | 327.35 | 327.46 | 126185.0 |
| 2021-02-04 07:30:00 | QQQ | ETF | 327.46 | 327.83 | 327.46 | 327.83 | 40745.0 |
| 2021-02-04 08:00:00 | QQQ | ETF | 327.4899 | 328.17 | 325.89 | 328.0 | 114813.0 |
| 2021-02-04 08:30:00 | QQQ | ETF | 327.95 | 328.16 | 327.66 | 327.89 | 75881.0 |
| 2021-02-04 09:00:00 | QQQ | ETF | 327.89 | 328.08 | 327.4 | 327.85 | 165787.0 |
| 2021-02-04 09:30:00 | QQQ | ETF | 327.84 | 328.605 | 326.98 | 327.53 | 3409709.0 |
| 2021-02-04 10:00:00 | QQQ | ETF | 327.53 | 327.94 | 326.46 | 327.01 | 2214086.0 |
| 2021-02-04 10:30:00 | QQQ | ETF | 326.9901 | 327.78 | 326.74 | 327.49 | 1794571.0 |
| 2021-02-04 11:00:00 | QQQ | ETF | 327.49 | 327.9514 | 327.2 | 327.7369 | 973621.0 |
| 2021-02-04 11:30:00 | QQQ | ETF | 327.745 | 328.205 | 327.49 | 328.02 | 833444.0 |
| 2021-02-04 12:00:00 | QQQ | ETF | 328.04 | 328.55 | 328.02 | 328.31 | 729673.0 |
| 2021-02-04 12:30:00 | QQQ | ETF | 328.32 | 328.71 | 328.31 | 328.59 | 721265.0 |
> showing 50 of 23,590 rows — these rows as CSV