PREVIEW / stock_1hour / 2013-05-03

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-05-03.parquet
  size:    1006 KB
  rows:    46,251
  symbols: 3,509

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-03 04:00:00	AAPL	Stock	15.9643	15.985	15.9643	15.9821	17444.0
2013-05-03 05:00:00	AAPL	Stock	15.9696	15.9696	15.9571	15.9571	14000.0
2013-05-03 07:00:00	AAPL	Stock	15.9654	15.9786	15.9407	15.9464	181720.0
2013-05-03 08:00:00	AAPL	Stock	15.9364	16.0871	15.92	16.0804	6062868.0
2013-05-03 09:00:00	AAPL	Stock	16.0679	16.1868	16.0679	16.1121	90455428.0
2013-05-03 10:00:00	AAPL	Stock	16.1125	16.1411	16.0539	16.1307	72152892.0
2013-05-03 11:00:00	AAPL	Stock	16.1314	16.1429	16.0893	16.1025	36321152.0
2013-05-03 12:00:00	AAPL	Stock	16.1036	16.1182	16.0936	16.1118	19364380.0
2013-05-03 13:00:00	AAPL	Stock	16.1136	16.1321	16.0825	16.0966	21780416.0
2013-05-03 14:00:00	AAPL	Stock	16.0971	16.1175	16.075	16.0827	24053400.0
2013-05-03 15:00:00	AAPL	Stock	16.0829	16.0907	16.0411	16.0689	64487360.0
2013-05-03 16:00:00	AAPL	Stock	16.0707	16.118	15.8925	16.0714	18595444.0
2013-05-03 17:00:00	AAPL	Stock	16.0718	16.0718	16.0704	16.0718	317856.0
2013-05-03 18:00:00	AAPL	Stock	16.0725	16.075	16.0686	16.0714	170240.0
2013-05-03 19:00:00	AAPL	Stock	16.0711	16.0718	16.0589	16.0714	80108.0
2013-05-03 05:00:00	MSFT	Stock	33.02	33.02	33.02	33.02	100.0
2013-05-03 06:00:00	MSFT	Stock	33.02	33.02	32.97	32.97	1965.0
2013-05-03 07:00:00	MSFT	Stock	33.02	33.06	33.0	33.0	700.0
2013-05-03 08:00:00	MSFT	Stock	33.06	33.39	33.05	33.37	112445.0
2013-05-03 09:00:00	MSFT	Stock	33.37	33.47	33.08	33.435	6746057.0
2013-05-03 10:00:00	MSFT	Stock	33.43	33.52	33.3	33.42	8211890.0
2013-05-03 11:00:00	MSFT	Stock	33.43	33.48	33.395	33.43	5950823.0
2013-05-03 12:00:00	MSFT	Stock	33.43	33.44	33.35	33.4	3971231.0
2013-05-03 13:00:00	MSFT	Stock	33.41	33.5	33.31	33.362	4115772.0
2013-05-03 14:00:00	MSFT	Stock	33.36	33.435	33.33	33.39	4971257.0
2013-05-03 15:00:00	MSFT	Stock	33.39	33.5	33.38	33.49	8892402.0
2013-05-03 16:00:00	MSFT	Stock	33.49	33.5	33.415	33.5	2752290.0
2013-05-03 17:00:00	MSFT	Stock	33.49	33.5	33.46	33.46	16351.0
2013-05-03 18:00:00	MSFT	Stock	33.49	33.49	33.46	33.46	1956.0
2013-05-03 19:00:00	MSFT	Stock	33.48	33.48	33.48	33.48	400.0
2013-05-03 08:00:00	NVDA	Stock	0.3462	0.3485	0.3462	0.3485	68000.0
2013-05-03 09:00:00	NVDA	Stock	0.348	0.3493	0.3455	0.348	21218920.0
2013-05-03 10:00:00	NVDA	Stock	0.348	0.3488	0.3468	0.3478	73919480.0
2013-05-03 11:00:00	NVDA	Stock	0.3479	0.3482	0.347	0.3475	45253600.0
2013-05-03 12:00:00	NVDA	Stock	0.3475	0.3488	0.3475	0.3482	17055640.0
2013-05-03 13:00:00	NVDA	Stock	0.3485	0.3493	0.3465	0.3465	29699240.0
2013-05-03 14:00:00	NVDA	Stock	0.3465	0.347	0.346	0.3468	25552880.0
2013-05-03 15:00:00	NVDA	Stock	0.3466	0.3473	0.3462	0.3468	61480840.0
2013-05-03 16:00:00	NVDA	Stock	0.3468	0.3473	0.3467	0.3468	19158360.0
2013-05-03 17:00:00	NVDA	Stock	0.3468	0.3468	0.3468	0.3468	47160.0
2013-05-03 05:00:00	AMZN	Stock	12.5975	12.6175	12.5975	12.6175	4000.0
2013-05-03 06:00:00	AMZN	Stock	12.6265	12.6265	12.6	12.6225	7300.0
2013-05-03 07:00:00	AMZN	Stock	12.635	12.635	12.6245	12.6245	4260.0
2013-05-03 08:00:00	AMZN	Stock	12.6	12.737	12.5535	12.725	580740.0
2013-05-03 09:00:00	AMZN	Stock	12.7235	12.9241	12.7235	12.8848	16285980.0
2013-05-03 10:00:00	AMZN	Stock	12.8885	12.915	12.85	12.897	14752780.0
2013-05-03 11:00:00	AMZN	Stock	12.8975	12.9465	12.895	12.935	7553120.0
2013-05-03 12:00:00	AMZN	Stock	12.9351	12.9625	12.927	12.93	5949620.0
2013-05-03 13:00:00	AMZN	Stock	12.9285	12.95	12.871	12.8988	6598060.0
2013-05-03 14:00:00	AMZN	Stock	12.8988	12.9315	12.895	12.9005	5031200.0

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

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