PREVIEW / etf_1hour / 2014-10-24

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-10-24.parquet
  size:    226 KB
  rows:    7,206

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-10-24 04:00:00	SPY	ETF	194.84	195.07	194.72	194.84	70445.0
2014-10-24 05:00:00	SPY	ETF	194.8	194.82	194.61	194.68	44631.0
2014-10-24 06:00:00	SPY	ETF	194.7	194.73	194.39	194.52	75270.0
2014-10-24 07:00:00	SPY	ETF	194.54	194.71	194.32	194.48	518841.0
2014-10-24 08:00:00	SPY	ETF	193.8318	195.06	192.62	194.88	2605170.0
2014-10-24 09:00:00	SPY	ETF	194.89	195.82	194.88	195.0854	17151089.0
2014-10-24 10:00:00	SPY	ETF	195.1	195.6	194.49	195.55	21108206.0
2014-10-24 11:00:00	SPY	ETF	195.56	196.14	195.35	195.9499	12763502.0
2014-10-24 12:00:00	SPY	ETF	195.94	196.26	195.59	195.71	9595867.0
2014-10-24 13:00:00	SPY	ETF	195.72	195.97	195.39	195.88	8582802.0
2014-10-24 14:00:00	SPY	ETF	195.88	196.21	195.8	196.09	9658628.0
2014-10-24 15:00:00	SPY	ETF	196.08	196.49	195.93	196.38	21936470.0
2014-10-24 16:00:00	SPY	ETF	196.38	196.61	196.38	196.6	8975197.0
2014-10-24 17:00:00	SPY	ETF	196.6	196.67	196.43	196.51	401200.0
2014-10-24 18:00:00	SPY	ETF	196.5	196.52	196.43	196.43	703277.0
2014-10-24 19:00:00	SPY	ETF	196.49	196.6	196.45	196.6	37106.0
2014-10-24 04:00:00	QQQ	ETF	97.7	97.79	97.61	97.61	400.0
2014-10-24 05:00:00	QQQ	ETF	97.61	97.64	97.57	97.57	12150.0
2014-10-24 06:00:00	QQQ	ETF	97.6	97.6	97.45	97.49	37700.0
2014-10-24 07:00:00	QQQ	ETF	97.56	97.61	97.45	97.52	30639.0
2014-10-24 08:00:00	QQQ	ETF	97.57	97.81	97.45	97.81	291704.0
2014-10-24 09:00:00	QQQ	ETF	97.81	98.27	97.77	97.93	7050130.0
2014-10-24 10:00:00	QQQ	ETF	97.93	98.25	97.64	98.22	5948184.0
2014-10-24 11:00:00	QQQ	ETF	98.22	98.38	98.07	98.3	3728629.0
2014-10-24 12:00:00	QQQ	ETF	98.3	98.4	98.09	98.13	2632292.0
2014-10-24 13:00:00	QQQ	ETF	98.14	98.35	97.96	98.3	2507770.0
2014-10-24 14:00:00	QQQ	ETF	98.3	98.4	98.26	98.3201	2243913.0
2014-10-24 15:00:00	QQQ	ETF	98.32	98.69	98.28	98.57	12783443.0
2014-10-24 16:00:00	QQQ	ETF	98.57	98.71	98.144	98.66	2220748.0
2014-10-24 17:00:00	QQQ	ETF	98.67	98.77	98.67	98.67	16386.0
2014-10-24 18:00:00	QQQ	ETF	98.67	98.67	98.62	98.66	2839.0
2014-10-24 19:00:00	QQQ	ETF	98.69	98.69	98.64	98.65	3571.0
2014-10-24 06:00:00	IWM	ETF	110.5	110.5	110.42	110.42	300.0
2014-10-24 07:00:00	IWM	ETF	110.42	110.53	110.37	110.48	48800.0
2014-10-24 08:00:00	IWM	ETF	110.53	110.76	110.36	110.71	319354.0
2014-10-24 09:00:00	IWM	ETF	110.72	111.32	110.66	110.82	4718991.0
2014-10-24 10:00:00	IWM	ETF	110.82	111.1095	110.44	110.76	6957532.0
2014-10-24 11:00:00	IWM	ETF	110.78	110.86	110.46	110.77	7524036.0
2014-10-24 12:00:00	IWM	ETF	110.77	111.13	110.65	110.715	3310395.0
2014-10-24 13:00:00	IWM	ETF	110.72	111.01	110.65	110.93	2003871.0
2014-10-24 14:00:00	IWM	ETF	110.93	110.9899	110.82	110.88	1821168.0
2014-10-24 15:00:00	IWM	ETF	110.88	111.195	110.85	111.07	5488694.0
2014-10-24 16:00:00	IWM	ETF	111.06	111.28	110.93	111.23	1027259.0
2014-10-24 17:00:00	IWM	ETF	111.21	111.25	111.11	111.2	36659.0
2014-10-24 18:00:00	IWM	ETF	111.11	111.11	111.11	111.11	100.0
2014-10-24 19:00:00	IWM	ETF	111.11	111.11	111.11	111.11	100.0
2014-10-24 08:00:00	DIA	ETF	166.0	166.47	166.0	166.45	9634.0
2014-10-24 09:00:00	DIA	ETF	166.46	167.13	166.4	166.64	910885.0
2014-10-24 10:00:00	DIA	ETF	166.65	166.99	166.17	166.97	1146357.0
2014-10-24 11:00:00	DIA	ETF	166.95	167.46	166.77	167.33	875551.0

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

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