PREVIEW / etf_1hour / 2011-05-26

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-05-26.parquet
  size:    177 KB
  rows:    5,370

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-05-26 04:00:00	SPY	ETF	132.51	132.74	132.45	132.45	12032.0
2011-05-26 05:00:00	SPY	ETF	132.43	132.43	132.24	132.24	900.0
2011-05-26 06:00:00	SPY	ETF	132.46	132.55	132.38	132.41	11787.0
2011-05-26 07:00:00	SPY	ETF	132.34	132.51	132.27	132.5	264212.0
2011-05-26 08:00:00	SPY	ETF	132.5	132.7	131.96	132.22	3311529.0
2011-05-26 09:00:00	SPY	ETF	132.2	132.43	131.85	131.9208	18571917.0
2011-05-26 10:00:00	SPY	ETF	131.92	132.27	131.78	131.87	25123408.0
2011-05-26 11:00:00	SPY	ETF	131.87	132.3	131.78	132.22	18923495.0
2011-05-26 12:00:00	SPY	ETF	132.23	132.74	132.15	132.67	18197133.0
2011-05-26 13:00:00	SPY	ETF	132.67	132.975	132.645	132.79	17097189.0
2011-05-26 14:00:00	SPY	ETF	132.79	133.24	132.79	133.15	18726722.0
2011-05-26 15:00:00	SPY	ETF	133.145	133.21	132.84	132.99	32173908.0
2011-05-26 16:00:00	SPY	ETF	132.99	133.22	132.11	133.2	11067157.0
2011-05-26 17:00:00	SPY	ETF	133.2	133.27	133.16	133.2	103180.0
2011-05-26 18:00:00	SPY	ETF	133.2	133.2	133.01	133.18	21123.0
2011-05-26 19:00:00	SPY	ETF	133.18	133.25	133.17	133.22	68953.0
2011-05-26 04:00:00	QQQ	ETF	56.85	56.85	56.85	56.85	1000.0
2011-05-26 05:00:00	QQQ	ETF	56.82	56.82	56.82	56.82	1000.0
2011-05-26 06:00:00	QQQ	ETF	56.82	56.82	56.8	56.8	800.0
2011-05-26 07:00:00	QQQ	ETF	56.77	56.78	56.74	56.78	5700.0
2011-05-26 08:00:00	QQQ	ETF	56.86	56.92	56.62	56.71	543101.0
2011-05-26 09:00:00	QQQ	ETF	56.71	56.91	56.61	56.7	6332968.0
2011-05-26 10:00:00	QQQ	ETF	56.71	56.94	56.68	56.75	5585996.0
2011-05-26 11:00:00	QQQ	ETF	56.74	56.99	56.73	56.95	3845321.0
2011-05-26 12:00:00	QQQ	ETF	56.96	57.16	56.91	57.12	4735751.0
2011-05-26 13:00:00	QQQ	ETF	57.12	57.21	57.07	57.129	3928672.0
2011-05-26 14:00:00	QQQ	ETF	57.1281	57.3	57.125	57.28	3697578.0
2011-05-26 15:00:00	QQQ	ETF	57.28	57.3	57.13	57.16	7503719.0
2011-05-26 16:00:00	QQQ	ETF	57.16	57.2443	56.7841	57.2	1090032.0
2011-05-26 17:00:00	QQQ	ETF	57.21	57.24	56.7841	57.21	503809.0
2011-05-26 18:00:00	QQQ	ETF	57.22	57.22	57.15	57.2	44052.0
2011-05-26 19:00:00	QQQ	ETF	57.21	57.23	57.19	57.19	11350.0
2011-05-26 06:00:00	IWM	ETF	81.98	82.0	81.98	82.0	4429.0
2011-05-26 07:00:00	IWM	ETF	81.86	82.02	81.84	82.02	181900.0
2011-05-26 08:00:00	IWM	ETF	82.09	82.23	81.7	81.83	894289.0
2011-05-26 09:00:00	IWM	ETF	81.83	82.1	81.67	81.75	7012699.0
2011-05-26 10:00:00	IWM	ETF	81.75	82.19	81.65	81.87	7656591.0
2011-05-26 11:00:00	IWM	ETF	81.86	82.43	81.77	82.39	5336825.0
2011-05-26 12:00:00	IWM	ETF	82.385	82.87	82.3	82.77	5748823.0
2011-05-26 13:00:00	IWM	ETF	82.77	82.92	82.695	82.73	5578635.0
2011-05-26 14:00:00	IWM	ETF	82.74	83.12	82.73	83.05	4649901.0
2011-05-26 15:00:00	IWM	ETF	83.05	83.11	82.84	83.08	10001812.0
2011-05-26 16:00:00	IWM	ETF	83.08	83.28	83.0386	83.27	1643028.0
2011-05-26 17:00:00	IWM	ETF	83.26	83.3	83.22	83.25	12328.0
2011-05-26 18:00:00	IWM	ETF	83.23	83.26	83.22	83.23	1530.0
2011-05-26 19:00:00	IWM	ETF	83.25	83.28	83.25	83.27	1900.0
2011-05-26 04:00:00	DIA	ETF	123.87	123.87	123.87	123.87	200.0
2011-05-26 05:00:00	DIA	ETF	123.75	123.75	123.58	123.58	200.0
2011-05-26 06:00:00	DIA	ETF	123.74	123.74	123.74	123.74	500.0
2011-05-26 08:00:00	DIA	ETF	123.81	123.85	123.38	123.64	27800.0

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

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