PREVIEW / etf_30min / 2008-10-13
file: by_date/etf_30min/2008/2008-10-13.parquet size: 189 KB rows: 6,736
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-10-13 04:00:00 | SPY | ETF | 94.13 | 94.48 | 94.08 | 94.33 | 14770.0 |
| 2008-10-13 04:30:00 | SPY | ETF | 94.25 | 94.25 | 93.97 | 94.05 | 1200.0 |
| 2008-10-13 05:00:00 | SPY | ETF | 93.88 | 93.88 | 93.2 | 93.2 | 4200.0 |
| 2008-10-13 05:30:00 | SPY | ETF | 93.2 | 93.45 | 93.2 | 93.45 | 5200.0 |
| 2008-10-13 06:00:00 | SPY | ETF | 93.6 | 93.95 | 93.55 | 93.95 | 31700.0 |
| 2008-10-13 06:30:00 | SPY | ETF | 93.71 | 93.85 | 93.25 | 93.3 | 324500.0 |
| 2008-10-13 07:00:00 | SPY | ETF | 93.31 | 93.4 | 92.65 | 92.9 | 651215.0 |
| 2008-10-13 07:30:00 | SPY | ETF | 92.95 | 93.39 | 92.85 | 92.93 | 1140819.0 |
| 2008-10-13 08:00:00 | SPY | ETF | 93.75 | 93.8 | 92.3 | 92.95 | 2771516.0 |
| 2008-10-13 08:30:00 | SPY | ETF | 92.96 | 93.55 | 91.65 | 93.44 | 2193926.0 |
| 2008-10-13 09:00:00 | SPY | ETF | 93.42 | 94.04 | 93.23 | 93.87 | 3389098.0 |
| 2008-10-13 09:30:00 | SPY | ETF | 93.87 | 94.67 | 93.38 | 93.8 | 60395563.0 |
| 2008-10-13 10:00:00 | SPY | ETF | 93.8 | 94.98 | 93.17 | 94.82 | 36649804.0 |
| 2008-10-13 10:30:00 | SPY | ETF | 94.82 | 95.26 | 89.9484 | 94.86 | 27085867.0 |
| 2008-10-13 11:00:00 | SPY | ETF | 94.86 | 95.37 | 94.72 | 95.13 | 23900868.0 |
| 2008-10-13 11:30:00 | SPY | ETF | 95.13 | 95.71 | 95.11 | 95.33 | 20624150.0 |
| 2008-10-13 12:00:00 | SPY | ETF | 95.33 | 96.29 | 95.1 | 96.18 | 17828203.0 |
| 2008-10-13 12:30:00 | SPY | ETF | 96.17 | 96.53 | 96.05 | 96.28 | 16239120.0 |
| 2008-10-13 13:00:00 | SPY | ETF | 96.26 | 96.5 | 96.21 | 96.38 | 11112056.0 |
| 2008-10-13 13:30:00 | SPY | ETF | 96.37 | 96.55 | 95.74 | 95.78 | 22236797.0 |
| 2008-10-13 14:00:00 | SPY | ETF | 95.78 | 95.95 | 95.15 | 95.17 | 23547338.0 |
| 2008-10-13 14:30:00 | SPY | ETF | 95.17 | 96.83 | 95.09 | 96.71 | 26078422.0 |
| 2008-10-13 15:00:00 | SPY | ETF | 96.71 | 98.0 | 96.67 | 97.73 | 40559937.0 |
| 2008-10-13 15:30:00 | SPY | ETF | 97.74 | 101.01 | 97.5 | 100.86 | 73008289.0 |
| 2008-10-13 16:00:00 | SPY | ETF | 100.7 | 101.35 | 96.25 | 100.92 | 24882476.0 |
| 2008-10-13 16:30:00 | SPY | ETF | 100.9 | 101.35 | 89.9484 | 101.0 | 7523385.0 |
| 2008-10-13 17:00:00 | SPY | ETF | 101.0 | 101.02 | 100.67 | 100.77 | 4819697.0 |
| 2008-10-13 17:30:00 | SPY | ETF | 100.73 | 101.47 | 89.9479 | 101.2 | 4418947.0 |
| 2008-10-13 18:00:00 | SPY | ETF | 101.2 | 101.34 | 100.93 | 101.29 | 458457.0 |
| 2008-10-13 18:30:00 | SPY | ETF | 101.32 | 101.49 | 101.23 | 101.48 | 911804.0 |
| 2008-10-13 19:00:00 | SPY | ETF | 101.45 | 102.99 | 101.41 | 102.2 | 172777.0 |
| 2008-10-13 19:30:00 | SPY | ETF | 102.25 | 103.35 | 102.2 | 103.34 | 181415.0 |
| 2008-10-13 04:00:00 | QQQ | ETF | 32.92 | 33.1 | 32.92 | 33.06 | 1400.0 |
| 2008-10-13 04:30:00 | QQQ | ETF | 33.1 | 33.17 | 32.96 | 33.17 | 10060.0 |
| 2008-10-13 05:00:00 | QQQ | ETF | 33.01 | 33.01 | 32.85 | 32.85 | 2000.0 |
| 2008-10-13 05:30:00 | QQQ | ETF | 32.85 | 32.89 | 32.85 | 32.89 | 2500.0 |
| 2008-10-13 06:00:00 | QQQ | ETF | 32.94 | 33.0 | 32.94 | 33.0 | 4200.0 |
| 2008-10-13 06:30:00 | QQQ | ETF | 33.02 | 33.02 | 32.7 | 32.7 | 16355.0 |
| 2008-10-13 07:00:00 | QQQ | ETF | 32.75 | 32.85 | 32.58 | 32.68 | 59800.0 |
| 2008-10-13 07:30:00 | QQQ | ETF | 32.7 | 32.78 | 32.66 | 32.75 | 323633.0 |
| 2008-10-13 08:00:00 | QQQ | ETF | 32.75 | 32.85 | 32.53 | 32.72 | 1126486.0 |
| 2008-10-13 08:30:00 | QQQ | ETF | 32.72 | 32.93 | 32.35 | 32.85 | 999146.0 |
| 2008-10-13 09:00:00 | QQQ | ETF | 32.85 | 32.9 | 32.75 | 32.81 | 1217377.0 |
| 2008-10-13 09:30:00 | QQQ | ETF | 32.81 | 33.03 | 32.47 | 32.6774 | 38128142.0 |
| 2008-10-13 10:00:00 | QQQ | ETF | 32.67 | 32.94 | 32.4 | 32.89 | 25465335.0 |
| 2008-10-13 10:30:00 | QQQ | ETF | 32.89 | 33.15 | 32.82 | 33.0 | 21451677.0 |
| 2008-10-13 11:00:00 | QQQ | ETF | 33.0 | 33.13 | 32.93 | 33.09 | 12696153.0 |
| 2008-10-13 11:30:00 | QQQ | ETF | 33.09 | 33.3 | 33.09 | 33.221 | 12720046.0 |
| 2008-10-13 12:00:00 | QQQ | ETF | 33.21 | 33.63 | 33.17 | 33.58 | 12799410.0 |
| 2008-10-13 12:30:00 | QQQ | ETF | 33.59 | 33.67 | 33.51 | 33.54 | 9984958.0 |
> showing 50 of 6,736 rows — these rows as CSV