PREVIEW / etf_1hour / 2022-02-15

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-02-15.parquet
  size:    453 KB
  rows:    16,147

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-02-15 04:00:00	SPY	ETF	443.9	444.95	441.4	444.3	115620.0
2022-02-15 05:00:00	SPY	ETF	444.6	445.3	443.63	444.81	153660.0
2022-02-15 06:00:00	SPY	ETF	445.05	446.01	445.05	445.49	201038.0
2022-02-15 07:00:00	SPY	ETF	445.35	446.3	444.89	445.77	810925.0
2022-02-15 08:00:00	SPY	ETF	445.79	446.28	437.94	444.01	964939.0
2022-02-15 09:00:00	SPY	ETF	444.05	445.78	443.45	444.03	8740956.0
2022-02-15 10:00:00	SPY	ETF	444.04	445.92	443.5	445.52	9458286.0
2022-02-15 11:00:00	SPY	ETF	445.51	445.99	444.76	445.6	7407231.0
2022-02-15 12:00:00	SPY	ETF	445.61	445.91	443.18	443.8618	6393866.0
2022-02-15 13:00:00	SPY	ETF	443.87	445.6	443.76	445.49	5066590.0
2022-02-15 14:00:00	SPY	ETF	445.495	445.73	444.46	445.35	6468187.0
2022-02-15 15:00:00	SPY	ETF	445.35	446.28	443.86	446.07	19439650.0
2022-02-15 16:00:00	SPY	ETF	446.07	446.1	444.83	445.37	4266121.0
2022-02-15 17:00:00	SPY	ETF	445.45	446.1	445.1	445.42	139433.0
2022-02-15 18:00:00	SPY	ETF	445.4	445.54	444.75	444.85	129259.0
2022-02-15 19:00:00	SPY	ETF	444.85	444.99	444.62	444.69	82461.0
2022-02-15 04:00:00	QQQ	ETF	349.95	354.37	349.95	353.63	177769.0
2022-02-15 05:00:00	QQQ	ETF	353.75	354.59	353.35	354.17	135643.0
2022-02-15 06:00:00	QQQ	ETF	354.01	355.32	353.99	354.77	261157.0
2022-02-15 07:00:00	QQQ	ETF	354.75	355.32	354.32	354.75	512767.0
2022-02-15 08:00:00	QQQ	ETF	354.86	355.3396	347.24	352.89	1038905.0
2022-02-15 09:00:00	QQQ	ETF	352.85	354.07	352.22	353.599	6592760.0
2022-02-15 10:00:00	QQQ	ETF	353.6333	354.7	352.392	354.09	7295058.0
2022-02-15 11:00:00	QQQ	ETF	354.11	355.0974	353.82	354.77	5460115.0
2022-02-15 12:00:00	QQQ	ETF	354.78	355.01	351.82	352.79	5463705.0
2022-02-15 13:00:00	QQQ	ETF	352.78	354.71	352.64	354.61	3975075.0
2022-02-15 14:00:00	QQQ	ETF	354.61	355.27	353.68	355.08	4285094.0
2022-02-15 15:00:00	QQQ	ETF	355.08	356.37	354.15	356.21	10540903.0
2022-02-15 16:00:00	QQQ	ETF	356.22	356.22	354.95	355.6	1453573.0
2022-02-15 17:00:00	QQQ	ETF	355.85	355.97	355.41	355.61	50286.0
2022-02-15 18:00:00	QQQ	ETF	355.65	355.73	355.02	355.15	65897.0
2022-02-15 19:00:00	QQQ	ETF	355.15	355.21	354.79	354.79	198132.0
2022-02-15 04:00:00	IWM	ETF	203.29	203.84	203.0	203.4	57352.0
2022-02-15 05:00:00	IWM	ETF	203.59	203.91	203.01	203.82	63257.0
2022-02-15 06:00:00	IWM	ETF	203.91	204.61	203.89	204.37	88149.0
2022-02-15 07:00:00	IWM	ETF	204.27	204.7	203.88	204.3	159189.0
2022-02-15 08:00:00	IWM	ETF	204.32	204.5701	200.36	203.14	165659.0
2022-02-15 09:00:00	IWM	ETF	203.1	204.95	202.63	203.91	3975679.0
2022-02-15 10:00:00	IWM	ETF	203.93	204.579	202.97	204.32	2820292.0
2022-02-15 11:00:00	IWM	ETF	204.33	205.31	204.14	205.21	1865037.0
2022-02-15 12:00:00	IWM	ETF	205.21	205.52	204.11	204.73	1437613.0
2022-02-15 13:00:00	IWM	ETF	204.72	205.89	204.62	205.78	1702613.0
2022-02-15 14:00:00	IWM	ETF	205.79	206.08	205.34	205.77	2040963.0
2022-02-15 15:00:00	IWM	ETF	205.78	206.305	205.02	206.06	3634538.0
2022-02-15 16:00:00	IWM	ETF	206.06	206.11	205.61	205.85	1180068.0
2022-02-15 17:00:00	IWM	ETF	205.87	206.06	205.72	205.88	38611.0
2022-02-15 18:00:00	IWM	ETF	205.75	206.06	205.45	205.5	18334.0
2022-02-15 19:00:00	IWM	ETF	205.54	205.66	205.37	205.37	24991.0
2022-02-15 04:00:00	DIA	ETF	348.81	349.31	348.64	349.21	1400.0
2022-02-15 05:00:00	DIA	ETF	349.24	349.56	348.09	349.12	6500.0

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

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