PREVIEW / etf_1hour / 2022-03-01

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-03-01.parquet
  size:    466 KB
  rows:    16,758

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-01 04:00:00	SPY	ETF	436.74	437.03	433.81	434.03	140021.0
2022-03-01 05:00:00	SPY	ETF	434.14	434.46	432.66	434.43	132040.0
2022-03-01 06:00:00	SPY	ETF	434.1	434.6	432.07	432.73	127889.0
2022-03-01 07:00:00	SPY	ETF	432.79	434.35	432.68	433.33	485922.0
2022-03-01 08:00:00	SPY	ETF	432.8	439.56	432.5699	435.49	852452.0
2022-03-01 09:00:00	SPY	ETF	435.53	437.17	434.41	434.86	8928253.0
2022-03-01 10:00:00	SPY	ETF	434.86	436.23	432.31	432.71	14350139.0
2022-03-01 11:00:00	SPY	ETF	432.69	434.14	429.23	429.76	12216288.0
2022-03-01 12:00:00	SPY	ETF	429.765	431.64	428.5	431.33	11431741.0
2022-03-01 13:00:00	SPY	ETF	431.33	432.04	428.16	429.11	8693777.0
2022-03-01 14:00:00	SPY	ETF	429.1	431.4	427.93	429.73	11180110.0
2022-03-01 15:00:00	SPY	ETF	429.74	432.29	427.11	430.01	27194986.0
2022-03-01 16:00:00	SPY	ETF	430.01	431.19	429.75	430.7	5265877.0
2022-03-01 17:00:00	SPY	ETF	430.53	430.9	430.25	430.34	112033.0
2022-03-01 18:00:00	SPY	ETF	430.6	431.38	430.2	431.38	130062.0
2022-03-01 19:00:00	SPY	ETF	431.38	431.95	431.01	431.6	116445.0
2022-03-01 04:00:00	QQQ	ETF	346.9	346.9	344.08	344.15	75167.0
2022-03-01 05:00:00	QQQ	ETF	344.09	345.45	343.5	345.15	60827.0
2022-03-01 06:00:00	QQQ	ETF	345.0	345.42	343.18	343.77	93688.0
2022-03-01 07:00:00	QQQ	ETF	343.82	345.17	343.72	344.33	322077.0
2022-03-01 08:00:00	QQQ	ETF	344.43	349.1	343.75	345.81	556623.0
2022-03-01 09:00:00	QQQ	ETF	345.87	347.635	345.18	346.41	6566932.0
2022-03-01 10:00:00	QQQ	ETF	346.42	348.078	344.6799	345.14	10753141.0
2022-03-01 11:00:00	QQQ	ETF	345.13	346.57	341.88	342.3	7013910.0
2022-03-01 12:00:00	QQQ	ETF	342.28	343.9699	341.39	343.64	5137140.0
2022-03-01 13:00:00	QQQ	ETF	343.63	344.33	340.75	341.69	5896945.0
2022-03-01 14:00:00	QQQ	ETF	341.68	343.07	340.57	341.4332	5672058.0
2022-03-01 15:00:00	QQQ	ETF	341.45	343.85	338.9	341.56	9904515.0
2022-03-01 16:00:00	QQQ	ETF	341.57	342.5	341.2	342.03	1635205.0
2022-03-01 17:00:00	QQQ	ETF	342.19	342.21	341.49	342.0	95475.0
2022-03-01 18:00:00	QQQ	ETF	341.95	342.65	341.49	342.65	162663.0
2022-03-01 19:00:00	QQQ	ETF	342.63	343.03	342.2	342.55	164623.0
2022-03-01 04:00:00	IWM	ETF	203.76	203.88	201.96	202.07	20779.0
2022-03-01 05:00:00	IWM	ETF	201.92	202.2	201.12	202.19	17346.0
2022-03-01 06:00:00	IWM	ETF	202.01	202.39	201.1	201.54	19268.0
2022-03-01 07:00:00	IWM	ETF	201.59	202.65	201.59	201.94	94329.0
2022-03-01 08:00:00	IWM	ETF	201.8	204.75	201.51	203.21	181110.0
2022-03-01 09:00:00	IWM	ETF	203.21	203.79	201.48	201.7075	4112953.0
2022-03-01 10:00:00	IWM	ETF	201.76	202.51	200.31	200.68	4144623.0
2022-03-01 11:00:00	IWM	ETF	200.69	201.37	198.74	199.07	4183517.0
2022-03-01 12:00:00	IWM	ETF	199.06	200.33	198.58	200.17	2928433.0
2022-03-01 13:00:00	IWM	ETF	200.15	200.5438	198.47	199.12	2630455.0
2022-03-01 14:00:00	IWM	ETF	199.13	201.02	198.55	199.495	3464245.0
2022-03-01 15:00:00	IWM	ETF	199.5	200.96	197.8	199.43	6304991.0
2022-03-01 16:00:00	IWM	ETF	199.43	200.13	199.31	199.76	1028516.0
2022-03-01 17:00:00	IWM	ETF	199.54	199.87	199.49	199.53	13984.0
2022-03-01 18:00:00	IWM	ETF	199.59	200.08	199.41	199.99	46681.0
2022-03-01 19:00:00	IWM	ETF	200.08	200.4	199.88	200.28	47572.0
2022-03-01 04:00:00	DIA	ETF	339.63	339.63	338.9	338.95	2063.0
2022-03-01 05:00:00	DIA	ETF	336.99	337.18	336.61	336.97	7000.0

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

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