PREVIEW / stock_1hour / 2019-08-23

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-08-23.parquet
  size:    1.1 MB
  rows:    50,265
  symbols: 2,543

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
2019-08-23 04:00:00	AAPL	Stock	53.2875	53.5425	53.2875	53.535	17640.0
2019-08-23 05:00:00	AAPL	Stock	53.5025	53.53	53.375	53.4	16772.0
2019-08-23 06:00:00	AAPL	Stock	53.4325	53.4425	53.14	53.24	27700.0
2019-08-23 07:00:00	AAPL	Stock	53.3075	53.4	53.245	53.3625	69652.0
2019-08-23 08:00:00	AAPL	Stock	53.335	53.425	52.25	52.4125	1304472.0
2019-08-23 09:00:00	AAPL	Stock	52.3875	52.585	52.175	52.425	13218936.0
2019-08-23 10:00:00	AAPL	Stock	52.4275	53.0128	52.34	52.78	17258580.0
2019-08-23 11:00:00	AAPL	Stock	52.785	52.8575	50.88	50.9538	36097692.0
2019-08-23 12:00:00	AAPL	Stock	50.9575	51.1925	50.8525	51.0138	15960308.0
2019-08-23 13:00:00	AAPL	Stock	51.0112	51.0525	50.61	50.81	15649140.0
2019-08-23 14:00:00	AAPL	Stock	50.8075	50.8075	50.4775	50.63	13342600.0
2019-08-23 15:00:00	AAPL	Stock	50.625	50.9095	50.25	50.6575	28617728.0
2019-08-23 16:00:00	AAPL	Stock	50.25	50.8875	50.25	50.655	16990036.0
2019-08-23 17:00:00	AAPL	Stock	50.7	50.7	50.325	50.3575	467296.0
2019-08-23 18:00:00	AAPL	Stock	50.375	50.495	50.325	50.4375	127964.0
2019-08-23 19:00:00	AAPL	Stock	50.4425	50.4675	50.375	50.45	96412.0
2019-08-23 04:00:00	MSFT	Stock	138.31	138.7	138.27	138.7	819.0
2019-08-23 05:00:00	MSFT	Stock	138.58	138.68	138.58	138.67	425.0
2019-08-23 06:00:00	MSFT	Stock	138.65	138.65	138.25	138.25	2054.0
2019-08-23 07:00:00	MSFT	Stock	138.26	138.6	138.26	138.3	9481.0
2019-08-23 08:00:00	MSFT	Stock	138.35	138.592	136.54	137.01	50475.0
2019-08-23 09:00:00	MSFT	Stock	137.0	137.78	136.33	136.65	2099945.0
2019-08-23 10:00:00	MSFT	Stock	136.65	138.35	136.39	137.85	3235718.0
2019-08-23 11:00:00	MSFT	Stock	137.86	137.99	134.3	134.31	5226351.0
2019-08-23 12:00:00	MSFT	Stock	134.32	134.52	133.78	134.23	3786574.0
2019-08-23 13:00:00	MSFT	Stock	134.23	134.23	133.13	134.1	3822732.0
2019-08-23 14:00:00	MSFT	Stock	134.09	134.09	133.392	133.68	1955548.0
2019-08-23 15:00:00	MSFT	Stock	133.68	135.3	132.8	133.4	7702593.0
2019-08-23 16:00:00	MSFT	Stock	133.39	134.09	133.39	133.86	5799704.0
2019-08-23 17:00:00	MSFT	Stock	133.85	133.89	133.25	133.4	65738.0
2019-08-23 18:00:00	MSFT	Stock	133.6	133.6	133.35	133.51	3099.0
2019-08-23 19:00:00	MSFT	Stock	133.6	133.69	133.41	133.41	2572.0
2019-08-23 04:00:00	NVDA	Stock	4.3075	4.3075	4.3075	4.3075	4200.0
2019-08-23 06:00:00	NVDA	Stock	4.3102	4.3102	4.3102	4.3102	8000.0
2019-08-23 07:00:00	NVDA	Stock	4.3048	4.3102	4.3025	4.3075	180560.0
2019-08-23 08:00:00	NVDA	Stock	4.3047	4.3135	4.2078	4.225	3910440.0
2019-08-23 09:00:00	NVDA	Stock	4.225	4.2325	4.16	4.2014	71921960.0
2019-08-23 10:00:00	NVDA	Stock	4.203	4.2648	4.1805	4.229	73273400.0
2019-08-23 11:00:00	NVDA	Stock	4.2312	4.2342	4.0585	4.0594	124711880.0
2019-08-23 12:00:00	NVDA	Stock	4.0602	4.098	4.0513	4.0806	51560200.0
2019-08-23 13:00:00	NVDA	Stock	4.0803	4.0918	4.0606	4.084	48563760.0
2019-08-23 14:00:00	NVDA	Stock	4.083	4.0836	4.054	4.075	35691080.0
2019-08-23 15:00:00	NVDA	Stock	4.0748	4.0988	4.041	4.063	103349680.0
2019-08-23 16:00:00	NVDA	Stock	4.061	4.1176	4.061	4.066	9504160.0
2019-08-23 17:00:00	NVDA	Stock	4.064	4.0662	4.0305	4.0325	1682440.0
2019-08-23 18:00:00	NVDA	Stock	4.0325	4.038	4.0325	4.0362	595720.0
2019-08-23 19:00:00	NVDA	Stock	4.0355	4.0355	4.0052	4.013	851240.0
2019-08-23 04:00:00	AMZN	Stock	90.7215	90.7215	90.7	90.7	6000.0
2019-08-23 06:00:00	AMZN	Stock	90.523	90.523	90.523	90.523	6620.0
2019-08-23 07:00:00	AMZN	Stock	90.5	90.625	90.455	90.5505	43980.0

> showing 50 of 50,265 rows — these rows as CSV

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