PREVIEW / etf_1hour / 2015-03-12

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-03-12.parquet
  size:    238 KB
  rows:    7,537

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-03-12 04:00:00	SPY	ETF	204.65	205.35	204.65	205.25	3360.0
2015-03-12 05:00:00	SPY	ETF	205.33	205.33	204.9	204.9	4260.0
2015-03-12 06:00:00	SPY	ETF	204.92	205.29	204.92	205.24	33630.0
2015-03-12 07:00:00	SPY	ETF	205.11	205.19	204.83	205.19	190123.0
2015-03-12 08:00:00	SPY	ETF	205.16	205.61	204.93	205.6	1383145.0
2015-03-12 09:00:00	SPY	ETF	205.6	206.43	205.18	206.17	18318750.0
2015-03-12 10:00:00	SPY	ETF	206.18	206.37	205.93	206.26	14253049.0
2015-03-12 11:00:00	SPY	ETF	206.26	206.7	206.13	206.46	9930347.0
2015-03-12 12:00:00	SPY	ETF	206.47	206.51	206.21	206.42	5965442.0
2015-03-12 13:00:00	SPY	ETF	206.42	206.69	206.34	206.59	5666750.0
2015-03-12 14:00:00	SPY	ETF	206.59	206.88	206.42	206.84	7075374.0
2015-03-12 15:00:00	SPY	ETF	206.845	207.175	206.845	207.11	22036835.0
2015-03-12 16:00:00	SPY	ETF	207.1	207.13	205.8272	207.06	7297471.0
2015-03-12 17:00:00	SPY	ETF	207.04	207.1	206.93	206.96	791260.0
2015-03-12 18:00:00	SPY	ETF	206.98	207.09	206.95	207.09	66268.0
2015-03-12 19:00:00	SPY	ETF	207.09	207.18	207.07	207.18	94041.0
2015-03-12 04:00:00	QQQ	ETF	105.47	105.47	105.47	105.47	100.0
2015-03-12 06:00:00	QQQ	ETF	105.39	105.46	105.39	105.44	10500.0
2015-03-12 07:00:00	QQQ	ETF	105.44	105.49	105.35	105.49	34610.0
2015-03-12 08:00:00	QQQ	ETF	105.39	105.52	105.31	105.52	279587.0
2015-03-12 09:00:00	QQQ	ETF	105.51	105.7195	104.93	105.535	5986908.0
2015-03-12 10:00:00	QQQ	ETF	105.535	105.66	105.36	105.53	3022998.0
2015-03-12 11:00:00	QQQ	ETF	105.515	105.8	105.45	105.6	1895827.0
2015-03-12 12:00:00	QQQ	ETF	105.6	105.66	105.5	105.6	870458.0
2015-03-12 13:00:00	QQQ	ETF	105.595	105.78	105.55	105.73	1364095.0
2015-03-12 14:00:00	QQQ	ETF	105.735	105.75	105.5	105.72	1918829.0
2015-03-12 15:00:00	QQQ	ETF	105.72	105.92	105.71	105.81	5048992.0
2015-03-12 16:00:00	QQQ	ETF	105.81	105.8753	105.72	105.75	467871.0
2015-03-12 17:00:00	QQQ	ETF	105.78	105.78	105.73	105.75	15502.0
2015-03-12 18:00:00	QQQ	ETF	105.74	105.83	105.74	105.81	16444.0
2015-03-12 19:00:00	QQQ	ETF	105.8	105.84	105.8	105.84	24935.0
2015-03-12 04:00:00	IWM	ETF	121.2	121.68	121.2	121.6	485.0
2015-03-12 06:00:00	IWM	ETF	121.6	121.66	121.6	121.66	30000.0
2015-03-12 07:00:00	IWM	ETF	121.65	121.8	121.62	121.8	83247.0
2015-03-12 08:00:00	IWM	ETF	121.85	122.09	121.67	122.09	332094.0
2015-03-12 09:00:00	IWM	ETF	122.1	122.76	121.74	122.3	5283645.0
2015-03-12 10:00:00	IWM	ETF	122.3	122.51	121.75	122.03	4102028.0
2015-03-12 11:00:00	IWM	ETF	122.015	122.45	121.99	122.28	3154198.0
2015-03-12 12:00:00	IWM	ETF	122.285	122.46	122.2	122.41	1407214.0
2015-03-12 13:00:00	IWM	ETF	122.41	122.63	122.359	122.61	1839546.0
2015-03-12 14:00:00	IWM	ETF	122.61	122.76	122.47	122.72	2099171.0
2015-03-12 15:00:00	IWM	ETF	122.73	123.15	122.725	123.02	6527921.0
2015-03-12 16:00:00	IWM	ETF	123.01	123.23	120.9804	123.21	3823420.0
2015-03-12 17:00:00	IWM	ETF	123.21	123.25	123.05	123.25	384728.0
2015-03-12 18:00:00	IWM	ETF	123.23	123.23	123.2	123.23	2321.0
2015-03-12 19:00:00	IWM	ETF	123.23	123.23	123.18	123.23	7300.0
2015-03-12 08:00:00	DIA	ETF	176.78	177.49	176.78	177.45	5044.0
2015-03-12 09:00:00	DIA	ETF	177.21	178.32	177.2	178.12	916791.0
2015-03-12 10:00:00	DIA	ETF	178.1	178.2	177.83	178.1349	630951.0
2015-03-12 11:00:00	DIA	ETF	178.11	178.47	178.04	178.28	378722.0

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

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