PREVIEW / etf_1hour / 2004-07-19

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-07-19.parquet
  size:    25 KB
  rows:    697

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-07-19 08:00:00	SPY	ETF	110.91	110.95	110.77	110.77	119400.0
2004-07-19 09:00:00	SPY	ETF	110.79	110.83	110.53	110.76	7169500.0
2004-07-19 10:00:00	SPY	ETF	110.76	110.9	110.5	110.72	4382200.0
2004-07-19 11:00:00	SPY	ETF	110.73	110.77	110.13	110.17	5427100.0
2004-07-19 12:00:00	SPY	ETF	110.17	110.31	110.01	110.27	3612300.0
2004-07-19 13:00:00	SPY	ETF	110.28	110.37	109.99	110.15	2780600.0
2004-07-19 14:00:00	SPY	ETF	110.14	110.96	110.1	110.71	7629400.0
2004-07-19 15:00:00	SPY	ETF	110.71	110.82	110.34	110.45	5644900.0
2004-07-19 16:00:00	SPY	ETF	110.47	110.49	110.19	110.2	666600.0
2004-07-19 17:00:00	SPY	ETF	110.19	110.27	110.19	110.25	39400.0
2004-07-19 18:00:00	SPY	ETF	110.24	110.24	110.23	110.24	700.0
2004-07-19 19:00:00	SPY	ETF	110.27	110.27	110.27	110.27	600.0
2004-07-19 08:00:00	QQQ	ETF	34.8	34.84	34.79	34.79	374500.0
2004-07-19 09:00:00	QQQ	ETF	34.79	34.93	34.71	34.87	12623100.0
2004-07-19 10:00:00	QQQ	ETF	34.87	34.902	34.67	34.77	13399000.0
2004-07-19 11:00:00	QQQ	ETF	34.78	34.81	34.52	34.55	12168700.0
2004-07-19 12:00:00	QQQ	ETF	34.55	34.611	34.47	34.61	11829700.0
2004-07-19 13:00:00	QQQ	ETF	34.6	34.67	34.49	34.55	8779800.0
2004-07-19 14:00:00	QQQ	ETF	34.549	34.97	34.53	34.88	25236300.0
2004-07-19 15:00:00	QQQ	ETF	34.88	34.9	34.72	34.731	16587400.0
2004-07-19 16:00:00	QQQ	ETF	34.731	34.76	34.58	34.6	3831300.0
2004-07-19 17:00:00	QQQ	ETF	34.609	34.64	34.6	34.62	101400.0
2004-07-19 18:00:00	QQQ	ETF	34.63	34.641	34.61	34.63	14500.0
2004-07-19 19:00:00	QQQ	ETF	34.63	34.64	34.6	34.64	4400.0
2004-07-19 08:00:00	IWM	ETF	55.485	55.485	55.485	55.485	400.0
2004-07-19 09:00:00	IWM	ETF	55.42	55.475	55.25	55.335	1951000.0
2004-07-19 10:00:00	IWM	ETF	55.33	55.475	55.055	55.25	4041600.0
2004-07-19 11:00:00	IWM	ETF	55.25	55.34	54.975	54.975	1766600.0
2004-07-19 12:00:00	IWM	ETF	54.985	55.04	54.825	54.95	1443400.0
2004-07-19 13:00:00	IWM	ETF	54.95	55.02	54.845	54.915	1665400.0
2004-07-19 14:00:00	IWM	ETF	54.895	55.5	54.865	55.415	4377800.0
2004-07-19 15:00:00	IWM	ETF	55.415	55.46	55.22	55.355	1598600.0
2004-07-19 16:00:00	IWM	ETF	55.345	55.35	55.18	55.22	220800.0
2004-07-19 08:00:00	DIA	ETF	101.71	101.71	101.63	101.65	26700.0
2004-07-19 09:00:00	DIA	ETF	101.64	101.67	101.43	101.56	1012200.0
2004-07-19 10:00:00	DIA	ETF	101.56	101.68	101.32	101.52	2279900.0
2004-07-19 11:00:00	DIA	ETF	101.53	101.55	100.91	100.97	1012300.0
2004-07-19 12:00:00	DIA	ETF	100.98	101.03	100.79	101.02	897700.0
2004-07-19 13:00:00	DIA	ETF	101.02	101.07	100.83	100.93	618900.0
2004-07-19 14:00:00	DIA	ETF	100.91	101.6	100.89	101.33	1884600.0
2004-07-19 15:00:00	DIA	ETF	101.33	101.38	100.95	101.06	1104900.0
2004-07-19 16:00:00	DIA	ETF	101.1	101.13	100.91	100.91	85200.0
2004-07-19 17:00:00	DIA	ETF	100.91	100.91	100.9	100.9	400.0
2004-07-19 18:00:00	DIA	ETF	100.91	100.91	100.91	100.91	200.0
2004-07-19 09:00:00	TLT	ETF	85.41	85.45	85.36	85.38	68900.0
2004-07-19 10:00:00	TLT	ETF	85.37	85.48	85.36	85.37	138100.0
2004-07-19 11:00:00	TLT	ETF	85.39	85.46	85.37	85.45	176400.0
2004-07-19 12:00:00	TLT	ETF	85.45	85.55	85.43	85.5	126400.0
2004-07-19 13:00:00	TLT	ETF	85.5	85.57	85.46	85.55	64200.0
2004-07-19 14:00:00	TLT	ETF	85.54	85.57	85.48	85.49	139900.0

> showing 50 of 697 rows — these rows as CSV

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