PREVIEW / etf_1hour / 2005-11-18

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-11-18.parquet
  size:    34 KB
  rows:    1,031

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-11-18 07:00:00	SPY	ETF	124.66	124.8	124.66	124.77	96100.0
2005-11-18 08:00:00	SPY	ETF	124.69	124.97	124.68	124.9	2239600.0
2005-11-18 09:00:00	SPY	ETF	124.9	125.12	124.76	125.04	12984800.0
2005-11-18 10:00:00	SPY	ETF	125.02	125.28	124.62	124.67	15397900.0
2005-11-18 11:00:00	SPY	ETF	124.67	124.85	124.46	124.54	10876600.0
2005-11-18 12:00:00	SPY	ETF	124.56	125.756	124.33	124.45	6714200.0
2005-11-18 13:00:00	SPY	ETF	124.45	124.9	124.43	124.79	4339900.0
2005-11-18 14:00:00	SPY	ETF	124.78	124.87	124.63	124.73	3867500.0
2005-11-18 15:00:00	SPY	ETF	124.73	125.23	124.69	125.1	9773200.0
2005-11-18 16:00:00	SPY	ETF	125.09	125.134	124.7625	125.0	2797200.0
2005-11-18 17:00:00	SPY	ETF	125.04	125.05	125.01	125.02	102900.0
2005-11-18 19:00:00	SPY	ETF	125.06	125.07	125.06	125.07	1600.0
2005-11-18 09:00:00	QQQ	ETF	41.51	41.53	40.5	41.48	19232000.0
2005-11-18 10:00:00	QQQ	ETF	41.49	41.65	39.39	41.33	25864000.0
2005-11-18 11:00:00	QQQ	ETF	41.34	41.47	41.27	41.37	15018600.0
2005-11-18 12:00:00	QQQ	ETF	41.37	41.44	41.31	41.35	4556300.0
2005-11-18 13:00:00	QQQ	ETF	41.35	41.45	41.32	41.42	6475000.0
2005-11-18 14:00:00	QQQ	ETF	41.43	41.47	41.03	41.33	9069100.0
2005-11-18 15:00:00	QQQ	ETF	41.33	41.46	41.32	41.42	13830200.0
2005-11-18 07:00:00	IWM	ETF	66.42	66.5	66.42	66.5	27300.0
2005-11-18 08:00:00	IWM	ETF	66.5	66.64	66.39	66.52	660400.0
2005-11-18 09:00:00	IWM	ETF	66.57	66.83	66.49	66.81	4302400.0
2005-11-18 10:00:00	IWM	ETF	66.81	67.08	66.5	66.6	9436000.0
2005-11-18 11:00:00	IWM	ETF	66.6	66.71	66.37	66.51	2835000.0
2005-11-18 12:00:00	IWM	ETF	66.52	66.68	66.43	66.53	1521200.0
2005-11-18 13:00:00	IWM	ETF	66.53	66.89	66.53	66.85	2516000.0
2005-11-18 14:00:00	IWM	ETF	66.85	66.93	66.61	66.7	2547500.0
2005-11-18 15:00:00	IWM	ETF	66.69	66.95	66.64	66.91	3294300.0
2005-11-18 16:00:00	IWM	ETF	66.92	66.95	66.8	66.85	297300.0
2005-11-18 07:00:00	DIA	ETF	107.33	107.34	107.33	107.34	1000.0
2005-11-18 08:00:00	DIA	ETF	107.33	107.48	107.32	107.43	38100.0
2005-11-18 09:00:00	DIA	ETF	107.44	107.63	107.36	107.52	1079600.0
2005-11-18 10:00:00	DIA	ETF	107.52	107.7	107.15	107.16	2630500.0
2005-11-18 11:00:00	DIA	ETF	107.16	107.25	107.02	107.05	1213600.0
2005-11-18 12:00:00	DIA	ETF	107.05	107.18	106.9	107.0	847800.0
2005-11-18 13:00:00	DIA	ETF	107.0	107.26	106.99	107.21	384400.0
2005-11-18 14:00:00	DIA	ETF	107.22	107.3	107.14	107.27	772600.0
2005-11-18 15:00:00	DIA	ETF	107.3	107.64	107.24	107.55	791300.0
2005-11-18 16:00:00	DIA	ETF	107.57	107.58	107.53	107.55	234800.0
2005-11-18 19:00:00	DIA	ETF	107.51	107.51	107.51	107.51	200.0
2005-11-18 07:00:00	GLD	ETF	48.69	48.69	48.69	48.69	500.0
2005-11-18 08:00:00	GLD	ETF	48.65	48.72	48.46	48.64	29800.0
2005-11-18 09:00:00	GLD	ETF	48.63	48.74	48.34	48.4	337800.0
2005-11-18 10:00:00	GLD	ETF	48.41	48.61	48.39	48.49	360300.0
2005-11-18 11:00:00	GLD	ETF	48.49	48.61	48.21	48.21	172800.0
2005-11-18 12:00:00	GLD	ETF	48.2	48.39	48.2	48.32	215500.0
2005-11-18 13:00:00	GLD	ETF	48.34	48.48	48.32	48.39	89100.0
2005-11-18 14:00:00	GLD	ETF	48.39	48.44	48.32	48.43	92500.0
2005-11-18 15:00:00	GLD	ETF	48.43	48.48	48.4	48.44	143900.0
2005-11-18 16:00:00	GLD	ETF	48.44	48.46	48.44	48.46	400.0

> showing 50 of 1,031 rows — these rows as CSV

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