PREVIEW / stock_1hour / 2014-04-11

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-04-11.parquet
  size:    1.0 MB
  rows:    47,984
  symbols: 3,546

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-04-11 04:00:00	AAPL	Stock	18.6729	18.6889	18.6729	18.6771	14000.0
2014-04-11 05:00:00	AAPL	Stock	18.6736	18.6821	18.6736	18.6821	5600.0
2014-04-11 06:00:00	AAPL	Stock	18.695	18.695	18.65	18.65	8400.0
2014-04-11 07:00:00	AAPL	Stock	18.6654	18.6654	18.5264	18.5982	280140.0
2014-04-11 08:00:00	AAPL	Stock	18.6071	18.6071	18.5357	18.5661	919772.0
2014-04-11 09:00:00	AAPL	Stock	18.5625	18.6571	18.5321	18.5679	32849320.0
2014-04-11 10:00:00	AAPL	Stock	18.5682	18.625	18.4693	18.6029	52234000.0
2014-04-11 11:00:00	AAPL	Stock	18.6025	18.6725	18.5732	18.6019	25869788.0
2014-04-11 12:00:00	AAPL	Stock	18.6043	18.6407	18.5543	18.5699	12050360.0
2014-04-11 13:00:00	AAPL	Stock	18.5754	18.62	18.4889	18.5489	22459360.0
2014-04-11 14:00:00	AAPL	Stock	18.5504	18.5864	18.51	18.5329	19625452.0
2014-04-11 15:00:00	AAPL	Stock	18.5329	18.5971	18.5229	18.5579	37651600.0
2014-04-11 16:00:00	AAPL	Stock	18.5575	18.5731	18.5429	18.5643	11623780.0
2014-04-11 17:00:00	AAPL	Stock	18.5625	18.5714	18.5457	18.5511	178500.0
2014-04-11 18:00:00	AAPL	Stock	18.5568	18.5625	18.5536	18.5589	92428.0
2014-04-11 19:00:00	AAPL	Stock	18.5571	18.5696	18.5571	18.5696	43820.0
2014-04-11 04:00:00	MSFT	Stock	39.35	39.35	39.35	39.35	200.0
2014-04-11 05:00:00	MSFT	Stock	39.33	39.33	39.33	39.33	100.0
2014-04-11 06:00:00	MSFT	Stock	39.33	39.33	39.33	39.33	150.0
2014-04-11 07:00:00	MSFT	Stock	39.15	39.15	39.09	39.09	2900.0
2014-04-11 08:00:00	MSFT	Stock	39.09	39.15	39.09	39.11	15305.0
2014-04-11 09:00:00	MSFT	Stock	39.09	39.64	39.0	39.61	6183275.0
2014-04-11 10:00:00	MSFT	Stock	39.6	39.79	39.175	39.65	5930897.0
2014-04-11 11:00:00	MSFT	Stock	39.65	39.75	39.26	39.4	4151782.0
2014-04-11 12:00:00	MSFT	Stock	39.4	39.55	39.36	39.47	1872568.0
2014-04-11 13:00:00	MSFT	Stock	39.47	39.539	39.26	39.355	2330472.0
2014-04-11 14:00:00	MSFT	Stock	39.355	39.49	39.17	39.26	3149736.0
2014-04-11 15:00:00	MSFT	Stock	39.268	39.45	39.19	39.2	7115702.0
2014-04-11 16:00:00	MSFT	Stock	39.19	39.558	39.182	39.558	2646007.0
2014-04-11 17:00:00	MSFT	Stock	39.32	39.32	39.2	39.22	2098.0
2014-04-11 18:00:00	MSFT	Stock	39.23	39.29	39.23	39.24	700.0
2014-04-11 19:00:00	MSFT	Stock	39.29	39.29	39.24	39.29	2400.0
2014-04-11 08:00:00	NVDA	Stock	0.458	0.458	0.458	0.458	32000.0
2014-04-11 09:00:00	NVDA	Stock	0.456	0.463	0.4555	0.4588	44569880.0
2014-04-11 10:00:00	NVDA	Stock	0.4585	0.4605	0.4525	0.459	47785920.0
2014-04-11 11:00:00	NVDA	Stock	0.459	0.46	0.4542	0.4553	32277200.0
2014-04-11 12:00:00	NVDA	Stock	0.4555	0.4582	0.4555	0.4574	17983960.0
2014-04-11 13:00:00	NVDA	Stock	0.4575	0.4575	0.454	0.4541	21396160.0
2014-04-11 14:00:00	NVDA	Stock	0.454	0.4549	0.447	0.451	58021360.0
2014-04-11 15:00:00	NVDA	Stock	0.451	0.4564	0.4508	0.453	109554520.0
2014-04-11 16:00:00	NVDA	Stock	0.453	0.4548	0.4522	0.453	12801320.0
2014-04-11 04:00:00	AMZN	Stock	15.91	15.91	15.89	15.89	4000.0
2014-04-11 05:00:00	AMZN	Stock	15.8525	15.8595	15.8525	15.8595	15000.0
2014-04-11 06:00:00	AMZN	Stock	15.8355	15.8355	15.835	15.835	4200.0
2014-04-11 07:00:00	AMZN	Stock	15.6605	15.737	15.658	15.737	26560.0
2014-04-11 08:00:00	AMZN	Stock	15.7165	15.75	15.7155	15.7485	255560.0
2014-04-11 09:00:00	AMZN	Stock	15.7195	15.8155	15.526	15.6965	26610520.0
2014-04-11 10:00:00	AMZN	Stock	15.6875	15.825	15.475	15.75	28973100.0
2014-04-11 11:00:00	AMZN	Stock	15.75	15.7945	15.6065	15.6465	16379660.0
2014-04-11 12:00:00	AMZN	Stock	15.649	15.6655	15.5425	15.6004	10047380.0

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

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