PREVIEW / etf_1hour / 2013-03-22

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-03-22.parquet
  size:    194 KB
  rows:    6,070

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-22 04:00:00	SPY	ETF	154.27	154.31	154.12	154.31	2200.0
2013-03-22 05:00:00	SPY	ETF	154.15	154.36	154.15	154.35	8228.0
2013-03-22 06:00:00	SPY	ETF	154.33	154.47	154.3	154.47	103663.0
2013-03-22 07:00:00	SPY	ETF	154.45	154.8	154.44	154.7	611526.0
2013-03-22 08:00:00	SPY	ETF	154.67	154.79	154.61	154.68	440955.0
2013-03-22 09:00:00	SPY	ETF	154.69	155.03	154.64	154.94	14035731.0
2013-03-22 10:00:00	SPY	ETF	154.945	155.36	154.9401	155.17	19679735.0
2013-03-22 11:00:00	SPY	ETF	155.17	155.48	155.13	155.22	13325628.0
2013-03-22 12:00:00	SPY	ETF	155.2199	155.3	155.06	155.26	10046818.0
2013-03-22 13:00:00	SPY	ETF	155.26	155.57	155.15	155.31	9121425.0
2013-03-22 14:00:00	SPY	ETF	155.3	155.41	155.22	155.3	6188707.0
2013-03-22 15:00:00	SPY	ETF	155.31	155.52	155.05	155.51	21452217.0
2013-03-22 16:00:00	SPY	ETF	155.52	155.71	155.34	155.65	6758459.0
2013-03-22 17:00:00	SPY	ETF	155.66	155.85	154.48	155.83	174502.0
2013-03-22 18:00:00	SPY	ETF	155.83	155.89	155.71	155.75	57273.0
2013-03-22 19:00:00	SPY	ETF	155.77	155.85	155.75	155.84	24032.0
2013-03-22 04:00:00	QQQ	ETF	67.97	67.97	67.97	67.97	200.0
2013-03-22 06:00:00	QQQ	ETF	68.01	68.01	68.01	68.01	100.0
2013-03-22 07:00:00	QQQ	ETF	68.07	68.17	68.07	68.14	27500.0
2013-03-22 08:00:00	QQQ	ETF	68.13	68.17	68.11	68.15	17770.0
2013-03-22 09:00:00	QQQ	ETF	68.16	68.29	68.13	68.215	4665290.0
2013-03-22 10:00:00	QQQ	ETF	68.2101	68.375	68.13	68.29	4243508.0
2013-03-22 11:00:00	QQQ	ETF	68.29	68.395	68.25	68.31	2432745.0
2013-03-22 12:00:00	QQQ	ETF	68.31	68.46	68.29	68.455	2155331.0
2013-03-22 13:00:00	QQQ	ETF	68.46	68.64	68.43	68.54	2642842.0
2013-03-22 14:00:00	QQQ	ETF	68.54	68.58	68.47	68.495	2555870.0
2013-03-22 15:00:00	QQQ	ETF	68.5	68.57	68.38	68.57	5609715.0
2013-03-22 16:00:00	QQQ	ETF	68.58	68.62	68.45	68.61	2235187.0
2013-03-22 17:00:00	QQQ	ETF	68.61	68.68	68.59	68.66	99230.0
2013-03-22 18:00:00	QQQ	ETF	68.68	68.71	68.66	68.7	5480.0
2013-03-22 19:00:00	QQQ	ETF	68.69	68.69	68.69	68.69	200.0
2013-03-22 07:00:00	IWM	ETF	94.07	94.16	94.07	94.14	106500.0
2013-03-22 08:00:00	IWM	ETF	94.1	94.14	94.05	94.14	35150.0
2013-03-22 09:00:00	IWM	ETF	94.12	94.37	94.0	94.14	3473562.0
2013-03-22 10:00:00	IWM	ETF	94.14	94.32	94.04	94.17	3993887.0
2013-03-22 11:00:00	IWM	ETF	94.16	94.26	94.0	94.0599	2947902.0
2013-03-22 12:00:00	IWM	ETF	94.06	94.11	93.94	94.06	2371281.0
2013-03-22 13:00:00	IWM	ETF	94.06	94.24	94.01	94.1	1939309.0
2013-03-22 14:00:00	IWM	ETF	94.11	94.2	94.06	94.14	6100653.0
2013-03-22 15:00:00	IWM	ETF	94.15	94.17	93.96	94.12	7433466.0
2013-03-22 16:00:00	IWM	ETF	94.13	94.33	94.11	94.31	1391399.0
2013-03-22 17:00:00	IWM	ETF	94.3	94.35	94.14	94.35	6945.0
2013-03-22 18:00:00	IWM	ETF	94.39	94.42	94.39	94.42	24882.0
2013-03-22 07:00:00	DIA	ETF	144.15	144.29	144.15	144.28	2400.0
2013-03-22 08:00:00	DIA	ETF	144.21	144.31	144.17	144.3	3600.0
2013-03-22 09:00:00	DIA	ETF	144.22	144.58	144.22	144.45	923055.0
2013-03-22 10:00:00	DIA	ETF	144.445	144.8	144.15	144.6	1058523.0
2013-03-22 11:00:00	DIA	ETF	144.59	144.87	144.57	144.63	601961.0
2013-03-22 12:00:00	DIA	ETF	144.64	144.71	144.5498	144.66	507992.0
2013-03-22 13:00:00	DIA	ETF	144.67	144.87	144.58	144.674	477577.0

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

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