PREVIEW / stock_1hour / 2019-10-29

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-10-29.parquet
  size:    1.1 MB
  rows:    49,852
  symbols: 2,507

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-29 04:00:00	AAPL	Stock	62.2625	62.3	62.175	62.175	30552.0
2019-10-29 05:00:00	AAPL	Stock	62.225	62.2375	62.14	62.15	14676.0
2019-10-29 06:00:00	AAPL	Stock	62.16	62.1925	62.16	62.1925	2988.0
2019-10-29 07:00:00	AAPL	Stock	62.22	62.2225	62.125	62.2075	91332.0
2019-10-29 08:00:00	AAPL	Stock	62.2032	62.25	62.1075	62.2225	254424.0
2019-10-29 09:00:00	AAPL	Stock	62.2328	62.4375	61.965	61.9772	13346612.0
2019-10-29 10:00:00	AAPL	Stock	61.9738	62.005	61.3525	61.375	20511252.0
2019-10-29 11:00:00	AAPL	Stock	61.3825	61.4475	60.7075	60.7952	26513292.0
2019-10-29 12:00:00	AAPL	Stock	60.8	61.1825	60.73	60.8928	13719184.0
2019-10-29 13:00:00	AAPL	Stock	60.8925	60.9925	60.7375	60.9162	10900812.0
2019-10-29 14:00:00	AAPL	Stock	60.9125	60.965	60.6425	60.6688	9716532.0
2019-10-29 15:00:00	AAPL	Stock	60.6675	61.0975	60.6632	60.8225	17218468.0
2019-10-29 16:00:00	AAPL	Stock	60.8225	60.89	60.5	60.875	5366452.0
2019-10-29 17:00:00	AAPL	Stock	60.8725	60.965	60.8225	60.9525	2532052.0
2019-10-29 18:00:00	AAPL	Stock	60.975	61.0	60.95	60.975	109132.0
2019-10-29 19:00:00	AAPL	Stock	60.955	60.9675	60.9275	60.9575	91956.0
2019-10-29 04:00:00	MSFT	Stock	144.18	144.18	144.02	144.02	1018.0
2019-10-29 05:00:00	MSFT	Stock	144.11	144.11	144.11	144.11	200.0
2019-10-29 06:00:00	MSFT	Stock	144.05	144.05	144.02	144.05	1370.0
2019-10-29 07:00:00	MSFT	Stock	144.13	144.14	143.71	143.9	17457.0
2019-10-29 08:00:00	MSFT	Stock	144.1	144.14	143.75	144.0	16515.0
2019-10-29 09:00:00	MSFT	Stock	144.0	144.5	143.81	144.08	2623079.0
2019-10-29 10:00:00	MSFT	Stock	144.08	144.12	143.315	143.42	2642400.0
2019-10-29 11:00:00	MSFT	Stock	143.43	143.72	142.9	143.16	2257291.0
2019-10-29 12:00:00	MSFT	Stock	143.16	143.725	143.05	143.525	1515917.0
2019-10-29 13:00:00	MSFT	Stock	143.53	143.61	142.79	142.85	1493572.0
2019-10-29 14:00:00	MSFT	Stock	142.85	143.15	142.65	143.09	1536502.0
2019-10-29 15:00:00	MSFT	Stock	143.09	143.27	142.73	142.81	2758497.0
2019-10-29 16:00:00	MSFT	Stock	142.83	142.953	142.83	142.83	1629837.0
2019-10-29 17:00:00	MSFT	Stock	142.83	142.88	142.76	142.76	1102790.0
2019-10-29 18:00:00	MSFT	Stock	142.83	142.92	142.82	142.86	3584.0
2019-10-29 19:00:00	MSFT	Stock	142.81	142.9	142.8	142.82	6463.0
2019-10-29 04:00:00	NVDA	Stock	5.1665	5.1665	5.1665	5.1665	4000.0
2019-10-29 07:00:00	NVDA	Stock	5.1625	5.1625	5.1343	5.1343	116520.0
2019-10-29 08:00:00	NVDA	Stock	5.15	5.157	5.131	5.1412	496760.0
2019-10-29 09:00:00	NVDA	Stock	5.14	5.1622	5.086	5.0955	28332560.0
2019-10-29 10:00:00	NVDA	Stock	5.0975	5.1265	5.0645	5.0969	39570440.0
2019-10-29 11:00:00	NVDA	Stock	5.0963	5.105	5.0588	5.0645	26341800.0
2019-10-29 12:00:00	NVDA	Stock	5.064	5.1028	5.0535	5.0868	18851880.0
2019-10-29 13:00:00	NVDA	Stock	5.0878	5.0895	5.0738	5.0841	13555080.0
2019-10-29 14:00:00	NVDA	Stock	5.0841	5.092	5.0725	5.0808	12800240.0
2019-10-29 15:00:00	NVDA	Stock	5.0808	5.095	5.0679	5.0725	27679160.0
2019-10-29 16:00:00	NVDA	Stock	5.073	5.1278	5.0488	5.0875	3959120.0
2019-10-29 17:00:00	NVDA	Stock	5.0898	5.0963	5.073	5.0895	3644240.0
2019-10-29 18:00:00	NVDA	Stock	5.095	5.0988	5.065	5.075	744520.0
2019-10-29 19:00:00	NVDA	Stock	5.066	5.07	5.06	5.06	363760.0
2019-10-29 04:00:00	AMZN	Stock	88.8115	88.8115	88.8115	88.8115	2000.0
2019-10-29 08:00:00	AMZN	Stock	88.55	89.076	88.55	88.8	45280.0
2019-10-29 09:00:00	AMZN	Stock	88.8	88.85	88.275	88.6261	4122300.0
2019-10-29 10:00:00	AMZN	Stock	88.584	88.586	88.1054	88.112	4586540.0

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

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