PREVIEW / stock_1hour / 2015-06-03

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-06-03.parquet
  size:    1.0 MB
  rows:    48,545
  symbols: 3,494

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-06-03 04:00:00	AAPL	Stock	32.5175	32.5825	32.515	32.52	11080.0
2015-06-03 05:00:00	AAPL	Stock	32.55	32.55	32.535	32.535	2800.0
2015-06-03 06:00:00	AAPL	Stock	32.54	32.5875	32.54	32.5875	6820.0
2015-06-03 07:00:00	AAPL	Stock	32.5875	32.6875	32.575	32.6875	277840.0
2015-06-03 08:00:00	AAPL	Stock	32.685	32.6875	32.575	32.655	622984.0
2015-06-03 09:00:00	AAPL	Stock	32.6625	32.7	32.56	32.67	18226696.0
2015-06-03 10:00:00	AAPL	Stock	32.67	32.735	32.5802	32.709	22114468.0
2015-06-03 11:00:00	AAPL	Stock	32.7075	32.715	32.565	32.6125	14605352.0
2015-06-03 12:00:00	AAPL	Stock	32.615	32.645	32.475	32.5375	16525916.0
2015-06-03 13:00:00	AAPL	Stock	32.5375	32.56	32.4925	32.5568	10857636.0
2015-06-03 14:00:00	AAPL	Stock	32.5575	32.605	32.5175	32.535	11367508.0
2015-06-03 15:00:00	AAPL	Stock	32.535	32.5575	32.4935	32.54	17689812.0
2015-06-03 16:00:00	AAPL	Stock	32.53	32.6118	32.5275	32.545	3899808.0
2015-06-03 17:00:00	AAPL	Stock	32.55	32.55	32.54	32.5425	57560.0
2015-06-03 18:00:00	AAPL	Stock	32.5448	32.55	32.5275	32.55	60916.0
2015-06-03 19:00:00	AAPL	Stock	32.545	32.55	32.535	32.5475	68076.0
2015-06-03 04:00:00	MSFT	Stock	47.02	47.02	46.94	47.02	800.0
2015-06-03 06:00:00	MSFT	Stock	47.03	47.03	47.03	47.03	100.0
2015-06-03 07:00:00	MSFT	Stock	47.1	47.21	47.1	47.19	2500.0
2015-06-03 08:00:00	MSFT	Stock	47.19	47.27	47.12	47.22	24313.0
2015-06-03 09:00:00	MSFT	Stock	47.22	47.525	47.13	47.51	3220843.0
2015-06-03 10:00:00	MSFT	Stock	47.51	47.735	47.41	47.66	3132551.0
2015-06-03 11:00:00	MSFT	Stock	47.66	47.665	47.09	47.14	2800776.0
2015-06-03 12:00:00	MSFT	Stock	47.13	47.19	46.96	47.12	2575848.0
2015-06-03 13:00:00	MSFT	Stock	47.11	47.34	47.09	47.25	5347229.0
2015-06-03 14:00:00	MSFT	Stock	47.255	47.32	46.92	47.02	2876423.0
2015-06-03 15:00:00	MSFT	Stock	47.02	47.06	46.82	46.86	4720806.0
2015-06-03 16:00:00	MSFT	Stock	46.85	47.238	46.85	46.93	1442687.0
2015-06-03 17:00:00	MSFT	Stock	46.93	46.93	46.93	46.93	1000.0
2015-06-03 18:00:00	MSFT	Stock	46.93	46.93	46.93	46.93	1100.0
2015-06-03 19:00:00	MSFT	Stock	46.94	46.94	46.94	46.94	550.0
2015-06-03 09:00:00	NVDA	Stock	0.5485	0.5542	0.5485	0.5512	43577720.0
2015-06-03 10:00:00	NVDA	Stock	0.5512	0.553	0.5492	0.5515	41773080.0
2015-06-03 11:00:00	NVDA	Stock	0.5512	0.5518	0.5475	0.5475	30840760.0
2015-06-03 12:00:00	NVDA	Stock	0.5475	0.548	0.5428	0.5435	25287880.0
2015-06-03 13:00:00	NVDA	Stock	0.5438	0.5442	0.5425	0.5436	19708440.0
2015-06-03 14:00:00	NVDA	Stock	0.5436	0.5445	0.5425	0.5428	14436480.0
2015-06-03 15:00:00	NVDA	Stock	0.5428	0.5442	0.5415	0.5425	58101920.0
2015-06-03 16:00:00	NVDA	Stock	0.5425	0.5467	0.5425	0.5467	9872400.0
2015-06-03 17:00:00	NVDA	Stock	0.545	0.545	0.545	0.545	12000.0
2015-06-03 18:00:00	NVDA	Stock	0.545	0.545	0.545	0.545	8000.0
2015-06-03 19:00:00	NVDA	Stock	0.545	0.545	0.545	0.545	124000.0
2015-06-03 06:00:00	AMZN	Stock	21.5875	21.6715	21.5875	21.651	18000.0
2015-06-03 07:00:00	AMZN	Stock	21.6815	21.74	21.6815	21.74	22800.0
2015-06-03 08:00:00	AMZN	Stock	21.739	21.75	21.715	21.7325	224900.0
2015-06-03 09:00:00	AMZN	Stock	21.7255	21.879	21.6375	21.8495	10977960.0
2015-06-03 10:00:00	AMZN	Stock	21.846	21.8845	21.7775	21.8285	6761220.0
2015-06-03 11:00:00	AMZN	Stock	21.8165	21.886	21.7825	21.879	6378240.0
2015-06-03 12:00:00	AMZN	Stock	21.8695	21.9115	21.813	21.8375	6110740.0
2015-06-03 13:00:00	AMZN	Stock	21.846	21.867	21.817	21.851	3101800.0

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

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