PREVIEW / etf_1hour / 2010-01-08

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-01-08.parquet
  size:    149 KB
  rows:    4,636

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
2010-01-08 04:00:00	SPY	ETF	114.25	114.25	114.25	114.25	100.0
2010-01-08 05:00:00	SPY	ETF	114.26	114.26	114.26	114.26	3500.0
2010-01-08 06:00:00	SPY	ETF	114.22	114.33	114.22	114.33	43600.0
2010-01-08 07:00:00	SPY	ETF	114.28	114.28	114.12	114.17	224500.0
2010-01-08 08:00:00	SPY	ETF	114.18	114.38	113.54	113.84	7843725.0
2010-01-08 09:00:00	SPY	ETF	113.85	114.24	113.66	114.06	18301962.0
2010-01-08 10:00:00	SPY	ETF	114.07	114.2	113.92	114.15	21142011.0
2010-01-08 11:00:00	SPY	ETF	114.125	114.2	113.96	114.11	12728972.0
2010-01-08 12:00:00	SPY	ETF	114.11	114.2	114.05	114.06	7138365.0
2010-01-08 13:00:00	SPY	ETF	114.07	114.31	114.06	114.08	10515197.0
2010-01-08 14:00:00	SPY	ETF	114.08	114.17	114.02	114.11	9848667.0
2010-01-08 15:00:00	SPY	ETF	114.11	114.61	114.06	114.57	20353312.0
2010-01-08 16:00:00	SPY	ETF	114.56	114.66	113.73	114.63	16833687.0
2010-01-08 17:00:00	SPY	ETF	114.66	114.76	114.64	114.7	176263.0
2010-01-08 18:00:00	SPY	ETF	114.7	114.72	114.65	114.68	16100.0
2010-01-08 19:00:00	SPY	ETF	114.7	114.71	114.6	114.7	28753.0
2010-01-08 06:00:00	QQQ	ETF	46.24	46.28	46.24	46.25	32300.0
2010-01-08 07:00:00	QQQ	ETF	46.26	46.26	46.21	46.22	185720.0
2010-01-08 08:00:00	QQQ	ETF	46.22	46.34	45.89	46.04	5436567.0
2010-01-08 09:00:00	QQQ	ETF	46.04	46.18	45.93	46.15	16846159.0
2010-01-08 10:00:00	QQQ	ETF	46.15	46.41	46.15	46.32	23027451.0
2010-01-08 11:00:00	QQQ	ETF	46.31	46.42	46.25	46.39	7324477.0
2010-01-08 12:00:00	QQQ	ETF	46.39	46.42	46.33	46.39	6315280.0
2010-01-08 13:00:00	QQQ	ETF	46.39	46.53	46.37	46.44	9170263.0
2010-01-08 14:00:00	QQQ	ETF	46.44	46.48	46.41	46.44	5402186.0
2010-01-08 15:00:00	QQQ	ETF	46.451	46.55	46.35	46.55	8940270.0
2010-01-08 16:00:00	QQQ	ETF	46.54	46.57	46.4246	46.51	4940258.0
2010-01-08 17:00:00	QQQ	ETF	46.49	46.55	46.49	46.53	30855.0
2010-01-08 18:00:00	QQQ	ETF	46.53	46.55	46.53	46.55	9170.0
2010-01-08 19:00:00	QQQ	ETF	46.54	46.55	46.54	46.54	15540.0
2010-01-08 07:00:00	IWM	ETF	64.18	64.18	64.14	64.14	24200.0
2010-01-08 08:00:00	IWM	ETF	63.9	64.33	63.7	63.94	2528772.0
2010-01-08 09:00:00	IWM	ETF	63.95	64.23	63.8	64.16	8234068.0
2010-01-08 10:00:00	IWM	ETF	64.16	64.25	63.98	64.1999	6581733.0
2010-01-08 11:00:00	IWM	ETF	64.2	64.2	64.0104	64.13	4126440.0
2010-01-08 12:00:00	IWM	ETF	64.12	64.22	64.11	64.165	1828197.0
2010-01-08 13:00:00	IWM	ETF	64.1581	64.33	64.13	64.16	3369090.0
2010-01-08 14:00:00	IWM	ETF	64.16	64.21	64.07	64.12	3531125.0
2010-01-08 15:00:00	IWM	ETF	64.12	64.5	64.09	64.5	6900952.0
2010-01-08 16:00:00	IWM	ETF	64.5	64.54	63.7621	64.54	6295498.0
2010-01-08 17:00:00	IWM	ETF	64.56	64.59	64.54	64.55	6900.0
2010-01-08 18:00:00	IWM	ETF	64.56	64.56	64.56	64.56	300.0
2010-01-08 19:00:00	IWM	ETF	64.51	64.51	64.51	64.51	100.0
2010-01-08 08:00:00	DIA	ETF	106.0	106.45	105.0	105.7	248620.0
2010-01-08 09:00:00	DIA	ETF	105.73	105.81	105.44	105.74	989999.0
2010-01-08 10:00:00	DIA	ETF	105.73	105.8	105.57	105.74	950097.0
2010-01-08 11:00:00	DIA	ETF	105.74	105.81	105.64	105.77	492499.0
2010-01-08 12:00:00	DIA	ETF	105.76	105.81	105.69	105.7	285547.0
2010-01-08 13:00:00	DIA	ETF	105.6841	105.83	105.63	105.65	460285.0
2010-01-08 14:00:00	DIA	ETF	105.65	105.72	105.61	105.6701	526044.0

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

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