PREVIEW / etf_1hour / 2022-11-04

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-11-04.parquet
  size:    467 KB
  rows:    17,266

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-11-04 04:00:00	SPY	ETF	371.76	372.96	371.5	372.96	44394.0
2022-11-04 05:00:00	SPY	ETF	373.0	374.1	372.81	373.63	74092.0
2022-11-04 06:00:00	SPY	ETF	373.47	374.44	373.27	374.17	73195.0
2022-11-04 07:00:00	SPY	ETF	374.17	374.95	373.56	374.22	393811.0
2022-11-04 08:00:00	SPY	ETF	373.92	375.77	368.99	375.64	2906463.0
2022-11-04 09:00:00	SPY	ETF	375.6	377.37	372.225	375.1	9632428.0
2022-11-04 10:00:00	SPY	ETF	375.11	378.87	374.7	376.8	11010800.0
2022-11-04 11:00:00	SPY	ETF	376.83	377.43	370.8005	370.97	9216622.0
2022-11-04 12:00:00	SPY	ETF	370.98	373.01	370.07	371.2797	8704296.0
2022-11-04 13:00:00	SPY	ETF	371.29	372.08	370.14	370.76	5693276.0
2022-11-04 14:00:00	SPY	ETF	370.77	374.2	370.0	373.96	7688878.0
2022-11-04 15:00:00	SPY	ETF	373.97	376.47	373.6	376.34	16282380.0
2022-11-04 16:00:00	SPY	ETF	376.34	376.82	375.42	375.61	9164908.0
2022-11-04 17:00:00	SPY	ETF	375.63	376.35	375.5	375.9	128346.0
2022-11-04 18:00:00	SPY	ETF	375.81	376.15	375.58	375.88	27955.0
2022-11-04 19:00:00	SPY	ETF	375.87	376.0	375.67	376.0	19798.0
2022-11-04 04:00:00	QQQ	ETF	261.21	262.1	261.2	262.1	72314.0
2022-11-04 05:00:00	QQQ	ETF	262.14	263.04	262.05	262.52	78153.0
2022-11-04 06:00:00	QQQ	ETF	262.5	263.04	262.25	262.83	99340.0
2022-11-04 07:00:00	QQQ	ETF	262.82	263.45	262.32	262.74	458855.0
2022-11-04 08:00:00	QQQ	ETF	262.61	264.23	258.51	264.06	3094007.0
2022-11-04 09:00:00	QQQ	ETF	264.06	266.39	260.57	263.46	11031452.0
2022-11-04 10:00:00	QQQ	ETF	263.48	266.61	262.5615	264.55	10266299.0
2022-11-04 11:00:00	QQQ	ETF	264.56	264.95	259.98	260.08	7942714.0
2022-11-04 12:00:00	QQQ	ETF	260.09	262.28	259.44	260.3101	6990044.0
2022-11-04 13:00:00	QQQ	ETF	260.32	260.89	259.2	259.68	4531157.0
2022-11-04 14:00:00	QQQ	ETF	259.68	262.8	259.08	262.58	5060980.0
2022-11-04 15:00:00	QQQ	ETF	262.59	264.73	262.23	264.68	10061021.0
2022-11-04 16:00:00	QQQ	ETF	264.68	265.2	264.0	264.15	1710012.0
2022-11-04 17:00:00	QQQ	ETF	264.23	264.68	264.13	264.68	565478.0
2022-11-04 18:00:00	QQQ	ETF	264.35	264.53	264.2	264.43	24928.0
2022-11-04 19:00:00	QQQ	ETF	264.49	264.66	264.3	264.45	18883.0
2022-11-04 04:00:00	IWM	ETF	177.01	177.52	177.01	177.52	21993.0
2022-11-04 05:00:00	IWM	ETF	177.52	178.02	177.43	177.88	22567.0
2022-11-04 06:00:00	IWM	ETF	177.8	178.22	177.59	178.11	20085.0
2022-11-04 07:00:00	IWM	ETF	178.02	178.5	177.71	178.06	140659.0
2022-11-04 08:00:00	IWM	ETF	177.89	178.66	175.8	178.64	233636.0
2022-11-04 09:00:00	IWM	ETF	178.6	179.19	176.85	177.99	3702763.0
2022-11-04 10:00:00	IWM	ETF	177.99	179.94	177.24	179.07	3246745.0
2022-11-04 11:00:00	IWM	ETF	179.07	179.4399	175.96	176.0	2264189.0
2022-11-04 12:00:00	IWM	ETF	176.005	176.82	175.47	176.23	2242630.0
2022-11-04 13:00:00	IWM	ETF	176.15	176.6	175.58	175.95	1170237.0
2022-11-04 14:00:00	IWM	ETF	175.93	177.61	175.47	177.435	1798170.0
2022-11-04 15:00:00	IWM	ETF	177.46	178.74	177.32	178.72	3800409.0
2022-11-04 16:00:00	IWM	ETF	178.68	178.91	178.26	178.5	912718.0
2022-11-04 17:00:00	IWM	ETF	178.31	178.68	178.18	178.68	206619.0
2022-11-04 18:00:00	IWM	ETF	178.32	178.37	178.16	178.36	6158.0
2022-11-04 19:00:00	IWM	ETF	178.35	178.45	178.3	178.42	13779.0
2022-11-04 04:00:00	DIA	ETF	320.74	321.2	320.74	321.2	2016.0
2022-11-04 05:00:00	DIA	ETF	321.81	321.82	321.49	321.7	4904.0

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

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