PREVIEW / etf_1hour / 2020-03-16

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-03-16.parquet
  size:    413 KB
  rows:    14,193

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-03-16 04:00:00	SPY	ETF	253.2	262.75	244.0	246.23	597352.0
2020-03-16 05:00:00	SPY	ETF	246.2	246.29	244.22	245.27	453538.0
2020-03-16 06:00:00	SPY	ETF	245.2	245.52	242.8	243.35	466216.0
2020-03-16 07:00:00	SPY	ETF	243.35	244.47	241.94	243.1	2285934.0
2020-03-16 08:00:00	SPY	ETF	243.1	260.0158	239.35	239.75	4160000.0
2020-03-16 09:00:00	SPY	ETF	239.85	247.79	237.36	245.57	22444622.0
2020-03-16 10:00:00	SPY	ETF	245.59	252.96	242.52	250.77	46078856.0
2020-03-16 11:00:00	SPY	ETF	250.77	256.9	250.21	254.13	34185399.0
2020-03-16 12:00:00	SPY	ETF	254.12	254.77	247.84	248.97	24891858.0
2020-03-16 13:00:00	SPY	ETF	248.97	251.64	246.16	247.205	23035536.0
2020-03-16 14:00:00	SPY	ETF	247.2	251.04	240.78	249.105	32818668.0
2020-03-16 15:00:00	SPY	ETF	249.11	250.85	238.8	239.41	81229031.0
2020-03-16 16:00:00	SPY	ETF	239.5	248.7395	239.21	241.61	17420636.0
2020-03-16 17:00:00	SPY	ETF	241.79	242.0	240.0	241.55	1110411.0
2020-03-16 18:00:00	SPY	ETF	241.55	245.63	240.88	243.2	1526490.0
2020-03-16 19:00:00	SPY	ETF	243.2	245.8	243.2	244.9	461363.0
2020-03-16 04:00:00	QQQ	ETF	181.1	183.0	176.5	176.89	115457.0
2020-03-16 05:00:00	QQQ	ETF	176.7	177.0	175.07	175.77	143388.0
2020-03-16 06:00:00	QQQ	ETF	175.84	176.05	175.02	176.05	115474.0
2020-03-16 07:00:00	QQQ	ETF	175.31	177.07	175.11	175.5	544661.0
2020-03-16 08:00:00	QQQ	ETF	175.6	185.6801	173.8	174.06	813565.0
2020-03-16 09:00:00	QQQ	ETF	174.06	178.5	171.25	176.83	6094072.0
2020-03-16 10:00:00	QQQ	ETF	176.79	181.88	173.6354	180.75	12808623.0
2020-03-16 11:00:00	QQQ	ETF	180.73	184.68	180.3	183.47	9917569.0
2020-03-16 12:00:00	QQQ	ETF	183.43	183.83	178.94	179.65	6206119.0
2020-03-16 13:00:00	QQQ	ETF	179.6	181.19	177.81	178.1	7157640.0
2020-03-16 14:00:00	QQQ	ETF	178.06	180.81	171.5	179.09	9633761.0
2020-03-16 15:00:00	QQQ	ETF	179.13	180.49	169.16	169.57	21664627.0
2020-03-16 16:00:00	QQQ	ETF	169.69	175.0	169.3	172.15	2723117.0
2020-03-16 17:00:00	QQQ	ETF	172.11	172.4	170.73	171.25	860748.0
2020-03-16 18:00:00	QQQ	ETF	171.5	174.57	170.68	173.2	476938.0
2020-03-16 19:00:00	QQQ	ETF	173.55	175.41	173.53	174.78	317417.0
2020-03-16 04:00:00	IWM	ETF	113.0	113.0	109.25	109.25	7812.0
2020-03-16 05:00:00	IWM	ETF	109.0	109.25	108.66	109.2	3502.0
2020-03-16 06:00:00	IWM	ETF	108.26	108.5	107.0	107.0	2517.0
2020-03-16 07:00:00	IWM	ETF	107.5	109.0	107.5	107.9	40017.0
2020-03-16 08:00:00	IWM	ETF	108.77	108.92	107.01	107.5	167908.0
2020-03-16 09:00:00	IWM	ETF	107.51	108.62	103.12	105.93	2993171.0
2020-03-16 10:00:00	IWM	ETF	105.92	110.38	104.61	108.765	6810941.0
2020-03-16 11:00:00	IWM	ETF	108.705	111.3	107.44	109.46	5623335.0
2020-03-16 12:00:00	IWM	ETF	109.46	110.06	106.36	106.8	5101867.0
2020-03-16 13:00:00	IWM	ETF	106.8	107.97	105.67	106.6	4313419.0
2020-03-16 14:00:00	IWM	ETF	106.58	108.08	105.025	107.74	6136540.0
2020-03-16 15:00:00	IWM	ETF	107.73	108.1	101.43	103.3	14772526.0
2020-03-16 16:00:00	IWM	ETF	103.3	105.51	103.18	103.5	3511841.0
2020-03-16 17:00:00	IWM	ETF	103.23	104.0	102.5	103.09	62847.0
2020-03-16 18:00:00	IWM	ETF	103.25	104.5	102.5	103.4	651582.0
2020-03-16 19:00:00	IWM	ETF	103.4	105.38	103.4	105.25	352784.0
2020-03-16 04:00:00	DIA	ETF	215.0	215.79	210.11	211.46	6629.0
2020-03-16 05:00:00	DIA	ETF	211.33	212.0	210.11	211.0	21706.0

> showing 50 of 14,193 rows — these rows as CSV

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