PREVIEW / etf_1hour / 2020-03-05

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-03-05.parquet
  size:    386 KB
  rows:    12,867

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-05 04:00:00	SPY	ETF	307.72	307.72	306.56	307.1	120040.0
2020-03-05 05:00:00	SPY	ETF	306.89	307.05	305.19	305.19	184408.0
2020-03-05 06:00:00	SPY	ETF	305.53	306.43	304.91	305.86	439276.0
2020-03-05 07:00:00	SPY	ETF	305.97	306.58	305.26	305.75	1238892.0
2020-03-05 08:00:00	SPY	ETF	305.9	310.53	304.04	305.46	1690593.0
2020-03-05 09:00:00	SPY	ETF	305.4	306.45	303.44	304.55	18798556.0
2020-03-05 10:00:00	SPY	ETF	304.57	306.99	304.0467	306.02	22002634.0
2020-03-05 11:00:00	SPY	ETF	306.04	308.47	305.27	305.74	20893957.0
2020-03-05 12:00:00	SPY	ETF	305.75	306.08	302.05	302.482	22016835.0
2020-03-05 13:00:00	SPY	ETF	302.48	304.18	301.47	303.49	21014036.0
2020-03-05 14:00:00	SPY	ETF	303.48	303.49	301.1	302.32	15097502.0
2020-03-05 15:00:00	SPY	ETF	302.36	303.19	300.01	302.45	41591591.0
2020-03-05 16:00:00	SPY	ETF	302.45	303.8384	301.62	302.6	16822467.0
2020-03-05 17:00:00	SPY	ETF	302.6	303.0	301.88	302.64	1580044.0
2020-03-05 18:00:00	SPY	ETF	302.64	313.0826	302.0	302.9	547963.0
2020-03-05 19:00:00	SPY	ETF	302.92	303.96	301.85	302.68	345957.0
2020-03-05 04:00:00	QQQ	ETF	214.29	214.29	213.47	213.81	98419.0
2020-03-05 05:00:00	QQQ	ETF	213.82	213.87	212.59	212.68	156391.0
2020-03-05 06:00:00	QQQ	ETF	212.8	213.47	212.52	213.12	202437.0
2020-03-05 07:00:00	QQQ	ETF	213.17	213.58	212.79	212.84	649484.0
2020-03-05 08:00:00	QQQ	ETF	212.98	216.38	211.93	212.78	661052.0
2020-03-05 09:00:00	QQQ	ETF	212.71	214.29	211.62	213.18	9018329.0
2020-03-05 10:00:00	QQQ	ETF	213.17	215.38	212.64	214.58	8073155.0
2020-03-05 11:00:00	QQQ	ETF	214.6	216.36	214.11	214.3941	7322313.0
2020-03-05 12:00:00	QQQ	ETF	214.42	214.67	211.64	211.94	7499100.0
2020-03-05 13:00:00	QQQ	ETF	211.94	213.39	211.22	212.8	8745328.0
2020-03-05 14:00:00	QQQ	ETF	212.8	212.8	211.12	211.87	7506981.0
2020-03-05 15:00:00	QQQ	ETF	211.874	212.25	210.1	211.58	14573590.0
2020-03-05 16:00:00	QQQ	ETF	211.58	211.79	210.8	211.63	1843633.0
2020-03-05 17:00:00	QQQ	ETF	211.45	211.69	211.33	211.58	58542.0
2020-03-05 18:00:00	QQQ	ETF	211.68	212.12	211.3	212.12	116130.0
2020-03-05 19:00:00	QQQ	ETF	212.18	212.87	211.37	211.81	208814.0
2020-03-05 04:00:00	IWM	ETF	149.95	149.95	149.4	149.5	12754.0
2020-03-05 05:00:00	IWM	ETF	149.25	149.25	148.75	148.8	7432.0
2020-03-05 06:00:00	IWM	ETF	149.23	149.39	148.79	149.27	37922.0
2020-03-05 07:00:00	IWM	ETF	149.35	149.5	149.08	149.3	64390.0
2020-03-05 08:00:00	IWM	ETF	149.2601	150.21	148.27	148.89	155348.0
2020-03-05 09:00:00	IWM	ETF	148.85	149.85	148.08	148.6	3001866.0
2020-03-05 10:00:00	IWM	ETF	148.56	149.74	148.12	148.28	3155819.0
2020-03-05 11:00:00	IWM	ETF	148.33	149.76	148.24	148.545	2588679.0
2020-03-05 12:00:00	IWM	ETF	148.55	148.73	146.62	146.97	3080852.0
2020-03-05 13:00:00	IWM	ETF	146.98	147.82	146.55	147.15	3215540.0
2020-03-05 14:00:00	IWM	ETF	147.13	147.14	145.97	146.43	3551430.0
2020-03-05 15:00:00	IWM	ETF	146.45	147.38	145.485	147.27	6172710.0
2020-03-05 16:00:00	IWM	ETF	147.29	147.5247	146.9	147.45	960621.0
2020-03-05 17:00:00	IWM	ETF	147.24	147.59	147.24	147.5	55287.0
2020-03-05 18:00:00	IWM	ETF	147.49	147.63	147.16	147.61	27080.0
2020-03-05 19:00:00	IWM	ETF	147.69	148.0	147.09	147.45	29640.0
2020-03-05 04:00:00	DIA	ETF	266.21	266.61	266.0	266.46	4178.0
2020-03-05 05:00:00	DIA	ETF	266.2	266.2	265.14	265.14	1508.0

> showing 50 of 12,867 rows — these rows as CSV

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