PREVIEW / stock_1hour / 2020-11-02

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-11-02.parquet
  size:    1.3 MB
  rows:    57,874
  symbols: 2,536

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-11-02 04:00:00	AAPL	Stock	109.62	109.85	109.02	109.64	71519.0
2020-11-02 05:00:00	AAPL	Stock	109.65	110.1	109.59	110.0	33471.0
2020-11-02 06:00:00	AAPL	Stock	109.99	110.04	109.5	109.69	42466.0
2020-11-02 07:00:00	AAPL	Stock	109.67	109.87	109.27	109.5	429100.0
2020-11-02 08:00:00	AAPL	Stock	109.45	109.8	109.05	109.1	881525.0
2020-11-02 09:00:00	AAPL	Stock	109.11	110.68	108.8	109.82	16913064.0
2020-11-02 10:00:00	AAPL	Stock	109.83	110.23	108.43	108.49	19467574.0
2020-11-02 11:00:00	AAPL	Stock	108.48	108.69	107.72	107.915	13823634.0
2020-11-02 12:00:00	AAPL	Stock	107.91	108.6	107.79	108.135	12395198.0
2020-11-02 13:00:00	AAPL	Stock	108.14	108.25	107.32	107.413	11143722.0
2020-11-02 14:00:00	AAPL	Stock	107.415	108.1	107.36	107.832	10511317.0
2020-11-02 15:00:00	AAPL	Stock	107.832	108.78	107.73	108.77	16935445.0
2020-11-02 16:00:00	AAPL	Stock	108.77	108.85	108.41	108.72	7491345.0
2020-11-02 17:00:00	AAPL	Stock	108.7	108.7	108.25	108.47	125327.0
2020-11-02 18:00:00	AAPL	Stock	108.47	108.74	108.46	108.61	115816.0
2020-11-02 19:00:00	AAPL	Stock	108.61	109.18	108.58	109.13	187908.0
2020-11-02 04:00:00	MSFT	Stock	203.7	205.19	203.7	204.9	8262.0
2020-11-02 05:00:00	MSFT	Stock	205.03	205.33	204.95	205.24	7249.0
2020-11-02 06:00:00	MSFT	Stock	205.11	205.2	204.87	204.93	6656.0
2020-11-02 07:00:00	MSFT	Stock	204.93	205.0	203.72	204.02	48015.0
2020-11-02 08:00:00	MSFT	Stock	204.38	204.99	203.6	204.1	68083.0
2020-11-02 09:00:00	MSFT	Stock	204.09	205.28	203.61	204.39	3202237.0
2020-11-02 10:00:00	MSFT	Stock	204.46	204.89	202.81	203.07	3486472.0
2020-11-02 11:00:00	MSFT	Stock	203.07	203.3	201.75	201.85	2725036.0
2020-11-02 12:00:00	MSFT	Stock	201.87	202.02	200.72	201.25	2421091.0
2020-11-02 13:00:00	MSFT	Stock	201.264	201.38	200.14	200.19	2017232.0
2020-11-02 14:00:00	MSFT	Stock	200.21	201.73	200.12	201.3	1915580.0
2020-11-02 15:00:00	MSFT	Stock	201.3	202.37	200.64	202.32	4195320.0
2020-11-02 16:00:00	MSFT	Stock	202.33	202.55	202.05	202.4	3448517.0
2020-11-02 17:00:00	MSFT	Stock	202.25	202.54	202.242	202.42	6866.0
2020-11-02 18:00:00	MSFT	Stock	202.5	203.0	202.4	202.75	25895.0
2020-11-02 19:00:00	MSFT	Stock	202.74	203.57	202.58	203.57	27101.0
2020-11-02 04:00:00	NVDA	Stock	12.6678	12.7	12.6538	12.7	21040.0
2020-11-02 05:00:00	NVDA	Stock	12.7248	12.7422	12.7	12.7	45680.0
2020-11-02 06:00:00	NVDA	Stock	12.7125	12.7125	12.71	12.71	36400.0
2020-11-02 07:00:00	NVDA	Stock	12.678	12.69	12.6302	12.6498	517400.0
2020-11-02 08:00:00	NVDA	Stock	12.6812	12.71	12.6327	12.65	651200.0
2020-11-02 09:00:00	NVDA	Stock	12.64	12.775	12.5003	12.7101	49753200.0
2020-11-02 10:00:00	NVDA	Stock	12.7158	12.8366	12.6506	12.738	42966040.0
2020-11-02 11:00:00	NVDA	Stock	12.7352	12.7538	12.5625	12.6188	27126800.0
2020-11-02 12:00:00	NVDA	Stock	12.6142	12.6458	12.4935	12.5142	21497000.0
2020-11-02 13:00:00	NVDA	Stock	12.52	12.5263	12.395	12.4071	21985040.0
2020-11-02 14:00:00	NVDA	Stock	12.4032	12.525	12.3968	12.5194	18351200.0
2020-11-02 15:00:00	NVDA	Stock	12.517	12.5875	12.486	12.5843	26871280.0
2020-11-02 16:00:00	NVDA	Stock	12.5808	12.5963	12.5752	12.5812	14853120.0
2020-11-02 17:00:00	NVDA	Stock	12.5788	12.5805	12.5583	12.575	186800.0
2020-11-02 18:00:00	NVDA	Stock	12.5808	12.625	12.5808	12.6125	74280.0
2020-11-02 19:00:00	NVDA	Stock	12.6125	12.65	12.605	12.65	62920.0
2020-11-02 04:00:00	AMZN	Stock	153.35	153.75	153.3	153.75	25180.0
2020-11-02 06:00:00	AMZN	Stock	154.503	154.503	153.25	153.25	64440.0

> showing 50 of 57,874 rows — these rows as CSV

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