PREVIEW / etf_1hour / 2013-10-14

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-10-14.parquet
  size:    208 KB
  rows:    6,429

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
2013-10-14 04:00:00	SPY	ETF	169.54	169.54	169.15	169.27	69980.0
2013-10-14 05:00:00	SPY	ETF	169.29	169.29	169.17	169.18	26027.0
2013-10-14 06:00:00	SPY	ETF	169.2	169.36	169.16	169.3	96780.0
2013-10-14 07:00:00	SPY	ETF	169.32	169.39	169.15	169.15	551827.0
2013-10-14 08:00:00	SPY	ETF	169.17	169.36	168.96	169.12	978370.0
2013-10-14 09:00:00	SPY	ETF	169.11	169.67	169.08	169.505	12176130.0
2013-10-14 10:00:00	SPY	ETF	169.5	169.66	169.28	169.42	11668564.0
2013-10-14 11:00:00	SPY	ETF	169.42	170.11	169.34	170.07	10940676.0
2013-10-14 12:00:00	SPY	ETF	170.07	170.18	169.88	170.15	8566347.0
2013-10-14 13:00:00	SPY	ETF	170.15	170.64	170.07	170.52	11424222.0
2013-10-14 14:00:00	SPY	ETF	170.51	170.94	170.47	170.68	17412810.0
2013-10-14 15:00:00	SPY	ETF	170.685	171.08	170.57	170.97	23771975.0
2013-10-14 16:00:00	SPY	ETF	170.96	171.13	169.49	171.06	11100965.0
2013-10-14 17:00:00	SPY	ETF	171.07	171.13	171.0	171.09	254686.0
2013-10-14 18:00:00	SPY	ETF	171.09	171.12	170.97	170.97	118036.0
2013-10-14 19:00:00	SPY	ETF	170.98	171.42	170.96	171.31	89213.0
2013-10-14 04:00:00	QQQ	ETF	78.86	78.88	78.77	78.83	19600.0
2013-10-14 05:00:00	QQQ	ETF	78.82	78.83	78.78	78.78	10600.0
2013-10-14 06:00:00	QQQ	ETF	78.79	78.89	78.78	78.85	62600.0
2013-10-14 07:00:00	QQQ	ETF	78.86	78.86	78.78	78.79	34024.0
2013-10-14 08:00:00	QQQ	ETF	78.79	78.87	78.62	78.73	169322.0
2013-10-14 09:00:00	QQQ	ETF	78.72	79.06	78.68	79.05	3891718.0
2013-10-14 10:00:00	QQQ	ETF	79.05	79.11	78.84	78.91	3756804.0
2013-10-14 11:00:00	QQQ	ETF	78.91	79.33	78.88	79.3065	3198095.0
2013-10-14 12:00:00	QQQ	ETF	79.31	79.435	79.22	79.42	3297948.0
2013-10-14 13:00:00	QQQ	ETF	79.43	79.55	79.38	79.539	3350300.0
2013-10-14 14:00:00	QQQ	ETF	79.54	79.75	79.52	79.6	5410429.0
2013-10-14 15:00:00	QQQ	ETF	79.6	79.79	79.55	79.77	6584506.0
2013-10-14 16:00:00	QQQ	ETF	79.77	79.88	79.7	79.88	1544453.0
2013-10-14 17:00:00	QQQ	ETF	79.86	79.9	79.82	79.86	28837.0
2013-10-14 18:00:00	QQQ	ETF	79.88	79.89	79.83	79.83	19490.0
2013-10-14 19:00:00	QQQ	ETF	79.83	79.97	79.82	79.97	13840.0
2013-10-14 06:00:00	IWM	ETF	107.16	107.16	107.15	107.16	2700.0
2013-10-14 07:00:00	IWM	ETF	107.18	107.21	107.03	107.06	116009.0
2013-10-14 08:00:00	IWM	ETF	107.05	107.11	106.93	106.93	237507.0
2013-10-14 09:00:00	IWM	ETF	106.95	107.37	106.93	107.14	3148443.0
2013-10-14 10:00:00	IWM	ETF	107.15	107.43	106.97	107.3	3826717.0
2013-10-14 11:00:00	IWM	ETF	107.3	107.93	107.26	107.89	3635927.0
2013-10-14 12:00:00	IWM	ETF	107.89	108.0	107.605	107.83	2961613.0
2013-10-14 13:00:00	IWM	ETF	107.83	108.115	107.7145	107.94	3002232.0
2013-10-14 14:00:00	IWM	ETF	107.9399	108.26	107.89	108.03	4254426.0
2013-10-14 15:00:00	IWM	ETF	108.03	108.345	107.95	108.17	7851614.0
2013-10-14 16:00:00	IWM	ETF	108.17	108.3	107.0754	108.27	5894485.0
2013-10-14 17:00:00	IWM	ETF	108.29	108.3	108.16	108.23	35126.0
2013-10-14 18:00:00	IWM	ETF	108.21	108.21	108.14	108.19	24952.0
2013-10-14 19:00:00	IWM	ETF	108.19	108.31	108.16	108.28	23176.0
2013-10-14 04:00:00	DIA	ETF	151.19	151.23	151.19	151.23	1100.0
2013-10-14 07:00:00	DIA	ETF	151.37	151.37	151.17	151.17	3200.0
2013-10-14 08:00:00	DIA	ETF	151.37	151.37	151.07	151.17	29799.0
2013-10-14 09:00:00	DIA	ETF	151.14	151.52	151.0802	151.49	682017.0

> showing 50 of 6,429 rows — these rows as CSV

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