PREVIEW / stock_1hour / 2013-04-19

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-04-19.parquet
  size:    960 KB
  rows:    44,806
  symbols: 3,473

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-04-19 04:00:00	AAPL	Stock	14.0264	14.0536	14.0264	14.0536	36400.0
2013-04-19 05:00:00	AAPL	Stock	14.0557	14.0679	14.0486	14.0679	28896.0
2013-04-19 06:00:00	AAPL	Stock	14.0779	14.0796	14.0486	14.0796	47208.0
2013-04-19 07:00:00	AAPL	Stock	14.0607	14.0786	14.0361	14.0361	456260.0
2013-04-19 08:00:00	AAPL	Stock	14.0507	14.0714	13.9471	13.9721	2318624.0
2013-04-19 09:00:00	AAPL	Stock	13.9725	13.9871	13.7536	13.9857	146203876.0
2013-04-19 10:00:00	AAPL	Stock	13.9854	14.2232	13.9757	14.1543	133337932.0
2013-04-19 11:00:00	AAPL	Stock	14.1543	14.2714	14.1518	14.17	75933816.0
2013-04-19 12:00:00	AAPL	Stock	14.17	14.1986	14.0739	14.114	43510600.0
2013-04-19 13:00:00	AAPL	Stock	14.1143	14.1161	14.0211	14.0621	43203524.0
2013-04-19 14:00:00	AAPL	Stock	14.0621	14.1261	13.9982	14.0061	49735504.0
2013-04-19 15:00:00	AAPL	Stock	14.0096	14.0418	13.9446	13.9525	85792896.0
2013-04-19 16:00:00	AAPL	Stock	13.9461	14.1956	13.93	13.9318	16672600.0
2013-04-19 17:00:00	AAPL	Stock	13.9346	13.9407	13.93	13.9311	418852.0
2013-04-19 18:00:00	AAPL	Stock	13.93	13.9325	13.9214	13.9268	264936.0
2013-04-19 19:00:00	AAPL	Stock	13.9282	13.9321	13.9239	13.9321	230216.0
2013-04-19 04:00:00	MSFT	Stock	29.62	29.62	29.55	29.55	620.0
2013-04-19 06:00:00	MSFT	Stock	29.5	29.55	29.5	29.5	4000.0
2013-04-19 07:00:00	MSFT	Stock	29.5	29.55	29.38	29.51	86544.0
2013-04-19 08:00:00	MSFT	Stock	29.5	29.76	29.2	29.7	1014028.0
2013-04-19 09:00:00	MSFT	Stock	29.7	30.24	29.62	29.925	35149069.0
2013-04-19 10:00:00	MSFT	Stock	29.925	30.055	29.74	29.882	15847020.0
2013-04-19 11:00:00	MSFT	Stock	29.89	29.9	29.67	29.717	8181071.0
2013-04-19 12:00:00	MSFT	Stock	29.72	29.81	29.62	29.65	8328110.0
2013-04-19 13:00:00	MSFT	Stock	29.642	29.77	29.61	29.705	4903226.0
2013-04-19 14:00:00	MSFT	Stock	29.7	29.8	29.68	29.68	5677661.0
2013-04-19 15:00:00	MSFT	Stock	29.68	29.84	29.68	29.76	11666001.0
2013-04-19 16:00:00	MSFT	Stock	29.77	29.838	29.68	29.69	4179980.0
2013-04-19 17:00:00	MSFT	Stock	29.77	29.77	29.72	29.72	653800.0
2013-04-19 18:00:00	MSFT	Stock	29.73	29.73	29.73	29.73	500.0
2013-04-19 19:00:00	MSFT	Stock	29.73	29.75	29.7	29.75	2886.0
2013-04-19 09:00:00	NVDA	Stock	0.3133	0.314	0.3093	0.3123	52086800.0
2013-04-19 10:00:00	NVDA	Stock	0.3123	0.3151	0.312	0.3135	40630800.0
2013-04-19 11:00:00	NVDA	Stock	0.3135	0.3149	0.3128	0.3135	19591800.0
2013-04-19 12:00:00	NVDA	Stock	0.3138	0.3143	0.3125	0.3125	13682640.0
2013-04-19 13:00:00	NVDA	Stock	0.3125	0.313	0.3118	0.3118	33606160.0
2013-04-19 14:00:00	NVDA	Stock	0.3119	0.3128	0.3115	0.3115	36135560.0
2013-04-19 15:00:00	NVDA	Stock	0.3115	0.3145	0.311	0.314	95572960.0
2013-04-19 16:00:00	NVDA	Stock	0.3143	0.3143	0.3128	0.3128	10459520.0
2013-04-19 19:00:00	NVDA	Stock	0.3128	0.3128	0.3128	0.3128	4000.0
2013-04-19 04:00:00	AMZN	Stock	13.0005	13.0005	13.0005	13.0005	2000.0
2013-04-19 07:00:00	AMZN	Stock	13.065	13.07	13.0455	13.0475	37000.0
2013-04-19 08:00:00	AMZN	Stock	13.07	13.07	12.966	13.043	260760.0
2013-04-19 09:00:00	AMZN	Stock	13.05	13.0575	12.875	12.96	12544360.0
2013-04-19 10:00:00	AMZN	Stock	12.9668	13.1085	12.9668	13.068	11184320.0
2013-04-19 11:00:00	AMZN	Stock	13.07	13.144	13.0525	13.1	4505900.0
2013-04-19 12:00:00	AMZN	Stock	13.1	13.106	13.0044	13.0247	3424320.0
2013-04-19 13:00:00	AMZN	Stock	13.024	13.035	12.9615	12.9825	3432620.0
2013-04-19 14:00:00	AMZN	Stock	12.9855	13.05	12.9848	13.006	4502700.0
2013-04-19 15:00:00	AMZN	Stock	13.0065	13.031	12.978	13.016	8645160.0

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

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