PREVIEW / etf_1hour / 2014-06-20

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-06-20.parquet
  size:    213 KB
  rows:    6,885

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-20 04:00:00	SPY	ETF	195.51	195.6	195.24	195.57	26008.0
2014-06-20 05:00:00	SPY	ETF	195.57	195.79	195.55	195.66	30433.0
2014-06-20 06:00:00	SPY	ETF	195.65	195.68	195.52	195.56	13665.0
2014-06-20 07:00:00	SPY	ETF	195.6	195.64	195.46	195.57	206060.0
2014-06-20 08:00:00	SPY	ETF	195.57	196.02	195.43	195.87	1235046.0
2014-06-20 09:00:00	SPY	ETF	195.87	196.17	195.77	195.87	19463516.0
2014-06-20 10:00:00	SPY	ETF	195.87	196.1039	195.72	195.93	16279958.0
2014-06-20 11:00:00	SPY	ETF	195.925	196.06	195.84	195.93	6804477.0
2014-06-20 12:00:00	SPY	ETF	195.928	195.94	195.78	195.85	6313683.0
2014-06-20 13:00:00	SPY	ETF	195.85	195.87	195.7	195.8	10025399.0
2014-06-20 14:00:00	SPY	ETF	195.805	195.91	195.75	195.795	6185165.0
2014-06-20 15:00:00	SPY	ETF	195.795	196.0	195.76	195.95	15245469.0
2014-06-20 16:00:00	SPY	ETF	195.95	195.9944	195.5988	195.89	11352473.0
2014-06-20 17:00:00	SPY	ETF	195.9	195.96	195.83	195.83	3701387.0
2014-06-20 18:00:00	SPY	ETF	195.94	195.95	195.84	195.94	601776.0
2014-06-20 19:00:00	SPY	ETF	195.95	195.97	195.9	195.97	11215.0
2014-06-20 04:00:00	QQQ	ETF	92.59	92.59	92.59	92.59	200.0
2014-06-20 05:00:00	QQQ	ETF	92.66	92.7	92.65	92.7	4900.0
2014-06-20 06:00:00	QQQ	ETF	92.62	92.62	92.62	92.62	2000.0
2014-06-20 07:00:00	QQQ	ETF	92.68	92.7	92.66	92.7	73000.0
2014-06-20 08:00:00	QQQ	ETF	92.72	92.91	92.7	92.71	227215.0
2014-06-20 09:00:00	QQQ	ETF	92.7	92.87	92.64	92.73	5733413.0
2014-06-20 10:00:00	QQQ	ETF	92.735	92.82	92.53	92.6352	3327285.0
2014-06-20 11:00:00	QQQ	ETF	92.64	92.76	92.6	92.63	2299166.0
2014-06-20 12:00:00	QQQ	ETF	92.64	92.6799	92.54	92.65	1725331.0
2014-06-20 13:00:00	QQQ	ETF	92.655	92.67	92.56	92.62	1428202.0
2014-06-20 14:00:00	QQQ	ETF	92.63	92.7	92.58	92.64	1669768.0
2014-06-20 15:00:00	QQQ	ETF	92.645	92.76	92.63	92.75	4904453.0
2014-06-20 16:00:00	QQQ	ETF	92.75	92.8	92.6452	92.76	1553187.0
2014-06-20 17:00:00	QQQ	ETF	92.76	92.78	92.72	92.74	393677.0
2014-06-20 18:00:00	QQQ	ETF	92.73	92.73	92.7	92.72	6100.0
2014-06-20 19:00:00	QQQ	ETF	92.7	92.72	92.69	92.72	4300.0
2014-06-20 08:00:00	IWM	ETF	117.71	118.22	117.71	118.1	152350.0
2014-06-20 09:00:00	IWM	ETF	118.12	118.24	117.61	117.65	4828882.0
2014-06-20 10:00:00	IWM	ETF	117.66	117.98	117.56	117.97	3749295.0
2014-06-20 11:00:00	IWM	ETF	117.97	118.12	117.83	117.935	2972222.0
2014-06-20 12:00:00	IWM	ETF	117.925	117.97	117.76	117.88	1385975.0
2014-06-20 13:00:00	IWM	ETF	117.87	117.99	117.84	117.96	1521818.0
2014-06-20 14:00:00	IWM	ETF	117.96	118.05	117.89	118.005	1797324.0
2014-06-20 15:00:00	IWM	ETF	118.01	118.3	117.96	118.26	5540790.0
2014-06-20 16:00:00	IWM	ETF	118.25	118.33	118.17	118.29	1952878.0
2014-06-20 17:00:00	IWM	ETF	118.31	118.45	118.23	118.25	1976321.0
2014-06-20 08:00:00	DIA	ETF	168.85	169.08	168.85	169.08	1900.0
2014-06-20 09:00:00	DIA	ETF	169.08	169.28	168.96	169.21	971125.0
2014-06-20 10:00:00	DIA	ETF	169.2	169.34	169.07	169.31	1519642.0
2014-06-20 11:00:00	DIA	ETF	169.32	169.42	169.19	169.27	887094.0
2014-06-20 12:00:00	DIA	ETF	169.27	169.28	169.14	169.18	247997.0
2014-06-20 13:00:00	DIA	ETF	169.18	169.18	169.02	169.12	256051.0
2014-06-20 14:00:00	DIA	ETF	169.12	169.21	169.08	169.12	330931.0
2014-06-20 15:00:00	DIA	ETF	169.12	169.21	169.0649	169.14	608737.0

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

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