PREVIEW / etf_1hour / 2004-06-17

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-06-17.parquet
  size:    24 KB
  rows:    667

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-17 08:00:00	SPY	ETF	114.02	114.1	113.9	113.92	175400.0
2004-06-17 09:00:00	SPY	ETF	113.91	113.93	113.48	113.53	4231500.0
2004-06-17 10:00:00	SPY	ETF	113.53	113.62	113.33	113.57	5728700.0
2004-06-17 11:00:00	SPY	ETF	113.58	113.85	113.48	113.71	3895300.0
2004-06-17 12:00:00	SPY	ETF	113.72	113.82	113.645	113.71	2085100.0
2004-06-17 13:00:00	SPY	ETF	113.71	113.98	113.67	113.87	2601300.0
2004-06-17 14:00:00	SPY	ETF	113.88	114.07	113.68	113.73	3634200.0
2004-06-17 15:00:00	SPY	ETF	113.72	113.99	113.71	113.85	3076600.0
2004-06-17 16:00:00	SPY	ETF	113.86	113.91	113.43	113.77	1567400.0
2004-06-17 17:00:00	SPY	ETF	113.75	113.76	113.71	113.71	104300.0
2004-06-17 18:00:00	SPY	ETF	113.77	113.8	113.74	113.78	68800.0
2004-06-17 19:00:00	SPY	ETF	113.73	113.73	113.73	113.73	200.0
2004-06-17 08:00:00	QQQ	ETF	36.7	36.72	36.62	36.66	230800.0
2004-06-17 09:00:00	QQQ	ETF	36.65	36.67	36.38	36.42	15350800.0
2004-06-17 10:00:00	QQQ	ETF	36.41	36.42	36.25	36.39	16415600.0
2004-06-17 11:00:00	QQQ	ETF	36.387	36.48	36.34	36.4	9935300.0
2004-06-17 12:00:00	QQQ	ETF	36.4	36.45	36.328	36.38	5592400.0
2004-06-17 13:00:00	QQQ	ETF	36.39	36.46	36.35	36.4077	7228100.0
2004-06-17 14:00:00	QQQ	ETF	36.4	36.48	36.32	36.33	10080300.0
2004-06-17 15:00:00	QQQ	ETF	36.33	36.42	36.32	36.4	9455900.0
2004-06-17 16:00:00	QQQ	ETF	36.4	36.425	36.35	36.38	2388100.0
2004-06-17 17:00:00	QQQ	ETF	36.37	36.42	36.355	36.4	310500.0
2004-06-17 18:00:00	QQQ	ETF	36.4	36.4	36.39	36.39	10200.0
2004-06-17 19:00:00	QQQ	ETF	36.39	36.41	36.39	36.41	1700.0
2004-06-17 08:00:00	IWM	ETF	56.8	56.8	56.8	56.8	1000.0
2004-06-17 09:00:00	IWM	ETF	56.775	56.85	56.34	56.4	806400.0
2004-06-17 10:00:00	IWM	ETF	56.405	56.67	56.33	56.64	2107200.0
2004-06-17 11:00:00	IWM	ETF	56.645	56.85	56.585	56.72	699400.0
2004-06-17 12:00:00	IWM	ETF	56.725	56.8	56.655	56.78	387000.0
2004-06-17 13:00:00	IWM	ETF	56.765	56.975	56.755	56.915	883000.0
2004-06-17 14:00:00	IWM	ETF	56.93	57.04	56.725	56.765	811600.0
2004-06-17 15:00:00	IWM	ETF	56.735	56.87	56.715	56.825	1838200.0
2004-06-17 16:00:00	IWM	ETF	56.8	56.845	56.6534	56.6534	6231000.0
2004-06-17 08:00:00	DIA	ETF	104.0	104.0	103.89	103.98	23000.0
2004-06-17 09:00:00	DIA	ETF	103.88	103.95	103.65	103.7	494700.0
2004-06-17 10:00:00	DIA	ETF	103.69	103.79	103.59	103.75	487100.0
2004-06-17 11:00:00	DIA	ETF	103.74	103.95	103.69	103.9	314300.0
2004-06-17 12:00:00	DIA	ETF	103.9	103.96	103.83	103.84	125800.0
2004-06-17 13:00:00	DIA	ETF	103.84	104.06	103.82	104.03	257100.0
2004-06-17 14:00:00	DIA	ETF	104.03	104.13	103.85	103.87	529300.0
2004-06-17 15:00:00	DIA	ETF	103.85	104.09	103.84	103.95	398900.0
2004-06-17 16:00:00	DIA	ETF	103.96	104.01	103.87	103.95	64000.0
2004-06-17 17:00:00	DIA	ETF	103.94	104.0	103.91	104.0	1000.0
2004-06-17 18:00:00	DIA	ETF	103.92	103.92	103.92	103.92	200.0
2004-06-17 08:00:00	TLT	ETF	82.1	82.1	82.1	82.1	7500.0
2004-06-17 09:00:00	TLT	ETF	82.11	82.11	82.0	82.11	15400.0
2004-06-17 10:00:00	TLT	ETF	82.11	82.17	81.97	82.08	57300.0
2004-06-17 11:00:00	TLT	ETF	82.14	82.27	82.14	82.2	27400.0
2004-06-17 12:00:00	TLT	ETF	82.16	82.44	82.16	82.43	12700.0
2004-06-17 13:00:00	TLT	ETF	82.42	82.64	82.4	82.6	112100.0

> showing 50 of 667 rows — these rows as CSV

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