PREVIEW / stock_1hour / 2013-07-11

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-07-11.parquet
  size:    1011 KB
  rows:    46,981
  symbols: 3,500

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-07-11 04:00:00	AAPL	Stock	15.1596	15.1604	15.1479	15.1479	47012.0
2013-07-11 05:00:00	AAPL	Stock	15.1479	15.1479	15.1293	15.1293	21000.0
2013-07-11 06:00:00	AAPL	Stock	15.1286	15.1296	15.1286	15.1296	5600.0
2013-07-11 07:00:00	AAPL	Stock	15.1286	15.1429	15.0857	15.1075	361788.0
2013-07-11 08:00:00	AAPL	Stock	15.1071	15.1429	15.0982	15.1071	1924664.0
2013-07-11 09:00:00	AAPL	Stock	15.1071	15.1414	15.0418	15.1029	48021064.0
2013-07-11 10:00:00	AAPL	Stock	15.1064	15.1859	15.0743	15.1786	56790720.0
2013-07-11 11:00:00	AAPL	Stock	15.1811	15.2386	15.155	15.2354	37413264.0
2013-07-11 12:00:00	AAPL	Stock	15.2354	15.2757	15.1962	15.2642	38197572.0
2013-07-11 13:00:00	AAPL	Stock	15.2643	15.2768	15.2204	15.2529	31711624.0
2013-07-11 14:00:00	AAPL	Stock	15.2554	15.2946	15.2311	15.2457	39006912.0
2013-07-11 15:00:00	AAPL	Stock	15.2464	15.2886	15.2389	15.2625	45503024.0
2013-07-11 16:00:00	AAPL	Stock	15.265	15.3234	15.156	15.3234	24542224.0
2013-07-11 17:00:00	AAPL	Stock	15.26	15.2614	15.2568	15.2611	90972.0
2013-07-11 18:00:00	AAPL	Stock	15.2643	15.2657	15.2643	15.2654	27356.0
2013-07-11 19:00:00	AAPL	Stock	15.26	15.2789	15.2561	15.2561	161840.0
2013-07-11 04:00:00	MSFT	Stock	34.97	34.97	34.97	34.97	1361.0
2013-07-11 05:00:00	MSFT	Stock	34.81	35.12	34.8	35.12	1860.0
2013-07-11 07:00:00	MSFT	Stock	35.0	35.1	34.97	35.05	9193.0
2013-07-11 08:00:00	MSFT	Stock	35.1	35.18	34.7	35.13	204080.0
2013-07-11 09:00:00	MSFT	Stock	35.12	35.37	34.9	35.36	7663319.0
2013-07-11 10:00:00	MSFT	Stock	35.35	35.36	35.11	35.15	6962929.0
2013-07-11 11:00:00	MSFT	Stock	35.16	35.37	35.14	35.37	5533636.0
2013-07-11 12:00:00	MSFT	Stock	35.365	35.46	35.27	35.45	4791460.0
2013-07-11 13:00:00	MSFT	Stock	35.45	35.47	35.38	35.411	3465380.0
2013-07-11 14:00:00	MSFT	Stock	35.415	35.67	35.37	35.66	5584056.0
2013-07-11 15:00:00	MSFT	Stock	35.655	35.77	35.61	35.68	13221629.0
2013-07-11 16:00:00	MSFT	Stock	35.685	35.747	35.394	35.65	5636791.0
2013-07-11 17:00:00	MSFT	Stock	35.64	35.69	35.55	35.58	21984.0
2013-07-11 18:00:00	MSFT	Stock	35.61	35.61	35.55	35.6	11438.0
2013-07-11 19:00:00	MSFT	Stock	35.59	35.59	35.55	35.55	8749.0
2013-07-11 07:00:00	NVDA	Stock	0.3612	0.3612	0.3612	0.3612	20000.0
2013-07-11 08:00:00	NVDA	Stock	0.364	0.3642	0.364	0.3642	8000.0
2013-07-11 09:00:00	NVDA	Stock	0.3638	0.3662	0.3628	0.3652	26361800.0
2013-07-11 10:00:00	NVDA	Stock	0.3655	0.366	0.3628	0.364	54254040.0
2013-07-11 11:00:00	NVDA	Stock	0.364	0.3645	0.3632	0.3638	30039360.0
2013-07-11 12:00:00	NVDA	Stock	0.364	0.364	0.362	0.3638	19242320.0
2013-07-11 13:00:00	NVDA	Stock	0.364	0.3645	0.3635	0.3638	14856760.0
2013-07-11 14:00:00	NVDA	Stock	0.3639	0.3658	0.3638	0.3649	35106560.0
2013-07-11 15:00:00	NVDA	Stock	0.365	0.3658	0.3642	0.3655	51190360.0
2013-07-11 16:00:00	NVDA	Stock	0.3658	0.3658	0.3644	0.365	8134680.0
2013-07-11 19:00:00	NVDA	Stock	0.366	0.366	0.366	0.366	12000.0
2013-07-11 04:00:00	AMZN	Stock	14.7325	14.7325	14.726	14.726	48000.0
2013-07-11 05:00:00	AMZN	Stock	14.733	14.733	14.733	14.733	2000.0
2013-07-11 06:00:00	AMZN	Stock	14.7625	14.763	14.7625	14.763	12000.0
2013-07-11 07:00:00	AMZN	Stock	14.764	14.775	14.7485	14.77	162800.0
2013-07-11 08:00:00	AMZN	Stock	14.763	14.8235	14.758	14.775	228160.0
2013-07-11 09:00:00	AMZN	Stock	14.7625	14.7625	14.605	14.7235	14572480.0
2013-07-11 10:00:00	AMZN	Stock	14.7188	14.817	14.709	14.789	12259720.0
2013-07-11 11:00:00	AMZN	Stock	14.7945	14.894	14.7915	14.8875	9371780.0

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

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