PREVIEW / etf_5min / 2014-10-09

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-10-09.parquet
  size:    1.1 MB
  rows:    48,254

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-09 04:00:00	SPY	ETF	197.04	197.37	197.04	197.37	837.0
2014-10-09 04:05:00	SPY	ETF	197.28	197.45	197.27	197.45	1900.0
2014-10-09 04:10:00	SPY	ETF	197.21	197.23	197.21	197.23	320.0
2014-10-09 04:15:00	SPY	ETF	197.21	197.21	197.15	197.15	732.0
2014-10-09 04:20:00	SPY	ETF	197.15	197.15	197.15	197.15	100.0
2014-10-09 04:30:00	SPY	ETF	197.23	197.23	197.23	197.23	150.0
2014-10-09 04:40:00	SPY	ETF	197.24	197.24	197.22	197.23	500.0
2014-10-09 04:45:00	SPY	ETF	197.26	197.26	197.23	197.23	500.0
2014-10-09 04:50:00	SPY	ETF	197.17	197.18	197.16	197.16	630.0
2014-10-09 04:55:00	SPY	ETF	197.11	197.21	197.11	197.21	4300.0
2014-10-09 05:05:00	SPY	ETF	197.13	197.2	197.13	197.2	2100.0
2014-10-09 05:10:00	SPY	ETF	197.26	197.3	197.26	197.3	1100.0
2014-10-09 05:15:00	SPY	ETF	197.3	197.3	197.3	197.3	1000.0
2014-10-09 05:20:00	SPY	ETF	197.2	197.28	197.2	197.26	9344.0
2014-10-09 05:25:00	SPY	ETF	197.23	197.23	197.18	197.2	8306.0
2014-10-09 05:30:00	SPY	ETF	197.23	197.3	197.23	197.25	3811.0
2014-10-09 05:35:00	SPY	ETF	197.2	197.23	197.2	197.23	2203.0
2014-10-09 05:40:00	SPY	ETF	197.23	197.23	197.2	197.22	21681.0
2014-10-09 05:45:00	SPY	ETF	197.27	197.27	197.2	197.2	2400.0
2014-10-09 05:50:00	SPY	ETF	197.25	197.25	197.21	197.21	1600.0
2014-10-09 06:00:00	SPY	ETF	197.2	197.2	197.2	197.2	100.0
2014-10-09 06:05:00	SPY	ETF	197.27	197.28	197.27	197.27	2902.0
2014-10-09 06:10:00	SPY	ETF	197.23	197.24	197.2	197.24	3000.0
2014-10-09 06:15:00	SPY	ETF	197.24	197.27	197.24	197.27	500.0
2014-10-09 06:20:00	SPY	ETF	197.22	197.22	197.22	197.22	325.0
2014-10-09 06:25:00	SPY	ETF	197.12	197.12	197.12	197.12	900.0
2014-10-09 06:30:00	SPY	ETF	197.09	197.09	197.02	197.02	18253.0
2014-10-09 06:35:00	SPY	ETF	197.03	197.05	196.97	197.0	90446.0
2014-10-09 06:40:00	SPY	ETF	196.99	197.08	196.99	197.08	16754.0
2014-10-09 06:45:00	SPY	ETF	197.04	197.12	197.04	197.12	2718.0
2014-10-09 06:50:00	SPY	ETF	197.12	197.14	197.02	197.03	20552.0
2014-10-09 06:55:00	SPY	ETF	197.0	197.0	196.85	196.87	47738.0
2014-10-09 07:00:00	SPY	ETF	196.84	196.87	196.79	196.87	20900.0
2014-10-09 07:05:00	SPY	ETF	196.89	196.9	196.59	196.63	40153.0
2014-10-09 07:10:00	SPY	ETF	196.62	196.67	196.49	196.51	185953.0
2014-10-09 07:15:00	SPY	ETF	196.52	196.58	196.45	196.55	16900.0
2014-10-09 07:20:00	SPY	ETF	196.58	196.62	196.52	196.54	77752.0
2014-10-09 07:25:00	SPY	ETF	196.53	196.66	196.52	196.66	177593.0
2014-10-09 07:30:00	SPY	ETF	196.64	196.65	196.61	196.61	57250.0
2014-10-09 07:35:00	SPY	ETF	196.56	196.68	196.35	196.38	146000.0
2014-10-09 07:40:00	SPY	ETF	196.37	196.38	196.2	196.2	364371.0
2014-10-09 07:45:00	SPY	ETF	196.19	196.32	196.14	196.28	239095.0
2014-10-09 07:50:00	SPY	ETF	196.27	196.29	196.11	196.13	81957.0
2014-10-09 07:55:00	SPY	ETF	196.13	196.13	195.9	196.05	247062.0
2014-10-09 08:00:00	SPY	ETF	196.03	196.84	196.02	196.1	93912.0
2014-10-09 08:05:00	SPY	ETF	196.09	196.11	195.95	195.97	66278.0
2014-10-09 08:10:00	SPY	ETF	196.0	196.03	195.96	195.98	88386.0
2014-10-09 08:15:00	SPY	ETF	195.98	196.06	195.97	196.02	118685.0
2014-10-09 08:20:00	SPY	ETF	196.04	196.14	195.95	196.14	312737.0
2014-10-09 08:25:00	SPY	ETF	196.13	196.21	196.04	196.2	110634.0

> showing 50 of 48,254 rows — these rows as CSV

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