PREVIEW / stock_1hour / 2013-07-10

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-07-10.parquet
  size:    987 KB
  rows:    46,143
  symbols: 3,494

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-10 04:00:00	AAPL	Stock	15.1232	15.1232	15.1232	15.1232	8400.0
2013-07-10 06:00:00	AAPL	Stock	15.0679	15.0718	15.0679	15.0718	39312.0
2013-07-10 07:00:00	AAPL	Stock	15.0718	15.0718	15.0079	15.0079	129164.0
2013-07-10 08:00:00	AAPL	Stock	15.0164	15.0711	15.0079	15.0679	797160.0
2013-07-10 09:00:00	AAPL	Stock	15.0593	15.15	14.9375	15.0282	68225780.0
2013-07-10 10:00:00	AAPL	Stock	15.0314	15.1714	14.9879	15.1032	77247884.0
2013-07-10 11:00:00	AAPL	Stock	15.1036	15.1146	15.0446	15.0586	22416072.0
2013-07-10 12:00:00	AAPL	Stock	15.0568	15.1304	15.0554	15.1057	15575812.0
2013-07-10 13:00:00	AAPL	Stock	15.1065	15.1065	15.0596	15.0771	11907784.0
2013-07-10 14:00:00	AAPL	Stock	15.0767	15.1354	14.9929	15.0296	41352276.0
2013-07-10 15:00:00	AAPL	Stock	15.0296	15.0668	15.0025	15.026	33360124.0
2013-07-10 16:00:00	AAPL	Stock	15.0261	15.0848	15.0021	15.0243	6766564.0
2013-07-10 17:00:00	AAPL	Stock	15.0243	15.0621	15.0243	15.0536	569408.0
2013-07-10 18:00:00	AAPL	Stock	15.0611	15.1054	15.0611	15.0893	610232.0
2013-07-10 19:00:00	AAPL	Stock	15.0893	15.1179	15.0893	15.1154	364140.0
2013-07-10 08:00:00	MSFT	Stock	34.35	34.35	34.33	34.35	2906.0
2013-07-10 09:00:00	MSFT	Stock	34.38	34.74	34.3	34.72	3794658.0
2013-07-10 10:00:00	MSFT	Stock	34.715	34.81	34.55	34.59	5755055.0
2013-07-10 11:00:00	MSFT	Stock	34.59	34.7	34.56	34.59	3340291.0
2013-07-10 12:00:00	MSFT	Stock	34.59	34.64	34.53	34.555	2536625.0
2013-07-10 13:00:00	MSFT	Stock	34.55	34.69	34.52	34.654	1779894.0
2013-07-10 14:00:00	MSFT	Stock	34.66	34.77	34.564	34.635	4153545.0
2013-07-10 15:00:00	MSFT	Stock	34.64	34.75	34.59	34.69	5026141.0
2013-07-10 16:00:00	MSFT	Stock	34.69	34.73	34.35	34.73	1996222.0
2013-07-10 17:00:00	MSFT	Stock	34.73	35.05	34.68	34.99	21634.0
2013-07-10 18:00:00	MSFT	Stock	34.97	35.01	34.97	35.0	6649.0
2013-07-10 19:00:00	MSFT	Stock	35.05	35.05	35.0	35.0	6800.0
2013-07-10 08:00:00	NVDA	Stock	0.355	0.355	0.355	0.355	8000.0
2013-07-10 09:00:00	NVDA	Stock	0.356	0.3605	0.355	0.36	26134920.0
2013-07-10 10:00:00	NVDA	Stock	0.36	0.3618	0.3575	0.3585	28230360.0
2013-07-10 11:00:00	NVDA	Stock	0.3582	0.3588	0.3565	0.3579	13828840.0
2013-07-10 12:00:00	NVDA	Stock	0.3578	0.3585	0.3572	0.3575	9441680.0
2013-07-10 13:00:00	NVDA	Stock	0.3575	0.358	0.3558	0.3579	16457040.0
2013-07-10 14:00:00	NVDA	Stock	0.358	0.3602	0.3574	0.3588	42432600.0
2013-07-10 15:00:00	NVDA	Stock	0.359	0.361	0.3582	0.3608	61943680.0
2013-07-10 16:00:00	NVDA	Stock	0.3608	0.3608	0.3589	0.3608	1928360.0
2013-07-10 17:00:00	NVDA	Stock	0.361	0.3612	0.361	0.3612	80000.0
2013-07-10 06:00:00	AMZN	Stock	14.5665	14.5725	14.5665	14.5725	4000.0
2013-07-10 07:00:00	AMZN	Stock	14.5725	14.6055	14.5725	14.6055	26000.0
2013-07-10 08:00:00	AMZN	Stock	14.5775	14.5915	14.5675	14.586	84220.0
2013-07-10 09:00:00	AMZN	Stock	14.575	14.6115	14.5	14.5885	7488060.0
2013-07-10 10:00:00	AMZN	Stock	14.589	14.59	14.47	14.5015	5520560.0
2013-07-10 11:00:00	AMZN	Stock	14.496	14.5725	14.49	14.546	4208800.0
2013-07-10 12:00:00	AMZN	Stock	14.5485	14.5685	14.5368	14.5534	1543240.0
2013-07-10 13:00:00	AMZN	Stock	14.5515	14.6265	14.551	14.624	3500940.0
2013-07-10 14:00:00	AMZN	Stock	14.622	14.667	14.553	14.586	6033360.0
2013-07-10 15:00:00	AMZN	Stock	14.586	14.635	14.568	14.6185	5364160.0
2013-07-10 16:00:00	AMZN	Stock	14.6165	14.639	14.5662	14.639	1808540.0
2013-07-10 17:00:00	AMZN	Stock	14.6625	14.6975	14.6625	14.6845	52200.0
2013-07-10 18:00:00	AMZN	Stock	14.6935	14.72	14.6935	14.72	108900.0

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

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