PREVIEW / etf_1hour / 2016-04-27

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-04-27.parquet
  size:    251 KB
  rows:    8,014

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
2016-04-27 04:00:00	SPY	ETF	208.84	208.94	208.57	208.94	42988.0
2016-04-27 05:00:00	SPY	ETF	208.85	208.85	208.7	208.7	77427.0
2016-04-27 06:00:00	SPY	ETF	208.7	208.78	208.6	208.66	37013.0
2016-04-27 07:00:00	SPY	ETF	208.71	208.84	208.64	208.73	186687.0
2016-04-27 08:00:00	SPY	ETF	208.72	208.86	208.65	208.66	257983.0
2016-04-27 09:00:00	SPY	ETF	208.65	209.08	208.38	208.76	7192874.0
2016-04-27 10:00:00	SPY	ETF	208.76	208.92	208.05	208.16	10571553.0
2016-04-27 11:00:00	SPY	ETF	208.18	208.8795	208.085	208.87	5187504.0
2016-04-27 12:00:00	SPY	ETF	208.86	209.0	208.65	208.7712	4039030.0
2016-04-27 13:00:00	SPY	ETF	208.78	208.81	208.49	208.538	4871605.0
2016-04-27 14:00:00	SPY	ETF	208.54	209.42	208.2	209.09	17264506.0
2016-04-27 15:00:00	SPY	ETF	209.08	209.81	209.05	209.34	20318165.0
2016-04-27 16:00:00	SPY	ETF	209.36	209.69	208.9809	209.69	6113394.0
2016-04-27 17:00:00	SPY	ETF	209.69	209.69	209.35	209.61	260128.0
2016-04-27 18:00:00	SPY	ETF	209.64	209.7	209.55	209.67	47454.0
2016-04-27 19:00:00	SPY	ETF	209.7	209.73	209.6	209.67	46218.0
2016-04-27 04:00:00	QQQ	ETF	107.49	107.51	107.49	107.5	1200.0
2016-04-27 05:00:00	QQQ	ETF	107.56	107.56	107.43	107.44	1431.0
2016-04-27 06:00:00	QQQ	ETF	107.42	107.43	107.37	107.39	1337.0
2016-04-27 07:00:00	QQQ	ETF	107.43	107.5	107.37	107.37	76550.0
2016-04-27 08:00:00	QQQ	ETF	107.47	107.52	107.4	107.47	114735.0
2016-04-27 09:00:00	QQQ	ETF	107.47	107.8	107.15	107.2001	4420855.0
2016-04-27 10:00:00	QQQ	ETF	107.2	107.3	106.69	106.92	4798174.0
2016-04-27 11:00:00	QQQ	ETF	106.925	107.39	106.8701	107.341	2658455.0
2016-04-27 12:00:00	QQQ	ETF	107.35	107.37	107.15	107.22	1355754.0
2016-04-27 13:00:00	QQQ	ETF	107.22	107.2375	106.9229	106.98	2535602.0
2016-04-27 14:00:00	QQQ	ETF	107.01	107.4	106.78	107.19	4711623.0
2016-04-27 15:00:00	QQQ	ETF	107.19	107.83	107.18	107.59	5931142.0
2016-04-27 16:00:00	QQQ	ETF	107.6	108.4617	107.49	108.18	2664192.0
2016-04-27 17:00:00	QQQ	ETF	108.19	108.23	108.07	108.15	27890.0
2016-04-27 18:00:00	QQQ	ETF	108.12	108.17	108.08	108.17	24481.0
2016-04-27 19:00:00	QQQ	ETF	108.18	108.21	108.16	108.21	16258.0
2016-04-27 04:00:00	IWM	ETF	114.4	114.44	114.4	114.44	600.0
2016-04-27 05:00:00	IWM	ETF	114.38	114.41	114.38	114.41	500.0
2016-04-27 06:00:00	IWM	ETF	114.48	114.48	114.48	114.48	100.0
2016-04-27 07:00:00	IWM	ETF	114.45	114.54	114.43	114.5	15200.0
2016-04-27 08:00:00	IWM	ETF	114.5	114.58	114.48	114.52	85687.0
2016-04-27 09:00:00	IWM	ETF	114.48	114.85	114.42	114.65	2139551.0
2016-04-27 10:00:00	IWM	ETF	114.65	114.83	113.9	114.08	3162623.0
2016-04-27 11:00:00	IWM	ETF	114.09	114.61	114.0	114.555	1945852.0
2016-04-27 12:00:00	IWM	ETF	114.56	114.57	114.195	114.2525	1328772.0
2016-04-27 13:00:00	IWM	ETF	114.26	114.425	114.12	114.33	1269237.0
2016-04-27 14:00:00	IWM	ETF	114.33	114.8	114.0	114.44	4323618.0
2016-04-27 15:00:00	IWM	ETF	114.44	115.05	114.41	114.82	4933539.0
2016-04-27 16:00:00	IWM	ETF	114.82	115.03	114.6099	115.01	2609275.0
2016-04-27 17:00:00	IWM	ETF	115.0	115.01	115.0	115.01	1497.0
2016-04-27 18:00:00	IWM	ETF	115.0	115.0	115.0	115.0	2100.0
2016-04-27 19:00:00	IWM	ETF	114.99	115.0	114.97	115.0	1400.0
2016-04-27 06:00:00	DIA	ETF	179.32	179.38	179.26	179.26	500.0
2016-04-27 07:00:00	DIA	ETF	179.4	179.4	179.35	179.35	7600.0

> showing 50 of 8,014 rows — these rows as CSV

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