PREVIEW / etf_1hour / 2017-10-23

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-10-23.parquet
  size:    287 KB
  rows:    9,394

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-23 04:00:00	SPY	ETF	257.15	257.26	257.05	257.21	3054.0
2017-10-23 05:00:00	SPY	ETF	257.18	257.47	257.18	257.47	3629.0
2017-10-23 06:00:00	SPY	ETF	257.47	257.48	257.4	257.48	12800.0
2017-10-23 07:00:00	SPY	ETF	257.46	257.51	257.3	257.34	156435.0
2017-10-23 08:00:00	SPY	ETF	257.43	257.47	257.27	257.47	171059.0
2017-10-23 09:00:00	SPY	ETF	257.47	257.52	257.12	257.305	7673821.0
2017-10-23 10:00:00	SPY	ETF	257.305	257.305	257.0	257.02	6048509.0
2017-10-23 11:00:00	SPY	ETF	257.025	257.18	256.85	256.975	9822626.0
2017-10-23 12:00:00	SPY	ETF	256.97	257.05	256.88	257.05	2749718.0
2017-10-23 13:00:00	SPY	ETF	257.045	257.08	256.7	256.805	2763608.0
2017-10-23 14:00:00	SPY	ETF	256.8	256.86	256.48	256.655	6148945.0
2017-10-23 15:00:00	SPY	ETF	256.66	256.67	256.02	256.15	17253276.0
2017-10-23 16:00:00	SPY	ETF	256.14	256.26	255.96	256.08	9777060.0
2017-10-23 17:00:00	SPY	ETF	256.09	257.1539	256.05	256.06	30300.0
2017-10-23 18:00:00	SPY	ETF	256.06	256.2	256.02	256.2	45493.0
2017-10-23 19:00:00	SPY	ETF	256.22	256.28	256.2	256.26	25865.0
2017-10-23 04:00:00	QQQ	ETF	148.82	148.94	148.82	148.83	4100.0
2017-10-23 05:00:00	QQQ	ETF	148.78	149.02	148.78	149.02	6600.0
2017-10-23 06:00:00	QQQ	ETF	149.02	149.06	149.0	149.06	16627.0
2017-10-23 07:00:00	QQQ	ETF	149.0	149.02	148.88	148.88	6310.0
2017-10-23 08:00:00	QQQ	ETF	148.89	149.05	148.71	149.05	68010.0
2017-10-23 09:00:00	QQQ	ETF	149.05	149.07	148.6	148.66	2426435.0
2017-10-23 10:00:00	QQQ	ETF	148.66	148.7	148.16	148.28	3423892.0
2017-10-23 11:00:00	QQQ	ETF	148.28	148.43	148.18	148.3362	1517481.0
2017-10-23 12:00:00	QQQ	ETF	148.335	148.595	148.31	148.585	1780993.0
2017-10-23 13:00:00	QQQ	ETF	148.58	148.61	148.25	148.33	1696213.0
2017-10-23 14:00:00	QQQ	ETF	148.33	148.42	148.09	148.22	1665846.0
2017-10-23 15:00:00	QQQ	ETF	148.21	148.22	147.53	147.74	5805886.0
2017-10-23 16:00:00	QQQ	ETF	147.74	147.79	147.56	147.65	1056383.0
2017-10-23 17:00:00	QQQ	ETF	147.59	147.65	147.59	147.61	2003598.0
2017-10-23 18:00:00	QQQ	ETF	147.64	147.72	147.64	147.72	3371.0
2017-10-23 19:00:00	QQQ	ETF	147.71	147.77	147.71	147.74	25254.0
2017-10-23 04:00:00	IWM	ETF	150.02	150.03	149.94	150.03	6000.0
2017-10-23 05:00:00	IWM	ETF	150.09	150.19	150.04	150.19	5515.0
2017-10-23 06:00:00	IWM	ETF	150.14	150.16	150.14	150.16	2697.0
2017-10-23 07:00:00	IWM	ETF	150.22	150.29	150.06	150.08	26545.0
2017-10-23 08:00:00	IWM	ETF	150.08	150.16	150.06	150.14	9462.0
2017-10-23 09:00:00	IWM	ETF	150.14	150.24	149.62	149.91	1802978.0
2017-10-23 10:00:00	IWM	ETF	149.89	149.89	149.33	149.43	1519087.0
2017-10-23 11:00:00	IWM	ETF	149.43	149.515	149.11	149.31	1764224.0
2017-10-23 12:00:00	IWM	ETF	149.32	149.54	149.28	149.51	697555.0
2017-10-23 13:00:00	IWM	ETF	149.51	149.52	149.04	149.25	1162202.0
2017-10-23 14:00:00	IWM	ETF	149.25	149.37	149.04	149.18	1070410.0
2017-10-23 15:00:00	IWM	ETF	149.17	149.24	148.7	148.85	3638214.0
2017-10-23 16:00:00	IWM	ETF	148.86	148.88	148.63	148.83	971547.0
2017-10-23 17:00:00	IWM	ETF	148.82	149.105	148.73	148.82	41017.0
2017-10-23 18:00:00	IWM	ETF	148.74	148.85	148.74	148.85	8510.0
2017-10-23 19:00:00	IWM	ETF	148.86	148.9	148.84	148.88	16712.0
2017-10-23 05:00:00	DIA	ETF	233.2	233.2	233.2	233.2	200.0
2017-10-23 07:00:00	DIA	ETF	233.19	233.19	233.19	233.19	500.0

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

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