PREVIEW / etf_30min / 2008-11-10
file: by_date/etf_30min/2008/2008-11-10.parquet size: 177 KB rows: 6,227
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-11-10 04:00:00 | SPY | ETF | 95.81 | 95.88 | 95.69 | 95.88 | 8257.0 |
| 2008-11-10 04:30:00 | SPY | ETF | 95.86 | 96.03 | 95.86 | 95.93 | 4000.0 |
| 2008-11-10 05:00:00 | SPY | ETF | 95.85 | 96.34 | 95.85 | 96.32 | 11523.0 |
| 2008-11-10 05:30:00 | SPY | ETF | 96.36 | 96.55 | 96.3 | 96.35 | 27200.0 |
| 2008-11-10 06:00:00 | SPY | ETF | 96.33 | 96.46 | 96.24 | 96.24 | 30400.0 |
| 2008-11-10 06:30:00 | SPY | ETF | 96.2 | 96.37 | 95.96 | 95.96 | 29700.0 |
| 2008-11-10 07:00:00 | SPY | ETF | 95.96 | 96.0 | 95.43 | 95.54 | 515497.0 |
| 2008-11-10 07:30:00 | SPY | ETF | 95.48 | 95.9 | 95.48 | 95.89 | 651556.0 |
| 2008-11-10 08:00:00 | SPY | ETF | 95.9 | 96.3 | 95.53 | 95.72 | 2709610.0 |
| 2008-11-10 08:30:00 | SPY | ETF | 95.71 | 95.93 | 95.52 | 95.59 | 1414884.0 |
| 2008-11-10 09:00:00 | SPY | ETF | 95.6 | 95.6 | 95.07 | 95.18 | 2982801.0 |
| 2008-11-10 09:30:00 | SPY | ETF | 95.21 | 95.53 | 94.4 | 94.66 | 34228075.0 |
| 2008-11-10 10:00:00 | SPY | ETF | 94.67 | 94.98 | 94.24 | 94.48 | 17384238.0 |
| 2008-11-10 10:30:00 | SPY | ETF | 94.47 | 94.875 | 93.61 | 93.78 | 16341935.0 |
| 2008-11-10 11:00:00 | SPY | ETF | 93.79 | 93.87 | 93.32 | 93.77 | 15531895.0 |
| 2008-11-10 11:30:00 | SPY | ETF | 93.78 | 93.94 | 92.56 | 92.71 | 13733962.0 |
| 2008-11-10 12:00:00 | SPY | ETF | 92.72 | 93.13 | 92.32 | 92.35 | 13580319.0 |
| 2008-11-10 12:30:00 | SPY | ETF | 92.37 | 92.47 | 91.56 | 91.81 | 19274117.0 |
| 2008-11-10 13:00:00 | SPY | ETF | 91.81 | 92.39 | 91.49 | 92.278 | 16381727.0 |
| 2008-11-10 13:30:00 | SPY | ETF | 92.28 | 92.76 | 91.94 | 92.621 | 20024815.0 |
| 2008-11-10 14:00:00 | SPY | ETF | 92.63 | 92.92 | 92.06 | 92.16 | 15334842.0 |
| 2008-11-10 14:30:00 | SPY | ETF | 92.1515 | 92.27 | 91.41 | 91.62 | 16051587.0 |
| 2008-11-10 15:00:00 | SPY | ETF | 91.62 | 92.01 | 90.92 | 91.11 | 30315186.0 |
| 2008-11-10 15:30:00 | SPY | ETF | 91.11 | 92.31 | 90.98 | 92.23 | 40923801.0 |
| 2008-11-10 16:00:00 | SPY | ETF | 92.23 | 92.68 | 92.173 | 92.4 | 7288606.0 |
| 2008-11-10 16:30:00 | SPY | ETF | 92.38 | 92.5 | 92.27 | 92.43 | 6772385.0 |
| 2008-11-10 17:00:00 | SPY | ETF | 92.14 | 92.54 | 92.14 | 92.54 | 196802.0 |
| 2008-11-10 17:30:00 | SPY | ETF | 92.54 | 93.3148 | 92.46 | 92.51 | 2034134.0 |
| 2008-11-10 18:00:00 | SPY | ETF | 92.53 | 93.3148 | 92.11 | 92.2 | 3156404.0 |
| 2008-11-10 18:30:00 | SPY | ETF | 92.24 | 93.31 | 92.17 | 92.25 | 60150.0 |
| 2008-11-10 19:00:00 | SPY | ETF | 92.23 | 92.43 | 92.21 | 92.23 | 25456.0 |
| 2008-11-10 19:30:00 | SPY | ETF | 92.15 | 92.21 | 92.06 | 92.08 | 9399.0 |
| 2008-11-10 04:00:00 | QQQ | ETF | 32.15 | 32.19 | 32.15 | 32.19 | 3900.0 |
| 2008-11-10 04:30:00 | QQQ | ETF | 32.23 | 32.35 | 32.22 | 32.35 | 1200.0 |
| 2008-11-10 05:00:00 | QQQ | ETF | 32.2 | 32.4 | 32.2 | 32.4 | 2400.0 |
| 2008-11-10 05:30:00 | QQQ | ETF | 32.42 | 32.42 | 32.4 | 32.4 | 9000.0 |
| 2008-11-10 06:00:00 | QQQ | ETF | 32.42 | 32.45 | 32.42 | 32.45 | 200.0 |
| 2008-11-10 06:30:00 | QQQ | ETF | 32.43 | 32.45 | 32.41 | 32.41 | 2300.0 |
| 2008-11-10 07:00:00 | QQQ | ETF | 32.39 | 32.4 | 32.19 | 32.2 | 147434.0 |
| 2008-11-10 07:30:00 | QQQ | ETF | 32.22 | 32.28 | 32.15 | 32.25 | 140822.0 |
| 2008-11-10 08:00:00 | QQQ | ETF | 32.27 | 32.31 | 32.17 | 32.2 | 711313.0 |
| 2008-11-10 08:30:00 | QQQ | ETF | 32.2 | 32.25 | 32.15 | 32.15 | 360782.0 |
| 2008-11-10 09:00:00 | QQQ | ETF | 32.15 | 32.15 | 31.93 | 31.94 | 852430.0 |
| 2008-11-10 09:30:00 | QQQ | ETF | 31.94 | 31.97 | 31.38 | 31.54 | 22777319.0 |
| 2008-11-10 10:00:00 | QQQ | ETF | 31.55 | 31.6 | 31.34 | 31.46 | 9453815.0 |
| 2008-11-10 10:30:00 | QQQ | ETF | 31.47 | 31.56 | 31.32 | 31.37 | 6933756.0 |
| 2008-11-10 11:00:00 | QQQ | ETF | 31.37 | 31.3701 | 31.16 | 31.3005 | 7325703.0 |
| 2008-11-10 11:30:00 | QQQ | ETF | 31.3 | 31.36 | 30.89 | 30.9399 | 8707599.0 |
| 2008-11-10 12:00:00 | QQQ | ETF | 30.93 | 31.17 | 30.84 | 30.85 | 10583742.0 |
| 2008-11-10 12:30:00 | QQQ | ETF | 30.8499 | 30.88 | 30.55 | 30.66 | 9097312.0 |
> showing 50 of 6,227 rows — these rows as CSV