PREVIEW / etf_5min / 2020-03-04

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-03-04.parquet
  size:    1.8 MB
  rows:    76,846

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-04 04:00:00	SPY	ETF	304.99	305.68	304.99	305.53	56160.0
2020-03-04 04:05:00	SPY	ETF	305.59	305.71	304.86	305.01	30220.0
2020-03-04 04:10:00	SPY	ETF	305.0	305.16	304.75	304.9	8186.0
2020-03-04 04:15:00	SPY	ETF	304.98	305.28	304.9	305.25	7897.0
2020-03-04 04:20:00	SPY	ETF	305.15	305.34	305.02	305.12	8331.0
2020-03-04 04:25:00	SPY	ETF	305.22	305.45	305.16	305.32	11427.0
2020-03-04 04:30:00	SPY	ETF	305.24	305.34	305.15	305.19	10660.0
2020-03-04 04:35:00	SPY	ETF	305.23	305.97	305.19	305.66	26812.0
2020-03-04 04:40:00	SPY	ETF	305.61	306.14	305.58	305.73	22018.0
2020-03-04 04:45:00	SPY	ETF	305.75	306.3	305.66	305.98	17975.0
2020-03-04 04:50:00	SPY	ETF	306.15	306.16	305.66	305.68	5484.0
2020-03-04 04:55:00	SPY	ETF	305.71	305.94	305.69	305.82	15367.0
2020-03-04 05:00:00	SPY	ETF	305.65	305.82	305.65	305.82	459.0
2020-03-04 05:05:00	SPY	ETF	305.8	305.83	305.59	305.82	4723.0
2020-03-04 05:10:00	SPY	ETF	306.0	306.22	305.9	306.04	7806.0
2020-03-04 05:15:00	SPY	ETF	306.16	306.16	306.03	306.03	1116.0
2020-03-04 05:20:00	SPY	ETF	305.99	306.25	305.94	306.21	3791.0
2020-03-04 05:25:00	SPY	ETF	306.29	306.43	306.14	306.23	12568.0
2020-03-04 05:30:00	SPY	ETF	306.24	306.25	306.01	306.2	5936.0
2020-03-04 05:35:00	SPY	ETF	306.19	306.19	305.9	306.03	8347.0
2020-03-04 05:40:00	SPY	ETF	306.01	306.18	305.99	306.09	6885.0
2020-03-04 05:45:00	SPY	ETF	306.13	306.16	305.86	305.89	3476.0
2020-03-04 05:50:00	SPY	ETF	305.91	306.06	305.91	305.94	4495.0
2020-03-04 05:55:00	SPY	ETF	305.78	305.86	305.57	305.69	3904.0
2020-03-04 06:00:00	SPY	ETF	305.86	305.89	305.57	305.63	12414.0
2020-03-04 06:05:00	SPY	ETF	305.74	305.77	305.51	305.51	3396.0
2020-03-04 06:10:00	SPY	ETF	305.54	305.57	305.53	305.56	7553.0
2020-03-04 06:15:00	SPY	ETF	305.45	305.46	305.18	305.3	5017.0
2020-03-04 06:20:00	SPY	ETF	305.41	305.7	305.41	305.67	3347.0
2020-03-04 06:25:00	SPY	ETF	305.61	305.74	305.42	305.7	7271.0
2020-03-04 06:30:00	SPY	ETF	305.66	306.09	305.66	305.83	22512.0
2020-03-04 06:35:00	SPY	ETF	305.91	306.12	305.82	306.07	16859.0
2020-03-04 06:40:00	SPY	ETF	305.93	306.16	305.9	306.03	9152.0
2020-03-04 06:45:00	SPY	ETF	306.07	306.15	305.78	305.81	46690.0
2020-03-04 06:50:00	SPY	ETF	305.88	306.3	305.88	306.15	57233.0
2020-03-04 06:55:00	SPY	ETF	306.15	306.21	306.09	306.21	23211.0
2020-03-04 07:00:00	SPY	ETF	306.19	306.28	305.67	306.0	111428.0
2020-03-04 07:05:00	SPY	ETF	306.05	307.15	306.01	307.09	180029.0
2020-03-04 07:10:00	SPY	ETF	307.14	307.38	306.85	306.95	98799.0
2020-03-04 07:15:00	SPY	ETF	306.96	307.16	306.76	307.02	79351.0
2020-03-04 07:20:00	SPY	ETF	307.05	307.28	307.05	307.11	68369.0
2020-03-04 07:25:00	SPY	ETF	307.02	307.15	306.8	307.14	97968.0
2020-03-04 07:30:00	SPY	ETF	307.1	307.53	307.08	307.37	134343.0
2020-03-04 07:35:00	SPY	ETF	307.43	307.6	307.3	307.39	126169.0
2020-03-04 07:40:00	SPY	ETF	307.44	307.46	306.84	307.05	67140.0
2020-03-04 07:45:00	SPY	ETF	307.07	307.36	306.9	307.09	95680.0
2020-03-04 07:50:00	SPY	ETF	306.97	307.08	306.78	306.83	61297.0
2020-03-04 07:55:00	SPY	ETF	306.83	306.91	306.18	306.22	81210.0
2020-03-04 08:00:00	SPY	ETF	306.9375	307.59	300.24	305.96	493445.0
2020-03-04 08:05:00	SPY	ETF	305.94	305.94	305.02	305.11	465151.0

> showing 50 of 76,846 rows — these rows as CSV

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