PREVIEW / etf_1hour / 2004-03-31

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-03-31.parquet
  size:    25 KB
  rows:    698

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-03-31 08:00:00	SPY	ETF	113.19	113.24	113.09	113.17	42800.0
2004-03-31 09:00:00	SPY	ETF	113.15	113.17	112.64	112.9	7281900.0
2004-03-31 10:00:00	SPY	ETF	112.87	112.89	112.38	112.74	9200600.0
2004-03-31 11:00:00	SPY	ETF	112.74	112.89	112.64	112.74	4263200.0
2004-03-31 12:00:00	SPY	ETF	112.74	112.99	112.69	112.85	2035400.0
2004-03-31 13:00:00	SPY	ETF	112.85	112.92	112.61	112.67	2723700.0
2004-03-31 14:00:00	SPY	ETF	112.66	113.4	112.66	113.29	7031200.0
2004-03-31 15:00:00	SPY	ETF	113.29	113.31	112.82	112.87	8664700.0
2004-03-31 16:00:00	SPY	ETF	112.87	113.18	112.82	113.12	3679200.0
2004-03-31 17:00:00	SPY	ETF	113.07	113.15	113.01	113.15	57100.0
2004-03-31 18:00:00	SPY	ETF	113.1	113.19	113.1	113.18	25000.0
2004-03-31 19:00:00	SPY	ETF	113.19	113.19	113.16	113.16	3800.0
2004-03-31 08:00:00	QQQ	ETF	36.06	36.06	35.97	36.0	101300.0
2004-03-31 09:00:00	QQQ	ETF	36.0	36.0	35.78	35.855	10010800.0
2004-03-31 10:00:00	QQQ	ETF	35.854	35.854	35.61	35.77	20020900.0
2004-03-31 11:00:00	QQQ	ETF	35.77	35.79	35.67	35.74	7983600.0
2004-03-31 12:00:00	QQQ	ETF	35.74	35.84	35.717	35.76	6126500.0
2004-03-31 13:00:00	QQQ	ETF	35.76	35.8	35.66	35.691	6263200.0
2004-03-31 14:00:00	QQQ	ETF	35.69	36.0	35.68	35.94	14493000.0
2004-03-31 15:00:00	QQQ	ETF	35.94	35.95	35.66	35.69	14330700.0
2004-03-31 16:00:00	QQQ	ETF	35.69	35.85	35.68	35.83	3420100.0
2004-03-31 17:00:00	QQQ	ETF	35.84	35.84	35.81	35.81	118200.0
2004-03-31 18:00:00	QQQ	ETF	35.82	35.84	35.78	35.83	38700.0
2004-03-31 19:00:00	QQQ	ETF	35.84	35.86	35.82	35.82	10700.0
2004-03-31 08:00:00	IWM	ETF	58.8	58.8	58.8	58.8	2000.0
2004-03-31 09:00:00	IWM	ETF	58.675	58.715	58.485	58.59	2065400.0
2004-03-31 10:00:00	IWM	ETF	58.59	58.75	58.155	58.655	2995000.0
2004-03-31 11:00:00	IWM	ETF	58.69	58.79	58.595	58.63	1305800.0
2004-03-31 12:00:00	IWM	ETF	58.63	58.665	58.48	58.57	831400.0
2004-03-31 13:00:00	IWM	ETF	58.595	58.735	58.485	58.5	894600.0
2004-03-31 14:00:00	IWM	ETF	58.525	58.9	58.525	58.83	1185000.0
2004-03-31 15:00:00	IWM	ETF	58.825	58.895	58.675	58.785	2943200.0
2004-03-31 16:00:00	IWM	ETF	58.765	58.815	58.665	58.785	794400.0
2004-03-31 17:00:00	IWM	ETF	58.785	58.8	58.785	58.8	68600.0
2004-03-31 18:00:00	IWM	ETF	58.8	58.825	58.8	58.825	2400.0
2004-03-31 08:00:00	DIA	ETF	104.24	104.25	104.09	104.11	7500.0
2004-03-31 09:00:00	DIA	ETF	104.1	104.1	103.58	103.77	782200.0
2004-03-31 10:00:00	DIA	ETF	103.75	103.75	103.29	103.61	1941800.0
2004-03-31 11:00:00	DIA	ETF	103.6	103.76	103.54	103.63	517500.0
2004-03-31 12:00:00	DIA	ETF	103.61	103.83	103.6	103.7	306900.0
2004-03-31 13:00:00	DIA	ETF	103.68	103.74	103.45	103.49	203300.0
2004-03-31 14:00:00	DIA	ETF	103.51	104.21	103.51	104.04	937600.0
2004-03-31 15:00:00	DIA	ETF	104.07	104.09	103.63	103.64	1319700.0
2004-03-31 16:00:00	DIA	ETF	103.66	103.99	103.62	103.95	314600.0
2004-03-31 17:00:00	DIA	ETF	103.94	103.94	103.94	103.94	1000.0
2004-03-31 18:00:00	DIA	ETF	103.88	103.88	103.88	103.88	500.0
2004-03-31 09:00:00	TLT	ETF	89.25	89.44	89.25	89.27	319800.0
2004-03-31 10:00:00	TLT	ETF	89.38	89.63	89.38	89.49	630600.0
2004-03-31 11:00:00	TLT	ETF	89.49	89.53	89.42	89.53	140700.0
2004-03-31 12:00:00	TLT	ETF	89.52	89.58	89.36	89.38	91500.0

> showing 50 of 698 rows — these rows as CSV

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