PREVIEW / etf_1hour / 2014-03-07

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-03-07.parquet
  size:    216 KB
  rows:    6,809

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
2014-03-07 04:00:00	SPY	ETF	188.11	188.29	188.1	188.29	16529.0
2014-03-07 05:00:00	SPY	ETF	188.24	188.28	188.19	188.24	8850.0
2014-03-07 06:00:00	SPY	ETF	188.26	188.48	188.22	188.3	17400.0
2014-03-07 07:00:00	SPY	ETF	188.31	188.38	188.22	188.28	198667.0
2014-03-07 08:00:00	SPY	ETF	188.3	189.26	188.21	189.08	4912056.0
2014-03-07 09:00:00	SPY	ETF	189.06	189.1	187.9	188.18	19628961.0
2014-03-07 10:00:00	SPY	ETF	188.18	188.62	187.91	188.02	16334445.0
2014-03-07 11:00:00	SPY	ETF	188.03	188.2	187.43	188.135	17541624.0
2014-03-07 12:00:00	SPY	ETF	188.14	188.26	187.92	188.035	6538804.0
2014-03-07 13:00:00	SPY	ETF	188.03	188.06	187.67	187.92	6626915.0
2014-03-07 14:00:00	SPY	ETF	187.92	188.09	187.54	187.96	10831086.0
2014-03-07 15:00:00	SPY	ETF	187.97	188.22	187.69	188.21	17957713.0
2014-03-07 16:00:00	SPY	ETF	188.22	188.34	188.0	188.26	6957944.0
2014-03-07 17:00:00	SPY	ETF	188.26	188.28	188.18	188.24	133432.0
2014-03-07 18:00:00	SPY	ETF	188.21	188.24	188.18	188.21	12275.0
2014-03-07 19:00:00	SPY	ETF	188.2	188.25	188.2	188.21	24448.0
2014-03-07 04:00:00	QQQ	ETF	90.9	90.99	90.86	90.99	40650.0
2014-03-07 05:00:00	QQQ	ETF	90.97	90.97	90.97	90.97	200.0
2014-03-07 06:00:00	QQQ	ETF	91.02	91.08	91.01	91.04	4521.0
2014-03-07 07:00:00	QQQ	ETF	91.02	91.03	90.98	90.99	70000.0
2014-03-07 08:00:00	QQQ	ETF	91.0	91.4	90.9	91.3	598288.0
2014-03-07 09:00:00	QQQ	ETF	91.3	91.36	90.36	90.54	6747138.0
2014-03-07 10:00:00	QQQ	ETF	90.54	90.78	90.41	90.48	5389361.0
2014-03-07 11:00:00	QQQ	ETF	90.48	90.5	90.12	90.47	5029362.0
2014-03-07 12:00:00	QQQ	ETF	90.475	90.475	90.321	90.33	1371548.0
2014-03-07 13:00:00	QQQ	ETF	90.33	90.35	90.071	90.32	1787657.0
2014-03-07 14:00:00	QQQ	ETF	90.3199	90.35	90.1	90.3	2132764.0
2014-03-07 15:00:00	QQQ	ETF	90.3	90.52	90.205	90.52	3969895.0
2014-03-07 16:00:00	QQQ	ETF	90.52	90.5845	90.398	90.52	1692877.0
2014-03-07 17:00:00	QQQ	ETF	90.53	90.53	90.47	90.47	1742.0
2014-03-07 18:00:00	QQQ	ETF	90.47	90.47	90.47	90.47	2000.0
2014-03-07 19:00:00	QQQ	ETF	90.49	90.51	90.42	90.42	3458.0
2014-03-07 06:00:00	IWM	ETF	119.85	119.85	119.85	119.85	1100.0
2014-03-07 07:00:00	IWM	ETF	119.75	119.9	119.75	119.85	59300.0
2014-03-07 08:00:00	IWM	ETF	119.83	120.64	119.78	120.5	1373684.0
2014-03-07 09:00:00	IWM	ETF	120.53	120.53	119.18	119.41	7728135.0
2014-03-07 10:00:00	IWM	ETF	119.41	119.9	119.19	119.48	5659926.0
2014-03-07 11:00:00	IWM	ETF	119.47	119.6	119.025	119.57	4634654.0
2014-03-07 12:00:00	IWM	ETF	119.57	119.72	119.41	119.48	1620072.0
2014-03-07 13:00:00	IWM	ETF	119.48	119.5	119.27	119.4	2487857.0
2014-03-07 14:00:00	IWM	ETF	119.39	119.47	119.05	119.4	2800814.0
2014-03-07 15:00:00	IWM	ETF	119.4	119.66	119.26	119.66	5218733.0
2014-03-07 16:00:00	IWM	ETF	119.66	119.84	119.59	119.7	1980874.0
2014-03-07 17:00:00	IWM	ETF	119.68	119.68	119.65	119.65	20799.0
2014-03-07 18:00:00	IWM	ETF	119.65	119.7	119.65	119.65	9391.0
2014-03-07 19:00:00	IWM	ETF	119.65	119.65	119.65	119.65	900.0
2014-03-07 08:00:00	DIA	ETF	164.34	164.98	164.34	164.93	24257.0
2014-03-07 09:00:00	DIA	ETF	164.9	164.9	164.19	164.48	1042149.0
2014-03-07 10:00:00	DIA	ETF	164.47	164.89	164.23	164.39	1415545.0
2014-03-07 11:00:00	DIA	ETF	164.4	164.45	163.94	164.3849	1222349.0

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

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