PREVIEW / etf_5min / 2018-08-22

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-08-22.parquet
  size:    1.3 MB
  rows:    56,130

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-08-22 04:00:00	SPY	ETF	285.26	285.47	285.26	285.47	720.0
2018-08-22 04:05:00	SPY	ETF	285.43	285.48	285.42	285.48	3236.0
2018-08-22 04:10:00	SPY	ETF	285.48	285.58	285.47	285.47	2100.0
2018-08-22 04:15:00	SPY	ETF	285.5	285.5	285.48	285.48	1070.0
2018-08-22 04:20:00	SPY	ETF	285.4	285.4	285.38	285.38	1051.0
2018-08-22 04:25:00	SPY	ETF	285.3	285.3	285.3	285.3	300.0
2018-08-22 04:30:00	SPY	ETF	285.39	285.39	285.25	285.3	2205.0
2018-08-22 04:35:00	SPY	ETF	285.32	285.38	285.32	285.38	600.0
2018-08-22 04:45:00	SPY	ETF	285.44	285.44	285.41	285.41	320.0
2018-08-22 04:55:00	SPY	ETF	285.47	285.55	285.47	285.55	900.0
2018-08-22 05:00:00	SPY	ETF	285.55	285.58	285.53	285.58	3170.0
2018-08-22 05:05:00	SPY	ETF	285.56	285.56	285.42	285.48	582.0
2018-08-22 05:10:00	SPY	ETF	285.56	285.56	285.56	285.56	200.0
2018-08-22 05:15:00	SPY	ETF	285.46	285.55	285.46	285.55	200.0
2018-08-22 05:25:00	SPY	ETF	285.46	285.46	285.42	285.42	404.0
2018-08-22 05:30:00	SPY	ETF	285.43	285.43	285.41	285.41	534.0
2018-08-22 05:35:00	SPY	ETF	285.41	285.45	285.41	285.43	1000.0
2018-08-22 05:40:00	SPY	ETF	285.59	285.59	285.48	285.48	400.0
2018-08-22 05:55:00	SPY	ETF	285.54	285.54	285.42	285.42	3610.0
2018-08-22 06:00:00	SPY	ETF	285.48	285.48	285.48	285.48	1350.0
2018-08-22 06:05:00	SPY	ETF	285.54	285.61	285.53	285.61	16466.0
2018-08-22 06:10:00	SPY	ETF	285.61	285.77	285.61	285.75	4368.0
2018-08-22 06:15:00	SPY	ETF	285.8	285.83	285.77	285.8	8020.0
2018-08-22 06:20:00	SPY	ETF	285.84	285.84	285.75	285.75	600.0
2018-08-22 06:25:00	SPY	ETF	285.75	285.75	285.72	285.75	4600.0
2018-08-22 06:30:00	SPY	ETF	285.77	285.77	285.7	285.75	818.0
2018-08-22 06:35:00	SPY	ETF	285.68	285.7	285.67	285.7	1800.0
2018-08-22 06:40:00	SPY	ETF	285.7	285.7	285.7	285.7	1000.0
2018-08-22 06:45:00	SPY	ETF	285.75	285.85	285.75	285.84	15205.0
2018-08-22 06:50:00	SPY	ETF	285.82	285.85	285.82	285.85	7510.0
2018-08-22 06:55:00	SPY	ETF	285.87	285.9	285.87	285.9	2177.0
2018-08-22 07:00:00	SPY	ETF	285.9	286.05	285.9	286.0	39476.0
2018-08-22 07:05:00	SPY	ETF	285.97	286.02	285.89	285.9	8476.0
2018-08-22 07:10:00	SPY	ETF	285.9	285.9	285.8	285.82	22583.0
2018-08-22 07:15:00	SPY	ETF	285.85	285.85	285.77	285.85	15264.0
2018-08-22 07:20:00	SPY	ETF	285.78	285.78	285.67	285.73	26459.0
2018-08-22 07:25:00	SPY	ETF	285.71	285.72	285.66	285.66	3300.0
2018-08-22 07:30:00	SPY	ETF	285.68	285.81	285.68	285.8	4987.0
2018-08-22 07:35:00	SPY	ETF	285.81	285.81	285.71	285.71	1700.0
2018-08-22 07:40:00	SPY	ETF	285.66	285.69	285.6	285.6	57049.0
2018-08-22 07:45:00	SPY	ETF	285.57	285.61	285.56	285.56	25090.0
2018-08-22 07:50:00	SPY	ETF	285.59	285.64	285.53	285.59	83206.0
2018-08-22 07:55:00	SPY	ETF	285.63	285.63	285.6	285.6	4200.0
2018-08-22 08:00:00	SPY	ETF	285.822	286.05	285.55	285.63	17724.0
2018-08-22 08:05:00	SPY	ETF	285.63	285.68	285.58	285.65	46196.0
2018-08-22 08:10:00	SPY	ETF	285.65	285.66	285.52	285.56	46796.0
2018-08-22 08:15:00	SPY	ETF	285.55	285.55	285.36	285.38	60080.0
2018-08-22 08:20:00	SPY	ETF	285.4	285.41	285.36	285.39	87319.0
2018-08-22 08:25:00	SPY	ETF	285.37	285.37	285.29	285.36	237273.0
2018-08-22 08:30:00	SPY	ETF	285.34	285.41	285.24	285.28	360739.0

> showing 50 of 56,130 rows — these rows as CSV

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