PREVIEW / etf_5min / 2020-07-16

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-07-16.parquet
  size:    1.5 MB
  rows:    72,727

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-07-16 04:00:00	SPY	ETF	320.12	320.28	319.9	320.24	12477.0
2020-07-16 04:05:00	SPY	ETF	320.17	320.35	319.93	319.93	4135.0
2020-07-16 04:10:00	SPY	ETF	319.92	320.07	319.92	320.04	4203.0
2020-07-16 04:15:00	SPY	ETF	319.95	319.95	319.85	319.85	1895.0
2020-07-16 04:20:00	SPY	ETF	319.8	319.85	319.75	319.85	5599.0
2020-07-16 04:25:00	SPY	ETF	319.85	319.85	319.59	319.6	1448.0
2020-07-16 04:30:00	SPY	ETF	319.6	319.6	319.5	319.56	5701.0
2020-07-16 04:35:00	SPY	ETF	319.51	319.51	319.2	319.32	9721.0
2020-07-16 04:40:00	SPY	ETF	319.28	319.4	319.24	319.4	8663.0
2020-07-16 04:45:00	SPY	ETF	319.44	319.55	319.4	319.52	12671.0
2020-07-16 04:50:00	SPY	ETF	319.5	319.5	319.45	319.45	2333.0
2020-07-16 04:55:00	SPY	ETF	319.52	319.6	319.5	319.59	2100.0
2020-07-16 05:00:00	SPY	ETF	319.5	319.5	318.92	319.2	8325.0
2020-07-16 05:05:00	SPY	ETF	319.28	319.28	319.0	319.26	8503.0
2020-07-16 05:10:00	SPY	ETF	319.26	319.26	319.11	319.14	5750.0
2020-07-16 05:15:00	SPY	ETF	319.06	319.21	319.04	319.19	637.0
2020-07-16 05:20:00	SPY	ETF	319.28	319.28	319.24	319.28	2850.0
2020-07-16 05:25:00	SPY	ETF	319.26	319.48	319.26	319.47	2051.0
2020-07-16 05:30:00	SPY	ETF	319.46	319.64	319.46	319.62	4095.0
2020-07-16 05:35:00	SPY	ETF	319.56	319.71	319.56	319.66	4660.0
2020-07-16 05:40:00	SPY	ETF	319.7	319.78	319.65	319.66	7650.0
2020-07-16 05:45:00	SPY	ETF	319.62	319.62	319.36	319.48	2734.0
2020-07-16 05:50:00	SPY	ETF	319.5	319.5	319.32	319.44	4498.0
2020-07-16 05:55:00	SPY	ETF	319.45	319.54	319.44	319.44	1802.0
2020-07-16 06:00:00	SPY	ETF	319.5	319.5	319.49	319.49	542.0
2020-07-16 06:05:00	SPY	ETF	319.57	319.61	319.51	319.51	6368.0
2020-07-16 06:10:00	SPY	ETF	319.57	319.75	319.57	319.71	5148.0
2020-07-16 06:15:00	SPY	ETF	319.78	319.82	319.78	319.82	3073.0
2020-07-16 06:20:00	SPY	ETF	319.8	319.8	319.72	319.72	754.0
2020-07-16 06:25:00	SPY	ETF	319.78	319.82	319.49	319.49	2585.0
2020-07-16 06:30:00	SPY	ETF	319.42	319.44	319.42	319.44	1578.0
2020-07-16 06:35:00	SPY	ETF	319.4	319.63	319.38	319.63	3634.0
2020-07-16 06:40:00	SPY	ETF	319.63	319.75	319.63	319.75	4412.0
2020-07-16 06:45:00	SPY	ETF	319.74	319.95	319.74	319.93	28181.0
2020-07-16 06:50:00	SPY	ETF	319.87	319.98	319.78	319.81	2799.0
2020-07-16 06:55:00	SPY	ETF	319.83	319.9	319.8	319.89	3895.0
2020-07-16 07:00:00	SPY	ETF	319.96	320.22	319.94	320.18	23243.0
2020-07-16 07:05:00	SPY	ETF	320.11	320.13	319.95	319.95	6036.0
2020-07-16 07:10:00	SPY	ETF	319.93	320.0	319.78	319.83	11820.0
2020-07-16 07:15:00	SPY	ETF	319.77	320.05	319.73	320.05	24264.0
2020-07-16 07:20:00	SPY	ETF	320.08	320.18	320.05	320.07	36701.0
2020-07-16 07:25:00	SPY	ETF	320.07	320.07	320.0	320.07	37993.0
2020-07-16 07:30:00	SPY	ETF	320.13	320.2	320.07	320.16	21185.0
2020-07-16 07:35:00	SPY	ETF	320.14	320.16	319.88	319.97	42041.0
2020-07-16 07:40:00	SPY	ETF	320.0	320.37	320.0	320.2	18705.0
2020-07-16 07:45:00	SPY	ETF	320.17	320.35	320.16	320.28	13149.0
2020-07-16 07:50:00	SPY	ETF	320.3	320.31	320.05	320.1	18163.0
2020-07-16 07:55:00	SPY	ETF	320.09	320.09	319.9	319.97	64217.0
2020-07-16 08:00:00	SPY	ETF	319.9999	321.15	319.5596	319.87	91864.0
2020-07-16 08:05:00	SPY	ETF	319.89	320.0	319.84	319.9	44713.0

> showing 50 of 72,727 rows — these rows as CSV

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