PREVIEW / stock_1hour / 2021-01-04

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-01-04.parquet
  size:    1.4 MB
  rows:    65,404
  symbols: 2,673

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-01-04 04:00:00	AAPL	Stock	133.31	134.01	133.02	133.6	87961.0
2021-01-04 05:00:00	AAPL	Stock	133.6	134.43	133.43	134.3	147928.0
2021-01-04 06:00:00	AAPL	Stock	134.22	134.35	133.6	133.99	32943.0
2021-01-04 07:00:00	AAPL	Stock	133.92	134.0	133.54	133.95	424254.0
2021-01-04 08:00:00	AAPL	Stock	133.93	134.1	133.53	133.83	509531.0
2021-01-04 09:00:00	AAPL	Stock	133.83	133.87	131.294	131.449	13788693.0
2021-01-04 10:00:00	AAPL	Stock	131.45	131.67	130.38	130.968	16660868.0
2021-01-04 11:00:00	AAPL	Stock	130.97	131.31	128.79	128.82	16900029.0
2021-01-04 12:00:00	AAPL	Stock	128.81	128.919	126.76	128.42	17646282.0
2021-01-04 13:00:00	AAPL	Stock	128.41	129.2	128.05	129.178	10422877.0
2021-01-04 14:00:00	AAPL	Stock	129.17	129.579	128.62	129.492	11092077.0
2021-01-04 15:00:00	AAPL	Stock	129.48	129.74	128.76	129.41	16435041.0
2021-01-04 16:00:00	AAPL	Stock	129.41	129.69	129.16	129.37	17713668.0
2021-01-04 17:00:00	AAPL	Stock	129.39	129.7	129.26	129.33	134279.0
2021-01-04 18:00:00	AAPL	Stock	129.37	129.38	129.15	129.24	122715.0
2021-01-04 19:00:00	AAPL	Stock	129.25	129.41	129.11	129.39	86404.0
2021-01-04 04:00:00	MSFT	Stock	222.75	223.4	222.75	223.15	4902.0
2021-01-04 05:00:00	MSFT	Stock	223.01	223.29	222.52	222.52	4731.0
2021-01-04 06:00:00	MSFT	Stock	222.59	222.83	222.28	222.62	13677.0
2021-01-04 07:00:00	MSFT	Stock	222.83	223.15	222.51	223.1	18043.0
2021-01-04 08:00:00	MSFT	Stock	222.78	223.24	222.53	222.96	29399.0
2021-01-04 09:00:00	MSFT	Stock	222.65	223.0	219.283	219.79	3119846.0
2021-01-04 10:00:00	MSFT	Stock	219.81	220.95	218.87	218.93	2971310.0
2021-01-04 11:00:00	MSFT	Stock	218.95	219.23	216.14	216.27	3354874.0
2021-01-04 12:00:00	MSFT	Stock	216.27	216.57	214.81	215.6	3602340.0
2021-01-04 13:00:00	MSFT	Stock	215.59	217.08	215.27	216.96	2173854.0
2021-01-04 14:00:00	MSFT	Stock	216.956	217.305	216.191	217.25	1980880.0
2021-01-04 15:00:00	MSFT	Stock	217.23	218.24	216.71	217.81	3789201.0
2021-01-04 16:00:00	MSFT	Stock	217.69	217.9	217.36	217.65	8769428.0
2021-01-04 17:00:00	MSFT	Stock	217.65	217.65	217.29	217.63	5628.0
2021-01-04 18:00:00	MSFT	Stock	217.52	217.6	217.35	217.42	2693.0
2021-01-04 19:00:00	MSFT	Stock	217.4	217.64	217.4	217.64	9580.0
2021-01-04 04:00:00	NVDA	Stock	13.08	13.1568	13.07	13.1568	88520.0
2021-01-04 05:00:00	NVDA	Stock	13.15	13.15	13.1375	13.1375	38240.0
2021-01-04 06:00:00	NVDA	Stock	13.1375	13.1375	13.1078	13.115	64760.0
2021-01-04 07:00:00	NVDA	Stock	13.1225	13.1345	13.085	13.1288	456600.0
2021-01-04 08:00:00	NVDA	Stock	13.1384	13.15	13.115	13.1375	581920.0
2021-01-04 09:00:00	NVDA	Stock	13.1412	13.45	12.9625	13.4005	62061200.0
2021-01-04 10:00:00	NVDA	Stock	13.4048	13.6525	13.39	13.4528	102351000.0
2021-01-04 11:00:00	NVDA	Stock	13.451	13.4926	13.2232	13.2232	67184880.0
2021-01-04 12:00:00	NVDA	Stock	13.2273	13.2575	13.0395	13.1405	64926080.0
2021-01-04 13:00:00	NVDA	Stock	13.138	13.173	13.0525	13.1648	45252880.0
2021-01-04 14:00:00	NVDA	Stock	13.1652	13.185	13.0844	13.1586	28288240.0
2021-01-04 15:00:00	NVDA	Stock	13.1572	13.1935	13.0928	13.1135	52287480.0
2021-01-04 16:00:00	NVDA	Stock	13.1135	13.1198	13.1	13.1058	24059520.0
2021-01-04 17:00:00	NVDA	Stock	13.105	13.115	13.1	13.115	177680.0
2021-01-04 18:00:00	NVDA	Stock	13.1063	13.12	13.105	13.1175	215240.0
2021-01-04 19:00:00	NVDA	Stock	13.115	13.1288	13.1138	13.1288	213320.0
2021-01-04 04:00:00	AMZN	Stock	164.2475	164.2475	164.2475	164.2475	2000.0
2021-01-04 07:00:00	AMZN	Stock	164.0	164.0	163.45	163.55	78240.0

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

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