PREVIEW / etf_1hour / 2016-05-03

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-05-03.parquet
  size:    254 KB
  rows:    8,142

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-05-03 04:00:00	SPY	ETF	207.65	207.65	206.52	206.58	21534.0
2016-05-03 05:00:00	SPY	ETF	206.64	206.78	206.5	206.56	253820.0
2016-05-03 06:00:00	SPY	ETF	206.54	206.63	206.24	206.32	222095.0
2016-05-03 07:00:00	SPY	ETF	206.33	206.65	206.23	206.55	1235197.0
2016-05-03 08:00:00	SPY	ETF	206.55	207.701	206.27	206.66	632106.0
2016-05-03 09:00:00	SPY	ETF	206.67	206.72	205.86	206.1	16088819.0
2016-05-03 10:00:00	SPY	ETF	206.1	206.11	205.46	205.57	17231838.0
2016-05-03 11:00:00	SPY	ETF	205.57	205.97	205.28	205.82	13355818.0
2016-05-03 12:00:00	SPY	ETF	205.825	206.2	205.59	206.15	8793347.0
2016-05-03 13:00:00	SPY	ETF	206.14	206.8	206.06	206.44	12491296.0
2016-05-03 14:00:00	SPY	ETF	206.44	206.54	206.05	206.32	8636749.0
2016-05-03 15:00:00	SPY	ETF	206.32	206.39	205.75	206.15	18457830.0
2016-05-03 16:00:00	SPY	ETF	206.16	206.39	206.0	206.24	7122075.0
2016-05-03 17:00:00	SPY	ETF	206.22	206.25	206.13	206.19	424761.0
2016-05-03 18:00:00	SPY	ETF	206.2	206.33	206.2	206.22	135404.0
2016-05-03 19:00:00	SPY	ETF	206.23	206.42	206.23	206.4	69274.0
2016-05-03 04:00:00	QQQ	ETF	106.12	106.12	105.9	105.9	2452.0
2016-05-03 05:00:00	QQQ	ETF	105.97	105.97	105.83	105.92	11476.0
2016-05-03 06:00:00	QQQ	ETF	105.87	105.9	105.75	105.75	18051.0
2016-05-03 07:00:00	QQQ	ETF	105.77	105.98	105.77	105.98	47608.0
2016-05-03 08:00:00	QQQ	ETF	105.9	106.06	105.85	106.02	135342.0
2016-05-03 09:00:00	QQQ	ETF	106.02	106.23	105.6	105.81	3188409.0
2016-05-03 10:00:00	QQQ	ETF	105.81	105.85	105.45	105.6478	5088647.0
2016-05-03 11:00:00	QQQ	ETF	105.64	105.86	105.47	105.73	2414272.0
2016-05-03 12:00:00	QQQ	ETF	105.74	106.089	105.5489	106.046	1879983.0
2016-05-03 13:00:00	QQQ	ETF	106.0462	106.4399	105.98	106.24	2462057.0
2016-05-03 14:00:00	QQQ	ETF	106.25	106.29	105.84	106.02	1647810.0
2016-05-03 15:00:00	QQQ	ETF	106.02	106.08	105.59	105.73	10305305.0
2016-05-03 16:00:00	QQQ	ETF	105.74	106.7293	105.72	105.86	3186199.0
2016-05-03 17:00:00	QQQ	ETF	105.82	105.84	105.79	105.8	3339.0
2016-05-03 18:00:00	QQQ	ETF	105.79	105.87	105.79	105.83	3748.0
2016-05-03 19:00:00	QQQ	ETF	105.87	105.96	105.87	105.93	11686.0
2016-05-03 04:00:00	IWM	ETF	112.58	112.58	112.53	112.53	300.0
2016-05-03 05:00:00	IWM	ETF	112.53	112.53	112.5	112.5	2799.0
2016-05-03 06:00:00	IWM	ETF	112.38	112.38	112.31	112.31	1900.0
2016-05-03 07:00:00	IWM	ETF	112.29	112.48	112.29	112.48	159712.0
2016-05-03 08:00:00	IWM	ETF	112.49	112.66	112.43	112.66	91462.0
2016-05-03 09:00:00	IWM	ETF	112.63	112.72	111.77	111.9399	4674185.0
2016-05-03 10:00:00	IWM	ETF	111.93	111.99	111.32	111.39	7209932.0
2016-05-03 11:00:00	IWM	ETF	111.39	111.63	110.93	111.54	5029435.0
2016-05-03 12:00:00	IWM	ETF	111.54	111.74	111.35	111.72	1950629.0
2016-05-03 13:00:00	IWM	ETF	111.702	112.17	111.62	111.89	3246762.0
2016-05-03 14:00:00	IWM	ETF	111.89	112.04	111.6	111.88	2531777.0
2016-05-03 15:00:00	IWM	ETF	111.89	111.91	111.42	111.62	5431373.0
2016-05-03 16:00:00	IWM	ETF	111.62	111.71	111.46	111.46	1589728.0
2016-05-03 17:00:00	IWM	ETF	111.55	111.62	111.49	111.57	11218.0
2016-05-03 18:00:00	IWM	ETF	111.6	111.6	111.6	111.6	500.0
2016-05-03 19:00:00	IWM	ETF	111.6	111.69	111.6	111.64	2373.0
2016-05-03 04:00:00	DIA	ETF	177.8	177.8	177.8	177.8	100.0
2016-05-03 06:00:00	DIA	ETF	177.64	177.64	177.64	177.64	571.0

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

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