PREVIEW / stock_1hour / 2013-11-05

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-11-05.parquet
  size:    1.0 MB
  rows:    47,198
  symbols: 3,546

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-11-05 04:00:00	AAPL	Stock	18.7786	18.7786	18.7143	18.7321	36400.0
2013-11-05 05:00:00	AAPL	Stock	18.7254	18.7339	18.7254	18.7339	28784.0
2013-11-05 06:00:00	AAPL	Stock	18.7321	18.7518	18.7321	18.7518	21728.0
2013-11-05 07:00:00	AAPL	Stock	18.7464	18.7843	18.7464	18.7589	218120.0
2013-11-05 08:00:00	AAPL	Stock	18.7643	18.8036	18.725	18.7393	1608796.0
2013-11-05 09:00:00	AAPL	Stock	18.7393	18.8887	18.7239	18.7743	46888240.0
2013-11-05 10:00:00	AAPL	Stock	18.7811	18.7975	18.6786	18.7843	45749452.0
2013-11-05 11:00:00	AAPL	Stock	18.7854	18.7996	18.7414	18.7554	23411556.0
2013-11-05 12:00:00	AAPL	Stock	18.7532	18.7946	18.7118	18.775	24434760.0
2013-11-05 13:00:00	AAPL	Stock	18.7711	18.81	18.7629	18.7725	14679560.0
2013-11-05 14:00:00	AAPL	Stock	18.7693	18.8557	18.7643	18.8146	21723268.0
2013-11-05 15:00:00	AAPL	Stock	18.8154	18.83	18.7468	18.7707	39338236.0
2013-11-05 16:00:00	AAPL	Stock	18.7711	18.8125	18.755	18.7696	10903256.0
2013-11-05 17:00:00	AAPL	Stock	18.7696	18.7843	18.7696	18.7786	673568.0
2013-11-05 18:00:00	AAPL	Stock	18.7768	18.7768	18.7696	18.7746	79380.0
2013-11-05 19:00:00	AAPL	Stock	18.7696	18.7764	18.765	18.7764	122696.0
2013-11-05 07:00:00	MSFT	Stock	35.87	35.87	35.84	35.84	981.0
2013-11-05 08:00:00	MSFT	Stock	35.9	35.98	35.9	35.91	3590.0
2013-11-05 09:00:00	MSFT	Stock	35.85	36.49	35.77	36.248	8255325.0
2013-11-05 10:00:00	MSFT	Stock	36.25	36.49	36.165	36.4	6634457.0
2013-11-05 11:00:00	MSFT	Stock	36.4	36.47	36.32	36.44	4803777.0
2013-11-05 12:00:00	MSFT	Stock	36.435	36.63	36.43	36.59	6801609.0
2013-11-05 13:00:00	MSFT	Stock	36.59	36.65	36.43	36.435	4000605.0
2013-11-05 14:00:00	MSFT	Stock	36.437	36.51	36.32	36.5	5917984.0
2013-11-05 15:00:00	MSFT	Stock	36.5	36.71	36.49	36.63	12070067.0
2013-11-05 16:00:00	MSFT	Stock	36.635	36.69	35.94	36.55	2126107.0
2013-11-05 17:00:00	MSFT	Stock	36.6	36.64	36.6	36.635	121434.0
2013-11-05 18:00:00	MSFT	Stock	36.64	36.7	36.64	36.7	20338.0
2013-11-05 19:00:00	MSFT	Stock	36.65	36.69	36.65	36.69	8200.0
2013-11-05 08:00:00	NVDA	Stock	0.3688	0.3688	0.3682	0.3682	38000.0
2013-11-05 09:00:00	NVDA	Stock	0.3682	0.3692	0.3642	0.3658	57840120.0
2013-11-05 10:00:00	NVDA	Stock	0.3659	0.3715	0.3648	0.3713	76117280.0
2013-11-05 11:00:00	NVDA	Stock	0.3713	0.3715	0.3688	0.3698	64742480.0
2013-11-05 12:00:00	NVDA	Stock	0.37	0.3715	0.369	0.3713	32185080.0
2013-11-05 13:00:00	NVDA	Stock	0.3714	0.3716	0.369	0.369	32188760.0
2013-11-05 14:00:00	NVDA	Stock	0.3692	0.37	0.3685	0.3689	43168000.0
2013-11-05 15:00:00	NVDA	Stock	0.3689	0.3703	0.3688	0.3698	96872880.0
2013-11-05 16:00:00	NVDA	Stock	0.37	0.3708	0.3692	0.3692	2730720.0
2013-11-05 17:00:00	NVDA	Stock	0.37	0.37	0.3675	0.3675	175000.0
2013-11-05 04:00:00	AMZN	Stock	17.875	17.875	17.875	17.875	2000.0
2013-11-05 08:00:00	AMZN	Stock	17.875	17.9	17.825	17.825	88640.0
2013-11-05 09:00:00	AMZN	Stock	17.83	17.945	17.742	17.8195	7074200.0
2013-11-05 10:00:00	AMZN	Stock	17.8335	17.9395	17.7475	17.9005	6853540.0
2013-11-05 11:00:00	AMZN	Stock	17.9115	17.934	17.8385	17.856	3029400.0
2013-11-05 12:00:00	AMZN	Stock	17.862	17.897	17.833	17.8452	3026840.0
2013-11-05 13:00:00	AMZN	Stock	17.847	17.9632	17.83	17.9286	3792580.0
2013-11-05 14:00:00	AMZN	Stock	17.9305	17.999	17.925	17.978	4314900.0
2013-11-05 15:00:00	AMZN	Stock	17.9818	18.0085	17.9435	17.9535	9099780.0
2013-11-05 16:00:00	AMZN	Stock	17.9585	17.994	17.8268	17.994	2742080.0
2013-11-05 17:00:00	AMZN	Stock	17.9585	17.9585	17.934	17.934	59040.0

> showing 50 of 47,198 rows — these rows as CSV

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