PREVIEW / etf_1hour / 2009-04-24

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-04-24.parquet
  size:    133 KB
  rows:    4,107

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
2009-04-24 04:00:00	SPY	ETF	85.42	85.46	85.16	85.18	2000.0
2009-04-24 05:00:00	SPY	ETF	85.13	85.15	85.09	85.09	1000.0
2009-04-24 06:00:00	SPY	ETF	85.13	85.5	85.13	85.42	47819.0
2009-04-24 07:00:00	SPY	ETF	85.43	85.98	85.41	85.82	494257.0
2009-04-24 08:00:00	SPY	ETF	85.83	86.03	85.37	85.67	4630590.0
2009-04-24 09:00:00	SPY	ETF	85.68	86.27	85.68	86.27	26830540.0
2009-04-24 10:00:00	SPY	ETF	86.26	86.485	85.75	86.34	39200059.0
2009-04-24 11:00:00	SPY	ETF	86.34	86.82	86.21	86.7094	23862418.0
2009-04-24 12:00:00	SPY	ETF	86.71	86.9	86.55	86.86	20139932.0
2009-04-24 13:00:00	SPY	ETF	86.86	86.96	86.48	86.57	18010056.0
2009-04-24 14:00:00	SPY	ETF	86.56	87.14	85.74	87.07	68406224.0
2009-04-24 15:00:00	SPY	ETF	87.07	87.31	86.12	86.65	62605305.0
2009-04-24 16:00:00	SPY	ETF	86.68	87.17	86.5	86.98	16411044.0
2009-04-24 17:00:00	SPY	ETF	86.98	87.08	86.25	87.06	4691719.0
2009-04-24 18:00:00	SPY	ETF	87.01	87.05	86.94	86.96	19759.0
2009-04-24 19:00:00	SPY	ETF	86.96	87.04	86.91	86.91	54971.0
2009-04-24 06:00:00	QQQ	ETF	33.08	33.17	33.08	33.16	34760.0
2009-04-24 07:00:00	QQQ	ETF	33.15	33.36	33.15	33.33	260611.0
2009-04-24 08:00:00	QQQ	ETF	33.33	33.42	33.26	33.29	669860.0
2009-04-24 09:00:00	QQQ	ETF	33.29	33.38	33.07	33.33	15012894.0
2009-04-24 10:00:00	QQQ	ETF	33.34	33.58	33.25	33.52	18333102.0
2009-04-24 11:00:00	QQQ	ETF	33.52	33.82	33.4	33.77	13696381.0
2009-04-24 12:00:00	QQQ	ETF	33.78	33.82	33.65	33.78	14415115.0
2009-04-24 13:00:00	QQQ	ETF	33.7801	33.81	33.63	33.66	6794938.0
2009-04-24 14:00:00	QQQ	ETF	33.65	33.87	33.4	33.848	30547074.0
2009-04-24 15:00:00	QQQ	ETF	33.85	33.93	33.57	33.72	29359060.0
2009-04-24 16:00:00	QQQ	ETF	33.74	33.86	33.69	33.81	4904045.0
2009-04-24 17:00:00	QQQ	ETF	33.83	33.86	33.79	33.83	128870.0
2009-04-24 18:00:00	QQQ	ETF	33.81	33.81	33.79	33.81	23200.0
2009-04-24 19:00:00	QQQ	ETF	33.8	33.84	33.79	33.8	26325.0
2009-04-24 06:00:00	IWM	ETF	46.75	46.75	46.72	46.72	500.0
2009-04-24 07:00:00	IWM	ETF	46.78	47.15	46.78	47.0	79715.0
2009-04-24 08:00:00	IWM	ETF	46.99	47.09	46.71	46.89	541055.0
2009-04-24 09:00:00	IWM	ETF	46.9	47.25	46.67	47.21	4725231.0
2009-04-24 10:00:00	IWM	ETF	47.21	47.55	46.93	47.42	8146887.0
2009-04-24 11:00:00	IWM	ETF	47.43	47.73	47.23	47.63	5204779.0
2009-04-24 12:00:00	IWM	ETF	47.63	47.85	47.52	47.71	4842660.0
2009-04-24 13:00:00	IWM	ETF	47.72	47.88	47.48	47.59	3655748.0
2009-04-24 14:00:00	IWM	ETF	47.59	48.11	47.02	48.11	12426425.0
2009-04-24 15:00:00	IWM	ETF	48.11	48.28	47.56	47.56	15674815.0
2009-04-24 16:00:00	IWM	ETF	47.58	48.1095	47.55	47.89	2509922.0
2009-04-24 17:00:00	IWM	ETF	47.91	47.91	47.88	47.88	7200.0
2009-04-24 18:00:00	IWM	ETF	47.83	47.83	47.82	47.82	425.0
2009-04-24 19:00:00	IWM	ETF	47.91	47.91	47.91	47.91	200.0
2009-04-24 07:00:00	DIA	ETF	80.0	80.09	79.87	79.96	6900.0
2009-04-24 08:00:00	DIA	ETF	79.97	80.07	79.77	79.87	48967.0
2009-04-24 09:00:00	DIA	ETF	79.86	80.51	79.86	80.5	1633629.0
2009-04-24 10:00:00	DIA	ETF	80.5	80.69	80.05	80.52	2334951.0
2009-04-24 11:00:00	DIA	ETF	80.52	80.97	80.402	80.89	1798626.0
2009-04-24 12:00:00	DIA	ETF	80.88	80.97	80.74	80.9207	1264339.0

> showing 50 of 4,107 rows — these rows as CSV

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