PREVIEW / etf_5min / 2017-04-28

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-04-28.parquet
  size:    1.2 MB
  rows:    51,837

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
2017-04-28 04:00:00	SPY	ETF	238.65	238.65	238.65	238.65	500.0
2017-04-28 04:05:00	SPY	ETF	238.68	238.83	238.68	238.83	4510.0
2017-04-28 04:10:00	SPY	ETF	238.8	238.8	238.8	238.8	800.0
2017-04-28 04:15:00	SPY	ETF	238.83	238.83	238.76	238.76	2400.0
2017-04-28 04:20:00	SPY	ETF	238.75	238.83	238.75	238.83	1309.0
2017-04-28 04:30:00	SPY	ETF	238.75	238.75	238.75	238.75	106.0
2017-04-28 04:45:00	SPY	ETF	238.68	238.68	238.68	238.68	302.0
2017-04-28 04:50:00	SPY	ETF	238.71	238.71	238.71	238.71	300.0
2017-04-28 05:00:00	SPY	ETF	238.73	238.73	238.73	238.73	601.0
2017-04-28 05:05:00	SPY	ETF	238.81	238.81	238.81	238.81	406.0
2017-04-28 05:10:00	SPY	ETF	238.78	238.8	238.78	238.8	1202.0
2017-04-28 05:20:00	SPY	ETF	238.77	238.81	238.77	238.81	1703.0
2017-04-28 05:25:00	SPY	ETF	238.81	238.81	238.81	238.81	7000.0
2017-04-28 05:30:00	SPY	ETF	238.77	238.79	238.77	238.79	200.0
2017-04-28 05:40:00	SPY	ETF	238.74	238.74	238.74	238.74	200.0
2017-04-28 05:55:00	SPY	ETF	238.78	238.93	238.78	238.93	2610.0
2017-04-28 06:00:00	SPY	ETF	238.92	238.92	238.92	238.92	200.0
2017-04-28 06:05:00	SPY	ETF	238.9	238.9	238.89	238.89	300.0
2017-04-28 06:10:00	SPY	ETF	238.9	238.9	238.86	238.86	301.0
2017-04-28 06:15:00	SPY	ETF	238.87	238.87	238.87	238.87	100.0
2017-04-28 06:20:00	SPY	ETF	238.89	238.91	238.89	238.91	402.0
2017-04-28 06:30:00	SPY	ETF	238.82	238.82	238.82	238.82	100.0
2017-04-28 06:40:00	SPY	ETF	238.83	238.83	238.83	238.83	300.0
2017-04-28 06:50:00	SPY	ETF	238.85	238.93	238.84	238.92	2206.0
2017-04-28 06:55:00	SPY	ETF	238.89	238.89	238.83	238.83	1204.0
2017-04-28 07:00:00	SPY	ETF	238.9	238.91	238.87	238.87	12704.0
2017-04-28 07:05:00	SPY	ETF	238.87	238.9	238.83	238.87	25305.0
2017-04-28 07:10:00	SPY	ETF	238.89	238.89	238.86	238.86	4502.0
2017-04-28 07:15:00	SPY	ETF	238.87	238.91	238.87	238.9	4902.0
2017-04-28 07:20:00	SPY	ETF	238.89	238.95	238.89	238.91	4731.0
2017-04-28 07:25:00	SPY	ETF	238.94	238.95	238.91	238.91	49345.0
2017-04-28 07:30:00	SPY	ETF	238.95	238.95	238.8	238.86	11814.0
2017-04-28 07:35:00	SPY	ETF	238.85	238.85	238.84	238.84	810.0
2017-04-28 07:40:00	SPY	ETF	238.84	238.84	238.84	238.84	200.0
2017-04-28 07:45:00	SPY	ETF	238.85	238.85	238.81	238.84	34058.0
2017-04-28 07:50:00	SPY	ETF	238.83	238.83	238.75	238.78	18797.0
2017-04-28 07:55:00	SPY	ETF	238.78	238.83	238.78	238.82	5710.0
2017-04-28 08:00:00	SPY	ETF	238.9	238.95	238.77	238.81	8450.0
2017-04-28 08:05:00	SPY	ETF	238.79	238.82	238.78	238.81	1620.0
2017-04-28 08:10:00	SPY	ETF	238.76	238.79	238.76	238.76	7239.0
2017-04-28 08:15:00	SPY	ETF	238.76	238.82	238.76	238.82	82109.0
2017-04-28 08:20:00	SPY	ETF	238.8	238.85	238.79	238.85	28762.0
2017-04-28 08:25:00	SPY	ETF	238.86	238.95	238.85	238.9	46115.0
2017-04-28 08:30:00	SPY	ETF	238.86	238.89	238.77	238.79	15112.0
2017-04-28 08:35:00	SPY	ETF	238.79	238.89	238.78	238.79	16546.0
2017-04-28 08:40:00	SPY	ETF	238.79	238.81	238.73	238.75	8983.0
2017-04-28 08:45:00	SPY	ETF	238.79	238.86	238.79	238.83	6488.0
2017-04-28 08:50:00	SPY	ETF	238.83	238.91	238.83	238.9	34138.0
2017-04-28 08:55:00	SPY	ETF	238.83	238.83	238.78	238.8	7203.0
2017-04-28 09:00:00	SPY	ETF	238.8	238.82	238.78	238.81	7874.0

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

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