PREVIEW / stock_1hour / 2015-05-01

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-05-01.parquet
  size:    1.0 MB
  rows:    48,492
  symbols: 3,516

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-05-01 05:00:00	AAPL	Stock	31.3025	31.3875	31.2625	31.3875	4000.0
2015-05-01 06:00:00	AAPL	Stock	31.3925	31.43	31.305	31.3925	75800.0
2015-05-01 07:00:00	AAPL	Stock	31.3975	31.56	31.375	31.475	390456.0
2015-05-01 08:00:00	AAPL	Stock	31.4925	31.56	31.375	31.4575	868016.0
2015-05-01 09:00:00	AAPL	Stock	31.4575	31.6325	31.325	31.5375	35839716.0
2015-05-01 10:00:00	AAPL	Stock	31.535	31.755	31.5	31.58	35867456.0
2015-05-01 11:00:00	AAPL	Stock	31.585	31.6725	31.495	31.5438	19509380.0
2015-05-01 12:00:00	AAPL	Stock	31.545	31.6125	31.44	31.605	15293404.0
2015-05-01 13:00:00	AAPL	Stock	31.605	31.8325	31.555	31.7962	20326128.0
2015-05-01 14:00:00	AAPL	Stock	31.795	31.9875	31.78	31.98	24970996.0
2015-05-01 15:00:00	AAPL	Stock	31.9825	32.5325	31.9575	32.2375	51312432.0
2015-05-01 16:00:00	AAPL	Stock	32.2375	32.255	31.5052	32.2525	8769372.0
2015-05-01 17:00:00	AAPL	Stock	32.2525	32.255	32.24	32.245	231400.0
2015-05-01 18:00:00	AAPL	Stock	32.2425	32.2625	32.2425	32.2575	224176.0
2015-05-01 19:00:00	AAPL	Stock	32.2575	32.2725	32.2502	32.2625	135604.0
2015-05-01 06:00:00	MSFT	Stock	48.79	48.8	48.79	48.8	3600.0
2015-05-01 07:00:00	MSFT	Stock	48.79	48.85	48.74	48.76	4642.0
2015-05-01 08:00:00	MSFT	Stock	48.79	48.85	48.72	48.73	17938.0
2015-05-01 09:00:00	MSFT	Stock	48.73	48.88	48.51	48.66	4754336.0
2015-05-01 10:00:00	MSFT	Stock	48.66	48.875	48.57	48.665	5690965.0
2015-05-01 11:00:00	MSFT	Stock	48.67	48.87	48.625	48.685	4589812.0
2015-05-01 12:00:00	MSFT	Stock	48.69	48.81	48.56	48.67	3156493.0
2015-05-01 13:00:00	MSFT	Stock	48.665	48.7	48.47	48.61	3554314.0
2015-05-01 14:00:00	MSFT	Stock	48.605	48.69	48.52	48.55	2972911.0
2015-05-01 15:00:00	MSFT	Stock	48.55	48.66	48.4	48.65	7789729.0
2015-05-01 16:00:00	MSFT	Stock	48.65	48.676	48.55	48.6	2540894.0
2015-05-01 17:00:00	MSFT	Stock	48.58	48.58	48.56	48.57	7200.0
2015-05-01 18:00:00	MSFT	Stock	48.57	48.6	48.56	48.6	11000.0
2015-05-01 19:00:00	MSFT	Stock	48.62	48.62	48.62	48.62	2081.0
2015-05-01 09:00:00	NVDA	Stock	0.5598	0.5608	0.557	0.5585	24776680.0
2015-05-01 10:00:00	NVDA	Stock	0.5585	0.5674	0.5582	0.5668	47233920.0
2015-05-01 11:00:00	NVDA	Stock	0.5666	0.5695	0.565	0.5685	28718520.0
2015-05-01 12:00:00	NVDA	Stock	0.5683	0.5685	0.564	0.565	22687480.0
2015-05-01 13:00:00	NVDA	Stock	0.5652	0.5688	0.564	0.5684	17789200.0
2015-05-01 14:00:00	NVDA	Stock	0.5682	0.5705	0.567	0.568	30397520.0
2015-05-01 15:00:00	NVDA	Stock	0.568	0.57	0.5669	0.5688	68700880.0
2015-05-01 16:00:00	NVDA	Stock	0.5682	0.569	0.5661	0.569	3962240.0
2015-05-01 17:00:00	NVDA	Stock	0.568	0.568	0.568	0.568	8000.0
2015-05-01 08:00:00	AMZN	Stock	21.1525	21.185	21.1485	21.1485	27300.0
2015-05-01 09:00:00	AMZN	Stock	21.1565	21.282	20.9838	20.9839	9948840.0
2015-05-01 10:00:00	AMZN	Stock	20.9795	21.0195	20.861	20.898	13776840.0
2015-05-01 11:00:00	AMZN	Stock	20.9005	20.9958	20.8	20.98	12532720.0
2015-05-01 12:00:00	AMZN	Stock	20.9775	21.0785	20.958	21.0695	6326800.0
2015-05-01 13:00:00	AMZN	Stock	21.072	21.096	20.9925	21.0814	4876020.0
2015-05-01 14:00:00	AMZN	Stock	21.082	21.087	21.0095	21.0415	5578460.0
2015-05-01 15:00:00	AMZN	Stock	21.039	21.171	21.0205	21.1435	11360260.0
2015-05-01 16:00:00	AMZN	Stock	21.14	21.163	21.1255	21.1345	573540.0
2015-05-01 17:00:00	AMZN	Stock	21.1345	21.147	21.1345	21.147	17180.0
2015-05-01 18:00:00	AMZN	Stock	21.15	21.15	21.15	21.15	2000.0
2015-05-01 08:00:00	GOOGL	Stock	27.5055	27.5055	27.5	27.5	6000.0

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

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