PREVIEW / stock_1hour / 2020-06-19

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-06-19.parquet
  size:    1.3 MB
  rows:    57,623
  symbols: 2,446

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-06-19 04:00:00	AAPL	Stock	88.5125	88.6	88.3375	88.475	8888.0
2020-06-19 05:00:00	AAPL	Stock	88.575	88.625	88.455	88.455	24920.0
2020-06-19 06:00:00	AAPL	Stock	88.475	88.5725	88.3875	88.47	32520.0
2020-06-19 07:00:00	AAPL	Stock	88.47	88.7125	88.3525	88.7125	308448.0
2020-06-19 08:00:00	AAPL	Stock	88.715	88.9125	88.375	88.9	729276.0
2020-06-19 09:00:00	AAPL	Stock	88.9	89.2375	88.61	88.7525	30749300.0
2020-06-19 10:00:00	AAPL	Stock	88.7575	88.9475	88.315	88.5275	13778608.0
2020-06-19 11:00:00	AAPL	Stock	88.5325	88.7675	88.24	88.3062	10108132.0
2020-06-19 12:00:00	AAPL	Stock	88.3075	88.335	87.03	87.745	26715748.0
2020-06-19 13:00:00	AAPL	Stock	87.7415	87.755	86.79	86.7975	16583000.0
2020-06-19 14:00:00	AAPL	Stock	86.7975	86.9975	86.2875	86.8375	20997124.0
2020-06-19 15:00:00	AAPL	Stock	86.85	87.58	86.5425	87.3875	32543120.0
2020-06-19 16:00:00	AAPL	Stock	87.3775	87.4925	86.8575	86.9	57710892.0
2020-06-19 17:00:00	AAPL	Stock	86.9125	87.075	83.75	87.075	1293268.0
2020-06-19 18:00:00	AAPL	Stock	87.075	87.075	86.875	86.9	56676.0
2020-06-19 19:00:00	AAPL	Stock	86.9375	86.9375	86.765	86.7675	60560.0
2020-06-19 04:00:00	MSFT	Stock	197.04	197.1	197.04	197.1	1475.0
2020-06-19 05:00:00	MSFT	Stock	197.49	197.5	197.39	197.39	2722.0
2020-06-19 06:00:00	MSFT	Stock	197.49	197.5	197.21	197.5	903.0
2020-06-19 07:00:00	MSFT	Stock	197.3	198.0	197.21	197.98	40589.0
2020-06-19 08:00:00	MSFT	Stock	197.69	198.85	197.355	198.65	143948.0
2020-06-19 09:00:00	MSFT	Stock	198.61	199.84	198.19	198.43	10347955.0
2020-06-19 10:00:00	MSFT	Stock	198.435	199.29	197.8	197.98	3233064.0
2020-06-19 11:00:00	MSFT	Stock	197.985	198.469	196.94	197.019	2497135.0
2020-06-19 12:00:00	MSFT	Stock	197.015	197.14	194.37	196.882	4709282.0
2020-06-19 13:00:00	MSFT	Stock	196.9	196.94	195.23	195.24	2390967.0
2020-06-19 14:00:00	MSFT	Stock	195.23	196.13	194.63	195.91	2897319.0
2020-06-19 15:00:00	MSFT	Stock	195.9	196.86	195.02	195.03	5170167.0
2020-06-19 16:00:00	MSFT	Stock	195.15	196.41	194.01	194.71	6266470.0
2020-06-19 17:00:00	MSFT	Stock	194.71	195.09	194.71	194.81	38246.0
2020-06-19 18:00:00	MSFT	Stock	194.82	194.88	194.63	194.84	3888.0
2020-06-19 19:00:00	MSFT	Stock	194.71	194.81	194.65	194.71	7841.0
2020-06-19 05:00:00	NVDA	Stock	9.3	9.3	9.2925	9.2925	40680.0
2020-06-19 06:00:00	NVDA	Stock	9.3	9.3	9.263	9.263	296320.0
2020-06-19 07:00:00	NVDA	Stock	9.2625	9.2775	9.2555	9.2775	316280.0
2020-06-19 08:00:00	NVDA	Stock	9.2672	9.2975	9.255	9.2975	1336120.0
2020-06-19 09:00:00	NVDA	Stock	9.2875	9.3992	9.2274	9.38	97427200.0
2020-06-19 10:00:00	NVDA	Stock	9.3798	9.4188	9.347	9.3821	66620160.0
2020-06-19 11:00:00	NVDA	Stock	9.383	9.445	9.378	9.3848	54968520.0
2020-06-19 12:00:00	NVDA	Stock	9.385	9.3868	9.2475	9.3655	70019120.0
2020-06-19 13:00:00	NVDA	Stock	9.3662	9.3692	9.2688	9.2701	29451520.0
2020-06-19 14:00:00	NVDA	Stock	9.2715	9.3175	9.2378	9.3029	39927760.0
2020-06-19 15:00:00	NVDA	Stock	9.3018	9.321	9.2548	9.2592	49253080.0
2020-06-19 16:00:00	NVDA	Stock	9.2568	9.2612	9.2125	9.23	66275000.0
2020-06-19 17:00:00	NVDA	Stock	9.2373	9.2495	9.2302	9.235	165840.0
2020-06-19 18:00:00	NVDA	Stock	9.2375	9.2375	9.227	9.2325	35440.0
2020-06-19 19:00:00	NVDA	Stock	9.2325	9.2438	9.2138	9.2138	114480.0
2020-06-19 04:00:00	AMZN	Stock	133.6005	133.6005	133.6005	133.6005	2460.0
2020-06-19 06:00:00	AMZN	Stock	133.534	133.55	133.534	133.55	5320.0
2020-06-19 07:00:00	AMZN	Stock	133.7495	134.0	133.676	134.0	204480.0

> showing 50 of 57,623 rows — these rows as CSV

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