PREVIEW / stock_1hour / 2019-10-22

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-10-22.parquet
  size:    1.1 MB
  rows:    49,360
  symbols: 2,493

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-10-22 04:00:00	AAPL	Stock	60.1275	60.135	60.1275	60.135	4656.0
2019-10-22 05:00:00	AAPL	Stock	60.095	60.1975	60.095	60.1975	7288.0
2019-10-22 06:00:00	AAPL	Stock	60.215	60.2175	60.1525	60.1825	11696.0
2019-10-22 07:00:00	AAPL	Stock	60.215	60.3375	60.17	60.3	177504.0
2019-10-22 08:00:00	AAPL	Stock	60.2125	60.3725	60.175	60.2975	429012.0
2019-10-22 09:00:00	AAPL	Stock	60.295	60.4875	60.075	60.2562	13608436.0
2019-10-22 10:00:00	AAPL	Stock	60.26	60.46	60.175	60.39	8599916.0
2019-10-22 11:00:00	AAPL	Stock	60.3925	60.44	60.2305	60.2975	7598688.0
2019-10-22 12:00:00	AAPL	Stock	60.2985	60.4855	60.262	60.4845	5155492.0
2019-10-22 13:00:00	AAPL	Stock	60.4825	60.495	60.3325	60.485	5956836.0
2019-10-22 14:00:00	AAPL	Stock	60.4825	60.55	60.0875	60.1875	11564592.0
2019-10-22 15:00:00	AAPL	Stock	60.1875	60.26	59.9055	59.9925	12049324.0
2019-10-22 16:00:00	AAPL	Stock	59.99	60.0425	59.675	59.725	4419732.0
2019-10-22 17:00:00	AAPL	Stock	59.7	59.99	59.6875	59.8025	50072.0
2019-10-22 18:00:00	AAPL	Stock	59.8025	59.8875	59.8025	59.81	33444.0
2019-10-22 19:00:00	AAPL	Stock	59.805	59.8675	59.75	59.755	114844.0
2019-10-22 05:00:00	MSFT	Stock	138.66	138.8	138.66	138.79	1253.0
2019-10-22 06:00:00	MSFT	Stock	138.8	138.87	138.8	138.87	305.0
2019-10-22 07:00:00	MSFT	Stock	138.75	138.95	138.68	138.9	14522.0
2019-10-22 08:00:00	MSFT	Stock	138.8	138.93	138.72	138.86	34882.0
2019-10-22 09:00:00	MSFT	Stock	138.89	140.01	138.86	139.38	2945857.0
2019-10-22 10:00:00	MSFT	Stock	139.39	139.565	138.98	139.03	2726621.0
2019-10-22 11:00:00	MSFT	Stock	139.02	139.025	137.73	137.778	2827596.0
2019-10-22 12:00:00	MSFT	Stock	137.78	138.11	137.52	137.925	2711270.0
2019-10-22 13:00:00	MSFT	Stock	137.92	137.92	137.03	137.25	2004425.0
2019-10-22 14:00:00	MSFT	Stock	137.24	137.65	136.95	137.055	2963160.0
2019-10-22 15:00:00	MSFT	Stock	137.065	137.17	136.26	136.39	5656616.0
2019-10-22 16:00:00	MSFT	Stock	136.37	137.79	135.3	135.5	2700804.0
2019-10-22 17:00:00	MSFT	Stock	135.5	136.37	135.5	136.088	30854.0
2019-10-22 18:00:00	MSFT	Stock	136.0	136.25	135.96	136.0	21185.0
2019-10-22 19:00:00	MSFT	Stock	135.99	136.1	135.96	136.0	15723.0
2019-10-22 04:00:00	NVDA	Stock	4.9088	4.9088	4.9045	4.9045	32000.0
2019-10-22 05:00:00	NVDA	Stock	4.9088	4.9288	4.9088	4.9288	53960.0
2019-10-22 06:00:00	NVDA	Stock	4.9448	4.959	4.94	4.9583	45600.0
2019-10-22 07:00:00	NVDA	Stock	4.9508	4.9765	4.9175	4.9693	1569680.0
2019-10-22 08:00:00	NVDA	Stock	4.9575	4.9825	4.94	4.9722	2315360.0
2019-10-22 09:00:00	NVDA	Stock	4.97	5.0632	4.9275	4.9607	96036120.0
2019-10-22 10:00:00	NVDA	Stock	4.962	4.9722	4.9151	4.9495	43784720.0
2019-10-22 11:00:00	NVDA	Stock	4.949	4.9563	4.9025	4.9058	26651600.0
2019-10-22 12:00:00	NVDA	Stock	4.9038	4.942	4.9008	4.9232	17975240.0
2019-10-22 13:00:00	NVDA	Stock	4.9225	4.9278	4.9025	4.9164	15805000.0
2019-10-22 14:00:00	NVDA	Stock	4.9157	4.9403	4.908	4.9138	20722000.0
2019-10-22 15:00:00	NVDA	Stock	4.9148	4.92	4.8825	4.8882	37863440.0
2019-10-22 16:00:00	NVDA	Stock	4.8903	4.8903	4.7388	4.75	16308320.0
2019-10-22 17:00:00	NVDA	Stock	4.754	4.8903	4.754	4.7812	657880.0
2019-10-22 18:00:00	NVDA	Stock	4.775	4.7917	4.775	4.7862	308240.0
2019-10-22 19:00:00	NVDA	Stock	4.788	4.7938	4.7825	4.785	238560.0
2019-10-22 05:00:00	AMZN	Stock	89.3495	89.3495	89.3495	89.3495	2000.0
2019-10-22 07:00:00	AMZN	Stock	89.394	89.394	89.394	89.394	2000.0
2019-10-22 08:00:00	AMZN	Stock	89.38	89.442	89.3	89.34	216360.0

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

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