PREVIEW / etf_1min / 2012-09-28

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-09-28.parquet
  size:    1.9 MB
  rows:    99,371

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-09-28 04:39:00	SPY	ETF	144.68	144.68	144.68	144.68	1500.0
2012-09-28 04:40:00	SPY	ETF	144.66	144.66	144.66	144.66	200.0
2012-09-28 04:42:00	SPY	ETF	144.61	144.61	144.61	144.61	100.0
2012-09-28 04:46:00	SPY	ETF	144.63	144.63	144.63	144.63	300.0
2012-09-28 04:48:00	SPY	ETF	144.65	144.65	144.65	144.65	1000.0
2012-09-28 04:51:00	SPY	ETF	144.68	144.68	144.68	144.68	2000.0
2012-09-28 04:56:00	SPY	ETF	144.68	144.68	144.68	144.68	3000.0
2012-09-28 05:02:00	SPY	ETF	144.7	144.7	144.64	144.64	600.0
2012-09-28 05:19:00	SPY	ETF	144.76	144.76	144.74	144.74	1100.0
2012-09-28 05:22:00	SPY	ETF	144.74	144.74	144.74	144.74	1000.0
2012-09-28 05:30:00	SPY	ETF	144.74	144.74	144.74	144.74	100.0
2012-09-28 05:34:00	SPY	ETF	144.69	144.69	144.69	144.69	1300.0
2012-09-28 05:35:00	SPY	ETF	144.69	144.69	144.69	144.69	3000.0
2012-09-28 05:47:00	SPY	ETF	144.58	144.58	144.58	144.58	400.0
2012-09-28 05:48:00	SPY	ETF	144.57	144.57	144.57	144.57	100.0
2012-09-28 05:51:00	SPY	ETF	144.54	144.54	144.54	144.54	600.0
2012-09-28 05:54:00	SPY	ETF	144.52	144.52	144.52	144.52	200.0
2012-09-28 05:55:00	SPY	ETF	144.52	144.52	144.52	144.52	100.0
2012-09-28 06:04:00	SPY	ETF	144.52	144.52	144.52	144.52	100.0
2012-09-28 06:07:00	SPY	ETF	144.5	144.5	144.44	144.47	2100.0
2012-09-28 06:08:00	SPY	ETF	144.46	144.46	144.46	144.46	100.0
2012-09-28 06:10:00	SPY	ETF	144.49	144.49	144.49	144.49	1000.0
2012-09-28 06:16:00	SPY	ETF	144.38	144.38	144.34	144.34	4000.0
2012-09-28 06:17:00	SPY	ETF	144.31	144.33	144.31	144.33	3200.0
2012-09-28 06:18:00	SPY	ETF	144.34	144.34	144.31	144.33	8200.0
2012-09-28 06:23:00	SPY	ETF	144.33	144.33	144.33	144.33	200.0
2012-09-28 06:24:00	SPY	ETF	144.36	144.36	144.33	144.36	400.0
2012-09-28 06:28:00	SPY	ETF	144.37	144.37	144.37	144.37	300.0
2012-09-28 06:30:00	SPY	ETF	144.34	144.34	144.34	144.34	200.0
2012-09-28 06:32:00	SPY	ETF	144.33	144.33	144.33	144.33	200.0
2012-09-28 06:34:00	SPY	ETF	144.32	144.32	144.32	144.32	2500.0
2012-09-28 06:36:00	SPY	ETF	144.29	144.29	144.29	144.29	100.0
2012-09-28 06:40:00	SPY	ETF	144.31	144.31	144.31	144.31	100.0
2012-09-28 06:43:00	SPY	ETF	144.3	144.3	144.3	144.3	100.0
2012-09-28 06:45:00	SPY	ETF	144.31	144.31	144.31	144.31	600.0
2012-09-28 06:46:00	SPY	ETF	144.28	144.28	144.26	144.26	750.0
2012-09-28 06:47:00	SPY	ETF	144.27	144.27	144.27	144.27	175.0
2012-09-28 06:48:00	SPY	ETF	144.29	144.29	144.29	144.29	100.0
2012-09-28 06:50:00	SPY	ETF	144.27	144.27	144.27	144.27	150.0
2012-09-28 06:52:00	SPY	ETF	144.3	144.3	144.29	144.29	5000.0
2012-09-28 06:53:00	SPY	ETF	144.3	144.3	144.27	144.27	31700.0
2012-09-28 06:54:00	SPY	ETF	144.27	144.28	144.26	144.26	13800.0
2012-09-28 06:55:00	SPY	ETF	144.25	144.25	144.25	144.25	300.0
2012-09-28 06:56:00	SPY	ETF	144.25	144.25	144.13	144.17	8665.0
2012-09-28 06:57:00	SPY	ETF	144.16	144.18	144.14	144.14	19500.0
2012-09-28 06:58:00	SPY	ETF	144.14	144.15	144.14	144.14	50899.0
2012-09-28 06:59:00	SPY	ETF	144.11	144.18	144.1	144.18	51895.0
2012-09-28 07:00:00	SPY	ETF	144.12	144.12	144.11	144.11	1300.0
2012-09-28 07:01:00	SPY	ETF	144.11	144.12	144.08	144.12	8000.0
2012-09-28 07:02:00	SPY	ETF	144.06	144.12	144.06	144.12	6400.0

> showing 50 of 99,371 rows — these rows as CSV

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