PREVIEW / etf_1hour / 2023-10-06

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-10-06.parquet
  size:    492 KB
  rows:    17,709

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-06 04:00:00	SPY	ETF	424.65	425.01	424.36	424.5	47640.0
2023-10-06 05:00:00	SPY	ETF	424.54	425.05	424.42	425.01	18192.0
2023-10-06 06:00:00	SPY	ETF	425.12	425.84	425.05	425.51	42614.0
2023-10-06 07:00:00	SPY	ETF	425.42	425.581	424.74	424.809	167876.0
2023-10-06 08:00:00	SPY	ETF	425.34	425.8204	419.7	420.51	2774003.0
2023-10-06 09:00:00	SPY	ETF	420.48	423.0	420.19	421.91	9763571.0
2023-10-06 10:00:00	SPY	ETF	421.94	424.32	420.6	423.81	14345215.0
2023-10-06 11:00:00	SPY	ETF	423.82	428.9	423.782	428.879	13968408.0
2023-10-06 12:00:00	SPY	ETF	428.88	429.28	427.66	428.25	11206784.0
2023-10-06 13:00:00	SPY	ETF	428.28	429.87	428.085	429.74	7467663.0
2023-10-06 14:00:00	SPY	ETF	429.74	431.125	429.34	430.69	8500263.0
2023-10-06 15:00:00	SPY	ETF	430.69	430.95	429.38	429.52	20380665.0
2023-10-06 16:00:00	SPY	ETF	429.52	430.9099	421.1825	429.8	4606843.0
2023-10-06 17:00:00	SPY	ETF	429.8	429.95	429.75	429.94	31923.0
2023-10-06 18:00:00	SPY	ETF	429.95	430.1	429.74	429.89	32973.0
2023-10-06 19:00:00	SPY	ETF	429.89	430.15	429.89	430.15	27947.0
2023-10-06 04:00:00	QQQ	ETF	359.23	359.41	358.59	358.84	39493.0
2023-10-06 05:00:00	QQQ	ETF	358.88	359.35	358.8	359.29	25396.0
2023-10-06 06:00:00	QQQ	ETF	359.26	360.07	359.2	359.72	43575.0
2023-10-06 07:00:00	QQQ	ETF	359.7	359.91	358.91	358.99	121295.0
2023-10-06 08:00:00	QQQ	ETF	358.98	359.9396	353.78	354.38	3724178.0
2023-10-06 09:00:00	QQQ	ETF	354.33	357.2	354.06	356.25	9031175.0
2023-10-06 10:00:00	QQQ	ETF	356.3	359.61	354.95	359.22	10387313.0
2023-10-06 11:00:00	QQQ	ETF	359.2333	363.17	359.1586	363.15	10609526.0
2023-10-06 12:00:00	QQQ	ETF	363.15	363.68	362.46	363.13	6054012.0
2023-10-06 13:00:00	QQQ	ETF	363.13	364.37	362.93	364.3235	4622941.0
2023-10-06 14:00:00	QQQ	ETF	364.33	365.91	363.96	365.25	5648954.0
2023-10-06 15:00:00	QQQ	ETF	365.255	365.88	364.6	364.69	10336427.0
2023-10-06 16:00:00	QQQ	ETF	364.69	365.34	364.58	365.34	1804054.0
2023-10-06 17:00:00	QQQ	ETF	365.31	365.33	365.11	365.26	57502.0
2023-10-06 18:00:00	QQQ	ETF	365.31	365.4	365.08	365.19	52164.0
2023-10-06 19:00:00	QQQ	ETF	365.25	365.67	365.25	365.67	29735.0
2023-10-06 04:00:00	IWM	ETF	171.6	171.74	171.52	171.59	6024.0
2023-10-06 05:00:00	IWM	ETF	171.52	171.84	171.5	171.84	1342.0
2023-10-06 06:00:00	IWM	ETF	171.83	172.37	171.83	172.19	8644.0
2023-10-06 07:00:00	IWM	ETF	172.19	172.24	171.92	171.95	51029.0
2023-10-06 08:00:00	IWM	ETF	172.05	172.3504	169.39	169.95	890422.0
2023-10-06 09:00:00	IWM	ETF	169.83	171.105	169.69	170.43	4790836.0
2023-10-06 10:00:00	IWM	ETF	170.44	171.09	169.51	170.7	5977827.0
2023-10-06 11:00:00	IWM	ETF	170.71	173.77	170.68	173.75	6601791.0
2023-10-06 12:00:00	IWM	ETF	173.75	173.89	172.795	172.95	4603436.0
2023-10-06 13:00:00	IWM	ETF	172.95	173.49	172.8	173.45	2513601.0
2023-10-06 14:00:00	IWM	ETF	173.45	173.8799	173.23	173.565	2315986.0
2023-10-06 15:00:00	IWM	ETF	173.57	173.57	172.85	172.97	4681767.0
2023-10-06 16:00:00	IWM	ETF	172.97	173.28	172.91	173.17	772933.0
2023-10-06 17:00:00	IWM	ETF	173.16	173.36	173.12	173.21	19219.0
2023-10-06 18:00:00	IWM	ETF	173.33	173.34	173.23	173.3	4932.0
2023-10-06 19:00:00	IWM	ETF	173.3	173.35	173.23	173.35	5067.0
2023-10-06 04:00:00	DIA	ETF	331.51	331.51	331.48	331.48	441.0
2023-10-06 05:00:00	DIA	ETF	331.45	331.49	331.45	331.49	1815.0

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

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