PREVIEW / etf_1hour / 2022-01-25

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-01-25.parquet
  size:    474 KB
  rows:    17,017

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-25 04:00:00	SPY	ETF	434.95	437.4	433.22	436.89	152416.0
2022-01-25 05:00:00	SPY	ETF	436.91	437.7	434.71	435.19	112835.0
2022-01-25 06:00:00	SPY	ETF	435.1	436.35	433.76	434.2	349501.0
2022-01-25 07:00:00	SPY	ETF	434.17	434.68	432.91	433.39	467225.0
2022-01-25 08:00:00	SPY	ETF	434.14	440.169	431.4	433.16	1365607.0
2022-01-25 09:00:00	SPY	ETF	433.18	434.67	428.38	429.14	17265386.0
2022-01-25 10:00:00	SPY	ETF	429.13	433.98	427.15	431.14	20327859.0
2022-01-25 11:00:00	SPY	ETF	431.08	432.97	429.24	429.81	13353304.0
2022-01-25 12:00:00	SPY	ETF	429.8	432.84	429.5	431.55	9807132.0
2022-01-25 13:00:00	SPY	ETF	431.55	436.39	430.12	436.3093	10083011.0
2022-01-25 14:00:00	SPY	ETF	436.29	439.72	434.91	439.5	12026031.0
2022-01-25 15:00:00	SPY	ETF	439.49	439.62	433.44	434.48	28052002.0
2022-01-25 16:00:00	SPY	ETF	434.48	435.17	429.2	429.95	5750176.0
2022-01-25 17:00:00	SPY	ETF	430.1	430.5	429.67	430.4	191571.0
2022-01-25 18:00:00	SPY	ETF	430.4	436.4	430.4	435.16	712278.0
2022-01-25 19:00:00	SPY	ETF	435.17	435.28	432.99	433.59	267661.0
2022-01-25 04:00:00	QQQ	ETF	348.88	350.49	346.11	349.76	366797.0
2022-01-25 05:00:00	QQQ	ETF	349.83	350.3	347.53	347.94	149617.0
2022-01-25 06:00:00	QQQ	ETF	347.72	349.02	346.42	347.1	162841.0
2022-01-25 07:00:00	QQQ	ETF	347.08	347.34	345.72	346.45	433507.0
2022-01-25 08:00:00	QQQ	ETF	346.92	353.564	344.51	346.4	1037484.0
2022-01-25 09:00:00	QQQ	ETF	346.36	348.73	342.85	343.76	14334159.0
2022-01-25 10:00:00	QQQ	ETF	343.73	347.22	342.2	344.405	21870283.0
2022-01-25 11:00:00	QQQ	ETF	344.38	345.63	341.68	342.09	10339694.0
2022-01-25 12:00:00	QQQ	ETF	342.06	344.7483	341.84	343.565	9384224.0
2022-01-25 13:00:00	QQQ	ETF	343.57	348.03	342.33	347.91	8295847.0
2022-01-25 14:00:00	QQQ	ETF	347.91	351.0295	346.5	350.8	8438788.0
2022-01-25 15:00:00	QQQ	ETF	350.7921	350.92	344.12	344.93	15780438.0
2022-01-25 16:00:00	QQQ	ETF	344.93	346.22	338.65	339.45	4328811.0
2022-01-25 17:00:00	QQQ	ETF	339.55	345.11	339.31	340.15	279730.0
2022-01-25 18:00:00	QQQ	ETF	340.17	347.42	340.17	346.03	2694041.0
2022-01-25 19:00:00	QQQ	ETF	346.1	346.12	344.0	344.71	431254.0
2022-01-25 04:00:00	IWM	ETF	198.96	200.91	198.58	200.61	50585.0
2022-01-25 05:00:00	IWM	ETF	200.56	201.08	199.52	199.82	35316.0
2022-01-25 06:00:00	IWM	ETF	199.93	200.41	198.85	199.4	23146.0
2022-01-25 07:00:00	IWM	ETF	199.27	199.61	198.53	198.75	190446.0
2022-01-25 08:00:00	IWM	ETF	199.0001	200.52	197.85	199.02	198994.0
2022-01-25 09:00:00	IWM	ETF	198.81	199.35	195.04	195.81	9060681.0
2022-01-25 10:00:00	IWM	ETF	195.76	198.14	194.56	196.39	10677694.0
2022-01-25 11:00:00	IWM	ETF	196.36	197.75	195.75	196.5	5400430.0
2022-01-25 12:00:00	IWM	ETF	196.46	197.34	195.85	196.63	4140021.0
2022-01-25 13:00:00	IWM	ETF	196.65	199.55	196.02	199.52	4627469.0
2022-01-25 14:00:00	IWM	ETF	199.52	201.7	198.83	201.56	4407783.0
2022-01-25 15:00:00	IWM	ETF	201.54	201.62	198.45	198.87	7601004.0
2022-01-25 16:00:00	IWM	ETF	198.87	199.91	197.17	197.5	1359096.0
2022-01-25 17:00:00	IWM	ETF	197.8	198.84	197.29	197.72	155845.0
2022-01-25 18:00:00	IWM	ETF	197.7	199.42	197.7	198.65	200155.0
2022-01-25 19:00:00	IWM	ETF	198.86	199.01	197.96	198.31	43980.0
2022-01-25 04:00:00	DIA	ETF	341.0	342.88	341.0	342.62	13707.0
2022-01-25 05:00:00	DIA	ETF	342.65	343.47	341.37	341.7	6442.0

> showing 50 of 17,017 rows — these rows as CSV

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