PREVIEW / stock_1hour / 2021-01-22

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-01-22.parquet
  size:    1.4 MB
  rows:    66,500
  symbols: 2,713

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-22 04:00:00	AAPL	Stock	135.84	135.87	135.2	135.45	89502.0
2021-01-22 05:00:00	AAPL	Stock	135.45	136.08	135.35	135.66	49734.0
2021-01-22 06:00:00	AAPL	Stock	135.73	136.08	135.5	136.07	76215.0
2021-01-22 07:00:00	AAPL	Stock	136.0	136.3	135.57	135.88	365001.0
2021-01-22 08:00:00	AAPL	Stock	136.2	136.3	135.4	135.93	630821.0
2021-01-22 09:00:00	AAPL	Stock	135.96	137.58	135.02	137.34	16979983.0
2021-01-22 10:00:00	AAPL	Stock	137.37	137.66	136.02	136.88	14887867.0
2021-01-22 11:00:00	AAPL	Stock	136.87	137.52	136.8	137.34	10888173.0
2021-01-22 12:00:00	AAPL	Stock	137.35	138.18	137.2	137.975	10768394.0
2021-01-22 13:00:00	AAPL	Stock	137.973	138.32	137.74	137.999	7468645.0
2021-01-22 14:00:00	AAPL	Stock	137.999	139.19	137.88	139.09	9999511.0
2021-01-22 15:00:00	AAPL	Stock	139.095	139.85	138.63	138.97	19221991.0
2021-01-22 16:00:00	AAPL	Stock	138.98	139.5	138.92	139.39	6926233.0
2021-01-22 17:00:00	AAPL	Stock	139.38	139.98	139.11	139.95	568411.0
2021-01-22 18:00:00	AAPL	Stock	139.95	140.23	139.89	140.21	302674.0
2021-01-22 19:00:00	AAPL	Stock	140.23	140.4	140.17	140.36	262580.0
2021-01-22 04:00:00	MSFT	Stock	224.87	225.3	224.23	224.82	10220.0
2021-01-22 05:00:00	MSFT	Stock	224.53	224.93	224.42	224.5	8036.0
2021-01-22 06:00:00	MSFT	Stock	224.5	225.3	224.5	225.3	7534.0
2021-01-22 07:00:00	MSFT	Stock	225.02	225.81	224.78	225.8	35182.0
2021-01-22 08:00:00	MSFT	Stock	224.9	226.26	224.41	225.79	79518.0
2021-01-22 09:00:00	MSFT	Stock	225.72	229.32	225.65	229.28	4052388.0
2021-01-22 10:00:00	MSFT	Stock	229.28	230.07	228.73	229.752	4890677.0
2021-01-22 11:00:00	MSFT	Stock	229.77	229.79	227.67	228.055	3070580.0
2021-01-22 12:00:00	MSFT	Stock	228.06	228.53	227.45	227.459	1972996.0
2021-01-22 13:00:00	MSFT	Stock	227.48	227.73	227.17	227.21	1434692.0
2021-01-22 14:00:00	MSFT	Stock	227.205	227.64	227.02	227.46	1689468.0
2021-01-22 15:00:00	MSFT	Stock	227.47	227.47	225.8	225.84	3360023.0
2021-01-22 16:00:00	MSFT	Stock	225.95	226.47	225.916	226.44	4112316.0
2021-01-22 17:00:00	MSFT	Stock	226.45	226.95	226.25	226.95	21324.0
2021-01-22 18:00:00	MSFT	Stock	226.95	226.97	226.54	226.55	16049.0
2021-01-22 19:00:00	MSFT	Stock	226.56	226.95	226.45	226.7	22449.0
2021-01-22 04:00:00	NVDA	Stock	13.7325	13.775	13.6925	13.769	207640.0
2021-01-22 05:00:00	NVDA	Stock	13.7875	13.788	13.725	13.753	134000.0
2021-01-22 06:00:00	NVDA	Stock	13.7745	13.78	13.7	13.7055	404600.0
2021-01-22 07:00:00	NVDA	Stock	13.7363	13.75	13.6802	13.7125	914080.0
2021-01-22 08:00:00	NVDA	Stock	13.75	13.7598	13.675	13.7598	999560.0
2021-01-22 09:00:00	NVDA	Stock	13.7488	13.7875	13.6273	13.765	46861120.0
2021-01-22 10:00:00	NVDA	Stock	13.7688	13.7878	13.6625	13.7155	35347440.0
2021-01-22 11:00:00	NVDA	Stock	13.715	13.75	13.675	13.7268	15560840.0
2021-01-22 12:00:00	NVDA	Stock	13.73	13.748	13.6932	13.7174	14975840.0
2021-01-22 13:00:00	NVDA	Stock	13.7188	13.8358	13.7148	13.768	23456400.0
2021-01-22 14:00:00	NVDA	Stock	13.765	13.8312	13.7485	13.793	13681800.0
2021-01-22 15:00:00	NVDA	Stock	13.7936	13.8417	13.7072	13.7125	35192000.0
2021-01-22 16:00:00	NVDA	Stock	13.7125	13.7146	13.6938	13.6938	2615480.0
2021-01-22 17:00:00	NVDA	Stock	13.7	13.7068	13.6955	13.7038	57760.0
2021-01-22 18:00:00	NVDA	Stock	13.7038	13.7125	13.7038	13.7122	323560.0
2021-01-22 19:00:00	NVDA	Stock	13.713	13.7218	13.7113	13.7218	70080.0
2021-01-22 04:00:00	AMZN	Stock	164.2005	164.2005	164.0	164.001	10720.0
2021-01-22 06:00:00	AMZN	Stock	164.0	164.0	164.0	164.0	4000.0

> showing 50 of 66,500 rows — these rows as CSV

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