PREVIEW / stock_1hour / 2014-06-20

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-06-20.parquet
  size:    1.1 MB
  rows:    50,773
  symbols: 3,584

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
2014-06-20 04:00:00	AAPL	Stock	22.925	22.945	22.925	22.945	4320.0
2014-06-20 05:00:00	AAPL	Stock	22.935	22.9475	22.935	22.9475	16352.0
2014-06-20 06:00:00	AAPL	Stock	22.9575	22.9575	22.94	22.94	4300.0
2014-06-20 07:00:00	AAPL	Stock	22.95	22.99	22.94	22.97	108632.0
2014-06-20 08:00:00	AAPL	Stock	22.9625	22.985	22.9325	22.955	264148.0
2014-06-20 09:00:00	AAPL	Stock	22.9625	23.1375	22.87	23.1	76466828.0
2014-06-20 10:00:00	AAPL	Stock	23.1	23.1325	22.975	23.0025	31664276.0
2014-06-20 11:00:00	AAPL	Stock	23.0025	23.0625	22.9525	22.975	16630740.0
2014-06-20 12:00:00	AAPL	Stock	22.975	22.995	22.9075	22.9775	14613436.0
2014-06-20 13:00:00	AAPL	Stock	22.9775	23.0	22.93	22.9498	10413296.0
2014-06-20 14:00:00	AAPL	Stock	22.9475	22.9725	22.925	22.9262	11598112.0
2014-06-20 15:00:00	AAPL	Stock	22.925	22.945	22.725	22.725	66143492.0
2014-06-20 16:00:00	AAPL	Stock	22.7325	23.0258	22.705	22.855	159395616.0
2014-06-20 17:00:00	AAPL	Stock	22.8525	22.8625	22.7248	22.795	2590572.0
2014-06-20 18:00:00	AAPL	Stock	22.795	22.8175	22.7275	22.815	240780.0
2014-06-20 19:00:00	AAPL	Stock	22.815	22.865	22.81	22.855	223708.0
2014-06-20 06:00:00	MSFT	Stock	41.53	41.53	41.53	41.53	300.0
2014-06-20 07:00:00	MSFT	Stock	41.48	41.48	41.48	41.48	200.0
2014-06-20 08:00:00	MSFT	Stock	41.5	41.51	41.49	41.49	4558.0
2014-06-20 09:00:00	MSFT	Stock	41.48	41.83	41.38	41.76	20098083.0
2014-06-20 10:00:00	MSFT	Stock	41.76	41.795	41.63	41.76	3827176.0
2014-06-20 11:00:00	MSFT	Stock	41.77	41.82	41.73	41.73	2645970.0
2014-06-20 12:00:00	MSFT	Stock	41.73	41.736	41.59	41.72	1869538.0
2014-06-20 13:00:00	MSFT	Stock	41.73	41.78	41.67	41.67	1614937.0
2014-06-20 14:00:00	MSFT	Stock	41.675	41.75	41.67	41.725	1343091.0
2014-06-20 15:00:00	MSFT	Stock	41.725	41.83	41.66	41.67	8281538.0
2014-06-20 16:00:00	MSFT	Stock	41.67	41.78	41.48	41.696	6695663.0
2014-06-20 17:00:00	MSFT	Stock	41.75	41.76	41.67	41.681	44206.0
2014-06-20 18:00:00	MSFT	Stock	41.7	41.7	41.7	41.7	100.0
2014-06-20 19:00:00	MSFT	Stock	41.67	41.67	41.67	41.67	400.0
2014-06-20 09:00:00	NVDA	Stock	0.4803	0.4814	0.4768	0.4768	65188160.0
2014-06-20 10:00:00	NVDA	Stock	0.4768	0.4775	0.4738	0.4751	40334920.0
2014-06-20 11:00:00	NVDA	Stock	0.475	0.4753	0.4715	0.4715	25290120.0
2014-06-20 12:00:00	NVDA	Stock	0.4715	0.4718	0.4702	0.4702	30968240.0
2014-06-20 13:00:00	NVDA	Stock	0.4702	0.4728	0.4695	0.4721	22940480.0
2014-06-20 14:00:00	NVDA	Stock	0.4723	0.4742	0.4718	0.4734	23637560.0
2014-06-20 15:00:00	NVDA	Stock	0.4734	0.4735	0.4715	0.4731	73098000.0
2014-06-20 16:00:00	NVDA	Stock	0.4732	0.4777	0.4725	0.4735	61873920.0
2014-06-20 17:00:00	NVDA	Stock	0.4732	0.4735	0.4732	0.4735	131720.0
2014-06-20 07:00:00	AMZN	Stock	16.4	16.4	16.4	16.4	2000.0
2014-06-20 08:00:00	AMZN	Stock	16.429	16.429	16.375	16.4	28560.0
2014-06-20 09:00:00	AMZN	Stock	16.3945	16.4275	16.1445	16.1514	28388620.0
2014-06-20 10:00:00	AMZN	Stock	16.146	16.217	16.021	16.0825	20388920.0
2014-06-20 11:00:00	AMZN	Stock	16.088	16.15	16.0475	16.1112	8128500.0
2014-06-20 12:00:00	AMZN	Stock	16.11	16.1425	16.059	16.103	4569220.0
2014-06-20 13:00:00	AMZN	Stock	16.1065	16.1125	16.0525	16.101	3628860.0
2014-06-20 14:00:00	AMZN	Stock	16.1025	16.1281	16.0875	16.122	3581440.0
2014-06-20 15:00:00	AMZN	Stock	16.121	16.21	16.1	16.2015	14282760.0
2014-06-20 16:00:00	AMZN	Stock	16.21	16.2495	16.1262	16.225	20319460.0
2014-06-20 17:00:00	AMZN	Stock	16.2125	16.22	16.1605	16.163	84220.0

> showing 50 of 50,773 rows — these rows as CSV

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