PREVIEW / etf_1hour / 2011-02-18

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-02-18.parquet
  size:    175 KB
  rows:    5,365

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
2011-02-18 04:00:00	SPY	ETF	134.19	134.19	134.1	134.1	8994.0
2011-02-18 05:00:00	SPY	ETF	134.01	134.05	133.96	134.04	14550.0
2011-02-18 06:00:00	SPY	ETF	134.09	134.09	134.08	134.08	32400.0
2011-02-18 07:00:00	SPY	ETF	134.09	134.24	134.08	134.19	274135.0
2011-02-18 08:00:00	SPY	ETF	134.1	134.4	133.85	134.26	688243.0
2011-02-18 09:00:00	SPY	ETF	134.27	134.38	134.13	134.3	13887445.0
2011-02-18 10:00:00	SPY	ETF	134.3	134.45	134.2	134.32	15452258.0
2011-02-18 11:00:00	SPY	ETF	134.31	134.64	134.3	134.579	14479073.0
2011-02-18 12:00:00	SPY	ETF	134.57	134.69	134.53	134.61	10263004.0
2011-02-18 13:00:00	SPY	ETF	134.61	134.62	134.23	134.44	11553086.0
2011-02-18 14:00:00	SPY	ETF	134.44	134.45	134.06	134.35	15669138.0
2011-02-18 15:00:00	SPY	ETF	134.35	134.57	134.155	134.51	26514888.0
2011-02-18 16:00:00	SPY	ETF	134.57	134.72	134.15	134.56	12766383.0
2011-02-18 17:00:00	SPY	ETF	134.56	134.65	134.5	134.5	859216.0
2011-02-18 18:00:00	SPY	ETF	134.5	134.59	134.49	134.59	150591.0
2011-02-18 19:00:00	SPY	ETF	134.6	134.61	134.52	134.6	31200.0
2011-02-18 05:00:00	QQQ	ETF	58.76	58.76	58.72	58.75	11100.0
2011-02-18 06:00:00	QQQ	ETF	58.73	58.73	58.73	58.73	100.0
2011-02-18 07:00:00	QQQ	ETF	58.78	58.83	58.78	58.81	35013.0
2011-02-18 08:00:00	QQQ	ETF	58.81	58.95	58.81	58.87	119540.0
2011-02-18 09:00:00	QQQ	ETF	58.87	58.93	58.78	58.8701	4388045.0
2011-02-18 10:00:00	QQQ	ETF	58.875	58.905	58.74	58.77	5266866.0
2011-02-18 11:00:00	QQQ	ETF	58.76	58.97	58.74	58.9138	4160893.0
2011-02-18 12:00:00	QQQ	ETF	58.91	58.96	58.85	58.8835	2172828.0
2011-02-18 13:00:00	QQQ	ETF	58.89	58.9	58.6	58.759	7391055.0
2011-02-18 14:00:00	QQQ	ETF	58.76	58.77	58.51	58.69	6068271.0
2011-02-18 15:00:00	QQQ	ETF	58.69	58.76	58.57	58.76	7513065.0
2011-02-18 16:00:00	QQQ	ETF	58.75	58.84	58.61	58.74	1204411.0
2011-02-18 17:00:00	QQQ	ETF	58.73	58.75	58.67	58.73	36653.0
2011-02-18 18:00:00	QQQ	ETF	58.75	58.75	58.71	58.72	10967.0
2011-02-18 19:00:00	QQQ	ETF	58.72	58.72	58.71	58.72	6957.0
2011-02-18 07:00:00	IWM	ETF	83.35	83.44	83.34	83.44	58993.0
2011-02-18 08:00:00	IWM	ETF	83.36	83.49	83.07	83.47	72243.0
2011-02-18 09:00:00	IWM	ETF	83.47	83.53	83.2	83.3	4250825.0
2011-02-18 10:00:00	IWM	ETF	83.31	83.52	83.22	83.42	4504369.0
2011-02-18 11:00:00	IWM	ETF	83.42	83.65	83.41	83.6464	3636163.0
2011-02-18 12:00:00	IWM	ETF	83.64	83.77	83.61	83.6799	2900130.0
2011-02-18 13:00:00	IWM	ETF	83.67	83.68	83.23	83.43	3834040.0
2011-02-18 14:00:00	IWM	ETF	83.43	83.43	83.04	83.29	5103450.0
2011-02-18 15:00:00	IWM	ETF	83.29	83.39	83.13	83.38	9059501.0
2011-02-18 16:00:00	IWM	ETF	83.39	83.6	83.1666	83.39	3872884.0
2011-02-18 17:00:00	IWM	ETF	83.35	83.4	83.33	83.4	4524.0
2011-02-18 18:00:00	IWM	ETF	83.38	83.38	83.38	83.38	1000.0
2011-02-18 19:00:00	IWM	ETF	83.4	83.4	83.4	83.4	100.0
2011-02-18 04:00:00	DIA	ETF	123.11	123.11	123.02	123.02	21663.0
2011-02-18 07:00:00	DIA	ETF	122.83	122.92	122.83	122.91	7801.0
2011-02-18 08:00:00	DIA	ETF	122.85	122.9	122.85	122.89	11804.0
2011-02-18 09:00:00	DIA	ETF	122.89	123.1	122.82	123.08	586796.0
2011-02-18 10:00:00	DIA	ETF	123.08	123.19	122.9799	123.11	996198.0
2011-02-18 11:00:00	DIA	ETF	123.11	123.36	123.1	123.3301	1134315.0

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

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