PREVIEW / stock_1hour / 2014-02-25

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-02-25.parquet
  size:    1.0 MB
  rows:    48,674
  symbols: 3,528

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-02-25 04:00:00	AAPL	Stock	18.8429	18.8429	18.6361	18.8036	19600.0
2014-02-25 05:00:00	AAPL	Stock	18.8204	18.8204	18.8204	18.8204	11200.0
2014-02-25 06:00:00	AAPL	Stock	18.8643	18.8661	18.8643	18.8661	14000.0
2014-02-25 07:00:00	AAPL	Stock	18.8661	18.8925	18.8411	18.8621	73976.0
2014-02-25 08:00:00	AAPL	Stock	18.8411	18.8889	18.8411	18.8839	402052.0
2014-02-25 09:00:00	AAPL	Stock	18.8836	18.9286	18.7646	18.7752	33336408.0
2014-02-25 10:00:00	AAPL	Stock	18.7771	18.7998	18.6964	18.7107	35691068.0
2014-02-25 11:00:00	AAPL	Stock	18.7136	18.8671	18.6982	18.7971	27713280.0
2014-02-25 12:00:00	AAPL	Stock	18.797	18.8018	18.7179	18.7479	15146964.0
2014-02-25 13:00:00	AAPL	Stock	18.7468	18.7821	18.7143	18.7207	11666564.0
2014-02-25 14:00:00	AAPL	Stock	18.7225	18.7439	18.6579	18.6646	22633940.0
2014-02-25 15:00:00	AAPL	Stock	18.6703	18.6875	18.6071	18.6454	35895552.0
2014-02-25 16:00:00	AAPL	Stock	18.645	18.8995	18.6394	18.6714	7146384.0
2014-02-25 17:00:00	AAPL	Stock	18.6696	18.6911	18.6661	18.6714	248276.0
2014-02-25 18:00:00	AAPL	Stock	18.6871	18.6875	18.645	18.6786	576604.0
2014-02-25 19:00:00	AAPL	Stock	18.6786	18.6911	18.6646	18.6679	332164.0
2014-02-25 07:00:00	MSFT	Stock	37.59	37.59	37.59	37.59	100.0
2014-02-25 08:00:00	MSFT	Stock	37.68	37.68	37.52	37.64	6590.0
2014-02-25 09:00:00	MSFT	Stock	37.64	37.78	37.35	37.58	5820321.0
2014-02-25 10:00:00	MSFT	Stock	37.58	37.79	37.55	37.76	4028537.0
2014-02-25 11:00:00	MSFT	Stock	37.76	37.85	37.69	37.69	2955728.0
2014-02-25 12:00:00	MSFT	Stock	37.69	37.7	37.53	37.62	2772327.0
2014-02-25 13:00:00	MSFT	Stock	37.62	37.74	37.59	37.7	2494764.0
2014-02-25 14:00:00	MSFT	Stock	37.695	37.7	37.54	37.625	2302043.0
2014-02-25 15:00:00	MSFT	Stock	37.624	37.63	37.51	37.55	7260538.0
2014-02-25 16:00:00	MSFT	Stock	37.54	37.641	37.35	37.54	2372557.0
2014-02-25 17:00:00	MSFT	Stock	37.55	37.63	37.55	37.63	8025.0
2014-02-25 18:00:00	MSFT	Stock	37.63	37.63	37.54	37.63	125105.0
2014-02-25 19:00:00	MSFT	Stock	37.63	37.63	37.56	37.56	550.0
2014-02-25 08:00:00	NVDA	Stock	0.4742	0.4745	0.4742	0.4745	20000.0
2014-02-25 09:00:00	NVDA	Stock	0.474	0.474	0.4651	0.4656	30178760.0
2014-02-25 10:00:00	NVDA	Stock	0.4655	0.4671	0.4635	0.4655	36855080.0
2014-02-25 11:00:00	NVDA	Stock	0.4656	0.4713	0.4655	0.4702	32678200.0
2014-02-25 12:00:00	NVDA	Stock	0.4702	0.4713	0.469	0.471	21778440.0
2014-02-25 13:00:00	NVDA	Stock	0.471	0.472	0.4705	0.4708	16868600.0
2014-02-25 14:00:00	NVDA	Stock	0.471	0.4715	0.47	0.4702	19824680.0
2014-02-25 15:00:00	NVDA	Stock	0.4702	0.471	0.4683	0.4686	65342120.0
2014-02-25 16:00:00	NVDA	Stock	0.4685	0.4705	0.4684	0.4685	5027560.0
2014-02-25 18:00:00	NVDA	Stock	0.4685	0.4718	0.4685	0.4718	337880.0
2014-02-25 04:00:00	AMZN	Stock	17.675	17.675	17.6	17.6	4000.0
2014-02-25 06:00:00	AMZN	Stock	17.603	17.603	17.5915	17.5915	18000.0
2014-02-25 07:00:00	AMZN	Stock	17.6	17.6	17.6	17.6	2000.0
2014-02-25 08:00:00	AMZN	Stock	17.635	17.6505	17.635	17.6505	19800.0
2014-02-25 09:00:00	AMZN	Stock	17.6615	17.743	17.579	17.6617	8632860.0
2014-02-25 10:00:00	AMZN	Stock	17.655	17.94	17.5875	17.929	15690820.0
2014-02-25 11:00:00	AMZN	Stock	17.929	18.054	17.923	17.923	15899160.0
2014-02-25 12:00:00	AMZN	Stock	17.9205	17.9785	17.88	17.945	5537040.0
2014-02-25 13:00:00	AMZN	Stock	17.949	17.9875	17.9245	17.9435	3592000.0
2014-02-25 14:00:00	AMZN	Stock	17.9335	17.9911	17.8855	17.9195	5476740.0
2014-02-25 15:00:00	AMZN	Stock	17.9195	17.931	17.8315	17.923	10672960.0

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

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