PREVIEW / etf_5min / 2020-10-21

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-10-21.parquet
  size:    1.5 MB
  rows:    71,031

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
2020-10-21 04:00:00	SPY	ETF	343.93	343.97	343.87	343.87	699.0
2020-10-21 04:05:00	SPY	ETF	343.8	343.87	343.78	343.84	1531.0
2020-10-21 04:10:00	SPY	ETF	343.72	343.89	343.72	343.89	1750.0
2020-10-21 04:15:00	SPY	ETF	343.8	343.8	343.5	343.5	2982.0
2020-10-21 04:20:00	SPY	ETF	343.44	343.44	342.5	342.59	23665.0
2020-10-21 04:25:00	SPY	ETF	342.63	342.86	342.59	342.86	10121.0
2020-10-21 04:30:00	SPY	ETF	342.83	342.94	342.64	342.94	7704.0
2020-10-21 04:35:00	SPY	ETF	343.04	343.19	342.99	343.19	4190.0
2020-10-21 04:40:00	SPY	ETF	343.22	343.24	343.01	343.01	2400.0
2020-10-21 04:45:00	SPY	ETF	342.81	343.06	342.81	343.06	1150.0
2020-10-21 04:50:00	SPY	ETF	342.85	342.85	342.75	342.75	8101.0
2020-10-21 04:55:00	SPY	ETF	342.58	342.58	342.22	342.24	7996.0
2020-10-21 05:00:00	SPY	ETF	342.23	342.39	342.05	342.29	11138.0
2020-10-21 05:05:00	SPY	ETF	342.34	342.51	342.34	342.51	2078.0
2020-10-21 05:10:00	SPY	ETF	342.5	342.57	342.45	342.45	6668.0
2020-10-21 05:15:00	SPY	ETF	342.42	342.9	342.42	342.9	4221.0
2020-10-21 05:20:00	SPY	ETF	342.92	342.97	342.9	342.94	4300.0
2020-10-21 05:25:00	SPY	ETF	343.07	343.14	343.05	343.14	4245.0
2020-10-21 05:30:00	SPY	ETF	343.17	343.17	343.0	343.0	6084.0
2020-10-21 05:35:00	SPY	ETF	343.01	343.43	342.97	343.4	5749.0
2020-10-21 05:40:00	SPY	ETF	343.62	343.71	343.6	343.7	5463.0
2020-10-21 05:45:00	SPY	ETF	343.64	343.67	343.58	343.6	3829.0
2020-10-21 05:50:00	SPY	ETF	343.73	343.75	343.57	343.59	6577.0
2020-10-21 05:55:00	SPY	ETF	343.59	343.59	343.45	343.54	6471.0
2020-10-21 06:00:00	SPY	ETF	343.64	343.69	343.49	343.49	6001.0
2020-10-21 06:05:00	SPY	ETF	343.53	343.53	343.33	343.33	12075.0
2020-10-21 06:10:00	SPY	ETF	343.31	343.45	343.28	343.34	11850.0
2020-10-21 06:15:00	SPY	ETF	343.3	343.3	343.11	343.11	4245.0
2020-10-21 06:20:00	SPY	ETF	343.09	343.51	343.09	343.45	7854.0
2020-10-21 06:25:00	SPY	ETF	343.43	343.43	343.43	343.43	200.0
2020-10-21 06:30:00	SPY	ETF	343.38	343.38	343.38	343.38	100.0
2020-10-21 06:35:00	SPY	ETF	343.67	343.7	343.62	343.7	522.0
2020-10-21 06:40:00	SPY	ETF	343.66	343.66	343.41	343.41	1429.0
2020-10-21 06:45:00	SPY	ETF	343.6	343.6	343.6	343.6	633.0
2020-10-21 06:50:00	SPY	ETF	343.68	343.68	343.53	343.53	593.0
2020-10-21 06:55:00	SPY	ETF	343.53	343.57	343.38	343.38	1370.0
2020-10-21 07:00:00	SPY	ETF	343.35	343.35	342.88	343.03	9240.0
2020-10-21 07:05:00	SPY	ETF	343.01	343.02	342.71	342.76	20495.0
2020-10-21 07:10:00	SPY	ETF	342.83	342.96	342.68	342.68	12796.0
2020-10-21 07:15:00	SPY	ETF	342.79	342.86	342.65	342.86	2076.0
2020-10-21 07:20:00	SPY	ETF	342.88	342.92	342.86	342.92	2271.0
2020-10-21 07:25:00	SPY	ETF	342.8	342.81	342.31	342.6	13264.0
2020-10-21 07:30:00	SPY	ETF	342.65	342.71	342.48	342.69	15309.0
2020-10-21 07:35:00	SPY	ETF	342.67	342.67	342.55	342.67	7340.0
2020-10-21 07:40:00	SPY	ETF	342.63	342.87	342.63	342.77	15228.0
2020-10-21 07:45:00	SPY	ETF	342.68	342.77	342.68	342.77	3679.0
2020-10-21 07:50:00	SPY	ETF	342.86	342.98	342.85	342.98	8878.0
2020-10-21 07:55:00	SPY	ETF	342.94	343.07	342.83	342.85	19828.0
2020-10-21 08:00:00	SPY	ETF	342.92	345.33	342.52	342.834	32677.0
2020-10-21 08:05:00	SPY	ETF	342.9	342.96	342.75	342.96	7537.0

> showing 50 of 71,031 rows — these rows as CSV

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