PREVIEW / stock_1hour / 2014-07-29

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-07-29.parquet
  size:    1.0 MB
  rows:    48,738
  symbols: 3,571

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
2014-07-29 04:00:00	AAPL	Stock	24.755	24.76	24.725	24.76	5000.0
2014-07-29 05:00:00	AAPL	Stock	24.725	24.725	24.725	24.725	10168.0
2014-07-29 06:00:00	AAPL	Stock	24.725	24.7875	24.705	24.7475	63076.0
2014-07-29 07:00:00	AAPL	Stock	24.7475	24.8175	24.745	24.8175	185208.0
2014-07-29 08:00:00	AAPL	Stock	24.815	24.87	24.7	24.85	1329604.0
2014-07-29 09:00:00	AAPL	Stock	24.8425	24.86	24.6375	24.6445	34251752.0
2014-07-29 10:00:00	AAPL	Stock	24.645	24.725	24.6175	24.6625	30803336.0
2014-07-29 11:00:00	AAPL	Stock	24.665	24.68	24.5625	24.63	21619908.0
2014-07-29 12:00:00	AAPL	Stock	24.63	24.665	24.6125	24.6375	12585640.0
2014-07-29 13:00:00	AAPL	Stock	24.635	24.7225	24.6225	24.7122	13783972.0
2014-07-29 14:00:00	AAPL	Stock	24.7125	24.7475	24.6475	24.675	14895880.0
2014-07-29 15:00:00	AAPL	Stock	24.675	24.695	24.5625	24.5975	25670852.0
2014-07-29 16:00:00	AAPL	Stock	24.595	24.673	24.5	24.58	5351408.0
2014-07-29 17:00:00	AAPL	Stock	24.58	24.595	24.57	24.5875	362264.0
2014-07-29 18:00:00	AAPL	Stock	24.5825	24.5975	24.575	24.575	258240.0
2014-07-29 19:00:00	AAPL	Stock	24.575	24.58	24.555	24.565	172600.0
2014-07-29 04:00:00	MSFT	Stock	43.8	43.8	43.8	43.8	200.0
2014-07-29 05:00:00	MSFT	Stock	43.85	43.85	43.76	43.76	1900.0
2014-07-29 06:00:00	MSFT	Stock	43.85	43.85	43.76	43.76	1530.0
2014-07-29 07:00:00	MSFT	Stock	43.77	43.77	43.73	43.73	3151.0
2014-07-29 08:00:00	MSFT	Stock	43.76	43.9	43.76	43.9	7965.0
2014-07-29 09:00:00	MSFT	Stock	43.95	43.99	43.72	43.85	3486423.0
2014-07-29 10:00:00	MSFT	Stock	43.85	44.04	43.82	43.875	4766933.0
2014-07-29 11:00:00	MSFT	Stock	43.88	43.945	43.64	43.895	3402951.0
2014-07-29 12:00:00	MSFT	Stock	43.9	43.99	43.87	43.975	2090844.0
2014-07-29 13:00:00	MSFT	Stock	43.98	44.01	43.88	44.0	1885977.0
2014-07-29 14:00:00	MSFT	Stock	44.01	44.09	43.86	43.98	3629386.0
2014-07-29 15:00:00	MSFT	Stock	43.98	44.01	43.88	43.89	5016568.0
2014-07-29 16:00:00	MSFT	Stock	43.885	43.984	43.8	43.85	2113915.0
2014-07-29 17:00:00	MSFT	Stock	43.88	43.885	43.85	43.885	8490.0
2014-07-29 19:00:00	MSFT	Stock	43.88	43.88	43.85	43.85	751.0
2014-07-29 08:00:00	NVDA	Stock	0.445	0.445	0.445	0.445	20000.0
2014-07-29 09:00:00	NVDA	Stock	0.4458	0.4505	0.443	0.448	36236880.0
2014-07-29 10:00:00	NVDA	Stock	0.4482	0.45	0.4468	0.4478	36948240.0
2014-07-29 11:00:00	NVDA	Stock	0.4476	0.4485	0.445	0.4475	18925520.0
2014-07-29 12:00:00	NVDA	Stock	0.4475	0.4488	0.4468	0.447	15806400.0
2014-07-29 13:00:00	NVDA	Stock	0.4471	0.449	0.4471	0.4482	18583680.0
2014-07-29 14:00:00	NVDA	Stock	0.4485	0.449	0.4465	0.4472	15305600.0
2014-07-29 15:00:00	NVDA	Stock	0.4472	0.4474	0.4442	0.4445	51630000.0
2014-07-29 16:00:00	NVDA	Stock	0.4445	0.447	0.4435	0.4444	21086800.0
2014-07-29 07:00:00	AMZN	Stock	16.0335	16.035	16.0335	16.035	4000.0
2014-07-29 08:00:00	AMZN	Stock	16.0205	16.077	16.0	16.0625	198160.0
2014-07-29 09:00:00	AMZN	Stock	16.0635	16.128	15.975	16.118	11146960.0
2014-07-29 10:00:00	AMZN	Stock	16.1195	16.145	16.066	16.0755	10459980.0
2014-07-29 11:00:00	AMZN	Stock	16.071	16.0975	16.0215	16.0755	7076540.0
2014-07-29 12:00:00	AMZN	Stock	16.0815	16.09	16.05	16.074	4291620.0
2014-07-29 13:00:00	AMZN	Stock	16.075	16.1	16.0525	16.094	3324400.0
2014-07-29 14:00:00	AMZN	Stock	16.0965	16.1	16.0266	16.048	5371280.0
2014-07-29 15:00:00	AMZN	Stock	16.0445	16.0525	16.0	16.0	8117180.0
2014-07-29 16:00:00	AMZN	Stock	16.0	16.0693	15.994	16.0295	2367140.0

> showing 50 of 48,738 rows — these rows as CSV

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