PREVIEW / stock_1hour / 2013-06-10

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-06-10.parquet
  size:    987 KB
  rows:    46,085
  symbols: 3,520

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-06-10 04:00:00	AAPL	Stock	15.8689	15.8757	15.8679	15.8757	22400.0
2013-06-10 05:00:00	AAPL	Stock	15.8925	15.8925	15.8757	15.8757	11200.0
2013-06-10 06:00:00	AAPL	Stock	15.8671	15.8929	15.8671	15.8686	37800.0
2013-06-10 07:00:00	AAPL	Stock	15.8793	15.8975	15.8586	15.8743	458976.0
2013-06-10 08:00:00	AAPL	Stock	15.8739	15.8918	15.7321	15.8304	5400696.0
2013-06-10 09:00:00	AAPL	Stock	15.8354	16.0154	15.825	15.9807	61117084.0
2013-06-10 10:00:00	AAPL	Stock	15.9811	15.9954	15.8789	15.9596	53540928.0
2013-06-10 11:00:00	AAPL	Stock	15.9571	16.0093	15.9254	15.9977	32813340.0
2013-06-10 12:00:00	AAPL	Stock	15.9971	16.0143	15.9507	15.9607	21269668.0
2013-06-10 13:00:00	AAPL	Stock	15.9625	16.0385	15.875	15.9321	54163956.0
2013-06-10 14:00:00	AAPL	Stock	15.9321	15.9464	15.775	15.8329	75244540.0
2013-06-10 15:00:00	AAPL	Stock	15.8286	15.8346	15.6	15.6686	120366232.0
2013-06-10 16:00:00	AAPL	Stock	15.6682	15.857	15.6429	15.6604	22930180.0
2013-06-10 17:00:00	AAPL	Stock	15.6571	15.6643	15.6475	15.6475	288680.0
2013-06-10 18:00:00	AAPL	Stock	15.6496	15.6564	15.6439	15.6468	120792.0
2013-06-10 19:00:00	AAPL	Stock	15.6468	15.6586	15.6457	15.6586	146664.0
2013-06-10 04:00:00	MSFT	Stock	35.75	35.75	35.75	35.75	100.0
2013-06-10 05:00:00	MSFT	Stock	35.68	35.7	35.68	35.7	300.0
2013-06-10 06:00:00	MSFT	Stock	35.68	35.7	35.68	35.7	1100.0
2013-06-10 07:00:00	MSFT	Stock	35.7	35.7	35.7	35.7	200.0
2013-06-10 08:00:00	MSFT	Stock	35.73	35.74	35.54	35.6	694391.0
2013-06-10 09:00:00	MSFT	Stock	35.61	35.64	35.36	35.55	4410812.0
2013-06-10 10:00:00	MSFT	Stock	35.545	35.65	35.401	35.5	5636437.0
2013-06-10 11:00:00	MSFT	Stock	35.49	35.56	35.432	35.448	3579393.0
2013-06-10 12:00:00	MSFT	Stock	35.45	35.47	35.33	35.34	4329168.0
2013-06-10 13:00:00	MSFT	Stock	35.34	35.36	35.14	35.27	5160796.0
2013-06-10 14:00:00	MSFT	Stock	35.26	35.45	35.19	35.39	3170132.0
2013-06-10 15:00:00	MSFT	Stock	35.39	35.47	35.36	35.47	6204769.0
2013-06-10 16:00:00	MSFT	Stock	35.47	35.688	35.21	35.47	2090076.0
2013-06-10 17:00:00	MSFT	Stock	35.43	35.47	35.43	35.43	400.0
2013-06-10 18:00:00	MSFT	Stock	35.45	35.45	35.43	35.43	3034.0
2013-06-10 19:00:00	MSFT	Stock	35.44	35.47	35.44	35.47	380.0
2013-06-10 08:00:00	NVDA	Stock	0.3575	0.3648	0.3575	0.3648	8000.0
2013-06-10 09:00:00	NVDA	Stock	0.361	0.363	0.3582	0.3604	25121360.0
2013-06-10 10:00:00	NVDA	Stock	0.3605	0.3632	0.359	0.3619	30093040.0
2013-06-10 11:00:00	NVDA	Stock	0.362	0.3625	0.3612	0.3612	23655680.0
2013-06-10 12:00:00	NVDA	Stock	0.3612	0.362	0.3608	0.361	15643560.0
2013-06-10 13:00:00	NVDA	Stock	0.3608	0.3618	0.3605	0.3616	15896480.0
2013-06-10 14:00:00	NVDA	Stock	0.3616	0.3628	0.3605	0.3626	24564680.0
2013-06-10 15:00:00	NVDA	Stock	0.3625	0.3628	0.3608	0.3612	75926680.0
2013-06-10 16:00:00	NVDA	Stock	0.361	0.3624	0.3609	0.361	12848200.0
2013-06-10 17:00:00	NVDA	Stock	0.3565	0.3565	0.3565	0.3565	21000.0
2013-06-10 18:00:00	NVDA	Stock	0.3565	0.3565	0.3565	0.3565	14000.0
2013-06-10 04:00:00	AMZN	Stock	13.8995	13.9	13.865	13.865	8000.0
2013-06-10 05:00:00	AMZN	Stock	13.865	13.865	13.865	13.865	2000.0
2013-06-10 06:00:00	AMZN	Stock	13.87	13.87	13.87	13.87	2000.0
2013-06-10 07:00:00	AMZN	Stock	13.875	13.875	13.825	13.8485	44000.0
2013-06-10 08:00:00	AMZN	Stock	13.8595	13.8845	13.75	13.8285	285640.0
2013-06-10 09:00:00	AMZN	Stock	13.823	13.9195	13.762	13.8595	10876740.0
2013-06-10 10:00:00	AMZN	Stock	13.8715	14.04	13.8185	13.992	12885660.0

> showing 50 of 46,085 rows — these rows as CSV

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