PREVIEW / etf_1hour / 2004-05-25

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-05-25.parquet
  size:    25 KB
  rows:    687

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-05-25 08:00:00	SPY	ETF	109.88	109.98	109.88	109.96	123400.0
2004-05-25 09:00:00	SPY	ETF	109.95	110.0	109.66	109.71	3396900.0
2004-05-25 10:00:00	SPY	ETF	109.71	110.45	109.6	110.26	10964600.0
2004-05-25 11:00:00	SPY	ETF	110.27	110.49	110.09	110.36	4262700.0
2004-05-25 12:00:00	SPY	ETF	110.37	110.97	110.34	110.93	4412500.0
2004-05-25 13:00:00	SPY	ETF	110.94	111.48	110.9	111.33	6761000.0
2004-05-25 14:00:00	SPY	ETF	111.33	111.43	111.14	111.34	5427000.0
2004-05-25 15:00:00	SPY	ETF	111.35	111.98	111.27	111.92	7686100.0
2004-05-25 16:00:00	SPY	ETF	111.9	111.95	111.75	111.82	2176600.0
2004-05-25 17:00:00	SPY	ETF	111.85	111.88	111.81	111.88	6600.0
2004-05-25 18:00:00	SPY	ETF	111.84	111.88	110.0852	111.88	3047200.0
2004-05-25 19:00:00	SPY	ETF	111.88	111.9	111.76	111.78	3500.0
2004-05-25 08:00:00	QQQ	ETF	35.08	35.16	35.07	35.14	240400.0
2004-05-25 09:00:00	QQQ	ETF	35.13	35.17	35.03	35.06	9894700.0
2004-05-25 10:00:00	QQQ	ETF	35.06	35.28	34.949	35.17	20128000.0
2004-05-25 11:00:00	QQQ	ETF	35.16	35.277	35.06	35.24	9545300.0
2004-05-25 12:00:00	QQQ	ETF	35.25	35.5	35.21	35.5	21974300.0
2004-05-25 13:00:00	QQQ	ETF	35.5	35.75	35.43	35.68	24152600.0
2004-05-25 14:00:00	QQQ	ETF	35.68	35.735	35.608	35.72	16313000.0
2004-05-25 15:00:00	QQQ	ETF	35.72	36.08	35.71	36.02	27614400.0
2004-05-25 16:00:00	QQQ	ETF	36.02	36.04	35.92	35.94	4628800.0
2004-05-25 17:00:00	QQQ	ETF	35.94	35.99	35.93	35.96	298900.0
2004-05-25 18:00:00	QQQ	ETF	35.96	36.025	35.96	36.0	60900.0
2004-05-25 19:00:00	QQQ	ETF	35.96	35.96	35.88	35.93	49600.0
2004-05-25 08:00:00	IWM	ETF	55.005	55.01	55.005	55.01	4000.0
2004-05-25 09:00:00	IWM	ETF	55.025	55.125	54.81	54.965	1765600.0
2004-05-25 10:00:00	IWM	ETF	54.94	55.505	54.87	55.215	3316000.0
2004-05-25 11:00:00	IWM	ETF	55.23	55.53	55.115	55.485	833800.0
2004-05-25 12:00:00	IWM	ETF	55.465	55.86	55.445	55.805	1249000.0
2004-05-25 13:00:00	IWM	ETF	55.805	56.1	55.795	55.96	2053400.0
2004-05-25 14:00:00	IWM	ETF	55.96	56.04	55.855	55.975	1049200.0
2004-05-25 15:00:00	IWM	ETF	56.015	56.46	55.985	56.4	3220200.0
2004-05-25 16:00:00	IWM	ETF	56.335	56.39	56.175	56.175	915200.0
2004-05-25 17:00:00	IWM	ETF	56.275	56.39	56.275	56.39	74400.0
2004-05-25 08:00:00	DIA	ETF	99.58	99.59	99.5	99.53	15200.0
2004-05-25 09:00:00	DIA	ETF	99.54	99.62	99.29	99.38	689400.0
2004-05-25 10:00:00	DIA	ETF	99.32	100.02	99.26	99.87	1291600.0
2004-05-25 11:00:00	DIA	ETF	99.83	100.04	99.74	99.94	355600.0
2004-05-25 12:00:00	DIA	ETF	99.92	100.46	99.88	100.42	1061200.0
2004-05-25 13:00:00	DIA	ETF	100.42	100.94	100.4	100.77	1637000.0
2004-05-25 14:00:00	DIA	ETF	100.76	100.82	100.57	100.79	1905000.0
2004-05-25 15:00:00	DIA	ETF	100.79	101.35	100.74	101.31	1230800.0
2004-05-25 16:00:00	DIA	ETF	101.35	101.35	99.7127	101.26	744300.0
2004-05-25 17:00:00	DIA	ETF	101.3	101.39	101.2	101.2	2000.0
2004-05-25 18:00:00	DIA	ETF	101.25	101.25	101.25	101.25	100.0
2004-05-25 19:00:00	DIA	ETF	101.2	101.2	101.2	101.2	200.0
2004-05-25 09:00:00	TLT	ETF	82.03	82.22	82.03	82.16	50400.0
2004-05-25 10:00:00	TLT	ETF	82.23	82.32	82.07	82.07	102600.0
2004-05-25 11:00:00	TLT	ETF	82.06	82.23	82.01	82.23	25700.0
2004-05-25 12:00:00	TLT	ETF	82.22	82.32	82.22	82.27	224000.0

> showing 50 of 687 rows — these rows as CSV

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