PREVIEW / etf_1hour / 2014-04-28

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-04-28.parquet
  size:    218 KB
  rows:    6,934

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-28 04:00:00	SPY	ETF	186.94	187.32	186.66	187.3	7583.0
2014-04-28 05:00:00	SPY	ETF	187.26	187.3	187.09	187.21	18143.0
2014-04-28 06:00:00	SPY	ETF	187.24	187.26	186.97	187.04	7090.0
2014-04-28 07:00:00	SPY	ETF	187.05	187.28	187.05	187.26	334481.0
2014-04-28 08:00:00	SPY	ETF	187.26	187.27	186.845	186.85	1105344.0
2014-04-28 09:00:00	SPY	ETF	186.85	187.23	186.4	186.95	14900823.0
2014-04-28 10:00:00	SPY	ETF	186.96	187.69	186.84	187.2	15329235.0
2014-04-28 11:00:00	SPY	ETF	187.2	187.39	186.14	186.18	14789622.0
2014-04-28 12:00:00	SPY	ETF	186.18	186.49	186.08	186.2	10685029.0
2014-04-28 13:00:00	SPY	ETF	186.195	186.195	184.96	185.43	20916694.0
2014-04-28 14:00:00	SPY	ETF	185.42	186.28	185.15	186.04	14604452.0
2014-04-28 15:00:00	SPY	ETF	186.03	187.28	186.01	186.9	31415453.0
2014-04-28 16:00:00	SPY	ETF	186.91	187.17	186.2921	187.14	6764381.0
2014-04-28 17:00:00	SPY	ETF	187.14	187.2	187.12	187.12	36329.0
2014-04-28 18:00:00	SPY	ETF	187.12	187.37	187.06	187.3	130784.0
2014-04-28 19:00:00	SPY	ETF	187.28	187.32	187.23	187.24	55503.0
2014-04-28 04:00:00	QQQ	ETF	86.69	86.69	86.69	86.69	100.0
2014-04-28 06:00:00	QQQ	ETF	86.62	86.62	86.54	86.54	51000.0
2014-04-28 07:00:00	QQQ	ETF	86.64	86.72	86.64	86.68	32815.0
2014-04-28 08:00:00	QQQ	ETF	86.68	86.68	86.4	86.41	116182.0
2014-04-28 09:00:00	QQQ	ETF	86.41	86.69	86.09	86.6	7267489.0
2014-04-28 10:00:00	QQQ	ETF	86.62	87.11	86.49	86.73	7617285.0
2014-04-28 11:00:00	QQQ	ETF	86.735	86.8744	85.83	85.9	6853289.0
2014-04-28 12:00:00	QQQ	ETF	85.89	86.03	85.685	85.8	6035460.0
2014-04-28 13:00:00	QQQ	ETF	85.79	85.79	85.11	85.49	8759348.0
2014-04-28 14:00:00	QQQ	ETF	85.48	86.07	85.31	85.92	6510358.0
2014-04-28 15:00:00	QQQ	ETF	85.92	86.69	85.88	86.49	11340641.0
2014-04-28 16:00:00	QQQ	ETF	86.49	86.6	86.1363	86.47	1879618.0
2014-04-28 17:00:00	QQQ	ETF	86.58	86.65	86.58	86.6	25958.0
2014-04-28 18:00:00	QQQ	ETF	86.61	86.74	86.58	86.71	45866.0
2014-04-28 19:00:00	QQQ	ETF	86.71	86.75	86.68	86.7	29200.0
2014-04-28 06:00:00	IWM	ETF	112.0	112.0	112.0	112.0	2300.0
2014-04-28 07:00:00	IWM	ETF	112.0	112.2	112.0	112.2	149093.0
2014-04-28 08:00:00	IWM	ETF	112.2	112.21	111.63	111.88	299793.0
2014-04-28 09:00:00	IWM	ETF	111.86	112.1	111.09	111.82	6080944.0
2014-04-28 10:00:00	IWM	ETF	111.83	112.54	111.57	111.68	6861717.0
2014-04-28 11:00:00	IWM	ETF	111.6701	111.88	110.26	110.32	8594796.0
2014-04-28 12:00:00	IWM	ETF	110.32	110.5	109.98	110.16	5349158.0
2014-04-28 13:00:00	IWM	ETF	110.16	110.17	109.32	109.73	9674885.0
2014-04-28 14:00:00	IWM	ETF	109.73	110.7001	109.55	110.3299	7663366.0
2014-04-28 15:00:00	IWM	ETF	110.325	111.5	110.25	110.98	10825823.0
2014-04-28 16:00:00	IWM	ETF	110.97	111.5254	110.94	111.11	3046960.0
2014-04-28 17:00:00	IWM	ETF	110.96	111.16	110.96	111.07	651709.0
2014-04-28 18:00:00	IWM	ETF	111.14	111.14	111.14	111.14	2499.0
2014-04-28 19:00:00	IWM	ETF	111.18	111.18	111.18	111.18	200.0
2014-04-28 07:00:00	DIA	ETF	164.19	164.21	164.19	164.21	300.0
2014-04-28 08:00:00	DIA	ETF	164.02	164.25	163.98	163.98	2925.0
2014-04-28 09:00:00	DIA	ETF	163.96	164.47	163.89	164.17	808380.0
2014-04-28 10:00:00	DIA	ETF	164.19	164.69	164.1	164.43	753006.0
2014-04-28 11:00:00	DIA	ETF	164.41	164.53	163.64	163.66	823036.0

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

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