PREVIEW / etf_1hour / 2008-11-06

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-11-06.parquet
  size:    114 KB
  rows:    3,700

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-11-06 04:00:00	SPY	ETF	95.31	95.31	94.81	94.81	6800.0
2008-11-06 05:00:00	SPY	ETF	94.6	94.7	94.25	94.64	9200.0
2008-11-06 06:00:00	SPY	ETF	94.34	94.81	93.92	94.78	73900.0
2008-11-06 07:00:00	SPY	ETF	95.0	96.1	94.13	94.22	2381051.0
2008-11-06 08:00:00	SPY	ETF	94.26	95.76	93.9	94.83	4564170.0
2008-11-06 09:00:00	SPY	ETF	94.85	96.19	93.94	94.26	47454423.0
2008-11-06 10:00:00	SPY	ETF	94.26	94.92	92.72	93.27	61431533.0
2008-11-06 11:00:00	SPY	ETF	93.26	93.46	92.06	92.42	56508223.0
2008-11-06 12:00:00	SPY	ETF	92.42	92.68	91.22	91.67	62713862.0
2008-11-06 13:00:00	SPY	ETF	91.68	91.8	90.2991	91.26	59456426.0
2008-11-06 14:00:00	SPY	ETF	91.26	95.2	90.85	91.7	64844223.0
2008-11-06 15:00:00	SPY	ETF	91.71	91.95	90.06	90.65	97204803.0
2008-11-06 16:00:00	SPY	ETF	90.66	96.19	90.3435	91.15	16928565.0
2008-11-06 17:00:00	SPY	ETF	91.1	95.4451	90.49	90.83	3421996.0
2008-11-06 18:00:00	SPY	ETF	90.87	90.99	90.77	90.97	298527.0
2008-11-06 19:00:00	SPY	ETF	90.97	91.19	90.8	90.83	68318.0
2008-11-06 04:00:00	QQQ	ETF	31.49	31.49	31.49	31.49	4950.0
2008-11-06 05:00:00	QQQ	ETF	31.38	31.38	31.18	31.26	6700.0
2008-11-06 06:00:00	QQQ	ETF	31.23	31.35	31.08	31.34	3000.0
2008-11-06 07:00:00	QQQ	ETF	31.45	31.79	31.11	31.16	580891.0
2008-11-06 08:00:00	QQQ	ETF	31.21	31.71	31.15	31.58	2526846.0
2008-11-06 09:00:00	QQQ	ETF	31.58	31.87	31.2	31.28	32341320.0
2008-11-06 10:00:00	QQQ	ETF	31.281	31.53	30.89	31.15	31727306.0
2008-11-06 11:00:00	QQQ	ETF	31.15	31.2	30.89	31.06	21591780.0
2008-11-06 12:00:00	QQQ	ETF	31.0625	31.16	30.65	30.8	26031421.0
2008-11-06 13:00:00	QQQ	ETF	30.8	30.84	30.52	30.77	21764920.0
2008-11-06 14:00:00	QQQ	ETF	30.76	31.18	30.6	30.92	28704972.0
2008-11-06 15:00:00	QQQ	ETF	30.92	30.99	30.3999	30.58	43410361.0
2008-11-06 16:00:00	QQQ	ETF	30.57	31.9712	30.49	30.67	7216416.0
2008-11-06 17:00:00	QQQ	ETF	30.68	30.71	30.63	30.71	237808.0
2008-11-06 18:00:00	QQQ	ETF	30.7	30.71	30.64	30.65	87477.0
2008-11-06 19:00:00	QQQ	ETF	30.66	30.76	30.66	30.7	56469.0
2008-11-06 07:00:00	IWM	ETF	51.32	51.68	51.04	51.15	514315.0
2008-11-06 08:00:00	IWM	ETF	51.15	51.41	50.7	51.29	463936.0
2008-11-06 09:00:00	IWM	ETF	51.33	51.7	50.88	51.08	11416504.0
2008-11-06 10:00:00	IWM	ETF	51.05	51.26	50.35	50.76	10365877.0
2008-11-06 11:00:00	IWM	ETF	50.76	51.59	50.27	50.5	8208267.0
2008-11-06 12:00:00	IWM	ETF	50.5	50.69	49.73	50.18	9738922.0
2008-11-06 13:00:00	IWM	ETF	50.18	50.23	49.74	50.11	7122997.0
2008-11-06 14:00:00	IWM	ETF	50.11	50.97	50.0	50.67	12668944.0
2008-11-06 15:00:00	IWM	ETF	50.68	50.9	49.56	49.59	16348136.0
2008-11-06 16:00:00	IWM	ETF	49.62	51.48	49.54	49.92	5970820.0
2008-11-06 17:00:00	IWM	ETF	49.9	49.9	49.68	49.68	30200.0
2008-11-06 07:00:00	DIA	ETF	91.71	91.98	90.5	90.55	79629.0
2008-11-06 08:00:00	DIA	ETF	90.59	91.29	90.34	91.08	92565.0
2008-11-06 09:00:00	DIA	ETF	91.06	91.66	90.27	90.64	5547204.0
2008-11-06 10:00:00	DIA	ETF	90.63	90.77	89.16	89.62	6235723.0
2008-11-06 11:00:00	DIA	ETF	89.62	89.76	88.48	88.76	4832402.0
2008-11-06 12:00:00	DIA	ETF	88.76	88.99	87.62	88.03	4677432.0
2008-11-06 13:00:00	DIA	ETF	87.98	88.14	86.94	87.66	5166951.0

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

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