PREVIEW / stock_1hour / 2020-06-26

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-06-26.parquet
  size:    1.2 MB
  rows:    56,546
  symbols: 2,444

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-06-26 04:00:00	AAPL	Stock	90.965	91.0	90.75	91.0	22636.0
2020-06-26 05:00:00	AAPL	Stock	91.05	91.15	91.025	91.15	9540.0
2020-06-26 06:00:00	AAPL	Stock	91.15	91.2575	91.15	91.205	13648.0
2020-06-26 07:00:00	AAPL	Stock	91.295	91.48	91.2325	91.2325	130044.0
2020-06-26 08:00:00	AAPL	Stock	91.3758	91.465	90.9825	91.0725	347904.0
2020-06-26 09:00:00	AAPL	Stock	91.02	91.33	90.3825	90.5988	12998080.0
2020-06-26 10:00:00	AAPL	Stock	90.5925	90.5925	88.7625	89.355	27997544.0
2020-06-26 11:00:00	AAPL	Stock	89.355	90.35	89.303	90.22	18095620.0
2020-06-26 12:00:00	AAPL	Stock	90.225	90.24	89.21	89.7425	15886260.0
2020-06-26 13:00:00	AAPL	Stock	89.7375	90.0475	89.2525	89.255	15290080.0
2020-06-26 14:00:00	AAPL	Stock	89.2562	89.515	88.8862	89.0722	14023100.0
2020-06-26 15:00:00	AAPL	Stock	89.0575	89.475	88.255	88.4225	28946708.0
2020-06-26 16:00:00	AAPL	Stock	88.4075	88.7375	88.4075	88.435	27748492.0
2020-06-26 17:00:00	AAPL	Stock	88.435	88.5	88.375	88.4625	151300.0
2020-06-26 18:00:00	AAPL	Stock	88.47	88.5	88.4075	88.42	73740.0
2020-06-26 19:00:00	AAPL	Stock	88.425	88.45	88.4075	88.41	76948.0
2020-06-26 04:00:00	MSFT	Stock	201.0	201.0	199.82	200.0	980.0
2020-06-26 05:00:00	MSFT	Stock	200.1	200.32	200.1	200.32	548.0
2020-06-26 06:00:00	MSFT	Stock	200.6	201.0	200.5	201.0	2956.0
2020-06-26 07:00:00	MSFT	Stock	201.0	201.24	200.25	200.26	12078.0
2020-06-26 08:00:00	MSFT	Stock	201.0	201.35	199.6	199.8	40795.0
2020-06-26 09:00:00	MSFT	Stock	199.804	200.34	197.55	198.27	2827932.0
2020-06-26 10:00:00	MSFT	Stock	198.25	198.25	194.88	196.13	6712224.0
2020-06-26 11:00:00	MSFT	Stock	196.13	198.83	196.08	198.61	4589858.0
2020-06-26 12:00:00	MSFT	Stock	198.63	198.7	196.44	197.565	3310620.0
2020-06-26 13:00:00	MSFT	Stock	197.56	198.18	197.33	197.42	2423526.0
2020-06-26 14:00:00	MSFT	Stock	197.4	197.94	196.71	197.23	2930965.0
2020-06-26 15:00:00	MSFT	Stock	197.22	198.32	196.1	196.33	7999771.0
2020-06-26 16:00:00	MSFT	Stock	196.09	197.76	196.09	196.69	12155832.0
2020-06-26 17:00:00	MSFT	Stock	196.7	197.0	196.5	196.79	9196.0
2020-06-26 18:00:00	MSFT	Stock	196.62	196.8	196.39	196.39	11800.0
2020-06-26 19:00:00	MSFT	Stock	196.38	196.4	196.2	196.2	9054.0
2020-06-26 04:00:00	NVDA	Stock	9.475	9.475	9.466	9.466	17000.0
2020-06-26 06:00:00	NVDA	Stock	9.5235	9.53	9.5235	9.53	24000.0
2020-06-26 07:00:00	NVDA	Stock	9.5188	9.555	9.5175	9.5203	291800.0
2020-06-26 08:00:00	NVDA	Stock	9.5588	9.5625	9.4858	9.4875	897520.0
2020-06-26 09:00:00	NVDA	Stock	9.4938	9.5	9.3493	9.3738	51828080.0
2020-06-26 10:00:00	NVDA	Stock	9.3722	9.3722	9.161	9.178	91952800.0
2020-06-26 11:00:00	NVDA	Stock	9.183	9.2838	9.1801	9.2575	53442960.0
2020-06-26 12:00:00	NVDA	Stock	9.2588	9.2588	9.136	9.1963	52920120.0
2020-06-26 13:00:00	NVDA	Stock	9.193	9.2618	9.1875	9.2128	55896520.0
2020-06-26 14:00:00	NVDA	Stock	9.2118	9.2438	9.146	9.1712	46801720.0
2020-06-26 15:00:00	NVDA	Stock	9.17	9.205	9.125	9.161	102494720.0
2020-06-26 16:00:00	NVDA	Stock	9.155	9.1688	9.1478	9.15	14328600.0
2020-06-26 17:00:00	NVDA	Stock	9.1538	9.1562	9.15	9.1545	113880.0
2020-06-26 18:00:00	NVDA	Stock	9.1502	9.1545	9.1475	9.1475	72360.0
2020-06-26 19:00:00	NVDA	Stock	9.1475	9.15	9.1252	9.1375	267040.0
2020-06-26 04:00:00	AMZN	Stock	137.5005	137.8005	137.5005	137.8005	4000.0
2020-06-26 05:00:00	AMZN	Stock	138.058	138.058	138.058	138.058	2000.0
2020-06-26 06:00:00	AMZN	Stock	138.35	138.4875	138.3115	138.4875	10420.0

> showing 50 of 56,546 rows — these rows as CSV

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