PREVIEW / etf_1hour / 2004-05-24

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-05-24.parquet
  size:    25 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-05-24 08:00:00	SPY	ETF	110.47	110.56	110.44	110.45	128300.0
2004-05-24 09:00:00	SPY	ETF	110.49	110.76	110.34	110.57	4720400.0
2004-05-24 10:00:00	SPY	ETF	110.55	110.64	110.1	110.42	8328800.0
2004-05-24 11:00:00	SPY	ETF	110.42	110.45	109.74	109.92	8414900.0
2004-05-24 12:00:00	SPY	ETF	109.93	110.03	109.68	109.73	4772600.0
2004-05-24 13:00:00	SPY	ETF	109.75	110.275	109.73	110.09	3873400.0
2004-05-24 14:00:00	SPY	ETF	110.08	110.17	109.78	109.97	2466200.0
2004-05-24 15:00:00	SPY	ETF	109.98	110.31	109.92	110.09	4456600.0
2004-05-24 16:00:00	SPY	ETF	110.08	110.49	109.02	110.36	1784600.0
2004-05-24 17:00:00	SPY	ETF	110.34	110.35	110.26	110.28	37300.0
2004-05-24 18:00:00	SPY	ETF	110.27	110.27	110.26	110.26	1000.0
2004-05-24 19:00:00	SPY	ETF	110.25	110.25	110.25	110.25	400.0
2004-05-24 08:00:00	QQQ	ETF	35.26	35.34	35.25	35.32	576700.0
2004-05-24 09:00:00	QQQ	ETF	35.32	35.46	35.26	35.38	17234900.0
2004-05-24 10:00:00	QQQ	ETF	35.37	35.43	35.229	35.372	18276200.0
2004-05-24 11:00:00	QQQ	ETF	35.387	35.4	35.0	35.06	17398700.0
2004-05-24 12:00:00	QQQ	ETF	35.06	35.15	35.03	35.07	7023700.0
2004-05-24 13:00:00	QQQ	ETF	35.08	35.29	35.07	35.19	9858500.0
2004-05-24 14:00:00	QQQ	ETF	35.2	35.202	35.059	35.12	8588500.0
2004-05-24 15:00:00	QQQ	ETF	35.12	35.26	35.094	35.16	10430500.0
2004-05-24 16:00:00	QQQ	ETF	35.15	35.32	35.09	35.3	4338000.0
2004-05-24 17:00:00	QQQ	ETF	35.3	35.3	35.15	35.25	658600.0
2004-05-24 18:00:00	QQQ	ETF	35.25	35.27	35.2	35.25	67000.0
2004-05-24 19:00:00	QQQ	ETF	35.25	35.27	35.22	35.25	12500.0
2004-05-24 08:00:00	IWM	ETF	54.83	54.88	54.82	54.82	3600.0
2004-05-24 09:00:00	IWM	ETF	54.83	55.21	54.77	55.13	2467600.0
2004-05-24 10:00:00	IWM	ETF	55.135	55.15	54.85	55.06	2035000.0
2004-05-24 11:00:00	IWM	ETF	55.055	55.075	54.595	54.745	1561800.0
2004-05-24 12:00:00	IWM	ETF	54.745	54.82	54.62	54.64	369800.0
2004-05-24 13:00:00	IWM	ETF	54.64	55.0	54.625	54.91	834800.0
2004-05-24 14:00:00	IWM	ETF	54.915	54.925	54.75	54.875	326800.0
2004-05-24 15:00:00	IWM	ETF	54.87	55.09	54.825	55.07	1627600.0
2004-05-24 16:00:00	IWM	ETF	55.085	55.24	55.03	55.03	474000.0
2004-05-24 17:00:00	IWM	ETF	55.225	55.225	55.225	55.225	50000.0
2004-05-24 08:00:00	DIA	ETF	100.33	100.46	100.29	100.39	23900.0
2004-05-24 09:00:00	DIA	ETF	100.4	100.63	100.26	100.46	1002600.0
2004-05-24 10:00:00	DIA	ETF	100.45	100.52	100.0	100.22	1100500.0
2004-05-24 11:00:00	DIA	ETF	100.22	100.27	99.6	99.73	833200.0
2004-05-24 12:00:00	DIA	ETF	99.74	99.81	99.42	99.45	612900.0
2004-05-24 13:00:00	DIA	ETF	99.42	99.92	99.42	99.75	780400.0
2004-05-24 14:00:00	DIA	ETF	99.75	99.79	99.5	99.61	370600.0
2004-05-24 15:00:00	DIA	ETF	99.59	99.92	99.57	99.75	751800.0
2004-05-24 16:00:00	DIA	ETF	99.76	100.05	99.66	99.98	176300.0
2004-05-24 17:00:00	DIA	ETF	99.98	99.98	99.9	99.9	2700.0
2004-05-24 19:00:00	DIA	ETF	99.94	99.94	99.94	99.94	400.0
2004-05-24 08:00:00	TLT	ETF	81.86	81.86	81.86	81.86	500.0
2004-05-24 09:00:00	TLT	ETF	81.93	81.93	81.78	81.81	91800.0
2004-05-24 10:00:00	TLT	ETF	81.77	81.86	81.73	81.73	43000.0
2004-05-24 11:00:00	TLT	ETF	81.79	81.89	81.79	81.89	38400.0
2004-05-24 12:00:00	TLT	ETF	81.89	82.04	81.87	82.02	22200.0

> showing 50 of 671 rows — these rows as CSV

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