PREVIEW / etf_1hour / 2008-04-22

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-04-22.parquet
  size:    105 KB
  rows:    3,356

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-04-22 04:00:00	SPY	ETF	138.29	138.29	138.29	138.29	100.0
2008-04-22 05:00:00	SPY	ETF	138.47	138.62	138.47	138.62	100100.0
2008-04-22 06:00:00	SPY	ETF	138.7	138.75	138.42	138.47	273000.0
2008-04-22 07:00:00	SPY	ETF	138.44	138.68	138.4	138.48	485951.0
2008-04-22 08:00:00	SPY	ETF	138.51	138.63	138.0	138.33	865040.0
2008-04-22 09:00:00	SPY	ETF	138.34	138.37	137.7	137.87	16298787.0
2008-04-22 10:00:00	SPY	ETF	137.86	138.31	137.59	138.06	24761010.0
2008-04-22 11:00:00	SPY	ETF	138.07	138.14	136.64	137.5012	21854932.0
2008-04-22 12:00:00	SPY	ETF	137.5	137.58	136.93	137.01	23033830.0
2008-04-22 13:00:00	SPY	ETF	137.0011	138.37	136.92	137.41	17522870.0
2008-04-22 14:00:00	SPY	ETF	137.41	137.55	136.9	137.1	20990540.0
2008-04-22 15:00:00	SPY	ETF	137.11	137.69	137.01	137.69	23806951.0
2008-04-22 16:00:00	SPY	ETF	137.7	138.05	137.46	138.0	8660445.0
2008-04-22 17:00:00	SPY	ETF	138.0	138.19	137.96	138.1	403130.0
2008-04-22 18:00:00	SPY	ETF	138.1	138.1	137.9	137.95	157595.0
2008-04-22 19:00:00	SPY	ETF	137.91	138.05	137.91	137.98	23402.0
2008-04-22 04:00:00	QQQ	ETF	46.75	46.75	46.75	46.75	100.0
2008-04-22 06:00:00	QQQ	ETF	46.78	46.78	46.73	46.73	2800.0
2008-04-22 07:00:00	QQQ	ETF	46.82	46.87	46.78	46.78	259971.0
2008-04-22 08:00:00	QQQ	ETF	46.8	46.85	46.65	46.77	349382.0
2008-04-22 09:00:00	QQQ	ETF	46.76	46.77	46.57	46.62	9002886.0
2008-04-22 10:00:00	QQQ	ETF	46.62	46.77	46.48	46.62	18666934.0
2008-04-22 11:00:00	QQQ	ETF	46.63	46.66	46.29	46.3285	14107876.0
2008-04-22 12:00:00	QQQ	ETF	46.32	46.33	45.93	45.98	15754632.0
2008-04-22 13:00:00	QQQ	ETF	45.98	46.25	45.95	46.2278	8999387.0
2008-04-22 14:00:00	QQQ	ETF	46.23	46.281	46.05	46.12	8981301.0
2008-04-22 15:00:00	QQQ	ETF	46.12	46.35	46.09	46.33	15145173.0
2008-04-22 16:00:00	QQQ	ETF	46.33	46.6	46.26	46.49	8694472.0
2008-04-22 17:00:00	QQQ	ETF	46.5	46.54	46.49	46.54	141185.0
2008-04-22 18:00:00	QQQ	ETF	46.52	46.54	46.5	46.5	583413.0
2008-04-22 19:00:00	QQQ	ETF	46.52	46.53	46.5	46.51	22302.0
2008-04-22 07:00:00	IWM	ETF	71.47	71.57	71.4	71.4	62900.0
2008-04-22 08:00:00	IWM	ETF	71.41	71.44	71.28	71.28	292530.0
2008-04-22 09:00:00	IWM	ETF	71.28	71.29	70.49	70.56	9409179.0
2008-04-22 10:00:00	IWM	ETF	70.56	70.82	70.43	70.69	12772197.0
2008-04-22 11:00:00	IWM	ETF	70.69	70.75	70.19	70.24	7780709.0
2008-04-22 12:00:00	IWM	ETF	70.24	70.25	69.51	69.61	13349996.0
2008-04-22 13:00:00	IWM	ETF	69.62	70.0	69.57	69.95	7808139.0
2008-04-22 14:00:00	IWM	ETF	69.96	69.98	69.59	69.71	7211554.0
2008-04-22 15:00:00	IWM	ETF	69.7	71.6	69.62	70.32	11939265.0
2008-04-22 16:00:00	IWM	ETF	70.32	71.6	70.19	70.73	5734882.0
2008-04-22 17:00:00	IWM	ETF	70.71	70.78	70.35	70.6	730002.0
2008-04-22 18:00:00	IWM	ETF	70.65	70.73	70.44	70.67	415810.0
2008-04-22 19:00:00	IWM	ETF	70.56	70.56	70.56	70.56	200.0
2008-04-22 07:00:00	DIA	ETF	128.07	128.07	128.05	128.05	2500.0
2008-04-22 08:00:00	DIA	ETF	128.07	128.21	127.88	127.88	50630.0
2008-04-22 09:00:00	DIA	ETF	127.87	127.87	127.32	127.43	1316065.0
2008-04-22 10:00:00	DIA	ETF	127.44	127.76	127.15	127.56	1772372.0
2008-04-22 11:00:00	DIA	ETF	127.56	127.62	126.94	126.99	1231357.0
2008-04-22 12:00:00	DIA	ETF	126.99	127.14	126.47	126.52	1007744.0

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

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