PREVIEW / etf_1hour / 2014-02-14

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-02-14.parquet
  size:    214 KB
  rows:    6,738

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-02-14 04:00:00	SPY	ETF	182.6	183.05	182.58	182.95	15010.0
2014-02-14 05:00:00	SPY	ETF	182.95	182.95	182.85	182.92	33887.0
2014-02-14 06:00:00	SPY	ETF	182.87	183.14	182.87	183.14	42692.0
2014-02-14 07:00:00	SPY	ETF	183.12	183.19	183.0	183.08	184817.0
2014-02-14 08:00:00	SPY	ETF	183.07	183.11	182.83	182.95	710533.0
2014-02-14 09:00:00	SPY	ETF	182.96	183.23	182.58	183.13	10916280.0
2014-02-14 10:00:00	SPY	ETF	183.13	183.78	182.89	183.5	15566618.0
2014-02-14 11:00:00	SPY	ETF	183.49	183.74	183.419	183.61	9691860.0
2014-02-14 12:00:00	SPY	ETF	183.61	183.73	183.53	183.66	8407231.0
2014-02-14 13:00:00	SPY	ETF	183.66	184.07	183.611	184.03	7583838.0
2014-02-14 14:00:00	SPY	ETF	184.0201	184.36	184.0	184.29	8820953.0
2014-02-14 15:00:00	SPY	ETF	184.285	184.31	183.92	184.01	18285287.0
2014-02-14 16:00:00	SPY	ETF	184.01	184.06	183.1503	183.99	13570497.0
2014-02-14 17:00:00	SPY	ETF	183.99	184.0	183.6873	183.97	530845.0
2014-02-14 18:00:00	SPY	ETF	183.97	184.01	183.95	184.01	8823.0
2014-02-14 19:00:00	SPY	ETF	184.0	184.01	183.95	184.01	10934.0
2014-02-14 05:00:00	QQQ	ETF	89.65	89.68	89.65	89.68	3300.0
2014-02-14 06:00:00	QQQ	ETF	89.67	89.78	89.65	89.76	7000.0
2014-02-14 07:00:00	QQQ	ETF	89.76	89.79	89.71	89.74	17100.0
2014-02-14 08:00:00	QQQ	ETF	89.73	89.74	89.61	89.65	66777.0
2014-02-14 09:00:00	QQQ	ETF	89.64	89.64	89.37	89.46	4669321.0
2014-02-14 10:00:00	QQQ	ETF	89.46	89.78	89.33	89.5199	5866299.0
2014-02-14 11:00:00	QQQ	ETF	89.52	89.75	89.48	89.699	3801036.0
2014-02-14 12:00:00	QQQ	ETF	89.7	89.72	89.56	89.67	1834128.0
2014-02-14 13:00:00	QQQ	ETF	89.675	89.9	89.65	89.8699	1860135.0
2014-02-14 14:00:00	QQQ	ETF	89.867	90.01	89.85	89.99	2347276.0
2014-02-14 15:00:00	QQQ	ETF	89.99	90.0	89.79	89.81	4326327.0
2014-02-14 16:00:00	QQQ	ETF	89.81	89.87	89.384	89.86	3275560.0
2014-02-14 17:00:00	QQQ	ETF	89.87	89.89	89.83	89.89	27465.0
2014-02-14 18:00:00	QQQ	ETF	89.89	89.9	89.85	89.85	6500.0
2014-02-14 19:00:00	QQQ	ETF	89.9	89.92	89.87	89.9	4760.0
2014-02-14 07:00:00	IWM	ETF	113.94	113.94	113.83	113.86	71300.0
2014-02-14 08:00:00	IWM	ETF	113.85	113.88	113.7	113.75	129602.0
2014-02-14 09:00:00	IWM	ETF	113.7	113.87	113.14	113.62	5551287.0
2014-02-14 10:00:00	IWM	ETF	113.64	114.14	113.365	113.545	7285176.0
2014-02-14 11:00:00	IWM	ETF	113.54	113.9	113.45	113.74	2997873.0
2014-02-14 12:00:00	IWM	ETF	113.745	113.89	113.63	113.84	2027856.0
2014-02-14 13:00:00	IWM	ETF	113.83	114.12	113.81	114.09	2142454.0
2014-02-14 14:00:00	IWM	ETF	114.09	114.19	114.015	114.18	2021540.0
2014-02-14 15:00:00	IWM	ETF	114.17	114.21	113.96	114.08	4759932.0
2014-02-14 16:00:00	IWM	ETF	114.08	114.13	113.7333	113.98	1999367.0
2014-02-14 17:00:00	IWM	ETF	113.98	113.99	113.96	113.97	73265.0
2014-02-14 08:00:00	DIA	ETF	160.25	160.25	160.21	160.21	565.0
2014-02-14 09:00:00	DIA	ETF	160.17	160.46	159.9	160.43	631623.0
2014-02-14 10:00:00	DIA	ETF	160.42	161.02	160.23	160.91	1351354.0
2014-02-14 11:00:00	DIA	ETF	160.9	161.19	160.86	161.08	481982.0
2014-02-14 12:00:00	DIA	ETF	161.08	161.19	161.02	161.14	302074.0
2014-02-14 13:00:00	DIA	ETF	161.12	161.55	161.1	161.49	534880.0
2014-02-14 14:00:00	DIA	ETF	161.495	161.83	161.47	161.76	606622.0
2014-02-14 15:00:00	DIA	ETF	161.76	161.79	161.48	161.57	1256679.0

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

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