PREVIEW / etf_1hour / 2004-01-20

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-01-20.parquet
  size:    24 KB
  rows:    656

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-01-20 08:00:00	SPY	ETF	114.5	114.54	114.46	114.49	41300.0
2004-01-20 09:00:00	SPY	ETF	114.5	114.54	114.22	114.33	3609100.0
2004-01-20 10:00:00	SPY	ETF	114.35	114.65	113.99	114.16	7059800.0
2004-01-20 11:00:00	SPY	ETF	114.14	114.18	113.82	113.97	4693200.0
2004-01-20 12:00:00	SPY	ETF	113.98	114.23	113.96	114.03	2721400.0
2004-01-20 13:00:00	SPY	ETF	114.03	114.31	114.0	114.19	2019000.0
2004-01-20 14:00:00	SPY	ETF	114.19	114.35	114.03	114.35	2985000.0
2004-01-20 15:00:00	SPY	ETF	114.31	114.36	114.05	114.21	3233600.0
2004-01-20 16:00:00	SPY	ETF	114.23	114.45	114.09	114.16	2320400.0
2004-01-20 17:00:00	SPY	ETF	114.2	114.2	114.06	114.15	42200.0
2004-01-20 18:00:00	SPY	ETF	114.14	114.14	114.04	114.04	5900.0
2004-01-20 19:00:00	SPY	ETF	114.02	114.02	114.02	114.02	100.0
2004-01-20 08:00:00	QQQ	ETF	38.76	38.8	38.73	38.76	213100.0
2004-01-20 09:00:00	QQQ	ETF	38.75	38.85	38.51	38.6	14549600.0
2004-01-20 10:00:00	QQQ	ETF	38.58	38.72	38.4	38.5	14207100.0
2004-01-20 11:00:00	QQQ	ETF	38.503	38.54	38.31	38.444	9570200.0
2004-01-20 12:00:00	QQQ	ETF	38.441	38.58	38.43	38.5	5842600.0
2004-01-20 13:00:00	QQQ	ETF	38.507	38.66	38.5	38.603	5546700.0
2004-01-20 14:00:00	QQQ	ETF	38.604	38.674	38.49	38.674	7092800.0
2004-01-20 15:00:00	QQQ	ETF	38.67	38.68	38.52	38.66	9471400.0
2004-01-20 16:00:00	QQQ	ETF	38.65	38.71	38.45	38.48	8881700.0
2004-01-20 17:00:00	QQQ	ETF	38.48	38.51	38.41	38.45	638600.0
2004-01-20 18:00:00	QQQ	ETF	38.45	38.45	38.41	38.41	49900.0
2004-01-20 19:00:00	QQQ	ETF	38.44	38.46	38.42	38.46	10500.0
2004-01-20 09:00:00	IWM	ETF	58.96	59.225	58.95	59.125	555600.0
2004-01-20 10:00:00	IWM	ETF	59.09	59.2715	58.8735	58.962	1960800.0
2004-01-20 11:00:00	IWM	ETF	58.975	59.037	58.68	58.835	587600.0
2004-01-20 12:00:00	IWM	ETF	58.855	59.105	58.835	58.975	268400.0
2004-01-20 13:00:00	IWM	ETF	58.99	59.21	58.99	59.13	445200.0
2004-01-20 14:00:00	IWM	ETF	59.125	59.372	59.11	59.355	751000.0
2004-01-20 15:00:00	IWM	ETF	59.37	59.495	59.255	59.465	1484800.0
2004-01-20 16:00:00	IWM	ETF	59.47	59.565	59.408	59.408	787200.0
2004-01-20 17:00:00	IWM	ETF	59.415	59.415	59.415	59.415	200.0
2004-01-20 08:00:00	DIA	ETF	106.4	106.45	106.35	106.38	5000.0
2004-01-20 09:00:00	DIA	ETF	106.43	106.47	105.9	105.9	1056100.0
2004-01-20 10:00:00	DIA	ETF	105.88	106.08	105.54	105.68	2142400.0
2004-01-20 11:00:00	DIA	ETF	105.71	105.73	105.36	105.42	1435600.0
2004-01-20 12:00:00	DIA	ETF	105.44	105.64	105.4	105.45	615300.0
2004-01-20 13:00:00	DIA	ETF	105.41	105.73	105.41	105.598	452100.0
2004-01-20 14:00:00	DIA	ETF	105.6	105.71	105.48	105.62	750900.0
2004-01-20 15:00:00	DIA	ETF	105.64	105.69	105.3	105.54	1190900.0
2004-01-20 16:00:00	DIA	ETF	105.536	105.6917	105.4	105.46	92200.0
2004-01-20 17:00:00	DIA	ETF	105.42	105.43	105.4	105.43	1700.0
2004-01-20 18:00:00	DIA	ETF	105.42	105.53	105.42	105.46	1600.0
2004-01-20 09:00:00	TLT	ETF	87.5	87.7	87.5	87.6	54300.0
2004-01-20 10:00:00	TLT	ETF	87.6	87.9	87.57	87.73	112800.0
2004-01-20 11:00:00	TLT	ETF	87.73	87.93	87.71	87.91	111100.0
2004-01-20 12:00:00	TLT	ETF	87.91	87.92	87.85	87.86	34900.0
2004-01-20 13:00:00	TLT	ETF	87.87	87.88	87.75	87.8	13600.0
2004-01-20 14:00:00	TLT	ETF	87.75	87.8	87.52	87.56	79400.0

> showing 50 of 656 rows — these rows as CSV

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