PREVIEW / stock_1hour / 2014-07-08

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-07-08.parquet
  size:    1.0 MB
  rows:    49,195
  symbols: 3,576

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-07-08 04:00:00	AAPL	Stock	24.0725	24.1175	24.0675	24.0875	27584.0
2014-07-08 05:00:00	AAPL	Stock	24.085	24.085	24.065	24.065	19580.0
2014-07-08 06:00:00	AAPL	Stock	24.0675	24.1	24.065	24.1	97280.0
2014-07-08 07:00:00	AAPL	Stock	24.1025	24.1375	24.1	24.1125	523040.0
2014-07-08 08:00:00	AAPL	Stock	24.1125	24.18	23.925	24.1225	1924804.0
2014-07-08 09:00:00	AAPL	Stock	24.1225	24.2	23.9312	24.04	49712660.0
2014-07-08 10:00:00	AAPL	Stock	24.0398	24.04	23.71	23.8263	54193968.0
2014-07-08 11:00:00	AAPL	Stock	23.825	23.845	23.48	23.56	38573356.0
2014-07-08 12:00:00	AAPL	Stock	23.56	23.74	23.5425	23.735	24125680.0
2014-07-08 13:00:00	AAPL	Stock	23.735	23.85	23.665	23.8275	20064176.0
2014-07-08 14:00:00	AAPL	Stock	23.8275	23.84	23.7575	23.7805	15204876.0
2014-07-08 15:00:00	AAPL	Stock	23.7825	23.85	23.7125	23.8325	27064428.0
2014-07-08 16:00:00	AAPL	Stock	23.8325	23.9618	23.715	23.83	10541980.0
2014-07-08 17:00:00	AAPL	Stock	23.83	23.835	23.815	23.8275	151924.0
2014-07-08 18:00:00	AAPL	Stock	23.8175	23.8325	23.8075	23.825	170220.0
2014-07-08 19:00:00	AAPL	Stock	23.825	23.825	23.755	23.7875	175456.0
2014-07-08 08:00:00	MSFT	Stock	41.8	42.0	41.8	41.9	1100.0
2014-07-08 09:00:00	MSFT	Stock	41.9	41.98	41.75	41.84	3850201.0
2014-07-08 10:00:00	MSFT	Stock	41.835	41.86	41.61	41.83	5372425.0
2014-07-08 11:00:00	MSFT	Stock	41.835	41.88	41.74	41.82	3450391.0
2014-07-08 12:00:00	MSFT	Stock	41.82	41.86	41.795	41.855	2620385.0
2014-07-08 13:00:00	MSFT	Stock	41.855	42.0	41.83	41.94	2295775.0
2014-07-08 14:00:00	MSFT	Stock	41.94	42.0	41.89	41.913	2069565.0
2014-07-08 15:00:00	MSFT	Stock	41.92	41.93	41.75	41.79	5576192.0
2014-07-08 16:00:00	MSFT	Stock	41.78	41.876	41.707	41.83	3225181.0
2014-07-08 09:00:00	NVDA	Stock	0.4662	0.4683	0.465	0.4664	19823560.0
2014-07-08 10:00:00	NVDA	Stock	0.4662	0.4662	0.4618	0.4628	37295040.0
2014-07-08 11:00:00	NVDA	Stock	0.4628	0.4629	0.4593	0.4603	32242120.0
2014-07-08 12:00:00	NVDA	Stock	0.4603	0.4628	0.4598	0.4626	27099280.0
2014-07-08 13:00:00	NVDA	Stock	0.4625	0.464	0.4618	0.4631	28009240.0
2014-07-08 14:00:00	NVDA	Stock	0.463	0.4635	0.462	0.4631	18673320.0
2014-07-08 15:00:00	NVDA	Stock	0.4631	0.4645	0.4622	0.4636	38029440.0
2014-07-08 16:00:00	NVDA	Stock	0.4638	0.465	0.4628	0.4638	17302160.0
2014-07-08 18:00:00	NVDA	Stock	0.4643	0.4643	0.4643	0.4643	60000.0
2014-07-08 08:00:00	AMZN	Stock	16.6775	16.6775	16.646	16.646	30700.0
2014-07-08 09:00:00	AMZN	Stock	16.615	16.687	16.295	16.3445	10764680.0
2014-07-08 10:00:00	AMZN	Stock	16.3415	16.3515	16.079	16.122	19441960.0
2014-07-08 11:00:00	AMZN	Stock	16.1245	16.1895	16.07	16.1305	10918600.0
2014-07-08 12:00:00	AMZN	Stock	16.1365	16.2125	16.114	16.1851	5625180.0
2014-07-08 13:00:00	AMZN	Stock	16.1865	16.2405	16.133	16.2275	7011400.0
2014-07-08 14:00:00	AMZN	Stock	16.225	16.23	16.1305	16.134	6757360.0
2014-07-08 15:00:00	AMZN	Stock	16.1318	16.214	16.111	16.1945	12625800.0
2014-07-08 16:00:00	AMZN	Stock	16.1905	16.2216	16.1424	16.1424	2231300.0
2014-07-08 18:00:00	AMZN	Stock	16.1905	16.1905	16.1905	16.1905	56940.0
2014-07-08 19:00:00	AMZN	Stock	16.2085	16.21	16.2	16.2	13400.0
2014-07-08 08:00:00	GOOGL	Stock	29.407	29.452	29.4065	29.452	8000.0
2014-07-08 09:00:00	GOOGL	Stock	29.432	29.432	28.9	29.025	7227920.0
2014-07-08 10:00:00	GOOGL	Stock	29.0225	29.0435	28.7754	28.8325	5533160.0
2014-07-08 11:00:00	GOOGL	Stock	28.834	28.88	28.7275	28.823	4450180.0
2014-07-08 12:00:00	GOOGL	Stock	28.8212	28.8553	28.7	28.813	2579180.0

> showing 50 of 49,195 rows — these rows as CSV

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