PREVIEW / etf_5min / 2017-01-10

all etf 5-min files

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

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-10 04:00:00	SPY	ETF	226.46	226.46	226.4	226.4	294.0
2017-01-10 04:10:00	SPY	ETF	226.42	226.42	226.42	226.42	205.0
2017-01-10 04:25:00	SPY	ETF	226.47	226.47	226.47	226.47	102.0
2017-01-10 05:10:00	SPY	ETF	226.53	226.53	226.53	226.53	101.0
2017-01-10 05:25:00	SPY	ETF	226.57	226.66	226.57	226.66	1306.0
2017-01-10 05:30:00	SPY	ETF	226.69	226.7	226.67	226.67	304.0
2017-01-10 05:35:00	SPY	ETF	226.68	226.68	226.68	226.68	1300.0
2017-01-10 05:40:00	SPY	ETF	226.63	226.63	226.63	226.63	2304.0
2017-01-10 05:55:00	SPY	ETF	226.66	226.66	226.66	226.66	251.0
2017-01-10 06:30:00	SPY	ETF	226.63	226.63	226.63	226.63	100.0
2017-01-10 06:40:00	SPY	ETF	226.69	226.69	226.69	226.69	302.0
2017-01-10 06:45:00	SPY	ETF	226.69	226.69	226.69	226.69	500.0
2017-01-10 06:55:00	SPY	ETF	226.61	226.61	226.61	226.61	400.0
2017-01-10 07:00:00	SPY	ETF	226.55	226.56	226.55	226.55	2600.0
2017-01-10 07:05:00	SPY	ETF	226.62	226.62	226.62	226.62	1500.0
2017-01-10 07:10:00	SPY	ETF	226.62	226.62	226.62	226.62	301.0
2017-01-10 07:15:00	SPY	ETF	226.63	226.63	226.61	226.61	450.0
2017-01-10 07:20:00	SPY	ETF	226.62	226.62	226.62	226.62	2600.0
2017-01-10 07:25:00	SPY	ETF	226.61	226.61	226.61	226.61	300.0
2017-01-10 07:30:00	SPY	ETF	226.59	226.64	226.59	226.63	15100.0
2017-01-10 07:40:00	SPY	ETF	226.63	226.63	226.61	226.61	970.0
2017-01-10 07:45:00	SPY	ETF	226.58	226.61	226.58	226.59	6619.0
2017-01-10 07:50:00	SPY	ETF	226.59	226.62	226.59	226.62	35796.0
2017-01-10 07:55:00	SPY	ETF	226.56	226.56	226.48	226.48	2403.0
2017-01-10 08:00:00	SPY	ETF	226.6	226.61	226.46	226.47	18669.0
2017-01-10 08:05:00	SPY	ETF	226.5	226.52	226.49	226.52	15636.0
2017-01-10 08:10:00	SPY	ETF	226.54	226.58	226.54	226.58	12354.0
2017-01-10 08:15:00	SPY	ETF	226.58	226.59	226.48	226.48	22345.0
2017-01-10 08:20:00	SPY	ETF	226.5	226.5	226.44	226.46	25528.0
2017-01-10 08:25:00	SPY	ETF	226.46	226.47	226.44	226.45	19109.0
2017-01-10 08:30:00	SPY	ETF	226.46	226.48	226.44	226.48	14058.0
2017-01-10 08:35:00	SPY	ETF	226.5	226.53	226.48	226.51	15017.0
2017-01-10 08:40:00	SPY	ETF	226.53	226.54	226.52	226.53	6753.0
2017-01-10 08:45:00	SPY	ETF	226.51	226.53	226.46	226.48	6031.0
2017-01-10 08:50:00	SPY	ETF	226.48	226.51	226.46	226.47	30635.0
2017-01-10 08:55:00	SPY	ETF	226.46	226.49	226.43	226.49	13068.0
2017-01-10 09:00:00	SPY	ETF	226.54	226.55	226.51	226.51	11549.0
2017-01-10 09:05:00	SPY	ETF	226.51	226.51	226.49	226.5	5387.0
2017-01-10 09:10:00	SPY	ETF	226.53	226.55	226.5	226.52	6890.0
2017-01-10 09:15:00	SPY	ETF	226.52	226.52	226.48	226.49	6125.0
2017-01-10 09:20:00	SPY	ETF	226.52	226.57	226.5	226.57	41077.0
2017-01-10 09:25:00	SPY	ETF	226.55	226.55	226.47	226.48	119484.0
2017-01-10 09:30:00	SPY	ETF	226.48	226.49	226.2	226.36	1667239.0
2017-01-10 09:35:00	SPY	ETF	226.36	226.42	226.28	226.29	782070.0
2017-01-10 09:40:00	SPY	ETF	226.3	226.33	226.18	226.25	826054.0
2017-01-10 09:45:00	SPY	ETF	226.25	226.35	226.23	226.34	431294.0
2017-01-10 09:50:00	SPY	ETF	226.35	226.46	226.01	226.12	1596802.0
2017-01-10 09:55:00	SPY	ETF	226.12	226.295	226.1	226.27	592874.0
2017-01-10 10:00:00	SPY	ETF	226.27	226.43	226.26	226.37	645810.0
2017-01-10 10:05:00	SPY	ETF	226.375	226.43	226.33	226.34	1686173.0

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

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