PREVIEW / etf_1min / 2012-12-06
file: by_date/etf_1min/2012/2012-12-06.parquet size: 1.8 MB rows: 99,966
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-12-06 04:00:00 | SPY | ETF | 141.11 | 141.45 | 141.11 | 141.45 | 425.0 |
| 2012-12-06 04:01:00 | SPY | ETF | 141.46 | 141.5 | 141.46 | 141.5 | 200.0 |
| 2012-12-06 04:12:00 | SPY | ETF | 141.6 | 141.6 | 141.6 | 141.6 | 952.0 |
| 2012-12-06 04:20:00 | SPY | ETF | 141.73 | 141.73 | 141.73 | 141.73 | 10000.0 |
| 2012-12-06 04:34:00 | SPY | ETF | 141.69 | 141.69 | 141.69 | 141.69 | 100.0 |
| 2012-12-06 04:47:00 | SPY | ETF | 141.68 | 141.68 | 141.68 | 141.68 | 100.0 |
| 2012-12-06 04:49:00 | SPY | ETF | 141.68 | 141.68 | 141.68 | 141.68 | 5000.0 |
| 2012-12-06 05:05:00 | SPY | ETF | 141.67 | 141.67 | 141.67 | 141.67 | 9000.0 |
| 2012-12-06 05:07:00 | SPY | ETF | 141.67 | 141.67 | 141.67 | 141.67 | 9000.0 |
| 2012-12-06 05:09:00 | SPY | ETF | 141.69 | 141.69 | 141.69 | 141.69 | 2358.0 |
| 2012-12-06 05:22:00 | SPY | ETF | 141.62 | 141.63 | 141.62 | 141.63 | 5100.0 |
| 2012-12-06 05:26:00 | SPY | ETF | 141.65 | 141.65 | 141.65 | 141.65 | 100.0 |
| 2012-12-06 05:28:00 | SPY | ETF | 141.6 | 141.6 | 141.6 | 141.6 | 1000.0 |
| 2012-12-06 05:29:00 | SPY | ETF | 141.58 | 141.58 | 141.58 | 141.58 | 500.0 |
| 2012-12-06 05:55:00 | SPY | ETF | 141.58 | 141.59 | 141.58 | 141.59 | 5200.0 |
| 2012-12-06 06:00:00 | SPY | ETF | 141.63 | 141.63 | 141.63 | 141.63 | 200.0 |
| 2012-12-06 06:05:00 | SPY | ETF | 141.65 | 141.65 | 141.65 | 141.65 | 1000.0 |
| 2012-12-06 06:21:00 | SPY | ETF | 141.55 | 141.55 | 141.55 | 141.55 | 200.0 |
| 2012-12-06 06:22:00 | SPY | ETF | 141.53 | 141.53 | 141.49 | 141.49 | 980.0 |
| 2012-12-06 06:23:00 | SPY | ETF | 141.49 | 141.49 | 141.49 | 141.49 | 5000.0 |
| 2012-12-06 06:24:00 | SPY | ETF | 141.5 | 141.5 | 141.5 | 141.5 | 1000.0 |
| 2012-12-06 06:25:00 | SPY | ETF | 141.47 | 141.47 | 141.47 | 141.47 | 500.0 |
| 2012-12-06 06:26:00 | SPY | ETF | 141.45 | 141.45 | 141.45 | 141.45 | 180.0 |
| 2012-12-06 06:29:00 | SPY | ETF | 141.4 | 141.4 | 141.4 | 141.4 | 100.0 |
| 2012-12-06 06:33:00 | SPY | ETF | 141.49 | 141.49 | 141.49 | 141.49 | 500.0 |
| 2012-12-06 06:37:00 | SPY | ETF | 141.48 | 141.48 | 141.48 | 141.48 | 4000.0 |
| 2012-12-06 06:42:00 | SPY | ETF | 141.37 | 141.38 | 141.37 | 141.37 | 11900.0 |
| 2012-12-06 06:43:00 | SPY | ETF | 141.35 | 141.35 | 141.34 | 141.35 | 550.0 |
| 2012-12-06 06:49:00 | SPY | ETF | 141.29 | 141.29 | 141.29 | 141.29 | 3000.0 |
| 2012-12-06 06:51:00 | SPY | ETF | 141.35 | 141.35 | 141.35 | 141.35 | 200.0 |
| 2012-12-06 06:57:00 | SPY | ETF | 141.32 | 141.32 | 141.32 | 141.32 | 100.0 |
| 2012-12-06 07:00:00 | SPY | ETF | 141.31 | 141.35 | 141.31 | 141.35 | 1538.0 |
| 2012-12-06 07:04:00 | SPY | ETF | 141.39 | 141.39 | 141.39 | 141.39 | 173.0 |
| 2012-12-06 07:05:00 | SPY | ETF | 141.39 | 141.46 | 141.39 | 141.46 | 4845.0 |
| 2012-12-06 07:07:00 | SPY | ETF | 141.5 | 141.5 | 141.49 | 141.49 | 5790.0 |
| 2012-12-06 07:08:00 | SPY | ETF | 141.5 | 141.5 | 141.5 | 141.5 | 600.0 |
| 2012-12-06 07:09:00 | SPY | ETF | 141.5 | 141.5 | 141.5 | 141.5 | 2300.0 |
| 2012-12-06 07:11:00 | SPY | ETF | 141.51 | 141.51 | 141.5 | 141.5 | 5000.0 |
| 2012-12-06 07:12:00 | SPY | ETF | 141.48 | 141.48 | 141.48 | 141.48 | 300.0 |
| 2012-12-06 07:16:00 | SPY | ETF | 141.44 | 141.44 | 141.38 | 141.38 | 1245.0 |
| 2012-12-06 07:17:00 | SPY | ETF | 141.4 | 141.4 | 141.37 | 141.37 | 700.0 |
| 2012-12-06 07:18:00 | SPY | ETF | 141.37 | 141.37 | 141.32 | 141.32 | 2156.0 |
| 2012-12-06 07:19:00 | SPY | ETF | 141.34 | 141.35 | 141.32 | 141.35 | 9600.0 |
| 2012-12-06 07:20:00 | SPY | ETF | 141.33 | 141.33 | 141.32 | 141.32 | 10000.0 |
| 2012-12-06 07:21:00 | SPY | ETF | 141.35 | 141.35 | 141.35 | 141.35 | 100.0 |
| 2012-12-06 07:22:00 | SPY | ETF | 141.35 | 141.35 | 141.35 | 141.35 | 200.0 |
| 2012-12-06 07:24:00 | SPY | ETF | 141.37 | 141.37 | 141.37 | 141.37 | 30000.0 |
| 2012-12-06 07:26:00 | SPY | ETF | 141.4 | 141.41 | 141.4 | 141.41 | 8100.0 |
| 2012-12-06 07:27:00 | SPY | ETF | 141.43 | 141.43 | 141.43 | 141.43 | 5100.0 |
| 2012-12-06 07:29:00 | SPY | ETF | 141.49 | 141.5 | 141.49 | 141.5 | 600.0 |
> showing 50 of 99,966 rows — these rows as CSV