PREVIEW / etf_1hour / 2012-07-10

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-07-10.parquet
  size:    182 KB
  rows:    5,596

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
2012-07-10 04:00:00	SPY	ETF	135.05	135.81	135.0	135.81	5237.0
2012-07-10 05:00:00	SPY	ETF	135.82	136.05	135.82	135.9	54504.0
2012-07-10 06:00:00	SPY	ETF	135.9	136.11	135.9	136.01	61000.0
2012-07-10 07:00:00	SPY	ETF	136.01	136.04	135.82	135.92	240979.0
2012-07-10 08:00:00	SPY	ETF	135.92	135.95	135.43	135.93	1735927.0
2012-07-10 09:00:00	SPY	ETF	135.94	136.23	135.685	135.8809	15844614.0
2012-07-10 10:00:00	SPY	ETF	135.88	136.0225	135.01	135.17	21539774.0
2012-07-10 11:00:00	SPY	ETF	135.18	135.21	134.83	135.17	17631293.0
2012-07-10 12:00:00	SPY	ETF	135.17	135.24	134.98	135.08	8198244.0
2012-07-10 13:00:00	SPY	ETF	135.07	135.19	134.57	134.68	13086910.0
2012-07-10 14:00:00	SPY	ETF	134.6705	135.3091	133.92	133.97	22132129.0
2012-07-10 15:00:00	SPY	ETF	133.97	134.35	133.68	134.16	40887471.0
2012-07-10 16:00:00	SPY	ETF	134.17	135.3091	134.04	134.23	13569814.0
2012-07-10 17:00:00	SPY	ETF	134.22	134.22	134.1	134.16	2154517.0
2012-07-10 18:00:00	SPY	ETF	134.13	134.16	134.08	134.13	4546813.0
2012-07-10 19:00:00	SPY	ETF	134.12	134.15	134.08	134.14	88631.0
2012-07-10 04:00:00	QQQ	ETF	64.05	64.18	64.05	64.18	4800.0
2012-07-10 05:00:00	QQQ	ETF	64.27	64.3	64.27	64.3	600.0
2012-07-10 06:00:00	QQQ	ETF	64.26	64.31	64.26	64.3	6600.0
2012-07-10 07:00:00	QQQ	ETF	64.3	64.3	64.25	64.25	10008.0
2012-07-10 08:00:00	QQQ	ETF	64.26	64.35	64.07	64.35	1726034.0
2012-07-10 09:00:00	QQQ	ETF	64.34	64.51	64.25	64.35	5110454.0
2012-07-10 10:00:00	QQQ	ETF	64.36	64.43	63.72	63.81	7601719.0
2012-07-10 11:00:00	QQQ	ETF	63.8	63.8	63.51	63.7552	6436747.0
2012-07-10 12:00:00	QQQ	ETF	63.7595	63.85	63.67	63.76	2449625.0
2012-07-10 13:00:00	QQQ	ETF	63.77	63.829	63.59	63.64	5326894.0
2012-07-10 14:00:00	QQQ	ETF	63.64	63.69	63.21	63.23	6230476.0
2012-07-10 15:00:00	QQQ	ETF	63.24	63.48	63.12	63.4	9447203.0
2012-07-10 16:00:00	QQQ	ETF	63.4	64.011	63.173	63.35	1496417.0
2012-07-10 17:00:00	QQQ	ETF	63.35	63.35	63.3	63.3	74331.0
2012-07-10 18:00:00	QQQ	ETF	63.3	63.33	63.3	63.3	6150.0
2012-07-10 19:00:00	QQQ	ETF	63.3	63.31	63.29	63.29	22760.0
2012-07-10 04:00:00	IWM	ETF	80.2	80.2	80.2	80.2	172.0
2012-07-10 07:00:00	IWM	ETF	80.78	80.79	80.67	80.72	37482.0
2012-07-10 08:00:00	IWM	ETF	80.69	80.7834	80.41	80.77	225901.0
2012-07-10 09:00:00	IWM	ETF	80.76	80.96	80.52	80.54	4042824.0
2012-07-10 10:00:00	IWM	ETF	80.54	80.64	80.0	80.11	7511883.0
2012-07-10 11:00:00	IWM	ETF	80.1	80.1	79.8	80.02	4990376.0
2012-07-10 12:00:00	IWM	ETF	80.01	80.11	79.91	79.98	2247139.0
2012-07-10 13:00:00	IWM	ETF	79.98	80.08	79.57	79.61	3586033.0
2012-07-10 14:00:00	IWM	ETF	79.61	79.67	79.09	79.18	7120683.0
2012-07-10 15:00:00	IWM	ETF	79.17	79.39	78.98	79.35	11607752.0
2012-07-10 16:00:00	IWM	ETF	79.34	80.2327	79.1463	79.4	4144705.0
2012-07-10 17:00:00	IWM	ETF	79.36	79.37	79.36	79.36	3600.0
2012-07-10 18:00:00	IWM	ETF	79.38	79.38	79.34	79.34	3000.0
2012-07-10 19:00:00	IWM	ETF	79.33	79.34	79.33	79.33	1600.0
2012-07-10 07:00:00	DIA	ETF	127.88	127.88	127.88	127.88	580.0
2012-07-10 08:00:00	DIA	ETF	127.75	127.81	127.49	127.81	6101.0
2012-07-10 09:00:00	DIA	ETF	127.79	128.14	127.79	127.837	352408.0
2012-07-10 10:00:00	DIA	ETF	127.82	127.91	126.94	127.05	732937.0

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

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