PREVIEW / etf_1hour / 2011-08-02

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-08-02.parquet
  size:    192 KB
  rows:    5,907

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-08-02 04:00:00	SPY	ETF	128.13	128.13	127.75	127.83	7676.0
2011-08-02 05:00:00	SPY	ETF	127.94	127.94	127.6	127.7	7800.0
2011-08-02 06:00:00	SPY	ETF	127.7	128.05	127.7	127.87	44550.0
2011-08-02 07:00:00	SPY	ETF	127.88	127.99	127.53	127.78	1242087.0
2011-08-02 08:00:00	SPY	ETF	127.79	127.94	127.07	127.9	6716528.0
2011-08-02 09:00:00	SPY	ETF	127.9	128.43	127.6	128.35	28297662.0
2011-08-02 10:00:00	SPY	ETF	128.36	128.5	127.6	127.6715	36061994.0
2011-08-02 11:00:00	SPY	ETF	127.67	127.7267	127.23	127.38	37188198.0
2011-08-02 12:00:00	SPY	ETF	127.39	127.66	126.63	126.82	39824055.0
2011-08-02 13:00:00	SPY	ETF	126.81	127.25	126.3	126.4269	34646005.0
2011-08-02 14:00:00	SPY	ETF	126.43	126.96	126.36	126.87	27377177.0
2011-08-02 15:00:00	SPY	ETF	126.87	126.95	125.49	125.5	84204215.0
2011-08-02 16:00:00	SPY	ETF	125.5	128.8023	125.06	125.13	32985857.0
2011-08-02 17:00:00	SPY	ETF	125.13	125.5153	125.03	125.3	10711678.0
2011-08-02 18:00:00	SPY	ETF	125.3	125.49	124.96	125.09	1177915.0
2011-08-02 19:00:00	SPY	ETF	125.1	125.22	125.07	125.12	190929.0
2011-08-02 04:00:00	QQQ	ETF	57.5	57.5	57.41	57.41	2148.0
2011-08-02 06:00:00	QQQ	ETF	57.4	57.4	57.4	57.4	300.0
2011-08-02 07:00:00	QQQ	ETF	57.41	57.43	57.28	57.39	209173.0
2011-08-02 08:00:00	QQQ	ETF	57.39	57.46	57.13	57.45	1864214.0
2011-08-02 09:00:00	QQQ	ETF	57.44	57.64	57.33	57.62	6979180.0
2011-08-02 10:00:00	QQQ	ETF	57.63	57.72	57.38	57.415	13247323.0
2011-08-02 11:00:00	QQQ	ETF	57.42	57.42	57.17	57.275	13131672.0
2011-08-02 12:00:00	QQQ	ETF	57.28	57.41	56.89	56.9705	9999592.0
2011-08-02 13:00:00	QQQ	ETF	56.979	57.13	56.58	56.64	8496403.0
2011-08-02 14:00:00	QQQ	ETF	56.64	56.92	56.605	56.88	6795439.0
2011-08-02 15:00:00	QQQ	ETF	56.89	56.94	56.21	56.27	19033018.0
2011-08-02 16:00:00	QQQ	ETF	56.27	56.39	56.11	56.14	1927270.0
2011-08-02 17:00:00	QQQ	ETF	56.14	56.25	56.07	56.2	867097.0
2011-08-02 18:00:00	QQQ	ETF	56.15	56.25	56.06	56.12	151527.0
2011-08-02 19:00:00	QQQ	ETF	56.13	56.25	56.11	56.25	85111.0
2011-08-02 04:00:00	IWM	ETF	78.9	78.9	78.83	78.83	652.0
2011-08-02 07:00:00	IWM	ETF	78.73	78.85	78.48	78.78	266548.0
2011-08-02 08:00:00	IWM	ETF	78.8	78.92	78.38	78.91	1811223.0
2011-08-02 09:00:00	IWM	ETF	78.92	79.56	78.59	79.47	8347168.0
2011-08-02 10:00:00	IWM	ETF	79.49	79.6801	78.76	78.82	12695616.0
2011-08-02 11:00:00	IWM	ETF	78.81	78.83	78.19	78.31	10259474.0
2011-08-02 12:00:00	IWM	ETF	78.31	78.49	77.82	77.95	8145762.0
2011-08-02 13:00:00	IWM	ETF	77.94	78.2	77.41	77.5	7510091.0
2011-08-02 14:00:00	IWM	ETF	77.49	77.91	77.46	77.89	7583692.0
2011-08-02 15:00:00	IWM	ETF	77.88	77.92	76.61	76.8	18631495.0
2011-08-02 16:00:00	IWM	ETF	76.79	79.2046	76.39	76.39	3527265.0
2011-08-02 17:00:00	IWM	ETF	76.43	76.55	76.39	76.53	58760.0
2011-08-02 18:00:00	IWM	ETF	76.46	76.5	76.43	76.46	12402.0
2011-08-02 19:00:00	IWM	ETF	76.48	76.54	76.48	76.48	2222.0
2011-08-02 05:00:00	DIA	ETF	120.28	120.28	120.17	120.17	200.0
2011-08-02 06:00:00	DIA	ETF	120.43	120.43	120.43	120.43	100.0
2011-08-02 07:00:00	DIA	ETF	120.29	120.37	120.1	120.28	13100.0
2011-08-02 08:00:00	DIA	ETF	120.29	120.42	119.85	120.41	161023.0
2011-08-02 09:00:00	DIA	ETF	120.37	120.94	120.1	120.85	861639.0

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

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