PREVIEW / etf_1hour / 2013-01-17

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-01-17.parquet
  size:    196 KB
  rows:    6,143

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-17 04:00:00	SPY	ETF	146.85	147.03	146.85	147.03	5300.0
2013-01-17 05:00:00	SPY	ETF	146.91	147.03	146.91	147.03	5480.0
2013-01-17 06:00:00	SPY	ETF	146.96	147.13	146.96	147.09	36376.0
2013-01-17 07:00:00	SPY	ETF	147.17	147.26	147.15	147.2	295246.0
2013-01-17 08:00:00	SPY	ETF	147.17	147.97	147.07	147.76	3088806.0
2013-01-17 09:00:00	SPY	ETF	147.76	147.82	147.05	147.66	16741721.0
2013-01-17 10:00:00	SPY	ETF	147.66	147.86	147.23	147.64	20758286.0
2013-01-17 11:00:00	SPY	ETF	147.65	147.96	147.63	147.805	9582518.0
2013-01-17 12:00:00	SPY	ETF	147.805	148.14	147.8	148.0385	11453297.0
2013-01-17 13:00:00	SPY	ETF	148.035	148.3	147.98	148.26	13898464.0
2013-01-17 14:00:00	SPY	ETF	148.26	148.42	148.19	148.24	13519523.0
2013-01-17 15:00:00	SPY	ETF	148.24	148.29	147.92	147.92	21700311.0
2013-01-17 16:00:00	SPY	ETF	147.93	148.33	147.1446	147.89	12051593.0
2013-01-17 17:00:00	SPY	ETF	147.89	147.94	147.87	147.93	6985390.0
2013-01-17 18:00:00	SPY	ETF	147.93	147.93	147.81	147.85	193237.0
2013-01-17 19:00:00	SPY	ETF	147.84	147.9	147.82	147.89	67208.0
2013-01-17 06:00:00	QQQ	ETF	66.93	66.95	66.93	66.95	7000.0
2013-01-17 07:00:00	QQQ	ETF	67.0	67.04	67.0	67.03	8900.0
2013-01-17 08:00:00	QQQ	ETF	67.02	67.27	67.01	67.22	450929.0
2013-01-17 09:00:00	QQQ	ETF	67.21	67.26	67.06	67.19	3410528.0
2013-01-17 10:00:00	QQQ	ETF	67.17	67.35	67.07	67.11	8449505.0
2013-01-17 11:00:00	QQQ	ETF	67.12	67.3	67.1	67.18	1954108.0
2013-01-17 12:00:00	QQQ	ETF	67.18	67.31	67.18	67.27	1730205.0
2013-01-17 13:00:00	QQQ	ETF	67.27	67.43	67.2	67.4	3001861.0
2013-01-17 14:00:00	QQQ	ETF	67.4	67.48	67.32	67.3484	2437651.0
2013-01-17 15:00:00	QQQ	ETF	67.34	67.365	67.22	67.23	7654813.0
2013-01-17 16:00:00	QQQ	ETF	67.23	67.3169	67.09	67.1	2010129.0
2013-01-17 17:00:00	QQQ	ETF	67.09	67.14	67.05	67.07	48031.0
2013-01-17 18:00:00	QQQ	ETF	67.07	67.1	67.05	67.07	10331.0
2013-01-17 19:00:00	QQQ	ETF	67.08	67.12	67.07	67.11	5377.0
2013-01-17 04:00:00	IWM	ETF	87.41	87.41	87.41	87.41	250.0
2013-01-17 07:00:00	IWM	ETF	87.61	87.61	87.54	87.56	42470.0
2013-01-17 08:00:00	IWM	ETF	87.56	88.02	87.51	87.89	943464.0
2013-01-17 09:00:00	IWM	ETF	87.89	88.11	87.83	88.08	3390636.0
2013-01-17 10:00:00	IWM	ETF	88.07	88.17	87.92	87.99	5110123.0
2013-01-17 11:00:00	IWM	ETF	87.99	88.3	87.98	88.24	3279306.0
2013-01-17 12:00:00	IWM	ETF	88.24	88.42	88.23	88.36	2740544.0
2013-01-17 13:00:00	IWM	ETF	88.36	88.4599	88.31	88.45	1782627.0
2013-01-17 14:00:00	IWM	ETF	88.45	88.51	88.36	88.39	2440339.0
2013-01-17 15:00:00	IWM	ETF	88.389	88.46	88.3	88.31	4910839.0
2013-01-17 16:00:00	IWM	ETF	88.31	88.38	87.5679	88.26	5507915.0
2013-01-17 17:00:00	IWM	ETF	88.3	88.35	88.26	88.26	29045.0
2013-01-17 18:00:00	IWM	ETF	88.28	88.28	88.24	88.24	1100.0
2013-01-17 19:00:00	IWM	ETF	88.3	88.3	88.25	88.28	1693.0
2013-01-17 08:00:00	DIA	ETF	134.95	135.44	134.95	135.32	16711.0
2013-01-17 09:00:00	DIA	ETF	135.41	135.43	135.23	135.43	557777.0
2013-01-17 10:00:00	DIA	ETF	135.41	135.655	135.26	135.529	1554857.0
2013-01-17 11:00:00	DIA	ETF	135.54	135.72	135.48	135.62	483889.0
2013-01-17 12:00:00	DIA	ETF	135.62	135.93	135.62	135.84	560104.0
2013-01-17 13:00:00	DIA	ETF	135.85	136.09	135.78	136.06	439661.0

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

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