PREVIEW / stock_1hour / 2015-11-25

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-11-25.parquet
  size:    1.0 MB
  rows:    47,984
  symbols: 3,410

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-25 04:00:00	AAPL	Stock	29.75	29.75	29.7475	29.7475	36128.0
2015-11-25 05:00:00	AAPL	Stock	29.7475	29.7475	29.745	29.745	3600.0
2015-11-25 06:00:00	AAPL	Stock	29.7475	29.7475	29.6725	29.72	17300.0
2015-11-25 07:00:00	AAPL	Stock	29.72	29.76	29.705	29.75	64552.0
2015-11-25 08:00:00	AAPL	Stock	29.75	29.78	29.705	29.7625	329400.0
2015-11-25 09:00:00	AAPL	Stock	29.7725	29.815	29.555	29.642	15748436.0
2015-11-25 10:00:00	AAPL	Stock	29.6375	29.6575	29.5375	29.56	15931256.0
2015-11-25 11:00:00	AAPL	Stock	29.56	29.5925	29.5125	29.565	9160904.0
2015-11-25 12:00:00	AAPL	Stock	29.565	29.61	29.515	29.5675	6689376.0
2015-11-25 13:00:00	AAPL	Stock	29.57	29.5975	29.5375	29.5812	5868288.0
2015-11-25 14:00:00	AAPL	Stock	29.5812	29.6225	29.5675	29.595	5134340.0
2015-11-25 15:00:00	AAPL	Stock	29.595	29.605	29.48	29.505	15270388.0
2015-11-25 16:00:00	AAPL	Stock	29.5075	29.5225	29.5075	29.5125	5614076.0
2015-11-25 17:00:00	AAPL	Stock	29.505	29.51	29.5025	29.505	28976.0
2015-11-25 18:00:00	AAPL	Stock	29.51	29.5125	29.5025	29.5075	49736.0
2015-11-25 19:00:00	AAPL	Stock	29.5075	29.515	29.5025	29.515	46448.0
2015-11-25 04:00:00	MSFT	Stock	54.21	54.21	54.21	54.21	900.0
2015-11-25 05:00:00	MSFT	Stock	54.25	54.35	54.25	54.31	700.0
2015-11-25 06:00:00	MSFT	Stock	54.35	54.35	54.21	54.25	3488.0
2015-11-25 07:00:00	MSFT	Stock	54.25	54.25	54.24	54.25	2200.0
2015-11-25 08:00:00	MSFT	Stock	54.22	54.28	54.21	54.25	6597.0
2015-11-25 09:00:00	MSFT	Stock	54.21	54.29	53.94	53.98	3555383.0
2015-11-25 10:00:00	MSFT	Stock	53.98	54.03	53.83	54.0	2608099.0
2015-11-25 11:00:00	MSFT	Stock	54.005	54.08	53.92	54.05	1995393.0
2015-11-25 12:00:00	MSFT	Stock	54.05	54.15	54.02	54.05	2118576.0
2015-11-25 13:00:00	MSFT	Stock	54.057	54.09	53.96	53.96	1289072.0
2015-11-25 14:00:00	MSFT	Stock	53.97	54.0	53.9	53.945	2113824.0
2015-11-25 15:00:00	MSFT	Stock	53.95	53.99	53.69	53.7	3976506.0
2015-11-25 16:00:00	MSFT	Stock	53.69	53.78	53.69	53.75	1286340.0
2015-11-25 07:00:00	NVDA	Stock	0.78	0.78	0.78	0.78	20000.0
2015-11-25 08:00:00	NVDA	Stock	0.78	0.78	0.78	0.78	8000.0
2015-11-25 09:00:00	NVDA	Stock	0.7778	0.7822	0.7755	0.7815	15230000.0
2015-11-25 10:00:00	NVDA	Stock	0.7815	0.787	0.7803	0.7843	30006080.0
2015-11-25 11:00:00	NVDA	Stock	0.7845	0.7855	0.7803	0.783	13406080.0
2015-11-25 12:00:00	NVDA	Stock	0.783	0.7838	0.7812	0.7815	8618840.0
2015-11-25 13:00:00	NVDA	Stock	0.7812	0.7825	0.7788	0.78	11478080.0
2015-11-25 14:00:00	NVDA	Stock	0.78	0.7804	0.7786	0.7798	11019560.0
2015-11-25 15:00:00	NVDA	Stock	0.7796	0.78	0.7771	0.7785	32741120.0
2015-11-25 16:00:00	NVDA	Stock	0.7782	0.7782	0.7782	0.7782	8532440.0
2015-11-25 04:00:00	AMZN	Stock	33.6445	33.6445	33.6445	33.6445	2260.0
2015-11-25 06:00:00	AMZN	Stock	33.6925	33.6925	33.647	33.647	8560.0
2015-11-25 07:00:00	AMZN	Stock	33.6105	33.75	33.6105	33.725	97300.0
2015-11-25 08:00:00	AMZN	Stock	33.725	33.791	33.72	33.7475	222940.0
2015-11-25 09:00:00	AMZN	Stock	33.7375	33.985	33.7125	33.9325	14701500.0
2015-11-25 10:00:00	AMZN	Stock	33.936	33.949	33.6465	33.7245	8686540.0
2015-11-25 11:00:00	AMZN	Stock	33.716	33.788	33.562	33.7822	6669820.0
2015-11-25 12:00:00	AMZN	Stock	33.7785	33.844	33.7115	33.7885	3435420.0
2015-11-25 13:00:00	AMZN	Stock	33.7995	33.8128	33.7	33.7505	2214800.0
2015-11-25 14:00:00	AMZN	Stock	33.7505	33.7805	33.663	33.7135	2805820.0
2015-11-25 15:00:00	AMZN	Stock	33.7123	33.7965	33.705	33.7778	7599320.0

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

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