PREVIEW / etf_1min / 2014-04-03
file: by_date/etf_1min/2014/2014-04-03.parquet size: 2.1 MB rows: 110,021
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-04-03 04:04:00 | SPY | ETF | 188.76 | 188.76 | 188.76 | 188.76 | 100.0 |
| 2014-04-03 04:09:00 | SPY | ETF | 188.76 | 188.76 | 188.76 | 188.76 | 1300.0 |
| 2014-04-03 04:15:00 | SPY | ETF | 188.87 | 188.87 | 188.87 | 188.87 | 100.0 |
| 2014-04-03 04:25:00 | SPY | ETF | 188.97 | 188.97 | 188.97 | 188.97 | 100.0 |
| 2014-04-03 04:31:00 | SPY | ETF | 188.97 | 188.97 | 188.97 | 188.97 | 127.0 |
| 2014-04-03 04:41:00 | SPY | ETF | 188.91 | 188.91 | 188.91 | 188.91 | 2000.0 |
| 2014-04-03 04:42:00 | SPY | ETF | 188.91 | 188.91 | 188.91 | 188.91 | 339.0 |
| 2014-04-03 04:43:00 | SPY | ETF | 188.91 | 188.91 | 188.91 | 188.91 | 600.0 |
| 2014-04-03 04:45:00 | SPY | ETF | 188.89 | 188.91 | 188.89 | 188.89 | 1041.0 |
| 2014-04-03 04:53:00 | SPY | ETF | 188.93 | 188.93 | 188.93 | 188.93 | 241.0 |
| 2014-04-03 05:01:00 | SPY | ETF | 188.89 | 188.89 | 188.89 | 188.89 | 198.0 |
| 2014-04-03 05:03:00 | SPY | ETF | 188.92 | 188.92 | 188.92 | 188.92 | 130.0 |
| 2014-04-03 05:04:00 | SPY | ETF | 188.94 | 188.94 | 188.94 | 188.94 | 400.0 |
| 2014-04-03 05:13:00 | SPY | ETF | 188.92 | 188.92 | 188.92 | 188.92 | 164.0 |
| 2014-04-03 05:15:00 | SPY | ETF | 188.89 | 188.89 | 188.88 | 188.88 | 600.0 |
| 2014-04-03 05:22:00 | SPY | ETF | 188.87 | 188.87 | 188.87 | 188.87 | 130.0 |
| 2014-04-03 05:24:00 | SPY | ETF | 188.88 | 188.88 | 188.88 | 188.88 | 240.0 |
| 2014-04-03 05:32:00 | SPY | ETF | 188.92 | 188.92 | 188.92 | 188.92 | 199.0 |
| 2014-04-03 05:33:00 | SPY | ETF | 188.94 | 188.94 | 188.94 | 188.94 | 400.0 |
| 2014-04-03 05:34:00 | SPY | ETF | 188.93 | 188.93 | 188.93 | 188.93 | 145.0 |
| 2014-04-03 05:38:00 | SPY | ETF | 188.93 | 188.93 | 188.93 | 188.93 | 200.0 |
| 2014-04-03 05:43:00 | SPY | ETF | 188.89 | 188.89 | 188.89 | 188.89 | 110.0 |
| 2014-04-03 05:50:00 | SPY | ETF | 188.91 | 188.91 | 188.91 | 188.91 | 10000.0 |
| 2014-04-03 05:52:00 | SPY | ETF | 188.94 | 188.94 | 188.94 | 188.94 | 100.0 |
| 2014-04-03 05:53:00 | SPY | ETF | 188.95 | 188.97 | 188.95 | 188.97 | 399.0 |
| 2014-04-03 05:58:00 | SPY | ETF | 188.99 | 188.99 | 188.99 | 188.99 | 641.0 |
| 2014-04-03 06:02:00 | SPY | ETF | 189.01 | 189.01 | 189.01 | 189.01 | 400.0 |
| 2014-04-03 06:11:00 | SPY | ETF | 189.02 | 189.02 | 189.02 | 189.02 | 100.0 |
| 2014-04-03 06:12:00 | SPY | ETF | 188.98 | 188.98 | 188.98 | 188.98 | 900.0 |
| 2014-04-03 06:21:00 | SPY | ETF | 189.03 | 189.07 | 189.03 | 189.07 | 7306.0 |
| 2014-04-03 06:23:00 | SPY | ETF | 189.1 | 189.1 | 189.1 | 189.1 | 210.0 |
| 2014-04-03 06:25:00 | SPY | ETF | 189.08 | 189.08 | 189.08 | 189.08 | 252.0 |
| 2014-04-03 06:28:00 | SPY | ETF | 189.02 | 189.02 | 189.02 | 189.02 | 106.0 |
| 2014-04-03 06:40:00 | SPY | ETF | 189.01 | 189.01 | 189.01 | 189.01 | 100.0 |
| 2014-04-03 06:46:00 | SPY | ETF | 189.06 | 189.06 | 189.06 | 189.06 | 200.0 |
| 2014-04-03 06:47:00 | SPY | ETF | 189.09 | 189.12 | 189.09 | 189.12 | 1242.0 |
| 2014-04-03 06:48:00 | SPY | ETF | 189.12 | 189.12 | 189.12 | 189.12 | 1000.0 |
| 2014-04-03 06:57:00 | SPY | ETF | 189.07 | 189.07 | 189.07 | 189.07 | 1175.0 |
| 2014-04-03 07:00:00 | SPY | ETF | 189.04 | 189.04 | 189.04 | 189.04 | 756.0 |
| 2014-04-03 07:01:00 | SPY | ETF | 189.02 | 189.02 | 189.02 | 189.02 | 1000.0 |
| 2014-04-03 07:04:00 | SPY | ETF | 189.02 | 189.02 | 189.02 | 189.02 | 300.0 |
| 2014-04-03 07:06:00 | SPY | ETF | 189.02 | 189.02 | 189.02 | 189.02 | 1320.0 |
| 2014-04-03 07:07:00 | SPY | ETF | 189.01 | 189.01 | 189.01 | 189.01 | 100.0 |
| 2014-04-03 07:09:00 | SPY | ETF | 189.01 | 189.02 | 189.01 | 189.02 | 3100.0 |
| 2014-04-03 07:11:00 | SPY | ETF | 188.99 | 188.99 | 188.99 | 188.99 | 100.0 |
| 2014-04-03 07:12:00 | SPY | ETF | 188.99 | 188.99 | 188.99 | 188.99 | 700.0 |
| 2014-04-03 07:15:00 | SPY | ETF | 189.0 | 189.0 | 189.0 | 189.0 | 216.0 |
| 2014-04-03 07:16:00 | SPY | ETF | 189.02 | 189.02 | 189.02 | 189.02 | 7200.0 |
| 2014-04-03 07:20:00 | SPY | ETF | 189.02 | 189.02 | 189.02 | 189.02 | 900.0 |
| 2014-04-03 07:22:00 | SPY | ETF | 189.0 | 189.0 | 189.0 | 189.0 | 4800.0 |
> showing 50 of 110,021 rows — these rows as CSV