PREVIEW / etf_1hour / 2023-10-11

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-10-11.parquet
  size:    489 KB
  rows:    17,715

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-11 04:00:00	SPY	ETF	434.86	435.35	434.58	435.23	29556.0
2023-10-11 05:00:00	SPY	ETF	435.17	435.55	435.04	435.46	21965.0
2023-10-11 06:00:00	SPY	ETF	435.56	435.69	435.3	435.64	76262.0
2023-10-11 07:00:00	SPY	ETF	435.6	436.28	435.59	435.9	441240.0
2023-10-11 08:00:00	SPY	ETF	436.0	436.16	434.39	436.14	965004.0
2023-10-11 09:00:00	SPY	ETF	436.15	436.46	435.3	435.52	5781907.0
2023-10-11 10:00:00	SPY	ETF	435.53	435.62	434.51	435.505	6793012.0
2023-10-11 11:00:00	SPY	ETF	435.51	435.83	434.21	434.47	5812327.0
2023-10-11 12:00:00	SPY	ETF	434.46	434.5501	433.56	434.1571	5271556.0
2023-10-11 13:00:00	SPY	ETF	434.15	434.38	433.18	433.8296	5303790.0
2023-10-11 14:00:00	SPY	ETF	433.83	435.32	433.8	435.06	6743233.0
2023-10-11 15:00:00	SPY	ETF	435.05	436.58	434.92	436.31	12109438.0
2023-10-11 16:00:00	SPY	ETF	436.31	437.34	435.107	437.3	2553176.0
2023-10-11 17:00:00	SPY	ETF	437.29	437.33	436.3632	437.18	190903.0
2023-10-11 18:00:00	SPY	ETF	437.15	437.18	436.95	437.18	84350.0
2023-10-11 19:00:00	SPY	ETF	437.16	437.36	437.09	437.35	64829.0
2023-10-11 04:00:00	QQQ	ETF	369.23	369.54	368.75	369.41	34492.0
2023-10-11 05:00:00	QQQ	ETF	369.35	369.73	369.12	369.54	13912.0
2023-10-11 06:00:00	QQQ	ETF	369.66	369.97	369.38	369.88	31342.0
2023-10-11 07:00:00	QQQ	ETF	369.87	370.44	369.87	370.14	125086.0
2023-10-11 08:00:00	QQQ	ETF	370.3	370.44	368.5	370.2	1221049.0
2023-10-11 09:00:00	QQQ	ETF	370.19	371.412	369.67	370.05	4660458.0
2023-10-11 10:00:00	QQQ	ETF	370.06	370.91	369.34	370.7097	5044983.0
2023-10-11 11:00:00	QQQ	ETF	370.73	371.32	369.12	369.65	3652181.0
2023-10-11 12:00:00	QQQ	ETF	369.64	369.66	368.74	369.42	3449789.0
2023-10-11 13:00:00	QQQ	ETF	369.42	369.52	368.19	368.89	3727958.0
2023-10-11 14:00:00	QQQ	ETF	368.89	370.335	368.84	369.94	3470948.0
2023-10-11 15:00:00	QQQ	ETF	369.94	371.38	369.71	371.2	4341184.0
2023-10-11 16:00:00	QQQ	ETF	371.19	372.12	371.12	372.01	1008216.0
2023-10-11 17:00:00	QQQ	ETF	371.99	372.0399	371.91	371.92	75026.0
2023-10-11 18:00:00	QQQ	ETF	371.92	371.95	371.71	371.87	73660.0
2023-10-11 19:00:00	QQQ	ETF	371.86	372.1	371.82	372.09	67642.0
2023-10-11 04:00:00	IWM	ETF	176.11	176.21	175.86	176.2	10490.0
2023-10-11 05:00:00	IWM	ETF	176.16	176.33	176.06	176.33	3883.0
2023-10-11 06:00:00	IWM	ETF	176.28	176.3	176.12	176.24	55203.0
2023-10-11 07:00:00	IWM	ETF	176.22	176.44	176.19	176.31	82645.0
2023-10-11 08:00:00	IWM	ETF	176.25	176.59	175.79	176.59	290300.0
2023-10-11 09:00:00	IWM	ETF	176.61	177.23	176.09	176.32	3365944.0
2023-10-11 10:00:00	IWM	ETF	176.32	176.345	175.26	175.77	4152503.0
2023-10-11 11:00:00	IWM	ETF	175.78	175.92	175.03	175.18	2592838.0
2023-10-11 12:00:00	IWM	ETF	175.2	175.34	174.54	174.83	2948452.0
2023-10-11 13:00:00	IWM	ETF	174.83	174.925	174.375	174.71	2209148.0
2023-10-11 14:00:00	IWM	ETF	174.71	175.335	174.64	175.24	2308970.0
2023-10-11 15:00:00	IWM	ETF	175.24	175.725	175.135	175.62	4645618.0
2023-10-11 16:00:00	IWM	ETF	175.61	176.25	175.6	176.18	1131975.0
2023-10-11 17:00:00	IWM	ETF	176.16	176.25	176.05	176.05	15655.0
2023-10-11 18:00:00	IWM	ETF	176.2	176.2	176.07	176.19	11739.0
2023-10-11 19:00:00	IWM	ETF	176.21	176.41	176.16	176.38	141926.0
2023-10-11 04:00:00	DIA	ETF	337.86	337.86	337.86	337.86	125.0
2023-10-11 05:00:00	DIA	ETF	338.08	338.08	338.05	338.05	900.0

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

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