PREVIEW / etf_1hour / 2023-01-04

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-01-04.parquet
  size:    467 KB
  rows:    17,232

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
2023-01-04 04:00:00	SPY	ETF	382.5	382.62	382.0	382.38	27827.0
2023-01-04 05:00:00	SPY	ETF	382.38	382.87	381.87	382.08	11210.0
2023-01-04 06:00:00	SPY	ETF	382.3	382.81	382.26	382.38	20825.0
2023-01-04 07:00:00	SPY	ETF	382.28	382.39	381.4	381.84	393478.0
2023-01-04 08:00:00	SPY	ETF	382.17	383.28	381.3	382.92	475726.0
2023-01-04 09:00:00	SPY	ETF	382.97	384.17	381.9	383.23	6015160.0
2023-01-04 10:00:00	SPY	ETF	383.16	384.27	380.0	382.975	9704209.0
2023-01-04 11:00:00	SPY	ETF	382.97	385.88	382.311	385.48	8154077.0
2023-01-04 12:00:00	SPY	ETF	385.5	385.74	384.33	384.34	4676684.0
2023-01-04 13:00:00	SPY	ETF	384.35	385.33	383.65	384.14	5067698.0
2023-01-04 14:00:00	SPY	ETF	384.26	385.56	381.14	383.2301	12871633.0
2023-01-04 15:00:00	SPY	ETF	383.26	384.08	381.2163	383.74	13400112.0
2023-01-04 16:00:00	SPY	ETF	383.73	383.95	383.15	383.42	5467653.0
2023-01-04 17:00:00	SPY	ETF	383.31	383.88	383.29	383.61	164602.0
2023-01-04 18:00:00	SPY	ETF	383.45	383.87	383.38	383.63	109666.0
2023-01-04 19:00:00	SPY	ETF	383.55	383.75	383.34	383.37	66549.0
2023-01-04 04:00:00	QQQ	ETF	266.33	266.43	265.07	265.97	57005.0
2023-01-04 05:00:00	QQQ	ETF	266.05	266.43	265.24	265.69	51042.0
2023-01-04 06:00:00	QQQ	ETF	265.77	266.55	265.77	266.15	30486.0
2023-01-04 07:00:00	QQQ	ETF	266.1	266.15	265.19	265.62	291445.0
2023-01-04 08:00:00	QQQ	ETF	266.1275	267.01	264.678	266.38	564154.0
2023-01-04 09:00:00	QQQ	ETF	266.45	266.92	264.72	265.39	4865956.0
2023-01-04 10:00:00	QQQ	ETF	265.33	266.26	262.53	265.0	7301377.0
2023-01-04 11:00:00	QQQ	ETF	264.99	267.45	264.41	266.9499	4649384.0
2023-01-04 12:00:00	QQQ	ETF	267.01	267.25	265.89	265.905	2400348.0
2023-01-04 13:00:00	QQQ	ETF	265.9	266.92	265.245	266.18	2770529.0
2023-01-04 14:00:00	QQQ	ETF	266.17	267.35	263.45	265.7	7743970.0
2023-01-04 15:00:00	QQQ	ETF	265.7046	266.38	263.6	265.76	5848320.0
2023-01-04 16:00:00	QQQ	ETF	265.76	265.95	265.2	265.74	1392980.0
2023-01-04 17:00:00	QQQ	ETF	265.43	265.99	265.28	265.71	106478.0
2023-01-04 18:00:00	QQQ	ETF	265.71	265.95	265.53	265.75	207622.0
2023-01-04 19:00:00	QQQ	ETF	265.72	265.78	265.39	265.4	96222.0
2023-01-04 04:00:00	IWM	ETF	174.07	174.4	173.94	174.35	42607.0
2023-01-04 05:00:00	IWM	ETF	174.35	174.58	174.0	174.21	32669.0
2023-01-04 06:00:00	IWM	ETF	174.24	174.59	174.24	174.45	9176.0
2023-01-04 07:00:00	IWM	ETF	174.18	174.26	173.92	174.1	105655.0
2023-01-04 08:00:00	IWM	ETF	174.2	175.0	173.4	174.67	198531.0
2023-01-04 09:00:00	IWM	ETF	174.72	176.29	174.38	175.6	3079193.0
2023-01-04 10:00:00	IWM	ETF	175.58	176.02	174.28	175.495	3059962.0
2023-01-04 11:00:00	IWM	ETF	175.5	176.67	175.27	176.565	1690503.0
2023-01-04 12:00:00	IWM	ETF	176.58	176.665	176.01	176.05	1058052.0
2023-01-04 13:00:00	IWM	ETF	176.05	176.585	175.71	176.0	1190450.0
2023-01-04 14:00:00	IWM	ETF	175.82	176.65	174.68	175.8313	2616928.0
2023-01-04 15:00:00	IWM	ETF	175.85	176.18	174.68	175.57	3194197.0
2023-01-04 16:00:00	IWM	ETF	175.56	175.72	175.42	175.57	649182.0
2023-01-04 17:00:00	IWM	ETF	175.76	175.76	175.46	175.5	22872.0
2023-01-04 18:00:00	IWM	ETF	175.51	175.799	175.45	175.6	70165.0
2023-01-04 19:00:00	IWM	ETF	175.59	175.69	175.49	175.56	43147.0
2023-01-04 04:00:00	DIA	ETF	331.97	332.27	331.97	332.27	939.0
2023-01-04 05:00:00	DIA	ETF	332.46	332.46	332.46	332.46	100.0

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

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