PREVIEW / stock_1hour / 2015-03-13

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-03-13.parquet
  size:    1.0 MB
  rows:    48,249
  symbols: 3,489

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-13 04:00:00	AAPL	Stock	31.2	31.2125	31.17	31.1875	21200.0
2015-03-13 05:00:00	AAPL	Stock	31.1925	31.3	31.1875	31.3	37920.0
2015-03-13 06:00:00	AAPL	Stock	31.2325	31.25	31.185	31.225	84168.0
2015-03-13 07:00:00	AAPL	Stock	31.225	31.25	31.135	31.1375	161920.0
2015-03-13 08:00:00	AAPL	Stock	31.1625	31.25	31.0375	31.07	594176.0
2015-03-13 09:00:00	AAPL	Stock	31.0775	31.3488	30.975	31.1945	30829672.0
2015-03-13 10:00:00	AAPL	Stock	31.1925	31.2275	30.9475	30.949	33435884.0
2015-03-13 11:00:00	AAPL	Stock	30.95	31.0575	30.8925	30.9365	21865452.0
2015-03-13 12:00:00	AAPL	Stock	30.9375	30.945	30.73	30.84	23355528.0
2015-03-13 13:00:00	AAPL	Stock	30.8375	30.879	30.68	30.7575	20109028.0
2015-03-13 14:00:00	AAPL	Stock	30.76	30.825	30.645	30.81	19071720.0
2015-03-13 15:00:00	AAPL	Stock	30.8125	30.91	30.7288	30.8975	31543468.0
2015-03-13 16:00:00	AAPL	Stock	30.89	31.1038	30.7865	30.91	9564056.0
2015-03-13 17:00:00	AAPL	Stock	30.9025	30.9025	30.8625	30.865	150604.0
2015-03-13 18:00:00	AAPL	Stock	30.865	30.8975	30.86	30.875	180028.0
2015-03-13 19:00:00	AAPL	Stock	30.875	30.875	30.8475	30.865	101584.0
2015-03-13 05:00:00	MSFT	Stock	41.1	41.1	41.1	41.1	1000.0
2015-03-13 06:00:00	MSFT	Stock	41.2	41.2	41.07	41.12	4762.0
2015-03-13 07:00:00	MSFT	Stock	41.1	41.1	40.99	40.99	3089.0
2015-03-13 08:00:00	MSFT	Stock	40.99	41.01	40.79	40.83	42688.0
2015-03-13 09:00:00	MSFT	Stock	40.85	41.039	40.61	41.02	9418573.0
2015-03-13 10:00:00	MSFT	Stock	41.02	41.09	40.8	40.84	9600708.0
2015-03-13 11:00:00	MSFT	Stock	40.83	40.92	40.755	40.843	6819350.0
2015-03-13 12:00:00	MSFT	Stock	40.85	41.09	40.78	40.99	6078444.0
2015-03-13 13:00:00	MSFT	Stock	41.0	41.21	40.95	41.12	4116134.0
2015-03-13 14:00:00	MSFT	Stock	41.124	41.21	41.08	41.165	4067295.0
2015-03-13 15:00:00	MSFT	Stock	41.16	41.47	41.14	41.37	8929604.0
2015-03-13 16:00:00	MSFT	Stock	41.38	41.424	40.81	41.35	4048669.0
2015-03-13 17:00:00	MSFT	Stock	41.34	41.35	41.3	41.35	2507.0
2015-03-13 18:00:00	MSFT	Stock	41.299	41.38	41.299	41.35	34042.0
2015-03-13 19:00:00	MSFT	Stock	41.27	41.27	41.27	41.27	500.0
2015-03-13 09:00:00	NVDA	Stock	0.5642	0.5662	0.5608	0.5618	96314360.0
2015-03-13 10:00:00	NVDA	Stock	0.5618	0.5635	0.557	0.557	41128080.0
2015-03-13 11:00:00	NVDA	Stock	0.557	0.559	0.5562	0.559	49194480.0
2015-03-13 12:00:00	NVDA	Stock	0.5591	0.5652	0.5581	0.5648	47756720.0
2015-03-13 13:00:00	NVDA	Stock	0.5645	0.5652	0.562	0.5652	23403400.0
2015-03-13 14:00:00	NVDA	Stock	0.5652	0.5658	0.5621	0.5632	26354120.0
2015-03-13 15:00:00	NVDA	Stock	0.5632	0.569	0.5626	0.5675	56379760.0
2015-03-13 16:00:00	NVDA	Stock	0.5675	0.5676	0.5623	0.5623	4603800.0
2015-03-13 04:00:00	AMZN	Stock	18.722	18.722	18.722	18.722	11300.0
2015-03-13 08:00:00	AMZN	Stock	18.6525	18.675	18.6525	18.675	6960.0
2015-03-13 09:00:00	AMZN	Stock	18.65	18.6995	18.525	18.5705	5491820.0
2015-03-13 10:00:00	AMZN	Stock	18.5695	18.57	18.439	18.454	7561660.0
2015-03-13 11:00:00	AMZN	Stock	18.45	18.464	18.4005	18.452	6019940.0
2015-03-13 12:00:00	AMZN	Stock	18.4485	18.479	18.3875	18.479	3905500.0
2015-03-13 13:00:00	AMZN	Stock	18.476	18.4825	18.3575	18.3648	4108880.0
2015-03-13 14:00:00	AMZN	Stock	18.368	18.387	18.334	18.372	3297960.0
2015-03-13 15:00:00	AMZN	Stock	18.3675	18.5815	18.345	18.5265	14857480.0
2015-03-13 16:00:00	AMZN	Stock	18.529	18.5635	18.4782	18.5635	1058940.0
2015-03-13 17:00:00	AMZN	Stock	18.525	18.525	18.525	18.525	8040.0

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

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