PREVIEW / etf_1hour / 2004-10-22

all etf 1-hour files

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

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-22 08:00:00	SPY	ETF	111.12	111.36	111.1	111.35	83200.0
2004-10-22 09:00:00	SPY	ETF	111.3	111.31	110.96	111.14	4097500.0
2004-10-22 10:00:00	SPY	ETF	111.15	111.25	110.69	110.86	7498200.0
2004-10-22 11:00:00	SPY	ETF	110.85	110.93	110.65	110.75	3784600.0
2004-10-22 12:00:00	SPY	ETF	110.75	111.01	110.72	110.79	3515600.0
2004-10-22 13:00:00	SPY	ETF	110.79	110.85	110.21	110.34	5531500.0
2004-10-22 14:00:00	SPY	ETF	110.33	110.55	109.94	110.01	6823900.0
2004-10-22 15:00:00	SPY	ETF	110.0	110.24	109.86	109.95	10959900.0
2004-10-22 16:00:00	SPY	ETF	109.93	110.03	109.88	110.01	3118600.0
2004-10-22 17:00:00	SPY	ETF	110.02	110.08	109.97	110.06	8500.0
2004-10-22 18:00:00	SPY	ETF	110.08	110.1	110.08	110.1	1000.0
2004-10-22 19:00:00	SPY	ETF	110.1	110.15	110.0	110.0	700.0
2004-10-22 08:00:00	QQQ	ETF	36.6	36.76	36.6	36.72	648400.0
2004-10-22 09:00:00	QQQ	ETF	36.72	36.72	36.42	36.501	14627100.0
2004-10-22 10:00:00	QQQ	ETF	36.51	36.55	36.301	36.34	17412300.0
2004-10-22 11:00:00	QQQ	ETF	36.346	36.38	36.21	36.25	9091100.0
2004-10-22 12:00:00	QQQ	ETF	36.25	36.36	36.225	36.23	7956800.0
2004-10-22 13:00:00	QQQ	ETF	36.23	36.25	36.0	36.047	16063600.0
2004-10-22 14:00:00	QQQ	ETF	36.047	36.07	35.792	35.82	18022000.0
2004-10-22 15:00:00	QQQ	ETF	35.82	35.9	35.74	35.79	23888800.0
2004-10-22 16:00:00	QQQ	ETF	35.78	35.83	35.75	35.76	4814300.0
2004-10-22 17:00:00	QQQ	ETF	35.76	35.76	35.72	35.74	58500.0
2004-10-22 18:00:00	QQQ	ETF	35.77	35.79	35.76	35.76	13900.0
2004-10-22 19:00:00	QQQ	ETF	35.8	35.8	35.75	35.79	8900.0
2004-10-22 08:00:00	IWM	ETF	57.6	57.61	57.6	57.61	4000.0
2004-10-22 09:00:00	IWM	ETF	57.475	57.645	57.35	57.56	1835600.0
2004-10-22 10:00:00	IWM	ETF	57.57	57.65	57.375	57.475	2061000.0
2004-10-22 11:00:00	IWM	ETF	57.475	57.525	57.335	57.38	843600.0
2004-10-22 12:00:00	IWM	ETF	57.36	57.49	57.285	57.285	423000.0
2004-10-22 13:00:00	IWM	ETF	57.3	57.3	56.725	56.83	3103600.0
2004-10-22 14:00:00	IWM	ETF	56.84	57.155	56.685	56.745	2736400.0
2004-10-22 15:00:00	IWM	ETF	56.725	56.82	56.475	56.51	3603200.0
2004-10-22 16:00:00	IWM	ETF	56.505	56.59	56.455	56.525	1393200.0
2004-10-22 08:00:00	DIA	ETF	98.87	99.02	98.87	99.02	900.0
2004-10-22 09:00:00	DIA	ETF	99.0	99.03	98.81	98.95	608200.0
2004-10-22 10:00:00	DIA	ETF	98.98	99.04	98.53	98.59	965800.0
2004-10-22 11:00:00	DIA	ETF	98.6	98.68	98.43	98.51	635300.0
2004-10-22 12:00:00	DIA	ETF	98.49	98.8	98.47	98.52	673800.0
2004-10-22 13:00:00	DIA	ETF	98.5	98.6	98.03	98.09	1383500.0
2004-10-22 14:00:00	DIA	ETF	98.07	98.33	97.84	97.86	2643800.0
2004-10-22 15:00:00	DIA	ETF	97.85	97.99	97.68	97.71	2968500.0
2004-10-22 16:00:00	DIA	ETF	97.7	97.84	97.67	97.74	519400.0
2004-10-22 17:00:00	DIA	ETF	97.76	97.76	97.76	97.76	100.0
2004-10-22 18:00:00	DIA	ETF	97.75	97.75	97.74	97.74	600.0
2004-10-22 19:00:00	DIA	ETF	97.99	97.99	97.99	97.99	200.0
2004-10-22 08:00:00	TLT	ETF	89.37	89.37	89.32	89.32	600.0
2004-10-22 09:00:00	TLT	ETF	89.5	89.5	89.37	89.44	41500.0
2004-10-22 10:00:00	TLT	ETF	89.44	89.68	89.44	89.61	49800.0
2004-10-22 11:00:00	TLT	ETF	89.61	89.68	89.55	89.55	63600.0
2004-10-22 12:00:00	TLT	ETF	89.57	89.61	89.55	89.58	13000.0

> showing 50 of 734 rows — these rows as CSV

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