PREVIEW / stock_1hour / 2013-08-02

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-08-02.parquet
  size:    1017 KB
  rows:    46,638
  symbols: 3,516

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-02 05:00:00	AAPL	Stock	16.3232	16.3232	16.3232	16.3232	5600.0
2013-08-02 07:00:00	AAPL	Stock	16.3179	16.3218	16.3046	16.3107	102480.0
2013-08-02 08:00:00	AAPL	Stock	16.3079	16.3643	16.2143	16.35	1738996.0
2013-08-02 09:00:00	AAPL	Stock	16.3482	16.4132	16.3093	16.3621	53220328.0
2013-08-02 10:00:00	AAPL	Stock	16.3636	16.3929	16.3368	16.3429	36857828.0
2013-08-02 11:00:00	AAPL	Stock	16.342	16.3875	16.3182	16.3771	23305688.0
2013-08-02 12:00:00	AAPL	Stock	16.3782	16.4504	16.3714	16.4482	29640268.0
2013-08-02 13:00:00	AAPL	Stock	16.4468	16.5	16.4329	16.4543	28196224.0
2013-08-02 14:00:00	AAPL	Stock	16.4532	16.5	16.4518	16.4996	22356992.0
2013-08-02 15:00:00	AAPL	Stock	16.4982	16.5304	16.4689	16.5218	58799580.0
2013-08-02 16:00:00	AAPL	Stock	16.5196	16.5264	16.4236	16.5193	18189948.0
2013-08-02 17:00:00	AAPL	Stock	16.5168	16.5239	16.5168	16.5179	253456.0
2013-08-02 18:00:00	AAPL	Stock	16.5179	16.5211	16.5164	16.5193	104552.0
2013-08-02 19:00:00	AAPL	Stock	16.5193	16.53	16.5025	16.5036	528444.0
2013-08-02 07:00:00	MSFT	Stock	31.61	31.61	31.61	31.61	729.0
2013-08-02 08:00:00	MSFT	Stock	31.69	31.81	31.59	31.59	20715.0
2013-08-02 09:00:00	MSFT	Stock	31.62	31.72	31.565	31.65	3437899.0
2013-08-02 10:00:00	MSFT	Stock	31.65	31.78	31.61	31.62	4418243.0
2013-08-02 11:00:00	MSFT	Stock	31.63	31.75	31.6	31.72	3541498.0
2013-08-02 12:00:00	MSFT	Stock	31.72	31.725	31.67	31.69	2326968.0
2013-08-02 13:00:00	MSFT	Stock	31.7	31.76	31.68	31.74	2350222.0
2013-08-02 14:00:00	MSFT	Stock	31.74	31.85	31.73	31.81	2262755.0
2013-08-02 15:00:00	MSFT	Stock	31.815	31.9	31.75	31.89	7333368.0
2013-08-02 16:00:00	MSFT	Stock	31.88	31.89	31.703	31.88	3208788.0
2013-08-02 17:00:00	MSFT	Stock	31.82	31.87	31.81	31.81	1979.0
2013-08-02 18:00:00	MSFT	Stock	31.83	31.88	31.83	31.88	329.0
2013-08-02 19:00:00	MSFT	Stock	31.84	31.89	31.84	31.89	1200.0
2013-08-02 08:00:00	NVDA	Stock	0.366	0.366	0.366	0.366	24640.0
2013-08-02 09:00:00	NVDA	Stock	0.365	0.3652	0.3628	0.3648	17022200.0
2013-08-02 10:00:00	NVDA	Stock	0.3645	0.368	0.3642	0.367	37793760.0
2013-08-02 11:00:00	NVDA	Stock	0.3668	0.3672	0.3658	0.367	19432280.0
2013-08-02 12:00:00	NVDA	Stock	0.367	0.3672	0.366	0.3665	20037680.0
2013-08-02 13:00:00	NVDA	Stock	0.3665	0.3675	0.366	0.3669	14834600.0
2013-08-02 14:00:00	NVDA	Stock	0.367	0.3674	0.3662	0.3668	21480120.0
2013-08-02 15:00:00	NVDA	Stock	0.3669	0.3698	0.3665	0.369	65703560.0
2013-08-02 16:00:00	NVDA	Stock	0.369	0.369	0.3655	0.3689	11665440.0
2013-08-02 19:00:00	NVDA	Stock	0.3675	0.3675	0.3675	0.3675	40000.0
2013-08-02 07:00:00	AMZN	Stock	15.1075	15.1075	15.1075	15.1075	2000.0
2013-08-02 08:00:00	AMZN	Stock	15.2345	15.277	15.2305	15.25	86400.0
2013-08-02 09:00:00	AMZN	Stock	15.255	15.2665	15.075	15.1275	14175720.0
2013-08-02 10:00:00	AMZN	Stock	15.1265	15.2625	15.1005	15.214	10774140.0
2013-08-02 11:00:00	AMZN	Stock	15.2125	15.238	15.1535	15.1665	4418160.0
2013-08-02 12:00:00	AMZN	Stock	15.161	15.249	15.1575	15.2065	3853860.0
2013-08-02 13:00:00	AMZN	Stock	15.202	15.2245	15.182	15.201	2078660.0
2013-08-02 14:00:00	AMZN	Stock	15.207	15.2125	15.1475	15.1766	3496560.0
2013-08-02 15:00:00	AMZN	Stock	15.176	15.2105	15.148	15.2105	7923060.0
2013-08-02 16:00:00	AMZN	Stock	15.2105	15.2968	15.1625	15.221	462720.0
2013-08-02 19:00:00	AMZN	Stock	15.2	15.2	15.2	15.2	4240.0
2013-08-02 04:00:00	META	Stock	37.6	37.92	37.59	37.66	11597.0
2013-08-02 05:00:00	META	Stock	37.61	37.63	37.56	37.56	14554.0

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

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