PREVIEW / etf_1hour / 2023-12-06

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-12-06.parquet
  size:    518 KB
  rows:    18,861

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-12-06 04:00:00	SPY	ETF	457.62	457.85	457.4	457.5	11116.0
2023-12-06 05:00:00	SPY	ETF	457.52	457.96	457.47	457.96	19830.0
2023-12-06 06:00:00	SPY	ETF	457.85	457.85	457.29	457.52	34728.0
2023-12-06 07:00:00	SPY	ETF	457.46	457.54	457.14	457.54	103636.0
2023-12-06 08:00:00	SPY	ETF	457.37	458.69	457.17	458.58	603639.0
2023-12-06 09:00:00	SPY	ETF	458.5502	458.94	457.82	458.01	4982732.0
2023-12-06 10:00:00	SPY	ETF	458.01	458.4	456.76	457.19	7539361.0
2023-12-06 11:00:00	SPY	ETF	457.2	457.47	456.01	456.76	6229750.0
2023-12-06 12:00:00	SPY	ETF	456.76	456.86	455.8	455.862	4680344.0
2023-12-06 13:00:00	SPY	ETF	455.87	456.5985	455.6	456.47	4388827.0
2023-12-06 14:00:00	SPY	ETF	456.47	456.55	455.82	455.83	3862678.0
2023-12-06 15:00:00	SPY	ETF	455.83	455.9	454.31	454.71	15704485.0
2023-12-06 16:00:00	SPY	ETF	454.69	457.2052	454.58	454.75	4715414.0
2023-12-06 17:00:00	SPY	ETF	454.76	454.8	454.45	454.55	215826.0
2023-12-06 18:00:00	SPY	ETF	454.55	454.72	454.35	454.6	251722.0
2023-12-06 19:00:00	SPY	ETF	454.61	454.74	454.44	454.51	44101.0
2023-12-06 04:00:00	QQQ	ETF	388.32	388.97	388.16	388.38	39478.0
2023-12-06 05:00:00	QQQ	ETF	388.5	388.84	388.37	388.84	18774.0
2023-12-06 06:00:00	QQQ	ETF	388.83	388.83	387.9	388.2	20740.0
2023-12-06 07:00:00	QQQ	ETF	388.21	388.23	387.61	388.07	180270.0
2023-12-06 08:00:00	QQQ	ETF	388.3	389.9	387.58	389.82	546683.0
2023-12-06 09:00:00	QQQ	ETF	389.84	390.37	387.965	388.27	5020020.0
2023-12-06 10:00:00	QQQ	ETF	388.24	388.84	386.52	387.9418	5984650.0
2023-12-06 11:00:00	QQQ	ETF	387.95	388.2898	386.215	387.4896	4128136.0
2023-12-06 12:00:00	QQQ	ETF	387.48	387.68	386.23	386.3223	2389363.0
2023-12-06 13:00:00	QQQ	ETF	386.31	386.806	385.76	386.71	2978258.0
2023-12-06 14:00:00	QQQ	ETF	386.71	386.8199	386.055	386.3	2635618.0
2023-12-06 15:00:00	QQQ	ETF	386.31	386.422	384.7	385.015	7101814.0
2023-12-06 16:00:00	QQQ	ETF	385.0	385.15	384.87	384.99	1673637.0
2023-12-06 17:00:00	QQQ	ETF	385.02	385.05	384.85	384.85	41247.0
2023-12-06 18:00:00	QQQ	ETF	384.85	385.23	384.7	385.0204	45971.0
2023-12-06 19:00:00	QQQ	ETF	385.04	385.2	384.83	385.02	56799.0
2023-12-06 04:00:00	IWM	ETF	184.94	185.09	184.6	184.79	23818.0
2023-12-06 05:00:00	IWM	ETF	184.79	185.18	184.75	185.18	2101.0
2023-12-06 06:00:00	IWM	ETF	185.2	185.23	184.86	185.05	30363.0
2023-12-06 07:00:00	IWM	ETF	185.08	185.2	184.88	185.04	49743.0
2023-12-06 08:00:00	IWM	ETF	185.0109	185.83	184.5896	185.71	111622.0
2023-12-06 09:00:00	IWM	ETF	185.64	187.475	185.28	187.34	5069053.0
2023-12-06 10:00:00	IWM	ETF	187.34	187.92	186.27	186.37	6612576.0
2023-12-06 11:00:00	IWM	ETF	186.37	186.81	185.68	186.09	4421658.0
2023-12-06 12:00:00	IWM	ETF	186.09	186.095	185.35	185.4	2924758.0
2023-12-06 13:00:00	IWM	ETF	185.4	185.9059	185.12	185.755	2522836.0
2023-12-06 14:00:00	IWM	ETF	185.75	185.87	185.095	185.13	2007959.0
2023-12-06 15:00:00	IWM	ETF	185.13	185.29	183.79	183.97	7715047.0
2023-12-06 16:00:00	IWM	ETF	183.96	184.0764	183.86	184.0	1266727.0
2023-12-06 17:00:00	IWM	ETF	184.02	184.02	183.77	183.78	16542.0
2023-12-06 18:00:00	IWM	ETF	183.88	184.0	183.75	183.9	55970.0
2023-12-06 19:00:00	IWM	ETF	183.95	184.07	183.92	184.02	53876.0
2023-12-06 04:00:00	DIA	ETF	362.25	362.25	362.25	362.25	105.0
2023-12-06 05:00:00	DIA	ETF	362.3	362.3	362.3	362.3	130.0

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

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