PREVIEW / etf_1hour / 2007-04-23

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-04-23.parquet
  size:    69 KB
  rows:    2,236

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
2007-04-23 06:00:00	SPY	ETF	148.39	148.6	148.39	148.6	102400.0
2007-04-23 07:00:00	SPY	ETF	148.56	148.6	148.5	148.54	95200.0
2007-04-23 08:00:00	SPY	ETF	148.57	148.59	148.29	148.45	1175000.0
2007-04-23 09:00:00	SPY	ETF	148.45	148.73	148.21	148.5915	15724475.0
2007-04-23 10:00:00	SPY	ETF	148.59	148.68	148.42	148.55	11271921.0
2007-04-23 11:00:00	SPY	ETF	148.54	148.61	148.35	148.47	10991471.0
2007-04-23 12:00:00	SPY	ETF	148.47	148.49	148.28	148.38	4447676.0
2007-04-23 13:00:00	SPY	ETF	148.38	148.47	148.09	148.1	11355636.0
2007-04-23 14:00:00	SPY	ETF	148.09	148.32	147.97	148.2	8705323.0
2007-04-23 15:00:00	SPY	ETF	148.19	148.31	148.06	148.12	9437935.0
2007-04-23 16:00:00	SPY	ETF	148.12	148.37	148.05	148.35	2211800.0
2007-04-23 17:00:00	SPY	ETF	148.35	148.38	148.17	148.2	948800.0
2007-04-23 18:00:00	SPY	ETF	148.2	148.2	148.14	148.14	303400.0
2007-04-23 19:00:00	SPY	ETF	148.2	148.2	148.19	148.19	12000.0
2007-04-23 04:00:00	QQQ	ETF	45.41	45.41	45.4	45.4	14400.0
2007-04-23 06:00:00	QQQ	ETF	45.42	45.45	45.42	45.44	72701.0
2007-04-23 07:00:00	QQQ	ETF	45.47	45.5	45.47	45.48	42637.0
2007-04-23 08:00:00	QQQ	ETF	45.48	45.48	45.44	45.44	951467.0
2007-04-23 09:00:00	QQQ	ETF	45.44	45.56	45.4	45.51	12520838.0
2007-04-23 10:00:00	QQQ	ETF	45.51	45.55	45.42	45.53	14595800.0
2007-04-23 11:00:00	QQQ	ETF	45.52	45.6	45.48	45.54	10051700.0
2007-04-23 12:00:00	QQQ	ETF	45.53	45.54	45.43	45.5	8247100.0
2007-04-23 13:00:00	QQQ	ETF	45.51	45.55	45.39	45.39	9760000.0
2007-04-23 14:00:00	QQQ	ETF	45.4	45.5	45.34	45.47	8906600.0
2007-04-23 15:00:00	QQQ	ETF	45.47	45.54	45.44	45.47	12415500.0
2007-04-23 16:00:00	QQQ	ETF	45.47	45.69	45.44	45.68	6472336.0
2007-04-23 17:00:00	QQQ	ETF	45.69	45.7	45.59	45.62	471680.0
2007-04-23 18:00:00	QQQ	ETF	45.62	45.63	45.6	45.62	36418.0
2007-04-23 19:00:00	QQQ	ETF	45.62	45.65	45.61	45.64	54040.0
2007-04-23 08:00:00	IWM	ETF	82.14	82.21	82.14	82.18	76000.0
2007-04-23 09:00:00	IWM	ETF	82.17	82.51	82.02	82.41	7070054.0
2007-04-23 10:00:00	IWM	ETF	82.4	82.46	82.24	82.29	5185700.0
2007-04-23 11:00:00	IWM	ETF	82.29	82.4	82.16	82.26	3509278.0
2007-04-23 12:00:00	IWM	ETF	82.26	82.3	82.1	82.23	1805100.0
2007-04-23 13:00:00	IWM	ETF	82.23	82.36	81.94	81.95	7217606.0
2007-04-23 14:00:00	IWM	ETF	81.96	82.14	81.88	82.08	3435925.0
2007-04-23 15:00:00	IWM	ETF	82.08	82.25	82.03	82.17	4752365.0
2007-04-23 16:00:00	IWM	ETF	82.16	82.51	82.15	82.51	446500.0
2007-04-23 17:00:00	IWM	ETF	82.48	82.48	82.37	82.37	1220300.0
2007-04-23 18:00:00	IWM	ETF	82.37	82.37	82.37	82.37	2300.0
2007-04-23 07:00:00	DIA	ETF	129.66	129.66	129.66	129.66	600.0
2007-04-23 08:00:00	DIA	ETF	129.61	129.61	129.53	129.54	9200.0
2007-04-23 09:00:00	DIA	ETF	129.54	129.73	129.17	129.61	1160775.0
2007-04-23 10:00:00	DIA	ETF	129.61	129.68	128.49	129.53	1023983.0
2007-04-23 11:00:00	DIA	ETF	129.5299	129.61	129.42	129.53	619550.0
2007-04-23 12:00:00	DIA	ETF	129.52	129.54	129.4	129.48	780988.0
2007-04-23 13:00:00	DIA	ETF	129.5	129.54	129.19	129.2	475500.0
2007-04-23 14:00:00	DIA	ETF	129.2	129.33	129.08	129.26	658300.0
2007-04-23 15:00:00	DIA	ETF	129.26	129.29	129.06	129.12	2407497.0
2007-04-23 16:00:00	DIA	ETF	129.14	129.37	129.12	129.35	223600.0

> showing 50 of 2,236 rows — these rows as CSV

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