PREVIEW / stock_1hour / 2013-09-12

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-09-12.parquet
  size:    1021 KB
  rows:    47,771
  symbols: 3,517

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-09-12 04:00:00	AAPL	Stock	16.7768	16.7768	16.6968	16.7482	87388.0
2013-09-12 05:00:00	AAPL	Stock	16.7396	16.7821	16.7296	16.7821	154812.0
2013-09-12 06:00:00	AAPL	Stock	16.7939	16.8132	16.7782	16.7782	162960.0
2013-09-12 07:00:00	AAPL	Stock	16.7714	16.8157	16.7714	16.7975	541016.0
2013-09-12 08:00:00	AAPL	Stock	16.8036	16.9018	16.7768	16.8275	4132100.0
2013-09-12 09:00:00	AAPL	Stock	16.825	16.8296	16.6432	16.7696	80655456.0
2013-09-12 10:00:00	AAPL	Stock	16.7702	16.8032	16.6821	16.7789	61644268.0
2013-09-12 11:00:00	AAPL	Stock	16.7807	16.9054	16.7779	16.8887	66766532.0
2013-09-12 12:00:00	AAPL	Stock	16.8907	16.9786	16.8686	16.9019	55183940.0
2013-09-12 13:00:00	AAPL	Stock	16.9057	16.9489	16.8771	16.8822	30994712.0
2013-09-12 14:00:00	AAPL	Stock	16.8839	16.9329	16.8643	16.8887	31520328.0
2013-09-12 15:00:00	AAPL	Stock	16.8884	16.9068	16.815	16.8818	56838880.0
2013-09-12 16:00:00	AAPL	Stock	16.8818	16.8972	16.8358	16.8814	10403064.0
2013-09-12 17:00:00	AAPL	Stock	16.8793	16.8814	16.8661	16.8804	304248.0
2013-09-12 18:00:00	AAPL	Stock	16.88	16.8871	16.8768	16.8857	186816.0
2013-09-12 19:00:00	AAPL	Stock	16.8804	16.9036	16.8804	16.8943	363804.0
2013-09-12 04:00:00	MSFT	Stock	32.99	32.99	32.99	32.99	300.0
2013-09-12 08:00:00	MSFT	Stock	32.76	32.97	32.75	32.91	22374.0
2013-09-12 09:00:00	MSFT	Stock	32.88	32.89	32.67	32.735	4126808.0
2013-09-12 10:00:00	MSFT	Stock	32.73	32.76	32.61	32.635	4788702.0
2013-09-12 11:00:00	MSFT	Stock	32.63	32.677	32.59	32.67	6544893.0
2013-09-12 12:00:00	MSFT	Stock	32.67	32.7	32.61	32.685	2220901.0
2013-09-12 13:00:00	MSFT	Stock	32.69	32.76	32.64	32.64	2336222.0
2013-09-12 14:00:00	MSFT	Stock	32.64	32.71	32.625	32.705	2940483.0
2013-09-12 15:00:00	MSFT	Stock	32.71	32.71	32.6	32.71	6794186.0
2013-09-12 16:00:00	MSFT	Stock	32.71	32.751	32.625	32.65	1597323.0
2013-09-12 17:00:00	MSFT	Stock	32.66	32.71	32.66	32.66	1904.0
2013-09-12 18:00:00	MSFT	Stock	32.66	32.66	32.66	32.66	493.0
2013-09-12 19:00:00	MSFT	Stock	32.66	32.66	32.65	32.65	5247.0
2013-09-12 06:00:00	NVDA	Stock	0.395	0.395	0.395	0.395	4000.0
2013-09-12 08:00:00	NVDA	Stock	0.3933	0.3938	0.3925	0.3938	28000.0
2013-09-12 09:00:00	NVDA	Stock	0.3933	0.3975	0.3908	0.3973	61793040.0
2013-09-12 10:00:00	NVDA	Stock	0.397	0.3975	0.3948	0.396	54178160.0
2013-09-12 11:00:00	NVDA	Stock	0.3958	0.397	0.395	0.3968	46001200.0
2013-09-12 12:00:00	NVDA	Stock	0.397	0.397	0.3938	0.394	27407400.0
2013-09-12 13:00:00	NVDA	Stock	0.394	0.3973	0.3938	0.3966	37138560.0
2013-09-12 14:00:00	NVDA	Stock	0.3965	0.3968	0.3942	0.3956	21030920.0
2013-09-12 15:00:00	NVDA	Stock	0.3956	0.3958	0.3915	0.3925	39593480.0
2013-09-12 16:00:00	NVDA	Stock	0.3922	0.3958	0.392	0.392	1168440.0
2013-09-12 18:00:00	NVDA	Stock	0.3913	0.3913	0.3913	0.3913	8000.0
2013-09-12 07:00:00	AMZN	Stock	15.0225	15.0225	15.0225	15.0225	2000.0
2013-09-12 08:00:00	AMZN	Stock	14.935	14.985	14.935	14.985	19980.0
2013-09-12 09:00:00	AMZN	Stock	14.9845	14.9974	14.883	14.986	3261120.0
2013-09-12 10:00:00	AMZN	Stock	14.9895	15.1	14.9725	15.059	7261680.0
2013-09-12 11:00:00	AMZN	Stock	15.0625	15.069	14.905	14.956	6842540.0
2013-09-12 12:00:00	AMZN	Stock	14.9622	14.964	14.916	14.9475	2576600.0
2013-09-12 13:00:00	AMZN	Stock	14.9435	15.0	14.9395	14.9855	2583280.0
2013-09-12 14:00:00	AMZN	Stock	14.985	15.0325	14.9685	15.0195	2985860.0
2013-09-12 15:00:00	AMZN	Stock	15.018	15.0285	14.9255	14.943	5044780.0
2013-09-12 16:00:00	AMZN	Stock	14.9405	14.9904	14.9225	14.9225	232300.0

> showing 50 of 47,771 rows — these rows as CSV

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