PREVIEW / etf_1hour / 2013-01-11

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-01-11.parquet
  size:    194 KB
  rows:    6,139

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-01-11 04:00:00	SPY	ETF	147.1	147.1	147.01	147.01	6600.0
2013-01-11 05:00:00	SPY	ETF	146.9	147.09	146.85	147.09	47761.0
2013-01-11 06:00:00	SPY	ETF	146.95	147.08	146.95	147.03	35850.0
2013-01-11 07:00:00	SPY	ETF	147.0	147.15	146.95	147.05	198332.0
2013-01-11 08:00:00	SPY	ETF	147.06	147.21	146.94	147.03	628401.0
2013-01-11 09:00:00	SPY	ETF	147.04	147.11	146.69	146.72	11651354.0
2013-01-11 10:00:00	SPY	ETF	146.71	146.86	146.61	146.805	12932254.0
2013-01-11 11:00:00	SPY	ETF	146.81	146.98	146.67	146.94	8740087.0
2013-01-11 12:00:00	SPY	ETF	146.94	146.96	146.76	146.845	5831843.0
2013-01-11 13:00:00	SPY	ETF	146.845	146.93	146.695	146.755	6877608.0
2013-01-11 14:00:00	SPY	ETF	146.75	146.98	146.74	146.91	9738672.0
2013-01-11 15:00:00	SPY	ETF	146.91	147.15	146.79	147.11	23755694.0
2013-01-11 16:00:00	SPY	ETF	147.12	147.12	146.8016	147.05	24123848.0
2013-01-11 17:00:00	SPY	ETF	147.05	147.14	147.04	147.11	65030.0
2013-01-11 18:00:00	SPY	ETF	147.11	147.15	147.08	147.12	15085.0
2013-01-11 19:00:00	SPY	ETF	147.13	147.15	147.08	147.1	10929.0
2013-01-11 04:00:00	QQQ	ETF	67.07	67.07	67.07	67.07	100.0
2013-01-11 06:00:00	QQQ	ETF	67.11	67.11	67.11	67.11	100.0
2013-01-11 07:00:00	QQQ	ETF	67.14	67.15	67.12	67.15	3000.0
2013-01-11 08:00:00	QQQ	ETF	67.13	67.16	67.09	67.1	42300.0
2013-01-11 09:00:00	QQQ	ETF	67.08	67.29	67.07	67.08	3106270.0
2013-01-11 10:00:00	QQQ	ETF	67.07	67.14	67.01	67.09	3671847.0
2013-01-11 11:00:00	QQQ	ETF	67.09	67.18	67.0	67.17	2116865.0
2013-01-11 12:00:00	QQQ	ETF	67.17	67.18	67.0897	67.13	1777999.0
2013-01-11 13:00:00	QQQ	ETF	67.13	67.24	67.0999	67.14	1299130.0
2013-01-11 14:00:00	QQQ	ETF	67.15	67.27	67.12	67.229	1490371.0
2013-01-11 15:00:00	QQQ	ETF	67.23	67.28	67.13	67.26	4335870.0
2013-01-11 16:00:00	QQQ	ETF	67.26	67.29	67.1591	67.24	2144774.0
2013-01-11 17:00:00	QQQ	ETF	67.25	67.29	67.24	67.25	11107.0
2013-01-11 18:00:00	QQQ	ETF	67.25	67.25	67.24	67.25	1946.0
2013-01-11 19:00:00	QQQ	ETF	67.27	67.27	67.23	67.23	1414.0
2013-01-11 04:00:00	IWM	ETF	87.47	87.47	87.47	87.47	100.0
2013-01-11 06:00:00	IWM	ETF	87.36	87.39	87.35	87.35	5350.0
2013-01-11 07:00:00	IWM	ETF	87.35	87.42	87.35	87.42	2900.0
2013-01-11 08:00:00	IWM	ETF	87.39	87.44	87.35	87.36	66903.0
2013-01-11 09:00:00	IWM	ETF	87.37	87.54	87.2	87.22	3567580.0
2013-01-11 10:00:00	IWM	ETF	87.23	87.3	87.1	87.23	4517562.0
2013-01-11 11:00:00	IWM	ETF	87.2299	87.32	87.0	87.2299	2521701.0
2013-01-11 12:00:00	IWM	ETF	87.25	87.3	87.11	87.18	1348581.0
2013-01-11 13:00:00	IWM	ETF	87.185	87.32	87.15	87.17	1452413.0
2013-01-11 14:00:00	IWM	ETF	87.17	87.39	87.17	87.29	1425513.0
2013-01-11 15:00:00	IWM	ETF	87.29	87.5	87.2115	87.34	5446120.0
2013-01-11 16:00:00	IWM	ETF	87.35	87.4579	87.3094	87.32	3147194.0
2013-01-11 17:00:00	IWM	ETF	87.32	87.32	87.3	87.3	76200.0
2013-01-11 18:00:00	IWM	ETF	87.34	87.34	87.34	87.34	100.0
2013-01-11 04:00:00	DIA	ETF	134.51	134.51	134.45	134.45	5800.0
2013-01-11 07:00:00	DIA	ETF	134.49	134.49	134.47	134.47	200.0
2013-01-11 08:00:00	DIA	ETF	134.41	134.54	134.38	134.45	6389.0
2013-01-11 09:00:00	DIA	ETF	134.42	134.49	134.21	134.26	537600.0
2013-01-11 10:00:00	DIA	ETF	134.26	134.47	134.2499	134.43	535943.0

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

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