PREVIEW / etf_5min / 2014-10-28

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-10-28.parquet
  size:    1.1 MB
  rows:    47,016

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-28 04:00:00	SPY	ETF	196.8	196.93	196.8	196.86	3200.0
2014-10-28 04:05:00	SPY	ETF	196.82	196.82	196.82	196.82	105.0
2014-10-28 04:10:00	SPY	ETF	196.78	196.9	196.78	196.87	2220.0
2014-10-28 04:15:00	SPY	ETF	196.97	197.66	196.97	197.66	22251.0
2014-10-28 04:20:00	SPY	ETF	197.42	197.42	197.22	197.34	21580.0
2014-10-28 04:25:00	SPY	ETF	197.25	197.32	197.24	197.32	7800.0
2014-10-28 04:30:00	SPY	ETF	197.3	197.3	197.27	197.28	1274.0
2014-10-28 04:35:00	SPY	ETF	197.28	197.28	197.28	197.28	400.0
2014-10-28 04:40:00	SPY	ETF	197.27	197.27	197.24	197.24	700.0
2014-10-28 04:50:00	SPY	ETF	197.22	197.22	197.22	197.22	1320.0
2014-10-28 04:55:00	SPY	ETF	197.14	197.14	197.1	197.1	1200.0
2014-10-28 05:00:00	SPY	ETF	197.22	197.22	197.2	197.2	5843.0
2014-10-28 05:05:00	SPY	ETF	197.22	197.22	197.19	197.22	450.0
2014-10-28 05:10:00	SPY	ETF	197.19	197.19	197.15	197.17	13500.0
2014-10-28 05:15:00	SPY	ETF	197.16	197.17	197.15	197.15	7933.0
2014-10-28 05:20:00	SPY	ETF	197.17	197.27	197.17	197.23	15300.0
2014-10-28 05:25:00	SPY	ETF	197.23	197.25	197.23	197.25	2600.0
2014-10-28 05:30:00	SPY	ETF	197.27	197.3	197.26	197.29	18724.0
2014-10-28 05:35:00	SPY	ETF	197.3	197.33	197.3	197.33	6800.0
2014-10-28 05:40:00	SPY	ETF	197.34	197.38	197.31	197.38	4870.0
2014-10-28 05:45:00	SPY	ETF	197.38	197.39	197.37	197.38	33600.0
2014-10-28 05:50:00	SPY	ETF	197.36	197.36	197.33	197.33	1310.0
2014-10-28 05:55:00	SPY	ETF	197.31	197.31	197.26	197.3	4450.0
2014-10-28 06:00:00	SPY	ETF	197.28	197.28	197.28	197.28	270.0
2014-10-28 06:05:00	SPY	ETF	197.26	197.26	197.22	197.22	3514.0
2014-10-28 06:10:00	SPY	ETF	197.2	197.28	197.2	197.28	1970.0
2014-10-28 06:15:00	SPY	ETF	197.26	197.26	197.24	197.24	1903.0
2014-10-28 06:20:00	SPY	ETF	197.26	197.27	197.26	197.27	690.0
2014-10-28 06:25:00	SPY	ETF	197.21	197.28	197.18	197.28	30134.0
2014-10-28 06:30:00	SPY	ETF	197.23	197.23	197.22	197.22	2305.0
2014-10-28 06:35:00	SPY	ETF	197.19	197.23	197.19	197.22	1500.0
2014-10-28 06:40:00	SPY	ETF	197.23	197.28	197.23	197.28	2117.0
2014-10-28 06:45:00	SPY	ETF	197.35	197.35	197.26	197.26	925.0
2014-10-28 06:50:00	SPY	ETF	197.3	197.3	197.26	197.26	7500.0
2014-10-28 06:55:00	SPY	ETF	197.24	197.3	197.24	197.24	620.0
2014-10-28 07:00:00	SPY	ETF	197.24	197.27	197.22	197.27	4336.0
2014-10-28 07:05:00	SPY	ETF	197.26	197.26	197.22	197.25	3000.0
2014-10-28 07:10:00	SPY	ETF	197.23	197.23	197.21	197.21	10535.0
2014-10-28 07:15:00	SPY	ETF	197.27	197.31	197.27	197.31	10375.0
2014-10-28 07:20:00	SPY	ETF	197.25	197.25	197.18	197.24	3413.0
2014-10-28 07:25:00	SPY	ETF	197.24	197.32	197.21	197.32	32083.0
2014-10-28 07:30:00	SPY	ETF	197.31	197.32	197.23	197.23	4877.0
2014-10-28 07:35:00	SPY	ETF	197.25	197.25	197.16	197.16	18059.0
2014-10-28 07:40:00	SPY	ETF	197.17	197.2	197.11	197.18	15519.0
2014-10-28 07:45:00	SPY	ETF	197.16	197.22	197.16	197.22	72416.0
2014-10-28 07:50:00	SPY	ETF	197.21	197.33	197.21	197.29	13312.0
2014-10-28 07:55:00	SPY	ETF	197.27	197.33	197.27	197.32	34465.0
2014-10-28 08:00:00	SPY	ETF	197.32	197.36	196.505	196.505	103000.0
2014-10-28 08:05:00	SPY	ETF	197.29	197.3	197.26	197.29	31336.0
2014-10-28 08:10:00	SPY	ETF	197.3	197.3	197.21	197.21	46675.0

> showing 50 of 47,016 rows — these rows as CSV

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