PREVIEW / etf_1hour / 2011-11-11

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-11-11.parquet
  size:    175 KB
  rows:    5,372

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-11-11 04:00:00	SPY	ETF	125.12	125.2	124.71	124.94	2971.0
2011-11-11 05:00:00	SPY	ETF	124.96	125.1	124.86	125.01	1255.0
2011-11-11 06:00:00	SPY	ETF	124.85	125.25	124.85	125.0	88995.0
2011-11-11 07:00:00	SPY	ETF	124.91	125.42	124.83	125.42	847891.0
2011-11-11 08:00:00	SPY	ETF	125.39	125.66	125.11	125.49	3042472.0
2011-11-11 09:00:00	SPY	ETF	125.5	126.34	125.47	126.1	27386311.0
2011-11-11 10:00:00	SPY	ETF	126.09	126.92	126.08	126.81	34377821.0
2011-11-11 11:00:00	SPY	ETF	126.81	126.99	126.63	126.675	21145940.0
2011-11-11 12:00:00	SPY	ETF	126.68	126.84	126.51	126.6816	13792180.0
2011-11-11 13:00:00	SPY	ETF	126.685	126.94	126.61	126.65	13872825.0
2011-11-11 14:00:00	SPY	ETF	126.66	126.9	126.48	126.565	17289309.0
2011-11-11 15:00:00	SPY	ETF	126.57	126.72	126.34	126.69	34151812.0
2011-11-11 16:00:00	SPY	ETF	126.7	126.74	124.2427	126.51	21222081.0
2011-11-11 17:00:00	SPY	ETF	126.54	126.58	126.4	126.48	397684.0
2011-11-11 18:00:00	SPY	ETF	126.48	126.62	126.48	126.53	220877.0
2011-11-11 19:00:00	SPY	ETF	126.53	126.58	126.48	126.56	29972.0
2011-11-11 04:00:00	QQQ	ETF	57.04	57.04	56.9	57.01	1365.0
2011-11-11 06:00:00	QQQ	ETF	57.0	57.0	56.95	56.95	2250.0
2011-11-11 07:00:00	QQQ	ETF	57.04	57.11	57.01	57.1	50664.0
2011-11-11 08:00:00	QQQ	ETF	57.1	57.23	57.07	57.13	384308.0
2011-11-11 09:00:00	QQQ	ETF	57.14	57.48	57.13	57.32	8605773.0
2011-11-11 10:00:00	QQQ	ETF	57.32	57.8	57.31	57.7387	9605053.0
2011-11-11 11:00:00	QQQ	ETF	57.7301	57.94	57.7	57.8399	4588119.0
2011-11-11 12:00:00	QQQ	ETF	57.838	57.95	57.77	57.882	3438449.0
2011-11-11 13:00:00	QQQ	ETF	57.89	58.02	57.84	57.865	4766842.0
2011-11-11 14:00:00	QQQ	ETF	57.87	58.0	57.75	57.8001	3601513.0
2011-11-11 15:00:00	QQQ	ETF	57.8	57.86	57.71	57.83	6552486.0
2011-11-11 16:00:00	QQQ	ETF	57.83	57.86	56.7569	57.85	2735021.0
2011-11-11 17:00:00	QQQ	ETF	57.84	57.85	57.8	57.8	32250.0
2011-11-11 18:00:00	QQQ	ETF	57.82	57.84	57.81	57.82	13660.0
2011-11-11 19:00:00	QQQ	ETF	57.82	57.88	57.81	57.88	46225.0
2011-11-11 05:00:00	IWM	ETF	72.82	72.82	72.76	72.79	460.0
2011-11-11 06:00:00	IWM	ETF	72.97	73.02	72.97	73.02	300.0
2011-11-11 07:00:00	IWM	ETF	72.79	73.15	72.72	73.15	111200.0
2011-11-11 08:00:00	IWM	ETF	73.16	73.34	73.11	73.23	244110.0
2011-11-11 09:00:00	IWM	ETF	73.21	73.9	73.19	73.76	10574939.0
2011-11-11 10:00:00	IWM	ETF	73.76	74.53	73.76	74.45	11224545.0
2011-11-11 11:00:00	IWM	ETF	74.45	74.53	74.27	74.3	4292140.0
2011-11-11 12:00:00	IWM	ETF	74.31	74.45	74.11	74.28	2914771.0
2011-11-11 13:00:00	IWM	ETF	74.29	74.52	74.19	74.31	3169459.0
2011-11-11 14:00:00	IWM	ETF	74.3	74.5	74.15	74.26	4962383.0
2011-11-11 15:00:00	IWM	ETF	74.25	74.47	74.11	74.32	9092789.0
2011-11-11 16:00:00	IWM	ETF	74.32	74.43	72.5296	74.35	2971834.0
2011-11-11 17:00:00	IWM	ETF	74.34	74.35	74.31	74.35	16471.0
2011-11-11 18:00:00	IWM	ETF	74.35	74.35	74.33	74.33	5818.0
2011-11-11 19:00:00	IWM	ETF	74.33	74.38	74.32	74.37	5400.0
2011-11-11 07:00:00	DIA	ETF	119.6	119.63	119.59	119.59	1000.0
2011-11-11 08:00:00	DIA	ETF	119.68	119.93	119.68	119.87	13770.0
2011-11-11 09:00:00	DIA	ETF	119.85	121.05	119.85	120.9	1192599.0
2011-11-11 10:00:00	DIA	ETF	120.9	121.64	120.9	121.57	1651480.0

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

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