PREVIEW / etf_5min / 2020-03-09

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-03-09.parquet
  size:    2.1 MB
  rows:    91,446

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-09 04:00:00	SPY	ETF	280.2	289.4	277.22	279.0	60418.0
2020-03-09 04:05:00	SPY	ETF	279.4	279.98	279.0	279.96	13138.0
2020-03-09 04:10:00	SPY	ETF	279.5	279.89	278.57	278.57	25873.0
2020-03-09 04:15:00	SPY	ETF	278.6	279.35	278.4	278.45	27077.0
2020-03-09 04:20:00	SPY	ETF	278.27	278.61	277.61	277.61	44277.0
2020-03-09 04:25:00	SPY	ETF	277.81	277.98	277.01	277.78	48219.0
2020-03-09 04:30:00	SPY	ETF	277.48	277.48	276.54	276.78	18786.0
2020-03-09 04:35:00	SPY	ETF	276.79	277.96	276.73	277.0	29715.0
2020-03-09 04:40:00	SPY	ETF	276.99	278.2	276.69	278.2	19047.0
2020-03-09 04:45:00	SPY	ETF	278.0	279.7	278.0	279.13	14666.0
2020-03-09 04:50:00	SPY	ETF	278.9	279.16	278.0	278.35	16069.0
2020-03-09 04:55:00	SPY	ETF	278.56	279.12	278.56	278.91	6726.0
2020-03-09 05:00:00	SPY	ETF	278.75	279.25	278.5	278.75	21239.0
2020-03-09 05:05:00	SPY	ETF	278.56	279.0	278.16	279.0	4537.0
2020-03-09 05:10:00	SPY	ETF	279.25	280.95	279.0	280.95	28728.0
2020-03-09 05:15:00	SPY	ETF	280.75	281.35	280.5	281.02	32453.0
2020-03-09 05:20:00	SPY	ETF	281.49	283.13	281.05	282.24	49819.0
2020-03-09 05:25:00	SPY	ETF	282.03	282.28	281.51	281.7	21360.0
2020-03-09 05:30:00	SPY	ETF	281.8	281.8	281.01	281.39	17953.0
2020-03-09 05:35:00	SPY	ETF	281.3	281.64	281.01	281.41	9758.0
2020-03-09 05:40:00	SPY	ETF	281.35	281.5	281.01	281.1	7112.0
2020-03-09 05:45:00	SPY	ETF	281.39	281.5	280.74	281.0	44868.0
2020-03-09 05:50:00	SPY	ETF	281.1	281.49	280.02	280.11	36525.0
2020-03-09 05:55:00	SPY	ETF	280.02	280.37	279.12	279.31	34283.0
2020-03-09 06:00:00	SPY	ETF	279.85	279.85	279.0	279.75	29716.0
2020-03-09 06:05:00	SPY	ETF	279.74	279.8	279.0	279.1	15324.0
2020-03-09 06:10:00	SPY	ETF	279.1	279.43	278.55	278.58	14663.0
2020-03-09 06:15:00	SPY	ETF	278.59	278.99	278.5	278.88	13732.0
2020-03-09 06:20:00	SPY	ETF	278.88	279.4	278.75	279.39	5305.0
2020-03-09 06:25:00	SPY	ETF	279.12	281.51	279.1	280.6	26707.0
2020-03-09 06:30:00	SPY	ETF	280.52	281.04	280.22	281.04	40319.0
2020-03-09 06:35:00	SPY	ETF	281.05	281.49	280.5	280.79	16272.0
2020-03-09 06:40:00	SPY	ETF	280.61	280.65	280.01	280.4	9332.0
2020-03-09 06:45:00	SPY	ETF	280.4	281.0	280.39	280.39	8780.0
2020-03-09 06:50:00	SPY	ETF	280.2	280.2	279.5	279.5	19810.0
2020-03-09 06:55:00	SPY	ETF	279.7	279.75	279.0	279.25	27041.0
2020-03-09 07:00:00	SPY	ETF	279.5	281.0	279.26	280.15	109845.0
2020-03-09 07:05:00	SPY	ETF	280.01	280.2	279.12	279.9	68783.0
2020-03-09 07:10:00	SPY	ETF	279.9	279.96	278.6	278.6	111741.0
2020-03-09 07:15:00	SPY	ETF	278.67	279.59	278.19	279.09	67672.0
2020-03-09 07:20:00	SPY	ETF	279.08	279.11	278.26	278.28	63270.0
2020-03-09 07:25:00	SPY	ETF	278.32	278.41	278.05	278.3	74820.0
2020-03-09 07:30:00	SPY	ETF	278.16	278.3	277.7	278.0	88163.0
2020-03-09 07:35:00	SPY	ETF	278.0	278.01	277.25	277.36	103443.0
2020-03-09 07:40:00	SPY	ETF	277.35	277.7	277.18	277.6	191690.0
2020-03-09 07:45:00	SPY	ETF	277.48	277.65	277.35	277.35	104228.0
2020-03-09 07:50:00	SPY	ETF	277.35	278.0	277.2	278.0	111771.0
2020-03-09 07:55:00	SPY	ETF	277.99	278.8	277.5	278.5	160886.0
2020-03-09 08:00:00	SPY	ETF	277.35	282.82	277.25	278.0	274425.0
2020-03-09 08:05:00	SPY	ETF	278.0	278.8125	276.0	276.32	350582.0

> showing 50 of 91,446 rows — these rows as CSV

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