PREVIEW / etf_1hour / 2004-07-08

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-07-08.parquet
  size:    25 KB
  rows:    694

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
2004-07-08 08:00:00	SPY	ETF	111.63	111.76	111.59	111.72	84500.0
2004-07-08 09:00:00	SPY	ETF	111.73	112.05	111.61	111.83	4804700.0
2004-07-08 10:00:00	SPY	ETF	111.79	112.05	111.54	111.84	7054500.0
2004-07-08 11:00:00	SPY	ETF	111.84	112.32	111.79	112.13	5240700.0
2004-07-08 12:00:00	SPY	ETF	112.13	112.17	111.9	111.93	2585500.0
2004-07-08 13:00:00	SPY	ETF	111.93	111.98	111.67	111.71	3461300.0
2004-07-08 14:00:00	SPY	ETF	111.72	111.73	111.33	111.7	8601200.0
2004-07-08 15:00:00	SPY	ETF	111.7	111.83	111.2	111.22	6346800.0
2004-07-08 16:00:00	SPY	ETF	111.2	111.51	111.2	111.42	1678000.0
2004-07-08 17:00:00	SPY	ETF	111.43	111.54	111.41	111.5	153200.0
2004-07-08 18:00:00	SPY	ETF	111.5	111.5	111.43	111.45	48100.0
2004-07-08 08:00:00	QQQ	ETF	35.68	35.77	35.64	35.76	282700.0
2004-07-08 09:00:00	QQQ	ETF	35.77	35.93	35.73	35.864	16419500.0
2004-07-08 10:00:00	QQQ	ETF	35.864	35.965	35.78	35.84	13648600.0
2004-07-08 11:00:00	QQQ	ETF	35.859	36.13	35.81	36.02	16047800.0
2004-07-08 12:00:00	QQQ	ETF	36.02	36.06	35.867	35.89	8505100.0
2004-07-08 13:00:00	QQQ	ETF	35.89	35.94	35.77	35.79	7882800.0
2004-07-08 14:00:00	QQQ	ETF	35.79	35.8	35.64	35.77	15184800.0
2004-07-08 15:00:00	QQQ	ETF	35.77	35.81	35.55	35.57	17711800.0
2004-07-08 16:00:00	QQQ	ETF	35.58	35.75	35.55	35.69	4794100.0
2004-07-08 17:00:00	QQQ	ETF	35.68	35.71	35.65	35.69	949800.0
2004-07-08 18:00:00	QQQ	ETF	35.68	35.73	35.68	35.73	67700.0
2004-07-08 19:00:00	QQQ	ETF	35.7	35.74	35.66	35.74	10900.0
2004-07-08 08:00:00	IWM	ETF	56.66	56.66	56.66	56.66	4600.0
2004-07-08 09:00:00	IWM	ETF	56.71	56.815	56.445	56.63	1404200.0
2004-07-08 10:00:00	IWM	ETF	56.61	56.75	56.455	56.605	1199200.0
2004-07-08 11:00:00	IWM	ETF	56.6093	56.99	56.595	56.805	2066600.0
2004-07-08 12:00:00	IWM	ETF	56.79	56.83	56.565	56.585	1116200.0
2004-07-08 13:00:00	IWM	ETF	56.585	56.66	56.12	56.28	1646600.0
2004-07-08 14:00:00	IWM	ETF	56.295	56.315	56.08	56.315	2610200.0
2004-07-08 15:00:00	IWM	ETF	56.325	56.345	55.795	55.82	2548800.0
2004-07-08 16:00:00	IWM	ETF	55.855	55.955	55.81	55.935	694800.0
2004-07-08 17:00:00	IWM	ETF	55.9	55.925	55.9	55.925	2000.0
2004-07-08 08:00:00	DIA	ETF	102.2	102.36	102.19	102.33	3200.0
2004-07-08 09:00:00	DIA	ETF	102.33	102.58	102.2	102.3096	768100.0
2004-07-08 10:00:00	DIA	ETF	102.31	102.56	102.12	102.4	1351800.0
2004-07-08 11:00:00	DIA	ETF	102.43	102.9	102.42	102.75	1694100.0
2004-07-08 12:00:00	DIA	ETF	102.77	102.77	102.53	102.57	877100.0
2004-07-08 13:00:00	DIA	ETF	102.61	102.61	102.35	102.38	311300.0
2004-07-08 14:00:00	DIA	ETF	102.38	102.39	102.02	102.35	1105300.0
2004-07-08 15:00:00	DIA	ETF	102.34	102.45	101.86	101.89	1253000.0
2004-07-08 16:00:00	DIA	ETF	101.93	102.15	101.87	102.09	231600.0
2004-07-08 17:00:00	DIA	ETF	102.09	102.14	102.09	102.14	1000.0
2004-07-08 18:00:00	DIA	ETF	102.14	102.14	102.14	102.14	300.0
2004-07-08 19:00:00	DIA	ETF	102.25	102.25	102.12	102.12	600.0
2004-07-08 09:00:00	TLT	ETF	84.3	84.39	84.23	84.38	105500.0
2004-07-08 10:00:00	TLT	ETF	84.38	84.53	84.31	84.4	133700.0
2004-07-08 11:00:00	TLT	ETF	84.41	84.45	84.35	84.44	107500.0
2004-07-08 12:00:00	TLT	ETF	84.45	84.54	84.44	84.44	63800.0
2004-07-08 13:00:00	TLT	ETF	84.44	84.44	84.25	84.28	38700.0

> showing 50 of 694 rows — these rows as CSV

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