PREVIEW / etf_1hour / 2010-10-07

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-10-07.parquet
  size:    166 KB
  rows:    5,085

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-10-07 04:00:00	SPY	ETF	116.11	116.11	116.03	116.03	800.0
2010-10-07 05:00:00	SPY	ETF	115.9	116.1	115.9	115.9	15100.0
2010-10-07 06:00:00	SPY	ETF	116.09	116.2	116.09	116.16	52850.0
2010-10-07 07:00:00	SPY	ETF	116.16	116.22	116.02	116.02	130375.0
2010-10-07 08:00:00	SPY	ETF	116.01	116.83	115.94	116.68	3860007.0
2010-10-07 09:00:00	SPY	ETF	116.68	116.81	115.73	115.77	26612638.0
2010-10-07 10:00:00	SPY	ETF	115.78	116.26	115.68	115.97	30970128.0
2010-10-07 11:00:00	SPY	ETF	115.97	116.0	115.7	115.83	15182848.0
2010-10-07 12:00:00	SPY	ETF	115.83	115.87	115.19	115.4	20925952.0
2010-10-07 13:00:00	SPY	ETF	115.3938	115.82	115.33	115.74	19116738.0
2010-10-07 14:00:00	SPY	ETF	115.73	115.96	115.66	115.89	18530084.0
2010-10-07 15:00:00	SPY	ETF	115.89	116.01	115.69	115.89	20524183.0
2010-10-07 16:00:00	SPY	ETF	115.89	116.435	115.795	116.06	6606373.0
2010-10-07 17:00:00	SPY	ETF	116.07	116.2	116.04	116.15	215984.0
2010-10-07 18:00:00	SPY	ETF	116.14	116.16	115.89	116.15	124163.0
2010-10-07 19:00:00	SPY	ETF	116.14	116.18	116.14	116.18	36075.0
2010-10-07 06:00:00	QQQ	ETF	49.26	49.27	49.26	49.27	15960.0
2010-10-07 07:00:00	QQQ	ETF	49.25	49.3	49.21	49.22	120514.0
2010-10-07 08:00:00	QQQ	ETF	49.21	49.6	49.1	49.58	1118822.0
2010-10-07 09:00:00	QQQ	ETF	49.58	49.63	49.05	49.08	10837277.0
2010-10-07 10:00:00	QQQ	ETF	49.07	49.54	49.0	49.4	16728885.0
2010-10-07 11:00:00	QQQ	ETF	49.39	49.43	49.26	49.3299	9252798.0
2010-10-07 12:00:00	QQQ	ETF	49.32	49.34	49.03	49.1296	5935044.0
2010-10-07 13:00:00	QQQ	ETF	49.13	49.36	49.09	49.31	8505321.0
2010-10-07 14:00:00	QQQ	ETF	49.31	49.409	49.23	49.36	9115515.0
2010-10-07 15:00:00	QQQ	ETF	49.36	49.465	49.3	49.39	6742582.0
2010-10-07 16:00:00	QQQ	ETF	49.4	49.54	49.215	49.5	2368128.0
2010-10-07 17:00:00	QQQ	ETF	49.5	49.51	49.48	49.48	20636.0
2010-10-07 18:00:00	QQQ	ETF	49.48	49.51	49.48	49.5	33850.0
2010-10-07 19:00:00	QQQ	ETF	49.51	49.52	49.51	49.52	2931.0
2010-10-07 07:00:00	IWM	ETF	68.78	68.82	68.63	68.63	64285.0
2010-10-07 08:00:00	IWM	ETF	68.66	69.34	68.56	69.19	726532.0
2010-10-07 09:00:00	IWM	ETF	69.2	69.25	68.38	68.39	6811353.0
2010-10-07 10:00:00	IWM	ETF	68.38	68.9	68.31	68.66	5648587.0
2010-10-07 11:00:00	IWM	ETF	68.65	68.75	68.44	68.66	3000396.0
2010-10-07 12:00:00	IWM	ETF	68.652	68.67	67.92	68.12	4345320.0
2010-10-07 13:00:00	IWM	ETF	68.12	68.7	68.11	68.65	4196039.0
2010-10-07 14:00:00	IWM	ETF	68.6485	68.79	68.5	68.64	5390672.0
2010-10-07 15:00:00	IWM	ETF	68.64	68.73	68.4	68.42	5822711.0
2010-10-07 16:00:00	IWM	ETF	68.41	68.63	68.41	68.6	1271167.0
2010-10-07 17:00:00	IWM	ETF	68.58	68.58	68.55	68.58	19340.0
2010-10-07 18:00:00	IWM	ETF	68.58	68.61	68.58	68.61	700.0
2010-10-07 19:00:00	IWM	ETF	68.61	68.61	68.61	68.61	700.0
2010-10-07 05:00:00	DIA	ETF	109.59	109.59	109.59	109.59	100.0
2010-10-07 08:00:00	DIA	ETF	109.73	110.36	109.73	110.32	91000.0
2010-10-07 09:00:00	DIA	ETF	110.31	110.35	109.51	109.56	837724.0
2010-10-07 10:00:00	DIA	ETF	109.56	109.88	109.47	109.63	1003377.0
2010-10-07 11:00:00	DIA	ETF	109.6259	109.69	109.46	109.56	607963.0
2010-10-07 12:00:00	DIA	ETF	109.54	109.57	109.01	109.24	750447.0
2010-10-07 13:00:00	DIA	ETF	109.2278	109.53	109.17	109.4719	566684.0

> showing 50 of 5,085 rows — these rows as CSV

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