PREVIEW / etf_1hour / 2008-12-05

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-12-05.parquet
  size:    118 KB
  rows:    3,823

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
2008-12-05 04:00:00	SPY	ETF	85.32	85.56	85.29	85.5	4811.0
2008-12-05 05:00:00	SPY	ETF	85.3	85.3	85.26	85.26	1000.0
2008-12-05 06:00:00	SPY	ETF	85.09	85.1	84.91	85.0	9400.0
2008-12-05 07:00:00	SPY	ETF	85.1	85.1	84.33	84.4	1301683.0
2008-12-05 08:00:00	SPY	ETF	84.38	85.07	82.74	83.84	18258644.0
2008-12-05 09:00:00	SPY	ETF	83.85	85.3	83.25	83.27	48503676.0
2008-12-05 10:00:00	SPY	ETF	83.25	83.85	82.24	83.11	65811453.0
2008-12-05 11:00:00	SPY	ETF	83.11	83.79	82.48	83.5409	43349893.0
2008-12-05 12:00:00	SPY	ETF	83.55	84.0	83.06	83.41	28358803.0
2008-12-05 13:00:00	SPY	ETF	83.41	85.58	82.3	85.05	49173646.0
2008-12-05 14:00:00	SPY	ETF	85.048	87.32	84.42	86.88	73821039.0
2008-12-05 15:00:00	SPY	ETF	86.88	88.42	86.09	88.04	124140556.0
2008-12-05 16:00:00	SPY	ETF	88.09	88.1	82.8	87.59	14646861.0
2008-12-05 17:00:00	SPY	ETF	87.59	87.74	87.55	87.66	3230441.0
2008-12-05 18:00:00	SPY	ETF	87.67	87.75	87.6	87.75	151277.0
2008-12-05 19:00:00	SPY	ETF	87.8	87.8	87.66	87.72	20604.0
2008-12-05 04:00:00	QQQ	ETF	27.98	27.98	27.98	27.98	200.0
2008-12-05 05:00:00	QQQ	ETF	27.88	27.88	27.83	27.83	1100.0
2008-12-05 06:00:00	QQQ	ETF	27.78	27.78	27.78	27.78	100.0
2008-12-05 07:00:00	QQQ	ETF	27.72	27.72	27.55	27.55	479573.0
2008-12-05 08:00:00	QQQ	ETF	27.6	27.71	27.17	27.49	6359613.0
2008-12-05 09:00:00	QQQ	ETF	27.5	27.7	27.23	27.2395	23889608.0
2008-12-05 10:00:00	QQQ	ETF	27.23	27.37	26.95	27.29	33475241.0
2008-12-05 11:00:00	QQQ	ETF	27.29	27.48	27.0	27.4	16183869.0
2008-12-05 12:00:00	QQQ	ETF	27.3995	27.51	27.25	27.36	9101425.0
2008-12-05 13:00:00	QQQ	ETF	27.37	28.36	27.28	28.21	23989421.0
2008-12-05 14:00:00	QQQ	ETF	28.211	28.83	27.93	28.65	35638928.0
2008-12-05 15:00:00	QQQ	ETF	28.65	29.07	28.38	28.94	55308199.0
2008-12-05 16:00:00	QQQ	ETF	28.94	29.0	27.7608	27.7608	5650731.0
2008-12-05 17:00:00	QQQ	ETF	28.86	28.93	28.86	28.93	535770.0
2008-12-05 18:00:00	QQQ	ETF	28.9	28.93	28.89	28.92	10262.0
2008-12-05 19:00:00	QQQ	ETF	28.86	29.03	28.86	29.03	17480.0
2008-12-05 07:00:00	IWM	ETF	43.89	43.96	43.8	43.87	22500.0
2008-12-05 08:00:00	IWM	ETF	43.87	44.13	42.98	43.37	1616372.0
2008-12-05 09:00:00	IWM	ETF	43.36	44.06	42.89	42.9	10435672.0
2008-12-05 10:00:00	IWM	ETF	42.9	43.38	42.34	43.21	16387153.0
2008-12-05 11:00:00	IWM	ETF	43.21	43.62	42.88	43.53	6347655.0
2008-12-05 12:00:00	IWM	ETF	43.53	44.01	43.41	43.58	7430564.0
2008-12-05 13:00:00	IWM	ETF	43.58	45.09	43.58	44.67	14028347.0
2008-12-05 14:00:00	IWM	ETF	44.68	45.64	44.02	45.5	17756987.0
2008-12-05 15:00:00	IWM	ETF	45.51	46.27	44.81	46.07	26424681.0
2008-12-05 16:00:00	IWM	ETF	46.08	46.26	44.07	45.77	9717252.0
2008-12-05 17:00:00	IWM	ETF	45.75	45.84	45.75	45.84	4250.0
2008-12-05 18:00:00	IWM	ETF	45.84	45.84	45.84	45.84	2035.0
2008-12-05 19:00:00	IWM	ETF	45.83	45.84	45.83	45.84	3975.0
2008-12-05 06:00:00	DIA	ETF	84.01	84.09	84.01	84.09	400.0
2008-12-05 07:00:00	DIA	ETF	83.8	83.8	83.5	83.5	6311.0
2008-12-05 08:00:00	DIA	ETF	83.54	83.56	82.22	83.06	284389.0
2008-12-05 09:00:00	DIA	ETF	83.04	83.59	82.28	82.29	5032611.0
2008-12-05 10:00:00	DIA	ETF	82.28	82.44	81.31	82.01	6385851.0

> showing 50 of 3,823 rows — these rows as CSV

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