PREVIEW / etf_5min / 2012-07-16
file: by_date/etf_5min/2012/2012-07-16.parquet size: 805 KB rows: 33,725
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 |
|---|---|---|---|---|---|---|---|
| 2012-07-16 04:00:00 | SPY | ETF | 135.53 | 135.53 | 135.53 | 135.53 | 200.0 |
| 2012-07-16 04:05:00 | SPY | ETF | 135.47 | 135.47 | 135.47 | 135.47 | 100.0 |
| 2012-07-16 04:35:00 | SPY | ETF | 135.55 | 135.55 | 135.55 | 135.55 | 2100.0 |
| 2012-07-16 04:40:00 | SPY | ETF | 135.5 | 135.5 | 135.5 | 135.5 | 1000.0 |
| 2012-07-16 04:45:00 | SPY | ETF | 135.4 | 135.4 | 135.4 | 135.4 | 150.0 |
| 2012-07-16 04:55:00 | SPY | ETF | 135.37 | 135.37 | 135.37 | 135.37 | 3200.0 |
| 2012-07-16 05:05:00 | SPY | ETF | 135.45 | 135.5 | 135.45 | 135.5 | 10000.0 |
| 2012-07-16 05:10:00 | SPY | ETF | 135.4 | 135.4 | 135.4 | 135.4 | 200.0 |
| 2012-07-16 05:15:00 | SPY | ETF | 135.36 | 135.36 | 135.36 | 135.36 | 1100.0 |
| 2012-07-16 05:20:00 | SPY | ETF | 135.37 | 135.37 | 135.35 | 135.36 | 1500.0 |
| 2012-07-16 05:25:00 | SPY | ETF | 135.42 | 135.42 | 135.42 | 135.42 | 600.0 |
| 2012-07-16 05:30:00 | SPY | ETF | 135.4 | 135.4 | 135.37 | 135.37 | 2100.0 |
| 2012-07-16 05:40:00 | SPY | ETF | 135.34 | 135.34 | 135.31 | 135.31 | 1100.0 |
| 2012-07-16 05:45:00 | SPY | ETF | 135.29 | 135.3 | 135.29 | 135.3 | 2200.0 |
| 2012-07-16 05:50:00 | SPY | ETF | 135.32 | 135.35 | 135.32 | 135.35 | 400.0 |
| 2012-07-16 05:55:00 | SPY | ETF | 135.35 | 135.35 | 135.35 | 135.35 | 300.0 |
| 2012-07-16 06:00:00 | SPY | ETF | 135.35 | 135.35 | 135.34 | 135.34 | 4200.0 |
| 2012-07-16 06:05:00 | SPY | ETF | 135.4 | 135.4 | 135.4 | 135.4 | 500.0 |
| 2012-07-16 06:10:00 | SPY | ETF | 135.42 | 135.42 | 135.42 | 135.42 | 200.0 |
| 2012-07-16 06:15:00 | SPY | ETF | 135.47 | 135.47 | 135.47 | 135.47 | 200.0 |
| 2012-07-16 06:25:00 | SPY | ETF | 135.46 | 135.47 | 135.46 | 135.47 | 400.0 |
| 2012-07-16 06:30:00 | SPY | ETF | 135.52 | 135.52 | 135.52 | 135.52 | 1000.0 |
| 2012-07-16 06:35:00 | SPY | ETF | 135.46 | 135.46 | 135.46 | 135.46 | 5000.0 |
| 2012-07-16 06:40:00 | SPY | ETF | 135.55 | 135.55 | 135.54 | 135.54 | 200.0 |
| 2012-07-16 06:45:00 | SPY | ETF | 135.49 | 135.5 | 135.49 | 135.5 | 2200.0 |
| 2012-07-16 06:50:00 | SPY | ETF | 135.49 | 135.49 | 135.49 | 135.49 | 1100.0 |
| 2012-07-16 06:55:00 | SPY | ETF | 135.43 | 135.43 | 135.41 | 135.41 | 250.0 |
| 2012-07-16 07:00:00 | SPY | ETF | 135.38 | 135.43 | 135.36 | 135.43 | 12484.0 |
| 2012-07-16 07:05:00 | SPY | ETF | 135.45 | 135.47 | 135.43 | 135.43 | 11600.0 |
| 2012-07-16 07:10:00 | SPY | ETF | 135.47 | 135.48 | 135.47 | 135.48 | 600.0 |
| 2012-07-16 07:15:00 | SPY | ETF | 135.45 | 135.45 | 135.42 | 135.42 | 5600.0 |
| 2012-07-16 07:20:00 | SPY | ETF | 135.4 | 135.42 | 135.4 | 135.4 | 17000.0 |
| 2012-07-16 07:25:00 | SPY | ETF | 135.4 | 135.4 | 135.4 | 135.4 | 20200.0 |
| 2012-07-16 07:30:00 | SPY | ETF | 135.4 | 135.4 | 135.38 | 135.38 | 2750.0 |
| 2012-07-16 07:35:00 | SPY | ETF | 135.4 | 135.4 | 135.39 | 135.39 | 1109.0 |
| 2012-07-16 07:40:00 | SPY | ETF | 135.41 | 135.47 | 135.41 | 135.47 | 18451.0 |
| 2012-07-16 07:45:00 | SPY | ETF | 135.44 | 135.46 | 135.42 | 135.45 | 28100.0 |
| 2012-07-16 07:50:00 | SPY | ETF | 135.44 | 135.47 | 135.44 | 135.45 | 1700.0 |
| 2012-07-16 07:55:00 | SPY | ETF | 135.45 | 135.45 | 135.41 | 135.43 | 16172.0 |
| 2012-07-16 08:00:00 | SPY | ETF | 135.42 | 135.47 | 135.38 | 135.41 | 178713.0 |
| 2012-07-16 08:05:00 | SPY | ETF | 135.38 | 135.45 | 135.34 | 135.36 | 516625.0 |
| 2012-07-16 08:10:00 | SPY | ETF | 135.38 | 135.4 | 135.32 | 135.33 | 51595.0 |
| 2012-07-16 08:15:00 | SPY | ETF | 135.32 | 135.32 | 135.26 | 135.32 | 73202.0 |
| 2012-07-16 08:20:00 | SPY | ETF | 135.31 | 135.34 | 135.27 | 135.34 | 56748.0 |
| 2012-07-16 08:25:00 | SPY | ETF | 135.32 | 135.37 | 135.3 | 135.37 | 97985.0 |
| 2012-07-16 08:30:00 | SPY | ETF | 135.36 | 135.43 | 135.2 | 135.38 | 345538.0 |
| 2012-07-16 08:35:00 | SPY | ETF | 135.37 | 135.43 | 135.34 | 135.39 | 65790.0 |
| 2012-07-16 08:40:00 | SPY | ETF | 135.4 | 135.43 | 135.26 | 135.29 | 76990.0 |
| 2012-07-16 08:45:00 | SPY | ETF | 135.29 | 135.33 | 135.27 | 135.3 | 42782.0 |
| 2012-07-16 08:50:00 | SPY | ETF | 135.31 | 135.34 | 135.25 | 135.34 | 95109.0 |
> showing 50 of 33,725 rows — these rows as CSV