PREVIEW / stock_1hour / 2014-03-14

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-03-14.parquet
  size:    1.0 MB
  rows:    47,919
  symbols: 3,543

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-03-14 04:00:00	AAPL	Stock	18.8925	18.9286	18.8925	18.8929	16800.0
2014-03-14 06:00:00	AAPL	Stock	18.9071	18.9071	18.9018	18.9018	5600.0
2014-03-14 07:00:00	AAPL	Stock	18.9071	18.9371	18.8968	18.9114	143108.0
2014-03-14 08:00:00	AAPL	Stock	18.9196	18.9286	18.8786	18.885	336896.0
2014-03-14 09:00:00	AAPL	Stock	18.8929	18.9604	18.7939	18.8089	30243444.0
2014-03-14 10:00:00	AAPL	Stock	18.8046	18.86	18.7057	18.73	46466196.0
2014-03-14 11:00:00	AAPL	Stock	18.7307	18.8296	18.6786	18.8099	35261940.0
2014-03-14 12:00:00	AAPL	Stock	18.8107	18.8175	18.7414	18.7661	13212864.0
2014-03-14 13:00:00	AAPL	Stock	18.7659	18.7736	18.7343	18.7522	11077080.0
2014-03-14 14:00:00	AAPL	Stock	18.7496	18.7504	18.6875	18.6925	12119576.0
2014-03-14 15:00:00	AAPL	Stock	18.6943	18.7639	18.6861	18.7379	34956460.0
2014-03-14 16:00:00	AAPL	Stock	18.7382	18.7732	18.7332	18.7396	9284548.0
2014-03-14 17:00:00	AAPL	Stock	18.7429	18.7429	18.7311	18.7311	324464.0
2014-03-14 18:00:00	AAPL	Stock	18.7268	18.7425	18.7268	18.7382	314552.0
2014-03-14 19:00:00	AAPL	Stock	18.7321	18.7425	18.7264	18.7425	114324.0
2014-03-14 06:00:00	MSFT	Stock	37.87	37.87	37.87	37.87	100.0
2014-03-14 07:00:00	MSFT	Stock	37.77	37.77	37.76	37.76	1000.0
2014-03-14 08:00:00	MSFT	Stock	37.69	37.8	37.66	37.8	10423.0
2014-03-14 09:00:00	MSFT	Stock	37.8	38.09	37.61	37.824	3566743.0
2014-03-14 10:00:00	MSFT	Stock	37.83	38.13	37.82	37.86	4978248.0
2014-03-14 11:00:00	MSFT	Stock	37.86	38.135	37.815	38.095	2806025.0
2014-03-14 12:00:00	MSFT	Stock	38.09	38.11	37.8	37.95	2668763.0
2014-03-14 13:00:00	MSFT	Stock	37.955	38.0	37.81	37.86	1753936.0
2014-03-14 14:00:00	MSFT	Stock	37.86	37.88	37.76	37.765	2039422.0
2014-03-14 15:00:00	MSFT	Stock	37.765	37.925	37.69	37.7	5962987.0
2014-03-14 16:00:00	MSFT	Stock	37.7	38.041	37.65	37.7	2589170.0
2014-03-14 17:00:00	MSFT	Stock	37.69	37.821	37.67	37.69	1572.0
2014-03-14 18:00:00	MSFT	Stock	37.67	37.7	37.67	37.7	7660.0
2014-03-14 19:00:00	MSFT	Stock	37.7	37.7	37.66	37.66	2600.0
2014-03-14 09:00:00	NVDA	Stock	0.4442	0.4495	0.439	0.446	39871360.0
2014-03-14 10:00:00	NVDA	Stock	0.4458	0.4478	0.444	0.4445	39456320.0
2014-03-14 11:00:00	NVDA	Stock	0.4445	0.4455	0.4428	0.445	37303160.0
2014-03-14 12:00:00	NVDA	Stock	0.445	0.4451	0.4422	0.4444	37020960.0
2014-03-14 13:00:00	NVDA	Stock	0.4445	0.4465	0.444	0.4464	58802800.0
2014-03-14 14:00:00	NVDA	Stock	0.4462	0.4472	0.4442	0.4449	57135840.0
2014-03-14 15:00:00	NVDA	Stock	0.4449	0.4468	0.4445	0.445	159925600.0
2014-03-14 16:00:00	NVDA	Stock	0.4455	0.4462	0.4452	0.4454	7729280.0
2014-03-14 17:00:00	NVDA	Stock	0.443	0.443	0.443	0.443	12000.0
2014-03-14 05:00:00	AMZN	Stock	18.6475	18.6475	18.6475	18.6475	4000.0
2014-03-14 06:00:00	AMZN	Stock	18.7265	18.75	18.7265	18.742	6000.0
2014-03-14 07:00:00	AMZN	Stock	18.756	18.8	18.7445	18.7445	36000.0
2014-03-14 08:00:00	AMZN	Stock	18.728	18.728	18.5695	18.69	323980.0
2014-03-14 09:00:00	AMZN	Stock	18.6845	18.9284	18.625	18.8098	16912140.0
2014-03-14 10:00:00	AMZN	Stock	18.8081	18.899	18.631	18.662	13640520.0
2014-03-14 11:00:00	AMZN	Stock	18.6575	18.85	18.5775	18.8195	11592360.0
2014-03-14 12:00:00	AMZN	Stock	18.8278	18.8278	18.6756	18.723	9217200.0
2014-03-14 13:00:00	AMZN	Stock	18.725	18.7385	18.626	18.6745	8008200.0
2014-03-14 14:00:00	AMZN	Stock	18.6675	18.7375	18.6446	18.6655	7172320.0
2014-03-14 15:00:00	AMZN	Stock	18.6632	18.742	18.6385	18.6875	14380580.0
2014-03-14 16:00:00	AMZN	Stock	18.687	18.7456	18.66	18.66	408780.0

> showing 50 of 47,919 rows — these rows as CSV

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