PREVIEW / etf_30min / 2008-11-28
file: by_date/etf_30min/2008/2008-11-28.parquet size: 110 KB rows: 3,623
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-28 04:00:00 | SPY | ETF | 89.11 | 89.11 | 89.07 | 89.07 | 2000.0 |
| 2008-11-28 04:30:00 | SPY | ETF | 89.0 | 89.0 | 88.65 | 88.65 | 8600.0 |
| 2008-11-28 05:00:00 | SPY | ETF | 88.7 | 88.7 | 88.65 | 88.65 | 4500.0 |
| 2008-11-28 05:30:00 | SPY | ETF | 88.57 | 89.0 | 88.57 | 88.8 | 1700.0 |
| 2008-11-28 06:00:00 | SPY | ETF | 88.92 | 88.92 | 88.71 | 88.81 | 400.0 |
| 2008-11-28 06:30:00 | SPY | ETF | 88.87 | 88.96 | 88.64 | 88.64 | 24900.0 |
| 2008-11-28 07:00:00 | SPY | ETF | 88.58 | 88.58 | 88.1 | 88.28 | 145990.0 |
| 2008-11-28 07:30:00 | SPY | ETF | 88.35 | 88.44 | 88.09 | 88.37 | 290943.0 |
| 2008-11-28 08:00:00 | SPY | ETF | 88.18 | 88.58 | 88.18 | 88.44 | 1131442.0 |
| 2008-11-28 08:30:00 | SPY | ETF | 88.42 | 89.0 | 88.095 | 88.52 | 1199502.0 |
| 2008-11-28 09:00:00 | SPY | ETF | 88.53 | 88.77 | 88.38 | 88.63 | 1263584.0 |
| 2008-11-28 09:30:00 | SPY | ETF | 88.63 | 89.37 | 88.53 | 88.82 | 17943715.0 |
| 2008-11-28 10:00:00 | SPY | ETF | 88.82 | 89.08 | 88.5 | 88.8 | 14586146.0 |
| 2008-11-28 10:30:00 | SPY | ETF | 88.8 | 88.95 | 88.48 | 88.91 | 10073400.0 |
| 2008-11-28 11:00:00 | SPY | ETF | 88.9 | 89.25 | 88.59 | 89.16 | 17399365.0 |
| 2008-11-28 11:30:00 | SPY | ETF | 89.15 | 89.57 | 88.87 | 89.52 | 11709652.0 |
| 2008-11-28 12:00:00 | SPY | ETF | 89.53 | 89.65 | 88.85 | 89.26 | 11621382.0 |
| 2008-11-28 12:30:00 | SPY | ETF | 89.25 | 90.05 | 89.13 | 89.8 | 24721870.0 |
| 2008-11-28 13:00:00 | SPY | ETF | 89.8 | 90.13 | 89.18 | 90.13 | 2890991.0 |
| 2008-11-28 13:30:00 | SPY | ETF | 90.13 | 90.15 | 89.17 | 90.03 | 703218.0 |
| 2008-11-28 14:00:00 | SPY | ETF | 90.05 | 90.1 | 89.92 | 89.95 | 688909.0 |
| 2008-11-28 14:30:00 | SPY | ETF | 89.96 | 90.09 | 89.5 | 90.08 | 103719.0 |
| 2008-11-28 15:00:00 | SPY | ETF | 90.04 | 90.04 | 89.95 | 89.95 | 2659.0 |
| 2008-11-28 15:30:00 | SPY | ETF | 89.96 | 90.0 | 89.84 | 89.9 | 26048.0 |
| 2008-11-28 16:00:00 | SPY | ETF | 90.0 | 90.21 | 89.85 | 90.2 | 26962.0 |
| 2008-11-28 16:30:00 | SPY | ETF | 90.03 | 90.15 | 90.0 | 90.01 | 2575.0 |
| 2008-11-28 04:30:00 | QQQ | ETF | 29.14 | 29.15 | 29.11 | 29.11 | 1500.0 |
| 2008-11-28 05:00:00 | QQQ | ETF | 29.1 | 29.1 | 29.1 | 29.1 | 200.0 |
| 2008-11-28 05:30:00 | QQQ | ETF | 29.09 | 29.22 | 29.08 | 29.22 | 1800.0 |
| 2008-11-28 06:00:00 | QQQ | ETF | 29.12 | 29.12 | 29.12 | 29.12 | 100.0 |
| 2008-11-28 06:30:00 | QQQ | ETF | 29.2 | 29.2 | 29.2 | 29.2 | 100.0 |
| 2008-11-28 07:00:00 | QQQ | ETF | 29.1 | 29.1 | 28.98 | 29.06 | 22655.0 |
| 2008-11-28 07:30:00 | QQQ | ETF | 29.07 | 29.12 | 29.01 | 29.08 | 47621.0 |
| 2008-11-28 08:00:00 | QQQ | ETF | 29.09 | 29.13 | 29.02 | 29.03 | 550661.0 |
| 2008-11-28 08:30:00 | QQQ | ETF | 29.02 | 29.15 | 29.01 | 29.02 | 512635.0 |
| 2008-11-28 09:00:00 | QQQ | ETF | 29.03 | 29.08 | 28.96 | 29.04 | 1231114.0 |
| 2008-11-28 09:30:00 | QQQ | ETF | 29.04 | 29.19 | 28.92 | 28.94 | 8283309.0 |
| 2008-11-28 10:00:00 | QQQ | ETF | 28.95 | 29.05 | 28.89 | 28.97 | 4891216.0 |
| 2008-11-28 10:30:00 | QQQ | ETF | 28.96 | 29.0 | 28.83 | 28.92 | 3853433.0 |
| 2008-11-28 11:00:00 | QQQ | ETF | 28.91 | 29.03 | 28.85 | 29.01 | 2681035.0 |
| 2008-11-28 11:30:00 | QQQ | ETF | 29.01 | 29.1 | 28.9 | 29.08 | 4275696.0 |
| 2008-11-28 12:00:00 | QQQ | ETF | 29.07 | 29.13 | 28.96 | 28.96 | 3924598.0 |
| 2008-11-28 12:30:00 | QQQ | ETF | 28.97 | 29.18 | 28.92 | 29.14 | 8985026.0 |
| 2008-11-28 13:00:00 | QQQ | ETF | 29.14 | 29.16 | 29.0163 | 29.16 | 1680915.0 |
| 2008-11-28 13:30:00 | QQQ | ETF | 29.13 | 29.18 | 29.09 | 29.09 | 28500.0 |
| 2008-11-28 14:00:00 | QQQ | ETF | 29.1 | 29.11 | 29.09 | 29.11 | 9900.0 |
| 2008-11-28 14:30:00 | QQQ | ETF | 29.12 | 29.13 | 29.09 | 29.1 | 22100.0 |
| 2008-11-28 15:00:00 | QQQ | ETF | 29.07 | 29.09 | 29.06 | 29.09 | 15700.0 |
| 2008-11-28 15:30:00 | QQQ | ETF | 29.09 | 29.09 | 29.09 | 29.09 | 700.0 |
| 2008-11-28 16:00:00 | QQQ | ETF | 29.1 | 29.1 | 29.08 | 29.08 | 1945.0 |
> showing 50 of 3,623 rows — these rows as CSV