PREVIEW / etf_1hour / 2023-10-19

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-10-19.parquet
  size:    488 KB
  rows:    18,034

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-10-19 04:00:00	SPY	ETF	429.0	429.43	428.81	429.02	80067.0
2023-10-19 05:00:00	SPY	ETF	429.0	430.21	428.89	430.18	56562.0
2023-10-19 06:00:00	SPY	ETF	430.12	430.97	430.04	430.87	43827.0
2023-10-19 07:00:00	SPY	ETF	430.84	430.91	429.61	429.86	273458.0
2023-10-19 08:00:00	SPY	ETF	430.47	431.29	428.62	431.15	659969.0
2023-10-19 09:00:00	SPY	ETF	431.16	431.42	430.173	430.74	5363316.0
2023-10-19 10:00:00	SPY	ETF	430.74	431.1	428.67	428.9425	10133279.0
2023-10-19 11:00:00	SPY	ETF	428.95	430.72	428.46	430.0	7169967.0
2023-10-19 12:00:00	SPY	ETF	430.005	432.82	427.72	431.04	24439661.0
2023-10-19 13:00:00	SPY	ETF	431.06	432.39	429.01	429.47	12757459.0
2023-10-19 14:00:00	SPY	ETF	429.47	430.02	426.64	426.9504	13086496.0
2023-10-19 15:00:00	SPY	ETF	426.95	427.59	425.725	426.43	23752486.0
2023-10-19 16:00:00	SPY	ETF	426.44	431.6977	425.58	425.92	4810041.0
2023-10-19 17:00:00	SPY	ETF	425.91	425.99	425.6	425.72	80632.0
2023-10-19 18:00:00	SPY	ETF	425.74	426.0198	425.55	425.6	78698.0
2023-10-19 19:00:00	SPY	ETF	425.6	425.75	425.32	425.75	77389.0
2023-10-19 04:00:00	QQQ	ETF	362.09	362.86	362.09	362.48	60144.0
2023-10-19 05:00:00	QQQ	ETF	362.4	363.75	362.36	363.7	51034.0
2023-10-19 06:00:00	QQQ	ETF	363.7	364.36	363.55	364.2	55980.0
2023-10-19 07:00:00	QQQ	ETF	364.18	364.24	363.24	363.54	217004.0
2023-10-19 08:00:00	QQQ	ETF	363.5	364.86	361.4	364.72	550350.0
2023-10-19 09:00:00	QQQ	ETF	364.84	365.335	363.21	364.09	6725380.0
2023-10-19 10:00:00	QQQ	ETF	364.1	365.28	362.63	363.04	6543681.0
2023-10-19 11:00:00	QQQ	ETF	363.07	364.23	361.87	363.57	4620617.0
2023-10-19 12:00:00	QQQ	ETF	363.59	366.02	360.92	364.03	15381870.0
2023-10-19 13:00:00	QQQ	ETF	364.03	365.52	362.01	362.5	7556121.0
2023-10-19 14:00:00	QQQ	ETF	362.49	363.17	359.94	360.13	7339299.0
2023-10-19 15:00:00	QQQ	ETF	360.135	361.0	359.16	359.94	9307907.0
2023-10-19 16:00:00	QQQ	ETF	359.95	360.0	358.85	359.04	1615428.0
2023-10-19 17:00:00	QQQ	ETF	359.08	359.13	358.87	359.0	105627.0
2023-10-19 18:00:00	QQQ	ETF	359.0	359.19	358.63	358.66	169124.0
2023-10-19 19:00:00	QQQ	ETF	358.65	358.95	358.41	358.89	127376.0
2023-10-19 04:00:00	IWM	ETF	171.02	171.02	170.57	170.57	19451.0
2023-10-19 05:00:00	IWM	ETF	170.53	170.97	170.47	170.97	5694.0
2023-10-19 06:00:00	IWM	ETF	170.87	171.32	170.87	171.29	14270.0
2023-10-19 07:00:00	IWM	ETF	171.35	171.35	170.73	170.82	53067.0
2023-10-19 08:00:00	IWM	ETF	171.2781	171.42	170.77	171.33	94409.0
2023-10-19 09:00:00	IWM	ETF	171.31	171.45	170.27	170.47	3361903.0
2023-10-19 10:00:00	IWM	ETF	170.475	171.055	169.97	170.03	4430075.0
2023-10-19 11:00:00	IWM	ETF	170.04	171.35	169.955	170.82	4192504.0
2023-10-19 12:00:00	IWM	ETF	170.83	172.15	169.89	171.13	10298713.0
2023-10-19 13:00:00	IWM	ETF	171.13	171.81	169.98	170.18	5229197.0
2023-10-19 14:00:00	IWM	ETF	170.17	170.405	168.82	169.05	5618682.0
2023-10-19 15:00:00	IWM	ETF	169.05	169.22	168.36	168.66	8096791.0
2023-10-19 16:00:00	IWM	ETF	168.62	168.69	168.42	168.49	947159.0
2023-10-19 17:00:00	IWM	ETF	168.48	168.62	168.46	168.46	59387.0
2023-10-19 18:00:00	IWM	ETF	168.49	168.59	168.37	168.38	28449.0
2023-10-19 19:00:00	IWM	ETF	168.31	168.33	168.08	168.22	38977.0
2023-10-19 04:00:00	DIA	ETF	335.71	336.02	335.71	336.02	1836.0
2023-10-19 06:00:00	DIA	ETF	336.54	337.0	336.54	336.95	1875.0

> showing 50 of 18,034 rows — these rows as CSV

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