PREVIEW / etf_5min / 2010-01-07
file: by_date/etf_5min/2010/2010-01-07.parquet size: 744 KB rows: 31,988
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-01-07 04:15:00 | SPY | ETF | 113.43 | 113.43 | 113.43 | 113.43 | 100.0 |
| 2010-01-07 04:45:00 | SPY | ETF | 113.38 | 113.38 | 113.38 | 113.38 | 100.0 |
| 2010-01-07 04:50:00 | SPY | ETF | 113.3 | 113.3 | 113.3 | 113.3 | 100.0 |
| 2010-01-07 04:55:00 | SPY | ETF | 113.26 | 113.26 | 113.2 | 113.2 | 463.0 |
| 2010-01-07 05:20:00 | SPY | ETF | 113.21 | 113.21 | 113.2 | 113.2 | 200.0 |
| 2010-01-07 05:35:00 | SPY | ETF | 113.3 | 113.3 | 113.3 | 113.3 | 100.0 |
| 2010-01-07 05:45:00 | SPY | ETF | 113.29 | 113.3 | 113.29 | 113.3 | 20000.0 |
| 2010-01-07 05:50:00 | SPY | ETF | 113.28 | 113.29 | 113.28 | 113.29 | 10100.0 |
| 2010-01-07 06:00:00 | SPY | ETF | 113.29 | 113.29 | 113.29 | 113.29 | 2000.0 |
| 2010-01-07 06:05:00 | SPY | ETF | 113.27 | 113.27 | 113.27 | 113.27 | 100.0 |
| 2010-01-07 06:15:00 | SPY | ETF | 113.25 | 113.31 | 113.25 | 113.31 | 4200.0 |
| 2010-01-07 06:20:00 | SPY | ETF | 113.36 | 113.36 | 113.35 | 113.36 | 5100.0 |
| 2010-01-07 07:00:00 | SPY | ETF | 113.35 | 113.39 | 113.3 | 113.3 | 2700.0 |
| 2010-01-07 07:05:00 | SPY | ETF | 113.35 | 113.35 | 113.3 | 113.3 | 12650.0 |
| 2010-01-07 07:10:00 | SPY | ETF | 113.3 | 113.4 | 113.3 | 113.4 | 14200.0 |
| 2010-01-07 07:15:00 | SPY | ETF | 113.39 | 113.41 | 113.39 | 113.41 | 700.0 |
| 2010-01-07 07:20:00 | SPY | ETF | 113.39 | 113.41 | 113.39 | 113.39 | 5500.0 |
| 2010-01-07 07:25:00 | SPY | ETF | 113.43 | 113.43 | 113.39 | 113.4 | 22700.0 |
| 2010-01-07 07:30:00 | SPY | ETF | 113.4 | 113.41 | 113.3 | 113.3 | 175959.0 |
| 2010-01-07 07:35:00 | SPY | ETF | 113.3 | 113.34 | 113.28 | 113.34 | 246458.0 |
| 2010-01-07 07:40:00 | SPY | ETF | 113.37 | 113.37 | 113.34 | 113.37 | 121500.0 |
| 2010-01-07 07:45:00 | SPY | ETF | 113.37 | 113.41 | 113.34 | 113.34 | 31670.0 |
| 2010-01-07 07:50:00 | SPY | ETF | 113.35 | 113.37 | 113.31 | 113.33 | 159704.0 |
| 2010-01-07 07:55:00 | SPY | ETF | 113.36 | 113.37 | 113.31 | 113.31 | 127039.0 |
| 2010-01-07 08:00:00 | SPY | ETF | 113.31 | 113.55 | 113.31 | 113.36 | 1387872.0 |
| 2010-01-07 08:05:00 | SPY | ETF | 113.36 | 113.43 | 113.33 | 113.41 | 611400.0 |
| 2010-01-07 08:10:00 | SPY | ETF | 113.42 | 113.48 | 113.37 | 113.37 | 107021.0 |
| 2010-01-07 08:15:00 | SPY | ETF | 113.37 | 113.41 | 113.36 | 113.4 | 151489.0 |
| 2010-01-07 08:20:00 | SPY | ETF | 113.39 | 113.73 | 113.36 | 113.38 | 352950.0 |
| 2010-01-07 08:25:00 | SPY | ETF | 113.37 | 113.46 | 113.31 | 113.39 | 738408.0 |
| 2010-01-07 08:30:00 | SPY | ETF | 113.39 | 113.48 | 113.34 | 113.41 | 240363.0 |
| 2010-01-07 08:35:00 | SPY | ETF | 113.41 | 113.47 | 113.38 | 113.47 | 233608.0 |
| 2010-01-07 08:40:00 | SPY | ETF | 113.47 | 113.48 | 113.46 | 113.48 | 172608.0 |
| 2010-01-07 08:45:00 | SPY | ETF | 113.47 | 113.52 | 113.47 | 113.5 | 358731.0 |
| 2010-01-07 08:50:00 | SPY | ETF | 113.5 | 113.54 | 113.48 | 113.5 | 219363.0 |
| 2010-01-07 08:55:00 | SPY | ETF | 113.5 | 113.51 | 113.45 | 113.48 | 106017.0 |
| 2010-01-07 09:00:00 | SPY | ETF | 113.49 | 113.5 | 113.46 | 113.47 | 61636.0 |
| 2010-01-07 09:05:00 | SPY | ETF | 113.47 | 113.49 | 113.45 | 113.48 | 118721.0 |
| 2010-01-07 09:10:00 | SPY | ETF | 113.48 | 113.5 | 113.46 | 113.5 | 51694.0 |
| 2010-01-07 09:15:00 | SPY | ETF | 113.5 | 113.55 | 113.5 | 113.54 | 127201.0 |
| 2010-01-07 09:20:00 | SPY | ETF | 113.54 | 113.55 | 113.51 | 113.51 | 60743.0 |
| 2010-01-07 09:25:00 | SPY | ETF | 113.52 | 113.52 | 113.48 | 113.51 | 234279.0 |
| 2010-01-07 09:30:00 | SPY | ETF | 113.5 | 113.64 | 113.42 | 113.6 | 3366130.0 |
| 2010-01-07 09:35:00 | SPY | ETF | 113.59 | 113.69 | 113.54 | 113.635 | 2378274.0 |
| 2010-01-07 09:40:00 | SPY | ETF | 113.63 | 113.68 | 113.55 | 113.6 | 1334647.0 |
| 2010-01-07 09:45:00 | SPY | ETF | 113.6001 | 113.65 | 113.44 | 113.48 | 2137207.0 |
| 2010-01-07 09:50:00 | SPY | ETF | 113.47 | 113.5 | 113.26 | 113.31 | 4129791.0 |
| 2010-01-07 09:55:00 | SPY | ETF | 113.3 | 113.33 | 113.18 | 113.24 | 2907096.0 |
| 2010-01-07 10:00:00 | SPY | ETF | 113.2 | 113.34 | 113.2 | 113.32 | 1512799.0 |
| 2010-01-07 10:05:00 | SPY | ETF | 113.32 | 113.39 | 113.28 | 113.39 | 1324032.0 |
> showing 50 of 31,988 rows — these rows as CSV