PREVIEW / etf_5min / 2017-04-17

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-04-17.parquet
  size:    1.2 MB
  rows:    51,961

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-04-17 04:00:00	SPY	ETF	232.5	232.5	232.5	232.5	100.0
2017-04-17 04:05:00	SPY	ETF	232.51	232.51	232.5	232.5	325.0
2017-04-17 04:10:00	SPY	ETF	232.5	232.5	232.5	232.5	100.0
2017-04-17 04:20:00	SPY	ETF	232.49	232.49	232.46	232.46	300.0
2017-04-17 04:25:00	SPY	ETF	232.46	232.46	232.46	232.46	810.0
2017-04-17 04:40:00	SPY	ETF	232.51	232.51	232.51	232.51	425.0
2017-04-17 04:55:00	SPY	ETF	232.4	232.4	232.4	232.4	280.0
2017-04-17 05:15:00	SPY	ETF	232.4	232.4	232.4	232.4	304.0
2017-04-17 06:05:00	SPY	ETF	232.5	232.5	232.5	232.5	200.0
2017-04-17 06:25:00	SPY	ETF	232.5	232.5	232.5	232.5	200.0
2017-04-17 06:30:00	SPY	ETF	232.51	232.51	232.43	232.43	1010.0
2017-04-17 06:40:00	SPY	ETF	232.5	232.5	232.5	232.5	280.0
2017-04-17 06:45:00	SPY	ETF	232.52	232.52	232.52	232.52	3000.0
2017-04-17 06:50:00	SPY	ETF	232.52	232.52	232.48	232.48	400.0
2017-04-17 07:00:00	SPY	ETF	232.5	232.51	232.43	232.43	4100.0
2017-04-17 07:05:00	SPY	ETF	232.47	232.47	232.46	232.46	575.0
2017-04-17 07:10:00	SPY	ETF	232.47	232.49	232.46	232.46	3900.0
2017-04-17 07:15:00	SPY	ETF	232.49	232.49	232.49	232.49	250.0
2017-04-17 07:20:00	SPY	ETF	232.51	232.53	232.5	232.52	11547.0
2017-04-17 07:25:00	SPY	ETF	232.51	232.51	232.51	232.51	200.0
2017-04-17 07:30:00	SPY	ETF	232.52	232.53	232.52	232.53	9700.0
2017-04-17 07:35:00	SPY	ETF	232.57	232.67	232.57	232.64	1655.0
2017-04-17 07:40:00	SPY	ETF	232.65	232.87	232.65	232.86	18441.0
2017-04-17 07:45:00	SPY	ETF	232.86	232.91	232.81	232.91	17482.0
2017-04-17 07:50:00	SPY	ETF	232.88	232.98	232.88	232.96	32056.0
2017-04-17 07:55:00	SPY	ETF	232.98	233.01	232.94	233.01	54543.0
2017-04-17 08:00:00	SPY	ETF	233.01	233.02	232.46	232.91	40272.0
2017-04-17 08:05:00	SPY	ETF	232.93	232.95	232.91	232.95	4096.0
2017-04-17 08:10:00	SPY	ETF	232.96	233.0	232.91	232.94	17481.0
2017-04-17 08:15:00	SPY	ETF	232.92	232.94	232.91	232.92	57401.0
2017-04-17 08:20:00	SPY	ETF	232.92	232.95	232.92	232.95	33805.0
2017-04-17 08:25:00	SPY	ETF	232.94	233.1	232.93	233.06	70089.0
2017-04-17 08:30:00	SPY	ETF	233.01	233.15	232.98	233.15	234989.0
2017-04-17 08:35:00	SPY	ETF	233.15	233.2	233.12	233.15	50538.0
2017-04-17 08:40:00	SPY	ETF	233.14	233.16	233.07	233.07	81365.0
2017-04-17 08:45:00	SPY	ETF	233.07	233.12	233.03	233.12	14927.0
2017-04-17 08:50:00	SPY	ETF	233.1	233.17	233.1	233.12	44783.0
2017-04-17 08:55:00	SPY	ETF	233.13	233.16	233.1	233.14	57231.0
2017-04-17 09:00:00	SPY	ETF	233.14	233.21	233.12	233.21	49214.0
2017-04-17 09:05:00	SPY	ETF	233.18	233.24	233.16	233.18	40828.0
2017-04-17 09:10:00	SPY	ETF	233.16	233.16	233.08	233.13	10705.0
2017-04-17 09:15:00	SPY	ETF	233.13	233.17	233.13	233.14	4624.0
2017-04-17 09:20:00	SPY	ETF	233.16	233.17	233.15	233.17	4149.0
2017-04-17 09:25:00	SPY	ETF	233.16	233.16	233.06	233.1	147347.0
2017-04-17 09:30:00	SPY	ETF	233.11	233.31	233.08	233.31	1849692.0
2017-04-17 09:35:00	SPY	ETF	233.3	233.34	233.12	233.14	1207042.0
2017-04-17 09:40:00	SPY	ETF	233.135	233.16	232.88	233.01	1181318.0
2017-04-17 09:45:00	SPY	ETF	233.0	233.11	232.97	233.103	931663.0
2017-04-17 09:50:00	SPY	ETF	233.1	233.2993	233.08	233.275	639690.0
2017-04-17 09:55:00	SPY	ETF	233.28	233.3	233.18	233.22	722315.0

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

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