PREVIEW / etf_5min / 2009-09-28
file: by_date/etf_5min/2009/2009-09-28.parquet size: 713 KB rows: 29,408
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 |
|---|---|---|---|---|---|---|---|
| 2009-09-28 04:15:00 | SPY | ETF | 104.26 | 104.28 | 104.26 | 104.28 | 200.0 |
| 2009-09-28 04:20:00 | SPY | ETF | 104.35 | 104.35 | 104.35 | 104.35 | 2473.0 |
| 2009-09-28 04:25:00 | SPY | ETF | 104.34 | 104.37 | 104.34 | 104.37 | 2100.0 |
| 2009-09-28 04:50:00 | SPY | ETF | 104.6 | 104.6 | 104.6 | 104.6 | 100.0 |
| 2009-09-28 04:55:00 | SPY | ETF | 104.6 | 104.6 | 104.6 | 104.6 | 100.0 |
| 2009-09-28 05:35:00 | SPY | ETF | 104.6 | 104.6 | 104.6 | 104.6 | 100.0 |
| 2009-09-28 05:40:00 | SPY | ETF | 104.61 | 104.61 | 104.61 | 104.61 | 100.0 |
| 2009-09-28 05:50:00 | SPY | ETF | 104.56 | 104.56 | 104.56 | 104.56 | 100.0 |
| 2009-09-28 06:20:00 | SPY | ETF | 104.72 | 104.72 | 104.72 | 104.72 | 2000.0 |
| 2009-09-28 06:25:00 | SPY | ETF | 104.81 | 104.81 | 104.81 | 104.81 | 400.0 |
| 2009-09-28 06:30:00 | SPY | ETF | 104.82 | 104.82 | 104.82 | 104.82 | 100.0 |
| 2009-09-28 06:35:00 | SPY | ETF | 104.77 | 104.77 | 104.77 | 104.77 | 300.0 |
| 2009-09-28 06:55:00 | SPY | ETF | 104.79 | 104.79 | 104.79 | 104.79 | 2000.0 |
| 2009-09-28 07:00:00 | SPY | ETF | 104.8 | 104.83 | 104.74 | 104.8 | 8599.0 |
| 2009-09-28 07:05:00 | SPY | ETF | 104.79 | 104.82 | 104.79 | 104.81 | 20100.0 |
| 2009-09-28 07:10:00 | SPY | ETF | 104.8 | 104.85 | 104.8 | 104.84 | 8500.0 |
| 2009-09-28 07:15:00 | SPY | ETF | 104.85 | 104.88 | 104.85 | 104.85 | 6300.0 |
| 2009-09-28 07:20:00 | SPY | ETF | 104.87 | 104.99 | 104.87 | 104.92 | 11198.0 |
| 2009-09-28 07:25:00 | SPY | ETF | 104.87 | 104.98 | 104.87 | 104.93 | 33200.0 |
| 2009-09-28 07:30:00 | SPY | ETF | 104.95 | 104.95 | 104.92 | 104.95 | 13538.0 |
| 2009-09-28 07:35:00 | SPY | ETF | 104.95 | 104.96 | 104.92 | 104.96 | 5852.0 |
| 2009-09-28 07:40:00 | SPY | ETF | 104.98 | 104.99 | 104.97 | 104.98 | 4883.0 |
| 2009-09-28 07:45:00 | SPY | ETF | 104.92 | 104.95 | 104.9 | 104.9 | 13383.0 |
| 2009-09-28 07:50:00 | SPY | ETF | 104.92 | 104.95 | 104.92 | 104.92 | 127153.0 |
| 2009-09-28 07:55:00 | SPY | ETF | 104.97 | 104.97 | 104.92 | 104.92 | 47800.0 |
| 2009-09-28 08:00:00 | SPY | ETF | 104.9 | 104.94 | 104.1 | 104.93 | 54553.0 |
| 2009-09-28 08:05:00 | SPY | ETF | 104.94 | 105.0 | 104.94 | 104.97 | 95589.0 |
| 2009-09-28 08:10:00 | SPY | ETF | 104.98 | 105.1 | 104.97 | 105.07 | 256131.0 |
| 2009-09-28 08:15:00 | SPY | ETF | 105.08 | 105.13 | 105.04 | 105.05 | 58904.0 |
| 2009-09-28 08:20:00 | SPY | ETF | 105.05 | 105.12 | 105.04 | 105.09 | 33682.0 |
| 2009-09-28 08:25:00 | SPY | ETF | 105.09 | 105.16 | 105.09 | 105.1 | 52635.0 |
| 2009-09-28 08:30:00 | SPY | ETF | 105.11 | 105.19 | 105.1 | 105.17 | 56616.0 |
| 2009-09-28 08:35:00 | SPY | ETF | 105.18 | 105.22 | 105.13 | 105.16 | 73191.0 |
| 2009-09-28 08:40:00 | SPY | ETF | 105.16 | 105.16 | 105.1 | 105.12 | 268858.0 |
| 2009-09-28 08:45:00 | SPY | ETF | 105.11 | 105.18 | 105.11 | 105.18 | 142342.0 |
| 2009-09-28 08:50:00 | SPY | ETF | 105.18 | 105.2 | 105.12 | 105.12 | 173882.0 |
| 2009-09-28 08:55:00 | SPY | ETF | 105.13 | 105.18 | 104.95 | 104.97 | 221768.0 |
| 2009-09-28 09:00:00 | SPY | ETF | 104.96 | 104.98 | 104.9 | 104.96 | 190563.0 |
| 2009-09-28 09:05:00 | SPY | ETF | 104.97 | 105.02 | 104.95 | 104.98 | 44662.0 |
| 2009-09-28 09:10:00 | SPY | ETF | 104.98 | 105.08 | 104.98 | 105.08 | 133977.0 |
| 2009-09-28 09:15:00 | SPY | ETF | 105.04 | 105.08 | 105.01 | 105.05 | 106783.0 |
| 2009-09-28 09:20:00 | SPY | ETF | 105.04 | 105.05 | 104.92 | 104.94 | 89070.0 |
| 2009-09-28 09:25:00 | SPY | ETF | 104.93 | 104.94 | 104.86 | 104.86 | 281954.0 |
| 2009-09-28 09:30:00 | SPY | ETF | 104.85 | 105.01 | 104.83 | 104.92 | 2568484.0 |
| 2009-09-28 09:35:00 | SPY | ETF | 104.91 | 105.12 | 104.9 | 104.97 | 2721055.0 |
| 2009-09-28 09:40:00 | SPY | ETF | 104.96 | 105.4 | 104.94 | 105.38 | 3272645.0 |
| 2009-09-28 09:45:00 | SPY | ETF | 105.3799 | 105.65 | 105.37 | 105.59 | 4568251.0 |
| 2009-09-28 09:50:00 | SPY | ETF | 105.58 | 105.71 | 105.57 | 105.67 | 2343198.0 |
| 2009-09-28 09:55:00 | SPY | ETF | 105.67 | 105.68 | 105.51 | 105.6 | 2408340.0 |
| 2009-09-28 10:00:00 | SPY | ETF | 105.59 | 105.95 | 105.59 | 105.86 | 4381806.0 |
> showing 50 of 29,408 rows — these rows as CSV