PREVIEW / etf_5min / 2021-06-29

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-06-29.parquet
  size:    1.7 MB
  rows:    80,028

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-29 04:00:00	SPY	ETF	427.53	427.53	427.43	427.43	1296.0
2021-06-29 04:05:00	SPY	ETF	427.43	427.53	427.41	427.53	307.0
2021-06-29 04:15:00	SPY	ETF	427.33	427.35	427.33	427.35	500.0
2021-06-29 04:25:00	SPY	ETF	427.19	427.19	427.19	427.19	171.0
2021-06-29 04:30:00	SPY	ETF	427.18	427.23	427.17	427.23	2618.0
2021-06-29 04:45:00	SPY	ETF	427.01	427.06	427.0	427.05	2900.0
2021-06-29 04:50:00	SPY	ETF	427.2	427.2	427.16	427.16	2800.0
2021-06-29 04:55:00	SPY	ETF	427.21	427.21	427.21	427.21	100.0
2021-06-29 05:10:00	SPY	ETF	427.33	427.33	427.33	427.33	150.0
2021-06-29 05:20:00	SPY	ETF	427.38	427.46	427.38	427.46	4200.0
2021-06-29 05:25:00	SPY	ETF	427.45	427.45	427.45	427.45	1497.0
2021-06-29 05:40:00	SPY	ETF	427.39	427.39	427.35	427.39	3000.0
2021-06-29 05:45:00	SPY	ETF	427.51	427.51	427.51	427.51	300.0
2021-06-29 05:55:00	SPY	ETF	427.46	427.47	427.45	427.45	2100.0
2021-06-29 06:00:00	SPY	ETF	427.46	427.46	427.46	427.46	100.0
2021-06-29 06:15:00	SPY	ETF	427.44	427.44	427.44	427.44	108.0
2021-06-29 06:20:00	SPY	ETF	427.43	427.5	427.39	427.39	5200.0
2021-06-29 06:30:00	SPY	ETF	427.36	427.36	427.35	427.35	13399.0
2021-06-29 06:35:00	SPY	ETF	427.35	427.35	427.3	427.3	13501.0
2021-06-29 06:40:00	SPY	ETF	427.3	427.35	427.28	427.35	122800.0
2021-06-29 06:45:00	SPY	ETF	427.39	427.41	427.39	427.41	279.0
2021-06-29 06:50:00	SPY	ETF	427.5	427.5	427.5	427.5	395.0
2021-06-29 06:55:00	SPY	ETF	427.62	427.62	427.62	427.62	390.0
2021-06-29 07:00:00	SPY	ETF	427.62	427.62	427.53	427.55	9283.0
2021-06-29 07:05:00	SPY	ETF	427.55	427.55	427.39	427.39	2543.0
2021-06-29 07:10:00	SPY	ETF	427.38	427.38	427.29	427.33	5686.0
2021-06-29 07:15:00	SPY	ETF	427.36	427.36	427.3	427.34	2112.0
2021-06-29 07:20:00	SPY	ETF	427.38	427.39	427.3	427.31	2000.0
2021-06-29 07:25:00	SPY	ETF	427.31	427.31	427.27	427.27	3094.0
2021-06-29 07:30:00	SPY	ETF	427.27	427.27	427.17	427.2	2140.0
2021-06-29 07:35:00	SPY	ETF	427.27	427.27	427.23	427.24	2016.0
2021-06-29 07:40:00	SPY	ETF	427.27	427.27	427.15	427.15	3073.0
2021-06-29 07:45:00	SPY	ETF	427.13	427.14	427.05	427.12	17288.0
2021-06-29 07:50:00	SPY	ETF	427.11	427.21	427.1	427.11	10538.0
2021-06-29 07:55:00	SPY	ETF	427.11	427.22	427.11	427.22	1060.0
2021-06-29 08:00:00	SPY	ETF	427.22	427.61	427.06	427.27	45505.0
2021-06-29 08:05:00	SPY	ETF	427.25	427.41	427.24	427.41	5544.0
2021-06-29 08:10:00	SPY	ETF	427.38	427.39	427.33	427.35	31633.0
2021-06-29 08:15:00	SPY	ETF	427.38	427.59	427.38	427.59	16054.0
2021-06-29 08:20:00	SPY	ETF	427.5701	427.68	427.57	427.6	8366.0
2021-06-29 08:25:00	SPY	ETF	427.59	427.59	427.4	427.45	10592.0
2021-06-29 08:30:00	SPY	ETF	427.46	427.51	427.41	427.48	26990.0
2021-06-29 08:35:00	SPY	ETF	427.51	427.51	427.42	427.5	11907.0
2021-06-29 08:40:00	SPY	ETF	427.49	427.52	427.45	427.51	6030.0
2021-06-29 08:45:00	SPY	ETF	427.51	427.59	427.44	427.54	15895.0
2021-06-29 08:50:00	SPY	ETF	427.58	427.6	427.5	427.56	8131.0
2021-06-29 08:55:00	SPY	ETF	427.54	427.6	427.54	427.57	6929.0
2021-06-29 09:00:00	SPY	ETF	427.59	427.74	427.59	427.68	14989.0
2021-06-29 09:05:00	SPY	ETF	427.66	427.67	427.53	427.53	19305.0
2021-06-29 09:10:00	SPY	ETF	427.53	427.66	427.53	427.64	10978.0

> showing 50 of 80,028 rows — these rows as CSV

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