PREVIEW / stock_1hour / 2019-09-13

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-09-13.parquet
  size:    1.1 MB
  rows:    50,223
  symbols: 2,550

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-13 04:00:00	AAPL	Stock	55.925	55.94	55.835	55.8375	14664.0
2019-09-13 05:00:00	AAPL	Stock	55.8375	55.865	55.7875	55.7875	45940.0
2019-09-13 06:00:00	AAPL	Stock	55.7575	55.7575	55.175	55.4425	182860.0
2019-09-13 07:00:00	AAPL	Stock	55.4425	55.625	55.3775	55.4625	491000.0
2019-09-13 08:00:00	AAPL	Stock	55.4775	55.6225	55.0325	55.0575	1807808.0
2019-09-13 09:00:00	AAPL	Stock	55.055	55.1975	54.705	54.9525	25161916.0
2019-09-13 10:00:00	AAPL	Stock	54.9575	54.97	54.5875	54.7125	20124896.0
2019-09-13 11:00:00	AAPL	Stock	54.7175	54.82	54.55	54.5525	10050032.0
2019-09-13 12:00:00	AAPL	Stock	54.55	54.625	54.27	54.46	15263384.0
2019-09-13 13:00:00	AAPL	Stock	54.46	54.5225	54.255	54.304	9760612.0
2019-09-13 14:00:00	AAPL	Stock	54.3025	54.9525	54.3025	54.8812	22803100.0
2019-09-13 15:00:00	AAPL	Stock	54.8825	54.885	54.5925	54.7	15815472.0
2019-09-13 16:00:00	AAPL	Stock	54.6875	54.715	54.625	54.6725	7538556.0
2019-09-13 17:00:00	AAPL	Stock	54.655	54.6875	54.635	54.65	145772.0
2019-09-13 18:00:00	AAPL	Stock	54.64	54.65	54.6375	54.64	43928.0
2019-09-13 19:00:00	AAPL	Stock	54.65	54.67	54.6025	54.6125	66248.0
2019-09-13 04:00:00	MSFT	Stock	137.63	137.81	137.63	137.81	5306.0
2019-09-13 05:00:00	MSFT	Stock	137.7	137.85	137.7	137.8	1818.0
2019-09-13 06:00:00	MSFT	Stock	137.86	138.33	137.86	138.33	10222.0
2019-09-13 07:00:00	MSFT	Stock	138.13	138.35	138.05	138.05	21195.0
2019-09-13 08:00:00	MSFT	Stock	138.3	138.4	137.7	137.75	49889.0
2019-09-13 09:00:00	MSFT	Stock	137.758	138.0	136.57	137.37	2201075.0
2019-09-13 10:00:00	MSFT	Stock	137.37	137.99	136.98	137.76	2339789.0
2019-09-13 11:00:00	MSFT	Stock	137.76	138.06	137.215	137.43	1800730.0
2019-09-13 12:00:00	MSFT	Stock	137.43	137.68	137.21	137.28	1384324.0
2019-09-13 13:00:00	MSFT	Stock	137.28	137.58	137.13	137.293	1300619.0
2019-09-13 14:00:00	MSFT	Stock	137.29	137.48	137.18	137.355	1041069.0
2019-09-13 15:00:00	MSFT	Stock	137.36	137.48	136.89	137.21	3263899.0
2019-09-13 16:00:00	MSFT	Stock	137.32	137.432	137.12	137.18	3538927.0
2019-09-13 17:00:00	MSFT	Stock	137.32	137.32	137.22	137.274	1360.0
2019-09-13 19:00:00	MSFT	Stock	137.18	137.18	137.15	137.15	1610.0
2019-09-13 04:00:00	NVDA	Stock	4.6125	4.6125	4.525	4.5625	172640.0
2019-09-13 05:00:00	NVDA	Stock	4.562	4.5948	4.562	4.575	58360.0
2019-09-13 06:00:00	NVDA	Stock	4.575	4.5752	4.57	4.574	66360.0
2019-09-13 07:00:00	NVDA	Stock	4.5808	4.5925	4.5725	4.5725	409160.0
2019-09-13 08:00:00	NVDA	Stock	4.595	4.595	4.55	4.5526	1260440.0
2019-09-13 09:00:00	NVDA	Stock	4.55	4.5534	4.5045	4.5202	68755600.0
2019-09-13 10:00:00	NVDA	Stock	4.5215	4.5445	4.5055	4.5391	46773080.0
2019-09-13 11:00:00	NVDA	Stock	4.54	4.5733	4.54	4.5675	38567080.0
2019-09-13 12:00:00	NVDA	Stock	4.5679	4.577	4.5452	4.555	28562640.0
2019-09-13 13:00:00	NVDA	Stock	4.5535	4.5585	4.5311	4.532	17784880.0
2019-09-13 14:00:00	NVDA	Stock	4.5308	4.5548	4.53	4.5482	21220440.0
2019-09-13 15:00:00	NVDA	Stock	4.548	4.5662	4.5408	4.548	49098160.0
2019-09-13 16:00:00	NVDA	Stock	4.5485	4.55	4.5413	4.549	17930120.0
2019-09-13 17:00:00	NVDA	Stock	4.5485	4.5485	4.545	4.545	83200.0
2019-09-13 18:00:00	NVDA	Stock	4.5425	4.5425	4.5425	4.5425	12160.0
2019-09-13 19:00:00	NVDA	Stock	4.5425	4.549	4.5425	4.545	104720.0
2019-09-13 05:00:00	AMZN	Stock	92.3795	92.3795	92.3795	92.3795	2000.0
2019-09-13 06:00:00	AMZN	Stock	92.346	92.494	92.346	92.494	26820.0
2019-09-13 07:00:00	AMZN	Stock	92.525	92.525	92.4255	92.437	59840.0

> showing 50 of 50,223 rows — these rows as CSV

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