PREVIEW / stock_1hour / 2013-08-23

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-08-23.parquet
  size:    999 KB
  rows:    46,571
  symbols: 3,519

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-08-23 04:00:00	AAPL	Stock	18.0	18.0607	18.0	18.0539	36400.0
2013-08-23 05:00:00	AAPL	Stock	18.0586	18.0586	18.0357	18.0357	22400.0
2013-08-23 06:00:00	AAPL	Stock	18.0357	18.0357	18.0064	18.0089	14000.0
2013-08-23 07:00:00	AAPL	Stock	18.0007	18.0264	17.9779	17.9779	344932.0
2013-08-23 08:00:00	AAPL	Stock	17.9857	18.0171	17.9339	17.9582	1518048.0
2013-08-23 09:00:00	AAPL	Stock	17.9554	17.9768	17.8339	17.8921	53801524.0
2013-08-23 10:00:00	AAPL	Stock	17.8896	17.9589	17.8361	17.9329	41332620.0
2013-08-23 11:00:00	AAPL	Stock	17.93	17.9389	17.8804	17.9046	21642096.0
2013-08-23 12:00:00	AAPL	Stock	17.9046	17.9204	17.8764	17.8775	16374232.0
2013-08-23 13:00:00	AAPL	Stock	17.8764	17.8968	17.8686	17.8711	13429696.0
2013-08-23 14:00:00	AAPL	Stock	17.8689	17.8864	17.8564	17.8732	18544372.0
2013-08-23 15:00:00	AAPL	Stock	17.8729	17.9175	17.8661	17.8957	41715576.0
2013-08-23 16:00:00	AAPL	Stock	17.8925	17.9339	17.8608	17.8643	10781764.0
2013-08-23 17:00:00	AAPL	Stock	17.8643	17.8936	17.8614	17.8836	412944.0
2013-08-23 18:00:00	AAPL	Stock	17.8829	17.8839	17.8661	17.8839	144844.0
2013-08-23 19:00:00	AAPL	Stock	17.8907	17.8921	17.875	17.875	233296.0
2013-08-23 04:00:00	MSFT	Stock	32.5	32.5	32.5	32.5	500.0
2013-08-23 06:00:00	MSFT	Stock	32.45	32.45	32.45	32.45	500.0
2013-08-23 07:00:00	MSFT	Stock	32.42	32.47	32.42	32.47	300.0
2013-08-23 08:00:00	MSFT	Stock	32.41	32.5	32.33	32.43	16500.0
2013-08-23 09:00:00	MSFT	Stock	32.47	35.5	32.45	34.68	79406054.0
2013-08-23 10:00:00	MSFT	Stock	34.68	34.88	34.39	34.52	33959811.0
2013-08-23 11:00:00	MSFT	Stock	34.52	34.55	34.0	34.21	26725838.0
2013-08-23 12:00:00	MSFT	Stock	34.21	34.595	34.11	34.54	22860116.0
2013-08-23 13:00:00	MSFT	Stock	34.54	34.7	34.52	34.545	12257975.0
2013-08-23 14:00:00	MSFT	Stock	34.55	34.99	34.5	34.74	16418930.0
2013-08-23 15:00:00	MSFT	Stock	34.747	34.88	34.65	34.77	20660669.0
2013-08-23 16:00:00	MSFT	Stock	34.764	34.842	34.409	34.77	6346489.0
2013-08-23 17:00:00	MSFT	Stock	34.77	34.79	34.76	34.78	48661.0
2013-08-23 18:00:00	MSFT	Stock	34.78	34.79	34.74	34.76	35174.0
2013-08-23 19:00:00	MSFT	Stock	34.76	34.77	34.74	34.76	16026.0
2013-08-23 09:00:00	NVDA	Stock	0.3745	0.3763	0.374	0.3755	30947080.0
2013-08-23 10:00:00	NVDA	Stock	0.3755	0.3775	0.3743	0.3751	52458680.0
2013-08-23 11:00:00	NVDA	Stock	0.3753	0.3753	0.374	0.3743	30990800.0
2013-08-23 12:00:00	NVDA	Stock	0.3744	0.3748	0.3733	0.3736	29372720.0
2013-08-23 13:00:00	NVDA	Stock	0.3738	0.3745	0.3735	0.3745	17769960.0
2013-08-23 14:00:00	NVDA	Stock	0.3745	0.3745	0.3738	0.3738	23919320.0
2013-08-23 15:00:00	NVDA	Stock	0.3738	0.3748	0.3735	0.3738	50653240.0
2013-08-23 16:00:00	NVDA	Stock	0.374	0.375	0.374	0.374	8597800.0
2013-08-23 17:00:00	NVDA	Stock	0.374	0.374	0.374	0.374	66720.0
2013-08-23 18:00:00	NVDA	Stock	0.376	0.376	0.376	0.376	12000.0
2013-08-23 07:00:00	AMZN	Stock	14.5995	14.5995	14.52	14.52	4000.0
2013-08-23 08:00:00	AMZN	Stock	14.465	14.5645	14.45	14.4865	82000.0
2013-08-23 09:00:00	AMZN	Stock	14.485	14.575	14.4165	14.4475	6462880.0
2013-08-23 10:00:00	AMZN	Stock	14.443	14.5065	14.395	14.4725	6391300.0
2013-08-23 11:00:00	AMZN	Stock	14.479	14.4924	14.438	14.467	3228400.0
2013-08-23 12:00:00	AMZN	Stock	14.47	14.495	14.4645	14.495	2695120.0
2013-08-23 13:00:00	AMZN	Stock	14.4885	14.4985	14.446	14.4551	2753700.0
2013-08-23 14:00:00	AMZN	Stock	14.4505	14.5195	14.442	14.4795	6423900.0
2013-08-23 15:00:00	AMZN	Stock	14.4815	14.5015	14.452	14.5005	7032740.0

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

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