PREVIEW / etf_1hour / 2004-06-30

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-06-30.parquet
  size:    25 KB
  rows:    693

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-06-30 08:00:00	SPY	ETF	114.04	114.1	114.01	114.07	65500.0
2004-06-30 09:00:00	SPY	ETF	114.02	114.2	113.93	114.11	3366500.0
2004-06-30 10:00:00	SPY	ETF	114.12	114.12	113.84	114.01	5467800.0
2004-06-30 11:00:00	SPY	ETF	114.01	114.03	113.65	113.78	3334900.0
2004-06-30 12:00:00	SPY	ETF	113.77	113.88	113.7	113.83	1966300.0
2004-06-30 13:00:00	SPY	ETF	113.82	113.93	113.7	113.75	4300400.0
2004-06-30 14:00:00	SPY	ETF	113.74	114.34	113.72	114.27	12427300.0
2004-06-30 15:00:00	SPY	ETF	114.27	114.79	114.13	114.45	10408600.0
2004-06-30 16:00:00	SPY	ETF	114.42	114.59	114.35	114.39	6072100.0
2004-06-30 17:00:00	SPY	ETF	114.39	114.43	114.37	114.39	192300.0
2004-06-30 18:00:00	SPY	ETF	114.43	114.45	114.39	114.45	307600.0
2004-06-30 08:00:00	QQQ	ETF	37.47	37.47	37.45	37.45	57700.0
2004-06-30 09:00:00	QQQ	ETF	37.44	37.56	37.403	37.5	11696400.0
2004-06-30 10:00:00	QQQ	ETF	37.512	37.515	37.37	37.45	11507800.0
2004-06-30 11:00:00	QQQ	ETF	37.45	37.47	37.35	37.4	7486200.0
2004-06-30 12:00:00	QQQ	ETF	37.41	37.44	37.3715	37.41	2729800.0
2004-06-30 13:00:00	QQQ	ETF	37.41	37.49	37.39	37.46	4504600.0
2004-06-30 14:00:00	QQQ	ETF	37.44	37.65	37.44	37.571	25313000.0
2004-06-30 15:00:00	QQQ	ETF	37.58	37.9	37.5	37.74	28176600.0
2004-06-30 16:00:00	QQQ	ETF	37.725	37.78	37.68	37.73	3490800.0
2004-06-30 17:00:00	QQQ	ETF	37.72	37.74	37.692	37.73	149100.0
2004-06-30 18:00:00	QQQ	ETF	37.73	37.76	37.71	37.74	23900.0
2004-06-30 19:00:00	QQQ	ETF	37.74	37.77	37.72	37.74	20700.0
2004-06-30 08:00:00	IWM	ETF	58.71	58.72	58.71	58.72	7000.0
2004-06-30 09:00:00	IWM	ETF	58.66	58.96	58.66	58.765	317200.0
2004-06-30 10:00:00	IWM	ETF	58.765	58.765	58.52	58.685	867000.0
2004-06-30 11:00:00	IWM	ETF	58.68	58.7	58.535	58.63	450400.0
2004-06-30 12:00:00	IWM	ETF	58.615	58.72	58.595	58.675	747200.0
2004-06-30 13:00:00	IWM	ETF	58.65	58.745	58.625	58.645	654000.0
2004-06-30 14:00:00	IWM	ETF	58.64	58.96	58.625	58.8843	3176600.0
2004-06-30 15:00:00	IWM	ETF	58.875	58.995	58.78	58.88	2634400.0
2004-06-30 16:00:00	IWM	ETF	58.84	58.995	58.59	58.875	774000.0
2004-06-30 17:00:00	IWM	ETF	58.925	59.025	58.925	59.025	125000.0
2004-06-30 18:00:00	IWM	ETF	58.925	58.925	58.925	58.925	54600.0
2004-06-30 08:00:00	DIA	ETF	104.39	104.39	104.37	104.38	8000.0
2004-06-30 09:00:00	DIA	ETF	104.33	104.46	104.21	104.43	475300.0
2004-06-30 10:00:00	DIA	ETF	104.42	104.42	104.17	104.23	588100.0
2004-06-30 11:00:00	DIA	ETF	104.22	104.25	103.89	104.0184	835900.0
2004-06-30 12:00:00	DIA	ETF	104.02	104.09	103.95	104.04	223600.0
2004-06-30 13:00:00	DIA	ETF	104.04	104.17	104.0	104.02	266400.0
2004-06-30 14:00:00	DIA	ETF	104.02	104.59	103.98	104.51	2007400.0
2004-06-30 15:00:00	DIA	ETF	104.52	104.89	104.38	104.52	1773400.0
2004-06-30 16:00:00	DIA	ETF	104.57	104.63	104.47	104.56	191300.0
2004-06-30 17:00:00	DIA	ETF	104.55	104.55	104.55	104.55	100.0
2004-06-30 09:00:00	TLT	ETF	83.03	83.08	82.91	83.0	73800.0
2004-06-30 10:00:00	TLT	ETF	83.02	83.52	83.02	83.47	135000.0
2004-06-30 11:00:00	TLT	ETF	83.5	83.59	83.36	83.5	202400.0
2004-06-30 12:00:00	TLT	ETF	83.5	83.54	83.44	83.44	33000.0
2004-06-30 13:00:00	TLT	ETF	83.44	83.48	83.36	83.46	27300.0
2004-06-30 14:00:00	TLT	ETF	83.5	83.75	83.25	83.5	887100.0

> showing 50 of 693 rows — these rows as CSV

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