PREVIEW / etf_30min / 2010-10-25
file: by_date/etf_30min/2010/2010-10-25.parquet size: 267 KB rows: 8,965
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-25 04:00:00 | SPY | ETF | 118.89 | 119.3 | 118.89 | 119.3 | 1768.0 |
| 2010-10-25 04:30:00 | SPY | ETF | 119.33 | 119.39 | 119.27 | 119.3 | 1300.0 |
| 2010-10-25 05:30:00 | SPY | ETF | 119.25 | 119.25 | 119.17 | 119.17 | 5400.0 |
| 2010-10-25 06:00:00 | SPY | ETF | 119.3 | 119.33 | 119.3 | 119.3 | 21461.0 |
| 2010-10-25 06:30:00 | SPY | ETF | 119.35 | 119.4 | 119.35 | 119.37 | 201390.0 |
| 2010-10-25 07:00:00 | SPY | ETF | 119.35 | 119.36 | 119.27 | 119.3 | 236570.0 |
| 2010-10-25 07:30:00 | SPY | ETF | 119.3 | 119.33 | 119.17 | 119.27 | 126072.0 |
| 2010-10-25 08:00:00 | SPY | ETF | 119.15 | 119.3 | 118.95 | 119.15 | 317939.0 |
| 2010-10-25 08:30:00 | SPY | ETF | 119.16 | 119.2 | 119.06 | 119.13 | 1196828.0 |
| 2010-10-25 09:00:00 | SPY | ETF | 119.12 | 119.24 | 119.12 | 119.16 | 878134.0 |
| 2010-10-25 09:30:00 | SPY | ETF | 119.14 | 119.64 | 119.07 | 119.56 | 17882487.0 |
| 2010-10-25 10:00:00 | SPY | ETF | 119.56 | 119.76 | 119.41 | 119.45 | 15546554.0 |
| 2010-10-25 10:30:00 | SPY | ETF | 119.44 | 119.52 | 118.95 | 119.08 | 14661782.0 |
| 2010-10-25 11:00:00 | SPY | ETF | 119.1 | 119.18 | 118.88 | 119.17 | 9645444.0 |
| 2010-10-25 11:30:00 | SPY | ETF | 119.17 | 119.26 | 119.01 | 119.05 | 6715962.0 |
| 2010-10-25 12:00:00 | SPY | ETF | 119.04 | 119.08 | 118.72 | 118.86 | 8329888.0 |
| 2010-10-25 12:30:00 | SPY | ETF | 118.855 | 118.93 | 118.78 | 118.84 | 4636394.0 |
| 2010-10-25 13:00:00 | SPY | ETF | 118.83 | 119.13 | 118.76 | 119.07 | 7086884.0 |
| 2010-10-25 13:30:00 | SPY | ETF | 119.06 | 119.12 | 118.92 | 119.0 | 5086178.0 |
| 2010-10-25 14:00:00 | SPY | ETF | 119.0 | 119.1 | 118.97 | 119.03 | 4605586.0 |
| 2010-10-25 14:30:00 | SPY | ETF | 119.03 | 119.13 | 118.77 | 118.95 | 7158153.0 |
| 2010-10-25 15:00:00 | SPY | ETF | 118.94 | 119.28 | 118.93 | 119.22 | 9264593.0 |
| 2010-10-25 15:30:00 | SPY | ETF | 119.225 | 119.26 | 118.61 | 118.68 | 23052536.0 |
| 2010-10-25 16:00:00 | SPY | ETF | 118.68 | 119.475 | 118.62 | 118.71 | 9592229.0 |
| 2010-10-25 16:30:00 | SPY | ETF | 118.7 | 118.74 | 118.65 | 118.71 | 273988.0 |
| 2010-10-25 17:00:00 | SPY | ETF | 118.71 | 118.76 | 118.7 | 118.75 | 79297.0 |
| 2010-10-25 17:30:00 | SPY | ETF | 118.76 | 118.82 | 118.73 | 118.74 | 69020.0 |
| 2010-10-25 18:00:00 | SPY | ETF | 118.73 | 118.73 | 118.63 | 118.66 | 157530.0 |
| 2010-10-25 18:30:00 | SPY | ETF | 118.69 | 119.254 | 118.68 | 118.7 | 22864.0 |
| 2010-10-25 19:00:00 | SPY | ETF | 118.7 | 118.7 | 118.63 | 118.65 | 20067.0 |
| 2010-10-25 19:30:00 | SPY | ETF | 118.67 | 118.68 | 118.6 | 118.68 | 48540.0 |
| 2010-10-25 04:00:00 | QQQ | ETF | 51.75 | 52.0 | 51.75 | 52.0 | 20450.0 |
| 2010-10-25 04:30:00 | QQQ | ETF | 52.0 | 52.02 | 52.0 | 52.0 | 2680.0 |
| 2010-10-25 05:00:00 | QQQ | ETF | 52.0 | 52.0 | 51.99 | 51.99 | 1300.0 |
| 2010-10-25 06:00:00 | QQQ | ETF | 51.98 | 51.98 | 51.98 | 51.98 | 750.0 |
| 2010-10-25 06:30:00 | QQQ | ETF | 52.0 | 52.0 | 52.0 | 52.0 | 2000.0 |
| 2010-10-25 07:00:00 | QQQ | ETF | 51.97 | 52.0 | 51.97 | 51.98 | 12000.0 |
| 2010-10-25 07:30:00 | QQQ | ETF | 51.98 | 51.99 | 51.95 | 51.97 | 42365.0 |
| 2010-10-25 08:00:00 | QQQ | ETF | 51.96 | 52.0 | 51.93 | 51.93 | 138975.0 |
| 2010-10-25 08:30:00 | QQQ | ETF | 51.93 | 51.96 | 51.9 | 51.92 | 225186.0 |
| 2010-10-25 09:00:00 | QQQ | ETF | 51.93 | 51.95 | 51.85 | 51.85 | 196814.0 |
| 2010-10-25 09:30:00 | QQQ | ETF | 51.85 | 52.18 | 51.85 | 52.18 | 8851286.0 |
| 2010-10-25 10:00:00 | QQQ | ETF | 52.16 | 52.23 | 52.07 | 52.13 | 4854405.0 |
| 2010-10-25 10:30:00 | QQQ | ETF | 52.13 | 52.18 | 51.9 | 51.96 | 4605793.0 |
| 2010-10-25 11:00:00 | QQQ | ETF | 51.95 | 52.05 | 51.86 | 52.04 | 3545035.0 |
| 2010-10-25 11:30:00 | QQQ | ETF | 52.04 | 52.06 | 51.98 | 52.01 | 2126621.0 |
| 2010-10-25 12:00:00 | QQQ | ETF | 52.0042 | 52.02 | 51.87 | 51.93 | 2258505.0 |
| 2010-10-25 12:30:00 | QQQ | ETF | 51.9299 | 51.98 | 51.89 | 51.9105 | 1224350.0 |
| 2010-10-25 13:00:00 | QQQ | ETF | 51.91 | 52.0207 | 51.88 | 52.0005 | 2161583.0 |
| 2010-10-25 13:30:00 | QQQ | ETF | 52.005 | 52.07 | 51.98 | 52.03 | 3123250.0 |
> showing 50 of 8,965 rows — these rows as CSV