PREVIEW / etf_1hour / 2014-11-03

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-11-03.parquet
  size:    234 KB
  rows:    7,439

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-11-03 04:00:00	SPY	ETF	201.4	201.48	201.3	201.45	20400.0
2014-11-03 05:00:00	SPY	ETF	201.5	201.56	201.43	201.5	11714.0
2014-11-03 06:00:00	SPY	ETF	201.48	201.55	201.41	201.41	56947.0
2014-11-03 07:00:00	SPY	ETF	201.41	201.49	201.28	201.48	222638.0
2014-11-03 08:00:00	SPY	ETF	201.67	201.78	201.33	201.7	911050.0
2014-11-03 09:00:00	SPY	ETF	201.7	202.16	201.64	201.89	15808480.0
2014-11-03 10:00:00	SPY	ETF	201.89	202.21	201.35	201.89	18214895.0
2014-11-03 11:00:00	SPY	ETF	201.89	202.04	201.67	201.98	9615818.0
2014-11-03 12:00:00	SPY	ETF	201.98	202.45	201.9	202.37	7209467.0
2014-11-03 13:00:00	SPY	ETF	202.36	202.425	202.18	202.18	6753645.0
2014-11-03 14:00:00	SPY	ETF	202.19	202.23	201.55	201.64	11189875.0
2014-11-03 15:00:00	SPY	ETF	201.64	201.86	201.305	201.75	17134634.0
2014-11-03 16:00:00	SPY	ETF	201.74	201.85	201.53	201.6	5962321.0
2014-11-03 17:00:00	SPY	ETF	201.62	201.7	201.6	201.61	88325.0
2014-11-03 18:00:00	SPY	ETF	201.61	201.63	201.47	201.49	96247.0
2014-11-03 19:00:00	SPY	ETF	201.51	201.51	201.25	201.29	134542.0
2014-11-03 04:00:00	QQQ	ETF	101.33	101.33	101.23	101.25	6740.0
2014-11-03 05:00:00	QQQ	ETF	101.32	101.32	101.32	101.32	10000.0
2014-11-03 06:00:00	QQQ	ETF	101.32	101.36	101.29	101.33	3900.0
2014-11-03 07:00:00	QQQ	ETF	101.33	101.36	101.25	101.35	30136.0
2014-11-03 08:00:00	QQQ	ETF	101.36	101.5	101.31	101.46	138782.0
2014-11-03 09:00:00	QQQ	ETF	101.49	101.895	101.43	101.8365	4047355.0
2014-11-03 10:00:00	QQQ	ETF	101.84	101.9701	101.52	101.815	6069756.0
2014-11-03 11:00:00	QQQ	ETF	101.81	101.87	101.67	101.78	2853185.0
2014-11-03 12:00:00	QQQ	ETF	101.79	101.91	101.7	101.83	2194742.0
2014-11-03 13:00:00	QQQ	ETF	101.835	101.8463	101.75	101.765	1572302.0
2014-11-03 14:00:00	QQQ	ETF	101.76	101.8199	101.52	101.57	3121257.0
2014-11-03 15:00:00	QQQ	ETF	101.56	101.74	101.45	101.7	4559571.0
2014-11-03 16:00:00	QQQ	ETF	101.71	101.7513	101.4384	101.57	2703501.0
2014-11-03 17:00:00	QQQ	ETF	101.58	101.7105	101.4384	101.61	2206938.0
2014-11-03 18:00:00	QQQ	ETF	101.57	101.59	101.52	101.52	9272.0
2014-11-03 19:00:00	QQQ	ETF	101.52	101.52	101.4	101.41	78650.0
2014-11-03 04:00:00	IWM	ETF	116.46	116.46	116.43	116.43	3800.0
2014-11-03 06:00:00	IWM	ETF	116.45	116.45	116.4	116.4	10010.0
2014-11-03 07:00:00	IWM	ETF	116.36	116.51	116.3	116.51	28300.0
2014-11-03 08:00:00	IWM	ETF	116.46	116.75	116.41	116.6	185740.0
2014-11-03 09:00:00	IWM	ETF	116.6	117.37	116.4	117.14	6380376.0
2014-11-03 10:00:00	IWM	ETF	117.16	117.24	116.49	116.87	5371195.0
2014-11-03 11:00:00	IWM	ETF	116.865	117.09	116.62	116.96	2870196.0
2014-11-03 12:00:00	IWM	ETF	116.96	117.11	116.65	117.04	1956510.0
2014-11-03 13:00:00	IWM	ETF	117.04	117.05	116.83	116.89	1794101.0
2014-11-03 14:00:00	IWM	ETF	116.885	116.92	116.15	116.175	4498105.0
2014-11-03 15:00:00	IWM	ETF	116.17	116.37	115.9	116.36	7406419.0
2014-11-03 16:00:00	IWM	ETF	116.37	116.46	115.99	116.15	2149435.0
2014-11-03 17:00:00	IWM	ETF	116.2	116.2	116.09	116.09	16761.0
2014-11-03 08:00:00	DIA	ETF	173.31	173.35	173.31	173.35	3231.0
2014-11-03 09:00:00	DIA	ETF	173.47	173.64	173.32	173.37	735522.0
2014-11-03 10:00:00	DIA	ETF	173.4	173.6	173.05	173.385	1213166.0
2014-11-03 11:00:00	DIA	ETF	173.38	173.42	173.14	173.32	398294.0
2014-11-03 12:00:00	DIA	ETF	173.33	173.66	173.2592	173.57	461416.0

> showing 50 of 7,439 rows — these rows as CSV

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