PREVIEW / etf_1hour / 2008-11-26

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-11-26.parquet
  size:    117 KB
  rows:    3,824

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-26 04:00:00	SPY	ETF	85.66	85.91	85.23	85.25	5300.0
2008-11-26 05:00:00	SPY	ETF	85.15	85.22	84.5	84.77	21100.0
2008-11-26 06:00:00	SPY	ETF	84.89	84.89	84.59	84.75	17200.0
2008-11-26 07:00:00	SPY	ETF	84.93	85.17	83.99	84.09	3506863.0
2008-11-26 08:00:00	SPY	ETF	84.09	85.747	83.47	84.27	19757979.0
2008-11-26 09:00:00	SPY	ETF	84.26	85.6	84.24	85.26	35265568.0
2008-11-26 10:00:00	SPY	ETF	85.27	86.33	84.83	86.2	52132178.0
2008-11-26 11:00:00	SPY	ETF	86.18	87.23	85.78	86.73	41939326.0
2008-11-26 12:00:00	SPY	ETF	86.74	87.5	86.38	87.29	30293182.0
2008-11-26 13:00:00	SPY	ETF	87.29	87.76	86.83	87.04	33166919.0
2008-11-26 14:00:00	SPY	ETF	87.045	88.67	86.7	88.44	45508786.0
2008-11-26 15:00:00	SPY	ETF	88.43	89.15	88.17	89.04	84796560.0
2008-11-26 16:00:00	SPY	ETF	89.04	89.2	86.1379	88.99	17177930.0
2008-11-26 17:00:00	SPY	ETF	89.01	89.06	86.14	88.84	4211242.0
2008-11-26 18:00:00	SPY	ETF	88.87	88.91	88.61	88.65	181892.0
2008-11-26 19:00:00	SPY	ETF	88.65	88.8	88.61	88.68	48823.0
2008-11-26 04:00:00	QQQ	ETF	28.09	28.14	27.95	27.95	1350.0
2008-11-26 05:00:00	QQQ	ETF	27.93	27.93	27.75	27.75	1050.0
2008-11-26 06:00:00	QQQ	ETF	27.79	27.79	27.69	27.77	600.0
2008-11-26 07:00:00	QQQ	ETF	27.8	27.98	27.74	27.81	1067308.0
2008-11-26 08:00:00	QQQ	ETF	27.81	27.96	27.66	27.83	4866928.0
2008-11-26 09:00:00	QQQ	ETF	27.84	28.37	27.81	28.26	20911370.0
2008-11-26 10:00:00	QQQ	ETF	28.27	28.72	28.19	28.65	28295323.0
2008-11-26 11:00:00	QQQ	ETF	28.65	28.93	28.51	28.81	18179995.0
2008-11-26 12:00:00	QQQ	ETF	28.81	28.97	28.66	28.95	12843600.0
2008-11-26 13:00:00	QQQ	ETF	28.95	29.07	28.68	28.705	15836285.0
2008-11-26 14:00:00	QQQ	ETF	28.7	29.22	28.61	29.16	21517839.0
2008-11-26 15:00:00	QQQ	ETF	29.17	29.36	28.989	29.35	32492607.0
2008-11-26 16:00:00	QQQ	ETF	29.35	29.4	28.9428	29.29	4389267.0
2008-11-26 17:00:00	QQQ	ETF	29.3	29.32	29.21	29.3	20004.0
2008-11-26 18:00:00	QQQ	ETF	29.29	29.3	29.2	29.28	46237.0
2008-11-26 19:00:00	QQQ	ETF	29.28	29.29	29.11	29.15	110165.0
2008-11-26 07:00:00	IWM	ETF	43.53	43.53	43.09	43.15	6974.0
2008-11-26 08:00:00	IWM	ETF	43.45	43.45	42.65	43.1	891350.0
2008-11-26 09:00:00	IWM	ETF	43.2	44.37	43.13	44.13	5346535.0
2008-11-26 10:00:00	IWM	ETF	44.13	45.14	44.08	45.06	12812072.0
2008-11-26 11:00:00	IWM	ETF	45.05	45.99	44.76	45.89	12929202.0
2008-11-26 12:00:00	IWM	ETF	45.9	46.01	45.49	45.85	6242341.0
2008-11-26 13:00:00	IWM	ETF	45.86	46.12	45.32	45.39	6842878.0
2008-11-26 14:00:00	IWM	ETF	45.39	46.52	45.27	46.48	9380366.0
2008-11-26 15:00:00	IWM	ETF	46.48	47.03	44.42	46.77	25211481.0
2008-11-26 16:00:00	IWM	ETF	46.77	46.98	44.42	46.88	4028771.0
2008-11-26 17:00:00	IWM	ETF	46.98	47.25	44.42	46.73	1518857.0
2008-11-26 18:00:00	IWM	ETF	46.69	46.69	46.69	46.69	300.0
2008-11-26 07:00:00	DIA	ETF	83.92	84.05	83.18	83.18	31079.0
2008-11-26 08:00:00	DIA	ETF	83.24	83.5	82.74	83.35	140480.0
2008-11-26 09:00:00	DIA	ETF	83.37	84.24	82.96	84.0	3497064.0
2008-11-26 10:00:00	DIA	ETF	84.0	85.0	83.5	84.85	4627551.0
2008-11-26 11:00:00	DIA	ETF	84.87	85.73	84.53	85.28	3887635.0
2008-11-26 12:00:00	DIA	ETF	85.28	85.84	84.95	85.69	2666215.0

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

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