PREVIEW / stock_1hour / 2019-05-01

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-05-01.parquet
  size:    1.1 MB
  rows:    49,613
  symbols: 2,624

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-05-01 04:00:00	AAPL	Stock	52.7	52.85	52.7	52.8	37780.0
2019-05-01 05:00:00	AAPL	Stock	52.7825	53.0	52.75	53.0	52420.0
2019-05-01 06:00:00	AAPL	Stock	53.0	53.1675	52.975	53.1075	122116.0
2019-05-01 07:00:00	AAPL	Stock	53.1	53.1875	52.8525	52.875	915028.0
2019-05-01 08:00:00	AAPL	Stock	53.0225	53.1875	52.62	52.65	2173588.0
2019-05-01 09:00:00	AAPL	Stock	52.65	53.0125	52.3075	52.8075	48421936.0
2019-05-01 10:00:00	AAPL	Stock	52.8	53.345	52.73	53.265	35381596.0
2019-05-01 11:00:00	AAPL	Stock	53.2675	53.8275	53.25	53.7115	32501128.0
2019-05-01 12:00:00	AAPL	Stock	53.72	53.7675	53.315	53.48	20261412.0
2019-05-01 13:00:00	AAPL	Stock	53.49	53.67	53.4325	53.5625	12000980.0
2019-05-01 14:00:00	AAPL	Stock	53.5625	53.775	53.3575	53.535	20217456.0
2019-05-01 15:00:00	AAPL	Stock	53.53	53.7	52.6125	52.63	39409884.0
2019-05-01 16:00:00	AAPL	Stock	52.63	52.7	52.5625	52.6	11610484.0
2019-05-01 17:00:00	AAPL	Stock	52.595	52.63	52.47	52.47	320604.0
2019-05-01 18:00:00	AAPL	Stock	52.4975	52.625	52.475	52.62	239704.0
2019-05-01 19:00:00	AAPL	Stock	52.6075	52.6825	52.6075	52.6625	177996.0
2019-05-01 04:00:00	MSFT	Stock	131.23	131.23	131.0	131.0	200.0
2019-05-01 05:00:00	MSFT	Stock	131.0	131.0	131.0	131.0	100.0
2019-05-01 06:00:00	MSFT	Stock	130.99	130.99	130.86	130.86	350.0
2019-05-01 07:00:00	MSFT	Stock	130.86	130.95	130.65	130.77	15589.0
2019-05-01 08:00:00	MSFT	Stock	130.989	130.99	130.7	130.85	15298.0
2019-05-01 09:00:00	MSFT	Stock	130.76	130.83	129.594	129.87	2960013.0
2019-05-01 10:00:00	MSFT	Stock	129.87	130.0	129.49	129.637	2260822.0
2019-05-01 11:00:00	MSFT	Stock	129.636	129.97	129.582	129.73	1899315.0
2019-05-01 12:00:00	MSFT	Stock	129.73	129.8	129.34	129.535	1845294.0
2019-05-01 13:00:00	MSFT	Stock	129.535	129.75	129.25	129.417	1457853.0
2019-05-01 14:00:00	MSFT	Stock	129.42	129.82	128.68	128.99	3394127.0
2019-05-01 15:00:00	MSFT	Stock	128.99	129.03	127.7	127.877	5756855.0
2019-05-01 16:00:00	MSFT	Stock	127.88	127.98	127.54	127.57	2306145.0
2019-05-01 17:00:00	MSFT	Stock	127.57	127.88	127.57	127.7	22471.0
2019-05-01 18:00:00	MSFT	Stock	127.7	127.78	127.54	127.75	10719.0
2019-05-01 19:00:00	MSFT	Stock	127.77	127.97	127.7	127.97	5790.0
2019-05-01 05:00:00	NVDA	Stock	4.6075	4.6075	4.6075	4.6075	4000.0
2019-05-01 06:00:00	NVDA	Stock	4.6025	4.6025	4.6025	4.6025	4000.0
2019-05-01 07:00:00	NVDA	Stock	4.5875	4.6	4.5835	4.593	364000.0
2019-05-01 08:00:00	NVDA	Stock	4.6	4.6	4.5768	4.5768	1572640.0
2019-05-01 09:00:00	NVDA	Stock	4.5785	4.6125	4.5538	4.5853	63721920.0
2019-05-01 10:00:00	NVDA	Stock	4.5838	4.5859	4.5425	4.5665	50409000.0
2019-05-01 11:00:00	NVDA	Stock	4.5662	4.576	4.5262	4.571	36640920.0
2019-05-01 12:00:00	NVDA	Stock	4.572	4.5878	4.5525	4.563	26521960.0
2019-05-01 13:00:00	NVDA	Stock	4.5636	4.596	4.5605	4.5922	20363840.0
2019-05-01 14:00:00	NVDA	Stock	4.5922	4.6203	4.5785	4.59	48173800.0
2019-05-01 15:00:00	NVDA	Stock	4.5915	4.5932	4.5115	4.5118	61856360.0
2019-05-01 16:00:00	NVDA	Stock	4.5118	4.5125	4.4915	4.4915	12754080.0
2019-05-01 17:00:00	NVDA	Stock	4.491	4.5	4.491	4.5	185280.0
2019-05-01 18:00:00	NVDA	Stock	4.497	4.5055	4.4968	4.5022	193000.0
2019-05-01 19:00:00	NVDA	Stock	4.5022	4.5025	4.4968	4.4968	157080.0
2019-05-01 04:00:00	AMZN	Stock	96.8	96.8	96.8	96.8	3740.0
2019-05-01 06:00:00	AMZN	Stock	96.7555	96.7555	96.75	96.75	7960.0
2019-05-01 07:00:00	AMZN	Stock	96.787	96.83	96.675	96.785	89080.0

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

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