PREVIEW / etf_1hour / 2022-01-05

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-01-05.parquet
  size:    467 KB
  rows:    16,745

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-05 04:00:00	SPY	ETF	477.06	477.74	476.87	477.52	20827.0
2022-01-05 05:00:00	SPY	ETF	477.6	477.94	477.32	477.51	33642.0
2022-01-05 06:00:00	SPY	ETF	477.3	477.37	477.0	477.3	40082.0
2022-01-05 07:00:00	SPY	ETF	477.29	477.49	476.85	477.05	53577.0
2022-01-05 08:00:00	SPY	ETF	477.09	477.908	476.0	477.39	341466.0
2022-01-05 09:00:00	SPY	ETF	477.41	477.66	476.13	477.21	5669166.0
2022-01-05 10:00:00	SPY	ETF	477.22	477.98	476.75	477.3101	5208967.0
2022-01-05 11:00:00	SPY	ETF	477.305	477.395	476.3	476.56	3963453.0
2022-01-05 12:00:00	SPY	ETF	476.542	477.25	475.87	475.95	4958803.0
2022-01-05 13:00:00	SPY	ETF	475.9427	476.14	475.305	475.85	4526432.0
2022-01-05 14:00:00	SPY	ETF	475.84	476.91	471.11	471.6901	16610829.0
2022-01-05 15:00:00	SPY	ETF	471.7	471.7	468.2801	468.38	25373977.0
2022-01-05 16:00:00	SPY	ETF	468.38	469.08	468.12	468.4	4531728.0
2022-01-05 17:00:00	SPY	ETF	468.34	468.48	468.28	468.35	2896229.0
2022-01-05 18:00:00	SPY	ETF	468.35	469.08	467.41	469.01	275083.0
2022-01-05 19:00:00	SPY	ETF	468.98	469.43	468.4	468.95	180735.0
2022-01-05 04:00:00	QQQ	ETF	395.28	395.8	395.17	395.43	21196.0
2022-01-05 05:00:00	QQQ	ETF	395.61	396.15	395.34	395.57	23307.0
2022-01-05 06:00:00	QQQ	ETF	395.39	395.4	394.74	395.16	28593.0
2022-01-05 07:00:00	QQQ	ETF	395.22	395.45	394.64	394.97	84239.0
2022-01-05 08:00:00	QQQ	ETF	395.1601	396.767	394.25	395.3	367860.0
2022-01-05 09:00:00	QQQ	ETF	395.28	395.37	392.36	395.07	7232976.0
2022-01-05 10:00:00	QQQ	ETF	395.07	395.89	392.88	394.0951	6575119.0
2022-01-05 11:00:00	QQQ	ETF	394.09	394.44	392.76	393.17	3768207.0
2022-01-05 12:00:00	QQQ	ETF	393.13	393.56	391.03	391.16	5030858.0
2022-01-05 13:00:00	QQQ	ETF	391.155	392.0101	390.53	391.48	4054946.0
2022-01-05 14:00:00	QQQ	ETF	391.47	393.04	386.94	387.45	15364557.0
2022-01-05 15:00:00	QQQ	ETF	387.46	387.49	384.03	384.15	14707601.0
2022-01-05 16:00:00	QQQ	ETF	384.17	385.3383	382.8714	383.95	1990315.0
2022-01-05 17:00:00	QQQ	ETF	383.94	384.29	383.85	384.21	349172.0
2022-01-05 18:00:00	QQQ	ETF	384.15	384.77	383.0	384.74	372897.0
2022-01-05 19:00:00	QQQ	ETF	384.72	385.08	383.99	384.66	227560.0
2022-01-05 04:00:00	IWM	ETF	224.64	225.12	224.41	224.89	36383.0
2022-01-05 05:00:00	IWM	ETF	225.06	225.14	224.78	224.9	15377.0
2022-01-05 06:00:00	IWM	ETF	224.9	224.97	224.68	224.82	10850.0
2022-01-05 07:00:00	IWM	ETF	224.75	225.03	224.57	224.72	18312.0
2022-01-05 08:00:00	IWM	ETF	224.75	225.14	224.1	225.03	224950.0
2022-01-05 09:00:00	IWM	ETF	225.06	225.91	224.58	225.23	3854718.0
2022-01-05 10:00:00	IWM	ETF	225.24	225.6	224.43	224.52	3780625.0
2022-01-05 11:00:00	IWM	ETF	224.51	224.62	223.73	223.86	1993196.0
2022-01-05 12:00:00	IWM	ETF	223.86	224.16	223.04	223.13	1981479.0
2022-01-05 13:00:00	IWM	ETF	223.12	223.15	222.36	222.93	1962017.0
2022-01-05 14:00:00	IWM	ETF	222.93	223.47	219.48	219.8	5935294.0
2022-01-05 15:00:00	IWM	ETF	219.81	219.81	217.32	217.36	9486691.0
2022-01-05 16:00:00	IWM	ETF	217.36	221.3275	217.16	217.32	2880979.0
2022-01-05 17:00:00	IWM	ETF	217.14	217.36	217.13	217.21	261247.0
2022-01-05 18:00:00	IWM	ETF	217.35	217.83	216.89	217.81	77982.0
2022-01-05 19:00:00	IWM	ETF	217.78	218.08	217.46	217.8	42386.0
2022-01-05 04:00:00	DIA	ETF	367.77	368.27	367.77	368.13	4765.0
2022-01-05 05:00:00	DIA	ETF	368.36	368.42	368.04	368.04	6086.0

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

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