PREVIEW / etf_1hour / 2023-10-20

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-10-20.parquet
  size:    486 KB
  rows:    17,873

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-20 04:00:00	SPY	ETF	425.78	426.73	425.34	426.35	66443.0
2023-10-20 05:00:00	SPY	ETF	426.24	426.33	425.27	425.61	24064.0
2023-10-20 06:00:00	SPY	ETF	425.69	425.71	425.18	425.39	41674.0
2023-10-20 07:00:00	SPY	ETF	425.38	426.28	425.31	426.08	279064.0
2023-10-20 08:00:00	SPY	ETF	426.05	426.6304	424.58	425.15	799632.0
2023-10-20 09:00:00	SPY	ETF	425.25	426.54	425.09	425.09	8110701.0
2023-10-20 10:00:00	SPY	ETF	425.07	425.43	422.33	422.4091	14767435.0
2023-10-20 11:00:00	SPY	ETF	422.405	423.752	421.91	423.385	12471427.0
2023-10-20 12:00:00	SPY	ETF	423.39	424.46	422.295	424.269	8232487.0
2023-10-20 13:00:00	SPY	ETF	424.27	424.77	423.08	424.22	7807556.0
2023-10-20 14:00:00	SPY	ETF	424.2	424.2884	422.2367	422.62	9830504.0
2023-10-20 15:00:00	SPY	ETF	422.63	423.11	421.08	421.21	22024089.0
2023-10-20 16:00:00	SPY	ETF	421.21	425.5286	420.72	420.9	4939003.0
2023-10-20 17:00:00	SPY	ETF	420.9	421.05	420.85	420.85	218274.0
2023-10-20 18:00:00	SPY	ETF	420.85	420.85	420.65	420.85	40860.0
2023-10-20 19:00:00	SPY	ETF	420.84	420.84	420.6	420.6	11094.0
2023-10-20 04:00:00	QQQ	ETF	358.64	360.05	358.53	359.61	66383.0
2023-10-20 05:00:00	QQQ	ETF	359.58	359.6	358.67	359.19	66802.0
2023-10-20 06:00:00	QQQ	ETF	359.1	359.23	358.56	358.74	37461.0
2023-10-20 07:00:00	QQQ	ETF	358.78	359.65	358.61	359.44	123115.0
2023-10-20 08:00:00	QQQ	ETF	359.46	360.239	358.0	358.6	649905.0
2023-10-20 09:00:00	QQQ	ETF	358.55	360.04	358.21	358.89	6521869.0
2023-10-20 10:00:00	QQQ	ETF	358.85	359.4392	355.12	355.125	8705697.0
2023-10-20 11:00:00	QQQ	ETF	355.13	356.5006	354.6	356.18	7879167.0
2023-10-20 12:00:00	QQQ	ETF	356.19	357.45	355.25	357.3334	5101360.0
2023-10-20 13:00:00	QQQ	ETF	357.33	358.06	356.42	357.44	5604528.0
2023-10-20 14:00:00	QQQ	ETF	357.44	357.52	355.2905	355.7445	4658599.0
2023-10-20 15:00:00	QQQ	ETF	355.75	356.29	354.37	354.62	10057426.0
2023-10-20 16:00:00	QQQ	ETF	354.6	354.81	354.23	354.34	2754869.0
2023-10-20 17:00:00	QQQ	ETF	354.3101	354.37	354.2	354.21	60534.0
2023-10-20 18:00:00	QQQ	ETF	354.21	354.6	354.1	354.17	158573.0
2023-10-20 19:00:00	QQQ	ETF	354.19	354.19	353.95	353.96	15738.0
2023-10-20 04:00:00	IWM	ETF	168.14	168.8	168.14	168.6	9836.0
2023-10-20 05:00:00	IWM	ETF	168.54	168.54	168.18	168.43	1841.0
2023-10-20 06:00:00	IWM	ETF	168.3	168.33	168.06	168.17	18871.0
2023-10-20 07:00:00	IWM	ETF	168.22	168.63	168.21	168.56	38205.0
2023-10-20 08:00:00	IWM	ETF	168.21	168.58	167.81	168.12	134065.0
2023-10-20 09:00:00	IWM	ETF	168.18	168.93	167.865	168.22	5042810.0
2023-10-20 10:00:00	IWM	ETF	168.21	168.37	167.195	167.46	5691145.0
2023-10-20 11:00:00	IWM	ETF	167.47	167.8463	166.91	167.68	6294434.0
2023-10-20 12:00:00	IWM	ETF	167.69	168.21	167.15	168.11	4397410.0
2023-10-20 13:00:00	IWM	ETF	168.11	168.45	167.58	168.22	4679321.0
2023-10-20 14:00:00	IWM	ETF	168.22	168.265	167.231	167.375	3762776.0
2023-10-20 15:00:00	IWM	ETF	167.375	167.54	166.43	166.5	8985596.0
2023-10-20 16:00:00	IWM	ETF	166.44	166.56	166.3	166.52	1147421.0
2023-10-20 17:00:00	IWM	ETF	166.47	166.65	166.29	166.3	103398.0
2023-10-20 18:00:00	IWM	ETF	166.3	166.3	166.14	166.2001	24966.0
2023-10-20 19:00:00	IWM	ETF	166.28	166.28	166.11	166.14	5540.0
2023-10-20 04:00:00	DIA	ETF	333.88	334.2	333.65	333.99	6505.0
2023-10-20 05:00:00	DIA	ETF	333.83	333.83	333.5	333.62	1201.0

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

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