PREVIEW / stock_1hour / 2013-09-05

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-09-05.parquet
  size:    1008 KB
  rows:    46,497
  symbols: 3,506

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-09-05 04:00:00	AAPL	Stock	17.9107	17.9107	17.8571	17.875	197036.0
2013-09-05 05:00:00	AAPL	Stock	17.8929	17.8929	17.8725	17.8929	14224.0
2013-09-05 06:00:00	AAPL	Stock	17.8607	17.875	17.8571	17.875	19628.0
2013-09-05 07:00:00	AAPL	Stock	17.875	17.9204	17.8607	17.9	541996.0
2013-09-05 08:00:00	AAPL	Stock	17.9071	17.9204	17.8682	17.8929	2209592.0
2013-09-05 09:00:00	AAPL	Stock	17.8939	17.9032	17.7416	17.7679	56228676.0
2013-09-05 10:00:00	AAPL	Stock	17.7679	17.8025	17.7443	17.7511	38390828.0
2013-09-05 11:00:00	AAPL	Stock	17.7507	17.7818	17.7489	17.7621	17681020.0
2013-09-05 12:00:00	AAPL	Stock	17.7636	17.7636	17.63	17.6551	37411164.0
2013-09-05 13:00:00	AAPL	Stock	17.6586	17.7064	17.6525	17.6771	17453016.0
2013-09-05 14:00:00	AAPL	Stock	17.6664	17.6786	17.6525	17.6769	13406400.0
2013-09-05 15:00:00	AAPL	Stock	17.6757	17.69	17.6507	17.6879	31071460.0
2013-09-05 16:00:00	AAPL	Stock	17.6832	17.8213	17.6759	17.6882	17826704.0
2013-09-05 17:00:00	AAPL	Stock	17.7014	17.77	17.6882	17.7125	935508.0
2013-09-05 18:00:00	AAPL	Stock	17.7071	17.7171	17.7071	17.7143	181048.0
2013-09-05 19:00:00	AAPL	Stock	17.7193	17.75	17.7143	17.75	533624.0
2013-09-05 04:00:00	MSFT	Stock	31.2	31.27	31.2	31.27	460.0
2013-09-05 05:00:00	MSFT	Stock	31.27	31.31	31.27	31.3	2100.0
2013-09-05 06:00:00	MSFT	Stock	31.21	31.32	31.19	31.32	5058.0
2013-09-05 07:00:00	MSFT	Stock	31.29	31.29	31.22	31.26	19539.0
2013-09-05 08:00:00	MSFT	Stock	31.24	31.32	31.19	31.21	90226.0
2013-09-05 09:00:00	MSFT	Stock	31.21	31.31	30.95	31.3	15774649.0
2013-09-05 10:00:00	MSFT	Stock	31.3	31.321	31.18	31.22	13218302.0
2013-09-05 11:00:00	MSFT	Stock	31.224	31.36	31.22	31.35	9537093.0
2013-09-05 12:00:00	MSFT	Stock	31.36	31.44	31.33	31.415	9688232.0
2013-09-05 13:00:00	MSFT	Stock	31.415	31.43	31.35	31.37	3461335.0
2013-09-05 14:00:00	MSFT	Stock	31.365	31.42	31.36	31.42	4771644.0
2013-09-05 15:00:00	MSFT	Stock	31.42	31.43	31.22	31.23	10673853.0
2013-09-05 16:00:00	MSFT	Stock	31.24	31.441	31.2	31.24	2884532.0
2013-09-05 17:00:00	MSFT	Stock	31.27	31.28	31.225	31.25	139333.0
2013-09-05 18:00:00	MSFT	Stock	31.27	31.395	31.25	31.25	18234.0
2013-09-05 19:00:00	MSFT	Stock	31.24	31.27	31.24	31.27	2666.0
2013-09-05 09:00:00	NVDA	Stock	0.3715	0.3748	0.3708	0.3736	21610520.0
2013-09-05 10:00:00	NVDA	Stock	0.3738	0.375	0.373	0.3733	36611440.0
2013-09-05 11:00:00	NVDA	Stock	0.3733	0.3744	0.373	0.3741	24029960.0
2013-09-05 12:00:00	NVDA	Stock	0.3741	0.3745	0.3738	0.3738	14426080.0
2013-09-05 13:00:00	NVDA	Stock	0.3739	0.3743	0.373	0.373	13143840.0
2013-09-05 14:00:00	NVDA	Stock	0.373	0.374	0.373	0.3735	13779920.0
2013-09-05 15:00:00	NVDA	Stock	0.3734	0.3738	0.3725	0.3735	39393120.0
2013-09-05 16:00:00	NVDA	Stock	0.3735	0.3747	0.3725	0.3725	3807000.0
2013-09-05 17:00:00	NVDA	Stock	0.3722	0.3722	0.3722	0.3722	4000.0
2013-09-05 18:00:00	NVDA	Stock	0.3739	0.3739	0.3739	0.3739	1164000.0
2013-09-05 19:00:00	NVDA	Stock	0.3738	0.3738	0.3738	0.3738	4000.0
2013-09-05 07:00:00	AMZN	Stock	14.725	14.725	14.725	14.725	4000.0
2013-09-05 08:00:00	AMZN	Stock	14.7	14.7195	14.7	14.71	33180.0
2013-09-05 09:00:00	AMZN	Stock	14.6875	14.85	14.6605	14.8395	6819600.0
2013-09-05 10:00:00	AMZN	Stock	14.8394	14.847	14.707	14.7115	8731360.0
2013-09-05 11:00:00	AMZN	Stock	14.7155	14.734	14.655	14.6663	4116320.0
2013-09-05 12:00:00	AMZN	Stock	14.6665	14.678	14.6355	14.6635	2483640.0
2013-09-05 13:00:00	AMZN	Stock	14.665	14.7245	14.636	14.716	2472320.0

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

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