PREVIEW / etf_1hour / 2004-11-17

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-11-17.parquet
  size:    27 KB
  rows:    774

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-17 08:00:00	SPY	ETF	118.16	118.43	118.1	118.31	300400.0
2004-11-17 09:00:00	SPY	ETF	118.35	118.61	118.3	118.51	5347300.0
2004-11-17 10:00:00	SPY	ETF	118.51	119.13	118.48	118.88	10883200.0
2004-11-17 11:00:00	SPY	ETF	118.88	119.14	118.84	119.05	5302500.0
2004-11-17 12:00:00	SPY	ETF	119.04	119.1	118.95	119.08	3142900.0
2004-11-17 13:00:00	SPY	ETF	119.06	119.11	118.84	118.89	3854700.0
2004-11-17 14:00:00	SPY	ETF	118.88	118.88	118.16	118.53	9870000.0
2004-11-17 15:00:00	SPY	ETF	118.53	118.53	118.07	118.4	10949700.0
2004-11-17 16:00:00	SPY	ETF	118.4	118.74	118.38	118.45	2561200.0
2004-11-17 17:00:00	SPY	ETF	118.52	118.52	118.41	118.45	65400.0
2004-11-17 18:00:00	SPY	ETF	118.45	118.58	118.4	118.4	394300.0
2004-11-17 19:00:00	SPY	ETF	118.45	118.48	118.45	118.46	7700.0
2004-11-17 08:00:00	QQQ	ETF	38.78	38.9	38.73	38.86	547700.0
2004-11-17 09:00:00	QQQ	ETF	38.87	38.95	38.83	38.89	14780000.0
2004-11-17 10:00:00	QQQ	ETF	38.9	39.243	38.858	39.17	31534800.0
2004-11-17 11:00:00	QQQ	ETF	39.17	39.29	39.11	39.26	12366400.0
2004-11-17 12:00:00	QQQ	ETF	39.26	39.32	39.22	39.26	7669300.0
2004-11-17 13:00:00	QQQ	ETF	39.27	39.3	39.15	39.17	8204500.0
2004-11-17 14:00:00	QQQ	ETF	39.16	39.17	38.85	39.05	24739500.0
2004-11-17 15:00:00	QQQ	ETF	39.05	39.1	38.87	39.047	19696700.0
2004-11-17 16:00:00	QQQ	ETF	39.04	39.14	38.93	39.026	4111200.0
2004-11-17 17:00:00	QQQ	ETF	39.03	39.04	38.96	39.02	503400.0
2004-11-17 18:00:00	QQQ	ETF	39.01	39.02	38.95	38.98	100800.0
2004-11-17 19:00:00	QQQ	ETF	38.97	39.0	38.96	38.98	4600.0
2004-11-17 08:00:00	IWM	ETF	62.0	62.02	61.94	62.0	5000.0
2004-11-17 09:00:00	IWM	ETF	62.0	62.425	61.99	62.355	2237800.0
2004-11-17 10:00:00	IWM	ETF	62.36	62.67	62.36	62.5493	1871600.0
2004-11-17 11:00:00	IWM	ETF	62.54	62.63	62.47	62.59	1907600.0
2004-11-17 12:00:00	IWM	ETF	62.59	62.6	62.455	62.555	620200.0
2004-11-17 13:00:00	IWM	ETF	62.55	62.555	62.365	62.42	1169200.0
2004-11-17 14:00:00	IWM	ETF	62.435	62.435	61.87	62.045	2004800.0
2004-11-17 15:00:00	IWM	ETF	62.045	62.125	61.805	62.105	2526400.0
2004-11-17 16:00:00	IWM	ETF	62.11	62.13	62.045	62.13	1599200.0
2004-11-17 17:00:00	IWM	ETF	62.0	62.0	62.0	62.0	400.0
2004-11-17 19:00:00	IWM	ETF	62.05	62.05	62.05	62.05	800.0
2004-11-17 08:00:00	DIA	ETF	105.4	105.66	105.38	105.57	21600.0
2004-11-17 09:00:00	DIA	ETF	105.57	105.75	105.57	105.67	727600.0
2004-11-17 10:00:00	DIA	ETF	105.67	106.17	105.67	106.03	1649100.0
2004-11-17 11:00:00	DIA	ETF	106.03	106.26	106.0	106.19	764700.0
2004-11-17 12:00:00	DIA	ETF	106.18	106.25	106.12	106.21	385000.0
2004-11-17 13:00:00	DIA	ETF	106.21	106.24	105.99	106.06	452600.0
2004-11-17 14:00:00	DIA	ETF	106.05	106.05	105.35	105.73	1172600.0
2004-11-17 15:00:00	DIA	ETF	105.74	105.75	105.41	105.73	1210800.0
2004-11-17 16:00:00	DIA	ETF	105.72	105.9	105.68	105.8	405200.0
2004-11-17 17:00:00	DIA	ETF	105.73	105.73	105.71	105.71	400.0
2004-11-17 18:00:00	DIA	ETF	105.8	105.8	105.8	105.8	300.0
2004-11-17 08:00:00	TLT	ETF	87.71	88.05	87.68	88.05	32900.0
2004-11-17 09:00:00	TLT	ETF	87.93	88.12	87.89	88.1	98400.0
2004-11-17 10:00:00	TLT	ETF	88.1	88.26	88.1	88.18	92800.0
2004-11-17 11:00:00	TLT	ETF	88.2	88.55	88.2	88.49	254500.0

> showing 50 of 774 rows — these rows as CSV

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