PREVIEW / stock_1hour / 2019-09-16

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-09-16.parquet
  size:    1.1 MB
  rows:    51,231
  symbols: 2,559

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
2019-09-16 04:00:00	AAPL	Stock	54.3725	54.3725	54.075	54.125	78040.0
2019-09-16 05:00:00	AAPL	Stock	54.1275	54.21	54.0925	54.15	98592.0
2019-09-16 06:00:00	AAPL	Stock	54.175	54.3125	54.1625	54.3125	30536.0
2019-09-16 07:00:00	AAPL	Stock	54.255	54.45	54.15	54.4475	248840.0
2019-09-16 08:00:00	AAPL	Stock	54.2005	54.5275	54.15	54.4375	399964.0
2019-09-16 09:00:00	AAPL	Stock	54.4375	54.963	54.34	54.92	13079012.0
2019-09-16 10:00:00	AAPL	Stock	54.928	54.9325	54.5475	54.7312	10950488.0
2019-09-16 11:00:00	AAPL	Stock	54.735	55.0325	54.72	54.7625	12200548.0
2019-09-16 12:00:00	AAPL	Stock	54.76	54.8675	54.7275	54.7875	4951872.0
2019-09-16 13:00:00	AAPL	Stock	54.785	55.0225	54.755	55.0025	4738696.0
2019-09-16 14:00:00	AAPL	Stock	55.0025	55.025	54.89	54.94	5630844.0
2019-09-16 15:00:00	AAPL	Stock	54.935	55.0175	54.885	54.975	8450052.0
2019-09-16 16:00:00	AAPL	Stock	54.975	55.025	54.975	55.0225	6409688.0
2019-09-16 17:00:00	AAPL	Stock	55.0225	55.025	54.9775	54.9775	36296.0
2019-09-16 18:00:00	AAPL	Stock	55.02	55.095	55.0175	55.0575	46904.0
2019-09-16 19:00:00	AAPL	Stock	55.0625	55.0725	55.0175	55.0725	56392.0
2019-09-16 04:00:00	MSFT	Stock	136.33	136.33	136.01	136.24	978.0
2019-09-16 05:00:00	MSFT	Stock	136.62	136.62	136.34	136.41	2090.0
2019-09-16 06:00:00	MSFT	Stock	136.46	136.46	136.4	136.42	1280.0
2019-09-16 07:00:00	MSFT	Stock	136.35	136.42	136.05	136.2	9204.0
2019-09-16 08:00:00	MSFT	Stock	136.35	136.5	136.1	136.3	26929.0
2019-09-16 09:00:00	MSFT	Stock	136.3	136.54	135.66	136.45	1980001.0
2019-09-16 10:00:00	MSFT	Stock	136.47	136.668	136.13	136.23	1604333.0
2019-09-16 11:00:00	MSFT	Stock	136.24	136.7	136.08	136.21	1116470.0
2019-09-16 12:00:00	MSFT	Stock	136.19	136.55	136.17	136.236	838618.0
2019-09-16 13:00:00	MSFT	Stock	136.23	136.65	136.16	136.568	589129.0
2019-09-16 14:00:00	MSFT	Stock	136.57	136.66	136.4	136.45	805035.0
2019-09-16 15:00:00	MSFT	Stock	136.45	136.55	136.2	136.4	2047134.0
2019-09-16 16:00:00	MSFT	Stock	136.33	136.5	136.3	136.35	3991275.0
2019-09-16 17:00:00	MSFT	Stock	136.37	136.37	136.31	136.33	3071.0
2019-09-16 18:00:00	MSFT	Stock	136.37	136.4	136.34	136.39	4715.0
2019-09-16 19:00:00	MSFT	Stock	136.44	136.52	136.31	136.31	9710.0
2019-09-16 04:00:00	NVDA	Stock	4.5	4.5025	4.491	4.491	28760.0
2019-09-16 06:00:00	NVDA	Stock	4.488	4.4912	4.488	4.4912	16000.0
2019-09-16 07:00:00	NVDA	Stock	4.499	4.5	4.4775	4.496	372000.0
2019-09-16 08:00:00	NVDA	Stock	4.4908	4.5	4.4765	4.485	612360.0
2019-09-16 09:00:00	NVDA	Stock	4.4875	4.54	4.4625	4.5338	51257840.0
2019-09-16 10:00:00	NVDA	Stock	4.5334	4.5342	4.4878	4.4958	30613560.0
2019-09-16 11:00:00	NVDA	Stock	4.4972	4.5262	4.4925	4.4995	24541800.0
2019-09-16 12:00:00	NVDA	Stock	4.4985	4.5142	4.4937	4.5066	13289560.0
2019-09-16 13:00:00	NVDA	Stock	4.5063	4.5278	4.5022	4.5265	14353720.0
2019-09-16 14:00:00	NVDA	Stock	4.5268	4.5318	4.5082	4.517	14979720.0
2019-09-16 15:00:00	NVDA	Stock	4.5172	4.5278	4.5048	4.505	33055520.0
2019-09-16 16:00:00	NVDA	Stock	4.5052	4.5052	4.5	4.505	6019760.0
2019-09-16 17:00:00	NVDA	Stock	4.5038	4.51	4.5038	4.5042	131240.0
2019-09-16 18:00:00	NVDA	Stock	4.5188	4.5212	4.514	4.5193	65960.0
2019-09-16 19:00:00	NVDA	Stock	4.52	4.52	4.5145	4.5145	93000.0
2019-09-16 04:00:00	AMZN	Stock	91.375	91.375	91.375	91.375	2000.0
2019-09-16 05:00:00	AMZN	Stock	91.228	91.2685	91.228	91.2685	7620.0
2019-09-16 06:00:00	AMZN	Stock	91.3	91.3	91.3	91.3	7220.0

> showing 50 of 51,231 rows — these rows as CSV

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