PREVIEW / etf_5min / 2012-09-28

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-09-28.parquet
  size:    852 KB
  rows:    35,537

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:35: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.61	144.61	300.0
2012-09-28 04:45:00	SPY	ETF	144.63	144.65	144.63	144.65	1300.0
2012-09-28 04:50:00	SPY	ETF	144.68	144.68	144.68	144.68	2000.0
2012-09-28 04:55:00	SPY	ETF	144.68	144.68	144.68	144.68	3000.0
2012-09-28 05:00:00	SPY	ETF	144.7	144.7	144.64	144.64	600.0
2012-09-28 05:15:00	SPY	ETF	144.76	144.76	144.74	144.74	1100.0
2012-09-28 05:20: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.69	144.69	1400.0
2012-09-28 05:35:00	SPY	ETF	144.69	144.69	144.69	144.69	3000.0
2012-09-28 05:45:00	SPY	ETF	144.58	144.58	144.57	144.57	500.0
2012-09-28 05:50:00	SPY	ETF	144.54	144.54	144.52	144.52	800.0
2012-09-28 05:55:00	SPY	ETF	144.52	144.52	144.52	144.52	100.0
2012-09-28 06:00:00	SPY	ETF	144.52	144.52	144.52	144.52	100.0
2012-09-28 06:05:00	SPY	ETF	144.5	144.5	144.44	144.46	2200.0
2012-09-28 06:10:00	SPY	ETF	144.49	144.49	144.49	144.49	1000.0
2012-09-28 06:15:00	SPY	ETF	144.38	144.38	144.31	144.33	15400.0
2012-09-28 06:20:00	SPY	ETF	144.33	144.36	144.33	144.36	600.0
2012-09-28 06:25: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.32	144.32	2900.0
2012-09-28 06:35: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.3	144.3	200.0
2012-09-28 06:45:00	SPY	ETF	144.31	144.31	144.26	144.29	1625.0
2012-09-28 06:50:00	SPY	ETF	144.27	144.3	144.26	144.26	50650.0
2012-09-28 06:55:00	SPY	ETF	144.25	144.25	144.1	144.18	131259.0
2012-09-28 07:00:00	SPY	ETF	144.12	144.14	144.06	144.13	18200.0
2012-09-28 07:05:00	SPY	ETF	144.13	144.18	144.13	144.18	7000.0
2012-09-28 07:10:00	SPY	ETF	144.19	144.19	144.14	144.17	28300.0
2012-09-28 07:15:00	SPY	ETF	144.19	144.19	144.19	144.19	408.0
2012-09-28 07:20:00	SPY	ETF	144.18	144.19	144.16	144.19	2250.0
2012-09-28 07:25:00	SPY	ETF	144.19	144.19	144.15	144.16	23550.0
2012-09-28 07:30:00	SPY	ETF	144.16	144.2	144.16	144.2	2050.0
2012-09-28 07:35:00	SPY	ETF	144.19	144.2	144.16	144.16	37790.0
2012-09-28 07:40:00	SPY	ETF	144.18	144.18	144.15	144.17	24300.0
2012-09-28 07:45:00	SPY	ETF	144.17	144.17	144.13	144.14	60750.0
2012-09-28 07:50:00	SPY	ETF	144.17	144.19	144.17	144.17	6400.0
2012-09-28 07:55:00	SPY	ETF	144.19	144.22	144.16	144.22	7250.0
2012-09-28 08:00:00	SPY	ETF	144.18	144.19	144.14	144.15	104957.0
2012-09-28 08:05:00	SPY	ETF	144.14	144.15	143.94	143.94	171476.0
2012-09-28 08:10:00	SPY	ETF	143.94	144.83	143.89	144.0	100115.0
2012-09-28 08:15:00	SPY	ETF	144.0	144.03	143.96	143.97	69336.0
2012-09-28 08:20:00	SPY	ETF	143.97	143.99	143.96	143.97	69692.0
2012-09-28 08:25:00	SPY	ETF	143.96	143.96	143.77	143.83	328686.0
2012-09-28 08:30:00	SPY	ETF	143.86	143.9	143.8	143.89	172559.0
2012-09-28 08:35:00	SPY	ETF	143.89	143.93	143.75	143.9	213050.0
2012-09-28 08:40:00	SPY	ETF	143.89	143.915	143.83	143.9	772193.0
2012-09-28 08:45:00	SPY	ETF	143.9	143.92	143.82	143.88	135536.0
2012-09-28 08:50:00	SPY	ETF	143.89	143.95	143.86	143.94	271035.0
2012-09-28 08:55:00	SPY	ETF	143.95	144.03	143.92	144.01	178425.0
2012-09-28 09:00:00	SPY	ETF	144.01	144.07	143.98	144.05	281000.0

> showing 50 of 35,537 rows — these rows as CSV

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