PREVIEW / etf_1hour / 2008-09-26

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-09-26.parquet
  size:    112 KB
  rows:    3,624

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-26 04:00:00	SPY	ETF	118.88	119.15	118.85	119.15	3600.0
2008-09-26 05:00:00	SPY	ETF	119.05	119.15	118.75	118.79	71100.0
2008-09-26 06:00:00	SPY	ETF	118.89	119.28	118.71	119.23	94889.0
2008-09-26 07:00:00	SPY	ETF	119.25	119.33	118.76	119.12	1657341.0
2008-09-26 08:00:00	SPY	ETF	119.1	119.962	118.21	118.39	6472612.0
2008-09-26 09:00:00	SPY	ETF	118.39	119.78	118.39	119.2	39986011.0
2008-09-26 10:00:00	SPY	ETF	119.2	120.01	118.97	119.67	32219264.0
2008-09-26 11:00:00	SPY	ETF	119.67	120.79	118.8	118.97	33808726.0
2008-09-26 12:00:00	SPY	ETF	118.97	119.64	118.77	119.58	24285630.0
2008-09-26 13:00:00	SPY	ETF	119.58	120.52	119.4	120.04	33283175.0
2008-09-26 14:00:00	SPY	ETF	120.03	120.39	119.5	119.76	24830756.0
2008-09-26 15:00:00	SPY	ETF	119.74	121.5	119.23	121.36	73516882.0
2008-09-26 16:00:00	SPY	ETF	121.33	121.36	120.71	120.85	9814871.0
2008-09-26 17:00:00	SPY	ETF	120.86	121.35	120.7907	121.31	1206699.0
2008-09-26 18:00:00	SPY	ETF	121.3	121.34	121.09	121.27	97273.0
2008-09-26 19:00:00	SPY	ETF	121.3	121.48	121.25	121.48	44465.0
2008-09-26 04:00:00	QQQ	ETF	40.78	40.78	40.78	40.78	100.0
2008-09-26 05:00:00	QQQ	ETF	40.71	40.84	40.71	40.82	6400.0
2008-09-26 06:00:00	QQQ	ETF	40.82	40.82	40.56	40.67	21600.0
2008-09-26 07:00:00	QQQ	ETF	40.7	40.75	40.58	40.73	396294.0
2008-09-26 08:00:00	QQQ	ETF	40.73	40.74	40.01	40.11	4534182.0
2008-09-26 09:00:00	QQQ	ETF	40.11	40.81	40.11	40.64	28501264.0
2008-09-26 10:00:00	QQQ	ETF	40.63	40.8	40.43	40.65	20539433.0
2008-09-26 11:00:00	QQQ	ETF	40.6522	40.73	40.44	40.53	13999530.0
2008-09-26 12:00:00	QQQ	ETF	40.53	40.77	40.4	40.71	14089180.0
2008-09-26 13:00:00	QQQ	ETF	40.72	41.09	40.72	40.831	29343101.0
2008-09-26 14:00:00	QQQ	ETF	40.83	40.91	40.63	40.63	11357994.0
2008-09-26 15:00:00	QQQ	ETF	40.63	41.27	40.4774	41.16	42406983.0
2008-09-26 16:00:00	QQQ	ETF	41.16	41.4902	40.95	41.1	8861898.0
2008-09-26 17:00:00	QQQ	ETF	41.07	41.22	41.06	41.2	59065.0
2008-09-26 18:00:00	QQQ	ETF	41.19	41.2	41.15	41.19	59740.0
2008-09-26 19:00:00	QQQ	ETF	41.17	41.3	41.17	41.29	41928.0
2008-09-26 07:00:00	IWM	ETF	69.5	69.6	69.4	69.6	35900.0
2008-09-26 08:00:00	IWM	ETF	69.55	69.55	68.74	68.74	347686.0
2008-09-26 09:00:00	IWM	ETF	68.76	69.71	68.76	69.46	9401287.0
2008-09-26 10:00:00	IWM	ETF	69.46	69.83	69.08	69.6	12930024.0
2008-09-26 11:00:00	IWM	ETF	69.6	69.72	69.02	69.11	8807132.0
2008-09-26 12:00:00	IWM	ETF	69.11	69.5	69.0	69.46	9129996.0
2008-09-26 13:00:00	IWM	ETF	69.46	70.18	69.43	69.86	12961649.0
2008-09-26 14:00:00	IWM	ETF	69.86	70.21	69.64	69.65	6198239.0
2008-09-26 15:00:00	IWM	ETF	69.65	70.69	69.25	70.65	21489299.0
2008-09-26 16:00:00	IWM	ETF	70.65	70.7	70.04	70.42	8667059.0
2008-09-26 17:00:00	IWM	ETF	70.65	70.85	70.6	70.85	236150.0
2008-09-26 18:00:00	IWM	ETF	70.73	70.76	70.6	70.76	10663.0
2008-09-26 19:00:00	IWM	ETF	70.85	70.85	70.76	70.76	400.0
2008-09-26 07:00:00	DIA	ETF	108.3	108.84	108.3	108.61	1200.0
2008-09-26 08:00:00	DIA	ETF	108.72	109.19	107.95	108.1	146256.0
2008-09-26 09:00:00	DIA	ETF	108.15	110.0	108.15	109.21	3061634.0
2008-09-26 10:00:00	DIA	ETF	109.24	110.19	109.15	109.95	4274338.0
2008-09-26 11:00:00	DIA	ETF	109.97	110.12	109.33	109.41	2647322.0

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

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