PREVIEW / stock_1hour / 2021-05-17

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-05-17.parquet
  size:    1.4 MB
  rows:    64,762
  symbols: 2,979

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
2021-05-17 04:00:00	AAPL	Stock	126.96	127.23	126.81	127.16	9180.0
2021-05-17 05:00:00	AAPL	Stock	127.1	127.14	126.95	127.0	14059.0
2021-05-17 06:00:00	AAPL	Stock	126.93	126.95	126.69	126.75	5981.0
2021-05-17 07:00:00	AAPL	Stock	126.84	126.9	126.65	126.73	178021.0
2021-05-17 08:00:00	AAPL	Stock	126.74	127.45	126.65	126.91	1508381.0
2021-05-17 09:00:00	AAPL	Stock	126.89	127.25	126.01	126.0301	9413627.0
2021-05-17 10:00:00	AAPL	Stock	126.04	126.41	125.46	125.99	11207638.0
2021-05-17 11:00:00	AAPL	Stock	125.98	126.13	125.61	125.695	6419722.0
2021-05-17 12:00:00	AAPL	Stock	125.6999	125.9	125.47	125.59	5678560.0
2021-05-17 13:00:00	AAPL	Stock	125.59	125.705	125.17	125.4001	5835141.0
2021-05-17 14:00:00	AAPL	Stock	125.4069	125.6199	125.23	125.595	5486339.0
2021-05-17 15:00:00	AAPL	Stock	125.59	126.27	125.41	126.27	10478595.0
2021-05-17 16:00:00	AAPL	Stock	126.24	126.27	126.01	126.14	10724134.0
2021-05-17 17:00:00	AAPL	Stock	126.18	126.2	126.07	126.16	51041.0
2021-05-17 18:00:00	AAPL	Stock	126.19	126.2	126.08	126.12	27507.0
2021-05-17 19:00:00	AAPL	Stock	126.09	126.31	126.07	126.3	50079.0
2021-05-17 04:00:00	MSFT	Stock	248.0	248.39	248.0	248.3	1740.0
2021-05-17 05:00:00	MSFT	Stock	248.6	248.6	247.85	247.85	4053.0
2021-05-17 06:00:00	MSFT	Stock	247.72	247.74	247.5	247.51	3021.0
2021-05-17 07:00:00	MSFT	Stock	247.67	247.74	246.85	246.99	19630.0
2021-05-17 08:00:00	MSFT	Stock	247.5	248.15	246.6	247.03	165678.0
2021-05-17 09:00:00	MSFT	Stock	247.01	247.3	245.0	245.53	1952279.0
2021-05-17 10:00:00	MSFT	Stock	245.45	245.66	244.04	245.14	2502021.0
2021-05-17 11:00:00	MSFT	Stock	245.13	245.5359	244.04	244.35	1793281.0
2021-05-17 12:00:00	MSFT	Stock	244.35	244.98	244.16	244.39	1235851.0
2021-05-17 13:00:00	MSFT	Stock	244.37	244.52	243.52	243.76	1666801.0
2021-05-17 14:00:00	MSFT	Stock	243.74	244.21	243.56	244.21	1558436.0
2021-05-17 15:00:00	MSFT	Stock	244.21	245.23	244.13	245.18	2804534.0
2021-05-17 16:00:00	MSFT	Stock	245.18	245.46	244.8	245.23	4666158.0
2021-05-17 17:00:00	MSFT	Stock	245.21	245.34	245.21	245.21	3523.0
2021-05-17 18:00:00	MSFT	Stock	245.3	245.32	245.12	245.18	2704.0
2021-05-17 19:00:00	MSFT	Stock	245.12	245.6	244.81	245.5	18718.0
2021-05-17 05:00:00	NVDA	Stock	14.2	14.2002	14.2	14.2	26040.0
2021-05-17 06:00:00	NVDA	Stock	14.175	14.178	14.175	14.175	145960.0
2021-05-17 07:00:00	NVDA	Stock	14.1822	14.1875	14.125	14.1325	229160.0
2021-05-17 08:00:00	NVDA	Stock	14.195	14.195	14.125	14.125	708240.0
2021-05-17 09:00:00	NVDA	Stock	14.128	14.175	13.952	13.9645	24650680.0
2021-05-17 10:00:00	NVDA	Stock	13.956	14.1288	13.9083	14.043	21677760.0
2021-05-17 11:00:00	NVDA	Stock	14.0462	14.0688	13.9428	13.9508	12806320.0
2021-05-17 12:00:00	NVDA	Stock	13.947	14.0047	13.917	13.944	13250880.0
2021-05-17 13:00:00	NVDA	Stock	13.9402	13.9682	13.8535	13.9268	13145080.0
2021-05-17 14:00:00	NVDA	Stock	13.9302	14.081	13.9152	14.0718	12488680.0
2021-05-17 15:00:00	NVDA	Stock	14.0712	14.1692	14.0348	14.1692	20795840.0
2021-05-17 16:00:00	NVDA	Stock	14.1655	14.1825	14.1655	14.175	17473960.0
2021-05-17 17:00:00	NVDA	Stock	14.1798	14.1812	14.1658	14.1658	109760.0
2021-05-17 18:00:00	NVDA	Stock	14.175	14.175	14.166	14.166	101600.0
2021-05-17 19:00:00	NVDA	Stock	14.1655	14.1845	14.1655	14.1812	129720.0
2021-05-17 04:00:00	AMZN	Stock	161.2	161.2	161.1	161.145	10240.0
2021-05-17 05:00:00	AMZN	Stock	161.5	161.7555	161.5	161.75	25260.0
2021-05-17 06:00:00	AMZN	Stock	161.425	161.425	161.425	161.425	2000.0

> showing 50 of 64,762 rows — these rows as CSV

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