PREVIEW / etf_1hour / 2010-01-13

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-01-13.parquet
  size:    151 KB
  rows:    4,628

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-13 04:00:00	SPY	ETF	114.08	114.08	114.03	114.03	1250.0
2010-01-13 05:00:00	SPY	ETF	113.95	113.95	113.9	113.9	25580.0
2010-01-13 06:00:00	SPY	ETF	113.94	113.94	113.94	113.94	100.0
2010-01-13 07:00:00	SPY	ETF	113.88	114.15	113.88	114.09	612423.0
2010-01-13 08:00:00	SPY	ETF	114.09	114.18	113.9	113.99	1172196.0
2010-01-13 09:00:00	SPY	ETF	114.0	114.11	113.79	113.83	17619489.0
2010-01-13 10:00:00	SPY	ETF	113.83	113.88	113.37	113.72	28369751.0
2010-01-13 11:00:00	SPY	ETF	113.72	114.13	113.64	114.05	21073056.0
2010-01-13 12:00:00	SPY	ETF	114.05	114.54	113.65	114.3501	21727024.0
2010-01-13 13:00:00	SPY	ETF	114.35	114.51	114.28	114.32	13964974.0
2010-01-13 14:00:00	SPY	ETF	114.31	114.68	114.29	114.67	17684389.0
2010-01-13 15:00:00	SPY	ETF	114.67	114.94	114.54	114.64	27135093.0
2010-01-13 16:00:00	SPY	ETF	114.63	114.9298	113.56	114.62	7975880.0
2010-01-13 17:00:00	SPY	ETF	114.62	114.64	113.61	114.59	569632.0
2010-01-13 18:00:00	SPY	ETF	114.58	114.61	114.56	114.61	25814.0
2010-01-13 19:00:00	SPY	ETF	114.64	114.82	114.62	114.82	65763.0
2010-01-13 04:00:00	QQQ	ETF	45.99	45.99	45.97	45.97	900.0
2010-01-13 07:00:00	QQQ	ETF	45.92	46.01	45.9	45.98	217584.0
2010-01-13 08:00:00	QQQ	ETF	45.98	46.03	45.93	45.93	378590.0
2010-01-13 09:00:00	QQQ	ETF	45.93	46.08	45.82	45.835	10613341.0
2010-01-13 10:00:00	QQQ	ETF	45.84	45.87	45.61	45.83	18047922.0
2010-01-13 11:00:00	QQQ	ETF	45.83	45.94	45.76	45.87	8228070.0
2010-01-13 12:00:00	QQQ	ETF	45.875	46.22	45.87	46.16	13028329.0
2010-01-13 13:00:00	QQQ	ETF	46.16	46.3	46.11	46.23	9221111.0
2010-01-13 14:00:00	QQQ	ETF	46.24	46.39	46.22	46.39	9080018.0
2010-01-13 15:00:00	QQQ	ETF	46.39	46.49	46.3	46.36	14690238.0
2010-01-13 16:00:00	QQQ	ETF	46.36	46.42	45.7745	46.32	7223796.0
2010-01-13 17:00:00	QQQ	ETF	46.33	46.34	46.31	46.34	46550.0
2010-01-13 18:00:00	QQQ	ETF	46.33	46.33	46.3	46.33	40450.0
2010-01-13 19:00:00	QQQ	ETF	46.33	46.37	46.32	46.37	52372.0
2010-01-13 07:00:00	IWM	ETF	63.72	63.88	63.72	63.83	184600.0
2010-01-13 08:00:00	IWM	ETF	63.85	64.04	63.7	63.72	710702.0
2010-01-13 09:00:00	IWM	ETF	63.73	63.9	63.6	63.69	5298316.0
2010-01-13 10:00:00	IWM	ETF	63.7	63.74	63.23	63.59	6091522.0
2010-01-13 11:00:00	IWM	ETF	63.59	63.83	63.46	63.79	3502076.0
2010-01-13 12:00:00	IWM	ETF	63.8	64.2099	63.77	64.03	4627302.0
2010-01-13 13:00:00	IWM	ETF	64.03	64.16	63.96	64.04	2427169.0
2010-01-13 14:00:00	IWM	ETF	64.04	64.41	64.03	64.41	4983745.0
2010-01-13 15:00:00	IWM	ETF	64.41	64.51	64.25	64.36	8412670.0
2010-01-13 16:00:00	IWM	ETF	64.37	64.38	64.0199	64.24	3164965.0
2010-01-13 17:00:00	IWM	ETF	64.25	64.27	64.22	64.22	12000.0
2010-01-13 18:00:00	IWM	ETF	64.17	64.18	64.17	64.18	768.0
2010-01-13 19:00:00	IWM	ETF	64.29	64.35	64.24	64.27	2300.0
2010-01-13 07:00:00	DIA	ETF	106.27	106.27	106.27	106.27	100.0
2010-01-13 08:00:00	DIA	ETF	106.54	106.54	106.37	106.37	61600.0
2010-01-13 09:00:00	DIA	ETF	106.39	106.58	106.31	106.41	1314084.0
2010-01-13 10:00:00	DIA	ETF	106.42	106.45	106.035	106.26	2026686.0
2010-01-13 11:00:00	DIA	ETF	106.2636	106.51	106.19	106.45	1197615.0
2010-01-13 12:00:00	DIA	ETF	106.45	106.79	106.445	106.62	963708.0
2010-01-13 13:00:00	DIA	ETF	106.62	106.68	106.49	106.505	646257.0

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

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