PREVIEW / stock_1hour / 2019-08-21

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-08-21.parquet
  size:    1.1 MB
  rows:    50,206
  symbols: 2,562

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-08-21 04:00:00	AAPL	Stock	52.775	53.135	52.775	53.135	21240.0
2019-08-21 05:00:00	AAPL	Stock	53.1125	53.2	53.0875	53.1125	32664.0
2019-08-21 06:00:00	AAPL	Stock	53.09	53.1125	53.045	53.075	28592.0
2019-08-21 07:00:00	AAPL	Stock	53.1	53.1	53.0	53.0525	178424.0
2019-08-21 08:00:00	AAPL	Stock	53.06	53.115	53.0	53.115	217500.0
2019-08-21 09:00:00	AAPL	Stock	53.1025	53.3175	53.1	53.286	11807992.0
2019-08-21 10:00:00	AAPL	Stock	53.285	53.3575	53.2162	53.3025	11479692.0
2019-08-21 11:00:00	AAPL	Stock	53.3	53.4125	53.2225	53.335	8687664.0
2019-08-21 12:00:00	AAPL	Stock	53.34	53.3425	53.2175	53.2875	6096008.0
2019-08-21 13:00:00	AAPL	Stock	53.285	53.3375	53.05	53.085	5899304.0
2019-08-21 14:00:00	AAPL	Stock	53.085	53.2625	52.9008	53.07	10161048.0
2019-08-21 15:00:00	AAPL	Stock	53.0675	53.1825	53.0275	53.1625	11203040.0
2019-08-21 16:00:00	AAPL	Stock	53.16	53.2	53.0645	53.1875	8307304.0
2019-08-21 17:00:00	AAPL	Stock	53.1875	53.2375	53.1825	53.2125	28808.0
2019-08-21 18:00:00	AAPL	Stock	53.225	53.375	53.225	53.29	133284.0
2019-08-21 19:00:00	AAPL	Stock	53.3	53.3475	53.2875	53.3475	57632.0
2019-08-21 04:00:00	MSFT	Stock	137.7	138.25	137.7	138.25	2337.0
2019-08-21 05:00:00	MSFT	Stock	138.33	138.44	138.33	138.44	1516.0
2019-08-21 06:00:00	MSFT	Stock	138.3	138.3	138.3	138.3	100.0
2019-08-21 07:00:00	MSFT	Stock	138.2	138.28	137.81	138.2	16762.0
2019-08-21 08:00:00	MSFT	Stock	138.1	138.33	137.69	138.2	45369.0
2019-08-21 09:00:00	MSFT	Stock	138.22	139.494	138.22	139.1	2135087.0
2019-08-21 10:00:00	MSFT	Stock	139.1	139.19	138.64	138.93	1670081.0
2019-08-21 11:00:00	MSFT	Stock	138.92	139.11	138.72	138.855	1494842.0
2019-08-21 12:00:00	MSFT	Stock	138.86	138.904	138.64	138.77	978401.0
2019-08-21 13:00:00	MSFT	Stock	138.762	138.78	138.47	138.53	819324.0
2019-08-21 14:00:00	MSFT	Stock	138.52	138.83	138.0	138.52	1317954.0
2019-08-21 15:00:00	MSFT	Stock	138.51	138.95	138.34	138.78	2279020.0
2019-08-21 16:00:00	MSFT	Stock	138.79	138.96	138.53	138.96	1906647.0
2019-08-21 17:00:00	MSFT	Stock	138.91	138.96	138.8	138.88	9893.0
2019-08-21 18:00:00	MSFT	Stock	138.97	139.25	138.97	139.17	25277.0
2019-08-21 19:00:00	MSFT	Stock	139.11	139.25	139.11	139.11	5418.0
2019-08-21 04:00:00	NVDA	Stock	4.2498	4.262	4.2175	4.255	95720.0
2019-08-21 05:00:00	NVDA	Stock	4.2518	4.2525	4.2405	4.245	144360.0
2019-08-21 06:00:00	NVDA	Stock	4.2445	4.2597	4.2445	4.25	107040.0
2019-08-21 07:00:00	NVDA	Stock	4.2575	4.2575	4.2388	4.246	580040.0
2019-08-21 08:00:00	NVDA	Stock	4.245	4.275	4.2392	4.2738	2359320.0
2019-08-21 09:00:00	NVDA	Stock	4.2688	4.3112	4.2415	4.3082	87621280.0
2019-08-21 10:00:00	NVDA	Stock	4.3082	4.332	4.308	4.3185	87746840.0
2019-08-21 11:00:00	NVDA	Stock	4.3173	4.3362	4.3125	4.3205	51999920.0
2019-08-21 12:00:00	NVDA	Stock	4.3225	4.3225	4.297	4.3058	34828800.0
2019-08-21 13:00:00	NVDA	Stock	4.3056	4.3056	4.2778	4.2808	33351000.0
2019-08-21 14:00:00	NVDA	Stock	4.281	4.2897	4.258	4.2705	45634280.0
2019-08-21 15:00:00	NVDA	Stock	4.2705	4.2895	4.2638	4.281	64580160.0
2019-08-21 16:00:00	NVDA	Stock	4.2808	4.2925	4.2752	4.2833	3401600.0
2019-08-21 17:00:00	NVDA	Stock	4.2888	4.3	4.286	4.3	403640.0
2019-08-21 18:00:00	NVDA	Stock	4.305	4.3138	4.2962	4.3138	302040.0
2019-08-21 19:00:00	NVDA	Stock	4.31	4.316	4.3038	4.3125	449960.0
2019-08-21 04:00:00	AMZN	Stock	90.757	90.786	90.757	90.786	4380.0
2019-08-21 05:00:00	AMZN	Stock	90.8635	90.9	90.8635	90.9	6840.0

> showing 50 of 50,206 rows — these rows as CSV

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