PREVIEW / etf_30min / 2010-02-16
file: by_date/etf_30min/2010/2010-02-16.parquet size: 251 KB rows: 8,346
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-02-16 04:00:00 | SPY | ETF | 108.94 | 109.0 | 108.93 | 108.96 | 8541.0 |
| 2010-02-16 04:30:00 | SPY | ETF | 109.0 | 109.0 | 108.86 | 108.86 | 366.0 |
| 2010-02-16 05:00:00 | SPY | ETF | 108.92 | 109.0 | 108.86 | 108.86 | 8850.0 |
| 2010-02-16 05:30:00 | SPY | ETF | 108.92 | 108.92 | 108.82 | 108.87 | 9900.0 |
| 2010-02-16 06:00:00 | SPY | ETF | 108.82 | 108.83 | 108.78 | 108.83 | 41660.0 |
| 2010-02-16 06:30:00 | SPY | ETF | 108.89 | 108.89 | 108.82 | 108.83 | 40800.0 |
| 2010-02-16 07:00:00 | SPY | ETF | 108.81 | 108.89 | 108.54 | 108.62 | 1003145.0 |
| 2010-02-16 07:30:00 | SPY | ETF | 108.62 | 108.65 | 108.45 | 108.59 | 312406.0 |
| 2010-02-16 08:00:00 | SPY | ETF | 108.572 | 109.0 | 108.4424 | 108.88 | 2466352.0 |
| 2010-02-16 08:30:00 | SPY | ETF | 108.89 | 108.95 | 107.87 | 108.86 | 1819286.0 |
| 2010-02-16 09:00:00 | SPY | ETF | 108.87 | 109.1 | 108.79 | 108.85 | 2618052.0 |
| 2010-02-16 09:30:00 | SPY | ETF | 108.86 | 108.91 | 108.42 | 108.6195 | 21155897.0 |
| 2010-02-16 10:00:00 | SPY | ETF | 108.62 | 108.81 | 108.43 | 108.769 | 10674178.0 |
| 2010-02-16 10:30:00 | SPY | ETF | 108.76 | 109.16 | 108.73 | 108.91 | 14585781.0 |
| 2010-02-16 11:00:00 | SPY | ETF | 108.91 | 109.1 | 108.47 | 109.1 | 7764366.0 |
| 2010-02-16 11:30:00 | SPY | ETF | 109.1 | 109.35 | 109.08 | 109.21 | 9234411.0 |
| 2010-02-16 12:00:00 | SPY | ETF | 109.2001 | 109.3 | 109.14 | 109.24 | 7605629.0 |
| 2010-02-16 12:30:00 | SPY | ETF | 109.25 | 109.27 | 109.14 | 109.24 | 5188121.0 |
| 2010-02-16 13:00:00 | SPY | ETF | 109.2499 | 109.35 | 109.1 | 109.3301 | 6148674.0 |
| 2010-02-16 13:30:00 | SPY | ETF | 109.34 | 109.39 | 109.21 | 109.32 | 5759607.0 |
| 2010-02-16 14:00:00 | SPY | ETF | 109.31 | 109.42 | 109.17 | 109.3694 | 7741180.0 |
| 2010-02-16 14:30:00 | SPY | ETF | 109.36 | 109.43 | 109.2 | 109.35 | 7379456.0 |
| 2010-02-16 15:00:00 | SPY | ETF | 109.36 | 109.53 | 109.34 | 109.4983 | 8586645.0 |
| 2010-02-16 15:30:00 | SPY | ETF | 109.5 | 109.85 | 109.49 | 109.73 | 28036058.0 |
| 2010-02-16 16:00:00 | SPY | ETF | 109.73 | 109.82 | 108.55 | 109.75 | 6364051.0 |
| 2010-02-16 16:30:00 | SPY | ETF | 109.77 | 109.83 | 109.02 | 109.8 | 377153.0 |
| 2010-02-16 17:00:00 | SPY | ETF | 109.8 | 109.83 | 109.78 | 109.81 | 125188.0 |
| 2010-02-16 17:30:00 | SPY | ETF | 109.81 | 109.81 | 109.77 | 109.79 | 14341.0 |
| 2010-02-16 18:00:00 | SPY | ETF | 109.8 | 109.92 | 107.8208 | 109.92 | 2143773.0 |
| 2010-02-16 18:30:00 | SPY | ETF | 109.88 | 109.9 | 109.87 | 109.87 | 7589.0 |
| 2010-02-16 19:00:00 | SPY | ETF | 109.88 | 109.88 | 109.86 | 109.88 | 16019.0 |
| 2010-02-16 19:30:00 | SPY | ETF | 109.86 | 109.95 | 109.82 | 109.95 | 130398.0 |
| 2010-02-16 20:00:00 | SPY | ETF | 109.95 | 109.95 | 109.95 | 109.95 | 200.0 |
| 2010-02-16 04:00:00 | QQQ | ETF | 44.14 | 44.14 | 44.14 | 44.14 | 1090.0 |
| 2010-02-16 04:30:00 | QQQ | ETF | 44.16 | 44.16 | 44.16 | 44.16 | 500.0 |
| 2010-02-16 05:00:00 | QQQ | ETF | 44.17 | 44.17 | 44.12 | 44.12 | 200.0 |
| 2010-02-16 06:30:00 | QQQ | ETF | 44.13 | 44.13 | 44.11 | 44.11 | 350.0 |
| 2010-02-16 07:00:00 | QQQ | ETF | 44.13 | 44.14 | 43.96 | 43.98 | 342295.0 |
| 2010-02-16 07:30:00 | QQQ | ETF | 43.98 | 44.01 | 43.94 | 44.0 | 226372.0 |
| 2010-02-16 08:00:00 | QQQ | ETF | 43.98 | 44.15 | 43.97 | 44.09 | 1218440.0 |
| 2010-02-16 08:30:00 | QQQ | ETF | 44.05 | 44.11 | 43.95 | 44.1 | 1111439.0 |
| 2010-02-16 09:00:00 | QQQ | ETF | 44.11 | 44.17 | 44.04 | 44.08 | 1222807.0 |
| 2010-02-16 09:30:00 | QQQ | ETF | 44.07 | 44.12 | 43.85 | 43.97 | 13403447.0 |
| 2010-02-16 10:00:00 | QQQ | ETF | 43.965 | 44.08 | 43.89 | 44.06 | 6682085.0 |
| 2010-02-16 10:30:00 | QQQ | ETF | 44.07 | 44.26 | 44.05 | 44.14 | 10242932.0 |
| 2010-02-16 11:00:00 | QQQ | ETF | 44.14 | 44.23 | 44.0629 | 44.21 | 3739069.0 |
| 2010-02-16 11:30:00 | QQQ | ETF | 44.22 | 44.29 | 44.21 | 44.23 | 4248550.0 |
| 2010-02-16 12:00:00 | QQQ | ETF | 44.221 | 44.2593 | 44.19 | 44.21 | 3684955.0 |
| 2010-02-16 12:30:00 | QQQ | ETF | 44.22 | 44.23 | 44.18 | 44.21 | 2272359.0 |
| 2010-02-16 13:00:00 | QQQ | ETF | 44.201 | 44.23 | 44.16 | 44.22 | 2978573.0 |
> showing 50 of 8,346 rows — these rows as CSV