PREVIEW / etf_1hour / 2022-03-09

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-03-09.parquet
  size:    465 KB
  rows:    16,921

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
2022-03-09 04:00:00	SPY	ETF	421.5	423.93	419.11	423.87	171259.0
2022-03-09 05:00:00	SPY	ETF	423.84	424.3	422.56	423.06	142509.0
2022-03-09 06:00:00	SPY	ETF	422.86	424.38	422.33	422.98	125085.0
2022-03-09 07:00:00	SPY	ETF	422.81	424.2	422.4	424.04	527104.0
2022-03-09 08:00:00	SPY	ETF	422.9399	425.2	417.73	423.51	924993.0
2022-03-09 09:00:00	SPY	ETF	423.55	426.49	422.82	424.1377	12860192.0
2022-03-09 10:00:00	SPY	ETF	424.14	426.95	423.96	426.58	13933521.0
2022-03-09 11:00:00	SPY	ETF	426.58	427.52	424.73	427.37	9844566.0
2022-03-09 12:00:00	SPY	ETF	427.38	428.75	426.78	428.365	9110024.0
2022-03-09 13:00:00	SPY	ETF	428.38	428.38	426.29	426.7001	6003880.0
2022-03-09 14:00:00	SPY	ETF	426.72	428.12	426.57	427.3199	6456351.0
2022-03-09 15:00:00	SPY	ETF	427.32	429.51	426.63	427.41	20114346.0
2022-03-09 16:00:00	SPY	ETF	427.4	428.31	426.82	427.72	6359953.0
2022-03-09 17:00:00	SPY	ETF	427.72	427.8	427.41	427.51	87502.0
2022-03-09 18:00:00	SPY	ETF	427.65	427.87	426.91	427.24	228962.0
2022-03-09 19:00:00	SPY	ETF	427.3	427.65	426.8	427.24	101563.0
2022-03-09 04:00:00	QQQ	ETF	327.91	330.55	327.8	330.41	135366.0
2022-03-09 05:00:00	QQQ	ETF	330.3	330.84	329.42	329.5	191619.0
2022-03-09 06:00:00	QQQ	ETF	329.59	330.99	329.19	329.55	183688.0
2022-03-09 07:00:00	QQQ	ETF	329.52	330.92	328.95	330.82	400858.0
2022-03-09 08:00:00	QQQ	ETF	329.48	331.85	323.54	330.48	796638.0
2022-03-09 09:00:00	QQQ	ETF	330.55	332.67	329.09	330.88	9986658.0
2022-03-09 10:00:00	QQQ	ETF	330.88	333.63	330.48	333.2299	8168035.0
2022-03-09 11:00:00	QQQ	ETF	333.23	333.39	331.15	333.2499	4660306.0
2022-03-09 12:00:00	QQQ	ETF	333.24	335.27	332.48	334.608	4784302.0
2022-03-09 13:00:00	QQQ	ETF	334.62	334.98	333.08	333.83	3719570.0
2022-03-09 14:00:00	QQQ	ETF	333.84	335.18	333.66	334.59	3699641.0
2022-03-09 15:00:00	QQQ	ETF	334.61	336.38	334.12	335.05	9112774.0
2022-03-09 16:00:00	QQQ	ETF	335.04	337.05	334.48	335.9	3558622.0
2022-03-09 17:00:00	QQQ	ETF	335.81	336.31	334.99	335.6	333573.0
2022-03-09 18:00:00	QQQ	ETF	335.7	335.88	334.78	335.2	424809.0
2022-03-09 19:00:00	QQQ	ETF	335.22	335.44	334.89	335.14	280745.0
2022-03-09 04:00:00	IWM	ETF	196.0	198.21	196.0	198.08	49233.0
2022-03-09 05:00:00	IWM	ETF	198.02	198.39	197.55	197.72	62066.0
2022-03-09 06:00:00	IWM	ETF	197.64	198.22	197.19	197.32	84632.0
2022-03-09 07:00:00	IWM	ETF	197.28	198.25	196.85	198.15	119956.0
2022-03-09 08:00:00	IWM	ETF	197.0	198.51	194.9339	197.63	386076.0
2022-03-09 09:00:00	IWM	ETF	197.62	199.69	197.48	198.895	4997300.0
2022-03-09 10:00:00	IWM	ETF	198.91	200.33	198.73	200.31	3627794.0
2022-03-09 11:00:00	IWM	ETF	200.27	200.68	199.59	200.59	2139238.0
2022-03-09 12:00:00	IWM	ETF	200.61	201.0	200.09	200.61	1585731.0
2022-03-09 13:00:00	IWM	ETF	200.61	200.92	199.68	199.74	1289523.0
2022-03-09 14:00:00	IWM	ETF	199.73	200.5838	199.47	200.23	1532008.0
2022-03-09 15:00:00	IWM	ETF	200.24	201.0	199.88	200.24	3326131.0
2022-03-09 16:00:00	IWM	ETF	200.25	200.8	199.94	199.99	3262554.0
2022-03-09 17:00:00	IWM	ETF	200.18	200.35	199.95	200.24	64725.0
2022-03-09 18:00:00	IWM	ETF	200.12	200.2	199.76	199.92	62988.0
2022-03-09 19:00:00	IWM	ETF	199.95	200.25	199.67	199.93	18431.0
2022-03-09 04:00:00	DIA	ETF	330.42	331.53	330.05	331.53	6086.0
2022-03-09 05:00:00	DIA	ETF	331.49	331.92	330.89	330.89	2500.0

> showing 50 of 16,921 rows — these rows as CSV

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