PREVIEW / stock_1hour / 2020-01-28

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-01-28.parquet
  size:    1.2 MB
  rows:    50,798
  symbols: 2,430

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-01-28 04:00:00	AAPL	Stock	77.8375	77.925	77.515	77.8	54512.0
2020-01-28 05:00:00	AAPL	Stock	77.895	77.9275	77.8625	77.875	21804.0
2020-01-28 06:00:00	AAPL	Stock	77.8275	77.9725	77.6375	77.9725	38320.0
2020-01-28 07:00:00	AAPL	Stock	77.9575	78.225	77.805	78.0675	547404.0
2020-01-28 08:00:00	AAPL	Stock	77.975	78.2375	77.8	78.1002	956792.0
2020-01-28 09:00:00	AAPL	Stock	78.125	78.5075	78.0475	78.2425	16842112.0
2020-01-28 10:00:00	AAPL	Stock	78.25	78.96	78.105	78.9538	19930732.0
2020-01-28 11:00:00	AAPL	Stock	78.954	79.1925	78.75	79.133	13739760.0
2020-01-28 12:00:00	AAPL	Stock	79.14	79.2925	79.0025	79.175	10207328.0
2020-01-28 13:00:00	AAPL	Stock	79.1775	79.235	79.0275	79.21	7765008.0
2020-01-28 14:00:00	AAPL	Stock	79.21	79.5925	79.2025	79.5875	11475120.0
2020-01-28 15:00:00	AAPL	Stock	79.58	79.6	79.2275	79.44	23127060.0
2020-01-28 16:00:00	AAPL	Stock	79.4225	81.975	79.365	80.4	23678484.0
2020-01-28 17:00:00	AAPL	Stock	80.4175	81.2025	79.4225	80.58	7008016.0
2020-01-28 18:00:00	AAPL	Stock	80.58	80.72	80.2675	80.45	990964.0
2020-01-28 19:00:00	AAPL	Stock	80.45	80.6475	80.4	80.625	464812.0
2020-01-28 04:00:00	MSFT	Stock	163.01	163.04	162.76	162.78	1467.0
2020-01-28 05:00:00	MSFT	Stock	162.94	163.25	162.83	162.99	5647.0
2020-01-28 06:00:00	MSFT	Stock	162.99	163.25	162.7	163.25	4099.0
2020-01-28 07:00:00	MSFT	Stock	163.27	164.06	163.27	163.85	47908.0
2020-01-28 08:00:00	MSFT	Stock	163.4	164.21	163.27	163.81	61576.0
2020-01-28 09:00:00	MSFT	Stock	164.0	164.14	163.073	163.89	2538657.0
2020-01-28 10:00:00	MSFT	Stock	163.9	165.28	163.88	165.04	2992878.0
2020-01-28 11:00:00	MSFT	Stock	165.04	165.595	164.76	165.4	2005114.0
2020-01-28 12:00:00	MSFT	Stock	165.4	165.59	165.13	165.29	1343425.0
2020-01-28 13:00:00	MSFT	Stock	165.28	165.356	164.75	165.23	1250015.0
2020-01-28 14:00:00	MSFT	Stock	165.23	165.65	165.23	165.57	1554277.0
2020-01-28 15:00:00	MSFT	Stock	165.57	165.755	165.38	165.46	3385844.0
2020-01-28 16:00:00	MSFT	Stock	165.46	166.6	165.46	166.19	4661191.0
2020-01-28 17:00:00	MSFT	Stock	166.19	166.66	165.46	166.53	1479024.0
2020-01-28 18:00:00	MSFT	Stock	166.55	166.55	165.8	166.1	64799.0
2020-01-28 19:00:00	MSFT	Stock	166.17	166.35	166.0	166.29	33774.0
2020-01-28 04:00:00	NVDA	Stock	6.031	6.031	6.0175	6.0263	146600.0
2020-01-28 05:00:00	NVDA	Stock	6.0375	6.0375	6.0375	6.0375	5040.0
2020-01-28 06:00:00	NVDA	Stock	6.03	6.0505	6.03	6.05	154800.0
2020-01-28 07:00:00	NVDA	Stock	6.041	6.086	6.0402	6.0748	816280.0
2020-01-28 08:00:00	NVDA	Stock	6.05	6.09	6.0452	6.0755	1555040.0
2020-01-28 09:00:00	NVDA	Stock	6.08	6.107	6.0178	6.0535	48922680.0
2020-01-28 10:00:00	NVDA	Stock	6.055	6.1279	6.0486	6.1224	53673640.0
2020-01-28 11:00:00	NVDA	Stock	6.1215	6.165	6.0975	6.1625	36380680.0
2020-01-28 12:00:00	NVDA	Stock	6.1628	6.184	6.1553	6.1595	28681440.0
2020-01-28 13:00:00	NVDA	Stock	6.1608	6.191	6.1458	6.1888	24132600.0
2020-01-28 14:00:00	NVDA	Stock	6.189	6.2238	6.189	6.218	31062440.0
2020-01-28 15:00:00	NVDA	Stock	6.2182	6.2318	6.1935	6.2	42188160.0
2020-01-28 16:00:00	NVDA	Stock	6.1992	6.1992	6.1398	6.1598	23715200.0
2020-01-28 17:00:00	NVDA	Stock	6.15	6.1992	6.1395	6.1492	5108440.0
2020-01-28 18:00:00	NVDA	Stock	6.1428	6.1485	6.125	6.1325	623240.0
2020-01-28 19:00:00	NVDA	Stock	6.135	6.1438	6.1313	6.133	122880.0
2020-01-28 04:00:00	AMZN	Stock	91.8	91.87	91.8	91.87	6360.0
2020-01-28 06:00:00	AMZN	Stock	91.8825	91.8825	91.8825	91.8825	2000.0

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

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