PREVIEW / etf_1hour / 2015-08-17

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-08-17.parquet
  size:    235 KB
  rows:    7,470

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-08-17 04:00:00	SPY	ETF	209.47	209.5	209.11	209.45	127250.0
2015-08-17 05:00:00	SPY	ETF	209.53	209.64	209.45	209.64	4997.0
2015-08-17 06:00:00	SPY	ETF	209.45	209.52	209.35	209.44	30662.0
2015-08-17 07:00:00	SPY	ETF	209.41	209.54	209.29	209.37	207094.0
2015-08-17 08:00:00	SPY	ETF	209.37	209.5	208.64	208.78	1699485.0
2015-08-17 09:00:00	SPY	ETF	208.78	208.95	208.16	208.39	13683977.0
2015-08-17 10:00:00	SPY	ETF	208.4	209.6999	208.27	209.66	15345584.0
2015-08-17 11:00:00	SPY	ETF	209.66	210.05	209.645	209.83	8725033.0
2015-08-17 12:00:00	SPY	ETF	209.83	210.24	209.8	210.22	6113854.0
2015-08-17 13:00:00	SPY	ETF	210.22	210.42	210.16	210.28	7106040.0
2015-08-17 14:00:00	SPY	ETF	210.29	210.43	210.16	210.37	5558180.0
2015-08-17 15:00:00	SPY	ETF	210.375	210.58	210.25	210.58	16619296.0
2015-08-17 16:00:00	SPY	ETF	210.57	210.69	208.5948	210.53	2924058.0
2015-08-17 17:00:00	SPY	ETF	210.53	210.59	210.51	210.53	229547.0
2015-08-17 18:00:00	SPY	ETF	210.53	210.65	210.52	210.57	56655.0
2015-08-17 19:00:00	SPY	ETF	210.58	210.62	210.53	210.6	71333.0
2015-08-17 04:00:00	QQQ	ETF	110.5	110.64	110.4	110.64	14400.0
2015-08-17 07:00:00	QQQ	ETF	110.6	110.61	110.58	110.61	13300.0
2015-08-17 08:00:00	QQQ	ETF	110.607	110.61	110.2	110.3	163939.0
2015-08-17 09:00:00	QQQ	ETF	110.29	110.38	109.96	110.16	3311321.0
2015-08-17 10:00:00	QQQ	ETF	110.16	110.89	110.08	110.84	4455448.0
2015-08-17 11:00:00	QQQ	ETF	110.85	111.1068	110.84	110.948	2568343.0
2015-08-17 12:00:00	QQQ	ETF	110.95	111.2	110.9	111.18	1550262.0
2015-08-17 13:00:00	QQQ	ETF	111.19	111.37	111.165	111.29	1842064.0
2015-08-17 14:00:00	QQQ	ETF	111.29	111.41	111.2199	111.34	1344143.0
2015-08-17 15:00:00	QQQ	ETF	111.335	111.46	111.25	111.41	2458615.0
2015-08-17 16:00:00	QQQ	ETF	111.41	111.53	111.41	111.43	1523822.0
2015-08-17 17:00:00	QQQ	ETF	111.43	111.43	111.38	111.41	40463.0
2015-08-17 18:00:00	QQQ	ETF	111.42	111.45	111.42	111.44	4800.0
2015-08-17 19:00:00	QQQ	ETF	111.43	111.5	111.43	111.48	6300.0
2015-08-17 04:00:00	IWM	ETF	120.25	120.3	120.25	120.3	300.0
2015-08-17 05:00:00	IWM	ETF	120.32	120.5	120.32	120.45	300.0
2015-08-17 07:00:00	IWM	ETF	120.45	120.45	120.45	120.45	500.0
2015-08-17 08:00:00	IWM	ETF	120.4	120.41	119.95	120.02	79605.0
2015-08-17 09:00:00	IWM	ETF	120.02	120.2	119.6	120.03	2650337.0
2015-08-17 10:00:00	IWM	ETF	120.035	120.81	119.76	120.77	3785816.0
2015-08-17 11:00:00	IWM	ETF	120.77	121.07	120.74	120.83	2247699.0
2015-08-17 12:00:00	IWM	ETF	120.82	121.32	120.8	121.32	1486368.0
2015-08-17 13:00:00	IWM	ETF	121.32	121.68	121.32	121.54	2879068.0
2015-08-17 14:00:00	IWM	ETF	121.54	121.6	121.345	121.47	1552119.0
2015-08-17 15:00:00	IWM	ETF	121.475	121.66	121.295	121.61	4735481.0
2015-08-17 16:00:00	IWM	ETF	121.62	121.71	121.57	121.64	891849.0
2015-08-17 17:00:00	IWM	ETF	121.63	121.67	121.63	121.63	44664.0
2015-08-17 19:00:00	IWM	ETF	121.67	121.67	121.67	121.67	100.0
2015-08-17 04:00:00	DIA	ETF	174.9	174.9	174.9	174.9	100.0
2015-08-17 05:00:00	DIA	ETF	175.0	175.0	175.0	175.0	100.0
2015-08-17 08:00:00	DIA	ETF	175.06	175.06	174.3	174.33	4225.0
2015-08-17 09:00:00	DIA	ETF	174.28	174.4	173.62	173.85	717259.0
2015-08-17 10:00:00	DIA	ETF	173.84	175.2	173.78	175.14	1087322.0
2015-08-17 11:00:00	DIA	ETF	175.12	175.51	175.12	175.27	706203.0

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

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