PREVIEW / stock_1hour / 2015-08-31

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-08-31.parquet
  size:    1.0 MB
  rows:    49,104
  symbols: 3,479

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-08-31 04:00:00	AAPL	Stock	28.375	28.375	27.975	27.99	133780.0
2015-08-31 05:00:00	AAPL	Stock	28.0	28.075	28.0	28.05	103612.0
2015-08-31 06:00:00	AAPL	Stock	28.05	28.15	28.0375	28.0775	77476.0
2015-08-31 07:00:00	AAPL	Stock	28.0875	28.1775	28.0625	28.1725	199488.0
2015-08-31 08:00:00	AAPL	Stock	28.1575	28.175	28.03	28.075	847240.0
2015-08-31 09:00:00	AAPL	Stock	28.065	28.3225	27.975	28.0925	25264824.0
2015-08-31 10:00:00	AAPL	Stock	28.095	28.3625	28.0075	28.2175	30306764.0
2015-08-31 11:00:00	AAPL	Stock	28.22	28.4675	28.13	28.4475	28871464.0
2015-08-31 12:00:00	AAPL	Stock	28.445	28.6325	28.4375	28.5175	27424812.0
2015-08-31 13:00:00	AAPL	Stock	28.515	28.5525	28.3125	28.3575	20657488.0
2015-08-31 14:00:00	AAPL	Stock	28.3625	28.455	28.0775	28.125	24810624.0
2015-08-31 15:00:00	AAPL	Stock	28.1228	28.3288	28.1175	28.1775	37859220.0
2015-08-31 16:00:00	AAPL	Stock	28.19	28.21	28.1408	28.1475	16033804.0
2015-08-31 17:00:00	AAPL	Stock	28.1625	28.1875	28.155	28.175	93948.0
2015-08-31 18:00:00	AAPL	Stock	28.1675	28.1725	28.1275	28.135	62664.0
2015-08-31 19:00:00	AAPL	Stock	28.13	28.135	28.0625	28.0625	111324.0
2015-08-31 07:00:00	MSFT	Stock	43.94	43.94	43.66	43.66	200.0
2015-08-31 08:00:00	MSFT	Stock	43.733	43.783	43.64	43.747	9220.0
2015-08-31 09:00:00	MSFT	Stock	43.74	43.93	43.25	43.28	2599151.0
2015-08-31 10:00:00	MSFT	Stock	43.28	43.66	43.1	43.42	3924436.0
2015-08-31 11:00:00	MSFT	Stock	43.41	43.84	43.22	43.765	3160624.0
2015-08-31 12:00:00	MSFT	Stock	43.77	43.93	43.72	43.84	1481983.0
2015-08-31 13:00:00	MSFT	Stock	43.85	43.93	43.57	43.62	2082312.0
2015-08-31 14:00:00	MSFT	Stock	43.63	43.66	43.28	43.35	3712805.0
2015-08-31 15:00:00	MSFT	Stock	43.35	43.58	43.3	43.51	7578250.0
2015-08-31 16:00:00	MSFT	Stock	43.52	43.526	43.41	43.515	7762744.0
2015-08-31 17:00:00	MSFT	Stock	43.49	43.49	43.41	43.41	7359.0
2015-08-31 18:00:00	MSFT	Stock	43.42	43.42	43.42	43.42	200.0
2015-08-31 19:00:00	MSFT	Stock	43.3	43.3	43.26	43.26	2800.0
2015-08-31 09:00:00	NVDA	Stock	0.5622	0.5698	0.5622	0.563	22477640.0
2015-08-31 10:00:00	NVDA	Stock	0.5632	0.5642	0.5596	0.5632	27068080.0
2015-08-31 11:00:00	NVDA	Stock	0.5632	0.5695	0.5612	0.568	25078480.0
2015-08-31 12:00:00	NVDA	Stock	0.568	0.5694	0.567	0.5672	17460560.0
2015-08-31 13:00:00	NVDA	Stock	0.5672	0.5678	0.564	0.565	17346880.0
2015-08-31 14:00:00	NVDA	Stock	0.5652	0.5662	0.5616	0.5622	19206120.0
2015-08-31 15:00:00	NVDA	Stock	0.5622	0.566	0.5618	0.5618	60962920.0
2015-08-31 16:00:00	NVDA	Stock	0.562	0.5622	0.561	0.5619	21170560.0
2015-08-31 18:00:00	NVDA	Stock	0.561	0.561	0.561	0.561	4000.0
2015-08-31 04:00:00	AMZN	Stock	25.6895	25.696	25.6895	25.696	6300.0
2015-08-31 05:00:00	AMZN	Stock	25.7	25.753	25.7	25.7525	20300.0
2015-08-31 06:00:00	AMZN	Stock	25.7465	25.75	25.7465	25.75	14300.0
2015-08-31 07:00:00	AMZN	Stock	25.75	25.775	25.75	25.775	6500.0
2015-08-31 08:00:00	AMZN	Stock	25.7	25.8175	25.7	25.7575	156220.0
2015-08-31 09:00:00	AMZN	Stock	25.76	25.9375	25.738	25.8048	6496640.0
2015-08-31 10:00:00	AMZN	Stock	25.7995	25.896	25.7075	25.825	5986240.0
2015-08-31 11:00:00	AMZN	Stock	25.825	25.86	25.71	25.8285	5486460.0
2015-08-31 12:00:00	AMZN	Stock	25.84	25.9285	25.7948	25.915	3370320.0
2015-08-31 13:00:00	AMZN	Stock	25.9095	25.9705	25.667	25.687	5881700.0
2015-08-31 14:00:00	AMZN	Stock	25.6908	25.725	25.4535	25.521	7903880.0
2015-08-31 15:00:00	AMZN	Stock	25.52	25.7585	25.5195	25.645	10015960.0

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

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