PREVIEW / etf_1hour / 2022-03-25

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-03-25.parquet
  size:    451 KB
  rows:    16,050

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-25 04:00:00	SPY	ETF	450.8	450.97	449.25	449.99	34615.0
2022-03-25 05:00:00	SPY	ETF	450.0	450.6	449.42	450.56	15365.0
2022-03-25 06:00:00	SPY	ETF	450.62	451.49	450.48	451.27	38953.0
2022-03-25 07:00:00	SPY	ETF	451.31	452.2	450.88	451.92	132124.0
2022-03-25 08:00:00	SPY	ETF	452.05	452.16	449.5896	451.85	161135.0
2022-03-25 09:00:00	SPY	ETF	451.86	451.86	450.3	450.8601	4752978.0
2022-03-25 10:00:00	SPY	ETF	450.88	452.98	450.45	452.33	6512973.0
2022-03-25 11:00:00	SPY	ETF	452.33	452.52	448.43	449.275	10542467.0
2022-03-25 12:00:00	SPY	ETF	449.29	450.48	448.9601	450.06	5432284.0
2022-03-25 13:00:00	SPY	ETF	450.07	451.43	449.54	451.335	5213809.0
2022-03-25 14:00:00	SPY	ETF	451.35	452.195	451.14	451.885	4949021.0
2022-03-25 15:00:00	SPY	ETF	451.885	452.79	449.71	452.66	12863160.0
2022-03-25 16:00:00	SPY	ETF	452.64	452.74	452.25	452.64	2422424.0
2022-03-25 17:00:00	SPY	ETF	452.61	452.69	452.5	452.6	135700.0
2022-03-25 18:00:00	SPY	ETF	452.56	452.8	452.56	452.75	23202.0
2022-03-25 19:00:00	SPY	ETF	452.8	453.01	452.8	452.9	40596.0
2022-03-25 04:00:00	QQQ	ETF	360.1	360.1	357.94	358.68	184752.0
2022-03-25 05:00:00	QQQ	ETF	358.78	359.62	358.24	359.45	56674.0
2022-03-25 06:00:00	QQQ	ETF	359.56	360.37	359.41	360.3	73871.0
2022-03-25 07:00:00	QQQ	ETF	360.28	361.4	359.94	361.11	290876.0
2022-03-25 08:00:00	QQQ	ETF	360.31	361.3804	357.9896	360.76	363153.0
2022-03-25 09:00:00	QQQ	ETF	360.75	360.75	358.2607	358.55	6328198.0
2022-03-25 10:00:00	QQQ	ETF	358.55	360.67	357.9004	359.2017	7384279.0
2022-03-25 11:00:00	QQQ	ETF	359.22	359.47	354.9438	355.7138	8998227.0
2022-03-25 12:00:00	QQQ	ETF	355.76	357.28	355.22	356.71	4715725.0
2022-03-25 13:00:00	QQQ	ETF	356.7	358.46	356.15	358.4189	3973241.0
2022-03-25 14:00:00	QQQ	ETF	358.43	359.2	358.13	358.9707	3984113.0
2022-03-25 15:00:00	QQQ	ETF	358.99	359.47	356.27	359.36	8198213.0
2022-03-25 16:00:00	QQQ	ETF	359.36	359.42	359.0	359.24	749204.0
2022-03-25 17:00:00	QQQ	ETF	359.251	359.35	359.12	359.16	146759.0
2022-03-25 18:00:00	QQQ	ETF	359.16	359.48	359.16	359.48	18311.0
2022-03-25 19:00:00	QQQ	ETF	359.49	359.55	359.4	359.5	33743.0
2022-03-25 04:00:00	IWM	ETF	205.6	206.02	205.24	205.61	13819.0
2022-03-25 05:00:00	IWM	ETF	205.63	205.86	205.27	205.83	7592.0
2022-03-25 06:00:00	IWM	ETF	205.8	206.3	205.77	206.21	5944.0
2022-03-25 07:00:00	IWM	ETF	206.29	206.75	206.15	206.65	49130.0
2022-03-25 08:00:00	IWM	ETF	206.17	206.69	206.17	206.36	138264.0
2022-03-25 09:00:00	IWM	ETF	206.31	206.46	205.075	205.34	1730100.0
2022-03-25 10:00:00	IWM	ETF	205.36	206.59	205.27	206.55	2090334.0
2022-03-25 11:00:00	IWM	ETF	206.55	206.62	204.44	205.02	1918160.0
2022-03-25 12:00:00	IWM	ETF	205.03	205.72	204.85	205.35	1346030.0
2022-03-25 13:00:00	IWM	ETF	205.35	205.82	204.775	205.81	1624901.0
2022-03-25 14:00:00	IWM	ETF	205.835	206.3	205.72	206.08	1253782.0
2022-03-25 15:00:00	IWM	ETF	206.07	206.24	204.891	206.15	3553966.0
2022-03-25 16:00:00	IWM	ETF	206.12	206.18	205.96	206.17	544845.0
2022-03-25 17:00:00	IWM	ETF	206.15	206.23	206.05	206.23	12394.0
2022-03-25 18:00:00	IWM	ETF	206.12	206.38	206.12	206.37	3647.0
2022-03-25 19:00:00	IWM	ETF	206.27	206.75	206.0	206.0	8685.0
2022-03-25 04:00:00	DIA	ETF	346.46	346.46	346.46	346.46	100.0
2022-03-25 05:00:00	DIA	ETF	346.91	347.21	346.57	347.21	1300.0

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

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