PREVIEW / etf_1hour / 2017-06-23

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-06-23.parquet
  size:    271 KB
  rows:    8,886

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-06-23 04:00:00	SPY	ETF	243.09	243.25	243.09	243.2	14210.0
2017-06-23 05:00:00	SPY	ETF	243.11	243.19	242.91	242.91	4500.0
2017-06-23 06:00:00	SPY	ETF	242.98	243.0	242.63	242.75	83990.0
2017-06-23 07:00:00	SPY	ETF	242.85	242.88	242.78	242.86	22775.0
2017-06-23 08:00:00	SPY	ETF	242.87	243.06	242.82	243.03	214282.0
2017-06-23 09:00:00	SPY	ETF	243.02	243.09	242.47	242.79	6099823.0
2017-06-23 10:00:00	SPY	ETF	242.8	243.38	242.74	243.235	5837696.0
2017-06-23 11:00:00	SPY	ETF	243.24	243.35	243.175	243.3	2889445.0
2017-06-23 12:00:00	SPY	ETF	243.3	243.485	243.25	243.32	3190779.0
2017-06-23 13:00:00	SPY	ETF	243.31	243.51	243.22	243.39	2742689.0
2017-06-23 14:00:00	SPY	ETF	243.4	243.42	243.1	243.11	5313190.0
2017-06-23 15:00:00	SPY	ETF	243.115	243.32	242.71	243.16	27369581.0
2017-06-23 16:00:00	SPY	ETF	243.17	243.26	242.82	242.84	10020976.0
2017-06-23 17:00:00	SPY	ETF	242.94	243.17	242.92	243.15	174365.0
2017-06-23 18:00:00	SPY	ETF	243.15	243.22	243.09	243.18	58550.0
2017-06-23 19:00:00	SPY	ETF	243.11	243.2	243.11	243.19	38500.0
2017-06-23 04:00:00	QQQ	ETF	141.06	141.06	140.99	141.04	12900.0
2017-06-23 05:00:00	QQQ	ETF	140.99	140.99	140.99	140.99	400.0
2017-06-23 06:00:00	QQQ	ETF	140.68	140.69	140.47	140.52	38300.0
2017-06-23 07:00:00	QQQ	ETF	140.58	140.6	140.49	140.52	61608.0
2017-06-23 08:00:00	QQQ	ETF	140.53	140.69	140.53	140.69	142621.0
2017-06-23 09:00:00	QQQ	ETF	140.67	140.75	140.15	140.41	3139797.0
2017-06-23 10:00:00	QQQ	ETF	140.4	140.93	140.35	140.849	3275018.0
2017-06-23 11:00:00	QQQ	ETF	140.84	141.0867	140.8	141.05	1702613.0
2017-06-23 12:00:00	QQQ	ETF	141.04	141.36	140.94	141.2199	1719152.0
2017-06-23 13:00:00	QQQ	ETF	141.21	141.42	141.16	141.335	889771.0
2017-06-23 14:00:00	QQQ	ETF	141.34	141.37	141.08	141.175	1240759.0
2017-06-23 15:00:00	QQQ	ETF	141.18	141.31	140.85	141.23	4867348.0
2017-06-23 16:00:00	QQQ	ETF	141.23	141.39	141.1029	141.2	1379464.0
2017-06-23 17:00:00	QQQ	ETF	141.2	141.42	141.2	141.38	34983.0
2017-06-23 18:00:00	QQQ	ETF	141.3	141.32	141.27	141.29	10293.0
2017-06-23 19:00:00	QQQ	ETF	141.31	141.34	141.3	141.34	3070.0
2017-06-23 04:00:00	IWM	ETF	140.29	140.32	140.21	140.21	12485.0
2017-06-23 05:00:00	IWM	ETF	140.2	140.2	140.03	140.03	1600.0
2017-06-23 06:00:00	IWM	ETF	139.8	139.88	139.78	139.86	12600.0
2017-06-23 07:00:00	IWM	ETF	139.92	139.93	139.82	139.93	2900.0
2017-06-23 08:00:00	IWM	ETF	139.92	140.03	139.88	140.01	23131.0
2017-06-23 09:00:00	IWM	ETF	139.96	140.25	139.55	140.23	2497541.0
2017-06-23 10:00:00	IWM	ETF	140.22	140.86	140.16	140.81	3253919.0
2017-06-23 11:00:00	IWM	ETF	140.82	140.87	140.5401	140.67	1346336.0
2017-06-23 12:00:00	IWM	ETF	140.6601	140.83	140.58	140.66	1016456.0
2017-06-23 13:00:00	IWM	ETF	140.66	140.9	140.47	140.82	1343951.0
2017-06-23 14:00:00	IWM	ETF	140.82	140.865	140.55	140.69	1805083.0
2017-06-23 15:00:00	IWM	ETF	140.69	141.08	140.47	140.89	5993046.0
2017-06-23 16:00:00	IWM	ETF	140.89	140.98	140.64	140.75	2423411.0
2017-06-23 17:00:00	IWM	ETF	140.69	140.96	140.69	140.96	112420.0
2017-06-23 18:00:00	IWM	ETF	140.95	140.99	140.91	140.91	6365.0
2017-06-23 19:00:00	IWM	ETF	140.92	140.94	140.92	140.94	6500.0
2017-06-23 05:00:00	DIA	ETF	213.7	213.75	213.7	213.75	200.0
2017-06-23 06:00:00	DIA	ETF	213.5	213.5	213.21	213.21	1300.0

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

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