PREVIEW / etf_1hour / 2022-12-29

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-12-29.parquet
  size:    481 KB
  rows:    17,361

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-29 04:00:00	SPY	ETF	377.09	378.46	377.03	378.37	50505.0
2022-12-29 05:00:00	SPY	ETF	378.3	378.48	378.03	378.48	40443.0
2022-12-29 06:00:00	SPY	ETF	378.5	378.88	378.38	378.58	51001.0
2022-12-29 07:00:00	SPY	ETF	378.59	378.76	378.2	378.55	99441.0
2022-12-29 08:00:00	SPY	ETF	378.59	380.16	377.05	379.7	572938.0
2022-12-29 09:00:00	SPY	ETF	379.66	381.8099	379.08	381.6	6286563.0
2022-12-29 10:00:00	SPY	ETF	381.6	383.26	381.3401	383.1101	10128971.0
2022-12-29 11:00:00	SPY	ETF	383.12	384.24	382.275	383.89	5964410.0
2022-12-29 12:00:00	SPY	ETF	383.89	384.14	383.26	383.8	4122489.0
2022-12-29 13:00:00	SPY	ETF	383.81	383.98	383.19	383.88	3131985.0
2022-12-29 14:00:00	SPY	ETF	383.87	384.35	383.4305	383.55	3592725.0
2022-12-29 15:00:00	SPY	ETF	383.52	384.04	383.15	383.39	10345570.0
2022-12-29 16:00:00	SPY	ETF	383.39	383.55	382.99	383.08	4884132.0
2022-12-29 17:00:00	SPY	ETF	383.05	383.1	382.94	383.1	90778.0
2022-12-29 18:00:00	SPY	ETF	383.1	383.18	382.7	382.76	64632.0
2022-12-29 19:00:00	SPY	ETF	382.79	382.83	382.59	382.73	37670.0
2022-12-29 04:00:00	QQQ	ETF	260.91	261.92	260.91	261.84	34951.0
2022-12-29 05:00:00	QQQ	ETF	261.8	262.04	261.64	261.97	44426.0
2022-12-29 06:00:00	QQQ	ETF	262.03	262.38	261.78	261.99	42022.0
2022-12-29 07:00:00	QQQ	ETF	261.95	262.12	261.65	261.81	111011.0
2022-12-29 08:00:00	QQQ	ETF	262.06	263.37	260.295	263.03	750997.0
2022-12-29 09:00:00	QQQ	ETF	263.07	265.14	262.25	264.7883	6072457.0
2022-12-29 10:00:00	QQQ	ETF	264.8	266.58	264.34	266.47	5489964.0
2022-12-29 11:00:00	QQQ	ETF	266.48	267.405	265.77	267.1	3934538.0
2022-12-29 12:00:00	QQQ	ETF	267.1	267.24	266.15	266.575	3002379.0
2022-12-29 13:00:00	QQQ	ETF	266.575	266.88	265.92	266.8	2370549.0
2022-12-29 14:00:00	QQQ	ETF	266.79	267.22	266.3187	266.401	2146431.0
2022-12-29 15:00:00	QQQ	ETF	266.4	267.38	266.37	266.51	5621972.0
2022-12-29 16:00:00	QQQ	ETF	266.51	266.71	266.39	266.44	1400023.0
2022-12-29 17:00:00	QQQ	ETF	266.42	266.71	266.42	266.7	50489.0
2022-12-29 18:00:00	QQQ	ETF	266.65	266.65	266.25	266.32	88419.0
2022-12-29 19:00:00	QQQ	ETF	266.35	266.35	266.1	266.14	49874.0
2022-12-29 04:00:00	IWM	ETF	171.03	171.41	171.03	171.34	20978.0
2022-12-29 05:00:00	IWM	ETF	171.21	171.28	171.21	171.28	2325.0
2022-12-29 06:00:00	IWM	ETF	171.41	171.57	171.26	171.44	30577.0
2022-12-29 07:00:00	IWM	ETF	171.38	171.49	171.34	171.39	14837.0
2022-12-29 08:00:00	IWM	ETF	171.44	172.28	171.3501	172.1	53099.0
2022-12-29 09:00:00	IWM	ETF	171.96	173.365	171.4	173.33	2500105.0
2022-12-29 10:00:00	IWM	ETF	173.33	174.5	173.27	174.2	2888235.0
2022-12-29 11:00:00	IWM	ETF	174.2	175.23	173.835	175.13	1977306.0
2022-12-29 12:00:00	IWM	ETF	175.14	175.25	174.785	175.14	3535153.0
2022-12-29 13:00:00	IWM	ETF	175.135	175.22	174.8	175.01	1202337.0
2022-12-29 14:00:00	IWM	ETF	175.0	175.21	174.61	174.62	1046842.0
2022-12-29 15:00:00	IWM	ETF	174.61	175.15	174.51	174.86	2330190.0
2022-12-29 16:00:00	IWM	ETF	174.85	174.91	174.5	174.55	849615.0
2022-12-29 17:00:00	IWM	ETF	174.66	174.66	174.52	174.63	2017.0
2022-12-29 18:00:00	IWM	ETF	174.57	174.57	174.3	174.33	21200.0
2022-12-29 19:00:00	IWM	ETF	174.37	174.42	174.3	174.4	27632.0
2022-12-29 04:00:00	DIA	ETF	328.63	329.43	328.63	329.43	4800.0
2022-12-29 05:00:00	DIA	ETF	329.31	329.43	329.31	329.43	425.0

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

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