PREVIEW / etf_5min / 2014-10-21

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-10-21.parquet
  size:    1.2 MB
  rows:    49,073

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-10-21 04:00:00	SPY	ETF	190.36	190.63	190.36	190.5	1113.0
2014-10-21 04:05:00	SPY	ETF	190.46	190.47	190.46	190.47	500.0
2014-10-21 04:10:00	SPY	ETF	190.54	190.54	190.46	190.46	550.0
2014-10-21 04:15:00	SPY	ETF	190.42	190.42	190.42	190.42	100.0
2014-10-21 04:25:00	SPY	ETF	190.4	190.49	190.4	190.49	1149.0
2014-10-21 04:30:00	SPY	ETF	190.56	190.56	190.56	190.56	1901.0
2014-10-21 04:35:00	SPY	ETF	190.61	190.61	190.61	190.61	379.0
2014-10-21 04:40:00	SPY	ETF	190.58	190.58	190.58	190.58	165.0
2014-10-21 04:45:00	SPY	ETF	190.6	190.78	190.6	190.78	550.0
2014-10-21 04:50:00	SPY	ETF	190.75	190.81	190.75	190.78	4250.0
2014-10-21 04:55:00	SPY	ETF	190.8	190.8	190.73	190.78	2640.0
2014-10-21 05:00:00	SPY	ETF	190.7	190.72	190.67	190.69	9527.0
2014-10-21 05:05:00	SPY	ETF	190.7	190.72	190.65	190.65	1604.0
2014-10-21 05:10:00	SPY	ETF	190.64	190.64	190.64	190.64	100.0
2014-10-21 05:15:00	SPY	ETF	190.58	190.58	190.58	190.58	170.0
2014-10-21 05:20:00	SPY	ETF	190.5	190.5	190.5	190.5	3050.0
2014-10-21 05:25:00	SPY	ETF	190.45	190.6	190.45	190.6	7120.0
2014-10-21 05:30:00	SPY	ETF	190.69	190.99	190.69	190.78	9308.0
2014-10-21 05:35:00	SPY	ETF	190.85	190.93	190.8	190.92	1288.0
2014-10-21 05:40:00	SPY	ETF	190.92	191.23	190.92	191.23	11060.0
2014-10-21 05:45:00	SPY	ETF	191.17	191.21	191.17	191.21	3697.0
2014-10-21 05:50:00	SPY	ETF	191.14	191.18	191.09	191.18	37400.0
2014-10-21 05:55:00	SPY	ETF	191.11	191.11	191.06	191.07	1318.0
2014-10-21 06:00:00	SPY	ETF	191.1	191.23	191.09	191.2	23053.0
2014-10-21 06:05:00	SPY	ETF	191.19	191.35	191.19	191.29	27061.0
2014-10-21 06:10:00	SPY	ETF	191.27	191.38	191.26	191.38	19355.0
2014-10-21 06:15:00	SPY	ETF	191.45	191.83	191.45	191.78	83890.0
2014-10-21 06:20:00	SPY	ETF	191.79	191.82	191.66	191.73	16616.0
2014-10-21 06:25:00	SPY	ETF	191.68	191.75	191.68	191.74	28143.0
2014-10-21 06:30:00	SPY	ETF	191.73	191.8	191.63	191.78	100124.0
2014-10-21 06:35:00	SPY	ETF	191.69	191.69	191.61	191.61	5964.0
2014-10-21 06:40:00	SPY	ETF	191.58	191.65	191.58	191.58	3313.0
2014-10-21 06:45:00	SPY	ETF	191.61	191.74	191.61	191.73	22855.0
2014-10-21 06:50:00	SPY	ETF	191.7	191.92	191.7	191.88	102946.0
2014-10-21 06:55:00	SPY	ETF	191.88	192.2	191.88	192.05	64641.0
2014-10-21 07:00:00	SPY	ETF	192.07	192.18	191.97	191.98	162038.0
2014-10-21 07:05:00	SPY	ETF	191.95	191.97	191.82	191.93	55736.0
2014-10-21 07:10:00	SPY	ETF	191.96	192.14	191.96	192.1	97318.0
2014-10-21 07:15:00	SPY	ETF	192.1	192.16	192.03	192.03	145688.0
2014-10-21 07:20:00	SPY	ETF	192.0	192.0	191.86	191.86	77788.0
2014-10-21 07:25:00	SPY	ETF	191.88	191.99	191.88	191.99	105883.0
2014-10-21 07:30:00	SPY	ETF	191.98	192.0	191.77	191.82	84301.0
2014-10-21 07:35:00	SPY	ETF	191.78	191.87	191.74	191.82	150660.0
2014-10-21 07:40:00	SPY	ETF	191.82	191.84	191.63	191.7	145736.0
2014-10-21 07:45:00	SPY	ETF	191.7	191.78	191.64	191.77	64941.0
2014-10-21 07:50:00	SPY	ETF	191.78	191.93	191.72	191.9	95691.0
2014-10-21 07:55:00	SPY	ETF	191.88	191.9	191.28	191.44	468209.0
2014-10-21 08:00:00	SPY	ETF	191.42	192.18	191.25	191.26	420462.0
2014-10-21 08:05:00	SPY	ETF	191.27	191.6	191.23	191.6	270637.0
2014-10-21 08:10:00	SPY	ETF	191.56	191.69	191.48	191.5	212922.0

> showing 50 of 49,073 rows — these rows as CSV

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