PREVIEW / etf_1hour / 2004-10-06

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-10-06.parquet
  size:    25 KB
  rows:    708

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-06 08:00:00	SPY	ETF	113.8	113.89	113.79	113.87	25600.0
2004-10-06 09:00:00	SPY	ETF	113.86	113.94	113.69	113.76	4329500.0
2004-10-06 10:00:00	SPY	ETF	113.77	114.03	113.68	113.76	8672600.0
2004-10-06 11:00:00	SPY	ETF	113.73	113.96	113.71	113.88	6106700.0
2004-10-06 12:00:00	SPY	ETF	113.9	114.15	113.87	113.99	3742500.0
2004-10-06 13:00:00	SPY	ETF	114.0	114.065	113.86	113.92	2210600.0
2004-10-06 14:00:00	SPY	ETF	113.92	114.08	113.88	113.96	3008200.0
2004-10-06 15:00:00	SPY	ETF	113.95	114.6	113.94	114.57	10373300.0
2004-10-06 16:00:00	SPY	ETF	114.57	114.68	113.948	114.61	1649000.0
2004-10-06 17:00:00	SPY	ETF	114.57	114.62	114.54	114.6	118800.0
2004-10-06 18:00:00	SPY	ETF	114.59	114.61	114.57	114.58	2900.0
2004-10-06 19:00:00	SPY	ETF	114.58	114.58	114.58	114.58	100.0
2004-10-06 08:00:00	QQQ	ETF	36.35	36.36	36.32	36.35	116700.0
2004-10-06 09:00:00	QQQ	ETF	36.35	36.35	36.119	36.15	12046000.0
2004-10-06 10:00:00	QQQ	ETF	36.15	36.31	36.11	36.18	15151600.0
2004-10-06 11:00:00	QQQ	ETF	36.18	36.33	36.16	36.29	8282700.0
2004-10-06 12:00:00	QQQ	ETF	36.278	36.43	36.26	36.35	10391100.0
2004-10-06 13:00:00	QQQ	ETF	36.36	36.4	36.28	36.3	5146200.0
2004-10-06 14:00:00	QQQ	ETF	36.299	36.39	36.25	36.311	8668100.0
2004-10-06 15:00:00	QQQ	ETF	36.31	36.65	36.299	36.63	21542500.0
2004-10-06 16:00:00	QQQ	ETF	36.64	36.71	36.62	36.66	3637800.0
2004-10-06 17:00:00	QQQ	ETF	36.65	36.68	36.63	36.66	185600.0
2004-10-06 18:00:00	QQQ	ETF	36.67	36.68	36.56	36.66	131800.0
2004-10-06 19:00:00	QQQ	ETF	36.69	36.69	36.67	36.68	3800.0
2004-10-06 09:00:00	IWM	ETF	58.56	58.73	58.47	58.475	1168800.0
2004-10-06 10:00:00	IWM	ETF	58.475	58.625	58.44	58.5	1093000.0
2004-10-06 11:00:00	IWM	ETF	58.49	58.675	58.465	58.66	1065200.0
2004-10-06 12:00:00	IWM	ETF	58.63	58.89	58.63	58.785	1058200.0
2004-10-06 13:00:00	IWM	ETF	58.785	58.82	58.715	58.755	441600.0
2004-10-06 14:00:00	IWM	ETF	58.76	58.835	58.6	58.7092	609400.0
2004-10-06 15:00:00	IWM	ETF	58.715	59.13	58.715	59.13	3278200.0
2004-10-06 16:00:00	IWM	ETF	59.125	59.125	58.975	58.98	464200.0
2004-10-06 17:00:00	IWM	ETF	59.07	59.07	59.07	59.07	16400.0
2004-10-06 18:00:00	IWM	ETF	58.965	58.965	58.965	58.965	6000.0
2004-10-06 08:00:00	DIA	ETF	101.95	101.95	101.94	101.94	1500.0
2004-10-06 09:00:00	DIA	ETF	101.9	102.07	101.82	101.88	601500.0
2004-10-06 10:00:00	DIA	ETF	101.85	102.11	101.79	101.84	812400.0
2004-10-06 11:00:00	DIA	ETF	101.83	102.0	101.83	101.94	686000.0
2004-10-06 12:00:00	DIA	ETF	101.93	102.15	101.93	102.04	486600.0
2004-10-06 13:00:00	DIA	ETF	102.03	102.07	101.92	102.02	417000.0
2004-10-06 14:00:00	DIA	ETF	102.04	102.15	102.01	102.08	545000.0
2004-10-06 15:00:00	DIA	ETF	102.06	102.6	102.06	102.59	1450300.0
2004-10-06 16:00:00	DIA	ETF	102.58	102.65	102.56	102.64	162700.0
2004-10-06 17:00:00	DIA	ETF	102.67	102.67	102.67	102.67	100.0
2004-10-06 19:00:00	DIA	ETF	102.69	102.69	102.69	102.69	900.0
2004-10-06 09:00:00	TLT	ETF	87.45	87.45	87.28	87.4	31500.0
2004-10-06 10:00:00	TLT	ETF	87.41	87.47	87.28	87.45	125400.0
2004-10-06 11:00:00	TLT	ETF	87.44	87.44	87.3	87.32	35400.0
2004-10-06 12:00:00	TLT	ETF	87.33	87.35	87.22	87.22	126000.0
2004-10-06 13:00:00	TLT	ETF	87.23	87.23	87.1	87.19	92600.0

> showing 50 of 708 rows — these rows as CSV

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