PREVIEW / etf_1hour / 2022-01-19

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-01-19.parquet
  size:    460 KB
  rows:    16,658

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-01-19 04:00:00	SPY	ETF	456.0	457.36	455.5	457.27	48494.0
2022-01-19 05:00:00	SPY	ETF	457.21	457.54	456.92	457.54	60496.0
2022-01-19 06:00:00	SPY	ETF	457.55	457.95	456.73	457.58	63983.0
2022-01-19 07:00:00	SPY	ETF	457.75	457.96	457.1	457.76	395445.0
2022-01-19 08:00:00	SPY	ETF	457.8001	458.8	453.39	458.63	599113.0
2022-01-19 09:00:00	SPY	ETF	458.68	459.6124	457.74	459.48	8477814.0
2022-01-19 10:00:00	SPY	ETF	459.48	459.55	455.471	456.282	11623701.0
2022-01-19 11:00:00	SPY	ETF	456.28	456.87	454.73	456.72	9715457.0
2022-01-19 12:00:00	SPY	ETF	456.73	458.26	456.7	458.09	7141722.0
2022-01-19 13:00:00	SPY	ETF	458.11	458.1712	456.09	456.43	5864393.0
2022-01-19 14:00:00	SPY	ETF	456.42	456.66	454.25	455.3699	8289995.0
2022-01-19 15:00:00	SPY	ETF	455.38	456.11	451.46	451.79	21741165.0
2022-01-19 16:00:00	SPY	ETF	451.79	452.32	451.11	451.75	5211745.0
2022-01-19 17:00:00	SPY	ETF	451.81	451.9	451.69	451.8	79236.0
2022-01-19 18:00:00	SPY	ETF	451.86	452.22	450.88	450.88	168614.0
2022-01-19 19:00:00	SPY	ETF	451.14	452.52	451.14	452.08	189935.0
2022-01-19 04:00:00	QQQ	ETF	370.24	372.03	369.88	372.03	128762.0
2022-01-19 05:00:00	QQQ	ETF	371.98	372.0	371.27	372.0	57020.0
2022-01-19 06:00:00	QQQ	ETF	372.14	372.31	371.05	372.25	107562.0
2022-01-19 07:00:00	QQQ	ETF	372.16	372.31	371.27	372.06	145207.0
2022-01-19 08:00:00	QQQ	ETF	372.19	373.47	367.01	373.27	567184.0
2022-01-19 09:00:00	QQQ	ETF	373.27	374.609	371.75	374.4396	7643277.0
2022-01-19 10:00:00	QQQ	ETF	374.42	374.69	369.48	370.5339	11412089.0
2022-01-19 11:00:00	QQQ	ETF	370.51	371.16	368.16	370.38	9206533.0
2022-01-19 12:00:00	QQQ	ETF	370.35	373.33	370.32	373.19	8011278.0
2022-01-19 13:00:00	QQQ	ETF	373.2	373.3	371.19	371.74	5510643.0
2022-01-19 14:00:00	QQQ	ETF	371.71	372.06	369.145	370.12	6271531.0
2022-01-19 15:00:00	QQQ	ETF	370.13	370.86	366.21	366.53	11878055.0
2022-01-19 16:00:00	QQQ	ETF	366.5	366.84	365.88	366.45	3957755.0
2022-01-19 17:00:00	QQQ	ETF	366.46	366.65	366.23	366.65	487176.0
2022-01-19 18:00:00	QQQ	ETF	366.6	366.94	365.54	365.8	301742.0
2022-01-19 19:00:00	QQQ	ETF	365.79	367.32	365.79	366.93	255685.0
2022-01-19 04:00:00	IWM	ETF	207.14	208.25	206.98	208.16	51769.0
2022-01-19 05:00:00	IWM	ETF	208.16	208.46	208.04	208.24	31589.0
2022-01-19 06:00:00	IWM	ETF	208.42	208.63	207.52	208.57	88684.0
2022-01-19 07:00:00	IWM	ETF	208.51	208.78	208.26	208.54	96453.0
2022-01-19 08:00:00	IWM	ETF	208.3201	209.25	206.13	209.18	275345.0
2022-01-19 09:00:00	IWM	ETF	209.2	209.46	207.87	208.67	3682509.0
2022-01-19 10:00:00	IWM	ETF	208.67	208.7	205.53	206.66	7185540.0
2022-01-19 11:00:00	IWM	ETF	206.63	207.09	205.25	206.97	5026584.0
2022-01-19 12:00:00	IWM	ETF	206.94	208.4	206.9201	207.63	3974079.0
2022-01-19 13:00:00	IWM	ETF	207.63	207.67	206.36	206.8	2410669.0
2022-01-19 14:00:00	IWM	ETF	206.78	206.94	205.645	206.27	2939967.0
2022-01-19 15:00:00	IWM	ETF	206.28	206.545	204.38	204.53	6812600.0
2022-01-19 16:00:00	IWM	ETF	204.52	204.72	204.0	204.68	1588740.0
2022-01-19 17:00:00	IWM	ETF	204.71	204.75	204.41	204.65	302855.0
2022-01-19 18:00:00	IWM	ETF	204.72	204.92	203.95	203.98	69027.0
2022-01-19 19:00:00	IWM	ETF	204.18	205.18	204.18	204.66	99097.0
2022-01-19 04:00:00	DIA	ETF	353.39	354.23	353.21	354.2	3595.0
2022-01-19 05:00:00	DIA	ETF	354.03	354.27	354.03	354.25	2012.0

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

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