PREVIEW / etf_1hour / 2005-07-13

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-07-13.parquet
  size:    30 KB
  rows:    929

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-07-13 07:00:00	SPY	ETF	122.33	122.38	122.29	122.38	5900.0
2005-07-13 08:00:00	SPY	ETF	122.36	122.36	122.25	122.27	71400.0
2005-07-13 09:00:00	SPY	ETF	122.26	122.47	122.23	122.31	5485600.0
2005-07-13 10:00:00	SPY	ETF	122.31	122.39	121.99	122.02	12341400.0
2005-07-13 11:00:00	SPY	ETF	122.02	122.38	122.01	122.25	5470200.0
2005-07-13 12:00:00	SPY	ETF	122.24	122.47	122.16	122.2	2409800.0
2005-07-13 13:00:00	SPY	ETF	122.2	122.32	122.1	122.27	1512600.0
2005-07-13 14:00:00	SPY	ETF	122.27	122.41	122.23	122.25	4963400.0
2005-07-13 15:00:00	SPY	ETF	122.25	122.52	122.1	122.34	7053600.0
2005-07-13 16:00:00	SPY	ETF	122.32	122.54	122.281	122.53	861900.0
2005-07-13 17:00:00	SPY	ETF	122.5	122.58	122.47	122.52	24200.0
2005-07-13 18:00:00	SPY	ETF	122.53	122.53	122.5	122.52	4600.0
2005-07-13 19:00:00	SPY	ETF	122.52	122.58	122.51	122.58	27400.0
2005-07-13 09:00:00	QQQ	ETF	38.32	38.39	38.26	38.28	9786800.0
2005-07-13 10:00:00	QQQ	ETF	38.27	38.38	38.17	38.24	20123500.0
2005-07-13 11:00:00	QQQ	ETF	38.24	38.42	38.23	38.33	10353300.0
2005-07-13 12:00:00	QQQ	ETF	38.34	38.41	38.29	38.31	5123800.0
2005-07-13 13:00:00	QQQ	ETF	38.31	38.36	38.25	38.32	4467500.0
2005-07-13 14:00:00	QQQ	ETF	38.33	38.39	38.3	38.33	5996700.0
2005-07-13 15:00:00	QQQ	ETF	38.32	38.9	38.28	38.4	11512200.0
2005-07-13 07:00:00	IWM	ETF	66.64	66.64	66.64	66.64	200.0
2005-07-13 08:00:00	IWM	ETF	66.65	66.7	66.65	66.65	3700.0
2005-07-13 09:00:00	IWM	ETF	66.62	66.82	66.61	66.63	1349200.0
2005-07-13 10:00:00	IWM	ETF	66.63	66.71	66.17	66.29	5527100.0
2005-07-13 11:00:00	IWM	ETF	66.28	66.61	66.28	66.49	2300300.0
2005-07-13 12:00:00	IWM	ETF	66.5	66.64	66.42	66.44	1252500.0
2005-07-13 13:00:00	IWM	ETF	66.43	66.56	66.24	66.35	1017500.0
2005-07-13 14:00:00	IWM	ETF	66.34	66.46	66.3	66.35	1406500.0
2005-07-13 15:00:00	IWM	ETF	66.35	66.56	66.23	66.33	3781000.0
2005-07-13 16:00:00	IWM	ETF	66.33	66.56	66.33	66.48	83000.0
2005-07-13 17:00:00	IWM	ETF	66.53	66.53	66.53	66.53	2000.0
2005-07-13 19:00:00	IWM	ETF	66.47	66.47	66.47	66.47	400.0
2005-07-13 08:00:00	DIA	ETF	105.25	105.25	105.23	105.23	1500.0
2005-07-13 09:00:00	DIA	ETF	105.23	105.5	105.23	105.36	1425800.0
2005-07-13 10:00:00	DIA	ETF	105.36	105.47	105.15	105.19	863000.0
2005-07-13 11:00:00	DIA	ETF	105.18	105.45	105.18	105.38	1019100.0
2005-07-13 12:00:00	DIA	ETF	105.39	105.64	105.35	105.4	428900.0
2005-07-13 13:00:00	DIA	ETF	105.38	105.48	105.3	105.46	277800.0
2005-07-13 14:00:00	DIA	ETF	105.46	105.56	105.42	105.44	647500.0
2005-07-13 15:00:00	DIA	ETF	105.45	105.66	105.35	105.49	1304600.0
2005-07-13 16:00:00	DIA	ETF	105.49	105.7	105.49	105.7	280200.0
2005-07-13 17:00:00	DIA	ETF	105.7	105.7	105.7	105.7	100.0
2005-07-13 08:00:00	GLD	ETF	42.49	42.52	42.49	42.52	3000.0
2005-07-13 09:00:00	GLD	ETF	42.36	42.37	42.31	42.36	128900.0
2005-07-13 10:00:00	GLD	ETF	42.36	42.38	42.25	42.3	151000.0
2005-07-13 11:00:00	GLD	ETF	42.3	42.36	42.28	42.3	60600.0
2005-07-13 12:00:00	GLD	ETF	42.3	42.36	42.29	42.32	250500.0
2005-07-13 13:00:00	GLD	ETF	42.33	42.36	42.31	42.34	153800.0
2005-07-13 14:00:00	GLD	ETF	42.35	42.36	42.32	42.34	100400.0
2005-07-13 15:00:00	GLD	ETF	42.34	42.36	42.32	42.35	104100.0

> showing 50 of 929 rows — these rows as CSV

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