PREVIEW / etf_1hour / 2004-07-12

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-07-12.parquet
  size:    24 KB
  rows:    677

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-12 08:00:00	SPY	ETF	111.42	111.63	111.42	111.57	32200.0
2004-07-12 09:00:00	SPY	ETF	111.56	111.71	111.39	111.43	4008500.0
2004-07-12 10:00:00	SPY	ETF	111.42	111.45	111.0	111.28	9206200.0
2004-07-12 11:00:00	SPY	ETF	111.27	111.36	111.13	111.19	2313700.0
2004-07-12 12:00:00	SPY	ETF	111.19	111.3	111.11	111.26	2962200.0
2004-07-12 13:00:00	SPY	ETF	111.24	111.26	111.09	111.18	1681500.0
2004-07-12 14:00:00	SPY	ETF	111.18	112.04	111.15	111.76	8313100.0
2004-07-12 15:00:00	SPY	ETF	111.76	111.91	111.66	111.78	4799600.0
2004-07-12 16:00:00	SPY	ETF	111.8	111.84	111.64	111.82	1071600.0
2004-07-12 17:00:00	SPY	ETF	111.76	111.79	111.76	111.79	40200.0
2004-07-12 18:00:00	SPY	ETF	111.83	111.85	111.79	111.85	3000.0
2004-07-12 19:00:00	SPY	ETF	111.82	111.82	111.82	111.82	300.0
2004-07-12 08:00:00	QQQ	ETF	35.75	35.75	35.54	35.57	316300.0
2004-07-12 09:00:00	QQQ	ETF	35.58	35.64	35.42	35.459	10982200.0
2004-07-12 10:00:00	QQQ	ETF	35.46	35.46	35.26	35.379	17239500.0
2004-07-12 11:00:00	QQQ	ETF	35.38	35.43	35.317	35.341	7722200.0
2004-07-12 12:00:00	QQQ	ETF	35.34	35.38	35.3	35.368	5052200.0
2004-07-12 13:00:00	QQQ	ETF	35.36	35.39	35.24	35.314	5087300.0
2004-07-12 14:00:00	QQQ	ETF	35.314	35.69	35.31	35.49	17960500.0
2004-07-12 15:00:00	QQQ	ETF	35.499	35.65	35.47	35.599	12904200.0
2004-07-12 16:00:00	QQQ	ETF	35.57	35.63	35.55	35.58	3534200.0
2004-07-12 17:00:00	QQQ	ETF	35.58	35.6	35.567	35.6	64000.0
2004-07-12 18:00:00	QQQ	ETF	35.6	35.62	35.59	35.62	34800.0
2004-07-12 19:00:00	QQQ	ETF	35.62	35.62	35.6	35.61	2800.0
2004-07-12 08:00:00	IWM	ETF	56.105	56.16	56.105	56.16	800.0
2004-07-12 09:00:00	IWM	ETF	56.125	56.225	55.815	55.87	1730400.0
2004-07-12 10:00:00	IWM	ETF	55.875	55.875	55.58	55.83	3034400.0
2004-07-12 11:00:00	IWM	ETF	55.825	55.905	55.705	55.8	1592000.0
2004-07-12 12:00:00	IWM	ETF	55.85	55.875	55.785	55.86	792400.0
2004-07-12 13:00:00	IWM	ETF	55.85	55.86	55.775	55.83	456400.0
2004-07-12 14:00:00	IWM	ETF	55.83	56.375	55.82	56.135	2188000.0
2004-07-12 15:00:00	IWM	ETF	56.135	56.215	55.995	55.995	2007400.0
2004-07-12 16:00:00	IWM	ETF	56.015	56.2	55.99	56.025	345200.0
2004-07-12 18:00:00	IWM	ETF	56.085	56.085	56.085	56.085	200.0
2004-07-12 08:00:00	DIA	ETF	102.3	102.43	102.3	102.37	3900.0
2004-07-12 09:00:00	DIA	ETF	102.3	102.49	102.22	102.25	586800.0
2004-07-12 10:00:00	DIA	ETF	102.24	102.24	101.8	102.04	1400200.0
2004-07-12 11:00:00	DIA	ETF	102.04	102.1	101.9	101.96	639800.0
2004-07-12 12:00:00	DIA	ETF	101.94	102.07	101.88	101.99	367500.0
2004-07-12 13:00:00	DIA	ETF	102.0	102.02	101.89	101.99	130400.0
2004-07-12 14:00:00	DIA	ETF	101.98	102.79	101.98	102.54	1188500.0
2004-07-12 15:00:00	DIA	ETF	102.58	102.73	102.5	102.59	852700.0
2004-07-12 16:00:00	DIA	ETF	102.58	102.63	102.52	102.56	32000.0
2004-07-12 09:00:00	TLT	ETF	84.61	84.61	84.5	84.55	65700.0
2004-07-12 10:00:00	TLT	ETF	84.53	84.6	84.52	84.57	40800.0
2004-07-12 11:00:00	TLT	ETF	84.49	84.54	84.46	84.49	386500.0
2004-07-12 12:00:00	TLT	ETF	84.5	84.64	84.5	84.64	44200.0
2004-07-12 13:00:00	TLT	ETF	84.64	84.65	84.57	84.65	35300.0
2004-07-12 14:00:00	TLT	ETF	84.62	84.66	84.54	84.55	13600.0
2004-07-12 15:00:00	TLT	ETF	84.53	84.56	84.44	84.5	708100.0

> showing 50 of 677 rows — these rows as CSV

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