PREVIEW / etf_1hour / 2020-03-25

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-03-25.parquet
  size:    400 KB
  rows:    13,699

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-25 04:00:00	SPY	ETF	246.89	248.74	245.1	248.09	258038.0
2020-03-25 05:00:00	SPY	ETF	248.25	250.0	247.21	247.94	269920.0
2020-03-25 06:00:00	SPY	ETF	247.8	247.94	240.41	240.7	698916.0
2020-03-25 07:00:00	SPY	ETF	240.6	243.0	239.03	241.04	2454965.0
2020-03-25 08:00:00	SPY	ETF	241.25	249.77	239.05	243.13	3304848.0
2020-03-25 09:00:00	SPY	ETF	243.12	249.225	242.22	242.52	48139221.0
2020-03-25 10:00:00	SPY	ETF	242.5	245.74	239.75	245.39	46915564.0
2020-03-25 11:00:00	SPY	ETF	245.41	246.75	244.35	245.84	25539785.0
2020-03-25 12:00:00	SPY	ETF	245.82	252.27	245.71	250.81	34179494.0
2020-03-25 13:00:00	SPY	ETF	250.8357	256.35	250.48	254.03	33812369.0
2020-03-25 14:00:00	SPY	ETF	254.06	255.03	251.01	254.42	34679549.0
2020-03-25 15:00:00	SPY	ETF	254.42	255.49	245.59	246.77	56008676.0
2020-03-25 16:00:00	SPY	ETF	246.8	248.29	244.6132	246.83	9926078.0
2020-03-25 17:00:00	SPY	ETF	246.86	247.25	246.21	247.0	435472.0
2020-03-25 18:00:00	SPY	ETF	247.16	249.0	246.26	247.4	644535.0
2020-03-25 19:00:00	SPY	ETF	247.43	247.43	245.66	246.96	793020.0
2020-03-25 04:00:00	QQQ	ETF	186.1	188.09	185.3	187.65	153949.0
2020-03-25 05:00:00	QQQ	ETF	187.8	189.19	186.87	187.36	133235.0
2020-03-25 06:00:00	QQQ	ETF	187.27	187.33	181.63	181.74	343095.0
2020-03-25 07:00:00	QQQ	ETF	181.73	183.75	181.01	182.44	953603.0
2020-03-25 08:00:00	QQQ	ETF	183.2899	188.4	180.05	183.59	474565.0
2020-03-25 09:00:00	QQQ	ETF	183.63	187.1	182.25	182.47	11162931.0
2020-03-25 10:00:00	QQQ	ETF	182.39	183.53	179.98	183.29	10468467.0
2020-03-25 11:00:00	QQQ	ETF	183.32	183.99	182.21	183.0576	7195632.0
2020-03-25 12:00:00	QQQ	ETF	183.07	186.45	182.98	185.58	8214352.0
2020-03-25 13:00:00	QQQ	ETF	185.62	189.51	185.39	187.8301	8871221.0
2020-03-25 14:00:00	QQQ	ETF	187.84	188.12	185.7697	187.58	7303576.0
2020-03-25 15:00:00	QQQ	ETF	187.585	188.31	181.47	182.13	15447994.0
2020-03-25 16:00:00	QQQ	ETF	182.13	183.08	181.76	182.66	2491257.0
2020-03-25 17:00:00	QQQ	ETF	182.55	182.9	182.43	182.85	52939.0
2020-03-25 18:00:00	QQQ	ETF	182.9	184.0	182.38	182.86	174770.0
2020-03-25 19:00:00	QQQ	ETF	182.88	182.88	181.55	182.63	215537.0
2020-03-25 04:00:00	IWM	ETF	110.12	112.56	109.66	111.1	135736.0
2020-03-25 05:00:00	IWM	ETF	110.82	112.37	110.19	111.15	25934.0
2020-03-25 06:00:00	IWM	ETF	111.02	111.2	107.0	107.0	104774.0
2020-03-25 07:00:00	IWM	ETF	107.09	108.11	106.2	107.14	202838.0
2020-03-25 08:00:00	IWM	ETF	106.38	109.88	106.38	108.13	816659.0
2020-03-25 09:00:00	IWM	ETF	108.11	111.95	107.15	108.0	6327202.0
2020-03-25 10:00:00	IWM	ETF	107.99	108.7	106.02	108.52	9002085.0
2020-03-25 11:00:00	IWM	ETF	108.59	109.58	107.995	109.29	4366477.0
2020-03-25 12:00:00	IWM	ETF	109.3	112.45	109.17	111.45	5196316.0
2020-03-25 13:00:00	IWM	ETF	111.49	114.0	111.29	112.22	4783395.0
2020-03-25 14:00:00	IWM	ETF	112.27	113.08	110.74	112.58	5074544.0
2020-03-25 15:00:00	IWM	ETF	112.61	113.285	109.7	110.01	10699248.0
2020-03-25 16:00:00	IWM	ETF	110.03	110.2678	108.8902	109.36	1522133.0
2020-03-25 17:00:00	IWM	ETF	109.08	109.77	109.01	109.64	77144.0
2020-03-25 18:00:00	IWM	ETF	109.53	110.16	109.07	109.53	80393.0
2020-03-25 19:00:00	IWM	ETF	109.31	109.43	108.85	109.43	40633.0
2020-03-25 04:00:00	DIA	ETF	212.14	214.02	210.7	213.84	15295.0
2020-03-25 05:00:00	DIA	ETF	213.79	215.64	212.69	213.44	15806.0

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

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