PREVIEW / stock_1hour / 2020-08-12

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-08-12.parquet
  size:    1.2 MB
  rows:    57,178
  symbols: 2,434

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-08-12 04:00:00	AAPL	Stock	110.35	110.655	110.3475	110.655	12140.0
2020-08-12 05:00:00	AAPL	Stock	110.625	110.625	110.545	110.545	9460.0
2020-08-12 06:00:00	AAPL	Stock	110.515	110.71	110.475	110.6175	42420.0
2020-08-12 07:00:00	AAPL	Stock	110.615	110.815	110.4525	110.625	372636.0
2020-08-12 08:00:00	AAPL	Stock	110.4605	110.825	109.6475	110.55	630480.0
2020-08-12 09:00:00	AAPL	Stock	110.525	111.395	110.29	111.3188	19596416.0
2020-08-12 10:00:00	AAPL	Stock	111.3175	111.85	110.9	111.7725	18880464.0
2020-08-12 11:00:00	AAPL	Stock	111.7675	112.5	111.598	112.3825	15898984.0
2020-08-12 12:00:00	AAPL	Stock	112.3775	113.275	112.3575	112.7075	20732532.0
2020-08-12 13:00:00	AAPL	Stock	112.7102	113.23	112.28	113.2062	17349908.0
2020-08-12 14:00:00	AAPL	Stock	113.2048	113.275	112.6775	112.8262	11992252.0
2020-08-12 15:00:00	AAPL	Stock	112.8325	113.2625	112.54	113.06	17621312.0
2020-08-12 16:00:00	AAPL	Stock	113.01	113.0125	112.845	113.0	7371672.0
2020-08-12 17:00:00	AAPL	Stock	113.01	113.0225	112.7	112.825	102736.0
2020-08-12 18:00:00	AAPL	Stock	112.825	113.0	112.7375	112.9875	150588.0
2020-08-12 19:00:00	AAPL	Stock	112.9875	113.125	112.9375	113.1225	149900.0
2020-08-12 04:00:00	MSFT	Stock	206.03	206.03	205.51	205.93	3321.0
2020-08-12 05:00:00	MSFT	Stock	205.94	205.94	205.49	205.6	2072.0
2020-08-12 06:00:00	MSFT	Stock	205.61	205.86	205.41	205.74	6567.0
2020-08-12 07:00:00	MSFT	Stock	205.85	205.85	204.76	205.18	45517.0
2020-08-12 08:00:00	MSFT	Stock	205.18	205.8	203.88	204.75	76839.0
2020-08-12 09:00:00	MSFT	Stock	204.75	207.15	204.52	207.11	3060008.0
2020-08-12 10:00:00	MSFT	Stock	207.125	209.13	206.66	208.67	4001026.0
2020-08-12 11:00:00	MSFT	Stock	208.66	209.7	208.288	209.495	2412798.0
2020-08-12 12:00:00	MSFT	Stock	209.53	209.83	208.68	208.803	2071776.0
2020-08-12 13:00:00	MSFT	Stock	208.8	210.15	208.58	210.065	2085284.0
2020-08-12 14:00:00	MSFT	Stock	210.06	210.28	209.09	209.41	2337131.0
2020-08-12 15:00:00	MSFT	Stock	209.43	209.93	208.62	209.29	3656725.0
2020-08-12 16:00:00	MSFT	Stock	209.19	209.19	208.5	208.78	3062180.0
2020-08-12 17:00:00	MSFT	Stock	208.78	208.84	208.75	208.75	2929.0
2020-08-12 18:00:00	MSFT	Stock	208.72	208.84	208.71	208.71	3390.0
2020-08-12 19:00:00	MSFT	Stock	208.77	208.99	208.7	208.9	14827.0
2020-08-12 04:00:00	NVDA	Stock	11.002	11.002	11.0	11.0	8000.0
2020-08-12 05:00:00	NVDA	Stock	11.0135	11.0138	11.0135	11.0138	16400.0
2020-08-12 07:00:00	NVDA	Stock	10.9818	11.0065	10.9775	10.9775	323880.0
2020-08-12 08:00:00	NVDA	Stock	10.968	11.0	10.877	10.9365	1187040.0
2020-08-12 09:00:00	NVDA	Stock	10.9388	11.15	10.9288	11.1485	59952880.0
2020-08-12 10:00:00	NVDA	Stock	11.1472	11.2355	11.0808	11.2213	60930160.0
2020-08-12 11:00:00	NVDA	Stock	11.2198	11.3648	11.2145	11.3582	75652680.0
2020-08-12 12:00:00	NVDA	Stock	11.3591	11.408	11.3465	11.3626	52780560.0
2020-08-12 13:00:00	NVDA	Stock	11.363	11.4312	11.3302	11.4271	34907520.0
2020-08-12 14:00:00	NVDA	Stock	11.4282	11.4665	11.406	11.44	34628840.0
2020-08-12 15:00:00	NVDA	Stock	11.4418	11.467	11.359	11.4378	73653080.0
2020-08-12 16:00:00	NVDA	Stock	11.4402	11.4402	11.415	11.415	2884560.0
2020-08-12 17:00:00	NVDA	Stock	11.429	11.4328	11.414	11.418	252520.0
2020-08-12 18:00:00	NVDA	Stock	11.4242	11.427	11.413	11.413	157760.0
2020-08-12 19:00:00	NVDA	Stock	11.415	11.4212	11.408	11.4205	263320.0
2020-08-12 04:00:00	AMZN	Stock	155.5	155.5	155.0	155.0	22980.0
2020-08-12 05:00:00	AMZN	Stock	155.25	155.25	154.9835	154.9835	20740.0
2020-08-12 07:00:00	AMZN	Stock	155.31	155.31	155.0	155.125	103060.0

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

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