PREVIEW / etf_1hour / 2014-10-06

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-10-06.parquet
  size:    225 KB
  rows:    7,127

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-06 04:00:00	SPY	ETF	197.08	197.45	197.08	197.31	16708.0
2014-10-06 05:00:00	SPY	ETF	197.2	197.27	196.96	197.02	23309.0
2014-10-06 06:00:00	SPY	ETF	197.06	197.23	197.03	197.17	83033.0
2014-10-06 07:00:00	SPY	ETF	197.18	197.33	197.06	197.07	320850.0
2014-10-06 08:00:00	SPY	ETF	197.15	197.46	197.08	197.29	650702.0
2014-10-06 09:00:00	SPY	ETF	197.3	197.6	197.23	197.3	12368850.0
2014-10-06 10:00:00	SPY	ETF	197.3	197.48	196.45	196.59	17025339.0
2014-10-06 11:00:00	SPY	ETF	196.59	196.88	195.76	196.01	16366612.0
2014-10-06 12:00:00	SPY	ETF	196.01	196.35	195.582	195.76	13239390.0
2014-10-06 13:00:00	SPY	ETF	195.76	196.49	195.6	196.36	13217271.0
2014-10-06 14:00:00	SPY	ETF	196.364	196.73	196.06	196.45	9781217.0
2014-10-06 15:00:00	SPY	ETF	196.45	196.64	196.115	196.26	15300888.0
2014-10-06 16:00:00	SPY	ETF	196.26	197.1	195.82	195.98	5504248.0
2014-10-06 17:00:00	SPY	ETF	195.95	195.95	195.9	195.9	31279.0
2014-10-06 18:00:00	SPY	ETF	195.92	195.98	195.9	195.95	24858.0
2014-10-06 19:00:00	SPY	ETF	195.93	195.98	195.9	195.95	21178.0
2014-10-06 04:00:00	QQQ	ETF	98.53	98.59	98.51	98.51	31000.0
2014-10-06 05:00:00	QQQ	ETF	98.4	98.4	98.35	98.35	1821.0
2014-10-06 06:00:00	QQQ	ETF	98.43	98.49	98.4	98.44	6300.0
2014-10-06 07:00:00	QQQ	ETF	98.48	98.53	98.38	98.41	62900.0
2014-10-06 08:00:00	QQQ	ETF	98.42	98.55	98.37	98.42	217684.0
2014-10-06 09:00:00	QQQ	ETF	98.44	98.72	98.41	98.55	5144091.0
2014-10-06 10:00:00	QQQ	ETF	98.56	98.6701	98.01	98.14	5564738.0
2014-10-06 11:00:00	QQQ	ETF	98.14	98.2699	97.67	97.86	4345443.0
2014-10-06 12:00:00	QQQ	ETF	97.85	98.07	97.6587	97.777	3165017.0
2014-10-06 13:00:00	QQQ	ETF	97.77	98.12	97.68	98.005	3371653.0
2014-10-06 14:00:00	QQQ	ETF	98.01	98.22	97.8601	98.07	2778948.0
2014-10-06 15:00:00	QQQ	ETF	98.06	98.144	97.85	97.98	5153972.0
2014-10-06 16:00:00	QQQ	ETF	97.97	98.3183	97.73	97.84	705962.0
2014-10-06 17:00:00	QQQ	ETF	97.83	97.96	97.8	97.84	3408402.0
2014-10-06 18:00:00	QQQ	ETF	97.8	97.96	97.8	97.82	13267.0
2014-10-06 19:00:00	QQQ	ETF	97.84	97.84	97.77	97.83	7300.0
2014-10-06 06:00:00	IWM	ETF	110.0	110.0	110.0	110.0	10000.0
2014-10-06 07:00:00	IWM	ETF	110.05	110.12	109.95	109.95	85150.0
2014-10-06 08:00:00	IWM	ETF	109.95	110.09	109.86	109.9	243505.0
2014-10-06 09:00:00	IWM	ETF	109.92	110.07	109.66	109.71	4138533.0
2014-10-06 10:00:00	IWM	ETF	109.71	109.87	108.96	109.09	8696618.0
2014-10-06 11:00:00	IWM	ETF	109.08	109.26	108.51	108.84	5047836.0
2014-10-06 12:00:00	IWM	ETF	108.84	109.19	108.69	108.815	3275948.0
2014-10-06 13:00:00	IWM	ETF	108.81	109.3901	108.71	109.27	2799547.0
2014-10-06 14:00:00	IWM	ETF	109.26	109.49	108.97	109.31	2592828.0
2014-10-06 15:00:00	IWM	ETF	109.31	109.33	108.66	108.73	4857763.0
2014-10-06 16:00:00	IWM	ETF	108.73	108.79	108.42	108.48	1562449.0
2014-10-06 17:00:00	IWM	ETF	108.51	108.54	108.47	108.5	5206.0
2014-10-06 18:00:00	IWM	ETF	108.55	108.55	108.55	108.55	250.0
2014-10-06 19:00:00	IWM	ETF	108.67	108.75	108.6	108.75	1915.0
2014-10-06 08:00:00	DIA	ETF	170.2	170.51	170.2	170.37	11750.0
2014-10-06 09:00:00	DIA	ETF	170.47	170.69	170.37	170.45	888293.0
2014-10-06 10:00:00	DIA	ETF	170.45	170.58	169.78	169.92	913272.0
2014-10-06 11:00:00	DIA	ETF	169.92	170.17	169.25	169.42	792670.0

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

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