PREVIEW / etf_5min / 2017-01-19

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-01-19.parquet
  size:    1.3 MB
  rows:    54,485

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-01-19 04:05:00	SPY	ETF	226.58	226.58	226.57	226.57	600.0
2017-01-19 04:20:00	SPY	ETF	226.56	226.56	226.56	226.56	100.0
2017-01-19 04:50:00	SPY	ETF	226.39	226.39	226.39	226.39	501.0
2017-01-19 04:55:00	SPY	ETF	226.41	226.41	226.41	226.41	300.0
2017-01-19 05:00:00	SPY	ETF	226.33	226.33	226.32	226.32	450.0
2017-01-19 05:05:00	SPY	ETF	226.28	226.28	226.25	226.25	314.0
2017-01-19 05:10:00	SPY	ETF	226.25	226.27	226.25	226.27	803.0
2017-01-19 05:30:00	SPY	ETF	226.32	226.32	226.32	226.32	250.0
2017-01-19 05:35:00	SPY	ETF	226.34	226.34	226.34	226.34	2500.0
2017-01-19 05:55:00	SPY	ETF	226.36	226.36	226.36	226.36	1000.0
2017-01-19 06:00:00	SPY	ETF	226.35	226.36	226.35	226.36	1503.0
2017-01-19 06:05:00	SPY	ETF	226.4	226.42	226.4	226.42	1738.0
2017-01-19 06:10:00	SPY	ETF	226.49	226.52	226.49	226.52	3003.0
2017-01-19 06:15:00	SPY	ETF	226.5	226.5	226.49	226.49	1500.0
2017-01-19 06:25:00	SPY	ETF	226.55	226.56	226.55	226.56	18551.0
2017-01-19 06:30:00	SPY	ETF	226.56	226.56	226.55	226.56	600.0
2017-01-19 06:35:00	SPY	ETF	226.56	226.56	226.56	226.56	250.0
2017-01-19 06:40:00	SPY	ETF	226.56	226.56	226.56	226.56	500.0
2017-01-19 06:45:00	SPY	ETF	226.56	226.56	226.56	226.56	1511.0
2017-01-19 06:50:00	SPY	ETF	226.53	226.53	226.53	226.53	102.0
2017-01-19 07:00:00	SPY	ETF	226.58	226.59	226.56	226.56	19300.0
2017-01-19 07:05:00	SPY	ETF	226.59	226.59	226.56	226.56	3850.0
2017-01-19 07:10:00	SPY	ETF	226.55	226.56	226.55	226.56	3532.0
2017-01-19 07:15:00	SPY	ETF	226.56	226.56	226.55	226.55	701.0
2017-01-19 07:20:00	SPY	ETF	226.55	226.55	226.55	226.55	400.0
2017-01-19 07:25:00	SPY	ETF	226.56	226.56	226.56	226.56	3781.0
2017-01-19 07:30:00	SPY	ETF	226.52	226.53	226.52	226.53	3680.0
2017-01-19 07:35:00	SPY	ETF	226.51	226.51	226.5	226.5	5500.0
2017-01-19 07:40:00	SPY	ETF	226.56	226.56	226.52	226.52	3100.0
2017-01-19 07:45:00	SPY	ETF	226.55	226.58	226.55	226.56	3448.0
2017-01-19 07:50:00	SPY	ETF	226.52	226.52	226.45	226.5	7756.0
2017-01-19 07:55:00	SPY	ETF	226.51	226.56	226.5	226.52	7752.0
2017-01-19 08:00:00	SPY	ETF	226.51	226.59	226.48	226.52	19106.0
2017-01-19 08:05:00	SPY	ETF	226.53	226.54	226.5	226.51	7422.0
2017-01-19 08:10:00	SPY	ETF	226.5	226.51	226.45	226.48	27577.0
2017-01-19 08:15:00	SPY	ETF	226.47	226.5	226.44	226.5	20646.0
2017-01-19 08:20:00	SPY	ETF	226.75	226.75	226.5	226.54	5220.0
2017-01-19 08:25:00	SPY	ETF	226.55	226.55	226.46	226.5	31094.0
2017-01-19 08:30:00	SPY	ETF	226.51	226.69	226.5	226.69	39648.0
2017-01-19 08:35:00	SPY	ETF	226.65	226.66	226.57	226.66	106767.0
2017-01-19 08:40:00	SPY	ETF	226.66	226.73	226.65	226.66	72251.0
2017-01-19 08:45:00	SPY	ETF	226.7	226.7	226.64	226.65	9821.0
2017-01-19 08:50:00	SPY	ETF	226.66	226.66	226.6	226.64	15204.0
2017-01-19 08:55:00	SPY	ETF	226.64	226.7	226.64	226.65	11008.0
2017-01-19 09:00:00	SPY	ETF	226.65	226.66	226.61	226.62	8368.0
2017-01-19 09:05:00	SPY	ETF	226.65	226.68	226.62	226.68	23113.0
2017-01-19 09:10:00	SPY	ETF	226.67	226.67	226.64	226.65	1702.0
2017-01-19 09:15:00	SPY	ETF	226.67	226.68	226.62	226.68	12995.0
2017-01-19 09:20:00	SPY	ETF	226.69	226.79	226.69	226.79	75971.0
2017-01-19 09:25:00	SPY	ETF	226.76	226.85	226.76	226.83	239030.0

> showing 50 of 54,485 rows — these rows as CSV

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