PREVIEW / etf_1hour / 2020-12-16

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-12-16.parquet
  size:    402 KB
  rows:    13,598

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-12-16 04:00:00	SPY	ETF	370.26	370.42	370.14	370.32	58504.0
2020-12-16 05:00:00	SPY	ETF	370.29	370.75	370.25	370.65	24552.0
2020-12-16 06:00:00	SPY	ETF	370.68	370.73	370.53	370.55	17232.0
2020-12-16 07:00:00	SPY	ETF	370.6	370.61	370.31	370.36	117067.0
2020-12-16 08:00:00	SPY	ETF	370.4	370.83	368.95	370.04	934867.0
2020-12-16 09:00:00	SPY	ETF	370.02	370.05	368.8676	369.54	8156903.0
2020-12-16 10:00:00	SPY	ETF	369.55	370.22	369.31	369.77	7520489.0
2020-12-16 11:00:00	SPY	ETF	369.775	370.3716	369.64	370.22	4316060.0
2020-12-16 12:00:00	SPY	ETF	370.225	370.2801	369.3831	370.018	4611182.0
2020-12-16 13:00:00	SPY	ETF	370.01	370.01	369.58	369.8324	2275810.0
2020-12-16 14:00:00	SPY	ETF	369.84	370.78	369.06	370.7222	7772903.0
2020-12-16 15:00:00	SPY	ETF	370.73	371.16	369.93	370.14	13180314.0
2020-12-16 16:00:00	SPY	ETF	370.14	370.34	369.9	370.13	7792280.0
2020-12-16 17:00:00	SPY	ETF	370.15	370.25	369.92	370.17	99507.0
2020-12-16 18:00:00	SPY	ETF	370.17	370.41	370.13	370.33	106028.0
2020-12-16 19:00:00	SPY	ETF	370.33	370.38	370.0	370.33	53043.0
2020-12-16 04:00:00	QQQ	ETF	308.26	308.4	308.18	308.22	26052.0
2020-12-16 05:00:00	QQQ	ETF	308.17	308.35	308.09	308.21	11647.0
2020-12-16 06:00:00	QQQ	ETF	308.2	308.22	307.81	307.96	28268.0
2020-12-16 07:00:00	QQQ	ETF	307.95	307.95	307.64	307.75	64277.0
2020-12-16 08:00:00	QQQ	ETF	307.7101	308.35	307.29	307.91	320428.0
2020-12-16 09:00:00	QQQ	ETF	307.91	307.91	306.621	307.305	2263995.0
2020-12-16 10:00:00	QQQ	ETF	307.32	308.14	306.67	307.87	3154307.0
2020-12-16 11:00:00	QQQ	ETF	307.88	308.71	307.64	308.62	2158395.0
2020-12-16 12:00:00	QQQ	ETF	308.65	308.78	308.0	308.45	1309888.0
2020-12-16 13:00:00	QQQ	ETF	308.421	308.63	307.98	308.4062	1016070.0
2020-12-16 14:00:00	QQQ	ETF	308.45	309.29	307.58	309.24	3303223.0
2020-12-16 15:00:00	QQQ	ETF	309.23	309.785	308.86	309.01	4823217.0
2020-12-16 16:00:00	QQQ	ETF	309.0	309.41	308.4576	309.06	1137240.0
2020-12-16 17:00:00	QQQ	ETF	309.05	309.17	308.9	309.12	21518.0
2020-12-16 18:00:00	QQQ	ETF	309.2	309.44	308.96	309.31	176935.0
2020-12-16 19:00:00	QQQ	ETF	309.22	309.35	309.08	309.19	38603.0
2020-12-16 04:00:00	IWM	ETF	195.51	195.6	195.37	195.53	10216.0
2020-12-16 05:00:00	IWM	ETF	195.52	195.81	195.52	195.69	10629.0
2020-12-16 06:00:00	IWM	ETF	195.76	195.93	195.6	195.6	20485.0
2020-12-16 07:00:00	IWM	ETF	195.64	195.64	195.45	195.62	24556.0
2020-12-16 08:00:00	IWM	ETF	195.4599	196.04	194.44	195.1	211596.0
2020-12-16 09:00:00	IWM	ETF	195.12	195.26	194.35	194.78	1940552.0
2020-12-16 10:00:00	IWM	ETF	194.77	194.81	193.33	193.84	2375673.0
2020-12-16 11:00:00	IWM	ETF	193.825	194.115	193.45	194.11	1687787.0
2020-12-16 12:00:00	IWM	ETF	194.11	194.21	193.7	193.94	1377806.0
2020-12-16 13:00:00	IWM	ETF	193.93	193.935	193.2777	193.62	1460354.0
2020-12-16 14:00:00	IWM	ETF	193.64	194.4	192.96	194.355	3243536.0
2020-12-16 15:00:00	IWM	ETF	194.355	194.815	193.85	194.0	3704571.0
2020-12-16 16:00:00	IWM	ETF	194.0	194.4392	193.83	194.04	3199042.0
2020-12-16 17:00:00	IWM	ETF	193.9	194.16	193.84	194.14	26221.0
2020-12-16 18:00:00	IWM	ETF	194.12	194.34	194.12	194.34	22138.0
2020-12-16 19:00:00	IWM	ETF	194.24	194.26	194.04	194.22	14178.0
2020-12-16 04:00:00	DIA	ETF	303.16	303.21	303.08	303.16	8857.0
2020-12-16 05:00:00	DIA	ETF	303.38	303.38	303.38	303.38	1911.0

> showing 50 of 13,598 rows — these rows as CSV

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