PREVIEW / etf_1hour / 2004-11-04

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-11-04.parquet
  size:    28 KB
  rows:    770

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-11-04 08:00:00	SPY	ETF	114.84	114.98	114.8	114.87	127400.0
2004-11-04 09:00:00	SPY	ETF	114.86	115.05	114.73	115.04	4487200.0
2004-11-04 10:00:00	SPY	ETF	115.01	115.11	114.68	114.93	6784000.0
2004-11-04 11:00:00	SPY	ETF	114.95	115.54	114.87	115.34	10589000.0
2004-11-04 12:00:00	SPY	ETF	115.34	116.0	115.3	115.86	6996800.0
2004-11-04 13:00:00	SPY	ETF	115.87	116.35	115.81	116.31	7450000.0
2004-11-04 14:00:00	SPY	ETF	116.31	116.38	116.08	116.26	5287800.0
2004-11-04 15:00:00	SPY	ETF	116.27	116.67	116.22	116.57	9120200.0
2004-11-04 16:00:00	SPY	ETF	116.58	116.66	116.43	116.49	2685000.0
2004-11-04 17:00:00	SPY	ETF	116.49	116.53	116.45	116.46	159300.0
2004-11-04 18:00:00	SPY	ETF	116.53	116.53	116.5	116.5	2700.0
2004-11-04 19:00:00	SPY	ETF	116.45	116.49	116.43	116.43	10400.0
2004-11-04 08:00:00	QQQ	ETF	37.3	37.32	37.26	37.3	183400.0
2004-11-04 09:00:00	QQQ	ETF	37.3	37.34	37.19	37.281	12666400.0
2004-11-04 10:00:00	QQQ	ETF	37.281	37.32	37.11	37.22	18307200.0
2004-11-04 11:00:00	QQQ	ETF	37.27	37.55	37.23	37.37	16492500.0
2004-11-04 12:00:00	QQQ	ETF	37.366	37.66	37.35	37.57	15038200.0
2004-11-04 13:00:00	QQQ	ETF	37.57	37.75	37.51	37.69	13343200.0
2004-11-04 14:00:00	QQQ	ETF	37.71	37.76	37.626	37.67	13303300.0
2004-11-04 15:00:00	QQQ	ETF	37.67	37.78	37.6	37.64	18200400.0
2004-11-04 16:00:00	QQQ	ETF	37.637	37.67	37.6	37.63	2849400.0
2004-11-04 17:00:00	QQQ	ETF	37.62	37.682	37.62	37.64	323000.0
2004-11-04 18:00:00	QQQ	ETF	37.65	37.65	37.62	37.62	38500.0
2004-11-04 19:00:00	QQQ	ETF	37.62	37.63	37.62	37.63	52500.0
2004-11-04 08:00:00	IWM	ETF	59.32	59.32	59.235	59.28	13600.0
2004-11-04 09:00:00	IWM	ETF	59.215	59.34	59.08	59.21	1160800.0
2004-11-04 10:00:00	IWM	ETF	59.215	59.255	58.915	59.025	1201400.0
2004-11-04 11:00:00	IWM	ETF	59.06	59.465	59.035	59.37	2626800.0
2004-11-04 12:00:00	IWM	ETF	59.37	59.735	59.365	59.7	1532600.0
2004-11-04 13:00:00	IWM	ETF	59.7	59.88	59.665	59.86	1380000.0
2004-11-04 14:00:00	IWM	ETF	59.865	59.9	59.745	59.835	1054800.0
2004-11-04 15:00:00	IWM	ETF	59.84	60.015	59.8	59.98	2373400.0
2004-11-04 16:00:00	IWM	ETF	59.995	60.035	59.875	59.88	976000.0
2004-11-04 18:00:00	IWM	ETF	59.945	59.945	59.945	59.945	2200.0
2004-11-04 08:00:00	DIA	ETF	101.62	101.69	101.61	101.65	5200.0
2004-11-04 09:00:00	DIA	ETF	101.6	101.76	101.5	101.73	511000.0
2004-11-04 10:00:00	DIA	ETF	101.75	101.85	101.55	101.68	1013200.0
2004-11-04 11:00:00	DIA	ETF	101.74	102.22	101.65	102.07	859900.0
2004-11-04 12:00:00	DIA	ETF	102.08	102.7	102.04	102.57	1105700.0
2004-11-04 13:00:00	DIA	ETF	102.58	103.16	102.56	103.1	1333900.0
2004-11-04 14:00:00	DIA	ETF	103.1	103.15	102.84	103.07	727900.0
2004-11-04 15:00:00	DIA	ETF	103.09	103.45	103.09	103.34	2480900.0
2004-11-04 16:00:00	DIA	ETF	103.34	103.36	103.25	103.27	863400.0
2004-11-04 17:00:00	DIA	ETF	103.26	103.32	103.26	103.32	300.0
2004-11-04 18:00:00	DIA	ETF	103.23	103.23	103.23	103.23	100.0
2004-11-04 08:00:00	TLT	ETF	88.77	88.89	88.72	88.8	7700.0
2004-11-04 09:00:00	TLT	ETF	88.86	88.9	88.84	88.86	932800.0
2004-11-04 10:00:00	TLT	ETF	88.8	89.03	88.8	89.03	164100.0
2004-11-04 11:00:00	TLT	ETF	89.03	89.1	88.98	88.98	173300.0
2004-11-04 12:00:00	TLT	ETF	88.99	88.99	88.76	88.87	174300.0

> showing 50 of 770 rows — these rows as CSV

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