PREVIEW / etf_1hour / 2014-08-20

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-08-20.parquet
  size:    217 KB
  rows:    6,908

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-08-20 04:00:00	SPY	ETF	198.12	198.12	197.95	197.98	21009.0
2014-08-20 05:00:00	SPY	ETF	198.03	198.08	197.99	197.99	12113.0
2014-08-20 06:00:00	SPY	ETF	198.1	198.25	198.1	198.17	30604.0
2014-08-20 07:00:00	SPY	ETF	198.18	198.4	198.14	198.31	158879.0
2014-08-20 08:00:00	SPY	ETF	198.02	198.37	197.93	198.11	941935.0
2014-08-20 09:00:00	SPY	ETF	198.12	198.48	198.01	198.345	7655503.0
2014-08-20 10:00:00	SPY	ETF	198.35	198.63	198.28	198.575	8699724.0
2014-08-20 11:00:00	SPY	ETF	198.58	198.73	198.55	198.65	7445173.0
2014-08-20 12:00:00	SPY	ETF	198.65	198.67	198.59	198.65	2518917.0
2014-08-20 13:00:00	SPY	ETF	198.65	198.9	198.62	198.73	5898876.0
2014-08-20 14:00:00	SPY	ETF	198.725	198.96	198.21	198.92	18346462.0
2014-08-20 15:00:00	SPY	ETF	198.92	199.16	198.89	198.91	16336692.0
2014-08-20 16:00:00	SPY	ETF	198.91	198.93	198.38	198.89	3834050.0
2014-08-20 17:00:00	SPY	ETF	198.88	198.92	198.84	198.88	69826.0
2014-08-20 18:00:00	SPY	ETF	198.83	198.85	198.81	198.84	63591.0
2014-08-20 19:00:00	SPY	ETF	198.84	199.03	198.84	199.01	90791.0
2014-08-20 04:00:00	QQQ	ETF	98.49	98.49	98.47	98.47	8000.0
2014-08-20 06:00:00	QQQ	ETF	98.55	98.62	98.55	98.58	4200.0
2014-08-20 07:00:00	QQQ	ETF	98.61	98.7	98.61	98.67	43605.0
2014-08-20 08:00:00	QQQ	ETF	98.7	98.7	98.52	98.59	133086.0
2014-08-20 09:00:00	QQQ	ETF	98.59	98.72	98.56	98.66	3051347.0
2014-08-20 10:00:00	QQQ	ETF	98.66	98.77	98.54	98.721	3078837.0
2014-08-20 11:00:00	QQQ	ETF	98.73	98.815	98.68	98.79	1711592.0
2014-08-20 12:00:00	QQQ	ETF	98.795	98.815	98.74	98.765	1149447.0
2014-08-20 13:00:00	QQQ	ETF	98.765	98.8568	98.72	98.74	1503580.0
2014-08-20 14:00:00	QQQ	ETF	98.74	98.82	98.53	98.8	4705109.0
2014-08-20 15:00:00	QQQ	ETF	98.8	98.9	98.72	98.72	4346889.0
2014-08-20 16:00:00	QQQ	ETF	98.72	98.76	98.69	98.73	1641515.0
2014-08-20 17:00:00	QQQ	ETF	98.75	98.77	98.72	98.77	4738.0
2014-08-20 18:00:00	QQQ	ETF	98.72	98.73	98.72	98.73	9150.0
2014-08-20 19:00:00	QQQ	ETF	98.71	98.83	98.71	98.81	44648.0
2014-08-20 04:00:00	IWM	ETF	115.1	115.1	114.85	114.85	600.0
2014-08-20 06:00:00	IWM	ETF	114.83	114.83	114.83	114.83	5000.0
2014-08-20 07:00:00	IWM	ETF	115.21	115.22	115.11	115.15	17796.0
2014-08-20 08:00:00	IWM	ETF	115.0	115.0	114.62	114.73	322482.0
2014-08-20 09:00:00	IWM	ETF	114.72	114.95	114.49	114.8	5892930.0
2014-08-20 10:00:00	IWM	ETF	114.79	115.03	114.56	114.99	2946802.0
2014-08-20 11:00:00	IWM	ETF	115.0	115.1	114.91	114.93	1839047.0
2014-08-20 12:00:00	IWM	ETF	114.93	115.02	114.91	114.96	706796.0
2014-08-20 13:00:00	IWM	ETF	114.965	115.04	114.72	114.74	1532016.0
2014-08-20 14:00:00	IWM	ETF	114.75	115.07	114.41	114.99	5327388.0
2014-08-20 15:00:00	IWM	ETF	114.99	115.22	114.92	114.98	4813361.0
2014-08-20 16:00:00	IWM	ETF	114.98	115.09	114.6978	114.85	818706.0
2014-08-20 17:00:00	IWM	ETF	114.84	114.92	114.84	114.85	17257.0
2014-08-20 18:00:00	IWM	ETF	114.73	114.84	114.73	114.84	375.0
2014-08-20 19:00:00	IWM	ETF	114.85	114.94	114.85	114.9	10491.0
2014-08-20 08:00:00	DIA	ETF	168.55	168.65	168.55	168.64	3700.0
2014-08-20 09:00:00	DIA	ETF	168.72	169.02	168.72	168.945	384145.0
2014-08-20 10:00:00	DIA	ETF	168.96	169.25	168.91	169.23	294779.0
2014-08-20 11:00:00	DIA	ETF	169.23	169.36	169.19	169.28	224662.0

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

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