PREVIEW / etf_1hour / 2020-12-01

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-12-01.parquet
  size:    403 KB
  rows:    13,686

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-01 04:00:00	SPY	ETF	365.25	366.16	365.25	365.7	117211.0
2020-12-01 05:00:00	SPY	ETF	365.73	366.17	365.6	366.15	27606.0
2020-12-01 06:00:00	SPY	ETF	366.17	366.27	366.01	366.04	37605.0
2020-12-01 07:00:00	SPY	ETF	366.01	366.05	365.73	366.01	281257.0
2020-12-01 08:00:00	SPY	ETF	366.0	366.08	364.9	365.84	596717.0
2020-12-01 09:00:00	SPY	ETF	365.85	366.39	364.93	366.17	7183682.0
2020-12-01 10:00:00	SPY	ETF	366.165	367.44	365.84	366.29	11793546.0
2020-12-01 11:00:00	SPY	ETF	366.31	367.05	366.04	366.2699	10836351.0
2020-12-01 12:00:00	SPY	ETF	366.25	366.91	366.15	366.4	6081361.0
2020-12-01 13:00:00	SPY	ETF	366.41	367.23	366.405	367.115	3679348.0
2020-12-01 14:00:00	SPY	ETF	367.12	367.68	366.67	366.775	5985538.0
2020-12-01 15:00:00	SPY	ETF	366.77	366.8116	365.46	365.97	17588994.0
2020-12-01 16:00:00	SPY	ETF	365.99	366.12	361.936	365.83	6532399.0
2020-12-01 17:00:00	SPY	ETF	365.98	366.07	365.82	365.98	430882.0
2020-12-01 18:00:00	SPY	ETF	365.98	366.46	365.15	365.74	346372.0
2020-12-01 19:00:00	SPY	ETF	365.65	365.65	365.14	365.22	87066.0
2020-12-01 04:00:00	QQQ	ETF	301.55	301.88	301.47	301.63	68820.0
2020-12-01 05:00:00	QQQ	ETF	301.6	302.22	301.44	302.2	39548.0
2020-12-01 06:00:00	QQQ	ETF	302.09	302.36	301.99	302.07	53154.0
2020-12-01 07:00:00	QQQ	ETF	302.04	302.34	301.99	302.28	105441.0
2020-12-01 08:00:00	QQQ	ETF	302.05	302.37	299.62	301.92	190187.0
2020-12-01 09:00:00	QQQ	ETF	301.95	302.3	300.83	302.23	3340447.0
2020-12-01 10:00:00	QQQ	ETF	302.23	303.21	301.22	302.3	4111392.0
2020-12-01 11:00:00	QQQ	ETF	302.35	303.68	302.31	303.591	3105629.0
2020-12-01 12:00:00	QQQ	ETF	303.6	304.56	303.51	303.8578	2697981.0
2020-12-01 13:00:00	QQQ	ETF	303.87	305.0	303.81	304.61	1916367.0
2020-12-01 14:00:00	QQQ	ETF	304.6086	305.14	303.89	304.0898	2051431.0
2020-12-01 15:00:00	QQQ	ETF	304.09	304.1	302.91	303.66	4744533.0
2020-12-01 16:00:00	QQQ	ETF	303.67	304.15	303.45	303.82	705213.0
2020-12-01 17:00:00	QQQ	ETF	303.92	303.95	303.7	303.74	36810.0
2020-12-01 18:00:00	QQQ	ETF	303.89	304.12	303.33	303.62	91046.0
2020-12-01 19:00:00	QQQ	ETF	303.69	303.69	303.26	303.33	62134.0
2020-12-01 04:00:00	IWM	ETF	183.47	184.01	183.0	183.85	36195.0
2020-12-01 05:00:00	IWM	ETF	183.82	184.01	183.77	184.0	17033.0
2020-12-01 06:00:00	IWM	ETF	184.0	184.01	183.68	183.77	37074.0
2020-12-01 07:00:00	IWM	ETF	183.73	183.81	183.54	183.77	82670.0
2020-12-01 08:00:00	IWM	ETF	183.6299	183.85	183.06	183.52	53177.0
2020-12-01 09:00:00	IWM	ETF	183.51	183.81	182.93	183.72	3294266.0
2020-12-01 10:00:00	IWM	ETF	183.72	184.22	182.46	182.98	4175523.0
2020-12-01 11:00:00	IWM	ETF	182.98	183.245	181.79	181.9	2877942.0
2020-12-01 12:00:00	IWM	ETF	181.905	182.85	181.8	182.43	2324664.0
2020-12-01 13:00:00	IWM	ETF	182.43	183.25	182.195	183.2	1740706.0
2020-12-01 14:00:00	IWM	ETF	183.2	183.775	183.05	183.165	2459987.0
2020-12-01 15:00:00	IWM	ETF	183.17	183.22	182.41	182.66	4393446.0
2020-12-01 16:00:00	IWM	ETF	182.66	182.88	181.0218	182.58	4103940.0
2020-12-01 17:00:00	IWM	ETF	182.54	182.7	182.54	182.66	14037.0
2020-12-01 18:00:00	IWM	ETF	182.63	182.85	182.06	182.47	58093.0
2020-12-01 19:00:00	IWM	ETF	182.42	182.42	182.0	182.04	27152.0
2020-12-01 04:00:00	DIA	ETF	299.67	300.04	299.66	299.88	2855.0
2020-12-01 05:00:00	DIA	ETF	300.02	300.1	299.94	299.94	800.0

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

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