PREVIEW / stock_1hour / 2015-03-12

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-03-12.parquet
  size:    1.0 MB
  rows:    48,454
  symbols: 3,521

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
2015-03-12 04:00:00	AAPL	Stock	30.7475	30.8575	30.69	30.6975	12400.0
2015-03-12 05:00:00	AAPL	Stock	30.69	30.6925	30.64	30.65	47160.0
2015-03-12 06:00:00	AAPL	Stock	30.675	30.72	30.63	30.72	46904.0
2015-03-12 07:00:00	AAPL	Stock	30.7175	30.7175	30.6525	30.71	89780.0
2015-03-12 08:00:00	AAPL	Stock	30.7125	30.7175	30.58	30.6375	1120020.0
2015-03-12 09:00:00	AAPL	Stock	30.6375	30.9275	30.4075	30.905	38309788.0
2015-03-12 10:00:00	AAPL	Stock	30.905	31.11	30.8325	31.0125	35927036.0
2015-03-12 11:00:00	AAPL	Stock	31.01	31.0925	30.9175	30.955	18132288.0
2015-03-12 12:00:00	AAPL	Stock	30.955	31.1025	30.9475	31.015	14010672.0
2015-03-12 13:00:00	AAPL	Stock	31.0125	31.175	30.98	31.1425	13824064.0
2015-03-12 14:00:00	AAPL	Stock	31.1425	31.225	31.04	31.1502	21959352.0
2015-03-12 15:00:00	AAPL	Stock	31.15	31.1862	31.045	31.11	24961932.0
2015-03-12 16:00:00	AAPL	Stock	31.1125	31.1865	30.56	31.1375	12537784.0
2015-03-12 17:00:00	AAPL	Stock	31.1325	31.135	31.1125	31.125	200344.0
2015-03-12 18:00:00	AAPL	Stock	31.125	31.195	31.1225	31.19	273832.0
2015-03-12 19:00:00	AAPL	Stock	31.1925	31.2125	31.165	31.2075	161652.0
2015-03-12 05:00:00	MSFT	Stock	42.22	42.22	42.22	42.22	100.0
2015-03-12 08:00:00	MSFT	Stock	42.11	42.15	42.05	42.15	8400.0
2015-03-12 09:00:00	MSFT	Stock	42.1	42.1	40.67	41.38	13215634.0
2015-03-12 10:00:00	MSFT	Stock	41.39	41.6	41.35	41.384	8394768.0
2015-03-12 11:00:00	MSFT	Stock	41.38	41.42	41.16	41.24	6977594.0
2015-03-12 12:00:00	MSFT	Stock	41.24	41.24	41.1	41.2	4172943.0
2015-03-12 13:00:00	MSFT	Stock	41.2	41.27	41.125	41.149	4152523.0
2015-03-12 14:00:00	MSFT	Stock	41.14	41.15	40.86	41.0	7375120.0
2015-03-12 15:00:00	MSFT	Stock	40.995	41.09	40.98	41.01	10901188.0
2015-03-12 16:00:00	MSFT	Stock	41.02	41.345	40.95	41.01	2746928.0
2015-03-12 17:00:00	MSFT	Stock	41.02	41.02	40.96	40.98	17010.0
2015-03-12 18:00:00	MSFT	Stock	41.0	41.0	40.98	40.98	2966.0
2015-03-12 19:00:00	MSFT	Stock	40.99	41.04	40.99	41.01	3468.0
2015-03-12 09:00:00	NVDA	Stock	0.57	0.5722	0.556	0.5655	128484240.0
2015-03-12 10:00:00	NVDA	Stock	0.5652	0.5659	0.5588	0.564	42352640.0
2015-03-12 11:00:00	NVDA	Stock	0.5637	0.5671	0.563	0.5666	36135080.0
2015-03-12 12:00:00	NVDA	Stock	0.5667	0.5702	0.5648	0.5698	25224600.0
2015-03-12 13:00:00	NVDA	Stock	0.5698	0.5708	0.5678	0.5678	24773320.0
2015-03-12 14:00:00	NVDA	Stock	0.5678	0.568	0.563	0.5635	27877080.0
2015-03-12 15:00:00	NVDA	Stock	0.5638	0.5672	0.5625	0.5665	77126760.0
2015-03-12 16:00:00	NVDA	Stock	0.5668	0.567	0.5642	0.567	23114960.0
2015-03-12 17:00:00	NVDA	Stock	0.565	0.565	0.565	0.565	20000.0
2015-03-12 19:00:00	NVDA	Stock	0.565	0.5655	0.565	0.5655	14200.0
2015-03-12 08:00:00	AMZN	Stock	18.395	18.4315	18.395	18.4305	18200.0
2015-03-12 09:00:00	AMZN	Stock	18.4055	18.588	18.376	18.569	6561380.0
2015-03-12 10:00:00	AMZN	Stock	18.5735	18.6665	18.5525	18.584	8474040.0
2015-03-12 11:00:00	AMZN	Stock	18.5788	18.6912	18.573	18.668	7047300.0
2015-03-12 12:00:00	AMZN	Stock	18.665	18.6855	18.624	18.6785	3953780.0
2015-03-12 13:00:00	AMZN	Stock	18.675	18.708	18.6685	18.6875	5845020.0
2015-03-12 14:00:00	AMZN	Stock	18.689	18.71	18.628	18.7075	4267720.0
2015-03-12 15:00:00	AMZN	Stock	18.705	18.775	18.68	18.712	11833360.0
2015-03-12 16:00:00	AMZN	Stock	18.712	18.7225	18.6366	18.7215	3652860.0
2015-03-12 17:00:00	AMZN	Stock	18.712	18.732	18.712	18.732	37560.0
2015-03-12 19:00:00	AMZN	Stock	18.7245	18.7245	18.7245	18.7245	2000.0

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

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