PREVIEW / etf_1hour / 2022-12-30

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-12-30.parquet
  size:    490 KB
  rows:    17,871

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-12-30 04:00:00	SPY	ETF	381.12	381.94	381.1	381.73	29386.0
2022-12-30 05:00:00	SPY	ETF	381.85	382.54	381.7	382.12	26799.0
2022-12-30 06:00:00	SPY	ETF	382.36	382.54	381.76	381.8	17794.0
2022-12-30 07:00:00	SPY	ETF	381.8	382.0	380.98	381.09	213384.0
2022-12-30 08:00:00	SPY	ETF	381.77	383.12	380.56	381.0	418099.0
2022-12-30 09:00:00	SPY	ETF	380.9996	381.62	379.02	380.4301	5159320.0
2022-12-30 10:00:00	SPY	ETF	380.46	381.55	379.57	380.37	6371010.0
2022-12-30 11:00:00	SPY	ETF	380.37	380.86	379.625	380.74	3439192.0
2022-12-30 12:00:00	SPY	ETF	380.74	381.08	380.375	380.96	2521052.0
2022-12-30 13:00:00	SPY	ETF	380.99	381.0	378.43	379.32	6144174.0
2022-12-30 14:00:00	SPY	ETF	379.32	379.52	378.59	379.085	5644537.0
2022-12-30 15:00:00	SPY	ETF	379.09	382.58	379.035	382.44	21952255.0
2022-12-30 16:00:00	SPY	ETF	382.44	383.13	382.31	383.04	6815602.0
2022-12-30 17:00:00	SPY	ETF	383.04	383.15	382.95	383.1	102637.0
2022-12-30 18:00:00	SPY	ETF	383.1	383.14	382.99	383.04	21938.0
2022-12-30 19:00:00	SPY	ETF	383.09	383.29	382.72	383.23	28597.0
2022-12-30 04:00:00	QQQ	ETF	264.56	265.53	264.4	265.53	49661.0
2022-12-30 05:00:00	QQQ	ETF	265.55	266.0	265.36	265.83	17630.0
2022-12-30 06:00:00	QQQ	ETF	265.8	265.8	265.34	265.35	28077.0
2022-12-30 07:00:00	QQQ	ETF	265.41	265.47	263.98	264.07	198105.0
2022-12-30 08:00:00	QQQ	ETF	263.93	266.35	263.4	263.92	426500.0
2022-12-30 09:00:00	QQQ	ETF	263.9	264.49	262.29	263.7039	4795176.0
2022-12-30 10:00:00	QQQ	ETF	263.71	265.04	262.93	264.06	4314878.0
2022-12-30 11:00:00	QQQ	ETF	264.07	264.56	263.3	264.43	2834469.0
2022-12-30 12:00:00	QQQ	ETF	264.45	264.6854	264.03	264.62	1830278.0
2022-12-30 13:00:00	QQQ	ETF	264.65	264.67	262.7116	263.485	2708770.0
2022-12-30 14:00:00	QQQ	ETF	263.48	263.64	262.91	263.45	2164322.0
2022-12-30 15:00:00	QQQ	ETF	263.45	266.41	263.4	266.32	8399378.0
2022-12-30 16:00:00	QQQ	ETF	266.34	267.0	266.14	266.72	1486320.0
2022-12-30 17:00:00	QQQ	ETF	266.71	266.85	266.53	266.84	61303.0
2022-12-30 18:00:00	QQQ	ETF	266.85	266.94	266.83	266.84	16179.0
2022-12-30 19:00:00	QQQ	ETF	266.83	268.0	266.75	267.34	36821.0
2022-12-30 04:00:00	IWM	ETF	173.58	173.87	173.55	173.79	13039.0
2022-12-30 05:00:00	IWM	ETF	173.82	174.16	173.7	173.96	6243.0
2022-12-30 06:00:00	IWM	ETF	174.08	174.08	173.85	173.86	19468.0
2022-12-30 07:00:00	IWM	ETF	173.91	173.96	173.58	173.61	17677.0
2022-12-30 08:00:00	IWM	ETF	173.71	174.0	173.32	173.49	31397.0
2022-12-30 09:00:00	IWM	ETF	173.5	174.06	172.61	173.83	2254237.0
2022-12-30 10:00:00	IWM	ETF	173.83	174.45	173.3	173.96	1618185.0
2022-12-30 11:00:00	IWM	ETF	173.955	174.32	173.515	174.095	1136250.0
2022-12-30 12:00:00	IWM	ETF	174.095	174.19	173.775	174.09	623848.0
2022-12-30 13:00:00	IWM	ETF	174.1	174.11	172.91	173.6394	1282355.0
2022-12-30 14:00:00	IWM	ETF	173.63	173.73	172.845	173.06	1615233.0
2022-12-30 15:00:00	IWM	ETF	173.06	174.7203	173.03	174.37	5756251.0
2022-12-30 16:00:00	IWM	ETF	174.37	175.01	174.31	174.98	1323308.0
2022-12-30 17:00:00	IWM	ETF	174.9	175.0	174.36	174.91	611349.0
2022-12-30 18:00:00	IWM	ETF	174.91	175.03	174.86	174.86	7939.0
2022-12-30 19:00:00	IWM	ETF	174.86	175.12	174.8	175.12	12804.0
2022-12-30 04:00:00	DIA	ETF	331.08	331.08	330.73	331.0	2200.0
2022-12-30 05:00:00	DIA	ETF	330.98	331.08	330.88	330.98	900.0

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

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