PREVIEW / etf_1hour / 2015-02-02

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-02-02.parquet
  size:    243 KB
  rows:    7,717

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
2015-02-02 04:00:00	SPY	ETF	199.56	199.7	199.56	199.7	5537.0
2015-02-02 05:00:00	SPY	ETF	199.45	199.67	199.35	199.55	38650.0
2015-02-02 06:00:00	SPY	ETF	199.55	200.23	199.55	199.96	88029.0
2015-02-02 07:00:00	SPY	ETF	199.98	200.09	199.7	199.72	378144.0
2015-02-02 08:00:00	SPY	ETF	199.74	200.04	199.45	199.57	658612.0
2015-02-02 09:00:00	SPY	ETF	199.55	200.26	198.92	198.95	17630148.0
2015-02-02 10:00:00	SPY	ETF	198.93	199.29	197.86	199.05	31093467.0
2015-02-02 11:00:00	SPY	ETF	199.05	200.88	199.02	200.3901	21028502.0
2015-02-02 12:00:00	SPY	ETF	200.4	200.5	199.34	199.3949	15897058.0
2015-02-02 13:00:00	SPY	ETF	199.4	200.02	198.86	198.9351	15004769.0
2015-02-02 14:00:00	SPY	ETF	198.93	200.14	198.87	199.605	13399535.0
2015-02-02 15:00:00	SPY	ETF	199.605	202.03	199.52	201.87	34066311.0
2015-02-02 16:00:00	SPY	ETF	201.88	202.32	199.052	202.0	9239481.0
2015-02-02 17:00:00	SPY	ETF	202.02	202.04	201.92	201.96	2248131.0
2015-02-02 18:00:00	SPY	ETF	201.95	202.11	201.92	201.93	103200.0
2015-02-02 19:00:00	SPY	ETF	201.94	201.94	201.63	201.65	285941.0
2015-02-02 04:00:00	QQQ	ETF	101.1	101.1	101.1	101.1	300.0
2015-02-02 05:00:00	QQQ	ETF	101.1	101.1	101.0	101.0	200.0
2015-02-02 06:00:00	QQQ	ETF	101.39	101.41	100.66	101.37	6300.0
2015-02-02 07:00:00	QQQ	ETF	101.33	101.35	101.15	101.15	165970.0
2015-02-02 08:00:00	QQQ	ETF	101.17	101.28	101.04	101.08	112154.0
2015-02-02 09:00:00	QQQ	ETF	101.08	101.5	100.26	100.27	5370953.0
2015-02-02 10:00:00	QQQ	ETF	100.25	100.7	99.75	100.5	8745546.0
2015-02-02 11:00:00	QQQ	ETF	100.5	101.63	100.48	101.38	6133874.0
2015-02-02 12:00:00	QQQ	ETF	101.39	101.45	100.79	100.83	3073275.0
2015-02-02 13:00:00	QQQ	ETF	100.8267	101.14	100.5	100.56	3291131.0
2015-02-02 14:00:00	QQQ	ETF	100.545	101.23	100.53	100.845	2873729.0
2015-02-02 15:00:00	QQQ	ETF	100.85	102.07	100.75	101.98	7412405.0
2015-02-02 16:00:00	QQQ	ETF	101.98	102.2	100.496	102.05	2432389.0
2015-02-02 17:00:00	QQQ	ETF	102.05	102.07	101.99	102.01	71743.0
2015-02-02 18:00:00	QQQ	ETF	102.05	102.1	102.05	102.1	11670.0
2015-02-02 19:00:00	QQQ	ETF	101.98	102.02	101.86	101.9	16950.0
2015-02-02 04:00:00	IWM	ETF	116.1	116.1	115.51	115.51	600.0
2015-02-02 05:00:00	IWM	ETF	115.7	115.7	115.7	115.7	100.0
2015-02-02 06:00:00	IWM	ETF	116.72	116.72	116.0	116.0	300.0
2015-02-02 07:00:00	IWM	ETF	116.02	116.02	115.81	115.81	6138.0
2015-02-02 08:00:00	IWM	ETF	115.73	115.95	115.66	115.69	112759.0
2015-02-02 09:00:00	IWM	ETF	115.72	116.4	115.11	115.11	4506209.0
2015-02-02 10:00:00	IWM	ETF	115.17	115.37	114.38	115.07	7775939.0
2015-02-02 11:00:00	IWM	ETF	115.07	116.36	114.99	115.92	5691621.0
2015-02-02 12:00:00	IWM	ETF	115.93	116.0	115.44	115.67	3384017.0
2015-02-02 13:00:00	IWM	ETF	115.66	115.7699	114.93	114.98	3248032.0
2015-02-02 14:00:00	IWM	ETF	114.98	115.71	114.955	115.49	2900390.0
2015-02-02 15:00:00	IWM	ETF	115.485	116.84	115.445	116.73	8043703.0
2015-02-02 16:00:00	IWM	ETF	116.73	116.95	115.8081	116.73	3070032.0
2015-02-02 17:00:00	IWM	ETF	116.74	116.75	116.67	116.67	8921.0
2015-02-02 18:00:00	IWM	ETF	116.69	116.69	116.69	116.69	100.0
2015-02-02 19:00:00	IWM	ETF	116.62	116.68	116.62	116.63	1950.0
2015-02-02 04:00:00	DIA	ETF	171.5	171.5	171.5	171.5	840.0
2015-02-02 06:00:00	DIA	ETF	171.8	172.09	171.8	172.09	1000.0

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

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