PREVIEW / etf_1hour / 2017-11-03

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-11-03.parquet
  size:    285 KB
  rows:    9,349

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-11-03 04:00:00	SPY	ETF	257.66	257.72	257.61	257.72	8600.0
2017-11-03 05:00:00	SPY	ETF	257.79	257.83	257.79	257.83	800.0
2017-11-03 06:00:00	SPY	ETF	257.81	257.9	257.81	257.9	3799.0
2017-11-03 07:00:00	SPY	ETF	257.84	257.86	257.8	257.8	16455.0
2017-11-03 08:00:00	SPY	ETF	257.59	258.06	257.59	257.8	274950.0
2017-11-03 09:00:00	SPY	ETF	257.74	257.9	257.3	257.49	7224779.0
2017-11-03 10:00:00	SPY	ETF	257.49	257.72	257.38	257.625	4999003.0
2017-11-03 11:00:00	SPY	ETF	257.63	257.99	257.57	257.94	4332277.0
2017-11-03 12:00:00	SPY	ETF	257.945	258.21	257.94	258.13	5512828.0
2017-11-03 13:00:00	SPY	ETF	258.1311	258.38	258.13	258.365	4416541.0
2017-11-03 14:00:00	SPY	ETF	258.36	258.5	258.25	258.4	4739128.0
2017-11-03 15:00:00	SPY	ETF	258.405	258.45	258.23	258.44	12422111.0
2017-11-03 16:00:00	SPY	ETF	258.44	258.46	258.11	258.11	13177847.0
2017-11-03 17:00:00	SPY	ETF	258.15	258.405	258.14	258.24	151369.0
2017-11-03 18:00:00	SPY	ETF	258.2	258.26	258.18	258.25	26816.0
2017-11-03 19:00:00	SPY	ETF	258.22	258.24	258.2	258.21	11375.0
2017-11-03 04:00:00	QQQ	ETF	152.19	152.26	152.09	152.26	35900.0
2017-11-03 05:00:00	QQQ	ETF	152.3	152.3	152.3	152.3	100.0
2017-11-03 06:00:00	QQQ	ETF	152.32	152.38	152.32	152.38	500.0
2017-11-03 07:00:00	QQQ	ETF	152.42	152.45	152.38	152.39	10220.0
2017-11-03 08:00:00	QQQ	ETF	152.38	152.76	152.32	152.55	216421.0
2017-11-03 09:00:00	QQQ	ETF	152.49	152.58	151.9	152.03	2715583.0
2017-11-03 10:00:00	QQQ	ETF	152.03	152.33	151.84	152.32	2247074.0
2017-11-03 11:00:00	QQQ	ETF	152.31	152.61	152.19	152.58	1639901.0
2017-11-03 12:00:00	QQQ	ETF	152.58	152.76	152.56	152.68	1513660.0
2017-11-03 13:00:00	QQQ	ETF	152.68	153.08	152.68	153.04	1697803.0
2017-11-03 14:00:00	QQQ	ETF	153.04	153.29	153.02	153.185	3438631.0
2017-11-03 15:00:00	QQQ	ETF	153.1833	153.28	153.03	153.25	4387906.0
2017-11-03 16:00:00	QQQ	ETF	153.25	153.31	153.05	153.14	1671291.0
2017-11-03 17:00:00	QQQ	ETF	153.08	153.16	153.0	153.15	11030.0
2017-11-03 18:00:00	QQQ	ETF	153.18	153.18	153.12	153.15	2000.0
2017-11-03 19:00:00	QQQ	ETF	153.12	153.21	153.1	153.21	8686.0
2017-11-03 04:00:00	IWM	ETF	148.55	148.63	148.49	148.6	11963.0
2017-11-03 05:00:00	IWM	ETF	148.57	148.57	148.57	148.57	2423.0
2017-11-03 06:00:00	IWM	ETF	148.66	148.72	148.66	148.72	2371.0
2017-11-03 07:00:00	IWM	ETF	148.65	148.75	148.65	148.69	62884.0
2017-11-03 08:00:00	IWM	ETF	148.69	148.89	148.46	148.61	84829.0
2017-11-03 09:00:00	IWM	ETF	148.58	148.7	148.06	148.31	1651266.0
2017-11-03 10:00:00	IWM	ETF	148.29	148.87	148.26	148.56	1434506.0
2017-11-03 11:00:00	IWM	ETF	148.56	148.96	148.52	148.69	1423054.0
2017-11-03 12:00:00	IWM	ETF	148.7	148.81	148.55	148.73	1324173.0
2017-11-03 13:00:00	IWM	ETF	148.73	148.9	148.665	148.81	970453.0
2017-11-03 14:00:00	IWM	ETF	148.82	148.82	148.59	148.71	1207334.0
2017-11-03 15:00:00	IWM	ETF	148.705	148.71	148.46	148.6	3349509.0
2017-11-03 16:00:00	IWM	ETF	148.6	148.69	148.47	148.47	641685.0
2017-11-03 17:00:00	IWM	ETF	148.47	148.7766	148.47	148.51	861029.0
2017-11-03 18:00:00	IWM	ETF	148.46	148.46	148.46	148.46	100.0
2017-11-03 19:00:00	IWM	ETF	148.46	148.46	148.46	148.46	316.0
2017-11-03 04:00:00	DIA	ETF	235.1	235.1	235.1	235.1	100.0
2017-11-03 05:00:00	DIA	ETF	235.18	235.18	235.18	235.18	100.0

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

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