PREVIEW / stock_1hour / 2021-05-14

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-05-14.parquet
  size:    1.4 MB
  rows:    64,568
  symbols: 2,966

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
2021-05-14 04:00:00	AAPL	Stock	126.0	126.33	125.82	126.3	13944.0
2021-05-14 05:00:00	AAPL	Stock	126.3	126.68	126.3	126.49	16618.0
2021-05-14 06:00:00	AAPL	Stock	126.41	126.55	126.38	126.45	11756.0
2021-05-14 07:00:00	AAPL	Stock	126.48	126.62	126.3	126.47	211977.0
2021-05-14 08:00:00	AAPL	Stock	126.4501	126.62	126.1	126.5	561664.0
2021-05-14 09:00:00	AAPL	Stock	126.5	127.15	125.98	126.398	12069172.0
2021-05-14 10:00:00	AAPL	Stock	126.38	126.78	125.85	126.76	12010965.0
2021-05-14 11:00:00	AAPL	Stock	126.755	126.79	126.4011	126.52	6840618.0
2021-05-14 12:00:00	AAPL	Stock	126.53	127.17	126.47	127.145	6153477.0
2021-05-14 13:00:00	AAPL	Stock	127.145	127.285	126.973	127.22	5638822.0
2021-05-14 14:00:00	AAPL	Stock	127.21	127.7311	127.15	127.53	6788603.0
2021-05-14 15:00:00	AAPL	Stock	127.53	127.89	127.16	127.45	12237201.0
2021-05-14 16:00:00	AAPL	Stock	127.55	127.55	127.25	127.55	11333075.0
2021-05-14 17:00:00	AAPL	Stock	127.55	127.64	127.51	127.61	56349.0
2021-05-14 18:00:00	AAPL	Stock	127.61	127.65	127.55	127.61	41420.0
2021-05-14 19:00:00	AAPL	Stock	127.61	127.8	127.6	127.79	72552.0
2021-05-14 04:00:00	MSFT	Stock	244.64	245.23	244.64	245.05	678.0
2021-05-14 05:00:00	MSFT	Stock	245.47	246.6	245.47	246.0	2906.0
2021-05-14 06:00:00	MSFT	Stock	246.0	246.2	245.66	245.87	4572.0
2021-05-14 07:00:00	MSFT	Stock	245.75	246.05	245.31	245.65	21857.0
2021-05-14 08:00:00	MSFT	Stock	245.31	245.98	245.0	245.7	36571.0
2021-05-14 09:00:00	MSFT	Stock	245.36	248.66	245.36	247.75	3070159.0
2021-05-14 10:00:00	MSFT	Stock	247.74	247.95	246.26	247.3701	2493431.0
2021-05-14 11:00:00	MSFT	Stock	247.3933	248.19	247.19	247.62	1759448.0
2021-05-14 12:00:00	MSFT	Stock	247.61	248.37	247.48	248.29	1185748.0
2021-05-14 13:00:00	MSFT	Stock	248.29	248.8	248.24	248.76	1216647.0
2021-05-14 14:00:00	MSFT	Stock	248.7613	249.18	248.35	249.0	1685450.0
2021-05-14 15:00:00	MSFT	Stock	249.0	249.14	248.0	248.08	3395651.0
2021-05-14 16:00:00	MSFT	Stock	248.49	248.49	248.08	248.45	4034769.0
2021-05-14 17:00:00	MSFT	Stock	248.4	249.24	248.3	249.2	23941.0
2021-05-14 18:00:00	MSFT	Stock	249.2	249.84	249.2	249.35	20810.0
2021-05-14 19:00:00	MSFT	Stock	249.37	249.45	249.15	249.2	6388.0
2021-05-14 04:00:00	NVDA	Stock	13.838	13.892	13.838	13.892	19880.0
2021-05-14 05:00:00	NVDA	Stock	13.892	13.95	13.875	13.875	108520.0
2021-05-14 06:00:00	NVDA	Stock	13.875	13.875	13.875	13.875	6040.0
2021-05-14 07:00:00	NVDA	Stock	13.8725	13.9038	13.8662	13.875	126600.0
2021-05-14 08:00:00	NVDA	Stock	13.917	13.917	13.8305	13.8875	377000.0
2021-05-14 09:00:00	NVDA	Stock	13.8725	13.9062	13.7485	13.875	16014400.0
2021-05-14 10:00:00	NVDA	Stock	13.88	14.0602	13.8355	14.0245	23252080.0
2021-05-14 11:00:00	NVDA	Stock	14.0298	14.1075	13.9828	14.0948	18960240.0
2021-05-14 12:00:00	NVDA	Stock	14.0959	14.211	14.0893	14.2022	16003960.0
2021-05-14 13:00:00	NVDA	Stock	14.2014	14.2545	14.173	14.2475	11367440.0
2021-05-14 14:00:00	NVDA	Stock	14.251	14.3281	14.2275	14.3022	15411840.0
2021-05-14 15:00:00	NVDA	Stock	14.307	14.3232	14.2335	14.2478	29035960.0
2021-05-14 16:00:00	NVDA	Stock	14.243	14.2608	14.2425	14.25	27802280.0
2021-05-14 17:00:00	NVDA	Stock	14.251	14.2655	14.2508	14.2655	63200.0
2021-05-14 18:00:00	NVDA	Stock	14.2625	14.2938	14.2625	14.2938	170800.0
2021-05-14 19:00:00	NVDA	Stock	14.299	14.335	14.299	14.3152	175600.0
2021-05-14 05:00:00	AMZN	Stock	159.7	159.7	159.7	159.7	2000.0
2021-05-14 07:00:00	AMZN	Stock	159.6885	159.695	159.55	159.592	73240.0

> showing 50 of 64,568 rows — these rows as CSV

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