PREVIEW / etf_1hour / 2004-08-26

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-08-26.parquet
  size:    23 KB
  rows:    671

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-08-26 08:00:00	SPY	ETF	111.1	111.1	110.96	110.99	112000.0
2004-08-26 09:00:00	SPY	ETF	111.0	111.19	110.85	111.1	3570900.0
2004-08-26 10:00:00	SPY	ETF	111.1	111.25	110.98	111.08	5087300.0
2004-08-26 11:00:00	SPY	ETF	111.09	111.17	110.97	111.01	3148000.0
2004-08-26 12:00:00	SPY	ETF	111.0	111.19	110.97	111.13	2052400.0
2004-08-26 13:00:00	SPY	ETF	111.13	111.13	110.97	111.03	1709100.0
2004-08-26 14:00:00	SPY	ETF	111.03	111.18	110.89	111.1	3901700.0
2004-08-26 15:00:00	SPY	ETF	111.09	111.31	111.07	111.16	4757800.0
2004-08-26 16:00:00	SPY	ETF	111.15	111.16	110.99	111.12	1357500.0
2004-08-26 17:00:00	SPY	ETF	111.16	111.18	111.1	111.13	110400.0
2004-08-26 18:00:00	SPY	ETF	111.14	111.14	111.14	111.14	1000.0
2004-08-26 08:00:00	QQQ	ETF	34.53	34.53	34.44	34.47	156500.0
2004-08-26 09:00:00	QQQ	ETF	34.47	34.54	34.39	34.486	9287700.0
2004-08-26 10:00:00	QQQ	ETF	34.485	34.55	34.33	34.38	12508000.0
2004-08-26 11:00:00	QQQ	ETF	34.384	34.47	34.36	34.38	6305100.0
2004-08-26 12:00:00	QQQ	ETF	34.37	34.49	34.37	34.44	4112600.0
2004-08-26 13:00:00	QQQ	ETF	34.444	34.45	34.337	34.36	5206900.0
2004-08-26 14:00:00	QQQ	ETF	34.36	34.468	34.31	34.42	6226100.0
2004-08-26 15:00:00	QQQ	ETF	34.42	34.54	34.394	34.4	9051500.0
2004-08-26 16:00:00	QQQ	ETF	34.41	34.51	34.311	34.5	2229900.0
2004-08-26 17:00:00	QQQ	ETF	34.49	34.51	33.49	34.47	1052700.0
2004-08-26 18:00:00	QQQ	ETF	34.471	34.48	34.46	34.48	42600.0
2004-08-26 19:00:00	QQQ	ETF	34.48	34.49	34.47	34.47	13000.0
2004-08-26 08:00:00	IWM	ETF	54.685	54.705	54.685	54.705	1600.0
2004-08-26 09:00:00	IWM	ETF	54.655	54.78	54.56	54.755	3071800.0
2004-08-26 10:00:00	IWM	ETF	54.775	54.865	54.635	54.7	1517000.0
2004-08-26 11:00:00	IWM	ETF	54.71	54.74	54.575	54.6	1035000.0
2004-08-26 12:00:00	IWM	ETF	54.6	54.71	54.59	54.66	611000.0
2004-08-26 13:00:00	IWM	ETF	54.645	54.645	54.44	54.455	762000.0
2004-08-26 14:00:00	IWM	ETF	54.485	54.59	54.4	54.525	638800.0
2004-08-26 15:00:00	IWM	ETF	54.525	54.685	54.465	54.485	1436600.0
2004-08-26 16:00:00	IWM	ETF	54.485	54.5	54.34	54.34	197200.0
2004-08-26 08:00:00	DIA	ETF	101.95	101.97	101.85	101.85	1000.0
2004-08-26 09:00:00	DIA	ETF	101.85	102.08	101.74	101.99	772400.0
2004-08-26 10:00:00	DIA	ETF	101.98	102.06	101.77	101.85	531100.0
2004-08-26 11:00:00	DIA	ETF	101.88	101.96	101.8	101.8	566700.0
2004-08-26 12:00:00	DIA	ETF	101.8	101.98	101.8	101.88	280200.0
2004-08-26 13:00:00	DIA	ETF	101.88	101.89	101.77	101.79	112100.0
2004-08-26 14:00:00	DIA	ETF	101.8	101.9529	101.68	101.86	671400.0
2004-08-26 15:00:00	DIA	ETF	101.83	102.01	101.78	101.86	1241600.0
2004-08-26 16:00:00	DIA	ETF	101.83	101.88	101.76	101.87	38500.0
2004-08-26 09:00:00	TLT	ETF	86.56	86.56	86.46	86.5	13800.0
2004-08-26 10:00:00	TLT	ETF	86.47	86.6	86.44	86.6	48000.0
2004-08-26 11:00:00	TLT	ETF	86.6	86.75	86.52	86.75	46900.0
2004-08-26 12:00:00	TLT	ETF	86.75	86.78	86.73	86.75	29700.0
2004-08-26 13:00:00	TLT	ETF	86.74	86.83	86.74	86.76	56200.0
2004-08-26 14:00:00	TLT	ETF	86.74	86.83	86.73	86.78	73700.0
2004-08-26 15:00:00	TLT	ETF	86.75	86.87	86.72	86.85	200700.0
2004-08-26 16:00:00	TLT	ETF	86.8	86.88	86.8	86.88	8000.0

> showing 49 of 671 rows — these rows as CSV

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