PREVIEW / etf_5min / 2016-11-04

all etf 5-min files

  file:    by_date/etf_5min/2016/2016-11-04.parquet
  size:    1.2 MB
  rows:    51,273

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
2016-11-04 04:00:00	SPY	ETF	209.0	209.0	209.0	209.0	300.0
2016-11-04 04:05:00	SPY	ETF	208.93	209.1	208.88	209.1	1700.0
2016-11-04 04:15:00	SPY	ETF	208.86	208.86	208.86	208.86	279.0
2016-11-04 04:20:00	SPY	ETF	208.87	208.87	208.75	208.75	244.0
2016-11-04 04:40:00	SPY	ETF	208.87	208.87	208.82	208.82	803.0
2016-11-04 04:45:00	SPY	ETF	208.82	208.82	208.82	208.82	1198.0
2016-11-04 04:55:00	SPY	ETF	208.97	208.97	208.97	208.97	500.0
2016-11-04 05:00:00	SPY	ETF	208.72	208.75	208.72	208.75	1004.0
2016-11-04 05:05:00	SPY	ETF	208.75	208.75	208.59	208.59	1525.0
2016-11-04 05:15:00	SPY	ETF	208.55	208.55	208.55	208.55	999.0
2016-11-04 05:30:00	SPY	ETF	208.75	208.75	208.75	208.75	600.0
2016-11-04 05:40:00	SPY	ETF	208.87	208.87	208.86	208.86	1000.0
2016-11-04 05:45:00	SPY	ETF	208.94	208.95	208.94	208.95	205.0
2016-11-04 05:50:00	SPY	ETF	208.93	209.0	208.93	208.93	4340.0
2016-11-04 05:55:00	SPY	ETF	208.91	208.91	208.74	208.74	1107.0
2016-11-04 06:00:00	SPY	ETF	208.78	208.78	208.74	208.75	4052.0
2016-11-04 06:05:00	SPY	ETF	208.66	208.68	208.66	208.68	1504.0
2016-11-04 06:10:00	SPY	ETF	208.66	208.66	208.66	208.66	3002.0
2016-11-04 06:15:00	SPY	ETF	208.73	208.73	208.73	208.73	100.0
2016-11-04 06:20:00	SPY	ETF	208.73	208.73	208.68	208.68	1202.0
2016-11-04 06:25:00	SPY	ETF	208.7	208.7	208.7	208.7	300.0
2016-11-04 06:30:00	SPY	ETF	208.65	208.7	208.63	208.7	1009.0
2016-11-04 06:35:00	SPY	ETF	208.72	208.72	208.72	208.72	1003.0
2016-11-04 06:40:00	SPY	ETF	208.65	208.7	208.65	208.67	2702.0
2016-11-04 06:45:00	SPY	ETF	208.7	208.72	208.7	208.72	403.0
2016-11-04 06:50:00	SPY	ETF	208.78	208.89	208.74	208.85	8107.0
2016-11-04 06:55:00	SPY	ETF	208.85	208.85	208.78	208.78	304.0
2016-11-04 07:00:00	SPY	ETF	208.75	208.81	208.7	208.78	5816.0
2016-11-04 07:05:00	SPY	ETF	208.8	208.85	208.79	208.79	6702.0
2016-11-04 07:10:00	SPY	ETF	208.79	208.8	208.73	208.73	6534.0
2016-11-04 07:15:00	SPY	ETF	208.73	208.73	208.67	208.73	7307.0
2016-11-04 07:20:00	SPY	ETF	208.75	208.75	208.75	208.75	2904.0
2016-11-04 07:25:00	SPY	ETF	208.7	208.76	208.7	208.72	1009.0
2016-11-04 07:30:00	SPY	ETF	208.74	208.76	208.69	208.75	11151.0
2016-11-04 07:35:00	SPY	ETF	208.73	208.73	208.71	208.71	29001.0
2016-11-04 07:40:00	SPY	ETF	208.75	208.76	208.7	208.72	7650.0
2016-11-04 07:45:00	SPY	ETF	208.75	208.85	208.74	208.83	35511.0
2016-11-04 07:50:00	SPY	ETF	208.83	208.83	208.8	208.81	2201.0
2016-11-04 07:55:00	SPY	ETF	208.82	208.82	208.76	208.8	14884.0
2016-11-04 08:00:00	SPY	ETF	208.82	208.89	208.81	208.86	26190.0
2016-11-04 08:05:00	SPY	ETF	209.0	209.03	208.85	208.92	97764.0
2016-11-04 08:10:00	SPY	ETF	208.9	208.93	208.78	208.78	29879.0
2016-11-04 08:15:00	SPY	ETF	208.8	208.85	208.68	208.73	127182.0
2016-11-04 08:20:00	SPY	ETF	208.73	208.77	208.68	208.77	59258.0
2016-11-04 08:25:00	SPY	ETF	208.78	209.03	208.72	208.91	88019.0
2016-11-04 08:30:00	SPY	ETF	208.94	208.99	208.5	208.86	207137.0
2016-11-04 08:35:00	SPY	ETF	208.84	208.84	208.65	208.78	61547.0
2016-11-04 08:40:00	SPY	ETF	208.76	208.94	208.7	208.94	46104.0
2016-11-04 08:45:00	SPY	ETF	208.95	209.32	208.95	209.3	217187.0
2016-11-04 08:50:00	SPY	ETF	209.3	209.31	209.15	209.25	264311.0

> showing 50 of 51,273 rows — these rows as CSV

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