PREVIEW / etf_1hour / 2004-03-18

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-03-18.parquet
  size:    25 KB
  rows:    691

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-03-18 08:00:00	SPY	ETF	112.71	112.78	112.59	112.59	277600.0
2004-03-18 09:00:00	SPY	ETF	112.58	112.83	112.58	112.77	4245100.0
2004-03-18 10:00:00	SPY	ETF	112.78	112.8	112.25	112.36	6551000.0
2004-03-18 11:00:00	SPY	ETF	112.36	112.39	112.09	112.36	4683200.0
2004-03-18 12:00:00	SPY	ETF	112.33	112.65	111.93	112.44	9098800.0
2004-03-18 13:00:00	SPY	ETF	112.44	113.25	112.37	112.608	14910200.0
2004-03-18 14:00:00	SPY	ETF	112.6	112.82	112.42	112.66	4086300.0
2004-03-18 15:00:00	SPY	ETF	112.65	113.25	112.65	112.91	8046400.0
2004-03-18 16:00:00	SPY	ETF	112.9	113.15	112.88	113.07	2328000.0
2004-03-18 17:00:00	SPY	ETF	113.07	113.2	113.0	113.13	80800.0
2004-03-18 18:00:00	SPY	ETF	113.13	113.2	113.08	113.18	6800.0
2004-03-18 19:00:00	SPY	ETF	113.18	113.18	113.16	113.16	3400.0
2004-03-18 08:00:00	QQQ	ETF	35.36	35.43	35.32	35.33	529800.0
2004-03-18 09:00:00	QQQ	ETF	35.33	35.46	35.28	35.379	11612000.0
2004-03-18 10:00:00	QQQ	ETF	35.38	35.39	35.15	35.23	15130400.0
2004-03-18 11:00:00	QQQ	ETF	35.23	35.24	35.11	35.19	12079400.0
2004-03-18 12:00:00	QQQ	ETF	35.19	35.2	34.97	35.11	18751600.0
2004-03-18 13:00:00	QQQ	ETF	35.103	35.4	35.08	35.22	22366500.0
2004-03-18 14:00:00	QQQ	ETF	35.231	35.29	35.09	35.17	8418400.0
2004-03-18 15:00:00	QQQ	ETF	35.18	35.445	35.17	35.292	16232300.0
2004-03-18 16:00:00	QQQ	ETF	35.29	35.41	35.27	35.36	2630000.0
2004-03-18 17:00:00	QQQ	ETF	35.36	35.398	35.36	35.39	74600.0
2004-03-18 18:00:00	QQQ	ETF	35.39	35.41	35.35	35.4	62800.0
2004-03-18 19:00:00	QQQ	ETF	35.4	35.42	35.37	35.4	9400.0
2004-03-18 08:00:00	IWM	ETF	57.48	57.48	57.46	57.46	3200.0
2004-03-18 09:00:00	IWM	ETF	57.47	57.55	57.24	57.465	2537800.0
2004-03-18 10:00:00	IWM	ETF	57.495	57.495	57.035	57.125	2769800.0
2004-03-18 11:00:00	IWM	ETF	57.09	57.105	56.79	56.89	3044600.0
2004-03-18 12:00:00	IWM	ETF	56.905	57.175	56.675	57.05	2255600.0
2004-03-18 13:00:00	IWM	ETF	57.05	57.575	57.02	57.275	2910400.0
2004-03-18 14:00:00	IWM	ETF	57.285	57.35	57.055	57.14	697000.0
2004-03-18 15:00:00	IWM	ETF	57.14	57.615	57.13	57.285	2591200.0
2004-03-18 16:00:00	IWM	ETF	57.31	57.375	57.27	57.37	252600.0
2004-03-18 17:00:00	IWM	ETF	57.345	57.35	57.345	57.35	2800.0
2004-03-18 08:00:00	DIA	ETF	102.97	103.04	102.79	102.8	68800.0
2004-03-18 09:00:00	DIA	ETF	102.8	103.09	102.8	103.0	1462400.0
2004-03-18 10:00:00	DIA	ETF	103.05	103.05	102.54	102.66	796000.0
2004-03-18 11:00:00	DIA	ETF	102.67	102.73	102.49	102.7	745600.0
2004-03-18 12:00:00	DIA	ETF	102.69	103.0	102.35	102.8	966500.0
2004-03-18 13:00:00	DIA	ETF	102.8	103.53	102.77	102.98	2031100.0
2004-03-18 14:00:00	DIA	ETF	102.94	103.16	102.81	102.99	611400.0
2004-03-18 15:00:00	DIA	ETF	103.01	103.5	103.01	103.22	1882200.0
2004-03-18 16:00:00	DIA	ETF	103.24	103.48	103.22	103.48	218500.0
2004-03-18 17:00:00	DIA	ETF	103.47	103.6	103.47	103.55	11200.0
2004-03-18 18:00:00	DIA	ETF	103.55	103.55	103.5	103.5	3700.0
2004-03-18 19:00:00	DIA	ETF	103.6	103.69	103.5	103.69	6700.0
2004-03-18 08:00:00	TLT	ETF	90.68	90.68	90.5	90.67	15100.0
2004-03-18 09:00:00	TLT	ETF	90.71	90.85	90.7	90.8	89300.0
2004-03-18 10:00:00	TLT	ETF	90.78	90.94	90.71	90.77	205600.0
2004-03-18 11:00:00	TLT	ETF	90.77	91.0	90.75	90.98	223000.0

> showing 50 of 691 rows — these rows as CSV

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