PREVIEW / etf_5min / 2014-07-08

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-07-08.parquet
  size:    1.0 MB
  rows:    44,512

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-07-08 04:30:00	SPY	ETF	197.35	197.35	197.35	197.35	300.0
2014-07-08 04:40:00	SPY	ETF	197.28	197.31	197.28	197.31	433.0
2014-07-08 05:35:00	SPY	ETF	197.36	197.36	197.25	197.25	900.0
2014-07-08 05:50:00	SPY	ETF	197.25	197.25	197.25	197.25	100.0
2014-07-08 05:55:00	SPY	ETF	197.24	197.25	197.24	197.25	1000.0
2014-07-08 06:05:00	SPY	ETF	197.21	197.21	197.21	197.21	200.0
2014-07-08 06:15:00	SPY	ETF	197.2	197.21	197.2	197.21	2000.0
2014-07-08 06:20:00	SPY	ETF	197.24	197.24	197.2	197.2	4200.0
2014-07-08 06:25:00	SPY	ETF	197.2	197.22	197.2	197.22	3400.0
2014-07-08 06:30:00	SPY	ETF	197.25	197.29	197.25	197.29	658.0
2014-07-08 06:35:00	SPY	ETF	197.29	197.32	197.29	197.32	6600.0
2014-07-08 06:45:00	SPY	ETF	197.31	197.31	197.26	197.26	3000.0
2014-07-08 06:50:00	SPY	ETF	197.3	197.3	197.3	197.3	1200.0
2014-07-08 07:00:00	SPY	ETF	197.37	197.37	197.25	197.29	12137.0
2014-07-08 07:05:00	SPY	ETF	197.31	197.31	197.31	197.31	3000.0
2014-07-08 07:10:00	SPY	ETF	197.37	197.37	197.34	197.35	10600.0
2014-07-08 07:15:00	SPY	ETF	197.35	197.4	197.34	197.4	13700.0
2014-07-08 07:20:00	SPY	ETF	197.4	197.4	197.33	197.36	1300.0
2014-07-08 07:30:00	SPY	ETF	197.33	197.5	197.25	197.26	2096.0
2014-07-08 07:35:00	SPY	ETF	197.28	197.29	197.25	197.29	13400.0
2014-07-08 07:40:00	SPY	ETF	197.33	197.33	197.33	197.33	300.0
2014-07-08 07:45:00	SPY	ETF	197.31	197.31	197.28	197.28	8185.0
2014-07-08 07:50:00	SPY	ETF	197.3	197.34	197.3	197.34	25253.0
2014-07-08 07:55:00	SPY	ETF	197.34	197.35	197.3	197.3	5600.0
2014-07-08 08:00:00	SPY	ETF	197.36	197.36	197.28	197.34	46396.0
2014-07-08 08:05:00	SPY	ETF	197.35	197.36	197.3	197.3	26700.0
2014-07-08 08:10:00	SPY	ETF	197.32	197.32	197.31	197.31	2100.0
2014-07-08 08:15:00	SPY	ETF	197.31	197.32	197.3	197.3	4736.0
2014-07-08 08:20:00	SPY	ETF	197.31	197.32	197.3	197.3	15397.0
2014-07-08 08:25:00	SPY	ETF	197.3	197.31	197.28	197.28	14966.0
2014-07-08 08:30:00	SPY	ETF	197.27	197.27	197.21	197.23	24176.0
2014-07-08 08:35:00	SPY	ETF	197.25	197.25	197.16	197.17	21848.0
2014-07-08 08:40:00	SPY	ETF	197.18	197.26	197.16	197.25	32875.0
2014-07-08 08:45:00	SPY	ETF	197.25	197.28	197.23	197.26	14122.0
2014-07-08 08:50:00	SPY	ETF	197.27	197.29	197.21	197.23	10018.0
2014-07-08 08:55:00	SPY	ETF	197.21	197.25	197.21	197.22	5100.0
2014-07-08 09:00:00	SPY	ETF	197.22	197.22	197.11	197.16	67642.0
2014-07-08 09:05:00	SPY	ETF	197.15	197.16	197.07	197.08	38185.0
2014-07-08 09:10:00	SPY	ETF	197.08	197.17	197.07	197.17	64250.0
2014-07-08 09:15:00	SPY	ETF	197.17	197.21	197.15	197.15	42870.0
2014-07-08 09:20:00	SPY	ETF	197.15	197.17	197.13	197.17	20009.0
2014-07-08 09:25:00	SPY	ETF	197.17	197.2	197.11	197.15	133102.0
2014-07-08 09:30:00	SPY	ETF	197.15	197.22	196.8	196.85	3441707.0
2014-07-08 09:35:00	SPY	ETF	196.85	196.96	196.66	196.76	2325874.0
2014-07-08 09:40:00	SPY	ETF	196.76	196.85	196.68	196.845	1813237.0
2014-07-08 09:45:00	SPY	ETF	196.85	196.85	196.61	196.63	1509685.0
2014-07-08 09:50:00	SPY	ETF	196.63	196.64	196.47	196.505	1853563.0
2014-07-08 09:55:00	SPY	ETF	196.5	196.73	196.5	196.72	1628642.0
2014-07-08 10:00:00	SPY	ETF	196.73	196.73	196.32	196.3822	2152187.0
2014-07-08 10:05:00	SPY	ETF	196.39	196.47	196.31	196.42	2007708.0

> showing 50 of 44,512 rows — these rows as CSV

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