PREVIEW / etf_1min / 2012-12-12
file: by_date/etf_1min/2012/2012-12-12.parquet size: 2.0 MB rows: 105,444
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-12 04:00:00 | SPY | ETF | 143.88 | 143.88 | 143.88 | 143.88 | 100.0 |
| 2012-12-12 04:01:00 | SPY | ETF | 144.0 | 144.0 | 144.0 | 144.0 | 100.0 |
| 2012-12-12 04:14:00 | SPY | ETF | 144.05 | 144.05 | 144.05 | 144.05 | 25000.0 |
| 2012-12-12 04:16:00 | SPY | ETF | 144.05 | 144.05 | 144.05 | 144.05 | 100.0 |
| 2012-12-12 04:20:00 | SPY | ETF | 144.05 | 144.05 | 144.05 | 144.05 | 10088.0 |
| 2012-12-12 04:21:00 | SPY | ETF | 144.05 | 144.05 | 144.05 | 144.05 | 10088.0 |
| 2012-12-12 04:22:00 | SPY | ETF | 144.05 | 144.05 | 144.02 | 144.02 | 400.0 |
| 2012-12-12 04:26:00 | SPY | ETF | 144.09 | 144.09 | 144.09 | 144.09 | 5000.0 |
| 2012-12-12 04:29:00 | SPY | ETF | 144.04 | 144.05 | 144.04 | 144.05 | 10500.0 |
| 2012-12-12 04:34:00 | SPY | ETF | 144.02 | 144.02 | 144.01 | 144.01 | 10000.0 |
| 2012-12-12 04:44:00 | SPY | ETF | 144.01 | 144.01 | 144.01 | 144.01 | 700.0 |
| 2012-12-12 04:51:00 | SPY | ETF | 144.03 | 144.03 | 144.03 | 144.03 | 200.0 |
| 2012-12-12 04:52:00 | SPY | ETF | 144.03 | 144.03 | 144.03 | 144.03 | 100.0 |
| 2012-12-12 05:08:00 | SPY | ETF | 144.07 | 144.07 | 144.07 | 144.07 | 200.0 |
| 2012-12-12 05:11:00 | SPY | ETF | 144.09 | 144.09 | 144.08 | 144.08 | 10500.0 |
| 2012-12-12 05:17:00 | SPY | ETF | 144.08 | 144.08 | 144.08 | 144.08 | 375.0 |
| 2012-12-12 05:19:00 | SPY | ETF | 144.05 | 144.05 | 144.05 | 144.05 | 100.0 |
| 2012-12-12 05:24:00 | SPY | ETF | 144.05 | 144.05 | 144.05 | 144.05 | 100.0 |
| 2012-12-12 05:33:00 | SPY | ETF | 143.98 | 143.98 | 143.98 | 143.98 | 200.0 |
| 2012-12-12 05:43:00 | SPY | ETF | 144.0 | 144.0 | 144.0 | 144.0 | 300.0 |
| 2012-12-12 05:44:00 | SPY | ETF | 144.02 | 144.02 | 144.02 | 144.02 | 1000.0 |
| 2012-12-12 05:53:00 | SPY | ETF | 143.95 | 143.95 | 143.95 | 143.95 | 9396.0 |
| 2012-12-12 05:56:00 | SPY | ETF | 144.03 | 144.03 | 144.03 | 144.03 | 200.0 |
| 2012-12-12 05:58:00 | SPY | ETF | 143.97 | 143.97 | 143.97 | 143.97 | 100.0 |
| 2012-12-12 06:07:00 | SPY | ETF | 143.97 | 143.97 | 143.97 | 143.97 | 280.0 |
| 2012-12-12 06:09:00 | SPY | ETF | 144.0 | 144.0 | 144.0 | 144.0 | 100.0 |
| 2012-12-12 06:10:00 | SPY | ETF | 143.97 | 143.97 | 143.97 | 143.97 | 100.0 |
| 2012-12-12 06:24:00 | SPY | ETF | 143.97 | 143.97 | 143.97 | 143.97 | 200.0 |
| 2012-12-12 06:29:00 | SPY | ETF | 143.99 | 143.99 | 143.99 | 143.99 | 200.0 |
| 2012-12-12 06:37:00 | SPY | ETF | 143.98 | 143.98 | 143.98 | 143.98 | 240.0 |
| 2012-12-12 06:39:00 | SPY | ETF | 143.97 | 143.97 | 143.97 | 143.97 | 1000.0 |
| 2012-12-12 06:43:00 | SPY | ETF | 143.98 | 143.98 | 143.98 | 143.98 | 2975.0 |
| 2012-12-12 06:44:00 | SPY | ETF | 143.98 | 143.98 | 143.98 | 143.98 | 7000.0 |
| 2012-12-12 06:46:00 | SPY | ETF | 143.96 | 143.96 | 143.96 | 143.96 | 24800.0 |
| 2012-12-12 06:49:00 | SPY | ETF | 143.92 | 143.92 | 143.92 | 143.92 | 100.0 |
| 2012-12-12 06:51:00 | SPY | ETF | 143.96 | 143.96 | 143.96 | 143.96 | 100.0 |
| 2012-12-12 06:52:00 | SPY | ETF | 143.95 | 143.96 | 143.95 | 143.96 | 400.0 |
| 2012-12-12 06:53:00 | SPY | ETF | 143.96 | 143.96 | 143.96 | 143.96 | 100.0 |
| 2012-12-12 06:54:00 | SPY | ETF | 143.97 | 143.97 | 143.97 | 143.97 | 100.0 |
| 2012-12-12 06:57:00 | SPY | ETF | 143.96 | 143.96 | 143.95 | 143.96 | 734.0 |
| 2012-12-12 07:00:00 | SPY | ETF | 143.98 | 143.98 | 143.96 | 143.96 | 1800.0 |
| 2012-12-12 07:01:00 | SPY | ETF | 143.93 | 143.93 | 143.93 | 143.93 | 500.0 |
| 2012-12-12 07:02:00 | SPY | ETF | 143.94 | 143.94 | 143.94 | 143.94 | 100.0 |
| 2012-12-12 07:03:00 | SPY | ETF | 143.95 | 143.96 | 143.95 | 143.95 | 1433.0 |
| 2012-12-12 07:04:00 | SPY | ETF | 143.98 | 143.98 | 143.98 | 143.98 | 200.0 |
| 2012-12-12 07:05:00 | SPY | ETF | 144.0 | 144.0 | 144.0 | 144.0 | 289.0 |
| 2012-12-12 07:06:00 | SPY | ETF | 143.98 | 143.98 | 143.98 | 143.98 | 100.0 |
| 2012-12-12 07:07:00 | SPY | ETF | 144.0 | 144.0 | 144.0 | 144.0 | 311.0 |
| 2012-12-12 07:08:00 | SPY | ETF | 144.03 | 144.03 | 144.03 | 144.03 | 200.0 |
| 2012-12-12 07:09:00 | SPY | ETF | 144.0 | 144.03 | 144.0 | 144.03 | 1100.0 |
> showing 50 of 105,444 rows — these rows as CSV