PREVIEW / etf_5min / 2010-03-22
file: by_date/etf_5min/2010/2010-03-22.parquet size: 788 KB rows: 32,804
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-03-22 04:15:00 | SPY | ETF | 115.41 | 115.53 | 115.41 | 115.53 | 1700.0 |
| 2010-03-22 04:20:00 | SPY | ETF | 115.5 | 115.5 | 115.42 | 115.42 | 7800.0 |
| 2010-03-22 04:25:00 | SPY | ETF | 115.37 | 115.37 | 115.31 | 115.31 | 5224.0 |
| 2010-03-22 04:30:00 | SPY | ETF | 115.4 | 115.4 | 115.4 | 115.4 | 100.0 |
| 2010-03-22 04:40:00 | SPY | ETF | 115.45 | 115.49 | 115.45 | 115.49 | 2500.0 |
| 2010-03-22 04:55:00 | SPY | ETF | 115.52 | 115.52 | 115.49 | 115.49 | 1000.0 |
| 2010-03-22 05:20:00 | SPY | ETF | 115.41 | 115.41 | 115.41 | 115.41 | 3200.0 |
| 2010-03-22 05:35:00 | SPY | ETF | 115.41 | 115.41 | 115.31 | 115.31 | 16176.0 |
| 2010-03-22 05:40:00 | SPY | ETF | 115.3 | 115.3 | 115.3 | 115.3 | 10380.0 |
| 2010-03-22 05:45:00 | SPY | ETF | 115.3 | 115.3 | 115.3 | 115.3 | 100.0 |
| 2010-03-22 05:50:00 | SPY | ETF | 115.25 | 115.25 | 115.24 | 115.24 | 5500.0 |
| 2010-03-22 05:55:00 | SPY | ETF | 115.2 | 115.2 | 115.2 | 115.2 | 5000.0 |
| 2010-03-22 06:10:00 | SPY | ETF | 115.24 | 115.24 | 115.19 | 115.19 | 1400.0 |
| 2010-03-22 06:20:00 | SPY | ETF | 115.29 | 115.29 | 115.29 | 115.29 | 1000.0 |
| 2010-03-22 06:35:00 | SPY | ETF | 115.3 | 115.32 | 115.3 | 115.32 | 5000.0 |
| 2010-03-22 06:45:00 | SPY | ETF | 115.21 | 115.27 | 115.21 | 115.27 | 5200.0 |
| 2010-03-22 06:50:00 | SPY | ETF | 115.25 | 115.27 | 115.25 | 115.27 | 1237.0 |
| 2010-03-22 06:55:00 | SPY | ETF | 115.31 | 115.31 | 115.31 | 115.31 | 500.0 |
| 2010-03-22 07:00:00 | SPY | ETF | 115.36 | 115.36 | 115.36 | 115.36 | 28300.0 |
| 2010-03-22 07:05:00 | SPY | ETF | 115.39 | 115.39 | 115.35 | 115.35 | 2000.0 |
| 2010-03-22 07:10:00 | SPY | ETF | 115.35 | 115.36 | 115.33 | 115.34 | 24300.0 |
| 2010-03-22 07:15:00 | SPY | ETF | 115.33 | 115.34 | 115.33 | 115.33 | 5700.0 |
| 2010-03-22 07:20:00 | SPY | ETF | 115.34 | 115.34 | 115.31 | 115.34 | 9370.0 |
| 2010-03-22 07:25:00 | SPY | ETF | 115.34 | 115.38 | 115.34 | 115.36 | 32000.0 |
| 2010-03-22 07:30:00 | SPY | ETF | 115.35 | 115.39 | 115.35 | 115.36 | 35700.0 |
| 2010-03-22 07:35:00 | SPY | ETF | 115.36 | 115.37 | 115.3 | 115.3 | 184905.0 |
| 2010-03-22 07:40:00 | SPY | ETF | 115.3 | 115.3 | 115.25 | 115.26 | 119512.0 |
| 2010-03-22 07:45:00 | SPY | ETF | 115.25 | 115.31 | 115.25 | 115.3 | 176955.0 |
| 2010-03-22 07:50:00 | SPY | ETF | 115.29 | 115.3 | 115.28 | 115.28 | 16500.0 |
| 2010-03-22 07:55:00 | SPY | ETF | 115.28 | 115.28 | 115.21 | 115.25 | 237314.0 |
| 2010-03-22 08:00:00 | SPY | ETF | 115.26 | 115.27 | 115.24 | 115.25 | 81361.0 |
| 2010-03-22 08:05:00 | SPY | ETF | 115.24 | 116.1 | 115.24 | 115.32 | 133800.0 |
| 2010-03-22 08:10:00 | SPY | ETF | 115.33 | 115.34 | 115.31 | 115.34 | 75474.0 |
| 2010-03-22 08:15:00 | SPY | ETF | 115.34 | 115.36 | 115.33 | 115.35 | 65988.0 |
| 2010-03-22 08:20:00 | SPY | ETF | 115.35 | 115.42 | 115.35 | 115.42 | 137309.0 |
| 2010-03-22 08:25:00 | SPY | ETF | 115.42 | 115.45 | 115.41 | 115.45 | 271057.0 |
| 2010-03-22 08:30:00 | SPY | ETF | 115.43 | 115.47 | 115.42 | 115.46 | 326573.0 |
| 2010-03-22 08:35:00 | SPY | ETF | 115.46 | 115.48 | 115.45 | 115.46 | 129459.0 |
| 2010-03-22 08:40:00 | SPY | ETF | 115.46 | 115.48 | 115.44 | 115.45 | 485680.0 |
| 2010-03-22 08:45:00 | SPY | ETF | 115.45 | 115.6 | 115.33 | 115.34 | 259149.0 |
| 2010-03-22 08:50:00 | SPY | ETF | 115.34 | 115.36 | 115.32 | 115.32 | 167172.0 |
| 2010-03-22 08:55:00 | SPY | ETF | 115.31 | 115.34 | 115.28 | 115.28 | 98845.0 |
| 2010-03-22 09:00:00 | SPY | ETF | 115.29 | 115.31 | 115.28 | 115.29 | 149117.0 |
| 2010-03-22 09:05:00 | SPY | ETF | 115.29 | 115.36 | 115.27 | 115.35 | 191250.0 |
| 2010-03-22 09:10:00 | SPY | ETF | 115.35 | 115.35 | 115.3 | 115.3 | 232034.0 |
| 2010-03-22 09:15:00 | SPY | ETF | 115.31 | 115.39 | 115.27 | 115.36 | 384721.0 |
| 2010-03-22 09:20:00 | SPY | ETF | 115.37 | 115.38 | 115.32 | 115.36 | 183460.0 |
| 2010-03-22 09:25:00 | SPY | ETF | 115.37 | 115.38 | 115.29 | 115.3 | 443021.0 |
| 2010-03-22 09:30:00 | SPY | ETF | 115.31 | 115.44 | 115.24 | 115.42 | 6215650.0 |
| 2010-03-22 09:35:00 | SPY | ETF | 115.42 | 115.53 | 115.33 | 115.47 | 3477212.0 |
> showing 50 of 32,804 rows — these rows as CSV