PREVIEW / etf_1hour / 2009-04-07

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-04-07.parquet
  size:    131 KB
  rows:    4,066

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-07 04:00:00	SPY	ETF	83.11	83.11	82.35	82.43	16213.0
2009-04-07 05:00:00	SPY	ETF	82.48	82.67	82.48	82.6	2900.0
2009-04-07 06:00:00	SPY	ETF	82.55	82.55	82.0	82.03	124401.0
2009-04-07 07:00:00	SPY	ETF	82.09	82.31	81.8	81.98	877477.0
2009-04-07 08:00:00	SPY	ETF	81.99	83.3	81.96	82.14	1726376.0
2009-04-07 09:00:00	SPY	ETF	82.14	82.27	81.67	81.97	33793214.0
2009-04-07 10:00:00	SPY	ETF	81.96	82.65	81.73	82.38	48368610.0
2009-04-07 11:00:00	SPY	ETF	82.39	82.55	82.06	82.13	33912193.0
2009-04-07 12:00:00	SPY	ETF	82.13	82.46	82.03	82.31	23242558.0
2009-04-07 13:00:00	SPY	ETF	82.31	82.35	81.56	81.73	28209705.0
2009-04-07 14:00:00	SPY	ETF	81.74	81.87	81.51	81.84	22917682.0
2009-04-07 15:00:00	SPY	ETF	81.84	82.37	81.56	81.56	47698157.0
2009-04-07 16:00:00	SPY	ETF	81.58	82.25	81.55	81.75	10839500.0
2009-04-07 17:00:00	SPY	ETF	81.77	81.88	81.69	81.87	2905294.0
2009-04-07 18:00:00	SPY	ETF	81.85	81.89	81.77	81.85	41943.0
2009-04-07 19:00:00	SPY	ETF	81.85	82.0	81.84	81.94	96788.0
2009-04-07 04:00:00	QQQ	ETF	32.04	32.05	31.99	32.01	30000.0
2009-04-07 05:00:00	QQQ	ETF	31.96	31.96	31.93	31.96	19200.0
2009-04-07 06:00:00	QQQ	ETF	31.95	31.95	31.8	31.8	53000.0
2009-04-07 07:00:00	QQQ	ETF	31.77	31.9	31.73	31.79	331420.0
2009-04-07 08:00:00	QQQ	ETF	31.78	32.2	31.78	31.91	646258.0
2009-04-07 09:00:00	QQQ	ETF	31.91	31.92	31.51	31.62	17539368.0
2009-04-07 10:00:00	QQQ	ETF	31.62	31.83	31.51	31.75	22383097.0
2009-04-07 11:00:00	QQQ	ETF	31.74	31.78	31.56	31.61	12442821.0
2009-04-07 12:00:00	QQQ	ETF	31.6	31.68	31.55	31.64	13480633.0
2009-04-07 13:00:00	QQQ	ETF	31.638	31.638	31.21	31.34	20694678.0
2009-04-07 14:00:00	QQQ	ETF	31.34	31.38	31.24	31.37	11774497.0
2009-04-07 15:00:00	QQQ	ETF	31.37	31.7	31.28	31.4	22943499.0
2009-04-07 16:00:00	QQQ	ETF	31.41	31.75	31.34	31.58	14673382.0
2009-04-07 17:00:00	QQQ	ETF	31.57	31.61	31.54	31.54	184654.0
2009-04-07 18:00:00	QQQ	ETF	31.55	31.59	31.55	31.59	56598.0
2009-04-07 19:00:00	QQQ	ETF	31.59	31.62	31.57	31.61	95050.0
2009-04-07 06:00:00	IWM	ETF	44.14	44.14	44.12	44.12	1100.0
2009-04-07 07:00:00	IWM	ETF	44.09	44.12	43.85	43.9	19757.0
2009-04-07 08:00:00	IWM	ETF	43.95	44.58	43.91	44.08	114952.0
2009-04-07 09:00:00	IWM	ETF	44.08	44.21	43.72	44.06	4997830.0
2009-04-07 10:00:00	IWM	ETF	44.05	44.46	43.8	44.3	5765464.0
2009-04-07 11:00:00	IWM	ETF	44.3	44.41	43.9	43.98	6079164.0
2009-04-07 12:00:00	IWM	ETF	43.99	44.13	43.84	43.96	5236292.0
2009-04-07 13:00:00	IWM	ETF	43.96	43.96	43.37	43.57	5599137.0
2009-04-07 14:00:00	IWM	ETF	43.56	43.65	43.27	43.51	4816794.0
2009-04-07 15:00:00	IWM	ETF	43.51	44.25	43.12	43.2	11208879.0
2009-04-07 16:00:00	IWM	ETF	43.23	43.5	43.15	43.3	1849074.0
2009-04-07 17:00:00	IWM	ETF	43.27	43.39	43.27	43.32	75050.0
2009-04-07 18:00:00	IWM	ETF	43.38	43.4	43.38	43.4	200.0
2009-04-07 19:00:00	IWM	ETF	43.3	43.3	43.3	43.3	1600.0
2009-04-07 04:00:00	DIA	ETF	79.23	79.23	79.23	79.23	100.0
2009-04-07 06:00:00	DIA	ETF	79.03	79.03	78.98	78.98	3200.0
2009-04-07 07:00:00	DIA	ETF	78.62	78.74	78.33	78.49	13498.0
2009-04-07 08:00:00	DIA	ETF	78.5	78.81	78.5	78.69	45460.0

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

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