PREVIEW / etf_5min / 2009-04-07
file: by_date/etf_5min/2009/2009-04-07.parquet size: 650 KB rows: 28,784
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-04-07 04:15:00 | SPY | ETF | 83.11 | 83.11 | 83.11 | 83.11 | 200.0 |
| 2009-04-07 04:35:00 | SPY | ETF | 83.01 | 83.01 | 82.81 | 82.81 | 2800.0 |
| 2009-04-07 04:40:00 | SPY | ETF | 82.81 | 82.81 | 82.75 | 82.79 | 6285.0 |
| 2009-04-07 04:45:00 | SPY | ETF | 82.68 | 82.68 | 82.5 | 82.5 | 3200.0 |
| 2009-04-07 04:50:00 | SPY | ETF | 82.56 | 82.56 | 82.35 | 82.4 | 3228.0 |
| 2009-04-07 04:55:00 | SPY | ETF | 82.43 | 82.43 | 82.43 | 82.43 | 500.0 |
| 2009-04-07 05:00:00 | SPY | ETF | 82.48 | 82.48 | 82.48 | 82.48 | 100.0 |
| 2009-04-07 05:05:00 | SPY | ETF | 82.58 | 82.58 | 82.55 | 82.55 | 200.0 |
| 2009-04-07 05:10:00 | SPY | ETF | 82.53 | 82.58 | 82.5 | 82.58 | 2200.0 |
| 2009-04-07 05:20:00 | SPY | ETF | 82.67 | 82.67 | 82.67 | 82.67 | 100.0 |
| 2009-04-07 05:30:00 | SPY | ETF | 82.58 | 82.58 | 82.58 | 82.58 | 100.0 |
| 2009-04-07 05:45:00 | SPY | ETF | 82.6 | 82.6 | 82.6 | 82.6 | 100.0 |
| 2009-04-07 05:55:00 | SPY | ETF | 82.6 | 82.6 | 82.6 | 82.6 | 100.0 |
| 2009-04-07 06:05:00 | SPY | ETF | 82.55 | 82.55 | 82.39 | 82.49 | 10900.0 |
| 2009-04-07 06:10:00 | SPY | ETF | 82.43 | 82.44 | 82.43 | 82.44 | 11000.0 |
| 2009-04-07 06:15:00 | SPY | ETF | 82.49 | 82.49 | 82.49 | 82.49 | 100.0 |
| 2009-04-07 06:20:00 | SPY | ETF | 82.5 | 82.54 | 82.49 | 82.49 | 4200.0 |
| 2009-04-07 06:25:00 | SPY | ETF | 82.54 | 82.54 | 82.46 | 82.48 | 8801.0 |
| 2009-04-07 06:30:00 | SPY | ETF | 82.48 | 82.48 | 82.48 | 82.48 | 1700.0 |
| 2009-04-07 06:35:00 | SPY | ETF | 82.51 | 82.51 | 82.32 | 82.32 | 12700.0 |
| 2009-04-07 06:40:00 | SPY | ETF | 82.41 | 82.41 | 82.21 | 82.24 | 11700.0 |
| 2009-04-07 06:45:00 | SPY | ETF | 82.24 | 82.29 | 82.24 | 82.29 | 5200.0 |
| 2009-04-07 06:50:00 | SPY | ETF | 82.23 | 82.24 | 82.21 | 82.21 | 11300.0 |
| 2009-04-07 06:55:00 | SPY | ETF | 82.16 | 82.16 | 82.0 | 82.03 | 46800.0 |
| 2009-04-07 07:00:00 | SPY | ETF | 82.09 | 82.15 | 82.06 | 82.15 | 105844.0 |
| 2009-04-07 07:05:00 | SPY | ETF | 82.18 | 82.22 | 82.12 | 82.14 | 87500.0 |
| 2009-04-07 07:10:00 | SPY | ETF | 82.17 | 82.23 | 82.16 | 82.2 | 21200.0 |
| 2009-04-07 07:15:00 | SPY | ETF | 82.2 | 82.22 | 82.18 | 82.18 | 3300.0 |
| 2009-04-07 07:20:00 | SPY | ETF | 82.23 | 82.23 | 82.15 | 82.2 | 7019.0 |
| 2009-04-07 07:25:00 | SPY | ETF | 82.21 | 82.21 | 82.16 | 82.18 | 17800.0 |
| 2009-04-07 07:30:00 | SPY | ETF | 82.21 | 82.31 | 82.21 | 82.26 | 54350.0 |
| 2009-04-07 07:35:00 | SPY | ETF | 82.28 | 82.28 | 82.18 | 82.18 | 46650.0 |
| 2009-04-07 07:40:00 | SPY | ETF | 82.16 | 82.2 | 82.08 | 82.12 | 94272.0 |
| 2009-04-07 07:45:00 | SPY | ETF | 82.11 | 82.11 | 81.87 | 81.93 | 115378.0 |
| 2009-04-07 07:50:00 | SPY | ETF | 81.94 | 81.96 | 81.8 | 81.95 | 280784.0 |
| 2009-04-07 07:55:00 | SPY | ETF | 81.96 | 81.99 | 81.93 | 81.98 | 43380.0 |
| 2009-04-07 08:00:00 | SPY | ETF | 81.99 | 82.2 | 81.96 | 82.11 | 304920.0 |
| 2009-04-07 08:05:00 | SPY | ETF | 82.1 | 82.14 | 82.05 | 82.13 | 226120.0 |
| 2009-04-07 08:10:00 | SPY | ETF | 82.12 | 83.3 | 82.02 | 82.04 | 126049.0 |
| 2009-04-07 08:15:00 | SPY | ETF | 82.04 | 82.16 | 82.04 | 82.14 | 107518.0 |
| 2009-04-07 08:20:00 | SPY | ETF | 82.14 | 82.2 | 82.14 | 82.17 | 144321.0 |
| 2009-04-07 08:25:00 | SPY | ETF | 82.17 | 83.26 | 82.05 | 82.07 | 164240.0 |
| 2009-04-07 08:30:00 | SPY | ETF | 82.08 | 82.16 | 82.07 | 82.15 | 157321.0 |
| 2009-04-07 08:35:00 | SPY | ETF | 82.14 | 82.25 | 82.14 | 82.25 | 65785.0 |
| 2009-04-07 08:40:00 | SPY | ETF | 82.26 | 82.28 | 82.2 | 82.27 | 120430.0 |
| 2009-04-07 08:45:00 | SPY | ETF | 82.27 | 82.29 | 82.23 | 82.24 | 142790.0 |
| 2009-04-07 08:50:00 | SPY | ETF | 82.25 | 82.26 | 82.21 | 82.26 | 62955.0 |
| 2009-04-07 08:55:00 | SPY | ETF | 82.25 | 82.29 | 82.14 | 82.14 | 103927.0 |
| 2009-04-07 09:00:00 | SPY | ETF | 82.14 | 82.18 | 82.02 | 82.04 | 626127.0 |
| 2009-04-07 09:05:00 | SPY | ETF | 82.02 | 82.1 | 82.0 | 82.05 | 123725.0 |
> showing 50 of 28,784 rows — these rows as CSV