PREVIEW / etf_1hour / 2010-08-02

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-08-02.parquet
  size:    167 KB
  rows:    5,088

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-08-02 04:00:00	SPY	ETF	110.99	111.62	110.99	111.56	15885.0
2010-08-02 05:00:00	SPY	ETF	111.57	111.7	111.56	111.7	4900.0
2010-08-02 06:00:00	SPY	ETF	111.65	111.65	111.56	111.57	28601.0
2010-08-02 07:00:00	SPY	ETF	111.57	111.78	111.57	111.64	803578.0
2010-08-02 08:00:00	SPY	ETF	111.64	111.74	110.27	111.67	1880139.0
2010-08-02 09:00:00	SPY	ETF	111.68	112.06	110.27	111.769	24059378.0
2010-08-02 10:00:00	SPY	ETF	111.76	112.49	111.72	112.4	35279397.0
2010-08-02 11:00:00	SPY	ETF	112.3981	112.67	112.1	112.629	17461891.0
2010-08-02 12:00:00	SPY	ETF	112.62	112.64	112.26	112.44	10944469.0
2010-08-02 13:00:00	SPY	ETF	112.43	112.57	112.32	112.51	9791534.0
2010-08-02 14:00:00	SPY	ETF	112.5199	112.85	112.445	112.8	19977588.0
2010-08-02 15:00:00	SPY	ETF	112.8	112.94	112.66	112.74	30821889.0
2010-08-02 16:00:00	SPY	ETF	112.74	112.8774	110.3463	112.69	35637843.0
2010-08-02 17:00:00	SPY	ETF	112.68	112.73	110.27	112.66	221114.0
2010-08-02 18:00:00	SPY	ETF	112.68	112.76	112.62	112.69	153888.0
2010-08-02 19:00:00	SPY	ETF	112.69	112.73	112.65	112.72	55083.0
2010-08-02 04:00:00	QQQ	ETF	45.71	46.31	45.71	46.29	1350.0
2010-08-02 05:00:00	QQQ	ETF	46.31	46.33	46.31	46.33	600.0
2010-08-02 06:00:00	QQQ	ETF	46.31	46.31	46.28	46.29	700.0
2010-08-02 07:00:00	QQQ	ETF	46.3	46.37	46.3	46.3	152063.0
2010-08-02 08:00:00	QQQ	ETF	46.29	46.8	45.81	46.3	545660.0
2010-08-02 09:00:00	QQQ	ETF	46.3	46.41	46.2101	46.38	13494604.0
2010-08-02 10:00:00	QQQ	ETF	46.37	46.72	46.37	46.645	15681005.0
2010-08-02 11:00:00	QQQ	ETF	46.65	46.75	46.6	46.701	5633347.0
2010-08-02 12:00:00	QQQ	ETF	46.7	46.72	46.54	46.61	2206869.0
2010-08-02 13:00:00	QQQ	ETF	46.602	46.67	46.57	46.62	1842480.0
2010-08-02 14:00:00	QQQ	ETF	46.625	46.79	46.6	46.73	4958937.0
2010-08-02 15:00:00	QQQ	ETF	46.74	46.78	46.64	46.68	11601699.0
2010-08-02 16:00:00	QQQ	ETF	46.68	46.7501	46.58	46.6	2281152.0
2010-08-02 17:00:00	QQQ	ETF	45.81	46.62	45.81	46.6	14898.0
2010-08-02 18:00:00	QQQ	ETF	46.62	46.63	46.58	46.61	23371.0
2010-08-02 19:00:00	QQQ	ETF	46.61	46.63	46.6	46.63	11558.0
2010-08-02 04:00:00	IWM	ETF	65.79	66.57	65.78	65.92	17100.0
2010-08-02 05:00:00	IWM	ETF	65.93	65.95	65.93	65.95	800.0
2010-08-02 06:00:00	IWM	ETF	65.98	66.0	65.92	66.0	40400.0
2010-08-02 07:00:00	IWM	ETF	65.99	66.06	65.95	65.95	83300.0
2010-08-02 08:00:00	IWM	ETF	65.95	66.1	65.02	66.02	358444.0
2010-08-02 09:00:00	IWM	ETF	66.03	66.38	65.73	65.83	8818485.0
2010-08-02 10:00:00	IWM	ETF	65.83	66.54	65.82	66.41	9885760.0
2010-08-02 11:00:00	IWM	ETF	66.41	66.43	66.17	66.23	5048350.0
2010-08-02 12:00:00	IWM	ETF	66.23	66.23	65.5901	65.8	4598341.0
2010-08-02 13:00:00	IWM	ETF	65.79	66.08	65.77	66.04	2884556.0
2010-08-02 14:00:00	IWM	ETF	66.03	66.33	65.94	66.21	5817382.0
2010-08-02 15:00:00	IWM	ETF	66.21	66.35	66.05	66.16	8642679.0
2010-08-02 16:00:00	IWM	ETF	66.15	66.35	66.0	66.35	1061669.0
2010-08-02 17:00:00	IWM	ETF	66.03	66.1	65.06	66.05	32349.0
2010-08-02 18:00:00	IWM	ETF	66.08	66.1	66.03	66.08	2400.0
2010-08-02 19:00:00	IWM	ETF	66.05	66.05	66.0	66.04	14504.0
2010-08-02 07:00:00	DIA	ETF	105.79	105.85	105.79	105.84	1700.0
2010-08-02 08:00:00	DIA	ETF	105.81	105.84	105.71	105.82	24320.0

> showing 50 of 5,088 rows — these rows as CSV

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