PREVIEW / etf_1hour / 2004-05-28

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-05-28.parquet
  size:    24 KB
  rows:    686

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-28 08:00:00	SPY	ETF	112.63	112.9	112.52	112.88	252800.0
2004-05-28 09:00:00	SPY	ETF	112.89	112.89	112.48	112.56	3980700.0
2004-05-28 10:00:00	SPY	ETF	112.55	112.73	112.36	112.51	5673500.0
2004-05-28 11:00:00	SPY	ETF	112.52	112.71	112.48	112.54	1834400.0
2004-05-28 12:00:00	SPY	ETF	112.56	112.78	112.52	112.58	1380700.0
2004-05-28 13:00:00	SPY	ETF	112.57	112.65	112.44	112.55	1465100.0
2004-05-28 14:00:00	SPY	ETF	112.54	112.75	112.52	112.66	1220100.0
2004-05-28 15:00:00	SPY	ETF	112.67	112.87	112.51	112.71	3575000.0
2004-05-28 16:00:00	SPY	ETF	112.7	112.93	112.62	112.84	2756400.0
2004-05-28 17:00:00	SPY	ETF	112.8	112.86	112.8	112.86	2900.0
2004-05-28 18:00:00	SPY	ETF	112.86	112.89	112.86	112.86	2400.0
2004-05-28 19:00:00	SPY	ETF	112.86	112.9	112.86	112.9	1200.0
2004-05-28 08:00:00	QQQ	ETF	36.35	36.4	36.34	36.4	169800.0
2004-05-28 09:00:00	QQQ	ETF	36.39	36.42	36.25	36.26	8512100.0
2004-05-28 10:00:00	QQQ	ETF	36.258	36.37	36.21	36.28	10872600.0
2004-05-28 11:00:00	QQQ	ETF	36.288	36.43	36.27	36.38	7709600.0
2004-05-28 12:00:00	QQQ	ETF	36.39	36.51	36.37	36.43	6664500.0
2004-05-28 13:00:00	QQQ	ETF	36.429	36.45	36.32	36.382	4891900.0
2004-05-28 14:00:00	QQQ	ETF	36.385	36.48	36.38	36.445	4427700.0
2004-05-28 15:00:00	QQQ	ETF	36.44	36.543	36.4	36.54	9614100.0
2004-05-28 16:00:00	QQQ	ETF	36.54	36.56	36.48	36.54	1784200.0
2004-05-28 17:00:00	QQQ	ETF	36.549	36.56	36.54	36.56	27200.0
2004-05-28 18:00:00	QQQ	ETF	36.55	36.57	36.54	36.54	18000.0
2004-05-28 19:00:00	QQQ	ETF	36.57	36.6	36.55	36.55	18500.0
2004-05-28 08:00:00	IWM	ETF	56.575	56.635	56.575	56.635	3200.0
2004-05-28 09:00:00	IWM	ETF	56.6	56.72	56.515	56.605	1038000.0
2004-05-28 10:00:00	IWM	ETF	56.625	56.735	56.39	56.54	1204600.0
2004-05-28 11:00:00	IWM	ETF	56.555	56.705	56.525	56.565	428600.0
2004-05-28 12:00:00	IWM	ETF	56.56	56.705	56.53	56.585	389400.0
2004-05-28 13:00:00	IWM	ETF	56.605	56.69	56.58	56.625	636600.0
2004-05-28 14:00:00	IWM	ETF	56.64	56.85	56.625	56.775	517800.0
2004-05-28 15:00:00	IWM	ETF	56.775	56.8	56.64	56.675	1103400.0
2004-05-28 16:00:00	IWM	ETF	56.67	56.75	56.575	56.75	1141400.0
2004-05-28 08:00:00	DIA	ETF	102.05	102.34	102.05	102.3	9100.0
2004-05-28 09:00:00	DIA	ETF	102.36	102.36	102.0	102.02	530200.0
2004-05-28 10:00:00	DIA	ETF	102.1	102.2	101.85	101.96	827200.0
2004-05-28 11:00:00	DIA	ETF	102.0	102.12	101.9	101.98	560100.0
2004-05-28 12:00:00	DIA	ETF	101.95	102.12	101.93	101.95	138600.0
2004-05-28 13:00:00	DIA	ETF	101.98	102.03	101.84	101.95	315800.0
2004-05-28 14:00:00	DIA	ETF	101.94	102.08	101.93	102.01	215100.0
2004-05-28 15:00:00	DIA	ETF	102.02	102.18	101.86	102.05	1376400.0
2004-05-28 16:00:00	DIA	ETF	102.06	102.27	101.99	102.2	180100.0
2004-05-28 18:00:00	DIA	ETF	102.24	102.25	102.2	102.2	1800.0
2004-05-28 09:00:00	TLT	ETF	83.02	83.37	83.02	83.24	89100.0
2004-05-28 10:00:00	TLT	ETF	83.2	83.2	82.75	82.86	114600.0
2004-05-28 11:00:00	TLT	ETF	82.89	82.94	82.85	82.94	176900.0
2004-05-28 12:00:00	TLT	ETF	82.94	83.11	82.84	82.92	68100.0
2004-05-28 13:00:00	TLT	ETF	82.9	82.98	82.89	82.95	32800.0
2004-05-28 14:00:00	TLT	ETF	82.94	83.1	82.9	83.1	57500.0
2004-05-28 15:00:00	TLT	ETF	83.1	83.15	83.0	83.0	62300.0

> showing 50 of 686 rows — these rows as CSV

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