PREVIEW / stock_1hour / 2020-04-09

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-04-09.parquet
  size:    1.2 MB
  rows:    55,227
  symbols: 2,416

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-04-09 04:00:00	AAPL	Stock	67.1375	67.225	66.6	66.6	43808.0
2020-04-09 05:00:00	AAPL	Stock	66.625	66.625	66.1	66.1375	17020.0
2020-04-09 06:00:00	AAPL	Stock	66.2225	66.2875	66.0	66.075	31068.0
2020-04-09 07:00:00	AAPL	Stock	66.105	66.42	65.85	66.0175	211756.0
2020-04-09 08:00:00	AAPL	Stock	66.1745	67.3225	65.5888	67.125	1160592.0
2020-04-09 09:00:00	AAPL	Stock	67.1	67.575	66.865	67.4405	20314052.0
2020-04-09 10:00:00	AAPL	Stock	67.4425	67.4602	66.2	66.595	27109368.0
2020-04-09 11:00:00	AAPL	Stock	66.6	66.9375	66.175	66.7925	16106780.0
2020-04-09 12:00:00	AAPL	Stock	66.7925	66.9175	66.425	66.78	10807324.0
2020-04-09 13:00:00	AAPL	Stock	66.785	66.95	66.555	66.7475	10031440.0
2020-04-09 14:00:00	AAPL	Stock	66.75	66.915	66.3225	66.5675	14228964.0
2020-04-09 15:00:00	AAPL	Stock	66.57	67.22	66.425	66.99	25059592.0
2020-04-09 16:00:00	AAPL	Stock	66.9975	67.125	66.7392	67.125	9531796.0
2020-04-09 17:00:00	AAPL	Stock	67.15	67.205	67.1075	67.175	92236.0
2020-04-09 18:00:00	AAPL	Stock	67.175	67.3675	67.175	67.35	115188.0
2020-04-09 19:00:00	AAPL	Stock	67.35	67.3925	67.265	67.2875	125752.0
2020-04-09 04:00:00	MSFT	Stock	166.43	166.84	164.6	165.65	21042.0
2020-04-09 05:00:00	MSFT	Stock	165.65	165.65	164.1	164.21	5706.0
2020-04-09 06:00:00	MSFT	Stock	164.44	164.68	164.04	164.04	7517.0
2020-04-09 07:00:00	MSFT	Stock	164.4	165.3	163.75	164.0	51253.0
2020-04-09 08:00:00	MSFT	Stock	165.298	166.97	163.01	166.62	266216.0
2020-04-09 09:00:00	MSFT	Stock	166.5	167.4	164.88	166.5	6250119.0
2020-04-09 10:00:00	MSFT	Stock	166.48	166.52	163.33	165.148	9666894.0
2020-04-09 11:00:00	MSFT	Stock	165.16	165.65	163.8	164.915	4448766.0
2020-04-09 12:00:00	MSFT	Stock	164.92	165.455	164.33	165.225	3271025.0
2020-04-09 13:00:00	MSFT	Stock	165.24	165.35	164.52	164.755	3223892.0
2020-04-09 14:00:00	MSFT	Stock	164.755	164.95	163.88	164.48	4001380.0
2020-04-09 15:00:00	MSFT	Stock	164.49	165.44	163.92	165.19	8192987.0
2020-04-09 16:00:00	MSFT	Stock	165.21	165.3	164.763	165.08	4278604.0
2020-04-09 17:00:00	MSFT	Stock	165.1	165.25	165.0	165.21	35967.0
2020-04-09 18:00:00	MSFT	Stock	165.21	165.43	165.14	165.3	17164.0
2020-04-09 19:00:00	MSFT	Stock	165.3	165.5	165.3	165.47	24087.0
2020-04-09 04:00:00	NVDA	Stock	6.7178	6.7178	6.675	6.675	46480.0
2020-04-09 05:00:00	NVDA	Stock	6.675	6.6848	6.65	6.65	52760.0
2020-04-09 06:00:00	NVDA	Stock	6.6012	6.625	6.6012	6.625	58280.0
2020-04-09 07:00:00	NVDA	Stock	6.65	6.68	6.6128	6.6325	775160.0
2020-04-09 08:00:00	NVDA	Stock	6.64	6.775	6.575	6.7565	4593000.0
2020-04-09 09:00:00	NVDA	Stock	6.775	6.8608	6.7125	6.75	62374280.0
2020-04-09 10:00:00	NVDA	Stock	6.7502	6.7505	6.5472	6.6142	98364920.0
2020-04-09 11:00:00	NVDA	Stock	6.6139	6.6695	6.5445	6.6395	41816720.0
2020-04-09 12:00:00	NVDA	Stock	6.6435	6.675	6.5933	6.6532	36961120.0
2020-04-09 13:00:00	NVDA	Stock	6.6562	6.6955	6.6232	6.6461	39440600.0
2020-04-09 14:00:00	NVDA	Stock	6.6425	6.6477	6.5105	6.542	55148000.0
2020-04-09 15:00:00	NVDA	Stock	6.5422	6.5888	6.5153	6.5718	72326400.0
2020-04-09 16:00:00	NVDA	Stock	6.5738	6.6012	6.5672	6.5835	15518720.0
2020-04-09 17:00:00	NVDA	Stock	6.5835	6.5875	6.5775	6.5875	256960.0
2020-04-09 18:00:00	NVDA	Stock	6.5775	6.595	6.5775	6.5945	211800.0
2020-04-09 19:00:00	NVDA	Stock	6.5945	6.61	6.5908	6.6062	360880.0
2020-04-09 06:00:00	AMZN	Stock	101.651	101.651	101.651	101.651	2000.0
2020-04-09 07:00:00	AMZN	Stock	101.9	102.192	101.45	101.5175	62000.0

> showing 50 of 55,227 rows — these rows as CSV

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