PREVIEW / stock_1hour / 2013-02-11

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-02-11.parquet
  size:    950 KB
  rows:    44,873
  symbols: 3,482

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-02-11 04:00:00	AAPL	Stock	17.0393	17.0893	17.0357	17.0804	111440.0
2013-02-11 05:00:00	AAPL	Stock	17.0718	17.0739	17.0464	17.0668	59640.0
2013-02-11 06:00:00	AAPL	Stock	17.0689	17.0714	17.0571	17.0696	47600.0
2013-02-11 07:00:00	AAPL	Stock	17.0696	17.0714	17.0021	17.0118	1115604.0
2013-02-11 08:00:00	AAPL	Stock	17.0096	17.0696	16.9636	17.0196	4147192.0
2013-02-11 09:00:00	AAPL	Stock	17.0186	17.1271	16.9018	17.1224	83684496.0
2013-02-11 10:00:00	AAPL	Stock	17.1185	17.2768	17.1136	17.2607	120139852.0
2013-02-11 11:00:00	AAPL	Stock	17.2607	17.3193	17.2243	17.2857	69057408.0
2013-02-11 12:00:00	AAPL	Stock	17.2868	17.2893	17.1357	17.2011	50486688.0
2013-02-11 13:00:00	AAPL	Stock	17.2011	17.2246	17.1482	17.1832	36782536.0
2013-02-11 14:00:00	AAPL	Stock	17.1846	17.2321	17.13	17.1341	36354276.0
2013-02-11 15:00:00	AAPL	Stock	17.1339	17.2107	17.0825	17.141	74672388.0
2013-02-11 16:00:00	AAPL	Stock	17.1404	17.1837	17.0186	17.0679	20540576.0
2013-02-11 17:00:00	AAPL	Stock	17.0646	17.105	17.0646	17.0861	977704.0
2013-02-11 18:00:00	AAPL	Stock	17.0861	17.0957	17.0679	17.0689	973476.0
2013-02-11 19:00:00	AAPL	Stock	17.0746	17.0775	17.0568	17.0568	342888.0
2013-02-11 07:00:00	MSFT	Stock	27.6	27.68	27.6	27.68	2705.0
2013-02-11 08:00:00	MSFT	Stock	27.67	27.68	27.53	27.66	61234.0
2013-02-11 09:00:00	MSFT	Stock	27.65	27.71	27.5	27.53	2995508.0
2013-02-11 10:00:00	MSFT	Stock	27.54	27.695	27.53	27.69	5551192.0
2013-02-11 11:00:00	MSFT	Stock	27.7	27.785	27.69	27.725	4281288.0
2013-02-11 12:00:00	MSFT	Stock	27.72	27.74	27.675	27.7	3200634.0
2013-02-11 13:00:00	MSFT	Stock	27.7	27.73	27.67	27.73	2504768.0
2013-02-11 14:00:00	MSFT	Stock	27.725	27.78	27.71	27.77	3056886.0
2013-02-11 15:00:00	MSFT	Stock	27.769	27.92	27.75	27.85	9379305.0
2013-02-11 16:00:00	MSFT	Stock	27.86	27.88	27.584	27.86	939849.0
2013-02-11 17:00:00	MSFT	Stock	27.86	27.88	27.84	27.84	2300.0
2013-02-11 18:00:00	MSFT	Stock	27.84	27.84	27.84	27.84	150.0
2013-02-11 19:00:00	MSFT	Stock	27.81	27.85	27.81	27.85	450.0
2013-02-11 08:00:00	NVDA	Stock	0.3123	0.3123	0.312	0.312	132400.0
2013-02-11 09:00:00	NVDA	Stock	0.312	0.312	0.3088	0.3095	39783760.0
2013-02-11 10:00:00	NVDA	Stock	0.3097	0.3148	0.3093	0.3145	127789840.0
2013-02-11 11:00:00	NVDA	Stock	0.3143	0.3154	0.3125	0.3145	68308120.0
2013-02-11 12:00:00	NVDA	Stock	0.3145	0.3153	0.3135	0.315	40515760.0
2013-02-11 13:00:00	NVDA	Stock	0.3151	0.3159	0.3145	0.3145	41143600.0
2013-02-11 14:00:00	NVDA	Stock	0.3147	0.3148	0.313	0.3135	22070680.0
2013-02-11 15:00:00	NVDA	Stock	0.3135	0.314	0.3128	0.3128	63023680.0
2013-02-11 16:00:00	NVDA	Stock	0.3128	0.3133	0.3125	0.313	4929320.0
2013-02-11 18:00:00	NVDA	Stock	0.3138	0.3138	0.3138	0.3138	4000.0
2013-02-11 19:00:00	NVDA	Stock	0.3128	0.3128	0.3128	0.3128	12000.0
2013-02-11 04:00:00	AMZN	Stock	13.1475	13.1475	13.1475	13.1475	2000.0
2013-02-11 05:00:00	AMZN	Stock	13.135	13.174	13.097	13.15	14000.0
2013-02-11 06:00:00	AMZN	Stock	13.115	13.115	13.115	13.115	2000.0
2013-02-11 07:00:00	AMZN	Stock	13.15	13.15	13.1245	13.1245	14000.0
2013-02-11 08:00:00	AMZN	Stock	13.1375	13.1375	13.1165	13.1175	48000.0
2013-02-11 09:00:00	AMZN	Stock	13.12	13.1625	12.9029	12.927	7634620.0
2013-02-11 10:00:00	AMZN	Stock	12.9225	12.9705	12.8755	12.936	15957540.0
2013-02-11 11:00:00	AMZN	Stock	12.936	12.954	12.861	12.928	10642420.0
2013-02-11 12:00:00	AMZN	Stock	12.928	12.9375	12.8485	12.8946	8377480.0
2013-02-11 13:00:00	AMZN	Stock	12.8999	12.9195	12.83	12.8586	5274500.0

> showing 50 of 44,873 rows — these rows as CSV

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