PREVIEW / etf_1hour / 2004-10-26

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-10-26.parquet
  size:    26 KB
  rows:    732

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-10-26 08:00:00	SPY	ETF	110.22	110.3	110.2	110.28	225600.0
2004-10-26 09:00:00	SPY	ETF	110.28	110.28	109.88	109.93	5714200.0
2004-10-26 10:00:00	SPY	ETF	109.93	110.61	109.9	110.43	11289600.0
2004-10-26 11:00:00	SPY	ETF	110.43	110.63	110.28	110.58	4518000.0
2004-10-26 12:00:00	SPY	ETF	110.59	111.01	110.53	110.87	5022600.0
2004-10-26 13:00:00	SPY	ETF	110.88	111.17	110.8	110.95	6245000.0
2004-10-26 14:00:00	SPY	ETF	110.95	111.24	110.92	111.17	4401000.0
2004-10-26 15:00:00	SPY	ETF	111.18	111.43	111.07	111.4	8968000.0
2004-10-26 16:00:00	SPY	ETF	111.43	111.6	111.4	111.47	4795000.0
2004-10-26 17:00:00	SPY	ETF	111.51	111.51	111.45	111.49	59700.0
2004-10-26 18:00:00	SPY	ETF	111.51	111.59	111.48	111.48	100800.0
2004-10-26 19:00:00	SPY	ETF	111.48	111.49	111.45	111.45	3900.0
2004-10-26 08:00:00	QQQ	ETF	35.73	35.76	35.7	35.73	327600.0
2004-10-26 09:00:00	QQQ	ETF	35.73	35.73	35.43	35.43	11437000.0
2004-10-26 10:00:00	QQQ	ETF	35.44	35.734	35.41	35.58	22839500.0
2004-10-26 11:00:00	QQQ	ETF	35.57	35.67	35.474	35.63	15685400.0
2004-10-26 12:00:00	QQQ	ETF	35.638	35.764	35.6	35.67	10206500.0
2004-10-26 13:00:00	QQQ	ETF	35.67	35.796	35.59	35.63	11017300.0
2004-10-26 14:00:00	QQQ	ETF	35.62	35.75	35.61	35.698	9630600.0
2004-10-26 15:00:00	QQQ	ETF	35.7	35.79	35.66	35.789	12285300.0
2004-10-26 16:00:00	QQQ	ETF	35.79	35.85	35.77	35.84	2819800.0
2004-10-26 17:00:00	QQQ	ETF	35.855	35.861	35.83	35.84	50200.0
2004-10-26 18:00:00	QQQ	ETF	35.85	35.882	35.84	35.84	28300.0
2004-10-26 19:00:00	QQQ	ETF	35.84	35.84	35.84	35.84	2400.0
2004-10-26 08:00:00	IWM	ETF	57.305	57.305	57.275	57.285	20800.0
2004-10-26 09:00:00	IWM	ETF	57.3	57.3	56.49	56.615	1494000.0
2004-10-26 10:00:00	IWM	ETF	56.62	57.095	56.585	56.94	2421000.0
2004-10-26 11:00:00	IWM	ETF	56.93	57.025	56.805	57.02	1214800.0
2004-10-26 12:00:00	IWM	ETF	57.02	57.28	56.975	57.175	2598400.0
2004-10-26 13:00:00	IWM	ETF	57.185	57.32	57.13	57.17	1556400.0
2004-10-26 14:00:00	IWM	ETF	57.175	57.385	57.13	57.36	1553000.0
2004-10-26 15:00:00	IWM	ETF	57.365	57.65	57.325	57.635	2904200.0
2004-10-26 16:00:00	IWM	ETF	57.645	57.85	57.645	57.73	691600.0
2004-10-26 18:00:00	IWM	ETF	57.75	57.755	57.75	57.755	3000.0
2004-10-26 08:00:00	DIA	ETF	98.06	98.1	98.04	98.05	4300.0
2004-10-26 09:00:00	DIA	ETF	98.01	98.06	97.67	97.75	616000.0
2004-10-26 10:00:00	DIA	ETF	97.75	98.3	97.7	98.22	1545700.0
2004-10-26 11:00:00	DIA	ETF	98.21	98.37	98.08	98.35	1111100.0
2004-10-26 12:00:00	DIA	ETF	98.34	98.75	98.31	98.63	1131500.0
2004-10-26 13:00:00	DIA	ETF	98.62	98.89	98.5	98.59	1306100.0
2004-10-26 14:00:00	DIA	ETF	98.61	98.83	98.59	98.81	567000.0
2004-10-26 15:00:00	DIA	ETF	98.81	98.99	98.74	98.99	1509400.0
2004-10-26 16:00:00	DIA	ETF	98.99	99.1	98.96	99.08	256500.0
2004-10-26 17:00:00	DIA	ETF	99.03	99.03	99.03	99.03	100.0
2004-10-26 18:00:00	DIA	ETF	99.01	99.08	99.01	99.08	1100.0
2004-10-26 19:00:00	DIA	ETF	98.96	99.07	98.96	99.05	1000.0
2004-10-26 09:00:00	TLT	ETF	89.95	90.01	89.93	89.97	31200.0
2004-10-26 10:00:00	TLT	ETF	90.0	90.0	89.8	89.92	130700.0
2004-10-26 11:00:00	TLT	ETF	89.88	89.94	89.87	89.94	138500.0
2004-10-26 12:00:00	TLT	ETF	89.91	89.92	89.81	89.84	22000.0

> showing 50 of 732 rows — these rows as CSV

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