PREVIEW / etf_1hour / 2013-03-05

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-03-05.parquet
  size:    204 KB
  rows:    6,357

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-03-05 04:00:00	SPY	ETF	153.42	153.45	153.3	153.43	91037.0
2013-03-05 05:00:00	SPY	ETF	153.44	153.44	153.31	153.39	120010.0
2013-03-05 06:00:00	SPY	ETF	153.34	153.41	153.27	153.36	10690.0
2013-03-05 07:00:00	SPY	ETF	153.37	153.43	153.32	153.38	539834.0
2013-03-05 08:00:00	SPY	ETF	153.37	153.72	153.36	153.64	1416889.0
2013-03-05 09:00:00	SPY	ETF	153.65	154.09	153.62	153.96	18363579.0
2013-03-05 10:00:00	SPY	ETF	153.965	154.56	153.94	154.42	24134888.0
2013-03-05 11:00:00	SPY	ETF	154.42	154.6	154.27	154.465	12238218.0
2013-03-05 12:00:00	SPY	ETF	154.47	154.57	154.31	154.43	7327326.0
2013-03-05 13:00:00	SPY	ETF	154.43	154.7	154.33	154.3701	9640417.0
2013-03-05 14:00:00	SPY	ETF	154.37	154.47	154.17	154.335	9661233.0
2013-03-05 15:00:00	SPY	ETF	154.33	154.52	154.08	154.31	24995433.0
2013-03-05 16:00:00	SPY	ETF	154.29	154.3891	152.8386	154.33	10446333.0
2013-03-05 17:00:00	SPY	ETF	154.35	154.4	154.35	154.39	226006.0
2013-03-05 18:00:00	SPY	ETF	154.37	154.37	154.29	154.33	76176.0
2013-03-05 19:00:00	SPY	ETF	154.34	154.34	154.17	154.28	202355.0
2013-03-05 04:00:00	QQQ	ETF	67.86	67.86	67.86	67.86	200.0
2013-03-05 05:00:00	QQQ	ETF	67.92	67.92	67.9	67.9	671.0
2013-03-05 06:00:00	QQQ	ETF	67.94	67.94	67.94	67.94	100.0
2013-03-05 07:00:00	QQQ	ETF	67.94	68.01	67.94	68.0	84482.0
2013-03-05 08:00:00	QQQ	ETF	67.98	68.09	67.97	68.06	203914.0
2013-03-05 09:00:00	QQQ	ETF	68.06	68.43	68.05	68.28	5677546.0
2013-03-05 10:00:00	QQQ	ETF	68.29	68.66	68.27	68.51	6566258.0
2013-03-05 11:00:00	QQQ	ETF	68.505	68.77	68.47	68.72	3547956.0
2013-03-05 12:00:00	QQQ	ETF	68.73	68.77	68.6	68.6255	1416308.0
2013-03-05 13:00:00	QQQ	ETF	68.62	68.77	68.54	68.554	3234348.0
2013-03-05 14:00:00	QQQ	ETF	68.56	68.65	68.45	68.51	2025933.0
2013-03-05 15:00:00	QQQ	ETF	68.51	68.72	68.43	68.68	6536643.0
2013-03-05 16:00:00	QQQ	ETF	68.68	68.69	67.6872	68.67	5185546.0
2013-03-05 17:00:00	QQQ	ETF	68.68	68.76	68.68	68.72	14119.0
2013-03-05 18:00:00	QQQ	ETF	68.7	68.71	68.7	68.71	2684.0
2013-03-05 19:00:00	QQQ	ETF	68.7	68.72	68.66	68.72	6895.0
2013-03-05 07:00:00	IWM	ETF	91.39	91.45	91.39	91.41	51200.0
2013-03-05 08:00:00	IWM	ETF	91.25	91.67	91.25	91.65	286575.0
2013-03-05 09:00:00	IWM	ETF	91.65	92.05	91.59	91.969	5283835.0
2013-03-05 10:00:00	IWM	ETF	91.98	92.35	91.93	92.19	6857675.0
2013-03-05 11:00:00	IWM	ETF	92.195	92.25	91.96	92.08	3868361.0
2013-03-05 12:00:00	IWM	ETF	92.07	92.14	91.94	92.12	2118392.0
2013-03-05 13:00:00	IWM	ETF	92.11	92.32	92.03	92.06	3170282.0
2013-03-05 14:00:00	IWM	ETF	92.06	92.16	91.9399	92.04	2322176.0
2013-03-05 15:00:00	IWM	ETF	92.05	92.27	91.96	92.2	7332848.0
2013-03-05 16:00:00	IWM	ETF	92.19	92.27	91.99	92.19	2068901.0
2013-03-05 17:00:00	IWM	ETF	92.19	92.22	92.19	92.22	26371.0
2013-03-05 18:00:00	IWM	ETF	92.18	92.2	92.18	92.2	600.0
2013-03-05 19:00:00	IWM	ETF	92.15	92.2	92.15	92.2	3000.0
2013-03-05 04:00:00	DIA	ETF	141.34	141.34	141.34	141.34	100.0
2013-03-05 08:00:00	DIA	ETF	141.45	141.7	141.45	141.62	17145.0
2013-03-05 09:00:00	DIA	ETF	141.63	142.17	141.63	142.1399	1592138.0
2013-03-05 10:00:00	DIA	ETF	142.14	142.68	142.111	142.57	1656814.0
2013-03-05 11:00:00	DIA	ETF	142.57	142.68	142.43	142.53	758678.0

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

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