PREVIEW / stock_1hour / 2021-05-05

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-05-05.parquet
  size:    1.4 MB
  rows:    65,394
  symbols: 2,991

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-05 04:00:00	AAPL	Stock	128.4	128.82	128.36	128.79	57302.0
2021-05-05 05:00:00	AAPL	Stock	128.79	129.1	128.74	128.9	27505.0
2021-05-05 06:00:00	AAPL	Stock	128.9	129.1	128.89	129.0	45422.0
2021-05-05 07:00:00	AAPL	Stock	129.0	129.01	128.67	128.9	226323.0
2021-05-05 08:00:00	AAPL	Stock	128.78	129.23	128.68	128.95	622865.0
2021-05-05 09:00:00	AAPL	Stock	128.94	130.45	128.77	129.7299	15120979.0
2021-05-05 10:00:00	AAPL	Stock	129.73	129.92	128.86	129.755	14434488.0
2021-05-05 11:00:00	AAPL	Stock	129.75	130.2	129.47	130.1489	7434287.0
2021-05-05 12:00:00	AAPL	Stock	130.15	130.1899	129.411	129.45	5608041.0
2021-05-05 13:00:00	AAPL	Stock	129.44	129.59	129.16	129.3064	5262273.0
2021-05-05 14:00:00	AAPL	Stock	129.31	129.33	128.64	128.8	6768151.0
2021-05-05 15:00:00	AAPL	Stock	128.804	128.8299	127.97	128.15	13010155.0
2021-05-05 16:00:00	AAPL	Stock	128.1	128.2	127.94	127.96	5245738.0
2021-05-05 17:00:00	AAPL	Stock	127.95	128.05	127.81	128.04	81175.0
2021-05-05 18:00:00	AAPL	Stock	128.02	128.1	127.9101	127.97	46636.0
2021-05-05 19:00:00	AAPL	Stock	127.93	128.04	127.89	127.98	129336.0
2021-05-05 04:00:00	MSFT	Stock	247.78	248.6	247.78	248.6	944.0
2021-05-05 05:00:00	MSFT	Stock	248.55	249.47	248.55	249.31	2601.0
2021-05-05 06:00:00	MSFT	Stock	249.3	249.3	248.96	249.3	4137.0
2021-05-05 07:00:00	MSFT	Stock	249.05	249.3	248.56	248.81	30081.0
2021-05-05 08:00:00	MSFT	Stock	248.76	249.4699	247.99	248.9	48459.0
2021-05-05 09:00:00	MSFT	Stock	248.74	249.5	248.365	248.62	1823758.0
2021-05-05 10:00:00	MSFT	Stock	248.68	248.76	247.3901	248.37	1900755.0
2021-05-05 11:00:00	MSFT	Stock	248.37	248.76	247.77	248.6	1103469.0
2021-05-05 12:00:00	MSFT	Stock	248.6	248.9	247.62	247.645	1192310.0
2021-05-05 13:00:00	MSFT	Stock	247.66	248.04	247.21	247.4899	949401.0
2021-05-05 14:00:00	MSFT	Stock	247.51	247.5794	246.79	246.8701	1127080.0
2021-05-05 15:00:00	MSFT	Stock	246.87	247.07	245.82	246.5	2897929.0
2021-05-05 16:00:00	MSFT	Stock	246.51	246.7829	246.1	246.1	2076511.0
2021-05-05 17:00:00	MSFT	Stock	246.22	246.39	245.95	246.22	24278.0
2021-05-05 18:00:00	MSFT	Stock	246.24	246.38	245.98	246.09	8354.0
2021-05-05 19:00:00	MSFT	Stock	245.98	246.3	245.98	246.3	11952.0
2021-05-05 04:00:00	NVDA	Stock	14.6195	14.6195	14.6195	14.6195	4000.0
2021-05-05 05:00:00	NVDA	Stock	14.6122	14.6125	14.6	14.6	22120.0
2021-05-05 06:00:00	NVDA	Stock	14.5878	14.619	14.5832	14.619	20000.0
2021-05-05 07:00:00	NVDA	Stock	14.6015	14.6625	14.5625	14.6275	520080.0
2021-05-05 08:00:00	NVDA	Stock	14.6004	14.6875	14.56	14.6475	893720.0
2021-05-05 09:00:00	NVDA	Stock	14.6368	14.8135	14.6202	14.625	36643440.0
2021-05-05 10:00:00	NVDA	Stock	14.6305	14.7888	14.5398	14.7731	39407600.0
2021-05-05 11:00:00	NVDA	Stock	14.7665	14.782	14.6628	14.7472	17270800.0
2021-05-05 12:00:00	NVDA	Stock	14.7495	14.757	14.591	14.5995	14511360.0
2021-05-05 13:00:00	NVDA	Stock	14.598	14.641	14.5588	14.58	13178280.0
2021-05-05 14:00:00	NVDA	Stock	14.5828	14.5882	14.4933	14.4976	15474840.0
2021-05-05 15:00:00	NVDA	Stock	14.4978	14.5382	14.3875	14.4602	32183120.0
2021-05-05 16:00:00	NVDA	Stock	14.4585	14.46	14.425	14.4252	18975440.0
2021-05-05 17:00:00	NVDA	Stock	14.4375	14.446	14.425	14.4312	126240.0
2021-05-05 18:00:00	NVDA	Stock	14.4375	14.4375	14.3903	14.3903	217640.0
2021-05-05 19:00:00	NVDA	Stock	14.4175	14.435	14.4138	14.425	122800.0
2021-05-05 04:00:00	AMZN	Stock	166.551	166.6925	166.502	166.6925	15160.0
2021-05-05 05:00:00	AMZN	Stock	166.65	166.65	166.65	166.65	2000.0

> showing 50 of 65,394 rows — these rows as CSV

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