PREVIEW / etf_5min / 2021-09-02

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-09-02.parquet
  size:    1.7 MB
  rows:    79,047

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-09-02 04:00:00	SPY	ETF	452.23	452.66	450.0	452.58	5503.0
2021-09-02 04:05:00	SPY	ETF	452.64	452.75	452.64	452.74	300.0
2021-09-02 04:10:00	SPY	ETF	452.73	452.73	452.7	452.7	1000.0
2021-09-02 04:15:00	SPY	ETF	452.68	452.74	452.68	452.74	3449.0
2021-09-02 04:20:00	SPY	ETF	452.65	452.65	452.65	452.65	800.0
2021-09-02 04:30:00	SPY	ETF	452.67	452.82	452.67	452.8	900.0
2021-09-02 04:35:00	SPY	ETF	452.77	452.86	452.77	452.8	1100.0
2021-09-02 04:40:00	SPY	ETF	452.8	452.8	452.79	452.79	400.0
2021-09-02 05:00:00	SPY	ETF	452.81	452.81	452.72	452.72	1500.0
2021-09-02 05:05:00	SPY	ETF	452.74	452.75	452.74	452.75	316.0
2021-09-02 05:10:00	SPY	ETF	452.72	452.72	452.69	452.69	200.0
2021-09-02 05:15:00	SPY	ETF	452.56	452.57	452.56	452.57	1443.0
2021-09-02 05:20:00	SPY	ETF	452.57	452.57	452.57	452.57	100.0
2021-09-02 05:25:00	SPY	ETF	452.55	452.63	452.52	452.63	2150.0
2021-09-02 05:30:00	SPY	ETF	452.7	452.78	452.7	452.72	2277.0
2021-09-02 05:35:00	SPY	ETF	452.7	452.73	452.7	452.73	598.0
2021-09-02 05:40:00	SPY	ETF	452.58	452.58	452.55	452.55	300.0
2021-09-02 05:45:00	SPY	ETF	452.7	452.71	452.7	452.71	700.0
2021-09-02 05:50:00	SPY	ETF	452.63	452.63	452.62	452.62	800.0
2021-09-02 05:55:00	SPY	ETF	452.48	452.48	452.48	452.48	300.0
2021-09-02 06:05:00	SPY	ETF	452.62	452.62	452.58	452.59	3197.0
2021-09-02 06:10:00	SPY	ETF	452.6	452.62	452.57	452.57	700.0
2021-09-02 06:15:00	SPY	ETF	452.5	452.5	452.5	452.5	100.0
2021-09-02 06:20:00	SPY	ETF	452.54	452.54	452.54	452.54	239.0
2021-09-02 06:25:00	SPY	ETF	452.5	452.5	452.5	452.5	100.0
2021-09-02 06:30:00	SPY	ETF	452.63	452.67	452.61	452.67	2549.0
2021-09-02 06:35:00	SPY	ETF	452.66	452.66	452.6	452.61	3300.0
2021-09-02 06:40:00	SPY	ETF	452.66	452.66	452.58	452.63	1800.0
2021-09-02 06:45:00	SPY	ETF	452.47	452.47	452.45	452.46	1001.0
2021-09-02 06:50:00	SPY	ETF	452.48	452.53	452.47	452.53	700.0
2021-09-02 06:55:00	SPY	ETF	452.57	452.57	452.55	452.55	500.0
2021-09-02 07:00:00	SPY	ETF	452.57	452.6	452.55	452.58	5013.0
2021-09-02 07:05:00	SPY	ETF	452.6	452.62	452.6	452.62	2033.0
2021-09-02 07:10:00	SPY	ETF	452.63	452.63	452.57	452.57	1940.0
2021-09-02 07:15:00	SPY	ETF	452.55	452.55	452.47	452.48	6730.0
2021-09-02 07:20:00	SPY	ETF	452.5	452.51	452.48	452.48	2500.0
2021-09-02 07:25:00	SPY	ETF	452.48	452.58	452.47	452.55	4880.0
2021-09-02 07:30:00	SPY	ETF	452.58	452.67	452.58	452.64	6059.0
2021-09-02 07:35:00	SPY	ETF	452.64	452.66	452.6	452.63	8381.0
2021-09-02 07:40:00	SPY	ETF	452.62	452.68	452.61	452.61	3760.0
2021-09-02 07:45:00	SPY	ETF	452.69	452.69	452.61	452.65	1299.0
2021-09-02 07:50:00	SPY	ETF	452.67	452.69	452.62	452.62	862.0
2021-09-02 07:55:00	SPY	ETF	452.62	452.64	452.6	452.64	3399.0
2021-09-02 08:00:00	SPY	ETF	452.6101	452.74	452.15	452.73	26192.0
2021-09-02 08:05:00	SPY	ETF	452.72	452.75	452.66	452.66	6205.0
2021-09-02 08:10:00	SPY	ETF	452.67	452.7	452.61	452.64	3124.0
2021-09-02 08:15:00	SPY	ETF	452.64	452.67	452.63	452.64	10388.0
2021-09-02 08:20:00	SPY	ETF	452.65	452.65	452.64	452.65	36247.0
2021-09-02 08:25:00	SPY	ETF	452.65	452.65	452.58	452.59	22163.0
2021-09-02 08:30:00	SPY	ETF	452.6	452.94	452.6	452.75	25940.0

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

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