PREVIEW / etf_1hour / 2005-01-07

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-01-07.parquet
  size:    29 KB
  rows:    831

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
2005-01-07 08:00:00	SPY	ETF	118.75	119.17	118.42	119.06	1061800.0
2005-01-07 09:00:00	SPY	ETF	119.07	119.13	118.74	118.85	7000300.0
2005-01-07 10:00:00	SPY	ETF	118.81	119.12	118.13	118.36	14236500.0
2005-01-07 11:00:00	SPY	ETF	118.34	119.06	118.34	118.96	8751100.0
2005-01-07 12:00:00	SPY	ETF	118.96	119.23	118.76	119.05	4836400.0
2005-01-07 13:00:00	SPY	ETF	119.05	119.15	118.88	118.97	2786100.0
2005-01-07 14:00:00	SPY	ETF	118.98	119.07	118.57	118.79	4849900.0
2005-01-07 15:00:00	SPY	ETF	118.79	118.9	118.49	118.56	7286600.0
2005-01-07 16:00:00	SPY	ETF	118.57	119.08	118.33	118.36	1473800.0
2005-01-07 17:00:00	SPY	ETF	118.39	118.39	118.33	118.37	15800.0
2005-01-07 18:00:00	SPY	ETF	118.36	118.37	118.32	118.32	3600.0
2005-01-07 19:00:00	SPY	ETF	118.32	118.37	118.31	118.36	1100.0
2005-01-07 09:00:00	QQQ	ETF	38.56	38.65	38.47	38.54	15117900.0
2005-01-07 10:00:00	QQQ	ETF	38.54	38.64	38.21	38.35	30522000.0
2005-01-07 11:00:00	QQQ	ETF	38.35	39.01	38.34	38.6	15767500.0
2005-01-07 12:00:00	QQQ	ETF	38.61	38.87	38.54	38.76	14479100.0
2005-01-07 13:00:00	QQQ	ETF	38.76	38.8	38.63	38.73	7583600.0
2005-01-07 14:00:00	QQQ	ETF	38.73	38.78	38.58	38.68	21656000.0
2005-01-07 15:00:00	QQQ	ETF	38.68	38.74	38.53	38.55	11621100.0
2005-01-07 08:00:00	IWM	ETF	61.855	61.985	61.855	61.93	52600.0
2005-01-07 09:00:00	IWM	ETF	61.91	61.975	61.405	61.45	2982000.0
2005-01-07 10:00:00	IWM	ETF	61.485	61.69	60.895	61.02	5519400.0
2005-01-07 11:00:00	IWM	ETF	61.02	61.69	61.015	61.35	3033800.0
2005-01-07 12:00:00	IWM	ETF	61.36	61.65	61.28	61.6	1748600.0
2005-01-07 13:00:00	IWM	ETF	61.605	61.66	61.325	61.48	981000.0
2005-01-07 14:00:00	IWM	ETF	61.48	61.6	61.29	61.41	1787400.0
2005-01-07 15:00:00	IWM	ETF	61.41	61.595	60.985	61.055	2906000.0
2005-01-07 16:00:00	IWM	ETF	61.005	61.09	60.9	60.93	758800.0
2005-01-07 17:00:00	IWM	ETF	60.92	61.3526	60.92	61.3526	21800.0
2005-01-07 08:00:00	DIA	ETF	106.19	106.56	106.17	106.41	41200.0
2005-01-07 09:00:00	DIA	ETF	106.47	106.49	106.17	106.23	961200.0
2005-01-07 10:00:00	DIA	ETF	106.22	106.44	105.63	105.89	2858400.0
2005-01-07 11:00:00	DIA	ETF	105.89	106.37	105.89	106.28	1286300.0
2005-01-07 12:00:00	DIA	ETF	106.27	106.5	106.14	106.33	622800.0
2005-01-07 13:00:00	DIA	ETF	106.34	106.42	106.18	106.26	414100.0
2005-01-07 14:00:00	DIA	ETF	106.27	106.35	105.94	106.12	496000.0
2005-01-07 15:00:00	DIA	ETF	106.12	106.24	105.93	105.95	919800.0
2005-01-07 16:00:00	DIA	ETF	106.0	106.12	105.79	105.79	86500.0
2005-01-07 17:00:00	DIA	ETF	105.76	105.76	105.73	105.73	800.0
2005-01-07 09:00:00	GLD	ETF	42.09	42.39	42.09	42.26	546600.0
2005-01-07 10:00:00	GLD	ETF	42.26	42.27	41.76	41.76	1616700.0
2005-01-07 11:00:00	GLD	ETF	41.76	41.9	41.71	41.86	402500.0
2005-01-07 12:00:00	GLD	ETF	41.86	41.88	41.7	41.72	257300.0
2005-01-07 13:00:00	GLD	ETF	41.72	41.9	41.72	41.89	1355200.0
2005-01-07 14:00:00	GLD	ETF	41.88	41.89	41.83	41.83	95100.0
2005-01-07 15:00:00	GLD	ETF	41.84	41.92	41.78	41.83	212900.0
2005-01-07 16:00:00	GLD	ETF	41.84	41.9	41.84	41.9	4800.0
2005-01-07 08:00:00	TLT	ETF	88.52	89.42	87.43	88.35	81100.0
2005-01-07 09:00:00	TLT	ETF	88.49	88.91	88.49	88.84	267700.0
2005-01-07 10:00:00	TLT	ETF	88.84	88.84	88.51	88.6	97400.0

> showing 50 of 831 rows — these rows as CSV

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