PREVIEW / etf_1hour / 2017-04-20

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-04-20.parquet
  size:    275 KB
  rows:    8,973

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
2017-04-20 04:00:00	SPY	ETF	233.84	234.1	233.84	234.05	19275.0
2017-04-20 05:00:00	SPY	ETF	233.92	234.2	233.92	234.07	12520.0
2017-04-20 06:00:00	SPY	ETF	234.06	234.11	233.99	234.07	12197.0
2017-04-20 07:00:00	SPY	ETF	234.07	234.12	233.96	234.02	74234.0
2017-04-20 08:00:00	SPY	ETF	234.03	234.18	233.98	234.05	314637.0
2017-04-20 09:00:00	SPY	ETF	234.04	234.3	233.78	233.9099	6932681.0
2017-04-20 10:00:00	SPY	ETF	233.9	234.4699	233.9	234.35	8949675.0
2017-04-20 11:00:00	SPY	ETF	234.35	234.94	234.17	234.9	10993050.0
2017-04-20 12:00:00	SPY	ETF	234.9	235.44	234.87	235.285	10882142.0
2017-04-20 13:00:00	SPY	ETF	235.283	235.845	235.14	235.74	11793216.0
2017-04-20 14:00:00	SPY	ETF	235.74	235.77	235.5	235.51	10337656.0
2017-04-20 15:00:00	SPY	ETF	235.505	235.69	235.27	235.3	21081058.0
2017-04-20 16:00:00	SPY	ETF	235.3	235.626	235.18	235.24	9206330.0
2017-04-20 17:00:00	SPY	ETF	235.24	235.34	235.19	235.28	120741.0
2017-04-20 18:00:00	SPY	ETF	235.26	235.38	235.24	235.32	184979.0
2017-04-20 19:00:00	SPY	ETF	235.32	235.36	235.3	235.32	51445.0
2017-04-20 04:00:00	QQQ	ETF	131.73	131.92	131.73	131.85	3350.0
2017-04-20 05:00:00	QQQ	ETF	131.88	131.88	131.88	131.88	100.0
2017-04-20 06:00:00	QQQ	ETF	131.95	131.95	131.95	131.95	3000.0
2017-04-20 07:00:00	QQQ	ETF	131.89	131.97	131.88	131.95	36224.0
2017-04-20 08:00:00	QQQ	ETF	131.93	132.06	131.91	131.98	78074.0
2017-04-20 09:00:00	QQQ	ETF	131.97	132.21	131.82	131.88	2079073.0
2017-04-20 10:00:00	QQQ	ETF	131.88	132.27	131.88	132.0965	2808612.0
2017-04-20 11:00:00	QQQ	ETF	132.1	132.4184	132.02	132.39	1683088.0
2017-04-20 12:00:00	QQQ	ETF	132.39	132.788	132.37	132.68	2213794.0
2017-04-20 13:00:00	QQQ	ETF	132.68	132.88	132.57	132.819	1779203.0
2017-04-20 14:00:00	QQQ	ETF	132.821	132.87	132.74	132.8	1795050.0
2017-04-20 15:00:00	QQQ	ETF	132.8	132.86	132.55	132.56	4804235.0
2017-04-20 16:00:00	QQQ	ETF	132.57	132.8192	132.54	132.62	836026.0
2017-04-20 17:00:00	QQQ	ETF	132.57	132.62	132.57	132.62	387.0
2017-04-20 18:00:00	QQQ	ETF	132.64	132.75	132.64	132.69	66860.0
2017-04-20 19:00:00	QQQ	ETF	132.72	132.72	132.69	132.71	2024.0
2017-04-20 04:00:00	IWM	ETF	136.18	136.2	136.18	136.2	7200.0
2017-04-20 05:00:00	IWM	ETF	136.36	136.38	136.33	136.33	7400.0
2017-04-20 06:00:00	IWM	ETF	136.27	136.27	136.2	136.2	2100.0
2017-04-20 07:00:00	IWM	ETF	136.2	136.37	136.2	136.34	18543.0
2017-04-20 08:00:00	IWM	ETF	136.34	136.59	136.3	136.32	106454.0
2017-04-20 09:00:00	IWM	ETF	136.32	136.83	136.23	136.35	2808418.0
2017-04-20 10:00:00	IWM	ETF	136.34	136.68	136.15	136.62	2887894.0
2017-04-20 11:00:00	IWM	ETF	136.62	137.215	136.47	137.09	3223208.0
2017-04-20 12:00:00	IWM	ETF	137.1	137.55	137.1	137.285	3268615.0
2017-04-20 13:00:00	IWM	ETF	137.29	137.5	137.03	137.42	2516480.0
2017-04-20 14:00:00	IWM	ETF	137.42	137.48	137.22	137.37	2245634.0
2017-04-20 15:00:00	IWM	ETF	137.375	137.67	137.17	137.53	6810453.0
2017-04-20 16:00:00	IWM	ETF	137.54	137.5956	137.31	137.31	2997529.0
2017-04-20 17:00:00	IWM	ETF	137.5754	137.5754	137.5754	137.5754	52000.0
2017-04-20 18:00:00	IWM	ETF	137.39	137.45	137.35	137.44	10300.0
2017-04-20 19:00:00	IWM	ETF	137.4	137.45	137.4	137.45	2900.0
2017-04-20 04:00:00	DIA	ETF	204.0	204.3	204.0	204.3	400.0
2017-04-20 07:00:00	DIA	ETF	204.3	204.35	204.3	204.35	600.0

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

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