PREVIEW / etf_1hour / 2017-04-10

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-04-10.parquet
  size:    270 KB
  rows:    8,825

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-10 04:00:00	SPY	ETF	235.26	235.42	235.26	235.29	4500.0
2017-04-10 05:00:00	SPY	ETF	235.35	235.35	235.19	235.19	1291.0
2017-04-10 06:00:00	SPY	ETF	235.0	235.2	234.92	235.13	34344.0
2017-04-10 07:00:00	SPY	ETF	235.22	235.48	235.21	235.45	189662.0
2017-04-10 08:00:00	SPY	ETF	235.45	235.49	235.13	235.21	186766.0
2017-04-10 09:00:00	SPY	ETF	235.22	235.97	235.22	235.96	4766964.0
2017-04-10 10:00:00	SPY	ETF	235.95	236.255	235.81	235.83	7654481.0
2017-04-10 11:00:00	SPY	ETF	235.83	235.99	235.04	235.28	10921979.0
2017-04-10 12:00:00	SPY	ETF	235.28	235.69	234.73	235.66	9946285.0
2017-04-10 13:00:00	SPY	ETF	235.66	235.96	235.59	235.785	4342120.0
2017-04-10 14:00:00	SPY	ETF	235.79	235.87	235.41	235.8	5976988.0
2017-04-10 15:00:00	SPY	ETF	235.8	235.97	235.14	235.32	14280252.0
2017-04-10 16:00:00	SPY	ETF	235.32	235.38	235.07	235.33	6601390.0
2017-04-10 17:00:00	SPY	ETF	235.32	235.39	235.29	235.39	224220.0
2017-04-10 18:00:00	SPY	ETF	235.38	235.51	235.32	235.38	55821.0
2017-04-10 19:00:00	SPY	ETF	235.39	235.43	235.26	235.28	26259.0
2017-04-10 04:00:00	QQQ	ETF	132.1	132.13	132.07	132.07	2100.0
2017-04-10 05:00:00	QQQ	ETF	132.07	132.08	131.95	131.95	18800.0
2017-04-10 06:00:00	QQQ	ETF	131.9	131.98	131.9	131.98	600.0
2017-04-10 07:00:00	QQQ	ETF	132.0	132.15	132.0	132.15	63708.0
2017-04-10 08:00:00	QQQ	ETF	132.15	132.17	132.03	132.03	61146.0
2017-04-10 09:00:00	QQQ	ETF	132.04	132.45	132.04	132.39	1619919.0
2017-04-10 10:00:00	QQQ	ETF	132.39	132.565	132.22	132.2395	1857680.0
2017-04-10 11:00:00	QQQ	ETF	132.24	132.3401	131.83	131.95	2224517.0
2017-04-10 12:00:00	QQQ	ETF	131.96	132.26	131.6564	132.23	2413414.0
2017-04-10 13:00:00	QQQ	ETF	132.22	132.42	132.2	132.31	1201504.0
2017-04-10 14:00:00	QQQ	ETF	132.315	132.315	132.03	132.27	1168246.0
2017-04-10 15:00:00	QQQ	ETF	132.28	132.39	131.92	132.04	2456288.0
2017-04-10 16:00:00	QQQ	ETF	132.04	132.26	131.91	132.12	1634503.0
2017-04-10 17:00:00	QQQ	ETF	132.1	132.13	132.1	132.13	4500.0
2017-04-10 18:00:00	QQQ	ETF	132.13	132.18	132.13	132.15	11898.0
2017-04-10 19:00:00	QQQ	ETF	132.12	132.12	132.03	132.03	6750.0
2017-04-10 05:00:00	IWM	ETF	135.56	135.56	135.56	135.56	680.0
2017-04-10 07:00:00	IWM	ETF	135.54	135.67	135.54	135.64	10560.0
2017-04-10 08:00:00	IWM	ETF	135.69	135.69	135.3	135.3	15802.0
2017-04-10 09:00:00	IWM	ETF	135.34	136.62	135.29	136.59	2720783.0
2017-04-10 10:00:00	IWM	ETF	136.59	136.85	136.155	136.2	3864221.0
2017-04-10 11:00:00	IWM	ETF	136.2	136.4	135.37	135.63	4151873.0
2017-04-10 12:00:00	IWM	ETF	135.64	135.99	135.16	135.91	2753881.0
2017-04-10 13:00:00	IWM	ETF	135.91	136.295	135.81	136.17	1359679.0
2017-04-10 14:00:00	IWM	ETF	136.17	136.22	135.74	136.13	2109042.0
2017-04-10 15:00:00	IWM	ETF	136.13	136.33	135.72	135.81	3349010.0
2017-04-10 16:00:00	IWM	ETF	135.82	135.87	135.6	135.77	1664273.0
2017-04-10 17:00:00	IWM	ETF	135.79	135.8	135.78	135.8	700.0
2017-04-10 18:00:00	IWM	ETF	135.83	135.83	135.83	135.83	1000.0
2017-04-10 19:00:00	IWM	ETF	135.82	135.84	135.72	135.72	1637.0
2017-04-10 07:00:00	DIA	ETF	206.5	206.5	206.5	206.5	100.0
2017-04-10 08:00:00	DIA	ETF	206.52	206.52	206.5	206.5	250.0
2017-04-10 09:00:00	DIA	ETF	206.49	206.965	206.4	206.91	333275.0
2017-04-10 10:00:00	DIA	ETF	206.93	207.32	206.85	207.08	342689.0

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

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