PREVIEW / etf_5min / 2020-04-13

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-04-13.parquet
  size:    1.8 MB
  rows:    79,931

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-04-13 04:00:00	SPY	ETF	274.63	274.71	274.38	274.38	30402.0
2020-04-13 04:05:00	SPY	ETF	274.35	274.47	274.33	274.46	6359.0
2020-04-13 04:10:00	SPY	ETF	274.47	274.54	274.33	274.53	8059.0
2020-04-13 04:15:00	SPY	ETF	274.57	274.64	274.4	274.5	2099.0
2020-04-13 04:20:00	SPY	ETF	274.48	274.48	274.4	274.41	2093.0
2020-04-13 04:25:00	SPY	ETF	274.4	274.46	274.2	274.2	4737.0
2020-04-13 04:30:00	SPY	ETF	274.21	274.38	274.07	274.24	5844.0
2020-04-13 04:35:00	SPY	ETF	274.46	274.47	274.29	274.29	3596.0
2020-04-13 04:40:00	SPY	ETF	274.25	274.31	274.25	274.27	1990.0
2020-04-13 04:45:00	SPY	ETF	274.34	274.4	274.11	274.23	6980.0
2020-04-13 04:50:00	SPY	ETF	274.18	274.39	274.15	274.39	2658.0
2020-04-13 04:55:00	SPY	ETF	274.43	274.67	274.43	274.6	2616.0
2020-04-13 05:00:00	SPY	ETF	274.6	274.94	274.59	274.9	4491.0
2020-04-13 05:05:00	SPY	ETF	274.94	274.94	274.8	274.8	4137.0
2020-04-13 05:10:00	SPY	ETF	275.0	275.0	275.0	275.0	420.0
2020-04-13 05:15:00	SPY	ETF	274.98	275.03	274.89	275.03	2386.0
2020-04-13 05:20:00	SPY	ETF	274.86	274.92	274.85	274.91	1050.0
2020-04-13 05:25:00	SPY	ETF	275.0	275.19	274.89	274.89	30228.0
2020-04-13 05:30:00	SPY	ETF	274.8	274.95	274.72	274.92	2320.0
2020-04-13 05:35:00	SPY	ETF	274.91	274.91	274.79	274.79	1811.0
2020-04-13 05:40:00	SPY	ETF	274.8	274.82	274.58	274.61	8610.0
2020-04-13 05:45:00	SPY	ETF	274.63	274.71	274.63	274.66	3960.0
2020-04-13 05:50:00	SPY	ETF	274.59	274.72	274.59	274.72	900.0
2020-04-13 05:55:00	SPY	ETF	274.68	274.71	274.59	274.71	2680.0
2020-04-13 06:00:00	SPY	ETF	274.81	274.89	274.81	274.86	5251.0
2020-04-13 06:05:00	SPY	ETF	274.86	274.86	274.75	274.81	10422.0
2020-04-13 06:10:00	SPY	ETF	274.72	274.72	274.4	274.4	9525.0
2020-04-13 06:15:00	SPY	ETF	274.43	274.87	274.43	274.69	6575.0
2020-04-13 06:20:00	SPY	ETF	274.59	274.79	274.59	274.79	4175.0
2020-04-13 06:25:00	SPY	ETF	274.82	274.95	274.81	274.81	2081.0
2020-04-13 06:30:00	SPY	ETF	274.89	274.99	274.83	274.91	4813.0
2020-04-13 06:35:00	SPY	ETF	275.0	275.48	275.0	275.39	45887.0
2020-04-13 06:40:00	SPY	ETF	275.38	275.56	275.31	275.54	4505.0
2020-04-13 06:45:00	SPY	ETF	275.6	275.94	275.51	275.55	16545.0
2020-04-13 06:50:00	SPY	ETF	275.58	275.58	275.35	275.44	11526.0
2020-04-13 06:55:00	SPY	ETF	275.4	275.51	275.31	275.35	10227.0
2020-04-13 07:00:00	SPY	ETF	275.35	275.75	275.35	275.65	76469.0
2020-04-13 07:05:00	SPY	ETF	275.66	275.9	275.6	275.85	30614.0
2020-04-13 07:10:00	SPY	ETF	275.78	275.86	275.7	275.8	32758.0
2020-04-13 07:15:00	SPY	ETF	275.84	276.11	275.7	276.09	94003.0
2020-04-13 07:20:00	SPY	ETF	276.12	276.36	276.03	276.26	35429.0
2020-04-13 07:25:00	SPY	ETF	276.25	276.43	276.2	276.4	50120.0
2020-04-13 07:30:00	SPY	ETF	276.43	276.79	276.42	276.65	88299.0
2020-04-13 07:35:00	SPY	ETF	276.65	276.85	276.6	276.7	65429.0
2020-04-13 07:40:00	SPY	ETF	276.65	276.66	276.28	276.28	65542.0
2020-04-13 07:45:00	SPY	ETF	276.3	276.51	276.3	276.43	42220.0
2020-04-13 07:50:00	SPY	ETF	276.48	277.07	276.48	277.0	120354.0
2020-04-13 07:55:00	SPY	ETF	277.0	277.1	276.78	276.98	36828.0
2020-04-13 08:00:00	SPY	ETF	276.91	277.08	274.85	276.7999	222993.0
2020-04-13 08:05:00	SPY	ETF	276.72	277.58	276.7	277.5	125958.0

> showing 50 of 79,931 rows — these rows as CSV

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