PREVIEW / stock_1hour / 2015-11-17

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-11-17.parquet
  size:    1.0 MB
  rows:    48,394
  symbols: 3,409

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-11-17 04:00:00	AAPL	Stock	28.5225	28.65	28.5225	28.65	6416.0
2015-11-17 05:00:00	AAPL	Stock	28.6425	28.65	28.6425	28.65	1236.0
2015-11-17 06:00:00	AAPL	Stock	28.6625	28.6925	28.6425	28.6775	31140.0
2015-11-17 07:00:00	AAPL	Stock	28.675	28.7725	28.655	28.7	168860.0
2015-11-17 08:00:00	AAPL	Stock	28.71	28.7975	28.6425	28.6875	379232.0
2015-11-17 09:00:00	AAPL	Stock	28.6875	28.7625	28.455	28.505	19267408.0
2015-11-17 10:00:00	AAPL	Stock	28.505	28.6425	28.4175	28.6225	17698272.0
2015-11-17 11:00:00	AAPL	Stock	28.6225	28.7025	28.5425	28.5975	14273976.0
2015-11-17 12:00:00	AAPL	Stock	28.5975	28.6725	28.48	28.575	9485068.0
2015-11-17 13:00:00	AAPL	Stock	28.5725	28.6	28.485	28.58	6560248.0
2015-11-17 14:00:00	AAPL	Stock	28.58	28.61	28.3875	28.4728	10519952.0
2015-11-17 15:00:00	AAPL	Stock	28.4725	28.4765	28.33	28.4175	19296176.0
2015-11-17 16:00:00	AAPL	Stock	28.4225	28.4575	28.33	28.455	4333616.0
2015-11-17 17:00:00	AAPL	Stock	28.4425	28.4625	28.4375	28.445	20432.0
2015-11-17 18:00:00	AAPL	Stock	28.435	28.4475	28.43	28.4375	35216.0
2015-11-17 19:00:00	AAPL	Stock	28.4325	28.4425	28.4275	28.4325	22804.0
2015-11-17 04:00:00	MSFT	Stock	53.7	53.7	53.51	53.51	780.0
2015-11-17 06:00:00	MSFT	Stock	53.75	53.75	53.42	53.53	12700.0
2015-11-17 07:00:00	MSFT	Stock	53.67	53.67	53.61	53.61	12400.0
2015-11-17 08:00:00	MSFT	Stock	53.67	53.67	53.53	53.53	29309.0
2015-11-17 09:00:00	MSFT	Stock	53.52	53.6	53.05	53.47	3820743.0
2015-11-17 10:00:00	MSFT	Stock	53.48	53.52	53.02	53.33	4405323.0
2015-11-17 11:00:00	MSFT	Stock	53.33	53.51	53.28	53.34	2887455.0
2015-11-17 12:00:00	MSFT	Stock	53.35	53.43	53.17	53.27	2626401.0
2015-11-17 13:00:00	MSFT	Stock	53.27	53.33	53.05	53.245	2114200.0
2015-11-17 14:00:00	MSFT	Stock	53.246	53.246	52.88	53.12	3338378.0
2015-11-17 15:00:00	MSFT	Stock	53.12	53.13	52.85	52.97	5809775.0
2015-11-17 16:00:00	MSFT	Stock	52.97	53.09	52.97	53.02	4628165.0
2015-11-17 17:00:00	MSFT	Stock	52.97	52.97	52.97	52.97	200.0
2015-11-17 18:00:00	MSFT	Stock	52.97	52.97	52.97	52.97	1200.0
2015-11-17 19:00:00	MSFT	Stock	53.1	53.1	52.99	52.99	200.0
2015-11-17 07:00:00	NVDA	Stock	0.7638	0.7638	0.7638	0.7638	39960.0
2015-11-17 08:00:00	NVDA	Stock	0.7673	0.7673	0.76	0.76	2624000.0
2015-11-17 09:00:00	NVDA	Stock	0.765	0.765	0.7578	0.7598	31682640.0
2015-11-17 10:00:00	NVDA	Stock	0.7598	0.7646	0.7568	0.7622	28193040.0
2015-11-17 11:00:00	NVDA	Stock	0.7622	0.766	0.7603	0.764	28467480.0
2015-11-17 12:00:00	NVDA	Stock	0.764	0.7665	0.7603	0.7604	23963600.0
2015-11-17 13:00:00	NVDA	Stock	0.7605	0.7633	0.7588	0.7612	21709560.0
2015-11-17 14:00:00	NVDA	Stock	0.7612	0.763	0.7578	0.7605	19828520.0
2015-11-17 15:00:00	NVDA	Stock	0.7604	0.7616	0.7575	0.7603	39202480.0
2015-11-17 16:00:00	NVDA	Stock	0.76	0.7603	0.7598	0.7598	44172640.0
2015-11-17 04:00:00	AMZN	Stock	32.45	32.5	32.45	32.5	12000.0
2015-11-17 05:00:00	AMZN	Stock	32.5445	32.55	32.5445	32.55	6000.0
2015-11-17 06:00:00	AMZN	Stock	32.535	32.535	32.5	32.5	7220.0
2015-11-17 07:00:00	AMZN	Stock	32.575	32.635	32.5065	32.55	133680.0
2015-11-17 08:00:00	AMZN	Stock	32.5655	32.5655	32.458	32.5465	412260.0
2015-11-17 09:00:00	AMZN	Stock	32.525	32.6625	32.2525	32.3848	16140520.0
2015-11-17 10:00:00	AMZN	Stock	32.3905	32.4863	32.137	32.2543	14038500.0
2015-11-17 11:00:00	AMZN	Stock	32.2545	32.4645	32.086	32.4045	9511500.0
2015-11-17 12:00:00	AMZN	Stock	32.411	32.4735	32.2305	32.45	7962220.0

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

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