PREVIEW / etf_1hour / 2014-01-29

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-01-29.parquet
  size:    224 KB
  rows:    7,013

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-01-29 04:00:00	SPY	ETF	180.05	180.05	179.43	179.72	154590.0
2014-01-29 05:00:00	SPY	ETF	179.7	179.7	179.26	179.4	61359.0
2014-01-29 06:00:00	SPY	ETF	179.35	179.35	178.82	179.11	599945.0
2014-01-29 07:00:00	SPY	ETF	179.19	179.47	178.36	178.69	2356247.0
2014-01-29 08:00:00	SPY	ETF	178.7	179.39	177.67	177.96	7004977.0
2014-01-29 09:00:00	SPY	ETF	177.98	178.21	177.27	177.9691	30614088.0
2014-01-29 10:00:00	SPY	ETF	177.96	178.38	177.57	178.085	27923937.0
2014-01-29 11:00:00	SPY	ETF	178.09	178.55	178.09	178.49	15835306.0
2014-01-29 12:00:00	SPY	ETF	178.49	178.54	177.79	178.04	13328227.0
2014-01-29 13:00:00	SPY	ETF	178.04	178.07	177.67	178.01	12574080.0
2014-01-29 14:00:00	SPY	ETF	178.01	178.43	176.88	177.27	45587271.0
2014-01-29 15:00:00	SPY	ETF	177.27	177.71	176.93	177.32	41186394.0
2014-01-29 16:00:00	SPY	ETF	177.3	179.1369	177.27	177.44	14034876.0
2014-01-29 17:00:00	SPY	ETF	177.43	177.63	177.4	177.53	2460275.0
2014-01-29 18:00:00	SPY	ETF	177.51	178.05	177.49	177.99	726539.0
2014-01-29 19:00:00	SPY	ETF	177.95	177.96	177.69	177.89	626206.0
2014-01-29 04:00:00	QQQ	ETF	86.39	86.39	86.15	86.18	4100.0
2014-01-29 06:00:00	QQQ	ETF	86.01	86.06	85.82	85.98	20920.0
2014-01-29 07:00:00	QQQ	ETF	86.0	86.1	85.45	85.62	156189.0
2014-01-29 08:00:00	QQQ	ETF	85.61	86.07	85.07	85.24	606855.0
2014-01-29 09:00:00	QQQ	ETF	85.24	85.48	84.87	85.36	7725353.0
2014-01-29 10:00:00	QQQ	ETF	85.3599	85.5	85.06	85.3	5101359.0
2014-01-29 11:00:00	QQQ	ETF	85.3	85.68	85.3	85.68	4113360.0
2014-01-29 12:00:00	QQQ	ETF	85.675	85.74	85.241	85.371	3039909.0
2014-01-29 13:00:00	QQQ	ETF	85.355	85.4	85.22	85.34	2772400.0
2014-01-29 14:00:00	QQQ	ETF	85.31	85.53	84.78	84.9	12114062.0
2014-01-29 15:00:00	QQQ	ETF	84.89	85.1	84.76	84.94	9677980.0
2014-01-29 16:00:00	QQQ	ETF	84.92	85.36	84.9198	85.28	4424382.0
2014-01-29 17:00:00	QQQ	ETF	85.84	85.84	85.22	85.35	75622.0
2014-01-29 18:00:00	QQQ	ETF	85.35	85.6	85.26	85.6	86767.0
2014-01-29 19:00:00	QQQ	ETF	85.58	85.58	85.39	85.45	19900.0
2014-01-29 06:00:00	IWM	ETF	113.0	113.15	112.96	113.12	1611.0
2014-01-29 07:00:00	IWM	ETF	113.08	113.24	112.64	112.82	337327.0
2014-01-29 08:00:00	IWM	ETF	112.86	112.96	111.94	112.12	520489.0
2014-01-29 09:00:00	IWM	ETF	112.13	112.41	111.66	112.19	7819877.0
2014-01-29 10:00:00	IWM	ETF	112.19	112.4899	111.87	112.2	6501403.0
2014-01-29 11:00:00	IWM	ETF	112.21	112.58	112.13	112.4799	4613365.0
2014-01-29 12:00:00	IWM	ETF	112.48	112.54	111.58	111.89	5084905.0
2014-01-29 13:00:00	IWM	ETF	111.88	111.89	111.45	111.7	4298495.0
2014-01-29 14:00:00	IWM	ETF	111.71	112.0536	111.12	111.4	11183741.0
2014-01-29 15:00:00	IWM	ETF	111.38	111.54	111.02	111.37	11303049.0
2014-01-29 16:00:00	IWM	ETF	111.36	112.9649	111.2	111.35	5930191.0
2014-01-29 17:00:00	IWM	ETF	111.32	111.5	111.31	111.45	33702.0
2014-01-29 18:00:00	IWM	ETF	111.5	111.74	111.5	111.74	16240.0
2014-01-29 19:00:00	IWM	ETF	111.65	111.69	111.6	111.69	5400.0
2014-01-29 07:00:00	DIA	ETF	159.0	159.0	158.4	158.4	6360.0
2014-01-29 08:00:00	DIA	ETF	158.73	158.76	157.75	157.93	36122.0
2014-01-29 09:00:00	DIA	ETF	157.9	158.03	157.21	157.84	1651863.0
2014-01-29 10:00:00	DIA	ETF	157.85	158.17	157.43	157.83	2018190.0
2014-01-29 11:00:00	DIA	ETF	157.84	158.2484	157.8378	158.11	876847.0

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

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