PREVIEW / stock_1hour / 2020-04-03

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-04-03.parquet
  size:    1.1 MB
  rows:    52,782
  symbols: 2,395

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
2020-04-03 04:00:00	AAPL	Stock	60.655	60.825	60.35	60.5025	8932.0
2020-04-03 05:00:00	AAPL	Stock	60.4125	60.525	60.375	60.525	3668.0
2020-04-03 06:00:00	AAPL	Stock	60.5975	60.67	60.5	60.605	11380.0
2020-04-03 07:00:00	AAPL	Stock	60.5	61.45	60.5	61.3775	235200.0
2020-04-03 08:00:00	AAPL	Stock	60.7	61.45	60.5	60.8725	799120.0
2020-04-03 09:00:00	AAPL	Stock	60.8032	61.425	60.5625	61.1575	12515424.0
2020-04-03 10:00:00	AAPL	Stock	61.1425	61.415	60.39	60.76	18182864.0
2020-04-03 11:00:00	AAPL	Stock	60.7525	60.8975	60.3975	60.576	11413244.0
2020-04-03 12:00:00	AAPL	Stock	60.5775	60.675	60.1625	60.4465	10818980.0
2020-04-03 13:00:00	AAPL	Stock	60.44	60.625	59.9725	60.0925	9736728.0
2020-04-03 14:00:00	AAPL	Stock	60.09	60.2225	59.825	60.1825	12140104.0
2020-04-03 15:00:00	AAPL	Stock	60.1825	60.4225	59.7435	60.3575	22819424.0
2020-04-03 16:00:00	AAPL	Stock	60.355	60.5025	60.315	60.4375	11382304.0
2020-04-03 17:00:00	AAPL	Stock	60.4425	60.45	60.3875	60.3875	42864.0
2020-04-03 18:00:00	AAPL	Stock	60.3775	60.425	60.2825	60.3375	91096.0
2020-04-03 19:00:00	AAPL	Stock	60.3025	60.375	60.25	60.3575	86584.0
2020-04-03 04:00:00	MSFT	Stock	154.44	154.44	153.0	153.07	4687.0
2020-04-03 05:00:00	MSFT	Stock	153.23	153.23	153.05	153.05	428.0
2020-04-03 06:00:00	MSFT	Stock	153.85	153.89	153.59	153.89	1564.0
2020-04-03 07:00:00	MSFT	Stock	153.6	155.77	153.56	155.5	56526.0
2020-04-03 08:00:00	MSFT	Stock	154.1	155.65	153.8	154.7	113803.0
2020-04-03 09:00:00	MSFT	Stock	154.7	156.94	154.45	156.34	4131833.0
2020-04-03 10:00:00	MSFT	Stock	156.34	157.38	155.07	156.06	5865411.0
2020-04-03 11:00:00	MSFT	Stock	156.09	156.465	154.474	154.81	3753777.0
2020-04-03 12:00:00	MSFT	Stock	154.78	155.01	153.01	153.562	3803601.0
2020-04-03 13:00:00	MSFT	Stock	153.562	154.2	152.36	152.59	3098367.0
2020-04-03 14:00:00	MSFT	Stock	152.59	153.76	152.19	153.56	3201127.0
2020-04-03 15:00:00	MSFT	Stock	153.545	154.76	152.605	153.82	5838294.0
2020-04-03 16:00:00	MSFT	Stock	153.83	154.26	153.53	153.98	3755920.0
2020-04-03 17:00:00	MSFT	Stock	154.0	154.0	153.6	153.77	21479.0
2020-04-03 18:00:00	MSFT	Stock	153.6	153.69	153.26	153.69	13295.0
2020-04-03 19:00:00	MSFT	Stock	153.5	153.7	153.41	153.62	10574.0
2020-04-03 04:00:00	NVDA	Stock	6.325	6.325	6.3002	6.3002	32000.0
2020-04-03 05:00:00	NVDA	Stock	6.3068	6.3068	6.3068	6.3068	5800.0
2020-04-03 06:00:00	NVDA	Stock	6.309	6.331	6.3053	6.31	77600.0
2020-04-03 07:00:00	NVDA	Stock	6.329	6.4013	6.3153	6.4	1195760.0
2020-04-03 08:00:00	NVDA	Stock	6.3747	6.4005	6.3175	6.365	1871560.0
2020-04-03 09:00:00	NVDA	Stock	6.375	6.4103	6.23	6.2582	72426440.0
2020-04-03 10:00:00	NVDA	Stock	6.2625	6.2925	6.115	6.132	89958960.0
2020-04-03 11:00:00	NVDA	Stock	6.1352	6.175	6.0922	6.1431	67925520.0
2020-04-03 12:00:00	NVDA	Stock	6.1426	6.1561	6.04	6.0458	72844960.0
2020-04-03 13:00:00	NVDA	Stock	6.046	6.0656	5.9633	5.9788	80878240.0
2020-04-03 14:00:00	NVDA	Stock	5.9767	6.0813	5.9598	6.064	84411520.0
2020-04-03 15:00:00	NVDA	Stock	6.0682	6.1203	5.9998	6.0978	88244680.0
2020-04-03 16:00:00	NVDA	Stock	6.0978	6.1125	6.0885	6.0978	25432680.0
2020-04-03 17:00:00	NVDA	Stock	6.0978	6.0978	6.0913	6.0913	164520.0
2020-04-03 18:00:00	NVDA	Stock	6.0915	6.096	6.0708	6.0712	335800.0
2020-04-03 19:00:00	NVDA	Stock	6.0653	6.0748	6.0583	6.0688	228320.0
2020-04-03 06:00:00	AMZN	Stock	95.4975	95.4975	95.4975	95.4975	2000.0
2020-04-03 07:00:00	AMZN	Stock	95.4495	95.95	95.306	95.95	96680.0

> showing 50 of 52,782 rows — these rows as CSV

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