PREVIEW / etf_1hour / 2011-07-20

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-07-20.parquet
  size:    179 KB
  rows:    5,589

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-07-20 04:00:00	SPY	ETF	133.0	133.12	133.0	133.1	2014.0
2011-07-20 05:00:00	SPY	ETF	132.79	133.09	132.79	133.09	500.0
2011-07-20 06:00:00	SPY	ETF	133.02	133.35	132.99	133.3	18275.0
2011-07-20 07:00:00	SPY	ETF	133.32	133.43	133.21	133.25	1056299.0
2011-07-20 08:00:00	SPY	ETF	133.3	133.34	133.12	133.22	3586825.0
2011-07-20 09:00:00	SPY	ETF	133.22	133.28	132.58	132.63	19018624.0
2011-07-20 10:00:00	SPY	ETF	132.63	132.94	132.42	132.8293	27645629.0
2011-07-20 11:00:00	SPY	ETF	132.82	132.99	132.55	132.61	14828189.0
2011-07-20 12:00:00	SPY	ETF	132.61	132.73	132.5	132.71	9603990.0
2011-07-20 13:00:00	SPY	ETF	132.71	133.01	132.61	132.95	10045273.0
2011-07-20 14:00:00	SPY	ETF	132.9406	133.1	132.75	132.86	15551742.0
2011-07-20 15:00:00	SPY	ETF	132.85	132.98	132.54	132.65	21572998.0
2011-07-20 16:00:00	SPY	ETF	132.65	132.8456	132.19	132.21	12448708.0
2011-07-20 17:00:00	SPY	ETF	132.24	132.65	132.1	132.17	440388.0
2011-07-20 18:00:00	SPY	ETF	132.17	132.91	132.08	132.89	760360.0
2011-07-20 19:00:00	SPY	ETF	132.87	133.04	132.83	132.98	612781.0
2011-07-20 04:00:00	QQQ	ETF	59.22	59.22	59.13	59.13	5490.0
2011-07-20 05:00:00	QQQ	ETF	59.1	59.17	59.1	59.17	400.0
2011-07-20 06:00:00	QQQ	ETF	59.2	59.29	59.2	59.28	1800.0
2011-07-20 07:00:00	QQQ	ETF	59.27	59.29	59.21	59.24	92553.0
2011-07-20 08:00:00	QQQ	ETF	59.23	59.25	59.18	59.2	1823834.0
2011-07-20 09:00:00	QQQ	ETF	59.21	59.24	58.73	58.83	8775480.0
2011-07-20 10:00:00	QQQ	ETF	58.83	58.889	58.6	58.83	8959067.0
2011-07-20 11:00:00	QQQ	ETF	58.82	58.91	58.55	58.57	6065680.0
2011-07-20 12:00:00	QQQ	ETF	58.57	58.65	58.5	58.61	4609545.0
2011-07-20 13:00:00	QQQ	ETF	58.62	58.839	58.57	58.8	6282930.0
2011-07-20 14:00:00	QQQ	ETF	58.7925	58.84	58.62	58.68	4387472.0
2011-07-20 15:00:00	QQQ	ETF	58.675	58.76	58.55	58.6	7323551.0
2011-07-20 16:00:00	QQQ	ETF	58.59	58.7	58.23	58.24	2522007.0
2011-07-20 17:00:00	QQQ	ETF	58.24	58.32	58.17	58.2	400092.0
2011-07-20 18:00:00	QQQ	ETF	58.2	58.7115	58.11	58.31	441544.0
2011-07-20 19:00:00	QQQ	ETF	58.34	58.45	58.34	58.39	139002.0
2011-07-20 06:00:00	IWM	ETF	83.57	83.57	83.57	83.57	200.0
2011-07-20 07:00:00	IWM	ETF	83.6	83.7	83.48	83.48	309663.0
2011-07-20 08:00:00	IWM	ETF	83.51	83.64	83.45	83.47	1081650.0
2011-07-20 09:00:00	IWM	ETF	83.48	83.53	82.74	82.89	8631682.0
2011-07-20 10:00:00	IWM	ETF	82.89	83.06	82.65	82.99	6877947.0
2011-07-20 11:00:00	IWM	ETF	82.98	83.04	82.68	82.75	3115292.0
2011-07-20 12:00:00	IWM	ETF	82.75	82.89	82.72	82.8844	2390066.0
2011-07-20 13:00:00	IWM	ETF	82.89	83.12	82.83	83.06	2128535.0
2011-07-20 14:00:00	IWM	ETF	83.06	83.28	83.05	83.13	3771449.0
2011-07-20 15:00:00	IWM	ETF	83.14	83.28	83.07	83.17	5368179.0
2011-07-20 16:00:00	IWM	ETF	83.18	83.21	82.8	82.88	599496.0
2011-07-20 17:00:00	IWM	ETF	82.9	82.92	82.81	82.81	243128.0
2011-07-20 18:00:00	IWM	ETF	82.86	83.22	82.82	83.22	12740.0
2011-07-20 19:00:00	IWM	ETF	83.26	83.3	83.12	83.3	13570.0
2011-07-20 04:00:00	DIA	ETF	125.83	125.86	125.83	125.86	1100.0
2011-07-20 05:00:00	DIA	ETF	125.7	125.79	125.7	125.79	200.0
2011-07-20 06:00:00	DIA	ETF	125.84	125.84	125.84	125.84	200.0
2011-07-20 07:00:00	DIA	ETF	125.99	126.09	125.95	125.95	5200.0

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

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