PREVIEW / stock_1hour / 2021-06-14

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-06-14.parquet
  size:    1.5 MB
  rows:    67,380
  symbols: 2,968

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-06-14 04:00:00	AAPL	Stock	127.4	127.75	127.4	127.6	13344.0
2021-06-14 05:00:00	AAPL	Stock	127.6	127.72	127.6	127.65	5983.0
2021-06-14 06:00:00	AAPL	Stock	127.65	127.99	127.65	127.94	9864.0
2021-06-14 07:00:00	AAPL	Stock	127.87	128.19	127.75	127.81	145697.0
2021-06-14 08:00:00	AAPL	Stock	127.8399	128.0799	127.56	127.66	248764.0
2021-06-14 09:00:00	AAPL	Stock	127.645	129.34	127.07	129.12	13231027.0
2021-06-14 10:00:00	AAPL	Stock	129.12	129.6	128.47	129.58	11902583.0
2021-06-14 11:00:00	AAPL	Stock	129.5724	129.88	129.25	129.4799	8450294.0
2021-06-14 12:00:00	AAPL	Stock	129.475	129.59	129.2626	129.565	6383060.0
2021-06-14 13:00:00	AAPL	Stock	129.565	130.0	129.525	129.9191	6182791.0
2021-06-14 14:00:00	AAPL	Stock	129.915	130.4	129.81	130.075	8147337.0
2021-06-14 15:00:00	AAPL	Stock	130.07	130.49	129.74	130.49	12735012.0
2021-06-14 16:00:00	AAPL	Stock	130.485	130.54	130.21	130.38	19236542.0
2021-06-14 17:00:00	AAPL	Stock	130.39	130.48	130.17	130.28	107403.0
2021-06-14 18:00:00	AAPL	Stock	130.28	130.35	130.21	130.28	43914.0
2021-06-14 19:00:00	AAPL	Stock	130.28	130.34	130.18	130.2	68342.0
2021-06-14 04:00:00	MSFT	Stock	258.29	258.5	258.25	258.5	464.0
2021-06-14 05:00:00	MSFT	Stock	258.6	258.6	258.6	258.6	200.0
2021-06-14 06:00:00	MSFT	Stock	258.69	258.9	258.68	258.9	4161.0
2021-06-14 07:00:00	MSFT	Stock	258.54	258.87	258.5	258.65	9195.0
2021-06-14 08:00:00	MSFT	Stock	258.7999	258.8	258.23	258.33	6431.0
2021-06-14 09:00:00	MSFT	Stock	258.39	258.65	256.8	257.74	1812441.0
2021-06-14 10:00:00	MSFT	Stock	257.75	257.84	256.94	257.67	1537026.0
2021-06-14 11:00:00	MSFT	Stock	257.66	257.99	257.52	257.925	1040352.0
2021-06-14 12:00:00	MSFT	Stock	257.915	258.14	257.6583	257.925	743788.0
2021-06-14 13:00:00	MSFT	Stock	257.93	258.455	257.86	258.395	783924.0
2021-06-14 14:00:00	MSFT	Stock	258.4	258.54	258.29	258.3846	873147.0
2021-06-14 15:00:00	MSFT	Stock	258.38	259.95	257.9263	259.88	3220183.0
2021-06-14 16:00:00	MSFT	Stock	259.89	259.95	259.75	259.85	4815249.0
2021-06-14 17:00:00	MSFT	Stock	259.85	259.85	259.71	259.8	9606.0
2021-06-14 18:00:00	MSFT	Stock	259.79	259.79	259.6	259.63	7969.0
2021-06-14 19:00:00	MSFT	Stock	259.65	259.79	259.61	259.63	6769.0
2021-06-14 04:00:00	NVDA	Stock	17.9225	17.98	17.9075	17.98	61400.0
2021-06-14 05:00:00	NVDA	Stock	18.0125	18.0125	17.9505	17.9505	36760.0
2021-06-14 06:00:00	NVDA	Stock	17.9748	17.975	17.9602	17.9602	38040.0
2021-06-14 07:00:00	NVDA	Stock	17.9648	17.9725	17.9	17.9	522720.0
2021-06-14 08:00:00	NVDA	Stock	17.9503	17.9745	17.8732	17.875	1008800.0
2021-06-14 09:00:00	NVDA	Stock	17.8512	17.925	17.6628	17.7938	45848840.0
2021-06-14 10:00:00	NVDA	Stock	17.801	17.873	17.7215	17.8432	35135680.0
2021-06-14 11:00:00	NVDA	Stock	17.8458	17.8862	17.8136	17.8577	14378400.0
2021-06-14 12:00:00	NVDA	Stock	17.861	17.993	17.8442	17.9568	21619280.0
2021-06-14 13:00:00	NVDA	Stock	17.96	18.0395	17.948	17.9992	21399280.0
2021-06-14 14:00:00	NVDA	Stock	18.0004	18.0192	17.9355	17.9808	13325280.0
2021-06-14 15:00:00	NVDA	Stock	17.9782	18.0202	17.9443	18.0172	27197320.0
2021-06-14 16:00:00	NVDA	Stock	18.0188	18.0275	18.0072	18.0123	16295960.0
2021-06-14 17:00:00	NVDA	Stock	18.0072	18.0172	18.0072	18.0162	199480.0
2021-06-14 18:00:00	NVDA	Stock	18.012	18.0123	17.981	17.997	130880.0
2021-06-14 19:00:00	NVDA	Stock	17.9945	18.0125	17.988	18.0125	111000.0
2021-06-14 05:00:00	AMZN	Stock	167.9	167.9	167.9	167.9	2000.0
2021-06-14 06:00:00	AMZN	Stock	167.849	167.9	167.849	167.9	4000.0

> showing 50 of 67,380 rows — these rows as CSV

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