PREVIEW / stock_1hour / 2013-03-05

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-03-05.parquet
  size:    1000 KB
  rows:    46,791
  symbols: 3,491

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	AAPL	Stock	14.9893	15.0	14.9496	14.9893	31724.0
2013-03-05 05:00:00	AAPL	Stock	14.995	15.0	14.9946	15.0	81844.0
2013-03-05 06:00:00	AAPL	Stock	15.0	15.0404	15.0	15.0357	106932.0
2013-03-05 07:00:00	AAPL	Stock	15.0246	15.1657	15.0246	15.0982	774536.0
2013-03-05 08:00:00	AAPL	Stock	15.0961	15.1546	14.9821	15.0821	3178196.0
2013-03-05 09:00:00	AAPL	Stock	15.0829	15.2232	15.0268	15.0868	102149376.0
2013-03-05 10:00:00	AAPL	Stock	15.0871	15.3625	15.0775	15.3296	129930836.0
2013-03-05 11:00:00	AAPL	Stock	15.331	15.5121	15.3282	15.4961	94408804.0
2013-03-05 12:00:00	AAPL	Stock	15.4946	15.5425	15.4471	15.4739	65927176.0
2013-03-05 13:00:00	AAPL	Stock	15.4714	15.4975	15.3857	15.4082	45493224.0
2013-03-05 14:00:00	AAPL	Stock	15.41	15.4521	15.2579	15.3	72131136.0
2013-03-05 15:00:00	AAPL	Stock	15.2996	15.4464	15.2686	15.4021	82007968.0
2013-03-05 16:00:00	AAPL	Stock	15.4021	15.4659	15.0018	15.45	27502916.0
2013-03-05 17:00:00	AAPL	Stock	15.45	15.4643	15.398	15.4246	626752.0
2013-03-05 18:00:00	AAPL	Stock	15.4243	15.4286	15.3989	15.4279	863436.0
2013-03-05 19:00:00	AAPL	Stock	15.4275	15.4339	15.4196	15.4336	372652.0
2013-03-05 04:00:00	MSFT	Stock	28.2	28.31	28.2	28.22	1700.0
2013-03-05 06:00:00	MSFT	Stock	28.31	28.31	28.26	28.26	5996.0
2013-03-05 07:00:00	MSFT	Stock	28.27	28.33	28.2	28.24	20208.0
2013-03-05 08:00:00	MSFT	Stock	28.2	28.27	28.1	28.2	45733.0
2013-03-05 09:00:00	MSFT	Stock	28.23	28.35	28.15	28.34	7400427.0
2013-03-05 10:00:00	MSFT	Stock	28.34	28.54	28.34	28.46	9203283.0
2013-03-05 11:00:00	MSFT	Stock	28.46	28.46	28.38	28.43	4515203.0
2013-03-05 12:00:00	MSFT	Stock	28.42	28.43	28.3	28.306	2904760.0
2013-03-05 13:00:00	MSFT	Stock	28.304	28.38	28.25	28.325	3985601.0
2013-03-05 14:00:00	MSFT	Stock	28.32	28.34	28.235	28.307	3539819.0
2013-03-05 15:00:00	MSFT	Stock	28.3	28.36	28.245	28.35	6399820.0
2013-03-05 16:00:00	MSFT	Stock	28.35	28.454	28.15	28.3	2556202.0
2013-03-05 17:00:00	MSFT	Stock	28.35	28.35	28.3	28.3	87970.0
2013-03-05 18:00:00	MSFT	Stock	28.33	28.33	28.31	28.31	1527.0
2013-03-05 19:00:00	MSFT	Stock	28.31	28.32	28.3	28.31	4517.0
2013-03-05 08:00:00	NVDA	Stock	0.3175	0.3175	0.3175	0.3175	9400.0
2013-03-05 09:00:00	NVDA	Stock	0.3163	0.32	0.3163	0.3168	39522520.0
2013-03-05 10:00:00	NVDA	Stock	0.317	0.319	0.3166	0.3168	46368800.0
2013-03-05 11:00:00	NVDA	Stock	0.3169	0.3195	0.3168	0.319	41210520.0
2013-03-05 12:00:00	NVDA	Stock	0.319	0.3193	0.3173	0.3178	23321120.0
2013-03-05 13:00:00	NVDA	Stock	0.3175	0.3184	0.3173	0.318	25331640.0
2013-03-05 14:00:00	NVDA	Stock	0.318	0.3193	0.318	0.3185	31014240.0
2013-03-05 15:00:00	NVDA	Stock	0.3186	0.3205	0.3185	0.3203	143924120.0
2013-03-05 16:00:00	NVDA	Stock	0.32	0.3201	0.3178	0.32	4916040.0
2013-03-05 17:00:00	NVDA	Stock	0.32	0.32	0.3185	0.3185	45040.0
2013-03-05 18:00:00	NVDA	Stock	0.32	0.32	0.32	0.32	68000.0
2013-03-05 19:00:00	NVDA	Stock	0.3188	0.3198	0.3188	0.3198	32000.0
2013-03-05 07:00:00	AMZN	Stock	13.6655	13.6655	13.656	13.657	14000.0
2013-03-05 08:00:00	AMZN	Stock	13.655	13.6775	13.6175	13.6725	355120.0
2013-03-05 09:00:00	AMZN	Stock	13.6725	13.725	13.505	13.5195	13375080.0
2013-03-05 10:00:00	AMZN	Stock	13.5195	13.6395	13.4995	13.572	16217300.0
2013-03-05 11:00:00	AMZN	Stock	13.5715	13.825	13.5695	13.7875	12642860.0
2013-03-05 12:00:00	AMZN	Stock	13.788	13.8125	13.729	13.7789	6241220.0
2013-03-05 13:00:00	AMZN	Stock	13.7775	13.834	13.7245	13.7359	5148240.0

> showing 50 of 46,791 rows — these rows as CSV

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