PREVIEW / stock_1hour / 2011-01-20

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-01-20.parquet
  size:    942 KB
  rows:    44,479
  symbols: 3,514

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
2011-01-20 04:00:00	AAPL	Stock	12.0736	12.0821	12.0696	12.0821	16800.0
2011-01-20 05:00:00	AAPL	Stock	12.0714	12.0771	12.0714	12.0714	56560.0
2011-01-20 06:00:00	AAPL	Stock	12.0707	12.0714	12.0429	12.0714	45920.0
2011-01-20 07:00:00	AAPL	Stock	12.0693	12.0936	12.0361	12.0532	678160.0
2011-01-20 08:00:00	AAPL	Stock	12.0536	12.0661	12.0179	12.0636	2238768.0
2011-01-20 09:00:00	AAPL	Stock	12.0621	12.0821	11.88	11.9393	146668676.0
2011-01-20 10:00:00	AAPL	Stock	11.9393	11.942	11.79	11.8411	213798452.0
2011-01-20 11:00:00	AAPL	Stock	11.8411	11.8814	11.8107	11.8279	73389512.0
2011-01-20 12:00:00	AAPL	Stock	11.8293	11.8875	11.8114	11.8782	68545596.0
2011-01-20 13:00:00	AAPL	Stock	11.8782	11.8807	11.8404	11.8742	43825908.0
2011-01-20 14:00:00	AAPL	Stock	11.8746	11.9457	11.86	11.9414	78200752.0
2011-01-20 15:00:00	AAPL	Stock	11.9414	11.9429	11.8625	11.8864	94806488.0
2011-01-20 16:00:00	AAPL	Stock	11.8875	11.9286	11.838	11.8946	27341776.0
2011-01-20 17:00:00	AAPL	Stock	11.8946	11.9977	11.8814	11.8886	1426656.0
2011-01-20 18:00:00	AAPL	Stock	11.8882	11.8929	11.8814	11.8839	522200.0
2011-01-20 19:00:00	AAPL	Stock	11.8832	11.8857	11.8611	11.8786	318332.0
2011-01-20 07:00:00	MSFT	Stock	28.45	28.47	28.36	28.36	1000.0
2011-01-20 08:00:00	MSFT	Stock	28.41	28.47	28.37	28.45	6978.0
2011-01-20 09:00:00	MSFT	Stock	28.45	28.55	28.23	28.31	7048142.0
2011-01-20 10:00:00	MSFT	Stock	28.31	28.38	28.13	28.17	8204376.0
2011-01-20 11:00:00	MSFT	Stock	28.18	28.26	28.15	28.22	6044777.0
2011-01-20 12:00:00	MSFT	Stock	28.225	28.3	28.205	28.275	4242018.0
2011-01-20 13:00:00	MSFT	Stock	28.28	28.31	28.18	28.299	4712625.0
2011-01-20 14:00:00	MSFT	Stock	28.3	28.4	28.25	28.32	5558854.0
2011-01-20 15:00:00	MSFT	Stock	28.33	28.39	28.21	28.36	9148844.0
2011-01-20 16:00:00	MSFT	Stock	28.35	28.4	28.255	28.35	11006738.0
2011-01-20 17:00:00	MSFT	Stock	28.36	28.36	28.35	28.35	1400.0
2011-01-20 18:00:00	MSFT	Stock	28.35	28.35	28.31	28.31	8272.0
2011-01-20 19:00:00	MSFT	Stock	28.31	28.31	28.31	28.31	100.0
2011-01-20 07:00:00	NVDA	Stock	0.555	0.555	0.5515	0.5538	68000.0
2011-01-20 08:00:00	NVDA	Stock	0.5528	0.5558	0.5445	0.5528	3086320.0
2011-01-20 09:00:00	NVDA	Stock	0.5555	0.5558	0.5448	0.554	177163360.0
2011-01-20 10:00:00	NVDA	Stock	0.5539	0.5608	0.5482	0.5505	252002360.0
2011-01-20 11:00:00	NVDA	Stock	0.5508	0.5548	0.546	0.5495	149556640.0
2011-01-20 12:00:00	NVDA	Stock	0.5495	0.5532	0.5472	0.553	108812200.0
2011-01-20 13:00:00	NVDA	Stock	0.5531	0.5561	0.5515	0.5558	103649240.0
2011-01-20 14:00:00	NVDA	Stock	0.5558	0.564	0.5555	0.5628	132588160.0
2011-01-20 15:00:00	NVDA	Stock	0.5628	0.563	0.5551	0.5605	169865160.0
2011-01-20 16:00:00	NVDA	Stock	0.5605	0.5642	0.5538	0.561	13086920.0
2011-01-20 17:00:00	NVDA	Stock	0.5595	0.561	0.5595	0.56	70000.0
2011-01-20 18:00:00	NVDA	Stock	0.5595	0.561	0.5595	0.561	88400.0
2011-01-20 19:00:00	NVDA	Stock	0.5568	0.5568	0.5568	0.5568	160000.0
2011-01-20 04:00:00	AMZN	Stock	9.3485	9.3485	9.3485	9.3485	2000.0
2011-01-20 06:00:00	AMZN	Stock	9.3025	9.317	9.3025	9.317	4000.0
2011-01-20 07:00:00	AMZN	Stock	9.297	9.31	9.297	9.31	10000.0
2011-01-20 08:00:00	AMZN	Stock	9.28	9.3045	9.26	9.299	41000.0
2011-01-20 09:00:00	AMZN	Stock	9.28	9.3425	9.233	9.2855	14505980.0
2011-01-20 10:00:00	AMZN	Stock	9.288	9.2945	9.1275	9.141	21116060.0
2011-01-20 11:00:00	AMZN	Stock	9.1402	9.1685	9.0645	9.0789	13455660.0
2011-01-20 12:00:00	AMZN	Stock	9.078	9.141	9.077	9.1395	6907480.0

> showing 50 of 44,479 rows — these rows as CSV

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