PREVIEW / etf_1hour / 2008-12-04

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-12-04.parquet
  size:    115 KB
  rows:    3,761

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-04 04:00:00	SPY	ETF	87.51	87.76	87.24	87.76	6050.0
2008-12-04 05:00:00	SPY	ETF	87.67	87.97	87.57	87.65	9050.0
2008-12-04 06:00:00	SPY	ETF	87.48	87.77	87.31	87.6	92359.0
2008-12-04 07:00:00	SPY	ETF	87.43	87.82	86.74	86.96	2116601.0
2008-12-04 08:00:00	SPY	ETF	87.15	87.52	85.58	86.0	10280336.0
2008-12-04 09:00:00	SPY	ETF	86.05	87.55	85.93	87.17	36469766.0
2008-12-04 10:00:00	SPY	ETF	87.17	88.05	86.5	87.92	66084356.0
2008-12-04 11:00:00	SPY	ETF	87.92	88.0	86.78	87.2	48835597.0
2008-12-04 12:00:00	SPY	ETF	87.2	87.31	86.34	86.8	31287259.0
2008-12-04 13:00:00	SPY	ETF	86.8008	87.27	86.03	86.97	40194333.0
2008-12-04 14:00:00	SPY	ETF	86.97	87.52	86.33	86.35	55730491.0
2008-12-04 15:00:00	SPY	ETF	86.35	87.2	83.74	84.88	123422410.0
2008-12-04 16:00:00	SPY	ETF	84.92	87.5338	84.87	85.19	23395433.0
2008-12-04 17:00:00	SPY	ETF	85.2	85.36	85.01	85.15	2141554.0
2008-12-04 18:00:00	SPY	ETF	85.16	85.32	85.12	85.31	184232.0
2008-12-04 19:00:00	SPY	ETF	85.32	85.45	85.1	85.22	136633.0
2008-12-04 06:00:00	QQQ	ETF	28.58	28.58	28.51	28.57	4752.0
2008-12-04 07:00:00	QQQ	ETF	28.51	28.71	28.34	28.45	658978.0
2008-12-04 08:00:00	QQQ	ETF	28.42	28.5	27.97	27.98	4853713.0
2008-12-04 09:00:00	QQQ	ETF	27.99	28.58	27.95	28.43	17221258.0
2008-12-04 10:00:00	QQQ	ETF	28.43	28.78	28.24	28.75	34361388.0
2008-12-04 11:00:00	QQQ	ETF	28.75	28.76	28.33	28.4899	22690590.0
2008-12-04 12:00:00	QQQ	ETF	28.48	28.51	28.2	28.35	14815392.0
2008-12-04 13:00:00	QQQ	ETF	28.34	28.42	28.09	28.3	14209628.0
2008-12-04 14:00:00	QQQ	ETF	28.31	28.46	28.12	28.15	17571034.0
2008-12-04 15:00:00	QQQ	ETF	28.16	28.19	27.32	27.81	55306323.0
2008-12-04 16:00:00	QQQ	ETF	27.82	28.1634	27.69	27.84	3689956.0
2008-12-04 17:00:00	QQQ	ETF	27.81	27.88	27.7598	27.81	1373108.0
2008-12-04 18:00:00	QQQ	ETF	27.82	27.88	27.8	27.83	23714.0
2008-12-04 19:00:00	QQQ	ETF	27.85	27.89	27.79	27.79	41230.0
2008-12-04 06:00:00	IWM	ETF	45.67	45.67	45.66	45.66	5100.0
2008-12-04 07:00:00	IWM	ETF	45.5	45.5	45.16	45.28	16095.0
2008-12-04 08:00:00	IWM	ETF	45.19	45.19	44.57	44.72	465468.0
2008-12-04 09:00:00	IWM	ETF	44.63	46.15	44.61	45.83	11239413.0
2008-12-04 10:00:00	IWM	ETF	45.83	46.45	45.1	46.36	18259997.0
2008-12-04 11:00:00	IWM	ETF	46.36	46.39	45.53	45.85	10850487.0
2008-12-04 12:00:00	IWM	ETF	45.85	45.89	45.2	45.52	8620161.0
2008-12-04 13:00:00	IWM	ETF	45.51	45.68	45.05	45.44	6371160.0
2008-12-04 14:00:00	IWM	ETF	45.45	45.8	45.06	45.09	8558892.0
2008-12-04 15:00:00	IWM	ETF	45.09	45.15	43.26	44.07	29558758.0
2008-12-04 16:00:00	IWM	ETF	44.0	46.3	43.99	45.49	3142947.0
2008-12-04 17:00:00	IWM	ETF	44.27	44.27	44.13	44.13	4000.0
2008-12-04 18:00:00	IWM	ETF	44.23	44.25	44.23	44.25	300.0
2008-12-04 19:00:00	IWM	ETF	44.25	44.3	44.25	44.3	550.0
2008-12-04 06:00:00	DIA	ETF	85.97	85.97	85.97	85.97	100.0
2008-12-04 07:00:00	DIA	ETF	85.91	85.91	85.27	85.54	10489.0
2008-12-04 08:00:00	DIA	ETF	85.46	85.46	84.14	84.73	137331.0
2008-12-04 09:00:00	DIA	ETF	84.73	86.09	84.65	85.74	2878172.0
2008-12-04 10:00:00	DIA	ETF	85.74	86.46	85.27	86.32	7978996.0
2008-12-04 11:00:00	DIA	ETF	86.31	86.39	85.18	85.64	5373313.0

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

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