PREVIEW / etf_5min / 2017-11-10

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-11-10.parquet
  size:    1.2 MB
  rows:    52,756

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-11-10 04:00:00	SPY	ETF	257.73	257.79	257.73	257.79	1600.0
2017-11-10 04:05:00	SPY	ETF	257.73	257.73	257.7	257.7	300.0
2017-11-10 04:10:00	SPY	ETF	257.6	257.6	257.52	257.52	5900.0
2017-11-10 04:15:00	SPY	ETF	257.5	257.5	257.37	257.45	6400.0
2017-11-10 04:20:00	SPY	ETF	257.58	257.58	257.58	257.58	201.0
2017-11-10 04:25:00	SPY	ETF	257.4	257.43	257.16	257.23	7645.0
2017-11-10 04:30:00	SPY	ETF	257.24	257.24	257.23	257.23	808.0
2017-11-10 04:35:00	SPY	ETF	257.3	257.3	257.25	257.3	5432.0
2017-11-10 04:40:00	SPY	ETF	257.3	257.31	257.17	257.25	5104.0
2017-11-10 04:45:00	SPY	ETF	257.36	257.36	257.32	257.32	9507.0
2017-11-10 04:50:00	SPY	ETF	257.32	257.33	257.25	257.25	1027.0
2017-11-10 04:55:00	SPY	ETF	257.23	257.23	257.23	257.23	2005.0
2017-11-10 05:00:00	SPY	ETF	257.31	257.31	257.31	257.31	100.0
2017-11-10 05:10:00	SPY	ETF	257.46	257.46	257.35	257.35	3304.0
2017-11-10 05:20:00	SPY	ETF	257.45	257.48	257.43	257.43	2003.0
2017-11-10 05:25:00	SPY	ETF	257.4	257.4	257.4	257.4	604.0
2017-11-10 05:30:00	SPY	ETF	257.46	257.46	257.46	257.46	1003.0
2017-11-10 05:40:00	SPY	ETF	257.49	257.49	257.49	257.49	101.0
2017-11-10 06:00:00	SPY	ETF	257.58	257.6	257.54	257.6	1409.0
2017-11-10 06:05:00	SPY	ETF	257.59	257.59	257.59	257.59	202.0
2017-11-10 06:10:00	SPY	ETF	257.63	257.63	257.6	257.63	3402.0
2017-11-10 06:15:00	SPY	ETF	257.63	257.63	257.6	257.61	3043.0
2017-11-10 06:20:00	SPY	ETF	257.6	257.6	257.58	257.58	602.0
2017-11-10 06:25:00	SPY	ETF	257.56	257.56	257.56	257.56	301.0
2017-11-10 06:30:00	SPY	ETF	257.56	257.56	257.48	257.48	3855.0
2017-11-10 06:35:00	SPY	ETF	257.44	257.44	257.41	257.41	1104.0
2017-11-10 06:40:00	SPY	ETF	257.41	257.41	257.37	257.37	2214.0
2017-11-10 06:45:00	SPY	ETF	257.39	257.43	257.39	257.41	1103.0
2017-11-10 06:50:00	SPY	ETF	257.43	257.46	257.43	257.46	4102.0
2017-11-10 06:55:00	SPY	ETF	257.47	257.47	257.47	257.47	103.0
2017-11-10 07:00:00	SPY	ETF	257.42	257.6	257.42	257.52	32937.0
2017-11-10 07:05:00	SPY	ETF	257.5	257.52	257.45	257.45	5328.0
2017-11-10 07:10:00	SPY	ETF	257.42	257.42	257.32	257.39	49347.0
2017-11-10 07:15:00	SPY	ETF	257.36	257.4	257.35	257.37	18602.0
2017-11-10 07:20:00	SPY	ETF	257.4	257.46	257.4	257.46	2603.0
2017-11-10 07:25:00	SPY	ETF	257.46	257.48	257.46	257.48	18569.0
2017-11-10 07:30:00	SPY	ETF	257.45	257.48	257.44	257.48	3993.0
2017-11-10 07:35:00	SPY	ETF	257.5	257.52	257.5	257.52	10473.0
2017-11-10 07:40:00	SPY	ETF	257.5	257.52	257.46	257.52	25102.0
2017-11-10 07:45:00	SPY	ETF	257.47	257.53	257.47	257.53	3440.0
2017-11-10 07:50:00	SPY	ETF	257.56	257.61	257.55	257.61	79562.0
2017-11-10 07:55:00	SPY	ETF	257.58	257.7	257.58	257.66	33704.0
2017-11-10 08:00:00	SPY	ETF	257.65	257.68	257.38	257.63	28251.0
2017-11-10 08:05:00	SPY	ETF	257.62	257.7	257.62	257.69	19203.0
2017-11-10 08:10:00	SPY	ETF	257.69	257.73	257.69	257.72	132239.0
2017-11-10 08:15:00	SPY	ETF	257.71	257.79	257.71	257.76	39098.0
2017-11-10 08:20:00	SPY	ETF	257.76	257.76	257.67	257.67	18217.0
2017-11-10 08:25:00	SPY	ETF	257.65	257.71	257.65	257.68	9551.0
2017-11-10 08:30:00	SPY	ETF	257.69	257.74	257.69	257.7	22592.0
2017-11-10 08:35:00	SPY	ETF	257.71	257.78	257.68	257.77	25068.0

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

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