PREVIEW / stock_1hour / 2015-04-29

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-04-29.parquet
  size:    1.0 MB
  rows:    48,597
  symbols: 3,495

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-04-29 04:00:00	AAPL	Stock	32.655	32.73	32.655	32.7125	17160.0
2015-04-29 05:00:00	AAPL	Stock	32.7225	32.7325	32.62	32.65	20736.0
2015-04-29 06:00:00	AAPL	Stock	32.65	32.7475	32.62	32.685	141976.0
2015-04-29 07:00:00	AAPL	Stock	32.68	32.77	32.635	32.67	301644.0
2015-04-29 08:00:00	AAPL	Stock	32.67	32.7925	32.6275	32.6575	1182396.0
2015-04-29 09:00:00	AAPL	Stock	32.6525	32.8975	32.45	32.6675	30680924.0
2015-04-29 10:00:00	AAPL	Stock	32.6675	32.7225	32.3925	32.4325	36552568.0
2015-04-29 11:00:00	AAPL	Stock	32.4325	32.585	32.4125	32.4482	19143488.0
2015-04-29 12:00:00	AAPL	Stock	32.445	32.4788	32.0875	32.245	36323364.0
2015-04-29 13:00:00	AAPL	Stock	32.2475	32.3875	32.145	32.3412	19308428.0
2015-04-29 14:00:00	AAPL	Stock	32.34	32.395	32.1425	32.2575	28562300.0
2015-04-29 15:00:00	AAPL	Stock	32.2575	32.3468	32.075	32.16	40044660.0
2015-04-29 16:00:00	AAPL	Stock	32.16	32.317	31.82	31.925	10490312.0
2015-04-29 17:00:00	AAPL	Stock	31.935	32.075	31.875	31.9775	1179584.0
2015-04-29 18:00:00	AAPL	Stock	31.9775	32.02	31.9625	31.97	425320.0
2015-04-29 19:00:00	AAPL	Stock	31.965	31.99	31.95	31.9525	300528.0
2015-04-29 04:00:00	MSFT	Stock	49.01	49.11	49.01	49.11	300.0
2015-04-29 05:00:00	MSFT	Stock	49.06	49.13	49.06	49.13	1600.0
2015-04-29 06:00:00	MSFT	Stock	49.12	49.13	49.03	49.03	11000.0
2015-04-29 07:00:00	MSFT	Stock	49.03	49.03	48.96	48.99	12439.0
2015-04-29 08:00:00	MSFT	Stock	48.98	49.0	48.86	48.88	62945.0
2015-04-29 09:00:00	MSFT	Stock	48.86	48.94	48.6	48.66	5942948.0
2015-04-29 10:00:00	MSFT	Stock	48.655	48.93	48.5	48.89	6445218.0
2015-04-29 11:00:00	MSFT	Stock	48.89	49.05	48.8	48.915	5277115.0
2015-04-29 12:00:00	MSFT	Stock	48.91	48.926	48.69	48.808	4232904.0
2015-04-29 13:00:00	MSFT	Stock	48.81	49.08	48.72	48.96	3990176.0
2015-04-29 14:00:00	MSFT	Stock	48.98	49.26	48.78	49.064	8473223.0
2015-04-29 15:00:00	MSFT	Stock	49.07	49.31	48.99	49.05	9082152.0
2015-04-29 16:00:00	MSFT	Stock	49.042	49.3	49.0	49.05	2484250.0
2015-04-29 17:00:00	MSFT	Stock	49.03	49.1	49.0	49.06	17920.0
2015-04-29 18:00:00	MSFT	Stock	49.04	49.06	48.89	49.0	29554.0
2015-04-29 19:00:00	MSFT	Stock	49.0	49.02	49.0	49.02	14103.0
2015-04-29 09:00:00	NVDA	Stock	0.5532	0.559	0.5512	0.5568	9561840.0
2015-04-29 10:00:00	NVDA	Stock	0.5568	0.558	0.5551	0.5571	25669760.0
2015-04-29 11:00:00	NVDA	Stock	0.5571	0.5588	0.557	0.5585	21569320.0
2015-04-29 12:00:00	NVDA	Stock	0.5586	0.5592	0.5528	0.5552	25752800.0
2015-04-29 13:00:00	NVDA	Stock	0.5552	0.5571	0.5542	0.5569	27056280.0
2015-04-29 14:00:00	NVDA	Stock	0.5568	0.5574	0.5522	0.5562	34313760.0
2015-04-29 15:00:00	NVDA	Stock	0.5565	0.5565	0.5528	0.5535	36558120.0
2015-04-29 16:00:00	NVDA	Stock	0.5535	0.5535	0.5525	0.5532	279800.0
2015-04-29 07:00:00	AMZN	Stock	21.4655	21.4655	21.4655	21.4655	2600.0
2015-04-29 08:00:00	AMZN	Stock	21.4605	21.4605	21.339	21.375	62400.0
2015-04-29 09:00:00	AMZN	Stock	21.3695	21.712	21.3075	21.642	15707580.0
2015-04-29 10:00:00	AMZN	Stock	21.641	21.651	21.478	21.5035	8447220.0
2015-04-29 11:00:00	AMZN	Stock	21.5	21.6455	21.495	21.535	5010480.0
2015-04-29 12:00:00	AMZN	Stock	21.535	21.536	21.3015	21.3645	6545420.0
2015-04-29 13:00:00	AMZN	Stock	21.3695	21.488	21.339	21.478	4293160.0
2015-04-29 14:00:00	AMZN	Stock	21.478	21.695	21.421	21.598	8913640.0
2015-04-29 15:00:00	AMZN	Stock	21.5927	21.607	21.43	21.4685	9643220.0
2015-04-29 16:00:00	AMZN	Stock	21.4685	21.502	21.45	21.45	292720.0

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

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