PREVIEW / etf_1hour / 2013-12-16

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-12-16.parquet
  size:    211 KB
  rows:    6,662

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
2013-12-16 04:00:00	SPY	ETF	178.01	178.36	178.01	178.3	33747.0
2013-12-16 05:00:00	SPY	ETF	178.27	178.86	178.23	178.81	99099.0
2013-12-16 06:00:00	SPY	ETF	178.8	179.04	178.75	178.83	137940.0
2013-12-16 07:00:00	SPY	ETF	178.82	179.16	178.8	179.05	438644.0
2013-12-16 08:00:00	SPY	ETF	179.07	179.13	177.04	179.01	820428.0
2013-12-16 09:00:00	SPY	ETF	179.01	179.77	178.9	179.71	16379468.0
2013-12-16 10:00:00	SPY	ETF	179.7	179.81	179.25	179.35	13265631.0
2013-12-16 11:00:00	SPY	ETF	179.35	179.45	179.155	179.4	8546659.0
2013-12-16 12:00:00	SPY	ETF	179.4	179.41	179.13	179.21	6261909.0
2013-12-16 13:00:00	SPY	ETF	179.21	179.42	178.97	179.37	7615418.0
2013-12-16 14:00:00	SPY	ETF	179.37	179.55	179.31	179.45	8281688.0
2013-12-16 15:00:00	SPY	ETF	179.44	179.48	179.2	179.2	16419979.0
2013-12-16 16:00:00	SPY	ETF	179.21	179.26	178.0955	179.12	8453336.0
2013-12-16 17:00:00	SPY	ETF	179.1	179.12	178.0956	179.05	2085676.0
2013-12-16 18:00:00	SPY	ETF	179.1	179.12	179.07	179.09	87412.0
2013-12-16 19:00:00	SPY	ETF	179.08	179.1	179.01	179.01	60434.0
2013-12-16 04:00:00	QQQ	ETF	84.9	85.06	84.9	85.05	14300.0
2013-12-16 05:00:00	QQQ	ETF	85.06	85.28	85.06	85.28	13140.0
2013-12-16 06:00:00	QQQ	ETF	85.26	85.32	85.24	85.26	9760.0
2013-12-16 07:00:00	QQQ	ETF	85.28	85.37	85.28	85.37	67726.0
2013-12-16 08:00:00	QQQ	ETF	85.3	85.34	85.24	85.32	295741.0
2013-12-16 09:00:00	QQQ	ETF	85.33	85.79	85.24	85.7608	4419649.0
2013-12-16 10:00:00	QQQ	ETF	85.77	85.81	85.49	85.52	2946952.0
2013-12-16 11:00:00	QQQ	ETF	85.52	85.57	85.39	85.48	1644593.0
2013-12-16 12:00:00	QQQ	ETF	85.489	85.495	85.34	85.39	1283860.0
2013-12-16 13:00:00	QQQ	ETF	85.39	85.43	85.21	85.41	1653055.0
2013-12-16 14:00:00	QQQ	ETF	85.4	85.48	85.37	85.4449	1811642.0
2013-12-16 15:00:00	QQQ	ETF	85.45	85.47	85.2701	85.33	6754635.0
2013-12-16 16:00:00	QQQ	ETF	85.32	85.764	85.26	85.27	3693567.0
2013-12-16 17:00:00	QQQ	ETF	84.85	85.28	84.85	85.28	5377.0
2013-12-16 18:00:00	QQQ	ETF	85.25	85.26	85.25	85.26	450.0
2013-12-16 19:00:00	QQQ	ETF	85.26	85.26	85.23	85.23	5200.0
2013-12-16 04:00:00	IWM	ETF	110.3	110.3	110.25	110.25	200.0
2013-12-16 05:00:00	IWM	ETF	110.57	110.64	110.57	110.64	250.0
2013-12-16 06:00:00	IWM	ETF	110.64	110.69	110.58	110.58	1000.0
2013-12-16 07:00:00	IWM	ETF	110.52	110.77	110.52	110.77	155400.0
2013-12-16 08:00:00	IWM	ETF	110.77	110.8	110.67	110.68	160496.0
2013-12-16 09:00:00	IWM	ETF	110.68	111.43	110.52	111.32	5667109.0
2013-12-16 10:00:00	IWM	ETF	111.32	111.365	110.95	111.08	4030181.0
2013-12-16 11:00:00	IWM	ETF	111.08	111.28	110.77	111.22	3150289.0
2013-12-16 12:00:00	IWM	ETF	111.22	111.31	111.12	111.23	1687433.0
2013-12-16 13:00:00	IWM	ETF	111.23	111.34	111.0	111.33	2500537.0
2013-12-16 14:00:00	IWM	ETF	111.32	111.57	111.32	111.5	2885961.0
2013-12-16 15:00:00	IWM	ETF	111.495	111.52	111.29	111.49	6704895.0
2013-12-16 16:00:00	IWM	ETF	111.48	111.51	111.31	111.37	1054834.0
2013-12-16 17:00:00	IWM	ETF	111.37	111.45	111.37	111.41	14661.0
2013-12-16 18:00:00	IWM	ETF	111.43	111.48	111.43	111.47	8560.0
2013-12-16 19:00:00	IWM	ETF	111.48	111.48	111.47	111.48	1370.0
2013-12-16 07:00:00	DIA	ETF	158.42	158.5	158.42	158.5	1500.0
2013-12-16 08:00:00	DIA	ETF	158.4	158.54	158.4	158.45	4640.0

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

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