PREVIEW / stock_1hour / 2019-01-09

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-01-09.parquet
  size:    1.1 MB
  rows:    49,611
  symbols: 2,697

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-01-09 04:00:00	AAPL	Stock	37.8	38.11	37.8	38.0375	47660.0
2019-01-09 05:00:00	AAPL	Stock	38.075	38.3	38.0375	38.3	142896.0
2019-01-09 06:00:00	AAPL	Stock	38.2725	38.3	38.15	38.175	145648.0
2019-01-09 07:00:00	AAPL	Stock	38.185	38.2225	37.8325	37.92	633800.0
2019-01-09 08:00:00	AAPL	Stock	38.0	38.19	37.6075	37.7075	1317252.0
2019-01-09 09:00:00	AAPL	Stock	37.7	38.01	37.4075	37.9548	24633848.0
2019-01-09 10:00:00	AAPL	Stock	37.9575	38.2025	37.85	38.1255	27709000.0
2019-01-09 11:00:00	AAPL	Stock	38.1225	38.51	38.0825	38.4525	29687256.0
2019-01-09 12:00:00	AAPL	Stock	38.4525	38.5925	38.4175	38.4625	18343784.0
2019-01-09 13:00:00	AAPL	Stock	38.4625	38.5525	38.3825	38.4762	12531044.0
2019-01-09 14:00:00	AAPL	Stock	38.475	38.6325	38.2325	38.4425	17411188.0
2019-01-09 15:00:00	AAPL	Stock	38.4425	38.6243	38.2775	38.3275	20221876.0
2019-01-09 16:00:00	AAPL	Stock	38.3275	38.4525	38.0852	38.3275	8888764.0
2019-01-09 17:00:00	AAPL	Stock	38.25	38.25	38.2	38.225	57192.0
2019-01-09 18:00:00	AAPL	Stock	38.2175	38.24	38.1875	38.1925	49356.0
2019-01-09 19:00:00	AAPL	Stock	38.1875	38.225	38.1375	38.155	82244.0
2019-01-09 04:00:00	MSFT	Stock	103.74	103.74	103.43	103.51	2710.0
2019-01-09 05:00:00	MSFT	Stock	103.51	103.52	103.01	103.15	12257.0
2019-01-09 06:00:00	MSFT	Stock	103.24	103.24	102.91	103.2	6650.0
2019-01-09 07:00:00	MSFT	Stock	103.24	103.25	102.61	103.15	15722.0
2019-01-09 08:00:00	MSFT	Stock	103.2	103.5	102.8	103.4	48921.0
2019-01-09 09:00:00	MSFT	Stock	103.4	104.27	103.21	104.15	4081344.0
2019-01-09 10:00:00	MSFT	Stock	104.145	104.29	103.244	103.79	4562583.0
2019-01-09 11:00:00	MSFT	Stock	103.79	104.62	103.68	104.42	3811825.0
2019-01-09 12:00:00	MSFT	Stock	104.41	104.79	104.135	104.67	2894968.0
2019-01-09 13:00:00	MSFT	Stock	104.68	104.763	104.33	104.49	2215521.0
2019-01-09 14:00:00	MSFT	Stock	104.485	104.88	103.98	104.266	3191063.0
2019-01-09 15:00:00	MSFT	Stock	104.265	104.4	103.88	104.31	4934651.0
2019-01-09 16:00:00	MSFT	Stock	104.27	104.37	104.0	104.27	3206540.0
2019-01-09 17:00:00	MSFT	Stock	104.1	104.18	104.0	104.08	4606.0
2019-01-09 18:00:00	MSFT	Stock	104.09	104.17	103.89	104.17	5163.0
2019-01-09 19:00:00	MSFT	Stock	103.96	104.1	103.8	103.8	8865.0
2019-01-09 04:00:00	NVDA	Stock	3.5125	3.5312	3.5125	3.5312	56880.0
2019-01-09 05:00:00	NVDA	Stock	3.5202	3.5222	3.505	3.5078	53200.0
2019-01-09 06:00:00	NVDA	Stock	3.5062	3.5062	3.4928	3.5018	80800.0
2019-01-09 07:00:00	NVDA	Stock	3.5165	3.5375	3.498	3.5375	1120560.0
2019-01-09 08:00:00	NVDA	Stock	3.5168	3.5472	3.498	3.5358	3210000.0
2019-01-09 09:00:00	NVDA	Stock	3.5338	3.6123	3.4965	3.6	115925880.0
2019-01-09 10:00:00	NVDA	Stock	3.5998	3.6095	3.506	3.5273	93854400.0
2019-01-09 11:00:00	NVDA	Stock	3.5264	3.5657	3.5125	3.5517	74552960.0
2019-01-09 12:00:00	NVDA	Stock	3.5521	3.5682	3.52	3.5441	52641480.0
2019-01-09 13:00:00	NVDA	Stock	3.5431	3.5715	3.525	3.5368	47324280.0
2019-01-09 14:00:00	NVDA	Stock	3.5385	3.555	3.506	3.546	62785120.0
2019-01-09 15:00:00	NVDA	Stock	3.5469	3.5768	3.5442	3.5672	71807320.0
2019-01-09 16:00:00	NVDA	Stock	3.5645	3.5675	3.555	3.5645	22111360.0
2019-01-09 17:00:00	NVDA	Stock	3.558	3.5688	3.5562	3.5628	513800.0
2019-01-09 18:00:00	NVDA	Stock	3.5618	3.5748	3.5583	3.5742	848160.0
2019-01-09 19:00:00	NVDA	Stock	3.5725	3.575	3.569	3.575	674360.0
2019-01-09 04:00:00	AMZN	Stock	83.367	83.7	83.35	83.55	36000.0
2019-01-09 05:00:00	AMZN	Stock	83.3	83.55	83.262	83.55	23900.0

> showing 50 of 49,611 rows — these rows as CSV

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