PREVIEW / etf_5min / 2017-09-08

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-09-08.parquet
  size:    1.2 MB
  rows:    51,918

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-09-08 04:00:00	SPY	ETF	246.51	246.55	246.46	246.46	3009.0
2017-09-08 04:05:00	SPY	ETF	246.47	246.47	246.47	246.47	1010.0
2017-09-08 04:15:00	SPY	ETF	246.41	246.41	246.41	246.41	210.0
2017-09-08 04:20:00	SPY	ETF	246.4	246.4	246.4	246.4	250.0
2017-09-08 04:25:00	SPY	ETF	246.36	246.36	246.36	246.36	500.0
2017-09-08 04:30:00	SPY	ETF	246.36	246.36	246.31	246.31	2460.0
2017-09-08 04:40:00	SPY	ETF	246.41	246.44	246.41	246.44	600.0
2017-09-08 04:45:00	SPY	ETF	246.41	246.41	246.41	246.41	625.0
2017-09-08 04:50:00	SPY	ETF	246.3	246.3	246.3	246.3	100.0
2017-09-08 04:55:00	SPY	ETF	246.3	246.3	246.26	246.27	700.0
2017-09-08 05:10:00	SPY	ETF	246.52	246.52	246.52	246.52	250.0
2017-09-08 05:15:00	SPY	ETF	246.6	246.6	246.58	246.58	500.0
2017-09-08 05:30:00	SPY	ETF	246.6	246.62	246.6	246.62	301.0
2017-09-08 05:35:00	SPY	ETF	246.64	246.64	246.64	246.64	400.0
2017-09-08 05:40:00	SPY	ETF	246.6	246.6	246.6	246.6	200.0
2017-09-08 05:55:00	SPY	ETF	246.4	246.4	246.4	246.4	100.0
2017-09-08 06:05:00	SPY	ETF	246.5	246.5	246.5	246.5	100.0
2017-09-08 06:10:00	SPY	ETF	246.49	246.49	246.49	246.49	550.0
2017-09-08 06:25:00	SPY	ETF	246.4	246.4	246.4	246.4	204.0
2017-09-08 06:40:00	SPY	ETF	246.28	246.28	246.28	246.28	200.0
2017-09-08 06:45:00	SPY	ETF	246.3	246.3	246.2	246.2	6338.0
2017-09-08 06:50:00	SPY	ETF	246.17	246.2	246.14	246.2	6203.0
2017-09-08 06:55:00	SPY	ETF	246.2	246.2	246.17	246.18	5701.0
2017-09-08 07:00:00	SPY	ETF	246.2	246.2	246.18	246.2	21201.0
2017-09-08 07:05:00	SPY	ETF	246.2	246.29	246.19	246.29	11682.0
2017-09-08 07:10:00	SPY	ETF	246.27	246.35	246.25	246.35	6578.0
2017-09-08 07:15:00	SPY	ETF	246.34	246.34	246.3	246.3	4253.0
2017-09-08 07:20:00	SPY	ETF	246.33	246.38	246.33	246.38	7699.0
2017-09-08 07:25:00	SPY	ETF	246.38	246.38	246.35	246.35	6200.0
2017-09-08 07:30:00	SPY	ETF	246.37	246.39	246.34	246.34	17469.0
2017-09-08 07:35:00	SPY	ETF	246.35	246.36	246.33	246.36	4350.0
2017-09-08 07:40:00	SPY	ETF	246.35	246.35	246.33	246.35	510.0
2017-09-08 07:45:00	SPY	ETF	246.36	246.41	246.36	246.41	4792.0
2017-09-08 07:50:00	SPY	ETF	246.45	246.45	246.4	246.42	4402.0
2017-09-08 07:55:00	SPY	ETF	246.42	246.43	246.42	246.43	20100.0
2017-09-08 08:00:00	SPY	ETF	246.18	246.43	246.18	246.38	23837.0
2017-09-08 08:05:00	SPY	ETF	246.38	246.39	246.34	246.36	25293.0
2017-09-08 08:10:00	SPY	ETF	246.36	246.36	246.33	246.34	6952.0
2017-09-08 08:15:00	SPY	ETF	246.38	246.43	246.38	246.39	9069.0
2017-09-08 08:20:00	SPY	ETF	246.39	246.39	246.34	246.34	29832.0
2017-09-08 08:25:00	SPY	ETF	246.35	246.52	246.35	246.5	24083.0
2017-09-08 08:30:00	SPY	ETF	246.5	246.55	246.49	246.55	18103.0
2017-09-08 08:35:00	SPY	ETF	246.54	246.55	246.5	246.5	19370.0
2017-09-08 08:40:00	SPY	ETF	246.47	246.47	246.45	246.46	8850.0
2017-09-08 08:45:00	SPY	ETF	246.46	246.49	246.46	246.49	34341.0
2017-09-08 08:50:00	SPY	ETF	246.47	246.58	246.46	246.56	33770.0
2017-09-08 08:55:00	SPY	ETF	246.57	246.57	246.54	246.55	2959.0
2017-09-08 09:00:00	SPY	ETF	246.56	246.56	246.46	246.5	22886.0
2017-09-08 09:05:00	SPY	ETF	246.5	246.5	246.44	246.47	14141.0
2017-09-08 09:10:00	SPY	ETF	246.46	246.46	246.43	246.43	6566.0

> showing 50 of 51,918 rows — these rows as CSV

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