PREVIEW / stock_1hour / 2021-01-29

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-01-29.parquet
  size:    1.5 MB
  rows:    68,117
  symbols: 2,742

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-29 04:00:00	AAPL	Stock	135.6	136.1	135.0	135.4	104096.0
2021-01-29 05:00:00	AAPL	Stock	135.32	136.03	134.76	135.96	64586.0
2021-01-29 06:00:00	AAPL	Stock	136.01	136.65	135.27	136.13	66188.0
2021-01-29 07:00:00	AAPL	Stock	136.17	136.39	135.7	135.85	424175.0
2021-01-29 08:00:00	AAPL	Stock	136.12	137.43	135.27	136.03	1163735.0
2021-01-29 09:00:00	AAPL	Stock	136.06	136.74	133.79	135.159	17101367.0
2021-01-29 10:00:00	AAPL	Stock	135.11	135.59	133.83	134.112	15985581.0
2021-01-29 11:00:00	AAPL	Stock	134.13	134.33	131.2	132.99	27165826.0
2021-01-29 12:00:00	AAPL	Stock	132.965	133.31	130.21	130.58	23253515.0
2021-01-29 13:00:00	AAPL	Stock	130.58	132.81	130.34	131.66	17974699.0
2021-01-29 14:00:00	AAPL	Stock	131.65	132.63	131.03	131.63	12880970.0
2021-01-29 15:00:00	AAPL	Stock	131.64	133.5	131.61	131.83	23753769.0
2021-01-29 16:00:00	AAPL	Stock	131.96	133.0	131.83	131.96	11109755.0
2021-01-29 17:00:00	AAPL	Stock	131.96	132.0	131.8	131.82	202911.0
2021-01-29 18:00:00	AAPL	Stock	131.84	131.92	131.7	131.8	177571.0
2021-01-29 19:00:00	AAPL	Stock	131.8	131.82	131.55	131.78	144090.0
2021-01-29 04:00:00	MSFT	Stock	235.7	235.9	233.98	234.76	29414.0
2021-01-29 05:00:00	MSFT	Stock	234.4	235.45	233.15	235.38	21999.0
2021-01-29 06:00:00	MSFT	Stock	235.12	236.55	235.0	235.29	20123.0
2021-01-29 07:00:00	MSFT	Stock	235.84	236.7	235.16	235.23	84037.0
2021-01-29 08:00:00	MSFT	Stock	236.0	238.93	234.2	236.8	173918.0
2021-01-29 09:00:00	MSFT	Stock	236.98	237.23	234.06	236.28	4335085.0
2021-01-29 10:00:00	MSFT	Stock	236.255	238.02	234.93	237.146	3385109.0
2021-01-29 11:00:00	MSFT	Stock	237.16	237.48	233.56	234.92	3293408.0
2021-01-29 12:00:00	MSFT	Stock	234.9	235.2	232.01	232.315	3613122.0
2021-01-29 13:00:00	MSFT	Stock	232.3	233.59	231.35	232.96	3080531.0
2021-01-29 14:00:00	MSFT	Stock	232.96	234.02	232.451	233.4	2655320.0
2021-01-29 15:00:00	MSFT	Stock	233.4	234.75	231.46	231.84	6333786.0
2021-01-29 16:00:00	MSFT	Stock	231.88	236.6	231.09	231.81	5690353.0
2021-01-29 17:00:00	MSFT	Stock	231.75	232.45	231.7	231.931	34439.0
2021-01-29 18:00:00	MSFT	Stock	232.0	232.14	231.6	231.76	13825.0
2021-01-29 19:00:00	MSFT	Stock	231.9	231.98	231.63	231.8	9999.0
2021-01-29 04:00:00	NVDA	Stock	12.97	12.97	12.8995	12.9	65320.0
2021-01-29 06:00:00	NVDA	Stock	12.925	12.9523	12.925	12.952	33120.0
2021-01-29 07:00:00	NVDA	Stock	12.952	12.9845	12.9498	12.9625	420560.0
2021-01-29 08:00:00	NVDA	Stock	12.954	13.075	12.925	13.0628	1122640.0
2021-01-29 09:00:00	NVDA	Stock	13.025	13.1	12.9115	13.0228	28411280.0
2021-01-29 10:00:00	NVDA	Stock	13.028	13.3348	12.9702	13.1591	47608640.0
2021-01-29 11:00:00	NVDA	Stock	13.1592	13.1792	13.0125	13.1088	20972720.0
2021-01-29 12:00:00	NVDA	Stock	13.1058	13.1545	12.9212	12.96	27354560.0
2021-01-29 13:00:00	NVDA	Stock	12.9575	13.0388	12.9195	12.9607	19495920.0
2021-01-29 14:00:00	NVDA	Stock	12.9542	13.0158	12.9245	12.9705	14869800.0
2021-01-29 15:00:00	NVDA	Stock	12.9743	13.1258	12.9632	12.9758	39218360.0
2021-01-29 16:00:00	NVDA	Stock	12.9898	13.127	12.9268	12.9417	23210600.0
2021-01-29 17:00:00	NVDA	Stock	12.95	12.9725	12.9417	12.9623	77640.0
2021-01-29 18:00:00	NVDA	Stock	12.95	12.9623	12.95	12.96	148680.0
2021-01-29 19:00:00	NVDA	Stock	12.9505	12.9725	12.9438	12.9438	138680.0
2021-01-29 04:00:00	AMZN	Stock	160.5	160.5	159.9	160.0	32600.0
2021-01-29 05:00:00	AMZN	Stock	159.65	160.7675	159.65	160.7675	6600.0
2021-01-29 06:00:00	AMZN	Stock	161.3895	161.3895	161.3895	161.3895	5820.0

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

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