PREVIEW / stock_1hour / 2020-07-02

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-07-02.parquet
  size:    1.2 MB
  rows:    56,406
  symbols: 2,435

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
2020-07-02 04:00:00	AAPL	Stock	91.3475	91.5025	91.2625	91.5	10216.0
2020-07-02 05:00:00	AAPL	Stock	91.46	91.525	91.3775	91.38	17444.0
2020-07-02 06:00:00	AAPL	Stock	91.3975	91.4525	91.35	91.4525	22368.0
2020-07-02 07:00:00	AAPL	Stock	91.375	91.5	91.375	91.455	181572.0
2020-07-02 08:00:00	AAPL	Stock	91.435	91.85	91.33	91.8025	898244.0
2020-07-02 09:00:00	AAPL	Stock	91.8025	92.6175	91.6625	92.495	18484452.0
2020-07-02 10:00:00	AAPL	Stock	92.4975	92.52	91.375	91.8078	19549620.0
2020-07-02 11:00:00	AAPL	Stock	91.8075	91.885	91.4525	91.86	9652432.0
2020-07-02 12:00:00	AAPL	Stock	91.86	92.015	91.6675	91.8925	7059100.0
2020-07-02 13:00:00	AAPL	Stock	91.89	91.8975	91.5738	91.6125	6267076.0
2020-07-02 14:00:00	AAPL	Stock	91.605	91.8275	91.535	91.78	5314572.0
2020-07-02 15:00:00	AAPL	Stock	91.7775	91.82	90.91	91.03	14842528.0
2020-07-02 16:00:00	AAPL	Stock	91.03	91.2375	91.0275	91.215	9651820.0
2020-07-02 17:00:00	AAPL	Stock	91.215	91.25	91.16	91.2225	39004.0
2020-07-02 18:00:00	AAPL	Stock	91.225	91.3	91.2025	91.2025	33128.0
2020-07-02 19:00:00	AAPL	Stock	91.2	91.225	91.15	91.2125	44180.0
2020-07-02 04:00:00	MSFT	Stock	205.8	205.99	205.5	205.5	6770.0
2020-07-02 05:00:00	MSFT	Stock	205.49	205.6	205.3	205.6	3301.0
2020-07-02 06:00:00	MSFT	Stock	205.7	205.7	205.35	205.65	2081.0
2020-07-02 07:00:00	MSFT	Stock	205.7	206.0	205.43	205.72	43857.0
2020-07-02 08:00:00	MSFT	Stock	205.72	206.8	205.4	206.598	115433.0
2020-07-02 09:00:00	MSFT	Stock	206.6	207.71	205.0	207.43	4321691.0
2020-07-02 10:00:00	MSFT	Stock	207.43	207.99	206.37	207.7	4127024.0
2020-07-02 11:00:00	MSFT	Stock	207.69	207.7	206.062	207.031	2939857.0
2020-07-02 12:00:00	MSFT	Stock	207.03	207.9	206.66	207.88	1872768.0
2020-07-02 13:00:00	MSFT	Stock	207.88	208.02	207.51	207.615	1756616.0
2020-07-02 14:00:00	MSFT	Stock	207.615	207.9	207.31	207.722	1667560.0
2020-07-02 15:00:00	MSFT	Stock	207.73	207.82	205.85	206.21	4565533.0
2020-07-02 16:00:00	MSFT	Stock	206.26	207.424	205.79	206.65	3962513.0
2020-07-02 17:00:00	MSFT	Stock	206.42	206.69	206.41	206.41	7279.0
2020-07-02 18:00:00	MSFT	Stock	206.4	206.75	206.4	206.69	2576.0
2020-07-02 19:00:00	MSFT	Stock	206.7	206.75	206.62	206.7	8420.0
2020-07-02 04:00:00	NVDA	Stock	9.5688	9.6295	9.5688	9.6115	28880.0
2020-07-02 05:00:00	NVDA	Stock	9.622	9.622	9.5875	9.5875	32000.0
2020-07-02 06:00:00	NVDA	Stock	9.5812	9.5812	9.5812	9.5812	26000.0
2020-07-02 07:00:00	NVDA	Stock	9.5808	9.625	9.575	9.6232	743520.0
2020-07-02 08:00:00	NVDA	Stock	9.6	9.662	9.5812	9.6546	2004560.0
2020-07-02 09:00:00	NVDA	Stock	9.655	9.7271	9.6172	9.7153	62041680.0
2020-07-02 10:00:00	NVDA	Stock	9.7125	9.7375	9.6325	9.6708	52612000.0
2020-07-02 11:00:00	NVDA	Stock	9.6695	9.675	9.5782	9.6658	32546920.0
2020-07-02 12:00:00	NVDA	Stock	9.6632	9.665	9.6285	9.6608	15064800.0
2020-07-02 13:00:00	NVDA	Stock	9.6582	9.6975	9.6463	9.6523	20046000.0
2020-07-02 14:00:00	NVDA	Stock	9.6513	9.71	9.6332	9.7075	18917160.0
2020-07-02 15:00:00	NVDA	Stock	9.7088	9.7098	9.5848	9.619	53020840.0
2020-07-02 16:00:00	NVDA	Stock	9.6123	9.64	9.5692	9.625	29741360.0
2020-07-02 17:00:00	NVDA	Stock	9.6225	9.625	9.6225	9.625	67800.0
2020-07-02 18:00:00	NVDA	Stock	9.625	9.6348	9.625	9.6348	41640.0
2020-07-02 19:00:00	NVDA	Stock	9.625	9.635	9.625	9.625	94600.0
2020-07-02 04:00:00	AMZN	Stock	144.837	145.049	144.6895	144.6895	22140.0
2020-07-02 05:00:00	AMZN	Stock	144.561	144.561	144.561	144.561	2000.0

> showing 50 of 56,406 rows — these rows as CSV

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