PREVIEW / etf_5min / 2021-07-29

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-07-29.parquet
  size:    1.7 MB
  rows:    79,332

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-07-29 04:00:00	SPY	ETF	438.93	439.3	438.93	439.3	500.0
2021-07-29 04:05:00	SPY	ETF	439.14	439.26	439.14	439.24	1599.0
2021-07-29 04:15:00	SPY	ETF	439.46	439.46	439.34	439.34	300.0
2021-07-29 04:20:00	SPY	ETF	439.22	439.22	439.22	439.22	100.0
2021-07-29 04:30:00	SPY	ETF	439.33	439.33	439.33	439.33	100.0
2021-07-29 04:35:00	SPY	ETF	439.46	439.46	439.46	439.46	103.0
2021-07-29 04:40:00	SPY	ETF	439.5	439.5	439.5	439.5	400.0
2021-07-29 04:45:00	SPY	ETF	439.52	439.52	439.52	439.52	100.0
2021-07-29 04:50:00	SPY	ETF	439.46	439.46	439.46	439.46	340.0
2021-07-29 04:55:00	SPY	ETF	439.41	439.41	439.41	439.41	200.0
2021-07-29 05:10:00	SPY	ETF	439.43	439.45	439.43	439.45	2600.0
2021-07-29 05:15:00	SPY	ETF	439.44	439.45	439.44	439.45	2523.0
2021-07-29 05:30:00	SPY	ETF	439.33	439.48	439.33	439.48	300.0
2021-07-29 05:35:00	SPY	ETF	439.5	439.71	439.5	439.71	495.0
2021-07-29 05:40:00	SPY	ETF	439.69	439.69	439.69	439.69	100.0
2021-07-29 05:45:00	SPY	ETF	439.76	439.79	439.76	439.79	755.0
2021-07-29 06:00:00	SPY	ETF	439.67	439.67	439.67	439.67	300.0
2021-07-29 06:05:00	SPY	ETF	439.76	439.76	439.73	439.76	1050.0
2021-07-29 06:10:00	SPY	ETF	439.68	439.68	439.68	439.68	106.0
2021-07-29 06:15:00	SPY	ETF	439.81	439.84	439.81	439.82	3389.0
2021-07-29 06:20:00	SPY	ETF	439.72	439.72	439.69	439.69	200.0
2021-07-29 06:30:00	SPY	ETF	439.7	439.71	439.69	439.71	725.0
2021-07-29 06:35:00	SPY	ETF	439.7	439.7	439.7	439.7	250.0
2021-07-29 06:40:00	SPY	ETF	439.53	439.58	439.53	439.55	600.0
2021-07-29 06:45:00	SPY	ETF	439.55	439.55	439.18	439.25	2400.0
2021-07-29 06:50:00	SPY	ETF	439.29	439.29	439.23	439.25	1700.0
2021-07-29 06:55:00	SPY	ETF	439.27	439.5	439.26	439.5	2070.0
2021-07-29 07:00:00	SPY	ETF	439.61	439.64	439.52	439.64	4498.0
2021-07-29 07:05:00	SPY	ETF	439.65	439.67	439.5	439.58	1971.0
2021-07-29 07:10:00	SPY	ETF	439.59	439.75	439.59	439.73	14971.0
2021-07-29 07:15:00	SPY	ETF	439.72	439.75	439.63	439.63	70622.0
2021-07-29 07:20:00	SPY	ETF	439.63	439.63	439.28	439.28	11408.0
2021-07-29 07:25:00	SPY	ETF	439.34	439.46	439.33	439.4	7205.0
2021-07-29 07:30:00	SPY	ETF	439.39	439.4	439.31	439.31	5324.0
2021-07-29 07:35:00	SPY	ETF	439.33	439.35	439.24	439.3	15704.0
2021-07-29 07:40:00	SPY	ETF	439.31	439.5	439.3	439.5	23874.0
2021-07-29 07:45:00	SPY	ETF	439.5	439.55	439.5	439.55	13444.0
2021-07-29 07:50:00	SPY	ETF	439.55	439.59	439.55	439.57	2957.0
2021-07-29 07:55:00	SPY	ETF	439.55	439.59	439.44	439.59	2475.0
2021-07-29 08:00:00	SPY	ETF	439.53	439.75	439.089	439.63	26734.0
2021-07-29 08:05:00	SPY	ETF	439.68	439.83	439.6401	439.78	57208.0
2021-07-29 08:10:00	SPY	ETF	439.79	439.81	439.75	439.81	9125.0
2021-07-29 08:15:00	SPY	ETF	439.81	439.81	439.71	439.72	4634.0
2021-07-29 08:20:00	SPY	ETF	439.73	440.0	439.69	439.76	42717.0
2021-07-29 08:25:00	SPY	ETF	439.74	439.77	439.64	439.71	5614.0
2021-07-29 08:30:00	SPY	ETF	439.71	439.78	439.48	439.64	56212.0
2021-07-29 08:35:00	SPY	ETF	439.66	439.67	439.56	439.58	11112.0
2021-07-29 08:40:00	SPY	ETF	439.63	439.67	439.55	439.66	13194.0
2021-07-29 08:45:00	SPY	ETF	439.66	439.66	439.57	439.64	20388.0
2021-07-29 08:50:00	SPY	ETF	439.61	439.64	439.6	439.63	4555.0

> showing 50 of 79,332 rows — these rows as CSV

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