PREVIEW / etf_1min / 2014-12-22
file: by_date/etf_1min/2014/2014-12-22.parquet size: 2.6 MB rows: 137,259
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 |
|---|---|---|---|---|---|---|---|
| 2014-12-22 04:00:00 | SPY | ETF | 207.12 | 207.17 | 207.12 | 207.17 | 3500.0 |
| 2014-12-22 04:01:00 | SPY | ETF | 207.23 | 207.23 | 207.23 | 207.23 | 13579.0 |
| 2014-12-22 04:02:00 | SPY | ETF | 207.21 | 207.23 | 207.21 | 207.23 | 6000.0 |
| 2014-12-22 04:04:00 | SPY | ETF | 207.23 | 207.23 | 207.23 | 207.23 | 5000.0 |
| 2014-12-22 04:09:00 | SPY | ETF | 207.16 | 207.19 | 207.16 | 207.19 | 5500.0 |
| 2014-12-22 04:11:00 | SPY | ETF | 207.12 | 207.12 | 207.12 | 207.12 | 100.0 |
| 2014-12-22 04:17:00 | SPY | ETF | 207.08 | 207.08 | 207.08 | 207.08 | 400.0 |
| 2014-12-22 04:32:00 | SPY | ETF | 207.08 | 207.08 | 207.08 | 207.08 | 350.0 |
| 2014-12-22 04:40:00 | SPY | ETF | 207.08 | 207.08 | 207.08 | 207.08 | 700.0 |
| 2014-12-22 04:46:00 | SPY | ETF | 207.1 | 207.1 | 207.1 | 207.1 | 300.0 |
| 2014-12-22 05:05:00 | SPY | ETF | 207.0 | 207.0 | 207.0 | 207.0 | 100.0 |
| 2014-12-22 05:59:00 | SPY | ETF | 207.02 | 207.02 | 207.02 | 207.02 | 200.0 |
| 2014-12-22 06:06:00 | SPY | ETF | 207.05 | 207.05 | 207.05 | 207.05 | 250.0 |
| 2014-12-22 06:09:00 | SPY | ETF | 207.09 | 207.09 | 207.09 | 207.09 | 100.0 |
| 2014-12-22 06:11:00 | SPY | ETF | 207.1 | 207.1 | 207.1 | 207.1 | 300.0 |
| 2014-12-22 06:12:00 | SPY | ETF | 207.1 | 207.1 | 207.1 | 207.1 | 100.0 |
| 2014-12-22 06:13:00 | SPY | ETF | 207.09 | 207.09 | 207.09 | 207.09 | 600.0 |
| 2014-12-22 06:14:00 | SPY | ETF | 207.1 | 207.13 | 207.1 | 207.12 | 700.0 |
| 2014-12-22 06:17:00 | SPY | ETF | 207.13 | 207.13 | 207.13 | 207.13 | 700.0 |
| 2014-12-22 06:20:00 | SPY | ETF | 207.12 | 207.12 | 207.12 | 207.12 | 300.0 |
| 2014-12-22 06:23:00 | SPY | ETF | 207.09 | 207.09 | 207.09 | 207.09 | 300.0 |
| 2014-12-22 06:27:00 | SPY | ETF | 207.09 | 207.09 | 207.09 | 207.09 | 300.0 |
| 2014-12-22 06:41:00 | SPY | ETF | 206.99 | 206.99 | 206.99 | 206.99 | 1010.0 |
| 2014-12-22 06:43:00 | SPY | ETF | 206.99 | 206.99 | 206.99 | 206.99 | 300.0 |
| 2014-12-22 06:45:00 | SPY | ETF | 206.94 | 206.94 | 206.94 | 206.94 | 2200.0 |
| 2014-12-22 06:46:00 | SPY | ETF | 206.97 | 206.97 | 206.97 | 206.97 | 500.0 |
| 2014-12-22 06:47:00 | SPY | ETF | 206.95 | 206.99 | 206.95 | 206.97 | 3100.0 |
| 2014-12-22 06:48:00 | SPY | ETF | 206.97 | 206.97 | 206.97 | 206.97 | 4200.0 |
| 2014-12-22 06:54:00 | SPY | ETF | 206.97 | 206.97 | 206.97 | 206.97 | 100.0 |
| 2014-12-22 06:57:00 | SPY | ETF | 207.08 | 207.08 | 207.08 | 207.08 | 150.0 |
| 2014-12-22 07:04:00 | SPY | ETF | 206.9 | 206.95 | 206.88 | 206.88 | 1370.0 |
| 2014-12-22 07:05:00 | SPY | ETF | 206.87 | 206.87 | 206.87 | 206.87 | 800.0 |
| 2014-12-22 07:08:00 | SPY | ETF | 206.94 | 206.94 | 206.94 | 206.94 | 1000.0 |
| 2014-12-22 07:10:00 | SPY | ETF | 206.83 | 206.83 | 206.83 | 206.83 | 2500.0 |
| 2014-12-22 07:11:00 | SPY | ETF | 206.83 | 206.83 | 206.8 | 206.8 | 600.0 |
| 2014-12-22 07:14:00 | SPY | ETF | 206.8 | 206.81 | 206.8 | 206.81 | 200.0 |
| 2014-12-22 07:23:00 | SPY | ETF | 206.9 | 206.9 | 206.9 | 206.9 | 700.0 |
| 2014-12-22 07:24:00 | SPY | ETF | 206.92 | 206.92 | 206.92 | 206.92 | 249.0 |
| 2014-12-22 07:25:00 | SPY | ETF | 206.96 | 206.96 | 206.91 | 206.91 | 1054.0 |
| 2014-12-22 07:26:00 | SPY | ETF | 206.95 | 206.95 | 206.95 | 206.95 | 6100.0 |
| 2014-12-22 07:27:00 | SPY | ETF | 206.95 | 206.98 | 206.95 | 206.98 | 500.0 |
| 2014-12-22 07:28:00 | SPY | ETF | 206.95 | 206.95 | 206.95 | 206.95 | 100.0 |
| 2014-12-22 07:29:00 | SPY | ETF | 206.95 | 206.95 | 206.95 | 206.95 | 100.0 |
| 2014-12-22 07:30:00 | SPY | ETF | 206.95 | 206.95 | 206.95 | 206.95 | 300.0 |
| 2014-12-22 07:32:00 | SPY | ETF | 206.95 | 206.95 | 206.95 | 206.95 | 200.0 |
| 2014-12-22 07:33:00 | SPY | ETF | 206.95 | 206.95 | 206.95 | 206.95 | 3164.0 |
| 2014-12-22 07:35:00 | SPY | ETF | 206.9 | 206.9 | 206.9 | 206.9 | 2002.0 |
| 2014-12-22 07:37:00 | SPY | ETF | 206.95 | 206.95 | 206.95 | 206.95 | 500.0 |
| 2014-12-22 07:38:00 | SPY | ETF | 206.91 | 206.91 | 206.91 | 206.91 | 634.0 |
| 2014-12-22 07:39:00 | SPY | ETF | 206.91 | 206.91 | 206.91 | 206.91 | 700.0 |
> showing 50 of 137,259 rows — these rows as CSV