PREVIEW / etf_5min / 2017-03-17

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-03-17.parquet
  size:    1.2 MB
  rows:    52,701

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-03-17 04:00:00	SPY	ETF	237.42	237.43	237.3	237.32	4175.0
2017-03-17 04:05:00	SPY	ETF	237.35	237.35	237.3	237.35	2350.0
2017-03-17 04:15:00	SPY	ETF	237.38	237.38	237.28	237.28	1400.0
2017-03-17 04:20:00	SPY	ETF	237.31	237.31	237.31	237.31	950.0
2017-03-17 04:35:00	SPY	ETF	237.33	237.4	237.33	237.33	1210.0
2017-03-17 04:40:00	SPY	ETF	237.35	237.43	237.35	237.4	2900.0
2017-03-17 04:45:00	SPY	ETF	237.34	237.34	237.34	237.34	500.0
2017-03-17 04:50:00	SPY	ETF	237.4	237.4	237.4	237.4	400.0
2017-03-17 05:00:00	SPY	ETF	237.4	237.4	237.4	237.4	103.0
2017-03-17 05:05:00	SPY	ETF	237.45	237.45	237.45	237.45	502.0
2017-03-17 05:15:00	SPY	ETF	237.5	237.5	237.5	237.5	300.0
2017-03-17 05:20:00	SPY	ETF	237.47	237.5	237.47	237.5	1006.0
2017-03-17 05:25:00	SPY	ETF	237.5	237.53	237.5	237.53	600.0
2017-03-17 05:40:00	SPY	ETF	237.48	237.48	237.48	237.48	3000.0
2017-03-17 05:45:00	SPY	ETF	237.47	237.47	237.47	237.47	700.0
2017-03-17 06:00:00	SPY	ETF	237.45	237.45	237.45	237.45	100.0
2017-03-17 06:20:00	SPY	ETF	237.52	237.52	237.51	237.51	5302.0
2017-03-17 06:25:00	SPY	ETF	237.47	237.47	237.47	237.47	245.0
2017-03-17 06:30:00	SPY	ETF	237.45	237.45	237.45	237.45	253.0
2017-03-17 06:35:00	SPY	ETF	237.47	237.47	237.44	237.44	2700.0
2017-03-17 06:50:00	SPY	ETF	237.59	237.59	237.59	237.59	200.0
2017-03-17 06:55:00	SPY	ETF	237.59	237.59	237.57	237.57	430.0
2017-03-17 07:00:00	SPY	ETF	237.57	237.73	237.57	237.73	27022.0
2017-03-17 07:05:00	SPY	ETF	237.71	237.74	237.71	237.74	20000.0
2017-03-17 07:10:00	SPY	ETF	237.68	237.68	237.68	237.68	400.0
2017-03-17 07:15:00	SPY	ETF	237.68	237.69	237.68	237.69	20000.0
2017-03-17 07:20:00	SPY	ETF	237.64	237.64	237.61	237.61	2403.0
2017-03-17 07:25:00	SPY	ETF	237.61	237.62	237.56	237.61	4830.0
2017-03-17 07:30:00	SPY	ETF	237.63	237.68	237.6	237.63	8179.0
2017-03-17 07:35:00	SPY	ETF	237.56	237.58	237.56	237.58	2103.0
2017-03-17 07:40:00	SPY	ETF	237.56	237.59	237.55	237.55	3132.0
2017-03-17 07:45:00	SPY	ETF	237.56	237.56	237.5	237.51	27225.0
2017-03-17 07:50:00	SPY	ETF	237.51	237.52	237.48	237.5	16474.0
2017-03-17 07:55:00	SPY	ETF	237.5	237.55	237.5	237.55	15100.0
2017-03-17 08:00:00	SPY	ETF	237.48	237.68	237.45	237.48	29195.0
2017-03-17 08:05:00	SPY	ETF	237.505	237.62	237.505	237.61	111276.0
2017-03-17 08:10:00	SPY	ETF	237.61	237.63	237.49	237.49	46779.0
2017-03-17 08:15:00	SPY	ETF	237.48	237.55	237.48	237.53	37776.0
2017-03-17 08:20:00	SPY	ETF	237.55	237.61	237.53	237.61	43798.0
2017-03-17 08:25:00	SPY	ETF	237.61	237.67	237.61	237.67	71895.0
2017-03-17 08:30:00	SPY	ETF	237.68	237.7	237.59	237.65	25711.0
2017-03-17 08:35:00	SPY	ETF	237.65	237.73	237.65	237.67	62235.0
2017-03-17 08:40:00	SPY	ETF	237.67	237.7	237.65	237.67	42128.0
2017-03-17 08:45:00	SPY	ETF	237.67	237.67	237.64	237.67	19110.0
2017-03-17 08:50:00	SPY	ETF	237.68	237.78	237.68	237.74	58678.0
2017-03-17 08:55:00	SPY	ETF	237.77	237.87	237.76	237.85	81359.0
2017-03-17 09:00:00	SPY	ETF	237.84	237.84	237.71	237.74	104517.0
2017-03-17 09:05:00	SPY	ETF	237.74	237.75	237.67	237.67	192987.0
2017-03-17 09:10:00	SPY	ETF	237.66	237.69	237.56	237.59	449307.0
2017-03-17 09:15:00	SPY	ETF	237.6	237.64	237.55	237.6	91672.0

> showing 50 of 52,701 rows — these rows as CSV

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