PREVIEW / etf_1hour / 2017-10-20

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-10-20.parquet
  size:    285 KB
  rows:    9,383

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-10-20 04:00:00	SPY	ETF	256.44	256.54	256.3	256.3	15697.0
2017-10-20 05:00:00	SPY	ETF	256.23	256.43	256.23	256.43	18705.0
2017-10-20 06:00:00	SPY	ETF	256.45	256.47	256.34	256.45	64184.0
2017-10-20 07:00:00	SPY	ETF	256.4	256.51	256.34	256.45	223336.0
2017-10-20 08:00:00	SPY	ETF	256.39	256.49	256.34	256.44	223201.0
2017-10-20 09:00:00	SPY	ETF	256.47	256.81	256.42	256.55	16753942.0
2017-10-20 10:00:00	SPY	ETF	256.55	256.75	256.43	256.45	11328402.0
2017-10-20 11:00:00	SPY	ETF	256.44	256.73	256.44	256.69	6298439.0
2017-10-20 12:00:00	SPY	ETF	256.7	256.83	256.64	256.79	4145750.0
2017-10-20 13:00:00	SPY	ETF	256.79	257.07	256.78	256.92	7440698.0
2017-10-20 14:00:00	SPY	ETF	256.92	257.14	256.915	256.94	7066568.0
2017-10-20 15:00:00	SPY	ETF	256.93	257.09	256.79	257.08	15024902.0
2017-10-20 16:00:00	SPY	ETF	257.08	257.24	257.07	257.16	16528198.0
2017-10-20 17:00:00	SPY	ETF	257.18	257.24	257.06	257.08	167645.0
2017-10-20 18:00:00	SPY	ETF	257.05	257.11	256.97	257.09	36534.0
2017-10-20 19:00:00	SPY	ETF	257.1	257.16	257.1	257.14	18416.0
2017-10-20 04:00:00	QQQ	ETF	148.72	148.87	148.65	148.65	10011.0
2017-10-20 05:00:00	QQQ	ETF	148.58	148.61	148.58	148.61	900.0
2017-10-20 06:00:00	QQQ	ETF	148.64	148.75	148.63	148.74	2725.0
2017-10-20 07:00:00	QQQ	ETF	148.74	148.81	148.7	148.81	59583.0
2017-10-20 08:00:00	QQQ	ETF	148.82	148.82	148.66	148.71	57287.0
2017-10-20 09:00:00	QQQ	ETF	148.74	149.02	148.74	148.85	2322662.0
2017-10-20 10:00:00	QQQ	ETF	148.8415	149.04	148.58	148.6	3219614.0
2017-10-20 11:00:00	QQQ	ETF	148.6	148.83	148.58	148.78	1505208.0
2017-10-20 12:00:00	QQQ	ETF	148.78	148.93	148.7522	148.9	1393331.0
2017-10-20 13:00:00	QQQ	ETF	148.9	148.99	148.88	148.91	1317347.0
2017-10-20 14:00:00	QQQ	ETF	148.915	148.99	148.77	148.79	2147474.0
2017-10-20 15:00:00	QQQ	ETF	148.79	148.85	148.53	148.69	6450815.0
2017-10-20 16:00:00	QQQ	ETF	148.7	148.9477	148.65	148.7	3811601.0
2017-10-20 17:00:00	QQQ	ETF	148.66	148.8039	148.66	148.8039	1050400.0
2017-10-20 18:00:00	QQQ	ETF	148.7	148.76	148.7	148.76	306.0
2017-10-20 19:00:00	QQQ	ETF	148.72	148.72	148.72	148.72	2373.0
2017-10-20 04:00:00	IWM	ETF	150.1	150.1	149.67	149.8	19689.0
2017-10-20 05:00:00	IWM	ETF	149.67	149.79	149.67	149.79	2003.0
2017-10-20 06:00:00	IWM	ETF	149.83	149.83	149.75	149.79	41720.0
2017-10-20 07:00:00	IWM	ETF	149.76	149.96	149.76	149.89	77988.0
2017-10-20 08:00:00	IWM	ETF	149.9	150.03	149.29	149.93	203899.0
2017-10-20 09:00:00	IWM	ETF	149.97	150.32	149.86	150.03	2749318.0
2017-10-20 10:00:00	IWM	ETF	150.0205	150.4134	149.93	150.09	2379487.0
2017-10-20 11:00:00	IWM	ETF	150.1	150.2	150.0	150.1848	1462673.0
2017-10-20 12:00:00	IWM	ETF	150.19	150.215	150.11	150.12	1011513.0
2017-10-20 13:00:00	IWM	ETF	150.12	150.31	150.07	150.1	1895858.0
2017-10-20 14:00:00	IWM	ETF	150.1	150.2241	149.97	149.98	1685178.0
2017-10-20 15:00:00	IWM	ETF	149.98	150.11	149.9	149.99	3710021.0
2017-10-20 16:00:00	IWM	ETF	149.99	150.06	149.94	149.99	3449390.0
2017-10-20 17:00:00	IWM	ETF	149.98	150.0927	149.98	150.04	1351360.0
2017-10-20 18:00:00	IWM	ETF	150.0	150.03	150.0	150.03	300.0
2017-10-20 19:00:00	IWM	ETF	150.03	150.08	150.01	150.02	2488.0
2017-10-20 04:00:00	DIA	ETF	232.08	232.08	232.08	232.08	200.0
2017-10-20 06:00:00	DIA	ETF	232.5	232.5	232.44	232.44	300.0

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

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