PREVIEW / etf_5min / 2012-03-12
file: by_date/etf_5min/2012/2012-03-12.parquet size: 799 KB rows: 35,229
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-03-12 04:15:00 | SPY | ETF | 137.22 | 137.22 | 137.22 | 137.22 | 380.0 |
| 2012-03-12 04:25:00 | SPY | ETF | 137.21 | 137.21 | 137.21 | 137.21 | 500.0 |
| 2012-03-12 04:30:00 | SPY | ETF | 137.2 | 137.2 | 137.2 | 137.2 | 200.0 |
| 2012-03-12 04:50:00 | SPY | ETF | 137.31 | 137.38 | 137.31 | 137.31 | 22000.0 |
| 2012-03-12 04:55:00 | SPY | ETF | 137.38 | 137.38 | 137.38 | 137.38 | 500.0 |
| 2012-03-12 05:05:00 | SPY | ETF | 137.57 | 137.57 | 137.57 | 137.57 | 8000.0 |
| 2012-03-12 05:20:00 | SPY | ETF | 137.63 | 137.68 | 137.63 | 137.68 | 1800.0 |
| 2012-03-12 05:25:00 | SPY | ETF | 137.65 | 137.66 | 137.65 | 137.66 | 900.0 |
| 2012-03-12 05:35:00 | SPY | ETF | 137.67 | 137.67 | 137.67 | 137.67 | 200.0 |
| 2012-03-12 05:55:00 | SPY | ETF | 137.68 | 137.68 | 137.68 | 137.68 | 7500.0 |
| 2012-03-12 06:35:00 | SPY | ETF | 137.63 | 137.63 | 137.63 | 137.63 | 100.0 |
| 2012-03-12 06:45:00 | SPY | ETF | 137.61 | 137.63 | 137.61 | 137.63 | 600.0 |
| 2012-03-12 06:50:00 | SPY | ETF | 137.61 | 137.65 | 137.6 | 137.65 | 20000.0 |
| 2012-03-12 06:55:00 | SPY | ETF | 137.57 | 137.57 | 137.57 | 137.57 | 2000.0 |
| 2012-03-12 07:00:00 | SPY | ETF | 137.55 | 137.6 | 137.55 | 137.56 | 1989.0 |
| 2012-03-12 07:05:00 | SPY | ETF | 137.54 | 137.63 | 137.5 | 137.6 | 54990.0 |
| 2012-03-12 07:10:00 | SPY | ETF | 137.59 | 137.64 | 137.59 | 137.62 | 11110.0 |
| 2012-03-12 07:15:00 | SPY | ETF | 137.61 | 137.61 | 137.6 | 137.6 | 2100.0 |
| 2012-03-12 07:20:00 | SPY | ETF | 137.57 | 137.59 | 137.52 | 137.59 | 1100.0 |
| 2012-03-12 07:25:00 | SPY | ETF | 137.62 | 137.63 | 137.62 | 137.63 | 2400.0 |
| 2012-03-12 07:30:00 | SPY | ETF | 137.59 | 137.6 | 137.57 | 137.57 | 3750.0 |
| 2012-03-12 07:35:00 | SPY | ETF | 137.6 | 137.6 | 137.58 | 137.58 | 1200.0 |
| 2012-03-12 07:40:00 | SPY | ETF | 137.54 | 137.54 | 137.47 | 137.52 | 42590.0 |
| 2012-03-12 07:45:00 | SPY | ETF | 137.52 | 137.55 | 137.5 | 137.55 | 73400.0 |
| 2012-03-12 07:50:00 | SPY | ETF | 137.55 | 137.55 | 137.5 | 137.53 | 46100.0 |
| 2012-03-12 07:55:00 | SPY | ETF | 137.5 | 137.53 | 137.5 | 137.53 | 12000.0 |
| 2012-03-12 08:00:00 | SPY | ETF | 137.53 | 137.65 | 137.53 | 137.54 | 89300.0 |
| 2012-03-12 08:05:00 | SPY | ETF | 137.53 | 137.55 | 137.48 | 137.48 | 42200.0 |
| 2012-03-12 08:10:00 | SPY | ETF | 137.48 | 137.48 | 137.39 | 137.41 | 48008.0 |
| 2012-03-12 08:15:00 | SPY | ETF | 137.41 | 137.46 | 137.4 | 137.46 | 66495.0 |
| 2012-03-12 08:20:00 | SPY | ETF | 137.43 | 137.46 | 137.37 | 137.37 | 42815.0 |
| 2012-03-12 08:25:00 | SPY | ETF | 137.37 | 137.37 | 137.3 | 137.33 | 78600.0 |
| 2012-03-12 08:30:00 | SPY | ETF | 137.32 | 137.36 | 137.28 | 137.31 | 139550.0 |
| 2012-03-12 08:35:00 | SPY | ETF | 137.3 | 137.37 | 137.29 | 137.33 | 125653.0 |
| 2012-03-12 08:40:00 | SPY | ETF | 137.35 | 137.46 | 137.34 | 137.35 | 84300.0 |
| 2012-03-12 08:45:00 | SPY | ETF | 137.35 | 137.36 | 137.3 | 137.33 | 53763.0 |
| 2012-03-12 08:50:00 | SPY | ETF | 137.33 | 137.38 | 137.25 | 137.35 | 70914.0 |
| 2012-03-12 08:55:00 | SPY | ETF | 137.35 | 137.48 | 137.34 | 137.48 | 61433.0 |
| 2012-03-12 09:00:00 | SPY | ETF | 137.47 | 137.53 | 137.46 | 137.5 | 98570.0 |
| 2012-03-12 09:05:00 | SPY | ETF | 137.51 | 137.67 | 137.51 | 137.67 | 207429.0 |
| 2012-03-12 09:10:00 | SPY | ETF | 137.66 | 137.66 | 137.57 | 137.59 | 160785.0 |
| 2012-03-12 09:15:00 | SPY | ETF | 137.58 | 137.59 | 137.55 | 137.57 | 57400.0 |
| 2012-03-12 09:20:00 | SPY | ETF | 137.57 | 137.6 | 137.56 | 137.58 | 230313.0 |
| 2012-03-12 09:25:00 | SPY | ETF | 137.57 | 137.61 | 137.53 | 137.55 | 88094.0 |
| 2012-03-12 09:30:00 | SPY | ETF | 137.55 | 137.59 | 137.39 | 137.43 | 2562843.0 |
| 2012-03-12 09:35:00 | SPY | ETF | 137.43 | 137.66 | 137.41 | 137.63 | 2528562.0 |
| 2012-03-12 09:40:00 | SPY | ETF | 137.62 | 137.76 | 137.62 | 137.66 | 1937078.0 |
| 2012-03-12 09:45:00 | SPY | ETF | 137.66 | 137.71 | 137.52 | 137.52 | 2170075.0 |
| 2012-03-12 09:50:00 | SPY | ETF | 137.52 | 137.57 | 137.42 | 137.56 | 2455748.0 |
| 2012-03-12 09:55:00 | SPY | ETF | 137.5601 | 137.605 | 137.47 | 137.52 | 1300169.0 |
> showing 50 of 35,229 rows — these rows as CSV