PREVIEW / stock_1hour / 2021-02-05

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-02-05.parquet
  size:    1.5 MB
  rows:    68,580
  symbols: 2,779

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-02-05 04:00:00	AAPL	Stock	137.03	137.85	137.0	137.58	26256.0
2021-02-05 05:00:00	AAPL	Stock	137.73	137.86	137.58	137.86	38550.0
2021-02-05 06:00:00	AAPL	Stock	137.89	138.04	137.6	137.85	56368.0
2021-02-05 07:00:00	AAPL	Stock	137.78	138.19	137.71	138.05	226691.0
2021-02-05 08:00:00	AAPL	Stock	137.85	138.19	137.525	137.75	582448.0
2021-02-05 09:00:00	AAPL	Stock	137.75	137.86	136.08	136.53	11372451.0
2021-02-05 10:00:00	AAPL	Stock	136.53	136.76	135.86	136.47	11308337.0
2021-02-05 11:00:00	AAPL	Stock	136.47	136.77	136.2	136.589	6418608.0
2021-02-05 12:00:00	AAPL	Stock	136.58	137.129	136.515	137.06	6523947.0
2021-02-05 13:00:00	AAPL	Stock	137.06	137.33	136.51	136.535	6013897.0
2021-02-05 14:00:00	AAPL	Stock	136.54	136.78	136.42	136.665	5317133.0
2021-02-05 15:00:00	AAPL	Stock	136.66	136.83	136.06	136.77	10255310.0
2021-02-05 16:00:00	AAPL	Stock	136.76	136.91	135.85	136.55	5133620.0
2021-02-05 17:00:00	AAPL	Stock	136.55	136.68	136.26	136.38	115510.0
2021-02-05 18:00:00	AAPL	Stock	136.37	136.38	136.24	136.35	63838.0
2021-02-05 19:00:00	AAPL	Stock	136.33	136.7	136.31	136.68	94683.0
2021-02-05 04:00:00	MSFT	Stock	242.71	242.71	242.71	242.71	995.0
2021-02-05 05:00:00	MSFT	Stock	242.63	242.63	242.07	242.07	1482.0
2021-02-05 06:00:00	MSFT	Stock	242.18	242.7	241.91	242.69	10064.0
2021-02-05 07:00:00	MSFT	Stock	242.7	242.78	242.52	242.76	23676.0
2021-02-05 08:00:00	MSFT	Stock	242.7	242.84	241.41	242.2	152157.0
2021-02-05 09:00:00	MSFT	Stock	242.15	243.28	240.42	240.72	2190068.0
2021-02-05 10:00:00	MSFT	Stock	240.74	242.03	240.53	241.61	2033107.0
2021-02-05 11:00:00	MSFT	Stock	241.61	241.89	240.77	240.96	1559744.0
2021-02-05 12:00:00	MSFT	Stock	240.97	242.51	240.9	242.5	1282641.0
2021-02-05 13:00:00	MSFT	Stock	242.5	242.67	241.724	241.789	1134600.0
2021-02-05 14:00:00	MSFT	Stock	241.78	242.13	241.43	241.55	1003239.0
2021-02-05 15:00:00	MSFT	Stock	241.55	242.25	241.18	242.2	2044469.0
2021-02-05 16:00:00	MSFT	Stock	242.2	242.3	241.46	242.29	2488352.0
2021-02-05 17:00:00	MSFT	Stock	242.2	242.27	242.1	242.15	1002.0
2021-02-05 18:00:00	MSFT	Stock	242.08	242.28	242.02	242.02	5272.0
2021-02-05 19:00:00	MSFT	Stock	242.28	242.3	242.06	242.3	3342.0
2021-02-05 06:00:00	NVDA	Stock	13.6328	13.6328	13.625	13.625	33880.0
2021-02-05 07:00:00	NVDA	Stock	13.6373	13.6975	13.6373	13.6708	206080.0
2021-02-05 08:00:00	NVDA	Stock	13.675	13.7025	13.6373	13.6955	359840.0
2021-02-05 09:00:00	NVDA	Stock	13.7	13.7372	13.5635	13.5675	21923200.0
2021-02-05 10:00:00	NVDA	Stock	13.5655	13.6429	13.5499	13.6118	21005320.0
2021-02-05 11:00:00	NVDA	Stock	13.609	13.6695	13.5499	13.596	18523720.0
2021-02-05 12:00:00	NVDA	Stock	13.5991	13.6502	13.5875	13.6445	11056320.0
2021-02-05 13:00:00	NVDA	Stock	13.6458	13.65	13.5522	13.554	12860320.0
2021-02-05 14:00:00	NVDA	Stock	13.5532	13.6053	13.5458	13.591	11891200.0
2021-02-05 15:00:00	NVDA	Stock	13.5945	13.6045	13.5564	13.585	26599400.0
2021-02-05 16:00:00	NVDA	Stock	13.591	13.605	13.5875	13.5875	6041960.0
2021-02-05 17:00:00	NVDA	Stock	13.5985	13.5985	13.5925	13.5925	22520.0
2021-02-05 18:00:00	NVDA	Stock	13.591	13.5918	13.5752	13.5918	74800.0
2021-02-05 19:00:00	NVDA	Stock	13.5928	13.6062	13.5928	13.605	208600.0
2021-02-05 04:00:00	AMZN	Stock	167.0	167.25	167.0	167.0	20580.0
2021-02-05 05:00:00	AMZN	Stock	167.2	167.2	167.2	167.2	6860.0
2021-02-05 06:00:00	AMZN	Stock	167.128	167.128	167.128	167.128	8840.0
2021-02-05 07:00:00	AMZN	Stock	167.0025	167.1	166.9455	166.9455	36640.0

> showing 50 of 68,580 rows — these rows as CSV

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