PREVIEW / stock_1hour / 2017-04-26

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-04-26.parquet
  size:    1.1 MB
  rows:    48,400
  symbols: 3,051

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
2017-04-26 04:00:00	AAPL	Stock	36.18	36.2	36.1775	36.2	11348.0
2017-04-26 05:00:00	AAPL	Stock	36.1975	36.225	36.1875	36.1975	13612.0
2017-04-26 06:00:00	AAPL	Stock	36.1975	36.2175	36.1575	36.1575	36340.0
2017-04-26 07:00:00	AAPL	Stock	36.1375	36.1725	36.0925	36.15	120680.0
2017-04-26 08:00:00	AAPL	Stock	36.125	36.175	36.1	36.135	291484.0
2017-04-26 09:00:00	AAPL	Stock	36.1325	36.15	36.015	36.1	9903524.0
2017-04-26 10:00:00	AAPL	Stock	36.1	36.1088	35.9525	36.0258	12277512.0
2017-04-26 11:00:00	AAPL	Stock	36.025	36.0775	35.9625	36.01	7553548.0
2017-04-26 12:00:00	AAPL	Stock	36.0075	36.07	35.9825	36.03	4269616.0
2017-04-26 13:00:00	AAPL	Stock	36.0312	36.15	36.0	36.02	9212284.0
2017-04-26 14:00:00	AAPL	Stock	36.02	36.085	35.9785	35.98	7286308.0
2017-04-26 15:00:00	AAPL	Stock	35.9788	36.0262	35.844	35.915	15040496.0
2017-04-26 16:00:00	AAPL	Stock	35.905	35.9475	35.9025	35.9325	4926056.0
2017-04-26 17:00:00	AAPL	Stock	35.9375	35.9575	35.9275	35.9575	68400.0
2017-04-26 18:00:00	AAPL	Stock	35.95	35.9525	35.9375	35.9375	10800.0
2017-04-26 19:00:00	AAPL	Stock	35.9375	35.9675	35.9375	35.9675	26496.0
2017-04-26 05:00:00	MSFT	Stock	68.14	68.15	68.0	68.01	816.0
2017-04-26 06:00:00	MSFT	Stock	68.09	68.17	68.09	68.14	1736.0
2017-04-26 07:00:00	MSFT	Stock	68.05	68.08	68.05	68.07	3611.0
2017-04-26 08:00:00	MSFT	Stock	68.05	68.15	68.03	68.14	12206.0
2017-04-26 09:00:00	MSFT	Stock	68.14	68.14	67.64	67.69	3228947.0
2017-04-26 10:00:00	MSFT	Stock	67.69	68.12	67.62	68.11	3741901.0
2017-04-26 11:00:00	MSFT	Stock	68.11	68.31	67.94	67.96	3336682.0
2017-04-26 12:00:00	MSFT	Stock	67.965	68.185	67.87	67.875	2475051.0
2017-04-26 13:00:00	MSFT	Stock	67.875	67.99	67.81	67.875	1892820.0
2017-04-26 14:00:00	MSFT	Stock	67.87	67.93	67.76	67.81	1983984.0
2017-04-26 15:00:00	MSFT	Stock	67.81	67.915	67.735	67.82	3835504.0
2017-04-26 16:00:00	MSFT	Stock	67.83	68.3	67.83	67.85	2844206.0
2017-04-26 17:00:00	MSFT	Stock	67.85	68.09	67.85	68.05	16033.0
2017-04-26 18:00:00	MSFT	Stock	68.04	68.07	67.98	68.04	11568.0
2017-04-26 19:00:00	MSFT	Stock	68.06	68.1	67.95	67.99	6482.0
2017-04-26 07:00:00	NVDA	Stock	2.6188	2.6188	2.6188	2.6188	4000.0
2017-04-26 08:00:00	NVDA	Stock	2.6188	2.622	2.6115	2.617	323920.0
2017-04-26 09:00:00	NVDA	Stock	2.6188	2.6392	2.6022	2.6045	49523880.0
2017-04-26 10:00:00	NVDA	Stock	2.604	2.6213	2.5985	2.6212	65405560.0
2017-04-26 11:00:00	NVDA	Stock	2.621	2.6325	2.6155	2.6198	50139880.0
2017-04-26 12:00:00	NVDA	Stock	2.6198	2.6278	2.6163	2.623	26278440.0
2017-04-26 13:00:00	NVDA	Stock	2.6228	2.6279	2.6128	2.613	23606440.0
2017-04-26 14:00:00	NVDA	Stock	2.6127	2.6137	2.6018	2.602	30876080.0
2017-04-26 15:00:00	NVDA	Stock	2.6016	2.6102	2.6003	2.6005	44766000.0
2017-04-26 16:00:00	NVDA	Stock	2.6005	2.6005	2.5925	2.5925	7563840.0
2017-04-26 17:00:00	NVDA	Stock	2.5913	2.593	2.5805	2.5808	271480.0
2017-04-26 18:00:00	NVDA	Stock	2.5813	2.585	2.5813	2.585	62840.0
2017-04-26 19:00:00	NVDA	Stock	2.585	2.5888	2.585	2.5875	35600.0
2017-04-26 07:00:00	AMZN	Stock	45.41	45.41	45.373	45.3935	20680.0
2017-04-26 08:00:00	AMZN	Stock	45.41	45.525	45.381	45.525	461600.0
2017-04-26 09:00:00	AMZN	Stock	45.525	45.7875	45.413	45.4975	11093940.0
2017-04-26 10:00:00	AMZN	Stock	45.495	45.59	45.4525	45.5075	7205000.0
2017-04-26 11:00:00	AMZN	Stock	45.5115	45.5695	45.378	45.417	5534560.0
2017-04-26 12:00:00	AMZN	Stock	45.4103	45.6205	45.4057	45.6195	4235660.0

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

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