PREVIEW / etf_1hour / 2009-07-01

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-07-01.parquet
  size:    135 KB
  rows:    4,154

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
2009-07-01 04:00:00	SPY	ETF	92.53	92.67	92.53	92.67	2074.0
2009-07-01 05:00:00	SPY	ETF	92.62	92.66	92.6	92.6	62100.0
2009-07-01 06:00:00	SPY	ETF	92.58	92.8	92.5	92.5	20100.0
2009-07-01 07:00:00	SPY	ETF	92.5	92.63	92.35	92.63	1037571.0
2009-07-01 08:00:00	SPY	ETF	92.63	92.68	92.0	92.44	5944848.0
2009-07-01 09:00:00	SPY	ETF	92.43	92.88	92.33	92.87	25072605.0
2009-07-01 10:00:00	SPY	ETF	92.86	93.23	92.411	93.0705	38414892.0
2009-07-01 11:00:00	SPY	ETF	93.08	93.14	92.83	92.96	16921111.0
2009-07-01 12:00:00	SPY	ETF	92.96	93.08	92.775	92.78	12059913.0
2009-07-01 13:00:00	SPY	ETF	92.79	92.96	92.77	92.8799	11840404.0
2009-07-01 14:00:00	SPY	ETF	92.88	92.89	92.54	92.63	17376628.0
2009-07-01 15:00:00	SPY	ETF	92.63	92.73	92.21	92.34	34070617.0
2009-07-01 16:00:00	SPY	ETF	92.34	93.15	92.26	92.37	8612338.0
2009-07-01 17:00:00	SPY	ETF	92.37	92.44	91.92	92.43	1042629.0
2009-07-01 18:00:00	SPY	ETF	92.41	92.41	92.36	92.37	37586.0
2009-07-01 19:00:00	SPY	ETF	92.4	92.4	92.35	92.39	50550.0
2009-07-01 04:00:00	QQQ	ETF	36.54	36.58	36.54	36.58	3700.0
2009-07-01 06:00:00	QQQ	ETF	36.64	36.68	36.59	36.59	11793.0
2009-07-01 07:00:00	QQQ	ETF	36.56	36.61	36.51	36.61	185230.0
2009-07-01 08:00:00	QQQ	ETF	36.61	36.66	36.38	36.61	3845574.0
2009-07-01 09:00:00	QQQ	ETF	36.6	36.69	36.5	36.68	11017354.0
2009-07-01 10:00:00	QQQ	ETF	36.67	36.84	36.52	36.7775	18085783.0
2009-07-01 11:00:00	QQQ	ETF	36.77	36.8	36.7	36.77	8221477.0
2009-07-01 12:00:00	QQQ	ETF	36.77	36.79	36.65	36.6599	5395501.0
2009-07-01 13:00:00	QQQ	ETF	36.65	36.71	36.63	36.65	6486233.0
2009-07-01 14:00:00	QQQ	ETF	36.6499	36.66	36.5	36.54	8789589.0
2009-07-01 15:00:00	QQQ	ETF	36.54	36.59	36.39	36.41	17598974.0
2009-07-01 16:00:00	QQQ	ETF	36.41	36.5787	36.38	36.41	5852536.0
2009-07-01 17:00:00	QQQ	ETF	36.42	36.43	36.41	36.41	55543.0
2009-07-01 18:00:00	QQQ	ETF	36.42	36.42	36.4	36.42	40426.0
2009-07-01 19:00:00	QQQ	ETF	36.42	36.42	36.41	36.42	18800.0
2009-07-01 06:00:00	IWM	ETF	51.47	51.54	51.47	51.54	463.0
2009-07-01 07:00:00	IWM	ETF	51.32	51.42	51.32	51.42	63929.0
2009-07-01 08:00:00	IWM	ETF	51.42	51.5	51.08	51.34	1083357.0
2009-07-01 09:00:00	IWM	ETF	51.34	51.8	51.31	51.74	6772798.0
2009-07-01 10:00:00	IWM	ETF	51.74	52.25	51.55	52.14	7999919.0
2009-07-01 11:00:00	IWM	ETF	52.14	52.17	51.9	52.06	3312383.0
2009-07-01 12:00:00	IWM	ETF	52.05	52.07	51.91	51.92	2370320.0
2009-07-01 13:00:00	IWM	ETF	51.93	52.09	51.92	52.02	1970151.0
2009-07-01 14:00:00	IWM	ETF	52.03	52.05	51.86	51.97	4123322.0
2009-07-01 15:00:00	IWM	ETF	51.97	52.05	51.79	51.84	12639517.0
2009-07-01 16:00:00	IWM	ETF	51.84	52.05	51.75	51.81	2533641.0
2009-07-01 17:00:00	IWM	ETF	51.77	51.82	51.74	51.81	54050.0
2009-07-01 18:00:00	IWM	ETF	51.8	51.8	51.8	51.8	200.0
2009-07-01 06:00:00	DIA	ETF	85.1	85.1	85.07	85.07	1100.0
2009-07-01 07:00:00	DIA	ETF	84.93	85.06	84.83	85.06	4400.0
2009-07-01 08:00:00	DIA	ETF	85.07	85.07	84.72	84.96	39029.0
2009-07-01 09:00:00	DIA	ETF	84.95	85.45	84.92	85.43	1099100.0
2009-07-01 10:00:00	DIA	ETF	85.44	85.8301	84.99	85.69	2639302.0
2009-07-01 11:00:00	DIA	ETF	85.682	85.74	85.442	85.56	813344.0

> showing 50 of 4,154 rows — these rows as CSV

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