PREVIEW / stock_1hour / 2020-07-30

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-07-30.parquet
  size:    1.3 MB
  rows:    57,830
  symbols: 2,436

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-07-30 04:00:00	AAPL	Stock	94.125	94.25	93.775	93.775	9092.0
2020-07-30 05:00:00	AAPL	Stock	93.775	94.5	93.775	94.395	53024.0
2020-07-30 06:00:00	AAPL	Stock	94.375	94.375	93.625	93.795	66964.0
2020-07-30 07:00:00	AAPL	Stock	93.915	94.4	93.795	94.25	423764.0
2020-07-30 08:00:00	AAPL	Stock	94.17	94.5	93.8125	93.875	647264.0
2020-07-30 09:00:00	AAPL	Stock	93.8825	95.045	93.7275	93.99	12074788.0
2020-07-30 10:00:00	AAPL	Stock	93.9825	94.675	93.7675	94.6038	13109004.0
2020-07-30 11:00:00	AAPL	Stock	94.5875	95.3675	94.5025	95.1963	11543928.0
2020-07-30 12:00:00	AAPL	Stock	95.1975	95.965	95.1975	95.4775	13148164.0
2020-07-30 13:00:00	AAPL	Stock	95.4725	95.7625	95.225	95.715	9673328.0
2020-07-30 14:00:00	AAPL	Stock	95.715	96.1375	95.435	96.04	11373572.0
2020-07-30 15:00:00	AAPL	Stock	96.035	96.2975	95.6225	96.22	19833904.0
2020-07-30 16:00:00	AAPL	Stock	96.19	101.9625	96.0	100.725	20787516.0
2020-07-30 17:00:00	AAPL	Stock	100.725	102.2375	100.65	102.0875	6118692.0
2020-07-30 18:00:00	AAPL	Stock	102.1125	102.21	101.625	101.9375	1515860.0
2020-07-30 19:00:00	AAPL	Stock	101.9375	102.4	101.8375	102.3875	1102664.0
2020-07-30 04:00:00	MSFT	Stock	202.44	202.44	201.1	201.1	4002.0
2020-07-30 05:00:00	MSFT	Stock	201.1	202.25	201.0	202.25	4323.0
2020-07-30 06:00:00	MSFT	Stock	202.1	202.1	200.15	200.91	17240.0
2020-07-30 07:00:00	MSFT	Stock	200.9	202.44	200.9	202.13	98103.0
2020-07-30 08:00:00	MSFT	Stock	201.45	204.57	200.58	200.756	121097.0
2020-07-30 09:00:00	MSFT	Stock	200.85	202.14	199.78	200.02	3884425.0
2020-07-30 10:00:00	MSFT	Stock	200.06	201.27	199.57	201.23	4011399.0
2020-07-30 11:00:00	MSFT	Stock	201.2	203.07	200.94	202.88	2681290.0
2020-07-30 12:00:00	MSFT	Stock	202.87	204.01	202.62	203.457	2149110.0
2020-07-30 13:00:00	MSFT	Stock	203.45	204.11	203.217	203.92	1386146.0
2020-07-30 14:00:00	MSFT	Stock	203.9	204.1	203.29	203.896	1413796.0
2020-07-30 15:00:00	MSFT	Stock	203.92	204.46	203.34	203.89	2708200.0
2020-07-30 16:00:00	MSFT	Stock	203.9	205.5	203.31	204.65	1626128.0
2020-07-30 17:00:00	MSFT	Stock	204.65	205.3	204.6	205.3	78872.0
2020-07-30 18:00:00	MSFT	Stock	205.3	205.5	204.4	204.6	54579.0
2020-07-30 19:00:00	MSFT	Stock	204.5	205.22	204.4	205.2	43538.0
2020-07-30 04:00:00	NVDA	Stock	10.375	10.375	10.375	10.375	13520.0
2020-07-30 05:00:00	NVDA	Stock	10.3495	10.3625	10.3495	10.3625	32920.0
2020-07-30 06:00:00	NVDA	Stock	10.3148	10.3148	10.3148	10.3148	4200.0
2020-07-30 07:00:00	NVDA	Stock	10.3325	10.3998	10.3152	10.376	474520.0
2020-07-30 08:00:00	NVDA	Stock	10.3625	10.3925	10.3252	10.34	798960.0
2020-07-30 09:00:00	NVDA	Stock	10.325	10.4686	10.3036	10.3233	41109000.0
2020-07-30 10:00:00	NVDA	Stock	10.326	10.3975	10.2953	10.3935	52940480.0
2020-07-30 11:00:00	NVDA	Stock	10.3941	10.5402	10.3782	10.5165	39708440.0
2020-07-30 12:00:00	NVDA	Stock	10.519	10.5573	10.5075	10.5356	20157080.0
2020-07-30 13:00:00	NVDA	Stock	10.5365	10.6168	10.5258	10.6161	30750320.0
2020-07-30 14:00:00	NVDA	Stock	10.615	10.6231	10.5488	10.6149	29193240.0
2020-07-30 15:00:00	NVDA	Stock	10.6159	10.623	10.569	10.6108	39364720.0
2020-07-30 16:00:00	NVDA	Stock	10.614	10.7	10.6125	10.7	6143200.0
2020-07-30 17:00:00	NVDA	Stock	10.7	10.7125	10.6905	10.7115	1613960.0
2020-07-30 18:00:00	NVDA	Stock	10.7115	10.725	10.7	10.7098	638240.0
2020-07-30 19:00:00	NVDA	Stock	10.71	10.7352	10.7075	10.7352	507240.0
2020-07-30 04:00:00	AMZN	Stock	150.777	150.777	150.526	150.526	9420.0
2020-07-30 05:00:00	AMZN	Stock	150.5	150.7	150.5	150.7	4100.0

> showing 50 of 57,830 rows — these rows as CSV

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