PREVIEW / etf_1hour / 2009-08-05

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-08-05.parquet
  size:    142 KB
  rows:    4,356

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-08-05 04:00:00	SPY	ETF	100.59	100.66	100.51	100.6	3050.0
2009-08-05 05:00:00	SPY	ETF	100.63	100.86	100.63	100.86	5636.0
2009-08-05 06:00:00	SPY	ETF	100.87	101.0	100.85	101.0	5826.0
2009-08-05 07:00:00	SPY	ETF	100.98	101.07	100.78	100.84	332397.0
2009-08-05 08:00:00	SPY	ETF	100.86	101.03	100.55	100.66	2567811.0
2009-08-05 09:00:00	SPY	ETF	100.67	100.87	100.13	100.25	25171341.0
2009-08-05 10:00:00	SPY	ETF	100.25	100.3	99.58	99.87	39538108.0
2009-08-05 11:00:00	SPY	ETF	99.86	100.07	99.76	99.871	15171136.0
2009-08-05 12:00:00	SPY	ETF	99.88	100.17	99.77	99.92	12421363.0
2009-08-05 13:00:00	SPY	ETF	99.92	100.32	99.72	100.09	21263170.0
2009-08-05 14:00:00	SPY	ETF	100.1	100.67	100.03	100.61	20477207.0
2009-08-05 15:00:00	SPY	ETF	100.6	100.79	100.2	100.41	37920460.0
2009-08-05 16:00:00	SPY	ETF	100.4	100.61	99.81	100.21	8208300.0
2009-08-05 17:00:00	SPY	ETF	100.24	100.7358	100.1	100.15	962970.0
2009-08-05 18:00:00	SPY	ETF	100.14	100.17	100.07	100.1	37750.0
2009-08-05 19:00:00	SPY	ETF	100.13	100.15	100.08	100.13	28805.0
2009-08-05 06:00:00	QQQ	ETF	40.08	40.13	40.08	40.13	10200.0
2009-08-05 07:00:00	QQQ	ETF	40.09	40.16	40.05	40.08	175200.0
2009-08-05 08:00:00	QQQ	ETF	40.08	40.15	40.02	40.06	651386.0
2009-08-05 09:00:00	QQQ	ETF	40.07	40.16	39.72	39.7501	17813152.0
2009-08-05 10:00:00	QQQ	ETF	39.76	39.78	39.54	39.65	21657816.0
2009-08-05 11:00:00	QQQ	ETF	39.65	39.71	39.5	39.54	8533017.0
2009-08-05 12:00:00	QQQ	ETF	39.54	39.66	39.5	39.51	8138253.0
2009-08-05 13:00:00	QQQ	ETF	39.52	39.7	39.46	39.59	15590890.0
2009-08-05 14:00:00	QQQ	ETF	39.59	39.81	39.56	39.77	10457887.0
2009-08-05 15:00:00	QQQ	ETF	39.78	39.85	39.69	39.73	19731877.0
2009-08-05 16:00:00	QQQ	ETF	39.74	39.78	39.53	39.55	9789118.0
2009-08-05 17:00:00	QQQ	ETF	39.55	39.55	39.38	39.45	1007273.0
2009-08-05 18:00:00	QQQ	ETF	39.45	39.46	39.44	39.46	448064.0
2009-08-05 19:00:00	QQQ	ETF	39.46	39.48	39.44	39.47	105783.0
2009-08-05 06:00:00	IWM	ETF	57.21	57.21	57.21	57.21	2000.0
2009-08-05 07:00:00	IWM	ETF	57.08	57.27	57.05	57.11	65700.0
2009-08-05 08:00:00	IWM	ETF	57.11	57.31	56.93	56.99	339815.0
2009-08-05 09:00:00	IWM	ETF	57.0	57.21	56.58	56.74	5706805.0
2009-08-05 10:00:00	IWM	ETF	56.74	56.77	56.13	56.32	6861563.0
2009-08-05 11:00:00	IWM	ETF	56.32	56.43	56.17	56.25	3487885.0
2009-08-05 12:00:00	IWM	ETF	56.26	56.42	56.12	56.17	4862545.0
2009-08-05 13:00:00	IWM	ETF	56.17	56.47	56.0	56.19	6425160.0
2009-08-05 14:00:00	IWM	ETF	56.19	56.65	56.11	56.54	5341038.0
2009-08-05 15:00:00	IWM	ETF	56.54	56.74	56.31	56.51	9569034.0
2009-08-05 16:00:00	IWM	ETF	56.51	57.0903	56.49	56.52	4375709.0
2009-08-05 17:00:00	IWM	ETF	56.5	56.5	56.38	56.39	130984.0
2009-08-05 18:00:00	IWM	ETF	56.37	56.52	56.26	56.3	4902.0
2009-08-05 19:00:00	IWM	ETF	56.3	56.3	56.19	56.25	3719.0
2009-08-05 06:00:00	DIA	ETF	93.33	93.33	93.32	93.32	500.0
2009-08-05 07:00:00	DIA	ETF	93.22	93.45	93.22	93.26	4550.0
2009-08-05 08:00:00	DIA	ETF	93.25	93.4	92.95	93.0	57802.0
2009-08-05 09:00:00	DIA	ETF	93.11	93.2087	92.67	92.78	1925300.0
2009-08-05 10:00:00	DIA	ETF	92.79	92.85	92.12	92.43	2424302.0
2009-08-05 11:00:00	DIA	ETF	92.43	92.58	92.31	92.4175	785337.0

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

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