PREVIEW / etf_1hour / 2010-02-22

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-02-22.parquet
  size:    149 KB
  rows:    4,694

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
2010-02-22 04:00:00	SPY	ETF	111.19	111.39	111.16	111.24	600.0
2010-02-22 05:00:00	SPY	ETF	111.32	111.39	111.24	111.32	21000.0
2010-02-22 06:00:00	SPY	ETF	111.32	111.36	111.26	111.26	29600.0
2010-02-22 07:00:00	SPY	ETF	111.32	111.73	111.32	111.67	723364.0
2010-02-22 08:00:00	SPY	ETF	111.66	111.7	111.03	111.53	1807674.0
2010-02-22 09:00:00	SPY	ETF	111.53	111.58	111.01	111.24	21458417.0
2010-02-22 10:00:00	SPY	ETF	111.23	111.33	110.83	111.06	25361974.0
2010-02-22 11:00:00	SPY	ETF	111.07	111.15	110.9	111.0	16630225.0
2010-02-22 12:00:00	SPY	ETF	111.0	111.4265	110.94	111.195	10820463.0
2010-02-22 13:00:00	SPY	ETF	111.195	111.33	111.05	111.13	10068281.0
2010-02-22 14:00:00	SPY	ETF	111.14	111.44	111.13	111.39	11981385.0
2010-02-22 15:00:00	SPY	ETF	111.38	111.5	110.96	111.13	24852496.0
2010-02-22 16:00:00	SPY	ETF	111.14	111.3652	110.99	111.12	8156968.0
2010-02-22 17:00:00	SPY	ETF	111.14	111.21	111.12	111.13	220577.0
2010-02-22 18:00:00	SPY	ETF	111.13	111.18	111.11	111.18	60352.0
2010-02-22 19:00:00	SPY	ETF	111.15	111.26	111.12	111.12	137507.0
2010-02-22 05:00:00	QQQ	ETF	44.97	44.97	44.97	44.97	100.0
2010-02-22 06:00:00	QQQ	ETF	44.93	44.97	44.93	44.97	6768.0
2010-02-22 07:00:00	QQQ	ETF	44.97	45.1	44.97	45.07	142296.0
2010-02-22 08:00:00	QQQ	ETF	45.07	45.09	44.83	45.06	369757.0
2010-02-22 09:00:00	QQQ	ETF	45.05	45.07	44.67	44.74	11847101.0
2010-02-22 10:00:00	QQQ	ETF	44.73	44.81	44.56	44.72	18240305.0
2010-02-22 11:00:00	QQQ	ETF	44.71	44.75	44.6	44.63	6648384.0
2010-02-22 12:00:00	QQQ	ETF	44.63	44.735	44.61	44.71	4325002.0
2010-02-22 13:00:00	QQQ	ETF	44.711	44.79	44.63	44.7101	4453877.0
2010-02-22 14:00:00	QQQ	ETF	44.72	44.86	44.7	44.84	5027815.0
2010-02-22 15:00:00	QQQ	ETF	44.84	44.87	44.66	44.74	12185939.0
2010-02-22 16:00:00	QQQ	ETF	44.73	44.8675	44.72	44.79	5613692.0
2010-02-22 17:00:00	QQQ	ETF	44.78	44.79	44.76	44.76	12219.0
2010-02-22 18:00:00	QQQ	ETF	44.77	44.79	44.73	44.79	100810.0
2010-02-22 19:00:00	QQQ	ETF	44.79	44.81	44.76	44.76	20310.0
2010-02-22 07:00:00	IWM	ETF	63.41	63.52	63.29	63.45	165218.0
2010-02-22 08:00:00	IWM	ETF	63.45	63.51	63.23	63.44	181190.0
2010-02-22 09:00:00	IWM	ETF	63.45	63.46	63.02	63.27	6904177.0
2010-02-22 10:00:00	IWM	ETF	63.27	63.42	63.08	63.32	9794532.0
2010-02-22 11:00:00	IWM	ETF	63.32	63.35	63.16	63.24	2971989.0
2010-02-22 12:00:00	IWM	ETF	63.24	63.31	63.16	63.25	1672387.0
2010-02-22 13:00:00	IWM	ETF	63.25	63.34	63.16	63.26	4185990.0
2010-02-22 14:00:00	IWM	ETF	63.265	63.39	63.26	63.34	4002483.0
2010-02-22 15:00:00	IWM	ETF	63.34	63.42	63.15	63.25	6565088.0
2010-02-22 16:00:00	IWM	ETF	63.25	63.3217	63.1882	63.24	3148388.0
2010-02-22 17:00:00	IWM	ETF	63.23	63.3	63.22	63.27	8300.0
2010-02-22 18:00:00	IWM	ETF	63.2	63.22	63.2	63.22	500.0
2010-02-22 19:00:00	IWM	ETF	63.23	63.24	63.2	63.23	1700.0
2010-02-22 06:00:00	DIA	ETF	104.04	104.04	104.04	104.04	100.0
2010-02-22 07:00:00	DIA	ETF	104.35	104.53	104.35	104.41	5700.0
2010-02-22 08:00:00	DIA	ETF	104.5	104.5	104.25	104.3	71799.0
2010-02-22 09:00:00	DIA	ETF	104.28	104.38	103.89	104.07	983492.0
2010-02-22 10:00:00	DIA	ETF	104.09	104.18	103.7499	103.92	1436773.0
2010-02-22 11:00:00	DIA	ETF	103.93	104.01	103.78	103.87	604056.0

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

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