PREVIEW / etf_1hour / 2004-06-03

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-06-03.parquet
  size:    24 KB
  rows:    686

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-03 08:00:00	SPY	ETF	112.64	112.74	112.56	112.73	55000.0
2004-06-03 09:00:00	SPY	ETF	112.76	112.88	112.67	112.8	3467400.0
2004-06-03 10:00:00	SPY	ETF	112.8	112.93	112.51	112.7	5782100.0
2004-06-03 11:00:00	SPY	ETF	112.69	113.11	112.62	112.99	5527700.0
2004-06-03 12:00:00	SPY	ETF	112.99	113.19	112.93	112.95	4609400.0
2004-06-03 13:00:00	SPY	ETF	112.95	113.07	112.77	112.79	2846000.0
2004-06-03 14:00:00	SPY	ETF	112.78	112.82	112.48	112.71	3504000.0
2004-06-03 15:00:00	SPY	ETF	112.7	112.8	112.23	112.23	5152100.0
2004-06-03 16:00:00	SPY	ETF	112.25	113.1163	112.07	112.18	5668400.0
2004-06-03 17:00:00	SPY	ETF	112.2	112.31	112.17	112.31	247800.0
2004-06-03 18:00:00	SPY	ETF	112.32	112.33	112.21	112.23	22600.0
2004-06-03 19:00:00	SPY	ETF	112.21	112.25	112.2	112.2	800.0
2004-06-03 08:00:00	QQQ	ETF	36.3	36.3	36.2	36.29	367200.0
2004-06-03 09:00:00	QQQ	ETF	36.3	36.34	36.18	36.23	10328800.0
2004-06-03 10:00:00	QQQ	ETF	36.24	36.29	36.063	36.13	21637800.0
2004-06-03 11:00:00	QQQ	ETF	36.13	36.31	36.09	36.25	8760100.0
2004-06-03 12:00:00	QQQ	ETF	36.24	36.36	36.2	36.27	6033600.0
2004-06-03 13:00:00	QQQ	ETF	36.267	36.35	36.2	36.22	9711900.0
2004-06-03 14:00:00	QQQ	ETF	36.22	36.22	36.038	36.129	12913900.0
2004-06-03 15:00:00	QQQ	ETF	36.128	36.2	35.94	35.97	19264500.0
2004-06-03 16:00:00	QQQ	ETF	35.971	36.11	35.844	35.975	6923400.0
2004-06-03 17:00:00	QQQ	ETF	35.988	36.01	35.988	36.01	75300.0
2004-06-03 18:00:00	QQQ	ETF	35.99	36.03	35.95	35.96	371400.0
2004-06-03 19:00:00	QQQ	ETF	35.96	36.0	35.94	36.0	13400.0
2004-06-03 08:00:00	IWM	ETF	56.85	56.85	56.785	56.785	3000.0
2004-06-03 09:00:00	IWM	ETF	56.875	57.08	56.7	56.885	1683800.0
2004-06-03 10:00:00	IWM	ETF	56.865	56.885	56.41	56.655	1972000.0
2004-06-03 11:00:00	IWM	ETF	56.675	56.82	56.565	56.755	909200.0
2004-06-03 12:00:00	IWM	ETF	56.75	56.815	56.7	56.705	1120000.0
2004-06-03 13:00:00	IWM	ETF	56.71	56.8	56.595	56.625	1344000.0
2004-06-03 14:00:00	IWM	ETF	56.615	56.625	56.315	56.44	1148400.0
2004-06-03 15:00:00	IWM	ETF	56.44	56.5	56.075	56.105	2891600.0
2004-06-03 16:00:00	IWM	ETF	56.075	56.325	56.0	56.07	369800.0
2004-06-03 17:00:00	IWM	ETF	56.11	56.11	56.09	56.11	41400.0
2004-06-03 08:00:00	DIA	ETF	102.4	102.46	102.34	102.43	9500.0
2004-06-03 09:00:00	DIA	ETF	102.5	102.59	102.4	102.52	645100.0
2004-06-03 10:00:00	DIA	ETF	102.5	102.65	102.3	102.46	1351300.0
2004-06-03 11:00:00	DIA	ETF	102.46	102.92	102.41	102.88	1132600.0
2004-06-03 12:00:00	DIA	ETF	102.87	102.99	102.77	102.82	340200.0
2004-06-03 13:00:00	DIA	ETF	102.8	102.93	102.67	102.7	1723700.0
2004-06-03 14:00:00	DIA	ETF	102.67	102.67	102.3	102.55	510400.0
2004-06-03 15:00:00	DIA	ETF	102.52	102.6	102.11	102.13	725600.0
2004-06-03 16:00:00	DIA	ETF	102.15	102.22	101.97	102.14	152400.0
2004-06-03 17:00:00	DIA	ETF	102.18	102.18	102.18	102.18	700.0
2004-06-03 18:00:00	DIA	ETF	102.18	102.18	102.18	102.18	800.0
2004-06-03 09:00:00	TLT	ETF	81.8	81.8	81.59	81.61	257400.0
2004-06-03 10:00:00	TLT	ETF	81.71	81.79	81.68	81.78	18300.0
2004-06-03 11:00:00	TLT	ETF	81.79	82.0	81.79	81.97	323800.0
2004-06-03 12:00:00	TLT	ETF	81.95	82.05	81.95	82.01	42800.0
2004-06-03 13:00:00	TLT	ETF	82.01	82.04	81.94	81.95	131300.0

> showing 50 of 686 rows — these rows as CSV

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