PREVIEW / etf_1hour / 2014-04-17

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-04-17.parquet
  size:    215 KB
  rows:    6,796

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-04-17 04:00:00	SPY	ETF	185.4	185.54	183.68	185.44	272390.0
2014-04-17 05:00:00	SPY	ETF	185.44	185.46	185.25	185.4	4886.0
2014-04-17 06:00:00	SPY	ETF	185.36	185.5	185.17	185.4	123503.0
2014-04-17 07:00:00	SPY	ETF	185.45	185.85	185.45	185.83	394602.0
2014-04-17 08:00:00	SPY	ETF	185.76	186.23	185.45	186.12	986826.0
2014-04-17 09:00:00	SPY	ETF	186.12	186.18	185.56	185.82	13394037.0
2014-04-17 10:00:00	SPY	ETF	185.82	186.4199	185.65	186.3	16970405.0
2014-04-17 11:00:00	SPY	ETF	186.31	186.45	185.96	186.13	11492521.0
2014-04-17 12:00:00	SPY	ETF	186.13	186.41	185.995	186.37	8997487.0
2014-04-17 13:00:00	SPY	ETF	186.38	186.86	186.34	186.76	8864406.0
2014-04-17 14:00:00	SPY	ETF	186.75	186.83	186.53	186.61	9774784.0
2014-04-17 15:00:00	SPY	ETF	186.615	186.91	186.36	186.39	20976319.0
2014-04-17 16:00:00	SPY	ETF	186.38	186.82	185.9	186.46	9845999.0
2014-04-17 17:00:00	SPY	ETF	186.46	186.46	186.25	186.37	2417592.0
2014-04-17 18:00:00	SPY	ETF	186.37	186.43	186.33	186.41	28844.0
2014-04-17 19:00:00	SPY	ETF	186.41	186.41	186.35	186.38	33528.0
2014-04-17 04:00:00	QQQ	ETF	85.61	85.61	85.54	85.56	6496.0
2014-04-17 05:00:00	QQQ	ETF	85.54	85.57	85.52	85.57	1400.0
2014-04-17 06:00:00	QQQ	ETF	85.52	85.52	85.44	85.49	26383.0
2014-04-17 07:00:00	QQQ	ETF	85.5	85.82	85.5	85.79	71850.0
2014-04-17 08:00:00	QQQ	ETF	85.59	85.99	85.59	85.89	371092.0
2014-04-17 09:00:00	QQQ	ETF	85.91	86.24	85.63	85.93	8242762.0
2014-04-17 10:00:00	QQQ	ETF	85.95	86.4	85.84	86.21	9322392.0
2014-04-17 11:00:00	QQQ	ETF	86.22	86.32	85.91	86.1	4853011.0
2014-04-17 12:00:00	QQQ	ETF	86.1	86.31	86.0	86.27	3519039.0
2014-04-17 13:00:00	QQQ	ETF	86.27	86.63	86.25	86.53	4170381.0
2014-04-17 14:00:00	QQQ	ETF	86.53	86.57	86.37	86.4303	3153184.0
2014-04-17 15:00:00	QQQ	ETF	86.43	86.56	86.2	86.2	6970895.0
2014-04-17 16:00:00	QQQ	ETF	86.2	86.3657	86.12	86.22	4055455.0
2014-04-17 17:00:00	QQQ	ETF	86.22	86.22	86.15	86.18	44080.0
2014-04-17 18:00:00	QQQ	ETF	86.19	86.22	86.19	86.22	3500.0
2014-04-17 19:00:00	QQQ	ETF	86.21	86.21	86.15	86.21	40035.0
2014-04-17 04:00:00	IWM	ETF	111.29	111.29	111.29	111.29	199.0
2014-04-17 07:00:00	IWM	ETF	111.84	112.04	111.78	112.02	98947.0
2014-04-17 08:00:00	IWM	ETF	111.91	112.26	111.91	112.13	239310.0
2014-04-17 09:00:00	IWM	ETF	112.14	112.43	111.72	112.03	5679421.0
2014-04-17 10:00:00	IWM	ETF	112.06	113.16	111.88	113.02	8085845.0
2014-04-17 11:00:00	IWM	ETF	113.03	113.1377	112.4	112.58	4648501.0
2014-04-17 12:00:00	IWM	ETF	112.58	112.82	112.42	112.75	3372873.0
2014-04-17 13:00:00	IWM	ETF	112.76	113.18	112.75	113.16	3993942.0
2014-04-17 14:00:00	IWM	ETF	113.1587	113.34	113.03	113.07	2814008.0
2014-04-17 15:00:00	IWM	ETF	113.07	113.41	112.87	112.87	7374063.0
2014-04-17 16:00:00	IWM	ETF	112.88	113.03	112.82	113.01	7903813.0
2014-04-17 17:00:00	IWM	ETF	113.01	113.03	112.95	113.02	96375.0
2014-04-17 18:00:00	IWM	ETF	113.0	113.0	113.0	113.0	600.0
2014-04-17 19:00:00	IWM	ETF	112.96	112.96	112.95	112.95	300.0
2014-04-17 08:00:00	DIA	ETF	163.74	164.09	163.54	163.86	40157.0
2014-04-17 09:00:00	DIA	ETF	163.83	163.9	163.3299	163.51	935226.0
2014-04-17 10:00:00	DIA	ETF	163.54	163.98	163.395	163.93	1224730.0
2014-04-17 11:00:00	DIA	ETF	163.93	164.02	163.575	163.67	669438.0

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

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