PREVIEW / etf_1hour / 2004-05-10

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-05-10.parquet
  size:    26 KB
  rows:    720

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-10 08:00:00	SPY	ETF	109.16	109.35	109.11	109.33	173000.0
2004-05-10 09:00:00	SPY	ETF	109.32	109.79	109.18	109.27	8846500.0
2004-05-10 10:00:00	SPY	ETF	109.29	109.4	108.61	108.95	11985400.0
2004-05-10 11:00:00	SPY	ETF	108.97	108.99	108.36	108.75	9913100.0
2004-05-10 12:00:00	SPY	ETF	108.77	109.4	108.7	109.39	7419500.0
2004-05-10 13:00:00	SPY	ETF	109.39	109.53	108.9	108.96	5959700.0
2004-05-10 14:00:00	SPY	ETF	108.98	109.1	108.57	108.91	5035100.0
2004-05-10 15:00:00	SPY	ETF	108.92	109.2	108.52	109.13	8515100.0
2004-05-10 16:00:00	SPY	ETF	109.11	110.3044	108.83	108.89	2478600.0
2004-05-10 17:00:00	SPY	ETF	109.17	109.17	108.83	108.85	181700.0
2004-05-10 18:00:00	SPY	ETF	108.86	108.88	108.71	108.8	57900.0
2004-05-10 19:00:00	SPY	ETF	108.8	108.82	108.76	108.8	14700.0
2004-05-10 08:00:00	QQQ	ETF	34.56	34.65	34.53	34.61	482700.0
2004-05-10 09:00:00	QQQ	ETF	34.61	34.9	34.57	34.7	21671300.0
2004-05-10 10:00:00	QQQ	ETF	34.696	34.78	34.51	34.61	25809400.0
2004-05-10 11:00:00	QQQ	ETF	34.62	34.68	34.42	34.58	23329400.0
2004-05-10 12:00:00	QQQ	ETF	34.58	34.8	34.517	34.78	13731800.0
2004-05-10 13:00:00	QQQ	ETF	34.784	34.9	34.63	34.66	17916700.0
2004-05-10 14:00:00	QQQ	ETF	34.654	34.76	34.55	34.67	10273800.0
2004-05-10 15:00:00	QQQ	ETF	34.668	34.77	34.5	34.747	20217700.0
2004-05-10 16:00:00	QQQ	ETF	34.748	34.77	34.64	34.7	2700400.0
2004-05-10 17:00:00	QQQ	ETF	34.699	34.72	34.673	34.71	86400.0
2004-05-10 18:00:00	QQQ	ETF	34.71	34.71	34.651	34.66	162600.0
2004-05-10 19:00:00	QQQ	ETF	34.67	34.69	34.66	34.67	41100.0
2004-05-10 08:00:00	IWM	ETF	53.855	53.935	53.84	53.865	5200.0
2004-05-10 09:00:00	IWM	ETF	54.0	54.255	53.745	53.81	3192600.0
2004-05-10 10:00:00	IWM	ETF	53.81	53.925	53.395	53.51	4376400.0
2004-05-10 11:00:00	IWM	ETF	53.51	53.51	53.075	53.45	3864000.0
2004-05-10 12:00:00	IWM	ETF	53.45	54.105	53.43	54.105	2082600.0
2004-05-10 13:00:00	IWM	ETF	54.105	54.38	53.755	53.81	3223800.0
2004-05-10 14:00:00	IWM	ETF	53.805	53.865	53.605	53.76	2842600.0
2004-05-10 15:00:00	IWM	ETF	53.765	54.045	53.46	53.66	5004400.0
2004-05-10 16:00:00	IWM	ETF	53.64	53.68	53.435	53.46	597400.0
2004-05-10 17:00:00	IWM	ETF	53.465	53.54	53.465	53.54	3000.0
2004-05-10 18:00:00	IWM	ETF	53.51	53.51	53.51	53.51	400.0
2004-05-10 19:00:00	IWM	ETF	53.51	53.51	53.51	53.51	2000.0
2004-05-10 08:00:00	DIA	ETF	100.38	100.55	100.3	100.43	31900.0
2004-05-10 09:00:00	DIA	ETF	100.5	100.83	100.39	100.5	1047500.0
2004-05-10 10:00:00	DIA	ETF	100.5	100.6	99.93	100.21	2856600.0
2004-05-10 11:00:00	DIA	ETF	100.19	100.21	99.6	99.86	2679000.0
2004-05-10 12:00:00	DIA	ETF	99.88	100.47	99.85	100.46	1578200.0
2004-05-10 13:00:00	DIA	ETF	100.46	100.52	99.93	99.98	1134200.0
2004-05-10 14:00:00	DIA	ETF	100.0	100.13	99.62	99.94	1994500.0
2004-05-10 15:00:00	DIA	ETF	99.94	100.21	99.52	100.17	3378000.0
2004-05-10 16:00:00	DIA	ETF	100.16	100.16	99.9	99.9	123000.0
2004-05-10 17:00:00	DIA	ETF	99.9	99.9	99.9	99.9	100.0
2004-05-10 18:00:00	DIA	ETF	99.9	99.9	99.9	99.9	200.0
2004-05-10 08:00:00	TLT	ETF	81.28	81.34	81.28	81.34	10500.0
2004-05-10 09:00:00	TLT	ETF	81.48	81.61	81.44	81.55	144900.0
2004-05-10 10:00:00	TLT	ETF	81.55	81.55	81.17	81.27	178800.0

> showing 50 of 720 rows — these rows as CSV

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