PREVIEW / etf_5min / 2021-06-18

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-06-18.parquet
  size:    1.8 MB
  rows:    85,430

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
2021-06-18 04:00:00	SPY	ETF	420.6	422.1	420.47	420.59	4471.0
2021-06-18 04:05:00	SPY	ETF	420.5	420.5	420.43	420.5	2899.0
2021-06-18 04:10:00	SPY	ETF	420.56	420.56	420.56	420.56	2000.0
2021-06-18 04:15:00	SPY	ETF	420.5	420.62	420.47	420.61	16169.0
2021-06-18 04:20:00	SPY	ETF	420.57	420.57	420.46	420.51	7850.0
2021-06-18 04:25:00	SPY	ETF	420.64	420.64	420.58	420.58	745.0
2021-06-18 04:30:00	SPY	ETF	420.58	420.58	420.58	420.58	500.0
2021-06-18 04:35:00	SPY	ETF	420.7	420.7	420.69	420.69	1270.0
2021-06-18 04:45:00	SPY	ETF	420.66	420.66	420.65	420.65	350.0
2021-06-18 04:50:00	SPY	ETF	420.53	420.54	420.53	420.53	1243.0
2021-06-18 04:55:00	SPY	ETF	420.55	420.55	420.55	420.55	200.0
2021-06-18 05:00:00	SPY	ETF	420.55	420.55	420.51	420.51	839.0
2021-06-18 05:05:00	SPY	ETF	420.5	420.61	420.5	420.61	1947.0
2021-06-18 05:10:00	SPY	ETF	420.63	420.7	420.6	420.69	5750.0
2021-06-18 05:15:00	SPY	ETF	420.72	420.75	420.72	420.74	1797.0
2021-06-18 05:20:00	SPY	ETF	420.75	420.75	420.72	420.74	1900.0
2021-06-18 05:25:00	SPY	ETF	420.78	420.78	420.75	420.78	3932.0
2021-06-18 05:30:00	SPY	ETF	420.7	420.7	420.59	420.59	1142.0
2021-06-18 05:40:00	SPY	ETF	420.83	420.83	420.71	420.71	1600.0
2021-06-18 05:50:00	SPY	ETF	420.7	420.7	420.51	420.51	2349.0
2021-06-18 05:55:00	SPY	ETF	420.62	420.62	420.62	420.62	300.0
2021-06-18 06:00:00	SPY	ETF	420.57	420.57	420.38	420.38	10379.0
2021-06-18 06:05:00	SPY	ETF	420.4	420.41	420.22	420.27	5789.0
2021-06-18 06:10:00	SPY	ETF	420.17	420.17	420.16	420.16	300.0
2021-06-18 06:15:00	SPY	ETF	420.15	420.15	420.05	420.05	6026.0
2021-06-18 06:20:00	SPY	ETF	420.2	420.3	420.08	420.28	2100.0
2021-06-18 06:25:00	SPY	ETF	420.27	420.27	420.21	420.21	200.0
2021-06-18 06:30:00	SPY	ETF	420.23	420.23	420.16	420.16	3713.0
2021-06-18 06:35:00	SPY	ETF	420.26	420.26	420.26	420.26	100.0
2021-06-18 06:40:00	SPY	ETF	420.37	420.45	420.35	420.35	6707.0
2021-06-18 06:45:00	SPY	ETF	420.43	420.43	420.35	420.38	985.0
2021-06-18 06:50:00	SPY	ETF	420.38	420.43	420.21	420.21	900.0
2021-06-18 06:55:00	SPY	ETF	420.19	420.3	420.16	420.3	2800.0
2021-06-18 07:00:00	SPY	ETF	420.19	420.31	419.95	419.95	32942.0
2021-06-18 07:05:00	SPY	ETF	419.99	420.06	419.77	419.81	8747.0
2021-06-18 07:10:00	SPY	ETF	419.73	419.78	419.62	419.68	18076.0
2021-06-18 07:15:00	SPY	ETF	419.73	419.73	419.53	419.56	10200.0
2021-06-18 07:20:00	SPY	ETF	419.51	419.51	419.24	419.24	41382.0
2021-06-18 07:25:00	SPY	ETF	419.22	419.71	419.21	419.7	12569.0
2021-06-18 07:30:00	SPY	ETF	419.56	419.78	419.56	419.76	28713.0
2021-06-18 07:35:00	SPY	ETF	419.7	419.71	419.5	419.5	13609.0
2021-06-18 07:40:00	SPY	ETF	419.56	419.58	419.22	419.23	26373.0
2021-06-18 07:45:00	SPY	ETF	419.3	419.42	419.21	419.29	11880.0
2021-06-18 07:50:00	SPY	ETF	419.25	419.41	419.17	419.38	14856.0
2021-06-18 07:55:00	SPY	ETF	419.38	419.64	419.38	419.62	6973.0
2021-06-18 08:00:00	SPY	ETF	419.29	422.276	418.89	418.9	98389.0
2021-06-18 08:05:00	SPY	ETF	418.95	420.22	418.75	418.75	65755.0
2021-06-18 08:10:00	SPY	ETF	418.75	418.8	418.25	418.45	79422.0
2021-06-18 08:15:00	SPY	ETF	418.54	418.54	417.92	418.22	255157.0
2021-06-18 08:20:00	SPY	ETF	418.22	418.23	416.94	417.6796	538615.0

> showing 50 of 85,430 rows — these rows as CSV

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