PREVIEW / etf_5min / 2017-06-19

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-06-19.parquet
  size:    1.2 MB
  rows:    53,415

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-06-19 04:00:00	SPY	ETF	243.2	243.38	243.2	243.38	420.0
2017-06-19 04:05:00	SPY	ETF	243.3	243.3	243.3	243.3	3000.0
2017-06-19 04:20:00	SPY	ETF	243.4	243.42	243.3	243.3	1600.0
2017-06-19 04:25:00	SPY	ETF	243.37	243.37	243.37	243.37	1000.0
2017-06-19 04:30:00	SPY	ETF	243.3	243.31	243.3	243.31	900.0
2017-06-19 04:40:00	SPY	ETF	243.34	243.34	243.3	243.3	200.0
2017-06-19 04:55:00	SPY	ETF	243.35	243.35	243.35	243.35	500.0
2017-06-19 05:00:00	SPY	ETF	243.35	243.35	243.35	243.35	100.0
2017-06-19 05:30:00	SPY	ETF	243.44	243.46	243.44	243.46	802.0
2017-06-19 05:35:00	SPY	ETF	243.44	243.44	243.44	243.44	500.0
2017-06-19 05:40:00	SPY	ETF	243.35	243.35	243.31	243.31	3300.0
2017-06-19 05:55:00	SPY	ETF	243.33	243.33	243.33	243.33	300.0
2017-06-19 06:05:00	SPY	ETF	243.33	243.33	243.33	243.33	1000.0
2017-06-19 06:20:00	SPY	ETF	243.3	243.3	243.3	243.3	150.0
2017-06-19 06:35:00	SPY	ETF	243.31	243.31	243.31	243.31	260.0
2017-06-19 06:40:00	SPY	ETF	243.33	243.33	243.33	243.33	100.0
2017-06-19 06:45:00	SPY	ETF	243.35	243.35	243.32	243.32	1730.0
2017-06-19 06:50:00	SPY	ETF	243.33	243.33	243.33	243.33	420.0
2017-06-19 06:55:00	SPY	ETF	243.35	243.35	243.35	243.35	300.0
2017-06-19 07:00:00	SPY	ETF	243.4	243.42	243.4	243.4	10130.0
2017-06-19 07:05:00	SPY	ETF	243.4	243.41	243.4	243.4	14000.0
2017-06-19 07:10:00	SPY	ETF	243.4	243.4	243.4	243.4	400.0
2017-06-19 07:15:00	SPY	ETF	243.41	243.41	243.39	243.4	3697.0
2017-06-19 07:20:00	SPY	ETF	243.41	243.41	243.41	243.41	2920.0
2017-06-19 07:25:00	SPY	ETF	243.44	243.46	243.44	243.46	6840.0
2017-06-19 07:30:00	SPY	ETF	243.44	243.44	243.42	243.42	2369.0
2017-06-19 07:35:00	SPY	ETF	243.47	243.49	243.47	243.48	34607.0
2017-06-19 07:40:00	SPY	ETF	243.46	243.46	243.44	243.44	28607.0
2017-06-19 07:45:00	SPY	ETF	243.47	243.49	243.47	243.47	6438.0
2017-06-19 07:50:00	SPY	ETF	243.5	243.52	243.48	243.48	49524.0
2017-06-19 07:55:00	SPY	ETF	243.48	243.48	243.45	243.47	11707.0
2017-06-19 08:00:00	SPY	ETF	243.49	243.49	243.36	243.49	21463.0
2017-06-19 08:05:00	SPY	ETF	243.49	243.55	243.49	243.52	17805.0
2017-06-19 08:10:00	SPY	ETF	243.52	243.56	243.5	243.51	18136.0
2017-06-19 08:15:00	SPY	ETF	243.51	243.52	243.45	243.45	12182.0
2017-06-19 08:20:00	SPY	ETF	243.44	243.47	243.43	243.46	6849.0
2017-06-19 08:25:00	SPY	ETF	243.46	243.46	243.39	243.4	39931.0
2017-06-19 08:30:00	SPY	ETF	243.42	243.42	243.39	243.4	35759.0
2017-06-19 08:35:00	SPY	ETF	243.4	243.42	243.39	243.39	21330.0
2017-06-19 08:40:00	SPY	ETF	243.39	243.46	243.38	243.44	41087.0
2017-06-19 08:45:00	SPY	ETF	243.47	243.55	243.46	243.5	50855.0
2017-06-19 08:50:00	SPY	ETF	243.5	243.54	243.48	243.54	63773.0
2017-06-19 08:55:00	SPY	ETF	243.54	243.54	243.49	243.49	15668.0
2017-06-19 09:00:00	SPY	ETF	243.48	243.48	243.44	243.45	58971.0
2017-06-19 09:05:00	SPY	ETF	243.46	243.5	243.45	243.5	15445.0
2017-06-19 09:10:00	SPY	ETF	243.49	243.52	243.46	243.51	25418.0
2017-06-19 09:15:00	SPY	ETF	243.52	243.53	243.48	243.48	18402.0
2017-06-19 09:20:00	SPY	ETF	243.5	243.52	243.49	243.51	8021.0
2017-06-19 09:25:00	SPY	ETF	243.52	243.62	243.51	243.58	126051.0
2017-06-19 09:30:00	SPY	ETF	243.59	243.67	243.48	243.55	1688195.0

> showing 50 of 53,415 rows — these rows as CSV

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