PREVIEW / etf_1hour / 2021-07-22

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-07-22.parquet
  size:    402 KB
  rows:    14,048

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
2021-07-22 04:00:00	SPY	ETF	435.04	435.29	435.03	435.21	25708.0
2021-07-22 05:00:00	SPY	ETF	435.19	435.41	435.18	435.33	14028.0
2021-07-22 06:00:00	SPY	ETF	435.34	435.59	435.25	435.51	38468.0
2021-07-22 07:00:00	SPY	ETF	435.5	435.51	434.89	435.16	127120.0
2021-07-22 08:00:00	SPY	ETF	435.45	435.5296	434.14	434.35	354439.0
2021-07-22 09:00:00	SPY	ETF	434.34	435.03	433.93	434.4	5715282.0
2021-07-22 10:00:00	SPY	ETF	434.39	435.365	434.07	435.04	5635114.0
2021-07-22 11:00:00	SPY	ETF	435.04	435.145	434.17	434.505	4019745.0
2021-07-22 12:00:00	SPY	ETF	434.5099	434.82	433.69	434.81	4506854.0
2021-07-22 13:00:00	SPY	ETF	434.81	435.24	434.68	435.229	2588148.0
2021-07-22 14:00:00	SPY	ETF	435.225	435.72	435.157	435.6619	3695681.0
2021-07-22 15:00:00	SPY	ETF	435.6501	435.71	435.11	435.49	7311239.0
2021-07-22 16:00:00	SPY	ETF	435.52	436.65	435.46	436.6	2394646.0
2021-07-22 17:00:00	SPY	ETF	436.61	436.71	436.49	436.63	86428.0
2021-07-22 18:00:00	SPY	ETF	436.63	436.67	435.46	436.52	43952.0
2021-07-22 19:00:00	SPY	ETF	436.51	436.58	436.41	436.5	28117.0
2021-07-22 04:00:00	QQQ	ETF	362.01	362.37	361.86	361.97	26562.0
2021-07-22 05:00:00	QQQ	ETF	361.95	362.18	361.93	361.93	5469.0
2021-07-22 06:00:00	QQQ	ETF	361.92	362.15	361.72	362.1	27639.0
2021-07-22 07:00:00	QQQ	ETF	362.08	362.28	361.72	361.93	123023.0
2021-07-22 08:00:00	QQQ	ETF	361.9396	362.2599	361.57	361.68	135874.0
2021-07-22 09:00:00	QQQ	ETF	361.66	363.08	361.47	362.68	4045311.0
2021-07-22 10:00:00	QQQ	ETF	362.6705	363.77	362.53	363.435	4100358.0
2021-07-22 11:00:00	QQQ	ETF	363.4288	363.75	362.69	363.32	2792839.0
2021-07-22 12:00:00	QQQ	ETF	363.32	363.4185	361.99	362.9499	2654263.0
2021-07-22 13:00:00	QQQ	ETF	362.95	363.4987	362.86	363.345	1391372.0
2021-07-22 14:00:00	QQQ	ETF	363.34	363.85	363.2	363.77	2177034.0
2021-07-22 15:00:00	QQQ	ETF	363.78	363.96	363.4401	363.94	3698411.0
2021-07-22 16:00:00	QQQ	ETF	363.93	365.21	363.91	365.07	979937.0
2021-07-22 17:00:00	QQQ	ETF	365.05	365.11	363.95	365.0	53839.0
2021-07-22 18:00:00	QQQ	ETF	365.05	365.22	364.92	365.06	43660.0
2021-07-22 19:00:00	QQQ	ETF	365.1	365.14	364.92	364.92	57879.0
2021-07-22 04:00:00	IWM	ETF	222.3	222.78	222.21	222.65	9562.0
2021-07-22 05:00:00	IWM	ETF	222.6	222.69	222.49	222.69	8453.0
2021-07-22 06:00:00	IWM	ETF	222.58	222.99	222.57	222.96	58883.0
2021-07-22 07:00:00	IWM	ETF	222.88	222.91	222.18	222.21	68570.0
2021-07-22 08:00:00	IWM	ETF	222.4101	222.94	220.56	220.89	210745.0
2021-07-22 09:00:00	IWM	ETF	220.88	221.57	219.221	219.45	4478392.0
2021-07-22 10:00:00	IWM	ETF	219.46	219.89	218.63	218.66	4448647.0
2021-07-22 11:00:00	IWM	ETF	218.66	218.81	217.9	218.17	3747249.0
2021-07-22 12:00:00	IWM	ETF	218.17	218.85	217.58	218.77	3364451.0
2021-07-22 13:00:00	IWM	ETF	218.77	219.36	218.67	219.28	2195507.0
2021-07-22 14:00:00	IWM	ETF	219.28	219.58	218.87	219.56	1857913.0
2021-07-22 15:00:00	IWM	ETF	219.555	219.6099	218.1	218.47	4417439.0
2021-07-22 16:00:00	IWM	ETF	218.53	219.3	218.45	219.26	3261568.0
2021-07-22 17:00:00	IWM	ETF	219.03	219.47	218.53	219.3	94531.0
2021-07-22 18:00:00	IWM	ETF	219.33	219.35	219.12	219.28	29541.0
2021-07-22 19:00:00	IWM	ETF	219.26	219.35	219.0	219.01	77497.0
2021-07-22 04:00:00	DIA	ETF	348.59	348.63	348.59	348.61	800.0
2021-07-22 05:00:00	DIA	ETF	348.61	348.78	348.61	348.78	500.0

> showing 50 of 14,048 rows — these rows as CSV

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