PREVIEW / etf_1hour / 2005-10-12

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-10-12.parquet
  size:    34 KB
  rows:    1,023

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-10-12 06:00:00	SPY	ETF	118.31	118.31	118.31	118.31	25000.0
2005-10-12 07:00:00	SPY	ETF	118.31	118.34	118.24	118.25	80400.0
2005-10-12 08:00:00	SPY	ETF	118.26	118.35	118.14	118.3	1115000.0
2005-10-12 09:00:00	SPY	ETF	118.3	119.13	118.16	119.08	9959500.0
2005-10-12 10:00:00	SPY	ETF	119.08	119.1	118.15	118.25	14913400.0
2005-10-12 11:00:00	SPY	ETF	118.25	118.52	117.78	117.78	15345800.0
2005-10-12 12:00:00	SPY	ETF	117.8	118.13	117.56	117.93	12328000.0
2005-10-12 13:00:00	SPY	ETF	117.94	118.32	117.77	117.89	12158200.0
2005-10-12 14:00:00	SPY	ETF	117.8715	118.03	117.42	117.56	14082000.0
2005-10-12 15:00:00	SPY	ETF	117.57	118.12	117.41	117.84	16917500.0
2005-10-12 16:00:00	SPY	ETF	117.83	117.84	117.5	117.64	1094900.0
2005-10-12 17:00:00	SPY	ETF	117.65	117.73	117.64	117.73	78300.0
2005-10-12 18:00:00	SPY	ETF	117.71	117.71	117.64	117.7	12200.0
2005-10-12 19:00:00	SPY	ETF	117.7	117.72	117.69	117.71	3200.0
2005-10-12 09:00:00	QQQ	ETF	37.77	38.06	37.75	37.97	20881800.0
2005-10-12 10:00:00	QQQ	ETF	37.98	37.99	37.61	37.68	26568700.0
2005-10-12 11:00:00	QQQ	ETF	37.68	37.83	37.54	37.55	23072000.0
2005-10-12 12:00:00	QQQ	ETF	37.54	37.79	37.49	37.6	13331200.0
2005-10-12 13:00:00	QQQ	ETF	37.59	37.76	37.58	37.61	11855100.0
2005-10-12 14:00:00	QQQ	ETF	37.61	37.68	37.44	37.5	17916100.0
2005-10-12 15:00:00	QQQ	ETF	37.49	37.63	37.43	37.48	22138800.0
2005-10-12 08:00:00	IWM	ETF	62.36	62.43	62.33	62.35	98000.0
2005-10-12 09:00:00	IWM	ETF	62.38	62.8	62.28	62.59	10071500.0
2005-10-12 10:00:00	IWM	ETF	62.59	62.63	61.72	61.83	13632100.0
2005-10-12 11:00:00	IWM	ETF	61.84	62.08	61.28	61.35	9826900.0
2005-10-12 12:00:00	IWM	ETF	61.33	61.8	61.25	61.67	4812100.0
2005-10-12 13:00:00	IWM	ETF	61.68	62.3	61.61	61.76	6862600.0
2005-10-12 14:00:00	IWM	ETF	61.76	61.86	61.37	61.58	7869900.0
2005-10-12 15:00:00	IWM	ETF	61.58	62.04	61.48	61.85	7741400.0
2005-10-12 16:00:00	IWM	ETF	61.85	61.94	61.64	61.7	214200.0
2005-10-12 17:00:00	IWM	ETF	61.7	61.7	61.7	61.7	700.0
2005-10-12 18:00:00	IWM	ETF	61.7	61.7	61.7	61.7	600.0
2005-10-12 19:00:00	IWM	ETF	61.65	61.7	61.65	61.7	2400.0
2005-10-12 08:00:00	DIA	ETF	102.33	102.51	102.33	102.48	9500.0
2005-10-12 09:00:00	DIA	ETF	102.46	103.08	102.46	103.07	1465200.0
2005-10-12 10:00:00	DIA	ETF	103.07	103.12	102.39	102.49	3344900.0
2005-10-12 11:00:00	DIA	ETF	102.5	102.73	102.08	102.09	1694400.0
2005-10-12 12:00:00	DIA	ETF	102.08	102.44	101.96	102.24	2527500.0
2005-10-12 13:00:00	DIA	ETF	102.24	102.6	102.16	102.28	2802400.0
2005-10-12 14:00:00	DIA	ETF	102.28	102.41	101.92	101.96	1600400.0
2005-10-12 15:00:00	DIA	ETF	101.97	102.43	101.88	102.17	3219900.0
2005-10-12 16:00:00	DIA	ETF	102.2	102.2	102.0	102.06	23000.0
2005-10-12 18:00:00	DIA	ETF	102.25	102.7	102.25	102.25	3000.0
2005-10-12 08:00:00	GLD	ETF	47.76	47.79	47.71	47.79	23400.0
2005-10-12 09:00:00	GLD	ETF	47.7	47.7	47.42	47.43	364100.0
2005-10-12 10:00:00	GLD	ETF	47.43	47.45	47.13	47.2701	578700.0
2005-10-12 11:00:00	GLD	ETF	47.28	47.53	47.26	47.41	396900.0
2005-10-12 12:00:00	GLD	ETF	47.43	47.48	47.09	47.1	442900.0
2005-10-12 13:00:00	GLD	ETF	47.11	47.26	47.0	47.11	307400.0
2005-10-12 14:00:00	GLD	ETF	47.11	47.14	46.92	46.98	546000.0

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

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