PREVIEW / etf_1hour / 2017-12-08

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-12-08.parquet
  size:    288 KB
  rows:    9,490

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-12-08 04:00:00	SPY	ETF	264.61	264.8	264.57	264.77	6167.0
2017-12-08 05:00:00	SPY	ETF	264.82	264.96	264.8	264.85	4950.0
2017-12-08 06:00:00	SPY	ETF	264.84	264.86	264.71	264.72	16214.0
2017-12-08 07:00:00	SPY	ETF	264.65	264.83	264.63	264.7	133747.0
2017-12-08 08:00:00	SPY	ETF	264.73	265.24	264.66	265.15	996560.0
2017-12-08 09:00:00	SPY	ETF	265.13	265.19	264.25	265.05	7848000.0
2017-12-08 10:00:00	SPY	ETF	265.05	265.14	264.72	265.14	8335496.0
2017-12-08 11:00:00	SPY	ETF	265.14	265.235	264.79	265.08	5816386.0
2017-12-08 12:00:00	SPY	ETF	265.085	265.5	265.07	265.305	7555580.0
2017-12-08 13:00:00	SPY	ETF	265.3	265.52	265.25	265.35	5721964.0
2017-12-08 14:00:00	SPY	ETF	265.35	265.36	264.95	265.125	5840285.0
2017-12-08 15:00:00	SPY	ETF	265.13	265.5	265.02	265.49	18862758.0
2017-12-08 16:00:00	SPY	ETF	265.5	265.53	264.0315	265.5	12416863.0
2017-12-08 17:00:00	SPY	ETF	265.49	265.61	265.0214	265.57	1489345.0
2017-12-08 18:00:00	SPY	ETF	265.57	265.61	265.56	265.56	8632.0
2017-12-08 19:00:00	SPY	ETF	265.56	265.73	265.56	265.73	21749.0
2017-12-08 04:00:00	QQQ	ETF	154.7	154.91	154.7	154.91	20812.0
2017-12-08 05:00:00	QQQ	ETF	154.95	154.99	154.9	154.97	6300.0
2017-12-08 06:00:00	QQQ	ETF	154.88	154.97	154.76	154.78	28812.0
2017-12-08 07:00:00	QQQ	ETF	154.74	154.97	154.74	154.91	180616.0
2017-12-08 08:00:00	QQQ	ETF	154.88	155.23	154.76	155.15	520051.0
2017-12-08 09:00:00	QQQ	ETF	155.15	155.53	155.1	155.28	4812640.0
2017-12-08 10:00:00	QQQ	ETF	155.27	155.4	155.14	155.26	2975364.0
2017-12-08 11:00:00	QQQ	ETF	155.27	155.35	154.65	154.87	3074677.0
2017-12-08 12:00:00	QQQ	ETF	154.87	155.22	154.82	154.99	1569063.0
2017-12-08 13:00:00	QQQ	ETF	154.99	155.13	154.881	155.0	1110226.0
2017-12-08 14:00:00	QQQ	ETF	155.0	155.0	154.46	154.67	2552614.0
2017-12-08 15:00:00	QQQ	ETF	154.67	154.77	154.48	154.71	4964297.0
2017-12-08 16:00:00	QQQ	ETF	154.71	154.7163	154.52	154.65	1283832.0
2017-12-08 17:00:00	QQQ	ETF	154.53	155.3664	154.53	154.7	196005.0
2017-12-08 18:00:00	QQQ	ETF	154.74	154.75	154.7	154.7	13785.0
2017-12-08 19:00:00	QQQ	ETF	154.7	154.75	154.66	154.66	10614.0
2017-12-08 04:00:00	IWM	ETF	151.81	151.93	151.81	151.93	6600.0
2017-12-08 05:00:00	IWM	ETF	151.99	152.08	151.99	152.08	2700.0
2017-12-08 06:00:00	IWM	ETF	151.9	151.9	151.81	151.81	866.0
2017-12-08 07:00:00	IWM	ETF	151.78	151.84	151.72	151.72	99977.0
2017-12-08 08:00:00	IWM	ETF	151.8	152.15	151.73	152.0	91485.0
2017-12-08 09:00:00	IWM	ETF	152.04	152.1	151.45	151.71	1818967.0
2017-12-08 10:00:00	IWM	ETF	151.7	151.92	151.44	151.84	1480175.0
2017-12-08 11:00:00	IWM	ETF	151.85	152.03	151.54	151.885	2137974.0
2017-12-08 12:00:00	IWM	ETF	151.8895	152.28	151.88	152.12	1672617.0
2017-12-08 13:00:00	IWM	ETF	152.12	152.15	151.67	151.78	837150.0
2017-12-08 14:00:00	IWM	ETF	151.8	151.81	151.33	151.51	1969150.0
2017-12-08 15:00:00	IWM	ETF	151.51	151.66	151.28	151.42	4285389.0
2017-12-08 16:00:00	IWM	ETF	151.43	151.48	151.31	151.47	2220942.0
2017-12-08 17:00:00	IWM	ETF	151.41	151.8036	151.41	151.53	117037.0
2017-12-08 18:00:00	IWM	ETF	151.53	151.59	151.53	151.59	1247.0
2017-12-08 19:00:00	IWM	ETF	151.58	151.6	151.58	151.6	1425.0
2017-12-08 04:00:00	DIA	ETF	242.65	242.65	242.65	242.65	100.0
2017-12-08 05:00:00	DIA	ETF	242.77	242.77	242.77	242.77	100.0

> showing 50 of 9,490 rows — these rows as CSV

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