PREVIEW / stock_1hour / 2015-04-20

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-04-20.parquet
  size:    1.1 MB
  rows:    49,211
  symbols: 3,502

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-04-20 04:00:00	AAPL	Stock	31.375	31.4075	31.3475	31.39	35436.0
2015-04-20 05:00:00	AAPL	Stock	31.4	31.4	31.325	31.3625	24920.0
2015-04-20 06:00:00	AAPL	Stock	31.355	31.425	31.355	31.425	31792.0
2015-04-20 07:00:00	AAPL	Stock	31.4125	31.4675	31.315	31.3425	250748.0
2015-04-20 08:00:00	AAPL	Stock	31.3475	31.4675	31.3	31.37	746448.0
2015-04-20 09:00:00	AAPL	Stock	31.37	31.6	31.2925	31.5975	27502612.0
2015-04-20 10:00:00	AAPL	Stock	31.5975	31.7875	31.53	31.785	35519180.0
2015-04-20 11:00:00	AAPL	Stock	31.785	31.9025	31.7825	31.894	23112216.0
2015-04-20 12:00:00	AAPL	Stock	31.895	31.98	31.87	31.9275	17111256.0
2015-04-20 13:00:00	AAPL	Stock	31.9255	32.03	31.9225	32.0	16423340.0
2015-04-20 14:00:00	AAPL	Stock	32.0012	32.0125	31.9325	31.955	14337316.0
2015-04-20 15:00:00	AAPL	Stock	31.955	31.975	31.8275	31.8975	29304740.0
2015-04-20 16:00:00	AAPL	Stock	31.9	31.935	31.8825	31.8825	12562932.0
2015-04-20 17:00:00	AAPL	Stock	31.8975	31.9075	31.8775	31.9	86548.0
2015-04-20 18:00:00	AAPL	Stock	31.8975	31.91	31.8925	31.905	47944.0
2015-04-20 19:00:00	AAPL	Stock	31.9	31.925	31.895	31.925	136536.0
2015-04-20 05:00:00	MSFT	Stock	41.68	41.68	41.62	41.62	300.0
2015-04-20 07:00:00	MSFT	Stock	41.75	41.75	41.68	41.68	1100.0
2015-04-20 08:00:00	MSFT	Stock	41.66	41.73	41.615	41.73	12560.0
2015-04-20 09:00:00	MSFT	Stock	41.7	42.21	41.64	42.2	3669167.0
2015-04-20 10:00:00	MSFT	Stock	42.21	42.49	42.17	42.48	4808805.0
2015-04-20 11:00:00	MSFT	Stock	42.48	42.64	42.48	42.63	4367414.0
2015-04-20 12:00:00	MSFT	Stock	42.63	42.86	42.615	42.855	3347392.0
2015-04-20 13:00:00	MSFT	Stock	42.85	43.11	42.84	43.035	6920911.0
2015-04-20 14:00:00	MSFT	Stock	43.035	43.04	42.83	43.0	5089665.0
2015-04-20 15:00:00	MSFT	Stock	42.995	43.17	42.89	42.9	9625509.0
2015-04-20 16:00:00	MSFT	Stock	42.905	43.01	42.82	42.87	4507289.0
2015-04-20 17:00:00	MSFT	Stock	42.87	42.9	42.87	42.9	5735.0
2015-04-20 18:00:00	MSFT	Stock	42.899	42.899	42.891	42.891	1600.0
2015-04-20 19:00:00	MSFT	Stock	42.9	42.92	42.9	42.92	380.0
2015-04-20 09:00:00	NVDA	Stock	0.5575	0.561	0.5565	0.557	14335240.0
2015-04-20 10:00:00	NVDA	Stock	0.5572	0.5598	0.5572	0.5596	17531880.0
2015-04-20 11:00:00	NVDA	Stock	0.5598	0.561	0.5594	0.5602	14628520.0
2015-04-20 12:00:00	NVDA	Stock	0.5601	0.5602	0.5559	0.5565	22423000.0
2015-04-20 13:00:00	NVDA	Stock	0.5568	0.557	0.5525	0.5525	25805200.0
2015-04-20 14:00:00	NVDA	Stock	0.5528	0.555	0.5522	0.5541	32567720.0
2015-04-20 15:00:00	NVDA	Stock	0.5542	0.555	0.5512	0.5522	84634360.0
2015-04-20 16:00:00	NVDA	Stock	0.5522	0.5525	0.5522	0.5525	8630720.0
2015-04-20 17:00:00	NVDA	Stock	0.553	0.553	0.553	0.553	20000.0
2015-04-20 04:00:00	AMZN	Stock	18.913	18.913	18.895	18.895	5540.0
2015-04-20 07:00:00	AMZN	Stock	18.9145	18.969	18.9145	18.969	53180.0
2015-04-20 08:00:00	AMZN	Stock	18.9495	18.989	18.931	18.941	136320.0
2015-04-20 09:00:00	AMZN	Stock	18.949	19.0555	18.85	19.034	7999620.0
2015-04-20 10:00:00	AMZN	Stock	19.0315	19.0935	18.9865	19.0805	7898140.0
2015-04-20 11:00:00	AMZN	Stock	19.08	19.19	19.0655	19.1855	6162640.0
2015-04-20 12:00:00	AMZN	Stock	19.1822	19.2735	19.11	19.261	9615620.0
2015-04-20 13:00:00	AMZN	Stock	19.261	19.3885	19.2525	19.3845	11302360.0
2015-04-20 14:00:00	AMZN	Stock	19.3845	19.456	19.3775	19.4425	13204960.0
2015-04-20 15:00:00	AMZN	Stock	19.449	19.597	19.4425	19.475	26073960.0
2015-04-20 16:00:00	AMZN	Stock	19.4755	19.5	19.45	19.45	9753260.0

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

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