PREVIEW / etf_1hour / 2009-06-08

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-06-08.parquet
  size:    137 KB
  rows:    4,241

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-06-08 04:00:00	SPY	ETF	93.58	93.68	93.49	93.55	21600.0
2009-06-08 05:00:00	SPY	ETF	93.6	93.68	93.35	93.37	7700.0
2009-06-08 06:00:00	SPY	ETF	93.45	93.7	93.39	93.6	17600.0
2009-06-08 07:00:00	SPY	ETF	93.65	93.79	93.51	93.66	957982.0
2009-06-08 08:00:00	SPY	ETF	93.66	93.72	93.51	93.64	1717171.0
2009-06-08 09:00:00	SPY	ETF	93.64	94.03	93.3	93.39	22045440.0
2009-06-08 10:00:00	SPY	ETF	93.39	93.82	93.11	93.65	30482163.0
2009-06-08 11:00:00	SPY	ETF	93.64	93.76	93.25	93.39	20193444.0
2009-06-08 12:00:00	SPY	ETF	93.38	93.43	93.04	93.28	22800639.0
2009-06-08 13:00:00	SPY	ETF	93.27	93.7	93.27	93.59	16973335.0
2009-06-08 14:00:00	SPY	ETF	93.6	93.7	93.41	93.61	17336734.0
2009-06-08 15:00:00	SPY	ETF	93.62	95.1	93.61	94.31	79426026.0
2009-06-08 16:00:00	SPY	ETF	94.31	94.529	94.09	94.46	24647788.0
2009-06-08 17:00:00	SPY	ETF	94.46	94.5	94.39	94.41	1128997.0
2009-06-08 18:00:00	SPY	ETF	94.41	94.46	94.3	94.37	52821.0
2009-06-08 19:00:00	SPY	ETF	94.39	94.5	94.37	94.45	33895.0
2009-06-08 05:00:00	QQQ	ETF	36.47	36.47	36.39	36.39	2600.0
2009-06-08 06:00:00	QQQ	ETF	36.44	36.5	36.44	36.5	51000.0
2009-06-08 07:00:00	QQQ	ETF	36.47	36.5	36.37	36.47	281559.0
2009-06-08 08:00:00	QQQ	ETF	36.47	36.5	36.39	36.47	792442.0
2009-06-08 09:00:00	QQQ	ETF	36.46	36.58	36.22	36.25	9488321.0
2009-06-08 10:00:00	QQQ	ETF	36.25	36.35	36.15	36.27	12945974.0
2009-06-08 11:00:00	QQQ	ETF	36.27	36.34	36.17	36.21	7330170.0
2009-06-08 12:00:00	QQQ	ETF	36.21	36.27	36.12	36.2	5785166.0
2009-06-08 13:00:00	QQQ	ETF	36.2	36.38	36.17	36.3199	8073587.0
2009-06-08 14:00:00	QQQ	ETF	36.31	36.36	36.21	36.33	7647153.0
2009-06-08 15:00:00	QQQ	ETF	36.33	36.95	36.32	36.66	32642905.0
2009-06-08 16:00:00	QQQ	ETF	36.67	36.8	36.2269	36.74	3013596.0
2009-06-08 17:00:00	QQQ	ETF	36.76	36.82	36.76	36.78	274563.0
2009-06-08 18:00:00	QQQ	ETF	36.78	36.79	36.76	36.77	53667.0
2009-06-08 19:00:00	QQQ	ETF	36.77	36.83	36.77	36.82	134200.0
2009-06-08 07:00:00	IWM	ETF	52.56	52.65	52.56	52.65	100896.0
2009-06-08 08:00:00	IWM	ETF	52.64	52.71	52.59	52.68	120455.0
2009-06-08 09:00:00	IWM	ETF	52.68	52.91	52.21	52.33	6747137.0
2009-06-08 10:00:00	IWM	ETF	52.32	52.55	52.08	52.4	4832970.0
2009-06-08 11:00:00	IWM	ETF	52.4	52.46	52.119	52.23	3318842.0
2009-06-08 12:00:00	IWM	ETF	52.23	52.32	52.04	52.18	2591382.0
2009-06-08 13:00:00	IWM	ETF	52.18	52.42	52.14	52.318	2282566.0
2009-06-08 14:00:00	IWM	ETF	52.31	52.35	52.13	52.331	3311083.0
2009-06-08 15:00:00	IWM	ETF	52.33	53.28	52.32	52.55	14734366.0
2009-06-08 16:00:00	IWM	ETF	52.55	53.12	52.47	52.66	4247767.0
2009-06-08 17:00:00	IWM	ETF	52.69	52.73	52.66	52.73	4365.0
2009-06-08 18:00:00	IWM	ETF	52.72	52.72	52.72	52.72	900.0
2009-06-08 19:00:00	IWM	ETF	52.72	52.72	52.72	52.72	400.0
2009-06-08 06:00:00	DIA	ETF	86.97	87.1	86.97	87.1	200.0
2009-06-08 07:00:00	DIA	ETF	87.05	87.14	87.02	87.08	2350.0
2009-06-08 08:00:00	DIA	ETF	87.1	87.15	87.0	87.1	20860.0
2009-06-08 09:00:00	DIA	ETF	87.02	87.6835	86.66	86.73	2037317.0
2009-06-08 10:00:00	DIA	ETF	86.73	87.1	86.53	86.95	3446497.0
2009-06-08 11:00:00	DIA	ETF	86.95	87.02	86.65	86.76	2147917.0

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

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