PREVIEW / stock_1hour / 2013-05-13

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-05-13.parquet
  size:    990 KB
  rows:    45,728
  symbols: 3,503

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-13 04:00:00	AAPL	Stock	16.1607	16.1607	16.1607	16.1607	2800.0
2013-05-13 05:00:00	AAPL	Stock	16.0964	16.0964	16.0964	16.0964	2800.0
2013-05-13 06:00:00	AAPL	Stock	16.0739	16.0743	16.0643	16.0643	18200.0
2013-05-13 07:00:00	AAPL	Stock	16.0732	16.125	16.0732	16.125	193704.0
2013-05-13 08:00:00	AAPL	Stock	16.1421	16.2464	16.0661	16.2179	2731344.0
2013-05-13 09:00:00	AAPL	Stock	16.2211	16.35	16.125	16.2357	74745300.0
2013-05-13 10:00:00	AAPL	Stock	16.235	16.2836	16.1904	16.2491	40726364.0
2013-05-13 11:00:00	AAPL	Stock	16.2489	16.2557	16.179	16.2525	30973040.0
2013-05-13 12:00:00	AAPL	Stock	16.2529	16.3536	16.2371	16.3237	39569320.0
2013-05-13 13:00:00	AAPL	Stock	16.3202	16.3411	16.2739	16.2942	22054984.0
2013-05-13 14:00:00	AAPL	Stock	16.2932	16.3381	16.2857	16.3004	21198548.0
2013-05-13 15:00:00	AAPL	Stock	16.3041	16.3041	16.2254	16.2407	44405200.0
2013-05-13 16:00:00	AAPL	Stock	16.2407	16.2666	16.2346	16.25	23226896.0
2013-05-13 17:00:00	AAPL	Stock	16.2407	16.25	16.2407	16.25	255752.0
2013-05-13 18:00:00	AAPL	Stock	16.2411	16.25	16.2411	16.25	76636.0
2013-05-13 19:00:00	AAPL	Stock	16.25	16.2593	16.25	16.2589	148792.0
2013-05-13 07:00:00	MSFT	Stock	32.69	32.69	32.65	32.65	2600.0
2013-05-13 08:00:00	MSFT	Stock	32.61	32.71	32.61	32.68	11676.0
2013-05-13 09:00:00	MSFT	Stock	32.68	32.9	32.55	32.8	4227344.0
2013-05-13 10:00:00	MSFT	Stock	32.79	32.9	32.71	32.758	5651075.0
2013-05-13 11:00:00	MSFT	Stock	32.75	32.81	32.68	32.76	3515999.0
2013-05-13 12:00:00	MSFT	Stock	32.77	32.81	32.73	32.75	1869873.0
2013-05-13 13:00:00	MSFT	Stock	32.75	32.77	32.71	32.758	2836070.0
2013-05-13 14:00:00	MSFT	Stock	32.75	32.97	32.74	32.935	4075545.0
2013-05-13 15:00:00	MSFT	Stock	32.935	33.07	32.87	33.06	10058658.0
2013-05-13 16:00:00	MSFT	Stock	33.03	33.07	32.803	33.03	2501141.0
2013-05-13 17:00:00	MSFT	Stock	33.04	33.07	33.03	33.07	8307.0
2013-05-13 18:00:00	MSFT	Stock	33.07	33.07	33.07	33.07	9320.0
2013-05-13 06:00:00	NVDA	Stock	0.3615	0.3615	0.3615	0.3615	12000.0
2013-05-13 07:00:00	NVDA	Stock	0.3615	0.3615	0.3608	0.3608	20000.0
2013-05-13 08:00:00	NVDA	Stock	0.3608	0.3615	0.3592	0.3608	334000.0
2013-05-13 09:00:00	NVDA	Stock	0.3612	0.3625	0.3595	0.3621	34308120.0
2013-05-13 10:00:00	NVDA	Stock	0.362	0.3624	0.358	0.3585	51998920.0
2013-05-13 11:00:00	NVDA	Stock	0.3586	0.3586	0.356	0.3568	38576560.0
2013-05-13 12:00:00	NVDA	Stock	0.357	0.3588	0.3568	0.3572	21499120.0
2013-05-13 13:00:00	NVDA	Stock	0.357	0.3572	0.3555	0.3555	25988880.0
2013-05-13 14:00:00	NVDA	Stock	0.3556	0.3565	0.3555	0.356	22285240.0
2013-05-13 15:00:00	NVDA	Stock	0.356	0.356	0.3545	0.356	78700440.0
2013-05-13 16:00:00	NVDA	Stock	0.356	0.3576	0.3558	0.356	13522000.0
2013-05-13 17:00:00	NVDA	Stock	0.3568	0.357	0.356	0.357	173520.0
2013-05-13 18:00:00	NVDA	Stock	0.357	0.3575	0.357	0.3575	240000.0
2013-05-13 19:00:00	NVDA	Stock	0.3568	0.3568	0.3568	0.3568	8000.0
2013-05-13 08:00:00	AMZN	Stock	13.15	13.169	13.1325	13.133	14000.0
2013-05-13 09:00:00	AMZN	Stock	13.163	13.1685	13.1	13.165	5806140.0
2013-05-13 10:00:00	AMZN	Stock	13.1655	13.284	13.1354	13.2135	8099700.0
2013-05-13 11:00:00	AMZN	Stock	13.218	13.2725	13.1885	13.2632	3597320.0
2013-05-13 12:00:00	AMZN	Stock	13.263	13.294	13.25	13.2595	3444920.0
2013-05-13 13:00:00	AMZN	Stock	13.2615	13.2795	13.1775	13.206	3945520.0
2013-05-13 14:00:00	AMZN	Stock	13.202	13.2465	13.1904	13.2085	5281080.0
2013-05-13 15:00:00	AMZN	Stock	13.2065	13.2495	13.163	13.227	7819140.0

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

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