PREVIEW / stock_1hour / 2015-03-24

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-03-24.parquet
  size:    1.0 MB
  rows:    49,023
  symbols: 3,495

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
2015-03-24 04:00:00	AAPL	Stock	31.805	31.935	31.805	31.935	8400.0
2015-03-24 05:00:00	AAPL	Stock	31.8825	31.895	31.8625	31.895	1780.0
2015-03-24 06:00:00	AAPL	Stock	31.9125	31.925	31.9	31.92	16124.0
2015-03-24 07:00:00	AAPL	Stock	31.9025	31.92	31.87	31.8875	79940.0
2015-03-24 08:00:00	AAPL	Stock	31.8875	31.92	31.795	31.8425	479920.0
2015-03-24 09:00:00	AAPL	Stock	31.835	31.835	31.64	31.77	19299416.0
2015-03-24 10:00:00	AAPL	Stock	31.77	32.01	31.7658	31.9	28364580.0
2015-03-24 11:00:00	AAPL	Stock	31.9012	31.965	31.87	31.9025	13099592.0
2015-03-24 12:00:00	AAPL	Stock	31.9	31.9362	31.7825	31.7825	12775196.0
2015-03-24 13:00:00	AAPL	Stock	31.785	31.8688	31.74	31.79	10842220.0
2015-03-24 14:00:00	AAPL	Stock	31.7875	31.7875	31.6825	31.7262	12118536.0
2015-03-24 15:00:00	AAPL	Stock	31.7275	31.775	31.655	31.6725	16998684.0
2015-03-24 16:00:00	AAPL	Stock	31.6725	31.927	31.665	31.6875	7366680.0
2015-03-24 17:00:00	AAPL	Stock	31.6925	31.7075	31.6725	31.7	234704.0
2015-03-24 18:00:00	AAPL	Stock	31.7025	31.7198	31.6975	31.715	102668.0
2015-03-24 19:00:00	AAPL	Stock	31.7125	31.7275	31.7	31.7125	74908.0
2015-03-24 07:00:00	MSFT	Stock	42.92	43.0	42.92	43.0	225.0
2015-03-24 08:00:00	MSFT	Stock	42.96	42.96	42.9	42.91	3080.0
2015-03-24 09:00:00	MSFT	Stock	42.88	43.01	42.72	42.97	2774398.0
2015-03-24 10:00:00	MSFT	Stock	42.975	43.13	42.94	43.07	3495883.0
2015-03-24 11:00:00	MSFT	Stock	43.07	43.17	43.025	43.07	2624798.0
2015-03-24 12:00:00	MSFT	Stock	43.07	43.17	43.06	43.115	2332519.0
2015-03-24 13:00:00	MSFT	Stock	43.11	43.17	43.03	43.085	2261400.0
2015-03-24 14:00:00	MSFT	Stock	43.08	43.085	42.99	43.05	2420652.0
2015-03-24 15:00:00	MSFT	Stock	43.06	43.09	42.88	42.91	5398159.0
2015-03-24 16:00:00	MSFT	Stock	42.9	43.134	42.896	42.921	3316286.0
2015-03-24 17:00:00	MSFT	Stock	42.9	42.9	42.9	42.9	48340.0
2015-03-24 18:00:00	MSFT	Stock	42.94	42.94	42.9	42.9	9799.0
2015-03-24 19:00:00	MSFT	Stock	42.92	42.92	42.92	42.92	2000.0
2015-03-24 08:00:00	NVDA	Stock	0.5725	0.5735	0.57	0.5702	76000.0
2015-03-24 09:00:00	NVDA	Stock	0.5712	0.572	0.5632	0.5648	36747000.0
2015-03-24 10:00:00	NVDA	Stock	0.5649	0.5658	0.5635	0.5636	43591240.0
2015-03-24 11:00:00	NVDA	Stock	0.5638	0.565	0.5625	0.5629	36271800.0
2015-03-24 12:00:00	NVDA	Stock	0.5629	0.563	0.5588	0.5605	46037640.0
2015-03-24 13:00:00	NVDA	Stock	0.5602	0.5621	0.5595	0.5602	24988920.0
2015-03-24 14:00:00	NVDA	Stock	0.56	0.5605	0.5575	0.5582	23858840.0
2015-03-24 15:00:00	NVDA	Stock	0.5582	0.561	0.5582	0.5599	76349720.0
2015-03-24 16:00:00	NVDA	Stock	0.56	0.5618	0.5592	0.5616	31622040.0
2015-03-24 17:00:00	NVDA	Stock	0.56	0.56	0.56	0.56	958560.0
2015-03-24 18:00:00	NVDA	Stock	0.5588	0.56	0.5588	0.56	36000.0
2015-03-24 19:00:00	NVDA	Stock	0.56	0.56	0.56	0.56	12000.0
2015-03-24 04:00:00	AMZN	Stock	18.4715	18.4715	18.4715	18.4715	10000.0
2015-03-24 07:00:00	AMZN	Stock	18.7985	18.7985	18.756	18.756	18760.0
2015-03-24 08:00:00	AMZN	Stock	18.775	18.775	18.755	18.755	11000.0
2015-03-24 09:00:00	AMZN	Stock	18.751	18.762	18.6135	18.713	7284120.0
2015-03-24 10:00:00	AMZN	Stock	18.7155	18.7155	18.6166	18.6985	8273220.0
2015-03-24 11:00:00	AMZN	Stock	18.705	18.7415	18.6555	18.665	4834300.0
2015-03-24 12:00:00	AMZN	Stock	18.6615	18.7135	18.6555	18.682	4027860.0
2015-03-24 13:00:00	AMZN	Stock	18.6815	18.7355	18.6575	18.7015	3163580.0
2015-03-24 14:00:00	AMZN	Stock	18.6985	18.72	18.679	18.6832	3521460.0

> showing 50 of 49,023 rows — these rows as CSV

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