PREVIEW / etf_1hour / 2014-06-23

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-06-23.parquet
  size:    216 KB
  rows:    6,908

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
2014-06-23 04:00:00	SPY	ETF	195.94	195.94	195.71	195.82	5583.0
2014-06-23 05:00:00	SPY	ETF	195.86	196.07	195.84	196.03	2975.0
2014-06-23 06:00:00	SPY	ETF	196.04	196.05	195.75	195.76	48371.0
2014-06-23 07:00:00	SPY	ETF	195.78	195.96	195.78	195.81	62048.0
2014-06-23 08:00:00	SPY	ETF	195.83	195.97	195.79	195.87	210890.0
2014-06-23 09:00:00	SPY	ETF	195.88	196.03	195.61	195.87	7823610.0
2014-06-23 10:00:00	SPY	ETF	195.87	196.05	195.68	195.77	12587627.0
2014-06-23 11:00:00	SPY	ETF	195.765	195.815	195.52	195.62	7903894.0
2014-06-23 12:00:00	SPY	ETF	195.62	195.86	195.61	195.805	3674191.0
2014-06-23 13:00:00	SPY	ETF	195.81	195.82	195.57	195.7	4327709.0
2014-06-23 14:00:00	SPY	ETF	195.71	195.8	195.62	195.79	4616642.0
2014-06-23 15:00:00	SPY	ETF	195.79	195.96	195.67	195.882	10059339.0
2014-06-23 16:00:00	SPY	ETF	195.89	195.9371	195.7	195.75	15891682.0
2014-06-23 17:00:00	SPY	ETF	195.74	195.75	195.69	195.7	38316.0
2014-06-23 18:00:00	SPY	ETF	195.67	195.68	195.57	195.65	109882.0
2014-06-23 19:00:00	SPY	ETF	195.64	195.69	195.57	195.67	51186.0
2014-06-23 04:00:00	QQQ	ETF	92.67	92.67	92.57	92.57	600.0
2014-06-23 05:00:00	QQQ	ETF	92.69	92.69	92.69	92.69	1200.0
2014-06-23 06:00:00	QQQ	ETF	92.67	92.67	92.62	92.62	1900.0
2014-06-23 07:00:00	QQQ	ETF	92.65	92.68	92.64	92.67	1600.0
2014-06-23 08:00:00	QQQ	ETF	92.67	92.71	92.62	92.68	43075.0
2014-06-23 09:00:00	QQQ	ETF	92.69	92.8	92.5799	92.72	3447022.0
2014-06-23 10:00:00	QQQ	ETF	92.72	92.79	92.54	92.58	4214021.0
2014-06-23 11:00:00	QQQ	ETF	92.58	92.679	92.51	92.6	2073986.0
2014-06-23 12:00:00	QQQ	ETF	92.595	92.82	92.59	92.745	1424783.0
2014-06-23 13:00:00	QQQ	ETF	92.75	92.78	92.61	92.71	1461315.0
2014-06-23 14:00:00	QQQ	ETF	92.715	92.791	92.67	92.78	936616.0
2014-06-23 15:00:00	QQQ	ETF	92.78	92.795	92.67	92.79	3035300.0
2014-06-23 16:00:00	QQQ	ETF	92.8	92.81	92.6757	92.72	2779910.0
2014-06-23 17:00:00	QQQ	ETF	92.75	92.75	92.73	92.73	999.0
2014-06-23 18:00:00	QQQ	ETF	92.71	92.71	92.65	92.68	16404.0
2014-06-23 19:00:00	QQQ	ETF	92.68	92.7	92.66	92.7	16328.0
2014-06-23 04:00:00	IWM	ETF	118.5	118.5	118.4	118.4	300.0
2014-06-23 05:00:00	IWM	ETF	118.65	118.65	118.65	118.65	100.0
2014-06-23 07:00:00	IWM	ETF	118.42	118.43	118.42	118.43	630.0
2014-06-23 08:00:00	IWM	ETF	118.5	118.51	117.9236	118.38	277640.0
2014-06-23 09:00:00	IWM	ETF	118.4	118.54	117.96	118.27	2827048.0
2014-06-23 10:00:00	IWM	ETF	118.29	118.55	118.01	118.09	4012406.0
2014-06-23 11:00:00	IWM	ETF	118.09	118.14	117.76	117.79	2145824.0
2014-06-23 12:00:00	IWM	ETF	117.78	118.01	117.78	117.95	1050307.0
2014-06-23 13:00:00	IWM	ETF	117.945	117.97	117.69	117.865	1429783.0
2014-06-23 14:00:00	IWM	ETF	117.86	118.09	117.83	117.96	1725623.0
2014-06-23 15:00:00	IWM	ETF	117.95	118.01	117.81	118.005	3108913.0
2014-06-23 16:00:00	IWM	ETF	118.005	118.03	117.83	117.83	1648036.0
2014-06-23 17:00:00	IWM	ETF	117.84	117.97	117.8	117.97	77150.0
2014-06-23 18:00:00	IWM	ETF	117.82	117.82	117.82	117.82	3900.0
2014-06-23 19:00:00	IWM	ETF	117.83	117.88	117.82	117.85	3050.0
2014-06-23 08:00:00	DIA	ETF	169.01	169.01	169.01	169.01	200.0
2014-06-23 09:00:00	DIA	ETF	169.0	169.12	168.58	168.85	662602.0
2014-06-23 10:00:00	DIA	ETF	168.86	169.01	168.69	168.78	493663.0

> showing 50 of 6,908 rows — these rows as CSV

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