PREVIEW / stock_1hour / 2013-07-18

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-07-18.parquet
  size:    1005 KB
  rows:    46,115
  symbols: 3,491

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-18 08:00:00	AAPL	Stock	15.375	15.4914	15.3214	15.4911	2115232.0
2013-07-18 09:00:00	AAPL	Stock	15.4893	15.5311	15.4429	15.4818	44598652.0
2013-07-18 10:00:00	AAPL	Stock	15.4854	15.5154	15.4471	15.5036	34008324.0
2013-07-18 11:00:00	AAPL	Stock	15.5068	15.5139	15.4179	15.4471	27075468.0
2013-07-18 12:00:00	AAPL	Stock	15.4471	15.4621	15.3789	15.4168	21715624.0
2013-07-18 13:00:00	AAPL	Stock	15.4193	15.44	15.3818	15.4375	18504416.0
2013-07-18 14:00:00	AAPL	Stock	15.4389	15.465	15.4314	15.435	15861020.0
2013-07-18 15:00:00	AAPL	Stock	15.4343	15.4486	15.4107	15.4175	20177472.0
2013-07-18 16:00:00	AAPL	Stock	15.4175	15.4385	15.3321	15.3929	26985672.0
2013-07-18 17:00:00	AAPL	Stock	15.4597	15.4597	15.3661	15.375	397600.0
2013-07-18 18:00:00	AAPL	Stock	15.375	15.3832	15.3664	15.3796	124404.0
2013-07-18 19:00:00	AAPL	Stock	15.3804	15.3839	15.3782	15.3804	134820.0
2013-07-18 08:00:00	MSFT	Stock	35.66	35.81	35.66	35.8	7479.0
2013-07-18 09:00:00	MSFT	Stock	35.81	35.89	35.46	35.665	5421181.0
2013-07-18 10:00:00	MSFT	Stock	35.67	35.89	35.62	35.81	5719051.0
2013-07-18 11:00:00	MSFT	Stock	35.805	35.86	35.59	35.62	5104813.0
2013-07-18 12:00:00	MSFT	Stock	35.614	35.65	35.46	35.525	4498126.0
2013-07-18 13:00:00	MSFT	Stock	35.525	35.56	35.34	35.447	3781964.0
2013-07-18 14:00:00	MSFT	Stock	35.45	35.45	35.22	35.275	6632535.0
2013-07-18 15:00:00	MSFT	Stock	35.28	35.47	35.26	35.43	8823771.0
2013-07-18 16:00:00	MSFT	Stock	35.44	35.64	33.47	33.85	7394525.0
2013-07-18 17:00:00	MSFT	Stock	33.83	35.822	33.18	33.25	1585735.0
2013-07-18 18:00:00	MSFT	Stock	33.25	33.29	33.07	33.07	264018.0
2013-07-18 19:00:00	MSFT	Stock	33.1	33.22	33.0	33.21	164446.0
2013-07-18 09:00:00	NVDA	Stock	0.3648	0.366	0.359	0.362	40941000.0
2013-07-18 10:00:00	NVDA	Stock	0.362	0.3638	0.3608	0.363	54499400.0
2013-07-18 11:00:00	NVDA	Stock	0.3631	0.3645	0.363	0.3642	41167720.0
2013-07-18 12:00:00	NVDA	Stock	0.364	0.3648	0.3625	0.3628	30267840.0
2013-07-18 13:00:00	NVDA	Stock	0.3628	0.3641	0.3625	0.364	20062360.0
2013-07-18 14:00:00	NVDA	Stock	0.364	0.3652	0.364	0.3651	26364000.0
2013-07-18 15:00:00	NVDA	Stock	0.365	0.3651	0.363	0.364	72686320.0
2013-07-18 16:00:00	NVDA	Stock	0.364	0.366	0.3612	0.3612	58040360.0
2013-07-18 17:00:00	NVDA	Stock	0.36	0.36	0.36	0.36	80000.0
2013-07-18 18:00:00	NVDA	Stock	0.3625	0.3625	0.3625	0.3625	40000.0
2013-07-18 19:00:00	NVDA	Stock	0.3625	0.3625	0.3625	0.3625	86200.0
2013-07-18 05:00:00	AMZN	Stock	15.375	15.375	15.375	15.375	2000.0
2013-07-18 07:00:00	AMZN	Stock	15.349	15.349	15.2755	15.2755	129680.0
2013-07-18 08:00:00	AMZN	Stock	15.306	15.4	15.257	15.3045	459160.0
2013-07-18 09:00:00	AMZN	Stock	15.4345	15.4345	15.107	15.125	17299540.0
2013-07-18 10:00:00	AMZN	Stock	15.1255	15.2875	15.0935	15.2635	14150960.0
2013-07-18 11:00:00	AMZN	Stock	15.2615	15.2925	15.2105	15.2205	5897840.0
2013-07-18 12:00:00	AMZN	Stock	15.2218	15.2565	15.146	15.1765	4662520.0
2013-07-18 13:00:00	AMZN	Stock	15.1765	15.2525	15.161	15.2463	2909000.0
2013-07-18 14:00:00	AMZN	Stock	15.251	15.2775	15.206	15.253	5980960.0
2013-07-18 15:00:00	AMZN	Stock	15.251	15.253	15.196	15.2065	6776260.0
2013-07-18 16:00:00	AMZN	Stock	15.2055	15.2197	14.9995	15.0265	739040.0
2013-07-18 17:00:00	AMZN	Stock	15.027	15.2055	15.027	15.0405	101240.0
2013-07-18 18:00:00	AMZN	Stock	15.0275	15.075	15.0275	15.0495	65080.0
2013-07-18 19:00:00	AMZN	Stock	15.028	15.031	15.028	15.031	6000.0
2013-07-18 04:00:00	META	Stock	26.68	26.68	26.64	26.64	1300.0

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

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