PREVIEW / etf_1hour / 2004-02-18

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-02-18.parquet
  size:    25 KB
  rows:    697

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-02-18 08:00:00	SPY	ETF	116.3	116.32	116.25	116.32	25700.0
2004-02-18 09:00:00	SPY	ETF	116.28	116.3	115.9	116.03	3607900.0
2004-02-18 10:00:00	SPY	ETF	116.04	116.2	115.85	115.95	3830300.0
2004-02-18 11:00:00	SPY	ETF	115.95	116.11	115.93	115.98	2485400.0
2004-02-18 12:00:00	SPY	ETF	115.98	116.25	115.89	116.11	1807300.0
2004-02-18 13:00:00	SPY	ETF	116.11	116.2	115.94	116.08	932200.0
2004-02-18 14:00:00	SPY	ETF	116.07	116.09	115.35	115.62	7439800.0
2004-02-18 15:00:00	SPY	ETF	115.62	115.8	115.56	115.66	3296400.0
2004-02-18 16:00:00	SPY	ETF	115.65	115.83	115.57	115.82	1226800.0
2004-02-18 17:00:00	SPY	ETF	115.81	115.94	115.8	115.85	337600.0
2004-02-18 18:00:00	SPY	ETF	115.85	115.95	115.85	115.9	39300.0
2004-02-18 19:00:00	SPY	ETF	115.9	115.9	115.9	115.9	100.0
2004-02-18 08:00:00	QQQ	ETF	37.53	37.55	37.5	37.53	36700.0
2004-02-18 09:00:00	QQQ	ETF	37.53	37.57	37.41	37.48	10341800.0
2004-02-18 10:00:00	QQQ	ETF	37.479	37.55	37.32	37.39	12974100.0
2004-02-18 11:00:00	QQQ	ETF	37.37	37.53	37.36	37.47	6249200.0
2004-02-18 12:00:00	QQQ	ETF	37.46	37.67	37.44	37.6	9194200.0
2004-02-18 13:00:00	QQQ	ETF	37.592	37.66	37.55	37.59	5463400.0
2004-02-18 14:00:00	QQQ	ETF	37.59	37.59	37.34	37.43	11446100.0
2004-02-18 15:00:00	QQQ	ETF	37.43	37.546	37.4	37.49	8296900.0
2004-02-18 16:00:00	QQQ	ETF	37.49	37.7	37.46	37.67	3185500.0
2004-02-18 17:00:00	QQQ	ETF	37.68	37.75	37.66	37.73	1115600.0
2004-02-18 18:00:00	QQQ	ETF	37.73	37.77	37.72	37.73	114600.0
2004-02-18 19:00:00	QQQ	ETF	37.73	37.74	37.72	37.72	74100.0
2004-02-18 08:00:00	IWM	ETF	59.465	59.525	59.45	59.525	3200.0
2004-02-18 09:00:00	IWM	ETF	59.475	59.475	59.125	59.205	778400.0
2004-02-18 10:00:00	IWM	ETF	59.225	59.25	59.01	59.09	1249800.0
2004-02-18 11:00:00	IWM	ETF	59.085	59.275	59.07	59.19	502800.0
2004-02-18 12:00:00	IWM	ETF	59.19	59.36	59.16	59.285	352200.0
2004-02-18 13:00:00	IWM	ETF	59.265	59.34	59.21	59.245	136200.0
2004-02-18 14:00:00	IWM	ETF	59.25	59.25	58.74	58.905	858000.0
2004-02-18 15:00:00	IWM	ETF	58.9	59.07	58.885	58.945	965000.0
2004-02-18 16:00:00	IWM	ETF	58.94	58.977	58.905	58.915	69600.0
2004-02-18 17:00:00	IWM	ETF	59.125	59.125	59.125	59.125	40000.0
2004-02-18 08:00:00	DIA	ETF	107.65	107.65	107.55	107.6	43300.0
2004-02-18 09:00:00	DIA	ETF	107.56	107.57	107.34	107.4	255600.0
2004-02-18 10:00:00	DIA	ETF	107.39	107.55	107.27	107.31	833600.0
2004-02-18 11:00:00	DIA	ETF	107.33	107.45	107.29	107.41	258300.0
2004-02-18 12:00:00	DIA	ETF	107.4	107.59	107.32	107.474	351500.0
2004-02-18 13:00:00	DIA	ETF	107.48	107.54	107.34	107.45	302400.0
2004-02-18 14:00:00	DIA	ETF	107.37	107.39	106.876	107.01	995500.0
2004-02-18 15:00:00	DIA	ETF	107.04	107.25	106.98	107.15	563700.0
2004-02-18 16:00:00	DIA	ETF	107.117	107.3	107.1	107.25	333600.0
2004-02-18 17:00:00	DIA	ETF	107.27	107.4	107.17	107.17	5800.0
2004-02-18 09:00:00	TLT	ETF	88.1	88.16	88.04	88.11	217400.0
2004-02-18 10:00:00	TLT	ETF	88.1	88.18	88.08	88.13	596900.0
2004-02-18 11:00:00	TLT	ETF	88.15	88.16	87.94	88.08	27300.0
2004-02-18 12:00:00	TLT	ETF	88.07	88.11	88.0	88.04	22800.0
2004-02-18 13:00:00	TLT	ETF	88.03	88.1	87.91	87.96	26900.0
2004-02-18 14:00:00	TLT	ETF	87.93	87.93	87.69	87.78	37700.0

> showing 50 of 697 rows — these rows as CSV

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