PREVIEW / stock_1hour / 2013-05-10

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-05-10.parquet
  size:    981 KB
  rows:    45,466
  symbols: 3,510

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-05-10 04:00:00	AAPL	Stock	16.3332	16.3482	16.3332	16.3336	103600.0
2013-05-10 05:00:00	AAPL	Stock	16.3336	16.3336	16.3336	16.3336	5600.0
2013-05-10 06:00:00	AAPL	Stock	16.3339	16.3339	16.3339	16.3339	2800.0
2013-05-10 07:00:00	AAPL	Stock	16.3471	16.4086	16.3396	16.3571	523404.0
2013-05-10 08:00:00	AAPL	Stock	16.375	16.4089	16.3404	16.3536	1205876.0
2013-05-10 09:00:00	AAPL	Stock	16.35	16.4182	16.2696	16.3094	56418544.0
2013-05-10 10:00:00	AAPL	Stock	16.3082	16.35	16.0886	16.1361	97465872.0
2013-05-10 11:00:00	AAPL	Stock	16.1371	16.2107	16.125	16.1442	42631204.0
2013-05-10 12:00:00	AAPL	Stock	16.1439	16.165	16.1164	16.1282	24244584.0
2013-05-10 13:00:00	AAPL	Stock	16.1282	16.165	16.1186	16.1268	22542772.0
2013-05-10 14:00:00	AAPL	Stock	16.1268	16.1857	16.1239	16.1689	25814012.0
2013-05-10 15:00:00	AAPL	Stock	16.1689	16.1782	16.1021	16.1743	49022092.0
2013-05-10 16:00:00	AAPL	Stock	16.1775	16.2014	16.166	16.1893	11756780.0
2013-05-10 17:00:00	AAPL	Stock	16.1882	16.1889	16.1793	16.1804	120288.0
2013-05-10 18:00:00	AAPL	Stock	16.1789	16.1871	16.1768	16.1871	153104.0
2013-05-10 19:00:00	AAPL	Stock	16.1829	16.2032	16.1829	16.1982	169512.0
2013-05-10 08:00:00	MSFT	Stock	32.6	32.65	32.57	32.57	10200.0
2013-05-10 09:00:00	MSFT	Stock	32.56	32.67	32.32	32.555	5090516.0
2013-05-10 10:00:00	MSFT	Stock	32.55	32.72	32.485	32.621	6712773.0
2013-05-10 11:00:00	MSFT	Stock	32.62	32.64	32.51	32.56	5019796.0
2013-05-10 12:00:00	MSFT	Stock	32.56	32.64	32.54	32.59	2897589.0
2013-05-10 13:00:00	MSFT	Stock	32.6	32.65	32.59	32.63	2415120.0
2013-05-10 14:00:00	MSFT	Stock	32.625	32.65	32.58	32.6	2664540.0
2013-05-10 15:00:00	MSFT	Stock	32.6	32.69	32.57	32.686	7292970.0
2013-05-10 16:00:00	MSFT	Stock	32.68	32.72	32.59	32.69	2608333.0
2013-05-10 17:00:00	MSFT	Stock	32.69	32.73	32.69	32.72	12233.0
2013-05-10 18:00:00	MSFT	Stock	32.71	32.71	32.71	32.71	130.0
2013-05-10 19:00:00	MSFT	Stock	32.72	32.72	32.71	32.71	1553.0
2013-05-10 07:00:00	NVDA	Stock	0.35	0.353	0.35	0.3525	1323800.0
2013-05-10 08:00:00	NVDA	Stock	0.3513	0.362	0.3513	0.3575	7744720.0
2013-05-10 09:00:00	NVDA	Stock	0.358	0.3632	0.3542	0.3565	213346320.0
2013-05-10 10:00:00	NVDA	Stock	0.3568	0.3612	0.3565	0.36	156119720.0
2013-05-10 11:00:00	NVDA	Stock	0.3602	0.3622	0.3595	0.3612	77212240.0
2013-05-10 12:00:00	NVDA	Stock	0.361	0.363	0.3608	0.3622	81406560.0
2013-05-10 13:00:00	NVDA	Stock	0.362	0.3632	0.3612	0.3631	65552800.0
2013-05-10 14:00:00	NVDA	Stock	0.3631	0.3632	0.3618	0.362	67167120.0
2013-05-10 15:00:00	NVDA	Stock	0.3619	0.365	0.3619	0.3635	171088960.0
2013-05-10 16:00:00	NVDA	Stock	0.3635	0.3645	0.3611	0.3635	19703800.0
2013-05-10 17:00:00	NVDA	Stock	0.3638	0.3642	0.3635	0.3638	98000.0
2013-05-10 18:00:00	NVDA	Stock	0.3638	0.365	0.3638	0.365	105280.0
2013-05-10 19:00:00	NVDA	Stock	0.365	0.3655	0.365	0.3655	30360.0
2013-05-10 05:00:00	AMZN	Stock	13.0495	13.0495	13.0355	13.0355	38500.0
2013-05-10 07:00:00	AMZN	Stock	13.0375	13.05	13.0205	13.0205	42000.0
2013-05-10 08:00:00	AMZN	Stock	13.044	13.0455	13.04	13.0425	44000.0
2013-05-10 09:00:00	AMZN	Stock	13.035	13.15	13.0105	13.1388	11234580.0
2013-05-10 10:00:00	AMZN	Stock	13.1425	13.1725	13.025	13.1075	14788120.0
2013-05-10 11:00:00	AMZN	Stock	13.104	13.1545	13.0425	13.0425	7841000.0
2013-05-10 12:00:00	AMZN	Stock	13.0445	13.114	13.025	13.093	6530820.0
2013-05-10 13:00:00	AMZN	Stock	13.095	13.1425	13.0845	13.0975	4170780.0
2013-05-10 14:00:00	AMZN	Stock	13.0949	13.157	13.0949	13.126	5354180.0

> showing 50 of 45,466 rows — these rows as CSV

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