PREVIEW / etf_1hour / 2004-05-19

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-05-19.parquet
  size:    25 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-19 08:00:00	SPY	ETF	110.41	110.5	110.31	110.42	239600.0
2004-05-19 09:00:00	SPY	ETF	110.43	110.67	110.33	110.6	5360500.0
2004-05-19 10:00:00	SPY	ETF	110.61	111.18	110.6	110.97	10208700.0
2004-05-19 11:00:00	SPY	ETF	110.98	111.1	110.82	110.96	4813400.0
2004-05-19 12:00:00	SPY	ETF	110.96	111.07	110.73	110.83	2392800.0
2004-05-19 13:00:00	SPY	ETF	110.81	111.0	110.68	110.94	3453300.0
2004-05-19 14:00:00	SPY	ETF	110.93	110.98	110.1	110.15	8608700.0
2004-05-19 15:00:00	SPY	ETF	110.15	110.2	109.32	109.41	13625600.0
2004-05-19 16:00:00	SPY	ETF	109.45	109.46	108.98	108.98	2913800.0
2004-05-19 17:00:00	SPY	ETF	109.02	109.08	108.98	109.08	57100.0
2004-05-19 18:00:00	SPY	ETF	109.03	109.2	109.03	109.13	204700.0
2004-05-19 19:00:00	SPY	ETF	109.16	109.16	109.1	109.12	6900.0
2004-05-19 08:00:00	QQQ	ETF	35.15	35.16	35.09	35.1	248200.0
2004-05-19 09:00:00	QQQ	ETF	35.1	35.22	35.08	35.179	14706800.0
2004-05-19 10:00:00	QQQ	ETF	35.18	35.5	35.16	35.428	32618600.0
2004-05-19 11:00:00	QQQ	ETF	35.43	35.477	35.31	35.41	14247300.0
2004-05-19 12:00:00	QQQ	ETF	35.4	35.46	35.329	35.38	7043400.0
2004-05-19 13:00:00	QQQ	ETF	35.37	35.43	35.319	35.42	7451400.0
2004-05-19 14:00:00	QQQ	ETF	35.421	35.44	35.102	35.15	19296900.0
2004-05-19 15:00:00	QQQ	ETF	35.15	35.15	34.71	34.75	36143600.0
2004-05-19 16:00:00	QQQ	ETF	34.75	34.79	34.61	34.64	4800400.0
2004-05-19 17:00:00	QQQ	ETF	34.65	34.67	34.621	34.65	151700.0
2004-05-19 18:00:00	QQQ	ETF	34.65	34.69	34.63	34.66	48600.0
2004-05-19 19:00:00	QQQ	ETF	34.66	34.68	34.64	34.68	14700.0
2004-05-19 08:00:00	IWM	ETF	54.68	54.68	54.675	54.675	30000.0
2004-05-19 09:00:00	IWM	ETF	54.65	54.935	54.57	54.91	3452000.0
2004-05-19 10:00:00	IWM	ETF	54.91	55.21	54.91	55.045	3649000.0
2004-05-19 11:00:00	IWM	ETF	55.045	55.055	54.76	54.855	766400.0
2004-05-19 12:00:00	IWM	ETF	54.86	54.875	54.585	54.695	907800.0
2004-05-19 13:00:00	IWM	ETF	54.69	54.795	54.625	54.78	1283600.0
2004-05-19 14:00:00	IWM	ETF	54.79	54.85	54.2	54.2	2285600.0
2004-05-19 15:00:00	IWM	ETF	54.215	54.23	53.73	53.8	4696000.0
2004-05-19 16:00:00	IWM	ETF	53.805	53.87	53.675	53.675	335200.0
2004-05-19 18:00:00	IWM	ETF	53.655	53.71	53.655	53.71	6000.0
2004-05-19 08:00:00	DIA	ETF	100.72	100.76	100.67	100.68	33300.0
2004-05-19 09:00:00	DIA	ETF	100.69	100.88	100.62	100.84	841600.0
2004-05-19 10:00:00	DIA	ETF	100.84	101.4	100.82	101.2	1519600.0
2004-05-19 11:00:00	DIA	ETF	101.161	101.31	101.09	101.18	967800.0
2004-05-19 12:00:00	DIA	ETF	101.19	101.25	101.0	101.05	447500.0
2004-05-19 13:00:00	DIA	ETF	101.06	101.2	100.95	101.16	298400.0
2004-05-19 14:00:00	DIA	ETF	101.16	101.2	100.48	100.5	1222000.0
2004-05-19 15:00:00	DIA	ETF	100.52	100.53	99.76	99.85	1679300.0
2004-05-19 16:00:00	DIA	ETF	99.85	100.1144	99.52	99.52	1101600.0
2004-05-19 17:00:00	DIA	ETF	99.5	99.64	99.5	99.64	1100.0
2004-05-19 09:00:00	TLT	ETF	81.4	81.43	81.28	81.39	43500.0
2004-05-19 10:00:00	TLT	ETF	81.35	81.4	81.28	81.4	48900.0
2004-05-19 11:00:00	TLT	ETF	81.41	81.45	81.31	81.42	38000.0
2004-05-19 12:00:00	TLT	ETF	81.4	81.45	81.36	81.45	32200.0
2004-05-19 13:00:00	TLT	ETF	81.35	81.39	81.17	81.25	34900.0
2004-05-19 14:00:00	TLT	ETF	81.26	81.29	81.15	81.28	83900.0

> showing 50 of 684 rows — these rows as CSV

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