PREVIEW / etf_1hour / 2005-12-01

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-12-01.parquet
  size:    38 KB
  rows:    1,163

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-12-01 04:00:00	SPY	ETF	125.9	125.9	125.9	125.9	500.0
2005-12-01 06:00:00	SPY	ETF	125.94	125.99	125.94	125.95	56600.0
2005-12-01 07:00:00	SPY	ETF	125.99	126.1	125.91	125.95	114900.0
2005-12-01 08:00:00	SPY	ETF	125.41	126.09	125.41	126.01	3017200.0
2005-12-01 09:00:00	SPY	ETF	126.01	126.45	125.41	126.32	9587400.0
2005-12-01 10:00:00	SPY	ETF	126.3301	126.53	126.17	126.48	10412500.0
2005-12-01 11:00:00	SPY	ETF	126.5	126.58	126.36	126.52	10079700.0
2005-12-01 12:00:00	SPY	ETF	126.51	126.84	126.5	126.78	7081000.0
2005-12-01 13:00:00	SPY	ETF	126.78	127.03	126.71	126.84	8763700.0
2005-12-01 14:00:00	SPY	ETF	126.83	126.92	126.72	126.84	4427800.0
2005-12-01 15:00:00	SPY	ETF	126.84	126.99	126.76	126.91	8684100.0
2005-12-01 16:00:00	SPY	ETF	126.91	126.91	125.41	126.75	1115800.0
2005-12-01 17:00:00	SPY	ETF	126.74	126.75	126.03	126.67	245500.0
2005-12-01 18:00:00	SPY	ETF	126.69	126.74	126.67	126.74	18200.0
2005-12-01 19:00:00	SPY	ETF	126.74	126.74	126.74	126.74	6800.0
2005-12-01 09:00:00	QQQ	ETF	41.53	41.8	41.5	41.72	12766200.0
2005-12-01 10:00:00	QQQ	ETF	41.73	41.87	41.72	41.79	18202000.0
2005-12-01 11:00:00	QQQ	ETF	41.8	41.86	41.73	41.79	13019400.0
2005-12-01 12:00:00	QQQ	ETF	41.79	41.94	41.79	41.94	7786500.0
2005-12-01 13:00:00	QQQ	ETF	41.94	42.02	41.9	41.93	8659500.0
2005-12-01 14:00:00	QQQ	ETF	41.93	41.98	41.85	41.93	6023400.0
2005-12-01 15:00:00	QQQ	ETF	41.93	42.05	41.93	42.01	15193000.0
2005-12-01 07:00:00	IWM	ETF	67.7	67.7	67.7	67.7	1000.0
2005-12-01 08:00:00	IWM	ETF	67.45	67.82	67.45	67.82	210700.0
2005-12-01 09:00:00	IWM	ETF	67.8	68.29	67.45	68.2399	4909000.0
2005-12-01 10:00:00	IWM	ETF	68.24	68.41	68.11	68.34	6269100.0
2005-12-01 11:00:00	IWM	ETF	68.35	68.48	68.25	68.37	4179000.0
2005-12-01 12:00:00	IWM	ETF	68.38	68.71	67.4308	68.66	6481200.0
2005-12-01 13:00:00	IWM	ETF	68.65	68.8	68.63	68.69	4360200.0
2005-12-01 14:00:00	IWM	ETF	68.69	68.8	67.4315	68.72	3733100.0
2005-12-01 15:00:00	IWM	ETF	68.73	68.85	68.65	68.71	4475500.0
2005-12-01 16:00:00	IWM	ETF	68.7	68.734	68.55	68.6	1427900.0
2005-12-01 17:00:00	IWM	ETF	68.61	68.62	67.45	67.79	149500.0
2005-12-01 18:00:00	IWM	ETF	68.58	68.58	68.58	68.58	200.0
2005-12-01 07:00:00	DIA	ETF	108.59	108.63	108.59	108.63	300.0
2005-12-01 08:00:00	DIA	ETF	108.63	108.72	108.57	108.7	208400.0
2005-12-01 09:00:00	DIA	ETF	108.7	108.93	108.64	108.84	757900.0
2005-12-01 10:00:00	DIA	ETF	108.87	108.99	108.77	108.96	1015400.0
2005-12-01 11:00:00	DIA	ETF	108.98	109.07	108.91	109.05	1037700.0
2005-12-01 12:00:00	DIA	ETF	109.03	109.23	109.01	109.171	379400.0
2005-12-01 13:00:00	DIA	ETF	109.18	109.39	109.16	109.26	901800.0
2005-12-01 14:00:00	DIA	ETF	109.27	109.29	109.08	109.17	410600.0
2005-12-01 15:00:00	DIA	ETF	109.16	109.32	109.11	109.16	659200.0
2005-12-01 16:00:00	DIA	ETF	109.17	109.17	109.02	109.08	289400.0
2005-12-01 17:00:00	DIA	ETF	109.09	109.09	109.06	109.06	800.0
2005-12-01 18:00:00	DIA	ETF	109.06	109.06	109.06	109.06	1100.0
2005-12-01 08:00:00	GLD	ETF	49.49	49.6	49.42	49.6	64600.0
2005-12-01 09:00:00	GLD	ETF	49.57	49.76	49.55	49.74	323900.0
2005-12-01 10:00:00	GLD	ETF	49.75	50.02	49.74	50.02	660500.0
2005-12-01 11:00:00	GLD	ETF	50.03	50.08	49.83	49.909	310700.0

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

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