PREVIEW / stock_1hour / 2014-05-12

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-05-12.parquet
  size:    1.0 MB
  rows:    48,287
  symbols: 3,553

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-05-12 04:00:00	AAPL	Stock	20.9525	20.9643	20.9214	20.9521	30800.0
2014-05-12 05:00:00	AAPL	Stock	20.9464	20.9643	20.9464	20.9643	14000.0
2014-05-12 06:00:00	AAPL	Stock	20.9632	20.9946	20.9632	20.975	22400.0
2014-05-12 07:00:00	AAPL	Stock	20.9821	21.0321	20.9821	21.0143	191772.0
2014-05-12 08:00:00	AAPL	Stock	21.0004	21.0304	20.9125	20.9125	6220060.0
2014-05-12 09:00:00	AAPL	Stock	20.9861	21.0975	20.9679	21.095	35849212.0
2014-05-12 10:00:00	AAPL	Stock	21.095	21.1321	21.0539	21.1086	24031252.0
2014-05-12 11:00:00	AAPL	Stock	21.1086	21.1121	21.0364	21.0916	14843192.0
2014-05-12 12:00:00	AAPL	Stock	21.0936	21.1621	21.0918	21.1329	13542844.0
2014-05-12 13:00:00	AAPL	Stock	21.1339	21.1607	21.1257	21.1546	8509060.0
2014-05-12 14:00:00	AAPL	Stock	21.1541	21.1711	21.0982	21.1561	14023744.0
2014-05-12 15:00:00	AAPL	Stock	21.1571	21.2021	21.1429	21.1704	28466984.0
2014-05-12 16:00:00	AAPL	Stock	21.1725	21.1767	21.0899	21.1767	15275456.0
2014-05-12 17:00:00	AAPL	Stock	21.1657	21.1725	21.1536	21.1689	386316.0
2014-05-12 18:00:00	AAPL	Stock	21.1689	21.1725	21.1618	21.1668	327348.0
2014-05-12 19:00:00	AAPL	Stock	21.1696	21.1696	21.1661	21.1696	46844.0
2014-05-12 07:00:00	MSFT	Stock	39.75	39.83	39.75	39.83	4872.0
2014-05-12 08:00:00	MSFT	Stock	39.65	39.7	39.65	39.68	1900.0
2014-05-12 09:00:00	MSFT	Stock	39.7	39.97	39.65	39.96	3069880.0
2014-05-12 10:00:00	MSFT	Stock	39.96	39.99	39.845	39.87	2898027.0
2014-05-12 11:00:00	MSFT	Stock	39.87	39.97	39.86	39.94	2460792.0
2014-05-12 12:00:00	MSFT	Stock	39.94	40.02	39.93	39.951	2345800.0
2014-05-12 13:00:00	MSFT	Stock	39.955	40.0	39.91	39.92	1544957.0
2014-05-12 14:00:00	MSFT	Stock	39.92	40.0	39.89	39.98	1585026.0
2014-05-12 15:00:00	MSFT	Stock	39.985	40.02	39.91	39.95	4497523.0
2014-05-12 16:00:00	MSFT	Stock	39.97	40.04	39.928	40.0	2551521.0
2014-05-12 17:00:00	MSFT	Stock	39.97	40.1	39.97	40.08	50413.0
2014-05-12 18:00:00	MSFT	Stock	40.1	40.11	40.08	40.08	6970.0
2014-05-12 19:00:00	MSFT	Stock	40.1	40.1	40.09	40.1	3838.0
2014-05-12 09:00:00	NVDA	Stock	0.4522	0.4593	0.452	0.4585	21747080.0
2014-05-12 10:00:00	NVDA	Stock	0.4585	0.4618	0.4582	0.4601	42724240.0
2014-05-12 11:00:00	NVDA	Stock	0.4601	0.4628	0.4595	0.4618	35985640.0
2014-05-12 12:00:00	NVDA	Stock	0.462	0.4648	0.461	0.462	30967640.0
2014-05-12 13:00:00	NVDA	Stock	0.462	0.4625	0.4612	0.4622	21101680.0
2014-05-12 14:00:00	NVDA	Stock	0.4622	0.464	0.4612	0.464	17202480.0
2014-05-12 15:00:00	NVDA	Stock	0.464	0.4655	0.4639	0.4641	59619880.0
2014-05-12 16:00:00	NVDA	Stock	0.4645	0.4646	0.452	0.4646	5758120.0
2014-05-12 17:00:00	NVDA	Stock	0.4645	0.4645	0.4645	0.4645	104800.0
2014-05-12 04:00:00	AMZN	Stock	14.675	14.675	14.675	14.675	6000.0
2014-05-12 05:00:00	AMZN	Stock	14.7395	14.742	14.7395	14.74	10000.0
2014-05-12 07:00:00	AMZN	Stock	14.7085	14.7085	14.7085	14.7085	4000.0
2014-05-12 08:00:00	AMZN	Stock	14.715	14.718	14.68	14.718	100800.0
2014-05-12 09:00:00	AMZN	Stock	14.725	14.96	14.7025	14.9125	14300060.0
2014-05-12 10:00:00	AMZN	Stock	14.9175	15.0695	14.851	15.0325	12016500.0
2014-05-12 11:00:00	AMZN	Stock	15.0415	15.06	14.973	14.988	6893180.0
2014-05-12 12:00:00	AMZN	Stock	14.9782	15.0325	14.9705	14.9985	4609440.0
2014-05-12 13:00:00	AMZN	Stock	15.0032	15.0235	14.97	15.0075	4225240.0
2014-05-12 14:00:00	AMZN	Stock	15.009	15.069	14.9895	15.0555	5434560.0
2014-05-12 15:00:00	AMZN	Stock	15.06	15.167	15.057	15.143	19085120.0
2014-05-12 16:00:00	AMZN	Stock	15.143	15.169	14.9954	15.146	478080.0

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

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