PREVIEW / stock_1hour / 2014-06-18

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-06-18.parquet
  size:    1.0 MB
  rows:    48,252
  symbols: 3,563

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-18 04:00:00	AAPL	Stock	23.065	23.065	23.025	23.05	8400.0
2014-06-18 05:00:00	AAPL	Stock	23.055	23.065	23.055	23.065	5200.0
2014-06-18 06:00:00	AAPL	Stock	23.06	23.07	23.0475	23.0575	14476.0
2014-06-18 07:00:00	AAPL	Stock	23.0575	23.25	23.0425	23.16	416856.0
2014-06-18 08:00:00	AAPL	Stock	23.145	23.1975	23.055	23.12	432620.0
2014-06-18 09:00:00	AAPL	Stock	23.125	23.13	22.925	22.94	20259600.0
2014-06-18 10:00:00	AAPL	Stock	22.94	22.985	22.8625	22.9025	21152484.0
2014-06-18 11:00:00	AAPL	Stock	22.9038	22.9275	22.85	22.9075	12235676.0
2014-06-18 12:00:00	AAPL	Stock	22.905	22.935	22.8875	22.9188	7606092.0
2014-06-18 13:00:00	AAPL	Stock	22.9175	22.925	22.84	22.8625	8864024.0
2014-06-18 14:00:00	AAPL	Stock	22.8625	23.02	22.8375	22.985	23301872.0
2014-06-18 15:00:00	AAPL	Stock	22.9847	23.065	22.9725	23.04	23903892.0
2014-06-18 16:00:00	AAPL	Stock	23.045	23.0775	22.9245	23.045	6067012.0
2014-06-18 17:00:00	AAPL	Stock	23.045	23.055	23.045	23.0475	696348.0
2014-06-18 18:00:00	AAPL	Stock	23.0475	23.055	23.04	23.0525	47508.0
2014-06-18 19:00:00	AAPL	Stock	23.045	23.055	23.04	23.05	70936.0
2014-06-18 05:00:00	MSFT	Stock	41.71	41.71	41.71	41.71	200.0
2014-06-18 06:00:00	MSFT	Stock	41.94	41.94	41.93	41.93	450.0
2014-06-18 08:00:00	MSFT	Stock	41.79	41.79	41.59	41.63	3107.0
2014-06-18 09:00:00	MSFT	Stock	41.63	41.71	41.28	41.31	2591510.0
2014-06-18 10:00:00	MSFT	Stock	41.3	41.38	41.215	41.215	2953535.0
2014-06-18 11:00:00	MSFT	Stock	41.21	41.31	41.2	41.268	2039727.0
2014-06-18 12:00:00	MSFT	Stock	41.27	41.35	41.18	41.34	6286996.0
2014-06-18 13:00:00	MSFT	Stock	41.33	41.41	41.21	41.245	1543106.0
2014-06-18 14:00:00	MSFT	Stock	41.24	41.51	41.18	41.495	3266736.0
2014-06-18 15:00:00	MSFT	Stock	41.5	41.74	41.49	41.65	5312885.0
2014-06-18 16:00:00	MSFT	Stock	41.65	41.66	41.204	41.65	2106697.0
2014-06-18 17:00:00	MSFT	Stock	41.65	41.65	41.65	41.65	400.0
2014-06-18 18:00:00	MSFT	Stock	41.65	41.65	41.65	41.65	43234.0
2014-06-18 19:00:00	MSFT	Stock	41.6	41.6	41.6	41.6	200.0
2014-06-18 09:00:00	NVDA	Stock	0.4883	0.49	0.4855	0.4875	26785680.0
2014-06-18 10:00:00	NVDA	Stock	0.4878	0.492	0.4868	0.4895	39074880.0
2014-06-18 11:00:00	NVDA	Stock	0.4892	0.4898	0.4878	0.4894	14663400.0
2014-06-18 12:00:00	NVDA	Stock	0.4894	0.4912	0.489	0.4901	23597200.0
2014-06-18 13:00:00	NVDA	Stock	0.49	0.4901	0.485	0.485	19181360.0
2014-06-18 14:00:00	NVDA	Stock	0.485	0.489	0.4845	0.4886	28718520.0
2014-06-18 15:00:00	NVDA	Stock	0.4888	0.4904	0.4872	0.4896	52561720.0
2014-06-18 16:00:00	NVDA	Stock	0.4898	0.4899	0.4886	0.4899	297800.0
2014-06-18 06:00:00	AMZN	Stock	16.35	16.35	16.3405	16.3405	6500.0
2014-06-18 07:00:00	AMZN	Stock	16.397	16.401	16.3865	16.3865	18400.0
2014-06-18 08:00:00	AMZN	Stock	16.386	16.424	16.34	16.341	301940.0
2014-06-18 09:00:00	AMZN	Stock	16.363	16.582	16.341	16.499	14684200.0
2014-06-18 10:00:00	AMZN	Stock	16.4935	16.5144	16.389	16.3895	11940960.0
2014-06-18 11:00:00	AMZN	Stock	16.3895	16.4105	16.3105	16.3605	7776580.0
2014-06-18 12:00:00	AMZN	Stock	16.3638	16.3785	16.3285	16.358	3246820.0
2014-06-18 13:00:00	AMZN	Stock	16.36	16.36	16.25	16.3075	10295000.0
2014-06-18 14:00:00	AMZN	Stock	16.3025	16.771	16.2653	16.7685	38341000.0
2014-06-18 15:00:00	AMZN	Stock	16.7661	16.7875	16.6975	16.7185	25453080.0
2014-06-18 16:00:00	AMZN	Stock	16.719	16.744	16.68	16.7125	3280460.0
2014-06-18 17:00:00	AMZN	Stock	16.725	16.9	16.7145	16.85	895260.0

> showing 50 of 48,252 rows — these rows as CSV

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