PREVIEW / etf_1hour / 2004-10-14

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-10-14.parquet
  size:    25 KB
  rows:    705

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-14 08:00:00	SPY	ETF	111.64	111.66	111.49	111.54	101400.0
2004-10-14 09:00:00	SPY	ETF	111.54	111.79	111.52	111.55	4894600.0
2004-10-14 10:00:00	SPY	ETF	111.55	111.93	111.49	111.5	7872200.0
2004-10-14 11:00:00	SPY	ETF	111.5	111.58	111.02	111.09	11214800.0
2004-10-14 12:00:00	SPY	ETF	111.1	111.24	110.95	111.01	7290700.0
2004-10-14 13:00:00	SPY	ETF	111.02	111.16	110.9	111.08	7566200.0
2004-10-14 14:00:00	SPY	ETF	111.08	111.1	110.71	110.78	4756000.0
2004-10-14 15:00:00	SPY	ETF	110.79	110.92	110.58	110.7	14992100.0
2004-10-14 16:00:00	SPY	ETF	110.71	110.77	110.61	110.7	2522000.0
2004-10-14 17:00:00	SPY	ETF	110.68	110.71	110.63	110.63	464500.0
2004-10-14 18:00:00	SPY	ETF	110.62	110.71	110.62	110.69	6000.0
2004-10-14 19:00:00	SPY	ETF	110.71	110.73	110.71	110.73	800.0
2004-10-14 08:00:00	QQQ	ETF	35.63	35.63	35.56	35.59	248000.0
2004-10-14 09:00:00	QQQ	ETF	35.59	35.76	35.54	35.55	11167900.0
2004-10-14 10:00:00	QQQ	ETF	35.55	35.78	35.54	35.549	17641600.0
2004-10-14 11:00:00	QQQ	ETF	35.549	35.61	35.4	35.46	16085000.0
2004-10-14 12:00:00	QQQ	ETF	35.46	35.54	35.41	35.439	9226000.0
2004-10-14 13:00:00	QQQ	ETF	35.438	35.54	35.4	35.52	9179600.0
2004-10-14 14:00:00	QQQ	ETF	35.52	35.52	35.379	35.43	10461000.0
2004-10-14 15:00:00	QQQ	ETF	35.43	35.51	35.33	35.43	18185000.0
2004-10-14 16:00:00	QQQ	ETF	35.44	35.49	35.39	35.43	3392800.0
2004-10-14 17:00:00	QQQ	ETF	35.43	35.46	35.39	35.4	85900.0
2004-10-14 18:00:00	QQQ	ETF	35.42	35.44	35.42	35.43	17400.0
2004-10-14 19:00:00	QQQ	ETF	35.42	35.44	35.42	35.44	2800.0
2004-10-14 08:00:00	IWM	ETF	56.675	56.705	56.54	56.605	17800.0
2004-10-14 09:00:00	IWM	ETF	56.675	56.77	56.52	56.535	1078400.0
2004-10-14 10:00:00	IWM	ETF	56.545	56.865	56.545	56.605	1677800.0
2004-10-14 11:00:00	IWM	ETF	56.6	56.675	56.435	56.53	2208800.0
2004-10-14 12:00:00	IWM	ETF	56.53	56.625	56.435	56.435	1868400.0
2004-10-14 13:00:00	IWM	ETF	56.435	56.61	56.36	56.595	1600000.0
2004-10-14 14:00:00	IWM	ETF	56.575	56.575	56.41	56.45	1966800.0
2004-10-14 15:00:00	IWM	ETF	56.445	56.49	56.25	56.3	2035000.0
2004-10-14 16:00:00	IWM	ETF	56.305	56.33	56.23	56.26	235200.0
2004-10-14 17:00:00	IWM	ETF	56.255	56.255	56.23	56.23	29200.0
2004-10-14 08:00:00	DIA	ETF	100.11	100.11	100.0	100.01	22100.0
2004-10-14 09:00:00	DIA	ETF	100.03	100.19	99.9	99.92	728900.0
2004-10-14 10:00:00	DIA	ETF	99.94	100.24	99.81	99.81	841000.0
2004-10-14 11:00:00	DIA	ETF	99.83	99.84	99.44	99.52	1413200.0
2004-10-14 12:00:00	DIA	ETF	99.51	99.61	99.35	99.37	913300.0
2004-10-14 13:00:00	DIA	ETF	99.35	99.52	99.22	99.46	723900.0
2004-10-14 14:00:00	DIA	ETF	99.44	99.45	99.17	99.2	1091000.0
2004-10-14 15:00:00	DIA	ETF	99.2	99.4	99.0	99.22	1635600.0
2004-10-14 16:00:00	DIA	ETF	99.23	99.25	99.1	99.25	195400.0
2004-10-14 17:00:00	DIA	ETF	99.11	99.11	99.01	99.01	2900.0
2004-10-14 18:00:00	DIA	ETF	99.21	99.23	99.21	99.23	1300.0
2004-10-14 08:00:00	TLT	ETF	88.65	88.65	88.65	88.65	1000.0
2004-10-14 09:00:00	TLT	ETF	88.52	88.54	88.41	88.54	16900.0
2004-10-14 10:00:00	TLT	ETF	88.55	88.57	88.42	88.57	130400.0
2004-10-14 11:00:00	TLT	ETF	88.57	88.79	88.57	88.79	112400.0
2004-10-14 12:00:00	TLT	ETF	88.74	88.88	88.74	88.84	88100.0

> showing 50 of 705 rows — these rows as CSV

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