PREVIEW / etf_30min / 2008-09-30
file: by_date/etf_30min/2008/2008-09-30.parquet size: 183 KB rows: 6,417
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-30 04:00:00 | SPY | ETF | 114.0 | 114.87 | 113.02 | 114.44 | 21500.0 |
| 2008-09-30 04:30:00 | SPY | ETF | 114.41 | 114.45 | 114.41 | 114.45 | 1400.0 |
| 2008-09-30 05:00:00 | SPY | ETF | 114.5 | 114.5 | 114.5 | 114.5 | 100.0 |
| 2008-09-30 05:30:00 | SPY | ETF | 114.5 | 114.83 | 114.5 | 114.58 | 11400.0 |
| 2008-09-30 06:00:00 | SPY | ETF | 114.62 | 114.85 | 114.14 | 114.16 | 45000.0 |
| 2008-09-30 06:30:00 | SPY | ETF | 114.15 | 114.29 | 113.59 | 113.59 | 86190.0 |
| 2008-09-30 07:00:00 | SPY | ETF | 113.59 | 114.0 | 113.0 | 113.93 | 585770.0 |
| 2008-09-30 07:30:00 | SPY | ETF | 113.92 | 114.41 | 113.92 | 114.09 | 819098.0 |
| 2008-09-30 08:00:00 | SPY | ETF | 114.09 | 114.29 | 112.3 | 113.83 | 2470196.0 |
| 2008-09-30 08:30:00 | SPY | ETF | 113.85 | 114.04 | 113.43 | 113.57 | 2588244.0 |
| 2008-09-30 09:00:00 | SPY | ETF | 113.58 | 114.64 | 113.34 | 113.5 | 1579905.0 |
| 2008-09-30 09:30:00 | SPY | ETF | 113.51 | 113.76 | 112.71 | 113.11 | 27835756.0 |
| 2008-09-30 10:00:00 | SPY | ETF | 113.11 | 114.25 | 112.88 | 113.82 | 27588070.0 |
| 2008-09-30 10:30:00 | SPY | ETF | 113.83 | 114.55 | 113.72 | 113.73 | 18076948.0 |
| 2008-09-30 11:00:00 | SPY | ETF | 113.73 | 113.95 | 113.5 | 113.8 | 11641094.0 |
| 2008-09-30 11:30:00 | SPY | ETF | 113.79 | 114.68 | 113.75 | 114.5 | 11883002.0 |
| 2008-09-30 12:00:00 | SPY | ETF | 114.49 | 114.64 | 113.7 | 113.81 | 9839363.0 |
| 2008-09-30 12:30:00 | SPY | ETF | 113.81 | 114.5 | 113.71 | 114.49 | 14969231.0 |
| 2008-09-30 13:00:00 | SPY | ETF | 114.49 | 115.04 | 113.93 | 115.01 | 15978768.0 |
| 2008-09-30 13:30:00 | SPY | ETF | 115.01 | 115.45 | 114.92 | 115.12 | 22076341.0 |
| 2008-09-30 14:00:00 | SPY | ETF | 115.13 | 115.71 | 114.9 | 115.69 | 22020167.0 |
| 2008-09-30 14:30:00 | SPY | ETF | 115.69 | 115.87 | 115.31 | 115.53 | 19286347.0 |
| 2008-09-30 15:00:00 | SPY | ETF | 115.53 | 116.19 | 115.1 | 115.98 | 30699178.0 |
| 2008-09-30 15:30:00 | SPY | ETF | 115.98 | 116.8 | 115.59 | 116.7 | 51696889.0 |
| 2008-09-30 16:00:00 | SPY | ETF | 116.54 | 116.57 | 115.85 | 116.03 | 10861528.0 |
| 2008-09-30 16:30:00 | SPY | ETF | 116.03 | 116.2236 | 110.53 | 115.87 | 9336546.0 |
| 2008-09-30 17:00:00 | SPY | ETF | 115.9 | 116.03 | 110.53 | 115.91 | 7814718.0 |
| 2008-09-30 17:30:00 | SPY | ETF | 115.91 | 115.96 | 115.85 | 115.94 | 1023234.0 |
| 2008-09-30 18:00:00 | SPY | ETF | 115.94 | 116.04 | 115.88 | 115.95 | 353950.0 |
| 2008-09-30 18:30:00 | SPY | ETF | 116.0 | 116.0 | 115.7 | 115.75 | 41078.0 |
| 2008-09-30 19:00:00 | SPY | ETF | 115.79 | 116.3 | 115.78 | 116.22 | 38321.0 |
| 2008-09-30 19:30:00 | SPY | ETF | 116.16 | 116.46 | 116.04 | 116.19 | 78972.0 |
| 2008-09-30 04:00:00 | QQQ | ETF | 38.03 | 38.1 | 37.95 | 37.95 | 2100.0 |
| 2008-09-30 04:30:00 | QQQ | ETF | 37.92 | 37.92 | 37.83 | 37.83 | 5293.0 |
| 2008-09-30 05:00:00 | QQQ | ETF | 37.83 | 37.93 | 37.83 | 37.93 | 2000.0 |
| 2008-09-30 05:30:00 | QQQ | ETF | 37.96 | 38.06 | 37.93 | 37.93 | 2700.0 |
| 2008-09-30 06:00:00 | QQQ | ETF | 37.99 | 37.99 | 37.69 | 37.69 | 6200.0 |
| 2008-09-30 06:30:00 | QQQ | ETF | 37.57 | 37.62 | 37.57 | 37.57 | 4130.0 |
| 2008-09-30 07:00:00 | QQQ | ETF | 37.52 | 37.58 | 37.34 | 37.55 | 208510.0 |
| 2008-09-30 07:30:00 | QQQ | ETF | 37.55 | 37.82 | 37.55 | 37.67 | 624456.0 |
| 2008-09-30 08:00:00 | QQQ | ETF | 37.45 | 37.68 | 37.43 | 37.61 | 1557184.0 |
| 2008-09-30 08:30:00 | QQQ | ETF | 37.62 | 37.73 | 37.47 | 37.57 | 1164027.0 |
| 2008-09-30 09:00:00 | QQQ | ETF | 37.56 | 37.89 | 37.53 | 37.74 | 1434714.0 |
| 2008-09-30 09:30:00 | QQQ | ETF | 37.73 | 38.07 | 37.6 | 37.78 | 26385967.0 |
| 2008-09-30 10:00:00 | QQQ | ETF | 37.82 | 38.22 | 37.67 | 38.04 | 19030164.0 |
| 2008-09-30 10:30:00 | QQQ | ETF | 38.03 | 38.37 | 38.01 | 38.11 | 18282856.0 |
| 2008-09-30 11:00:00 | QQQ | ETF | 38.11 | 38.17 | 37.99 | 38.16 | 11131966.0 |
| 2008-09-30 11:30:00 | QQQ | ETF | 38.16 | 38.55 | 38.16 | 38.51 | 11922313.0 |
| 2008-09-30 12:00:00 | QQQ | ETF | 38.51 | 38.54 | 38.13 | 38.19 | 9914941.0 |
| 2008-09-30 12:30:00 | QQQ | ETF | 38.19 | 38.4595 | 38.17 | 38.45 | 5950451.0 |
> showing 50 of 6,417 rows — these rows as CSV