PREVIEW / stock_1hour / 2015-10-21

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-10-21.parquet
  size:    1.0 MB
  rows:    47,603
  symbols: 3,411

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-10-21 04:00:00	AAPL	Stock	28.4275	28.4275	28.4275	28.4275	400.0
2015-10-21 05:00:00	AAPL	Stock	28.455	28.5125	28.4525	28.4775	11684.0
2015-10-21 06:00:00	AAPL	Stock	28.4875	28.525	28.48	28.5	31104.0
2015-10-21 07:00:00	AAPL	Stock	28.4825	28.4825	28.4325	28.4325	37504.0
2015-10-21 08:00:00	AAPL	Stock	28.4175	28.52	28.3575	28.475	473924.0
2015-10-21 09:00:00	AAPL	Stock	28.475	28.625	28.425	28.5625	25331944.0
2015-10-21 10:00:00	AAPL	Stock	28.5625	28.605	28.4525	28.5735	20628096.0
2015-10-21 11:00:00	AAPL	Stock	28.575	28.785	28.515	28.7805	21755672.0
2015-10-21 12:00:00	AAPL	Stock	28.78	28.895	28.7525	28.7738	23296136.0
2015-10-21 13:00:00	AAPL	Stock	28.7735	28.785	28.6625	28.6835	18096128.0
2015-10-21 14:00:00	AAPL	Stock	28.6825	28.72	28.5775	28.6425	19307328.0
2015-10-21 15:00:00	AAPL	Stock	28.64	28.6775	28.4325	28.44	22740000.0
2015-10-21 16:00:00	AAPL	Stock	28.44	28.4625	28.4	28.4325	6557568.0
2015-10-21 17:00:00	AAPL	Stock	28.4425	28.4625	28.44	28.44	123964.0
2015-10-21 18:00:00	AAPL	Stock	28.445	28.46	28.43	28.4375	46024.0
2015-10-21 19:00:00	AAPL	Stock	28.4475	28.4475	28.4125	28.4375	41268.0
2015-10-21 05:00:00	MSFT	Stock	47.68	47.68	47.68	47.68	2100.0
2015-10-21 06:00:00	MSFT	Stock	47.8	47.8	47.8	47.8	500.0
2015-10-21 07:00:00	MSFT	Stock	47.83	47.83	47.78	47.78	790.0
2015-10-21 08:00:00	MSFT	Stock	47.81	48.02	47.81	47.97	15269.0
2015-10-21 09:00:00	MSFT	Stock	47.97	48.0	47.57	47.77	2375109.0
2015-10-21 10:00:00	MSFT	Stock	47.78	47.87	47.68	47.84	3209024.0
2015-10-21 11:00:00	MSFT	Stock	47.85	47.99	47.725	47.945	3015976.0
2015-10-21 12:00:00	MSFT	Stock	47.942	47.99	47.82	47.82	1742154.0
2015-10-21 13:00:00	MSFT	Stock	47.814	47.82	47.4	47.47	2710312.0
2015-10-21 14:00:00	MSFT	Stock	47.46	47.69	47.37	47.53	2221444.0
2015-10-21 15:00:00	MSFT	Stock	47.54	47.58	47.11	47.2	6712720.0
2015-10-21 16:00:00	MSFT	Stock	47.2	47.23	47.03	47.16	2044798.0
2015-10-21 17:00:00	MSFT	Stock	47.16	47.22	47.16	47.2	6452.0
2015-10-21 18:00:00	MSFT	Stock	47.2	47.26	47.2	47.2	1759.0
2015-10-21 19:00:00	MSFT	Stock	47.25	47.25	47.19	47.19	4500.0
2015-10-21 09:00:00	NVDA	Stock	0.6955	0.7005	0.695	0.6995	21219360.0
2015-10-21 10:00:00	NVDA	Stock	0.6995	0.6995	0.6955	0.6974	28348280.0
2015-10-21 11:00:00	NVDA	Stock	0.6975	0.7028	0.6959	0.7001	44616160.0
2015-10-21 12:00:00	NVDA	Stock	0.6998	0.7008	0.6966	0.6966	17893320.0
2015-10-21 13:00:00	NVDA	Stock	0.6966	0.6966	0.6895	0.6918	38191120.0
2015-10-21 14:00:00	NVDA	Stock	0.6918	0.6922	0.6898	0.6905	32877680.0
2015-10-21 15:00:00	NVDA	Stock	0.6908	0.6912	0.684	0.6852	87916960.0
2015-10-21 16:00:00	NVDA	Stock	0.6852	0.6852	0.685	0.6852	96041320.0
2015-10-21 17:00:00	NVDA	Stock	0.6852	0.6852	0.685	0.685	20000.0
2015-10-21 18:00:00	NVDA	Stock	0.6902	0.695	0.6902	0.6935	240400.0
2015-10-21 19:00:00	NVDA	Stock	0.6925	0.6925	0.692	0.692	28400.0
2015-10-21 04:00:00	AMZN	Stock	28.05	28.05	28.05	28.05	4000.0
2015-10-21 07:00:00	AMZN	Stock	28.1295	28.1295	28.1295	28.1295	8320.0
2015-10-21 08:00:00	AMZN	Stock	28.2	28.2	28.16	28.17	103780.0
2015-10-21 09:00:00	AMZN	Stock	28.175	28.2625	27.9695	28.119	9692240.0
2015-10-21 10:00:00	AMZN	Stock	28.0965	28.1605	27.834	28.0955	8997140.0
2015-10-21 11:00:00	AMZN	Stock	28.0955	28.1145	27.8038	28.038	5138720.0
2015-10-21 12:00:00	AMZN	Stock	28.0306	28.056	27.9105	27.912	2769580.0
2015-10-21 13:00:00	AMZN	Stock	27.912	27.917	27.626	27.685	7753300.0

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

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