PREVIEW / etf_1min / 2011-01-20

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-01-20.parquet
  size:    2.1 MB
  rows:    109,748

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
2011-01-20 04:00:00	SPY	ETF	128.05	128.05	128.05	128.05	500.0
2011-01-20 04:01:00	SPY	ETF	128.1	128.1	128.1	128.1	250.0
2011-01-20 04:05:00	SPY	ETF	128.21	128.21	128.21	128.21	200.0
2011-01-20 04:07:00	SPY	ETF	128.23	128.23	128.23	128.23	100.0
2011-01-20 04:15:00	SPY	ETF	128.29	128.29	128.29	128.29	200.0
2011-01-20 04:22:00	SPY	ETF	128.34	128.34	128.31	128.31	200.0
2011-01-20 04:25:00	SPY	ETF	128.36	128.36	128.36	128.36	200.0
2011-01-20 04:41:00	SPY	ETF	128.21	128.21	128.21	128.21	200.0
2011-01-20 05:13:00	SPY	ETF	128.23	128.23	128.23	128.23	200.0
2011-01-20 05:14:00	SPY	ETF	128.18	128.18	128.18	128.18	100.0
2011-01-20 05:16:00	SPY	ETF	128.14	128.14	128.14	128.14	500.0
2011-01-20 05:44:00	SPY	ETF	128.12	128.12	128.02	128.02	1600.0
2011-01-20 06:04:00	SPY	ETF	127.96	127.96	127.89	127.89	1300.0
2011-01-20 06:07:00	SPY	ETF	127.98	127.98	127.98	127.98	100.0
2011-01-20 06:13:00	SPY	ETF	127.94	127.97	127.93	127.97	10200.0
2011-01-20 06:17:00	SPY	ETF	128.02	128.02	128.02	128.02	200.0
2011-01-20 06:18:00	SPY	ETF	128.12	128.12	128.12	128.12	100.0
2011-01-20 06:22:00	SPY	ETF	128.12	128.14	128.12	128.14	1400.0
2011-01-20 06:28:00	SPY	ETF	128.09	128.09	128.09	128.09	200.0
2011-01-20 06:32:00	SPY	ETF	128.01	128.01	128.01	128.01	3000.0
2011-01-20 06:33:00	SPY	ETF	128.01	128.01	128.01	128.01	2000.0
2011-01-20 06:36:00	SPY	ETF	128.04	128.05	128.04	128.05	3100.0
2011-01-20 06:38:00	SPY	ETF	128.03	128.03	128.03	128.03	100.0
2011-01-20 06:39:00	SPY	ETF	128.0	128.0	127.99	127.99	4870.0
2011-01-20 06:52:00	SPY	ETF	128.04	128.04	128.04	128.04	900.0
2011-01-20 06:57:00	SPY	ETF	128.1	128.1	128.1	128.1	100.0
2011-01-20 07:00:00	SPY	ETF	128.04	128.04	128.04	128.04	14960.0
2011-01-20 07:01:00	SPY	ETF	128.04	128.04	128.04	128.04	1000.0
2011-01-20 07:03:00	SPY	ETF	128.04	128.08	128.04	128.08	2700.0
2011-01-20 07:06:00	SPY	ETF	128.1	128.1	128.1	128.1	200.0
2011-01-20 07:09:00	SPY	ETF	128.14	128.14	128.14	128.14	200.0
2011-01-20 07:11:00	SPY	ETF	128.14	128.14	128.14	128.14	1100.0
2011-01-20 07:12:00	SPY	ETF	128.14	128.14	128.14	128.14	1800.0
2011-01-20 07:13:00	SPY	ETF	128.14	128.14	128.14	128.14	500.0
2011-01-20 07:15:00	SPY	ETF	128.15	128.17	128.13	128.13	11830.0
2011-01-20 07:17:00	SPY	ETF	128.09	128.1	128.09	128.1	6043.0
2011-01-20 07:18:00	SPY	ETF	128.1	128.1	128.09	128.09	614.0
2011-01-20 07:19:00	SPY	ETF	128.05	128.05	128.04	128.04	5000.0
2011-01-20 07:22:00	SPY	ETF	128.06	128.06	128.05	128.05	11400.0
2011-01-20 07:23:00	SPY	ETF	128.02	128.05	128.01	128.05	15000.0
2011-01-20 07:24:00	SPY	ETF	128.01	128.01	128.0	128.0	666.0
2011-01-20 07:25:00	SPY	ETF	128.01	128.01	128.0	128.0	10200.0
2011-01-20 07:26:00	SPY	ETF	128.0	128.0	127.96	127.96	10034.0
2011-01-20 07:27:00	SPY	ETF	127.96	128.0	127.93	127.95	6600.0
2011-01-20 07:28:00	SPY	ETF	127.89	127.92	127.89	127.92	10600.0
2011-01-20 07:29:00	SPY	ETF	127.9	127.9	127.78	127.85	25380.0
2011-01-20 07:30:00	SPY	ETF	127.84	127.98	127.84	127.98	7300.0
2011-01-20 07:31:00	SPY	ETF	127.96	127.96	127.94	127.94	10500.0
2011-01-20 07:32:00	SPY	ETF	127.99	128.0	127.97	127.97	2000.0
2011-01-20 07:33:00	SPY	ETF	127.99	128.04	127.99	128.04	1413.0

> showing 50 of 109,748 rows — these rows as CSV

> unlock the full archive -- $79 one-time