PREVIEW / etf_5min / 2021-08-27

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-08-27.parquet
  size:    1.7 MB
  rows:    78,493

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-08-27 04:00:00	SPY	ETF	447.6	447.82	447.6	447.81	7820.0
2021-08-27 04:05:00	SPY	ETF	447.69	447.7	447.53	447.54	2867.0
2021-08-27 04:10:00	SPY	ETF	447.53	447.63	447.53	447.63	1100.0
2021-08-27 04:20:00	SPY	ETF	447.62	447.64	447.57	447.57	1254.0
2021-08-27 04:25:00	SPY	ETF	447.54	447.56	447.5	447.56	6550.0
2021-08-27 04:30:00	SPY	ETF	447.53	447.56	447.53	447.56	1100.0
2021-08-27 04:40:00	SPY	ETF	447.55	447.55	447.55	447.55	200.0
2021-08-27 04:45:00	SPY	ETF	447.68	447.68	447.66	447.66	493.0
2021-08-27 05:00:00	SPY	ETF	447.54	447.54	447.54	447.54	100.0
2021-08-27 05:05:00	SPY	ETF	447.61	447.62	447.59	447.59	4800.0
2021-08-27 05:10:00	SPY	ETF	447.51	447.53	447.5	447.51	1200.0
2021-08-27 05:15:00	SPY	ETF	447.59	447.59	447.59	447.59	1000.0
2021-08-27 05:20:00	SPY	ETF	447.71	447.81	447.7	447.78	2200.0
2021-08-27 05:30:00	SPY	ETF	447.75	447.75	447.72	447.72	2100.0
2021-08-27 05:35:00	SPY	ETF	447.75	447.79	447.74	447.79	2600.0
2021-08-27 05:40:00	SPY	ETF	447.83	447.83	447.8	447.82	540.0
2021-08-27 05:45:00	SPY	ETF	447.8	447.8	447.76	447.78	1592.0
2021-08-27 05:50:00	SPY	ETF	447.75	447.79	447.73	447.73	1900.0
2021-08-27 05:55:00	SPY	ETF	447.77	447.82	447.76	447.82	600.0
2021-08-27 06:00:00	SPY	ETF	447.74	447.78	447.7	447.78	3116.0
2021-08-27 06:05:00	SPY	ETF	447.76	447.83	447.76	447.78	2897.0
2021-08-27 06:10:00	SPY	ETF	447.75	447.76	447.7	447.75	2400.0
2021-08-27 06:15:00	SPY	ETF	447.65	447.68	447.65	447.68	1000.0
2021-08-27 06:20:00	SPY	ETF	447.68	447.7	447.67	447.7	2696.0
2021-08-27 06:25:00	SPY	ETF	447.67	447.67	447.64	447.66	2918.0
2021-08-27 06:30:00	SPY	ETF	447.61	447.63	447.54	447.54	3100.0
2021-08-27 06:35:00	SPY	ETF	447.6	447.61	447.6	447.61	800.0
2021-08-27 06:40:00	SPY	ETF	447.63	447.68	447.63	447.68	34500.0
2021-08-27 06:45:00	SPY	ETF	447.63	447.65	447.63	447.65	1295.0
2021-08-27 06:50:00	SPY	ETF	447.73	447.76	447.68	447.68	2500.0
2021-08-27 07:00:00	SPY	ETF	447.62	447.65	447.58	447.65	4616.0
2021-08-27 07:05:00	SPY	ETF	447.59	447.6	447.58	447.58	7607.0
2021-08-27 07:10:00	SPY	ETF	447.67	447.68	447.67	447.67	950.0
2021-08-27 07:15:00	SPY	ETF	447.67	447.67	447.54	447.54	6330.0
2021-08-27 07:20:00	SPY	ETF	447.53	447.53	447.4	447.4	3899.0
2021-08-27 07:25:00	SPY	ETF	447.46	447.56	447.46	447.55	46950.0
2021-08-27 07:30:00	SPY	ETF	447.55	447.57	447.55	447.55	14876.0
2021-08-27 07:35:00	SPY	ETF	447.55	447.55	447.48	447.48	2565.0
2021-08-27 07:40:00	SPY	ETF	447.47	447.48	447.44	447.44	3637.0
2021-08-27 07:45:00	SPY	ETF	447.46	447.46	447.05	447.21	114934.0
2021-08-27 07:50:00	SPY	ETF	447.21	447.3	447.16	447.3	16074.0
2021-08-27 07:55:00	SPY	ETF	447.3	447.35	447.3	447.31	1648.0
2021-08-27 08:00:00	SPY	ETF	447.5899	447.65	446.594	447.37	16460.0
2021-08-27 08:05:00	SPY	ETF	447.35	447.42	447.34	447.41	27724.0
2021-08-27 08:10:00	SPY	ETF	447.38	447.41	447.36	447.36	10582.0
2021-08-27 08:15:00	SPY	ETF	447.33	447.46	447.33	447.43	15529.0
2021-08-27 08:20:00	SPY	ETF	447.44	447.51	447.42	447.44	19791.0
2021-08-27 08:25:00	SPY	ETF	447.44	447.47	447.35	447.35	42848.0
2021-08-27 08:30:00	SPY	ETF	447.36	447.4896	447.36	447.4896	34378.0
2021-08-27 08:35:00	SPY	ETF	447.47	447.56	447.45	447.55	29555.0

> showing 50 of 78,493 rows — these rows as CSV

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