PREVIEW / stock_1hour / 2013-11-27

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-11-27.parquet
  size:    1011 KB
  rows:    46,934
  symbols: 3,550

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-11-27 05:00:00	AAPL	Stock	19.0971	19.0971	19.0971	19.0971	2800.0
2013-11-27 06:00:00	AAPL	Stock	19.0996	19.1239	19.0936	19.1071	158956.0
2013-11-27 07:00:00	AAPL	Stock	19.1157	19.1789	19.1071	19.1589	1188348.0
2013-11-27 08:00:00	AAPL	Stock	19.1607	19.1846	19.0679	19.1643	2588320.0
2013-11-27 09:00:00	AAPL	Stock	19.1625	19.3964	19.1429	19.3711	102623864.0
2013-11-27 10:00:00	AAPL	Stock	19.3714	19.4268	19.3279	19.4064	69299132.0
2013-11-27 11:00:00	AAPL	Stock	19.4057	19.4643	19.3979	19.4568	42979608.0
2013-11-27 12:00:00	AAPL	Stock	19.4573	19.4596	19.3839	19.4092	32301500.0
2013-11-27 13:00:00	AAPL	Stock	19.4089	19.4336	19.3789	19.4319	19568332.0
2013-11-27 14:00:00	AAPL	Stock	19.4296	19.4682	19.4232	19.4475	28601496.0
2013-11-27 15:00:00	AAPL	Stock	19.4475	19.5	19.4196	19.4992	44984324.0
2013-11-27 16:00:00	AAPL	Stock	19.4986	19.525	19.3704	19.5132	11399836.0
2013-11-27 17:00:00	AAPL	Stock	19.5104	19.5389	19.5104	19.5329	737268.0
2013-11-27 18:00:00	AAPL	Stock	19.5329	19.5443	19.4986	19.5361	299544.0
2013-11-27 19:00:00	AAPL	Stock	19.5361	19.5446	19.5357	19.5357	394436.0
2013-11-27 07:00:00	MSFT	Stock	37.47	37.47	37.47	37.47	100.0
2013-11-27 08:00:00	MSFT	Stock	37.49	37.55	37.45	37.5	43500.0
2013-11-27 09:00:00	MSFT	Stock	37.52	37.76	37.49	37.73	3629093.0
2013-11-27 10:00:00	MSFT	Stock	37.73	37.73	37.63	37.695	3026569.0
2013-11-27 11:00:00	MSFT	Stock	37.69	37.715	37.58	37.63	3252381.0
2013-11-27 12:00:00	MSFT	Stock	37.63	37.69	37.595	37.63	2492377.0
2013-11-27 13:00:00	MSFT	Stock	37.62	37.68	37.61	37.64	1692925.0
2013-11-27 14:00:00	MSFT	Stock	37.65	37.72	37.63	37.69	2116754.0
2013-11-27 15:00:00	MSFT	Stock	37.69	37.7	37.58	37.61	4397881.0
2013-11-27 16:00:00	MSFT	Stock	37.6	37.66	37.6	37.66	1704181.0
2013-11-27 17:00:00	MSFT	Stock	37.56	37.72	37.56	37.72	1716.0
2013-11-27 18:00:00	MSFT	Stock	37.61	37.61	37.61	37.61	200.0
2013-11-27 19:00:00	MSFT	Stock	37.72	37.72	37.71	37.71	333.0
2013-11-27 09:00:00	NVDA	Stock	0.3908	0.3933	0.39	0.39	16306640.0
2013-11-27 10:00:00	NVDA	Stock	0.3901	0.3913	0.3882	0.3909	30614760.0
2013-11-27 11:00:00	NVDA	Stock	0.3909	0.3925	0.3905	0.3918	20716160.0
2013-11-27 12:00:00	NVDA	Stock	0.3918	0.3935	0.391	0.393	29012720.0
2013-11-27 13:00:00	NVDA	Stock	0.3929	0.3933	0.392	0.3924	9269920.0
2013-11-27 14:00:00	NVDA	Stock	0.3924	0.3936	0.392	0.3931	14866720.0
2013-11-27 15:00:00	NVDA	Stock	0.3931	0.3933	0.392	0.3925	38472320.0
2013-11-27 16:00:00	NVDA	Stock	0.3925	0.3926	0.3918	0.3926	6259280.0
2013-11-27 04:00:00	AMZN	Stock	19.0825	19.0825	19.0825	19.0825	2000.0
2013-11-27 07:00:00	AMZN	Stock	19.125	19.158	19.11	19.158	121540.0
2013-11-27 08:00:00	AMZN	Stock	19.155	19.155	19.1025	19.141	130320.0
2013-11-27 09:00:00	AMZN	Stock	19.15	19.35	19.1305	19.2975	13186840.0
2013-11-27 10:00:00	AMZN	Stock	19.2974	19.318	19.2265	19.24	7493180.0
2013-11-27 11:00:00	AMZN	Stock	19.2335	19.315	19.2335	19.2595	4223240.0
2013-11-27 12:00:00	AMZN	Stock	19.267	19.299	19.232	19.2565	2680300.0
2013-11-27 13:00:00	AMZN	Stock	19.25	19.264	19.219	19.2285	3618700.0
2013-11-27 14:00:00	AMZN	Stock	19.2325	19.31	19.2125	19.2735	3245240.0
2013-11-27 15:00:00	AMZN	Stock	19.2774	19.3415	19.246	19.33	7593840.0
2013-11-27 16:00:00	AMZN	Stock	19.3355	19.35	19.267	19.3375	2904960.0
2013-11-27 17:00:00	AMZN	Stock	19.3095	19.3225	19.3095	19.3225	4900.0
2013-11-27 18:00:00	AMZN	Stock	19.3345	19.3375	19.3155	19.335	27500.0
2013-11-27 19:00:00	AMZN	Stock	19.32	19.32	19.32	19.32	8500.0

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

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