PREVIEW / etf_1hour / 2022-01-21

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-01-21.parquet
  size:    480 KB
  rows:    17,557

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-21 04:00:00	SPY	ETF	445.51	446.73	445.0	446.61	86065.0
2022-01-21 05:00:00	SPY	ETF	446.59	447.06	446.09	446.85	82626.0
2022-01-21 06:00:00	SPY	ETF	446.78	446.78	444.44	445.49	135258.0
2022-01-21 07:00:00	SPY	ETF	445.39	445.58	443.75	444.36	377415.0
2022-01-21 08:00:00	SPY	ETF	444.88	447.115	443.87	444.58	734184.0
2022-01-21 09:00:00	SPY	ETF	444.6	446.67	443.14	443.63	16359897.0
2022-01-21 10:00:00	SPY	ETF	443.64	447.14	440.66	446.09	27348778.0
2022-01-21 11:00:00	SPY	ETF	446.0899	448.06	443.54	444.5	13588551.0
2022-01-21 12:00:00	SPY	ETF	444.5	445.02	442.1	442.86	11224464.0
2022-01-21 13:00:00	SPY	ETF	442.85	444.23	441.49	442.1805	10504972.0
2022-01-21 14:00:00	SPY	ETF	442.17	443.3	439.85	439.95	11696630.0
2022-01-21 15:00:00	SPY	ETF	439.96	441.26	437.97	438.02	35644455.0
2022-01-21 16:00:00	SPY	ETF	438.02	438.7	437.61	437.61	10005412.0
2022-01-21 17:00:00	SPY	ETF	437.68	437.98	436.54	436.83	432866.0
2022-01-21 18:00:00	SPY	ETF	436.83	437.98	436.51	436.72	250181.0
2022-01-21 19:00:00	SPY	ETF	436.72	436.87	436.45	436.55	72960.0
2022-01-21 04:00:00	QQQ	ETF	361.71	362.0	359.04	360.34	154818.0
2022-01-21 05:00:00	QQQ	ETF	360.32	361.09	359.97	360.73	76009.0
2022-01-21 06:00:00	QQQ	ETF	360.59	360.59	358.35	359.55	255251.0
2022-01-21 07:00:00	QQQ	ETF	359.47	359.53	357.88	358.5	273019.0
2022-01-21 08:00:00	QQQ	ETF	358.08	361.991	356.95	358.7	842843.0
2022-01-21 09:00:00	QQQ	ETF	358.71	361.24	356.66	357.14	13766285.0
2022-01-21 10:00:00	QQQ	ETF	357.13	361.19	354.24	359.9	22649664.0
2022-01-21 11:00:00	QQQ	ETF	359.89	362.18	357.18	358.27	13407287.0
2022-01-21 12:00:00	QQQ	ETF	358.26	359.375	356.03	356.97	11007006.0
2022-01-21 13:00:00	QQQ	ETF	356.94	358.36	355.3801	356.1	9282909.0
2022-01-21 14:00:00	QQQ	ETF	356.13	357.285	353.58	353.7199	10354609.0
2022-01-21 15:00:00	QQQ	ETF	353.71	355.29	351.41	351.44	20474301.0
2022-01-21 16:00:00	QQQ	ETF	351.4	361.5675	351.25	351.25	3297064.0
2022-01-21 17:00:00	QQQ	ETF	351.39	351.58	350.87	351.1	277901.0
2022-01-21 18:00:00	QQQ	ETF	351.1	351.69	350.73	350.76	409656.0
2022-01-21 19:00:00	QQQ	ETF	350.76	350.8	350.36	350.45	63738.0
2022-01-21 04:00:00	IWM	ETF	201.49	201.67	200.7	201.51	61084.0
2022-01-21 05:00:00	IWM	ETF	201.26	201.8	201.26	201.59	69390.0
2022-01-21 06:00:00	IWM	ETF	201.35	201.35	200.21	200.63	118464.0
2022-01-21 07:00:00	IWM	ETF	200.6	200.64	199.76	200.09	242361.0
2022-01-21 08:00:00	IWM	ETF	200.39	201.5	199.71	199.91	254547.0
2022-01-21 09:00:00	IWM	ETF	199.94	200.99	198.73	199.75	9925247.0
2022-01-21 10:00:00	IWM	ETF	199.73	202.79	197.6	201.88	16263136.0
2022-01-21 11:00:00	IWM	ETF	201.89	203.02	200.13	200.5838	7209586.0
2022-01-21 12:00:00	IWM	ETF	200.58	201.06	199.13	199.65	5230191.0
2022-01-21 13:00:00	IWM	ETF	199.63	200.36	198.835	199.48	4186377.0
2022-01-21 14:00:00	IWM	ETF	199.5	200.21	198.21	198.25	4022004.0
2022-01-21 15:00:00	IWM	ETF	198.26	199.305	197.02	197.04	11904238.0
2022-01-21 16:00:00	IWM	ETF	197.01	197.43	196.85	197.1	2195073.0
2022-01-21 17:00:00	IWM	ETF	197.01	197.1	196.4	196.45	62276.0
2022-01-21 18:00:00	IWM	ETF	196.45	197.0	196.36	196.79	1083194.0
2022-01-21 19:00:00	IWM	ETF	196.71	196.79	196.45	196.5	23824.0
2022-01-21 04:00:00	DIA	ETF	347.53	347.73	346.94	347.7	10594.0
2022-01-21 05:00:00	DIA	ETF	347.69	347.8	347.62	347.63	3083.0

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

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