PREVIEW / etf_5min / 2018-04-20

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-04-20.parquet
  size:    1.3 MB
  rows:    55,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
2018-04-20 04:00:00	SPY	ETF	268.1	268.21	268.1	268.2	1164.0
2018-04-20 04:05:00	SPY	ETF	268.3	268.4	268.3	268.38	1090.0
2018-04-20 04:10:00	SPY	ETF	268.41	268.42	268.38	268.38	1150.0
2018-04-20 04:20:00	SPY	ETF	268.32	268.32	268.32	268.32	100.0
2018-04-20 04:25:00	SPY	ETF	268.29	268.29	268.29	268.29	500.0
2018-04-20 04:30:00	SPY	ETF	268.33	268.37	268.33	268.37	3100.0
2018-04-20 04:35:00	SPY	ETF	268.33	268.43	268.33	268.43	1300.0
2018-04-20 04:45:00	SPY	ETF	268.34	268.34	268.34	268.34	100.0
2018-04-20 04:50:00	SPY	ETF	268.39	268.39	268.33	268.33	200.0
2018-04-20 04:55:00	SPY	ETF	268.39	268.5	268.39	268.5	200.0
2018-04-20 05:00:00	SPY	ETF	268.52	268.55	268.45	268.45	1430.0
2018-04-20 05:10:00	SPY	ETF	268.38	268.38	268.37	268.37	600.0
2018-04-20 05:15:00	SPY	ETF	268.33	268.33	268.25	268.25	1110.0
2018-04-20 05:25:00	SPY	ETF	268.15	268.24	268.03	268.24	5900.0
2018-04-20 05:45:00	SPY	ETF	268.45	268.45	268.37	268.37	1050.0
2018-04-20 05:50:00	SPY	ETF	268.53	268.76	268.53	268.76	8850.0
2018-04-20 05:55:00	SPY	ETF	268.78	268.78	268.77	268.77	2675.0
2018-04-20 06:00:00	SPY	ETF	268.77	268.79	268.69	268.72	15400.0
2018-04-20 06:05:00	SPY	ETF	268.72	268.72	268.63	268.63	2925.0
2018-04-20 06:10:00	SPY	ETF	268.77	268.77	268.73	268.73	900.0
2018-04-20 06:25:00	SPY	ETF	268.63	268.63	268.63	268.63	300.0
2018-04-20 06:30:00	SPY	ETF	268.62	268.68	268.62	268.68	2300.0
2018-04-20 06:35:00	SPY	ETF	268.82	269.0	268.82	269.0	18323.0
2018-04-20 06:40:00	SPY	ETF	268.89	268.99	268.89	268.91	28780.0
2018-04-20 06:45:00	SPY	ETF	268.87	268.95	268.87	268.95	680.0
2018-04-20 06:50:00	SPY	ETF	268.88	269.12	268.86	269.12	5734.0
2018-04-20 06:55:00	SPY	ETF	269.12	269.24	269.12	269.23	5810.0
2018-04-20 07:00:00	SPY	ETF	269.21	269.35	269.2	269.35	22615.0
2018-04-20 07:05:00	SPY	ETF	269.38	269.43	269.31	269.31	18319.0
2018-04-20 07:10:00	SPY	ETF	269.26	269.29	269.2	269.2	1448.0
2018-04-20 07:15:00	SPY	ETF	269.21	269.27	269.18	269.27	8000.0
2018-04-20 07:20:00	SPY	ETF	269.2	269.24	269.11	269.11	4433.0
2018-04-20 07:25:00	SPY	ETF	269.09	269.11	269.05	269.05	1753.0
2018-04-20 07:30:00	SPY	ETF	269.07	269.11	269.04	269.04	7282.0
2018-04-20 07:35:00	SPY	ETF	269.01	269.05	268.98	269.05	13973.0
2018-04-20 07:40:00	SPY	ETF	269.0	269.0	268.98	268.98	5500.0
2018-04-20 07:45:00	SPY	ETF	268.98	269.04	268.98	269.04	10425.0
2018-04-20 07:50:00	SPY	ETF	269.07	269.07	269.02	269.07	4147.0
2018-04-20 07:55:00	SPY	ETF	269.06	269.1	269.01	269.03	5300.0
2018-04-20 08:00:00	SPY	ETF	269.08	269.11	268.05	269.08	14221.0
2018-04-20 08:05:00	SPY	ETF	269.04	269.09	268.9	268.9	5297.0
2018-04-20 08:10:00	SPY	ETF	268.89	268.9	268.72	268.8	24881.0
2018-04-20 08:15:00	SPY	ETF	268.85	268.86	268.79	268.81	17360.0
2018-04-20 08:20:00	SPY	ETF	268.85	268.85	268.72	268.76	46015.0
2018-04-20 08:25:00	SPY	ETF	268.74	268.82	268.74	268.81	15624.0
2018-04-20 08:30:00	SPY	ETF	268.85	268.85	268.62	268.69	66585.0
2018-04-20 08:35:00	SPY	ETF	268.72	268.8	268.72	268.73	3668.0
2018-04-20 08:40:00	SPY	ETF	268.76	268.91	268.76	268.89	60515.0
2018-04-20 08:45:00	SPY	ETF	268.89	269.08	268.89	269.01	36874.0
2018-04-20 08:50:00	SPY	ETF	269.0	269.07	269.0	269.01	20422.0

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

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