PREVIEW / etf_5min / 2020-03-25

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-03-25.parquet
  size:    2.0 MB
  rows:    88,597

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
2020-03-25 04:00:00	SPY	ETF	246.89	247.0	245.55	245.63	48742.0
2020-03-25 04:05:00	SPY	ETF	245.3	246.01	245.1	245.97	23584.0
2020-03-25 04:10:00	SPY	ETF	245.82	246.74	245.75	246.63	25291.0
2020-03-25 04:15:00	SPY	ETF	246.62	247.0	246.22	246.91	15112.0
2020-03-25 04:20:00	SPY	ETF	247.06	247.23	246.85	247.17	23190.0
2020-03-25 04:25:00	SPY	ETF	247.16	247.97	247.12	247.95	17408.0
2020-03-25 04:30:00	SPY	ETF	247.81	248.19	247.71	248.11	18985.0
2020-03-25 04:35:00	SPY	ETF	248.11	248.17	246.9	247.1	32009.0
2020-03-25 04:40:00	SPY	ETF	247.13	248.1	247.0	248.06	9620.0
2020-03-25 04:45:00	SPY	ETF	247.97	248.1	247.87	247.9	8380.0
2020-03-25 04:50:00	SPY	ETF	247.81	248.48	247.81	248.48	13604.0
2020-03-25 04:55:00	SPY	ETF	248.46	248.74	248.09	248.09	22113.0
2020-03-25 05:00:00	SPY	ETF	248.25	248.96	248.2	248.83	16657.0
2020-03-25 05:05:00	SPY	ETF	248.8	249.63	248.68	249.57	28561.0
2020-03-25 05:10:00	SPY	ETF	249.64	249.66	249.38	249.48	16021.0
2020-03-25 05:15:00	SPY	ETF	249.53	249.54	249.05	249.06	14294.0
2020-03-25 05:20:00	SPY	ETF	249.11	249.5	248.86	249.43	26522.0
2020-03-25 05:25:00	SPY	ETF	249.51	249.97	249.51	249.97	36640.0
2020-03-25 05:30:00	SPY	ETF	249.83	250.0	249.06	249.23	31186.0
2020-03-25 05:35:00	SPY	ETF	249.23	249.27	248.8	249.2	15816.0
2020-03-25 05:40:00	SPY	ETF	249.27	249.28	248.1	248.22	18952.0
2020-03-25 05:45:00	SPY	ETF	248.24	248.85	248.22	248.4	14007.0
2020-03-25 05:50:00	SPY	ETF	248.28	248.28	247.57	247.69	16907.0
2020-03-25 05:55:00	SPY	ETF	247.51	247.94	247.21	247.94	34357.0
2020-03-25 06:00:00	SPY	ETF	247.8	247.94	247.4	247.75	21710.0
2020-03-25 06:05:00	SPY	ETF	247.88	247.93	246.89	247.0	20112.0
2020-03-25 06:10:00	SPY	ETF	246.91	246.94	246.51	246.67	18416.0
2020-03-25 06:15:00	SPY	ETF	246.63	247.18	246.03	246.03	47344.0
2020-03-25 06:20:00	SPY	ETF	246.25	246.52	245.97	246.4	25805.0
2020-03-25 06:25:00	SPY	ETF	246.01	246.07	245.62	245.83	59563.0
2020-03-25 06:30:00	SPY	ETF	245.8	246.0	245.03	245.03	43486.0
2020-03-25 06:35:00	SPY	ETF	245.01	245.13	243.89	244.87	83197.0
2020-03-25 06:40:00	SPY	ETF	244.7	244.7	243.13	243.77	75152.0
2020-03-25 06:45:00	SPY	ETF	243.67	243.74	242.34	242.88	53699.0
2020-03-25 06:50:00	SPY	ETF	242.78	242.85	240.41	241.4	114261.0
2020-03-25 06:55:00	SPY	ETF	241.4	242.01	240.47	240.7	136171.0
2020-03-25 07:00:00	SPY	ETF	240.6	242.05	240.5	241.82	200976.0
2020-03-25 07:05:00	SPY	ETF	241.7	243.0	241.03	241.48	416044.0
2020-03-25 07:10:00	SPY	ETF	241.35	241.5	240.1	240.91	240647.0
2020-03-25 07:15:00	SPY	ETF	240.91	241.55	240.11	240.94	273739.0
2020-03-25 07:20:00	SPY	ETF	240.82	242.01	240.36	242.0	213016.0
2020-03-25 07:25:00	SPY	ETF	242.05	242.6	241.16	241.51	94698.0
2020-03-25 07:30:00	SPY	ETF	241.71	241.91	239.05	239.05	245850.0
2020-03-25 07:35:00	SPY	ETF	239.05	239.98	239.03	239.86	209672.0
2020-03-25 07:40:00	SPY	ETF	239.72	241.28	239.72	240.65	190917.0
2020-03-25 07:45:00	SPY	ETF	240.91	241.05	239.74	240.37	123875.0
2020-03-25 07:50:00	SPY	ETF	240.3	240.3	239.33	239.55	119887.0
2020-03-25 07:55:00	SPY	ETF	239.57	241.2	239.25	241.04	125644.0
2020-03-25 08:00:00	SPY	ETF	241.25	249.77	239.05	242.1	546364.0
2020-03-25 08:05:00	SPY	ETF	242.06	242.75	241.55	241.96	959449.0

> showing 50 of 88,597 rows — these rows as CSV

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