PREVIEW / etf_1hour / 2008-09-30

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-09-30.parquet
  size:    117 KB
  rows:    3,771

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-09-30 04:00:00	SPY	ETF	114.0	114.87	113.02	114.45	22900.0
2008-09-30 05:00:00	SPY	ETF	114.5	114.83	114.5	114.58	11500.0
2008-09-30 06:00:00	SPY	ETF	114.62	114.85	113.59	113.59	131190.0
2008-09-30 07:00:00	SPY	ETF	113.59	114.41	113.0	114.09	1404868.0
2008-09-30 08:00:00	SPY	ETF	114.09	114.29	112.3	113.57	5058440.0
2008-09-30 09:00:00	SPY	ETF	113.58	114.64	112.71	113.11	29415661.0
2008-09-30 10:00:00	SPY	ETF	113.11	114.55	112.88	113.73	45665018.0
2008-09-30 11:00:00	SPY	ETF	113.73	114.68	113.5	114.5	23524096.0
2008-09-30 12:00:00	SPY	ETF	114.49	114.64	113.7	114.49	24808594.0
2008-09-30 13:00:00	SPY	ETF	114.49	115.45	113.93	115.12	38055109.0
2008-09-30 14:00:00	SPY	ETF	115.13	115.87	114.9	115.53	41306514.0
2008-09-30 15:00:00	SPY	ETF	115.53	116.8	115.1	116.7	82396067.0
2008-09-30 16:00:00	SPY	ETF	116.54	116.57	110.53	115.87	20198074.0
2008-09-30 17:00:00	SPY	ETF	115.9	116.03	110.53	115.94	8837952.0
2008-09-30 18:00:00	SPY	ETF	115.94	116.04	115.7	115.75	395028.0
2008-09-30 19:00:00	SPY	ETF	115.79	116.46	115.78	116.19	117293.0
2008-09-30 04:00:00	QQQ	ETF	38.03	38.1	37.83	37.83	7393.0
2008-09-30 05:00:00	QQQ	ETF	37.83	38.06	37.83	37.93	4700.0
2008-09-30 06:00:00	QQQ	ETF	37.99	37.99	37.57	37.57	10330.0
2008-09-30 07:00:00	QQQ	ETF	37.52	37.82	37.34	37.67	832966.0
2008-09-30 08:00:00	QQQ	ETF	37.45	37.73	37.43	37.57	2721211.0
2008-09-30 09:00:00	QQQ	ETF	37.56	38.07	37.53	37.78	27820681.0
2008-09-30 10:00:00	QQQ	ETF	37.82	38.37	37.67	38.11	37313020.0
2008-09-30 11:00:00	QQQ	ETF	38.11	38.55	37.99	38.51	23054279.0
2008-09-30 12:00:00	QQQ	ETF	38.51	38.54	38.13	38.45	15865392.0
2008-09-30 13:00:00	QQQ	ETF	38.45	38.71	38.25	38.52	19048921.0
2008-09-30 14:00:00	QQQ	ETF	38.52	38.87	38.49	38.77	14571030.0
2008-09-30 15:00:00	QQQ	ETF	38.78	39.3	38.64	39.16	40898751.0
2008-09-30 16:00:00	QQQ	ETF	39.17	39.25	38.9	38.91	5654537.0
2008-09-30 17:00:00	QQQ	ETF	39.02	39.05	38.96	39.02	180267.0
2008-09-30 18:00:00	QQQ	ETF	39.02	39.03	38.91	38.93	47323.0
2008-09-30 19:00:00	QQQ	ETF	38.93	39.16	38.92	39.13	39380.0
2008-09-30 06:00:00	IWM	ETF	65.9	65.9	65.9	65.9	100.0
2008-09-30 07:00:00	IWM	ETF	65.98	66.37	65.9	66.08	40700.0
2008-09-30 08:00:00	IWM	ETF	66.05	66.25	65.76	65.88	874295.0
2008-09-30 09:00:00	IWM	ETF	65.85	66.9	65.05	65.67	10662016.0
2008-09-30 10:00:00	IWM	ETF	65.62	66.69	65.57	66.38	16157439.0
2008-09-30 11:00:00	IWM	ETF	66.37	66.87	66.35	66.82	11909058.0
2008-09-30 12:00:00	IWM	ETF	66.82	66.84	66.39	66.65	6313999.0
2008-09-30 13:00:00	IWM	ETF	66.64	67.19	66.38	67.05	9572632.0
2008-09-30 14:00:00	IWM	ETF	67.06	67.55	66.98	67.43	13500517.0
2008-09-30 15:00:00	IWM	ETF	67.43	68.19	67.12	68.15	26661500.0
2008-09-30 16:00:00	IWM	ETF	68.14	68.42	65.64	68.0	7882543.0
2008-09-30 17:00:00	IWM	ETF	65.64	65.64	65.64	65.64	1254554.0
2008-09-30 18:00:00	IWM	ETF	65.64	68.0	65.64	67.86	1001000.0
2008-09-30 19:00:00	IWM	ETF	68.0	68.0	67.97	67.97	1200.0
2008-09-30 07:00:00	DIA	ETF	106.0	106.0	106.0	106.0	100.0
2008-09-30 08:00:00	DIA	ETF	106.3	106.5	105.8	105.99	56056.0
2008-09-30 09:00:00	DIA	ETF	105.98	106.5	105.22	105.53	2649151.0
2008-09-30 10:00:00	DIA	ETF	105.57	106.95	105.4	105.98	3705504.0

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

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