PREVIEW / etf_5min / 2017-05-11

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-05-11.parquet
  size:    1.2 MB
  rows:    53,341

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-05-11 04:00:00	SPY	ETF	239.65	239.65	239.65	239.65	522.0
2017-05-11 04:10:00	SPY	ETF	239.57	239.57	239.57	239.57	6000.0
2017-05-11 04:55:00	SPY	ETF	239.51	239.55	239.51	239.52	700.0
2017-05-11 05:05:00	SPY	ETF	239.49	239.49	239.49	239.49	100.0
2017-05-11 05:30:00	SPY	ETF	239.51	239.51	239.51	239.51	100.0
2017-05-11 05:35:00	SPY	ETF	239.47	239.5	239.47	239.5	8290.0
2017-05-11 05:40:00	SPY	ETF	239.5	239.5	239.44	239.44	7000.0
2017-05-11 05:45:00	SPY	ETF	239.42	239.42	239.4	239.4	1110.0
2017-05-11 05:50:00	SPY	ETF	239.4	239.41	239.34	239.34	10300.0
2017-05-11 06:05:00	SPY	ETF	239.37	239.38	239.37	239.38	1050.0
2017-05-11 06:15:00	SPY	ETF	239.38	239.38	239.35	239.35	1825.0
2017-05-11 06:20:00	SPY	ETF	239.35	239.35	239.32	239.32	1205.0
2017-05-11 06:25:00	SPY	ETF	239.33	239.38	239.33	239.38	5305.0
2017-05-11 06:30:00	SPY	ETF	239.35	239.35	239.35	239.35	1000.0
2017-05-11 06:45:00	SPY	ETF	239.38	239.38	239.38	239.38	12322.0
2017-05-11 06:50:00	SPY	ETF	239.38	239.41	239.37	239.41	6200.0
2017-05-11 06:55:00	SPY	ETF	239.38	239.38	239.38	239.38	500.0
2017-05-11 07:00:00	SPY	ETF	239.38	239.38	239.36	239.36	2575.0
2017-05-11 07:05:00	SPY	ETF	239.38	239.38	239.33	239.33	2200.0
2017-05-11 07:10:00	SPY	ETF	239.38	239.38	239.38	239.38	450.0
2017-05-11 07:15:00	SPY	ETF	239.41	239.41	239.37	239.37	7500.0
2017-05-11 07:20:00	SPY	ETF	239.4	239.41	239.4	239.41	2455.0
2017-05-11 07:25:00	SPY	ETF	239.44	239.44	239.44	239.44	4000.0
2017-05-11 07:30:00	SPY	ETF	239.44	239.44	239.4	239.44	7119.0
2017-05-11 07:35:00	SPY	ETF	239.43	239.46	239.42	239.46	11119.0
2017-05-11 07:40:00	SPY	ETF	239.45	239.45	239.34	239.34	23809.0
2017-05-11 07:45:00	SPY	ETF	239.36	239.36	239.14	239.16	28234.0
2017-05-11 07:50:00	SPY	ETF	239.16	239.19	239.07	239.15	95685.0
2017-05-11 07:55:00	SPY	ETF	239.15	239.2	239.13	239.2	14839.0
2017-05-11 08:00:00	SPY	ETF	239.15	239.4	239.1	239.2	67412.0
2017-05-11 08:05:00	SPY	ETF	239.2	239.2	239.14	239.14	42529.0
2017-05-11 08:10:00	SPY	ETF	239.13	239.14	239.09	239.11	26655.0
2017-05-11 08:15:00	SPY	ETF	239.12	239.18	239.12	239.18	22001.0
2017-05-11 08:20:00	SPY	ETF	239.17	239.21	239.17	239.19	8637.0
2017-05-11 08:25:00	SPY	ETF	239.17	239.19	239.11	239.13	32103.0
2017-05-11 08:30:00	SPY	ETF	239.14	239.18	239.04	239.16	90666.0
2017-05-11 08:35:00	SPY	ETF	239.14	239.17	239.11	239.16	17159.0
2017-05-11 08:40:00	SPY	ETF	239.18	239.29	239.18	239.29	53718.0
2017-05-11 08:45:00	SPY	ETF	239.29	239.34	239.26	239.33	69853.0
2017-05-11 08:50:00	SPY	ETF	239.33	239.35	239.3	239.34	88338.0
2017-05-11 08:55:00	SPY	ETF	239.33	239.33	239.3	239.3	4875.0
2017-05-11 09:00:00	SPY	ETF	239.32	239.32	239.27	239.31	13998.0
2017-05-11 09:05:00	SPY	ETF	239.3	239.35	239.28	239.34	50771.0
2017-05-11 09:10:00	SPY	ETF	239.34	239.35	239.32	239.32	22648.0
2017-05-11 09:15:00	SPY	ETF	239.33	239.34	239.3	239.33	20163.0
2017-05-11 09:20:00	SPY	ETF	239.33	239.34	239.26	239.27	26699.0
2017-05-11 09:25:00	SPY	ETF	239.26	239.34	239.26	239.33	19373.0
2017-05-11 09:30:00	SPY	ETF	239.35	239.43	239.31	239.42	1219768.0
2017-05-11 09:35:00	SPY	ETF	239.42	239.46	239.21	239.22	922850.0
2017-05-11 09:40:00	SPY	ETF	239.22	239.24	239.01	239.06	1028953.0

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

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