PREVIEW / etf_1hour / 2022-11-09

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-11-09.parquet
  size:    459 KB
  rows:    16,777

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-09 04:00:00	SPY	ETF	382.12	382.23	380.07	380.2	131462.0
2022-11-09 05:00:00	SPY	ETF	380.37	381.34	379.75	381.15	51953.0
2022-11-09 06:00:00	SPY	ETF	381.28	382.02	381.11	381.46	76062.0
2022-11-09 07:00:00	SPY	ETF	381.53	381.86	380.51	381.76	281081.0
2022-11-09 08:00:00	SPY	ETF	381.18	382.44	379.64	379.97	854417.0
2022-11-09 09:00:00	SPY	ETF	379.91	380.66	378.15	378.715	6830221.0
2022-11-09 10:00:00	SPY	ETF	378.71	381.14	377.5	378.2489	9291319.0
2022-11-09 11:00:00	SPY	ETF	378.25	380.23	378.1968	379.068	5117065.0
2022-11-09 12:00:00	SPY	ETF	379.05	379.2999	377.89	378.5299	3918568.0
2022-11-09 13:00:00	SPY	ETF	378.52	378.79	375.46	376.14	7263644.0
2022-11-09 14:00:00	SPY	ETF	376.14	376.8399	374.56	374.8395	7252680.0
2022-11-09 15:00:00	SPY	ETF	374.82	376.19	373.61	374.15	14582424.0
2022-11-09 16:00:00	SPY	ETF	374.15	374.56	373.95	374.2	4980537.0
2022-11-09 17:00:00	SPY	ETF	374.2999	374.4	374.04	374.17	56220.0
2022-11-09 18:00:00	SPY	ETF	374.17	374.59	374.05	374.31	58752.0
2022-11-09 19:00:00	SPY	ETF	374.29	375.01	374.26	374.81	124411.0
2022-11-09 04:00:00	QQQ	ETF	270.05	270.05	268.22	268.43	207214.0
2022-11-09 05:00:00	QQQ	ETF	268.52	269.21	267.88	269.14	91871.0
2022-11-09 06:00:00	QQQ	ETF	269.06	269.86	269.06	269.48	61737.0
2022-11-09 07:00:00	QQQ	ETF	269.44	269.7	268.48	269.58	211524.0
2022-11-09 08:00:00	QQQ	ETF	269.416	270.49	267.59	267.86	845045.0
2022-11-09 09:00:00	QQQ	ETF	267.8	268.59	266.42	266.795	6853762.0
2022-11-09 10:00:00	QQQ	ETF	266.78	268.56	265.61	266.21	8000169.0
2022-11-09 11:00:00	QQQ	ETF	266.22	268.0601	266.15	266.9199	4322272.0
2022-11-09 12:00:00	QQQ	ETF	266.91	267.145	265.91	266.35	3185872.0
2022-11-09 13:00:00	QQQ	ETF	266.35	266.74	263.87	264.4	5509392.0
2022-11-09 14:00:00	QQQ	ETF	264.4	265.1	263.38	263.605	4471259.0
2022-11-09 15:00:00	QQQ	ETF	263.6	264.77	263.03	263.27	9588949.0
2022-11-09 16:00:00	QQQ	ETF	263.29	263.7877	263.2	263.52	2101313.0
2022-11-09 17:00:00	QQQ	ETF	263.61	263.61	263.08	263.34	407544.0
2022-11-09 18:00:00	QQQ	ETF	263.35	263.81	263.35	263.57	59257.0
2022-11-09 19:00:00	QQQ	ETF	263.5	264.32	263.5	264.18	102922.0
2022-11-09 04:00:00	IWM	ETF	179.59	179.59	178.5	178.5	25650.0
2022-11-09 05:00:00	IWM	ETF	178.61	179.0	178.35	178.95	6752.0
2022-11-09 06:00:00	IWM	ETF	178.99	179.29	178.88	178.9	210470.0
2022-11-09 07:00:00	IWM	ETF	178.9	179.22	178.49	179.17	72027.0
2022-11-09 08:00:00	IWM	ETF	178.77	179.34	178.02	178.16	277671.0
2022-11-09 09:00:00	IWM	ETF	178.12	178.53	176.82	177.19	2964048.0
2022-11-09 10:00:00	IWM	ETF	177.17	178.67	176.61	176.925	2849452.0
2022-11-09 11:00:00	IWM	ETF	176.95	178.18	176.92	177.67	1259427.0
2022-11-09 12:00:00	IWM	ETF	177.67	177.76	176.79	177.19	1131681.0
2022-11-09 13:00:00	IWM	ETF	177.21	177.365	175.61	175.9	2015870.0
2022-11-09 14:00:00	IWM	ETF	175.89	176.205	174.94	175.01	1637536.0
2022-11-09 15:00:00	IWM	ETF	175.0	175.62	174.275	174.66	4695451.0
2022-11-09 16:00:00	IWM	ETF	174.63	175.01	174.63	174.82	1877723.0
2022-11-09 17:00:00	IWM	ETF	174.67	174.91	174.63	174.77	295618.0
2022-11-09 18:00:00	IWM	ETF	174.78	175.05	174.71	174.8	16160.0
2022-11-09 19:00:00	IWM	ETF	174.73	175.12	174.73	175.02	50636.0
2022-11-09 04:00:00	DIA	ETF	331.65	331.7	330.22	330.22	27339.0
2022-11-09 05:00:00	DIA	ETF	330.03	330.79	329.85	330.79	3640.0

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

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