PREVIEW / etf_30min / 2008-10-30
file: by_date/etf_30min/2008/2008-10-30.parquet size: 177 KB rows: 6,354
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-30 04:00:00 | SPY | ETF | 95.57 | 95.57 | 95.0 | 95.55 | 1300.0 |
| 2008-10-30 05:00:00 | SPY | ETF | 94.78 | 95.22 | 94.78 | 95.09 | 13100.0 |
| 2008-10-30 05:30:00 | SPY | ETF | 94.99 | 95.45 | 94.9 | 95.26 | 10700.0 |
| 2008-10-30 06:00:00 | SPY | ETF | 95.33 | 95.75 | 95.14 | 95.52 | 71900.0 |
| 2008-10-30 06:30:00 | SPY | ETF | 95.55 | 96.05 | 95.55 | 95.88 | 173342.0 |
| 2008-10-30 07:00:00 | SPY | ETF | 95.86 | 95.89 | 95.25 | 95.33 | 313929.0 |
| 2008-10-30 07:30:00 | SPY | ETF | 95.31 | 96.03 | 95.28 | 95.93 | 768907.0 |
| 2008-10-30 08:00:00 | SPY | ETF | 95.97 | 96.0 | 93.7 | 95.5 | 1773362.0 |
| 2008-10-30 08:30:00 | SPY | ETF | 95.5 | 96.46 | 95.35 | 96.15 | 4351317.0 |
| 2008-10-30 09:00:00 | SPY | ETF | 96.15 | 96.51 | 95.72 | 95.77 | 3618348.0 |
| 2008-10-30 09:30:00 | SPY | ETF | 95.78 | 96.51 | 95.2 | 95.55 | 39439686.0 |
| 2008-10-30 10:00:00 | SPY | ETF | 95.54 | 96.14 | 94.76 | 94.79 | 28441415.0 |
| 2008-10-30 10:30:00 | SPY | ETF | 94.78 | 95.06 | 93.9 | 94.55 | 29244129.0 |
| 2008-10-30 11:00:00 | SPY | ETF | 94.55 | 95.29 | 94.0 | 94.18 | 25744871.0 |
| 2008-10-30 11:30:00 | SPY | ETF | 94.1892 | 94.5 | 92.9 | 93.34 | 34857294.0 |
| 2008-10-30 12:00:00 | SPY | ETF | 93.33 | 94.12 | 93.22 | 93.9 | 21421510.0 |
| 2008-10-30 12:30:00 | SPY | ETF | 93.89 | 94.59 | 93.78 | 93.86 | 20458697.0 |
| 2008-10-30 13:00:00 | SPY | ETF | 93.86 | 95.08 | 93.66 | 94.19 | 19986209.0 |
| 2008-10-30 13:30:00 | SPY | ETF | 94.19 | 94.76 | 93.78 | 94.52 | 15233426.0 |
| 2008-10-30 14:00:00 | SPY | ETF | 94.51 | 95.63 | 94.42 | 95.28 | 21558049.0 |
| 2008-10-30 14:30:00 | SPY | ETF | 95.3025 | 95.65 | 94.76 | 95.22 | 21422078.0 |
| 2008-10-30 15:00:00 | SPY | ETF | 95.23 | 95.95 | 94.01 | 94.95 | 41245480.0 |
| 2008-10-30 15:30:00 | SPY | ETF | 94.94 | 95.92 | 93.77 | 95.47 | 64992618.0 |
| 2008-10-30 16:00:00 | SPY | ETF | 95.46 | 96.55 | 94.25 | 96.18 | 7460329.0 |
| 2008-10-30 16:30:00 | SPY | ETF | 96.13 | 96.3 | 93.0974 | 96.0 | 1862098.0 |
| 2008-10-30 17:00:00 | SPY | ETF | 96.04 | 96.09 | 95.88 | 95.96 | 151073.0 |
| 2008-10-30 17:30:00 | SPY | ETF | 96.01 | 96.1 | 95.99 | 96.0 | 1635926.0 |
| 2008-10-30 18:00:00 | SPY | ETF | 96.0 | 96.2 | 95.92 | 96.03 | 62500.0 |
| 2008-10-30 18:30:00 | SPY | ETF | 96.08 | 96.1 | 95.82 | 95.84 | 49698.0 |
| 2008-10-30 19:00:00 | SPY | ETF | 95.82 | 95.82 | 95.6 | 95.76 | 22111.0 |
| 2008-10-30 19:30:00 | SPY | ETF | 95.76 | 95.87 | 95.58 | 95.64 | 58758.0 |
| 2008-10-30 04:00:00 | QQQ | ETF | 32.62 | 32.66 | 32.5 | 32.66 | 500.0 |
| 2008-10-30 04:30:00 | QQQ | ETF | 32.56 | 32.58 | 32.53 | 32.53 | 800.0 |
| 2008-10-30 05:00:00 | QQQ | ETF | 32.54 | 32.59 | 32.54 | 32.56 | 1400.0 |
| 2008-10-30 05:30:00 | QQQ | ETF | 32.5 | 32.69 | 32.5 | 32.69 | 10300.0 |
| 2008-10-30 06:00:00 | QQQ | ETF | 32.75 | 33.0 | 32.73 | 32.81 | 3800.0 |
| 2008-10-30 06:30:00 | QQQ | ETF | 32.81 | 32.92 | 32.81 | 32.88 | 10700.0 |
| 2008-10-30 07:00:00 | QQQ | ETF | 32.87 | 32.95 | 32.64 | 32.67 | 36885.0 |
| 2008-10-30 07:30:00 | QQQ | ETF | 32.68 | 32.85 | 32.68 | 32.78 | 104269.0 |
| 2008-10-30 08:00:00 | QQQ | ETF | 32.79 | 32.83 | 32.41 | 32.44 | 954424.0 |
| 2008-10-30 08:30:00 | QQQ | ETF | 32.4 | 33.19 | 32.4 | 32.76 | 1852371.0 |
| 2008-10-30 09:00:00 | QQQ | ETF | 32.75 | 32.84 | 32.67 | 32.68 | 1039924.0 |
| 2008-10-30 09:30:00 | QQQ | ETF | 32.68 | 33.06 | 32.6 | 32.77 | 27319643.0 |
| 2008-10-30 10:00:00 | QQQ | ETF | 32.76 | 32.9 | 32.38 | 32.39 | 21989577.0 |
| 2008-10-30 10:30:00 | QQQ | ETF | 32.39 | 32.56 | 32.28 | 32.45 | 24162381.0 |
| 2008-10-30 11:00:00 | QQQ | ETF | 32.45 | 32.71 | 32.33 | 32.38 | 17065676.0 |
| 2008-10-30 11:30:00 | QQQ | ETF | 32.39 | 32.45 | 31.98 | 32.12 | 19874697.0 |
| 2008-10-30 12:00:00 | QQQ | ETF | 32.12 | 32.4 | 32.09 | 32.31 | 11467802.0 |
| 2008-10-30 12:30:00 | QQQ | ETF | 32.31 | 32.51 | 32.26 | 32.2795 | 8313750.0 |
| 2008-10-30 13:00:00 | QQQ | ETF | 32.27 | 32.77 | 32.22 | 32.49 | 17196273.0 |
> showing 50 of 6,354 rows — these rows as CSV