PREVIEW / etf_1hour / 2004-05-18

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-05-18.parquet
  size:    24 KB
  rows:    684

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-18 08:00:00	SPY	ETF	109.68	109.78	109.55	109.61	105800.0
2004-05-18 09:00:00	SPY	ETF	109.61	109.72	109.33	109.44	4539700.0
2004-05-18 10:00:00	SPY	ETF	109.46	109.9	109.34	109.78	5215400.0
2004-05-18 11:00:00	SPY	ETF	109.78	109.89	109.64	109.72	3445100.0
2004-05-18 12:00:00	SPY	ETF	109.73	109.94	109.69	109.76	2671900.0
2004-05-18 13:00:00	SPY	ETF	109.76	109.85	109.54	109.56	2508500.0
2004-05-18 14:00:00	SPY	ETF	109.56	109.87	109.51	109.67	3031400.0
2004-05-18 15:00:00	SPY	ETF	109.68	109.81	109.6	109.69	4674500.0
2004-05-18 16:00:00	SPY	ETF	109.69	109.77	109.56	109.62	1966700.0
2004-05-18 17:00:00	SPY	ETF	109.66	109.72	109.6	109.7	33500.0
2004-05-18 18:00:00	SPY	ETF	109.7	109.7	109.64	109.65	6100.0
2004-05-18 19:00:00	SPY	ETF	109.72	109.74	109.69	109.74	3400.0
2004-05-18 08:00:00	QQQ	ETF	34.66	34.73	34.64	34.66	311700.0
2004-05-18 09:00:00	QQQ	ETF	34.65	34.78	34.6	34.684	15771800.0
2004-05-18 10:00:00	QQQ	ETF	34.68	34.82	34.62	34.78	19371200.0
2004-05-18 11:00:00	QQQ	ETF	34.77	34.827	34.72	34.775	9030800.0
2004-05-18 12:00:00	QQQ	ETF	34.77	34.9	34.74	34.81	9484000.0
2004-05-18 13:00:00	QQQ	ETF	34.81	34.84	34.68	34.69	7445300.0
2004-05-18 14:00:00	QQQ	ETF	34.7	34.83	34.67	34.74	10802600.0
2004-05-18 15:00:00	QQQ	ETF	34.74	34.83	34.7	34.763	14680100.0
2004-05-18 16:00:00	QQQ	ETF	34.77	34.87	34.665	34.76	7879700.0
2004-05-18 17:00:00	QQQ	ETF	34.76	34.83	34.76	34.8	65300.0
2004-05-18 18:00:00	QQQ	ETF	34.806	34.82	34.8	34.8	24500.0
2004-05-18 19:00:00	QQQ	ETF	34.8	34.83	34.8	34.81	13100.0
2004-05-18 08:00:00	IWM	ETF	54.01	54.03	53.95	53.95	6600.0
2004-05-18 09:00:00	IWM	ETF	53.93	53.99	53.515	53.605	1902000.0
2004-05-18 10:00:00	IWM	ETF	53.67	53.895	53.59	53.82	1053600.0
2004-05-18 11:00:00	IWM	ETF	53.83	53.915	53.76	53.795	591200.0
2004-05-18 12:00:00	IWM	ETF	53.805	53.985	53.795	53.925	1109800.0
2004-05-18 13:00:00	IWM	ETF	53.915	53.945	53.79	53.8	1084800.0
2004-05-18 14:00:00	IWM	ETF	53.75	53.88	53.725	53.805	2032200.0
2004-05-18 15:00:00	IWM	ETF	53.825	54.09	53.76	54.08	2518600.0
2004-05-18 16:00:00	IWM	ETF	54.085	54.205	54.055	54.1157	2463400.0
2004-05-18 17:00:00	IWM	ETF	54.1	54.1	54.1	54.1	200.0
2004-05-18 19:00:00	IWM	ETF	54.175	54.175	54.175	54.175	1000.0
2004-05-18 08:00:00	DIA	ETF	100.03	100.12	99.91	99.94	11900.0
2004-05-18 09:00:00	DIA	ETF	99.95	100.0	99.6	99.68	1335500.0
2004-05-18 10:00:00	DIA	ETF	99.73	100.14	99.67	100.03	1543400.0
2004-05-18 11:00:00	DIA	ETF	100.03	100.14	99.9	100.07	620000.0
2004-05-18 12:00:00	DIA	ETF	100.07	100.24	100.0	100.05	308900.0
2004-05-18 13:00:00	DIA	ETF	100.06	100.12	99.85	99.86	731400.0
2004-05-18 14:00:00	DIA	ETF	99.84	100.16	99.84	100.03	324600.0
2004-05-18 15:00:00	DIA	ETF	100.03	100.18	99.96	100.05	1009300.0
2004-05-18 16:00:00	DIA	ETF	100.06	100.13	99.94	100.02	393900.0
2004-05-18 17:00:00	DIA	ETF	100.0	100.0	100.0	100.0	300.0
2004-05-18 18:00:00	DIA	ETF	100.0	100.0	100.0	100.0	1800.0
2004-05-18 19:00:00	DIA	ETF	100.0	100.07	100.0	100.07	1100.0
2004-05-18 08:00:00	TLT	ETF	81.7	81.7	81.6	81.6	5600.0
2004-05-18 09:00:00	TLT	ETF	81.7	81.77	81.57	81.65	76200.0
2004-05-18 10:00:00	TLT	ETF	81.69	81.79	81.68	81.7	58200.0

> showing 50 of 684 rows — these rows as CSV

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