PREVIEW / etf_5min / 2009-04-15
file: by_date/etf_5min/2009/2009-04-15.parquet size: 667 KB rows: 29,062
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-15 04:25:00 | SPY | ETF | 84.41 | 84.41 | 84.41 | 84.41 | 160.0 |
| 2009-04-15 04:30:00 | SPY | ETF | 84.5 | 84.5 | 84.5 | 84.5 | 400.0 |
| 2009-04-15 04:35:00 | SPY | ETF | 84.49 | 84.49 | 84.49 | 84.49 | 600.0 |
| 2009-04-15 04:40:00 | SPY | ETF | 84.48 | 84.55 | 84.48 | 84.55 | 300.0 |
| 2009-04-15 04:45:00 | SPY | ETF | 84.51 | 84.65 | 84.51 | 84.65 | 930.0 |
| 2009-04-15 04:50:00 | SPY | ETF | 84.67 | 84.68 | 84.66 | 84.68 | 800.0 |
| 2009-04-15 04:55:00 | SPY | ETF | 84.73 | 84.73 | 84.73 | 84.73 | 25000.0 |
| 2009-04-15 05:00:00 | SPY | ETF | 84.75 | 84.75 | 84.75 | 84.75 | 300.0 |
| 2009-04-15 05:15:00 | SPY | ETF | 84.61 | 84.61 | 84.61 | 84.61 | 100.0 |
| 2009-04-15 05:35:00 | SPY | ETF | 84.56 | 84.57 | 84.56 | 84.57 | 800.0 |
| 2009-04-15 05:40:00 | SPY | ETF | 84.41 | 84.41 | 84.41 | 84.41 | 100.0 |
| 2009-04-15 06:00:00 | SPY | ETF | 84.41 | 84.41 | 84.41 | 84.41 | 2000.0 |
| 2009-04-15 06:10:00 | SPY | ETF | 84.5 | 84.5 | 84.47 | 84.47 | 3000.0 |
| 2009-04-15 06:15:00 | SPY | ETF | 84.47 | 84.47 | 84.36 | 84.38 | 8500.0 |
| 2009-04-15 06:20:00 | SPY | ETF | 84.52 | 84.52 | 84.52 | 84.52 | 1000.0 |
| 2009-04-15 06:25:00 | SPY | ETF | 84.51 | 84.51 | 84.49 | 84.51 | 13800.0 |
| 2009-04-15 06:30:00 | SPY | ETF | 84.5 | 84.51 | 84.5 | 84.51 | 5300.0 |
| 2009-04-15 06:40:00 | SPY | ETF | 84.42 | 84.42 | 84.4 | 84.4 | 600.0 |
| 2009-04-15 06:45:00 | SPY | ETF | 84.39 | 84.42 | 84.39 | 84.42 | 1220.0 |
| 2009-04-15 06:50:00 | SPY | ETF | 84.54 | 84.54 | 84.54 | 84.54 | 100.0 |
| 2009-04-15 06:55:00 | SPY | ETF | 84.54 | 84.59 | 84.51 | 84.59 | 9500.0 |
| 2009-04-15 07:00:00 | SPY | ETF | 84.58 | 84.59 | 84.46 | 84.59 | 53315.0 |
| 2009-04-15 07:05:00 | SPY | ETF | 84.6 | 84.76 | 84.6 | 84.71 | 90624.0 |
| 2009-04-15 07:10:00 | SPY | ETF | 84.71 | 84.72 | 84.54 | 84.54 | 41201.0 |
| 2009-04-15 07:15:00 | SPY | ETF | 84.54 | 84.57 | 84.5 | 84.57 | 135103.0 |
| 2009-04-15 07:20:00 | SPY | ETF | 84.56 | 84.66 | 84.54 | 84.66 | 52333.0 |
| 2009-04-15 07:25:00 | SPY | ETF | 84.66 | 84.66 | 84.54 | 84.54 | 61844.0 |
| 2009-04-15 07:30:00 | SPY | ETF | 84.52 | 84.54 | 84.33 | 84.38 | 151049.0 |
| 2009-04-15 07:35:00 | SPY | ETF | 84.38 | 84.41 | 84.34 | 84.35 | 92511.0 |
| 2009-04-15 07:40:00 | SPY | ETF | 84.35 | 84.39 | 84.29 | 84.34 | 113538.0 |
| 2009-04-15 07:45:00 | SPY | ETF | 84.34 | 84.34 | 84.28 | 84.33 | 33261.0 |
| 2009-04-15 07:50:00 | SPY | ETF | 84.32 | 84.36 | 84.26 | 84.26 | 78677.0 |
| 2009-04-15 07:55:00 | SPY | ETF | 84.26 | 84.26 | 84.19 | 84.2 | 71444.0 |
| 2009-04-15 08:00:00 | SPY | ETF | 84.21 | 84.38 | 84.02 | 84.03 | 414650.0 |
| 2009-04-15 08:05:00 | SPY | ETF | 84.02 | 84.07 | 83.95 | 83.99 | 629434.0 |
| 2009-04-15 08:10:00 | SPY | ETF | 83.99 | 84.01 | 83.96 | 83.99 | 126562.0 |
| 2009-04-15 08:15:00 | SPY | ETF | 84.0 | 84.02 | 83.96 | 83.97 | 302131.0 |
| 2009-04-15 08:20:00 | SPY | ETF | 83.97 | 84.38 | 83.97 | 84.1 | 208341.0 |
| 2009-04-15 08:25:00 | SPY | ETF | 84.12 | 84.26 | 84.09 | 84.26 | 153490.0 |
| 2009-04-15 08:30:00 | SPY | ETF | 84.14 | 84.38 | 84.09 | 84.15 | 572006.0 |
| 2009-04-15 08:35:00 | SPY | ETF | 84.16 | 84.25 | 84.12 | 84.23 | 175397.0 |
| 2009-04-15 08:40:00 | SPY | ETF | 84.24 | 84.35 | 84.23 | 84.33 | 173231.0 |
| 2009-04-15 08:45:00 | SPY | ETF | 84.33 | 84.33 | 84.12 | 84.12 | 180460.0 |
| 2009-04-15 08:50:00 | SPY | ETF | 84.12 | 84.19 | 83.95 | 83.98 | 519764.0 |
| 2009-04-15 08:55:00 | SPY | ETF | 83.97 | 84.1 | 83.93 | 84.04 | 373780.0 |
| 2009-04-15 09:00:00 | SPY | ETF | 84.04 | 84.1 | 83.91 | 83.98 | 875170.0 |
| 2009-04-15 09:05:00 | SPY | ETF | 83.97 | 84.65 | 83.96 | 84.02 | 168206.0 |
| 2009-04-15 09:10:00 | SPY | ETF | 84.03 | 84.12 | 84.02 | 84.06 | 248698.0 |
| 2009-04-15 09:15:00 | SPY | ETF | 84.07 | 84.07 | 83.73 | 83.81 | 1080808.0 |
| 2009-04-15 09:20:00 | SPY | ETF | 83.82 | 83.87 | 83.78 | 83.86 | 94982.0 |
> showing 50 of 29,062 rows — these rows as CSV