PREVIEW / stock_1hour / 2021-05-26

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-05-26.parquet
  size:    1.4 MB
  rows:    64,676
  symbols: 2,996

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-26 04:00:00	AAPL	Stock	127.27	127.27	127.03	127.04	9411.0
2021-05-26 05:00:00	AAPL	Stock	127.07	127.29	127.04	127.14	7064.0
2021-05-26 06:00:00	AAPL	Stock	127.12	127.2	127.12	127.2	4359.0
2021-05-26 07:00:00	AAPL	Stock	127.23	127.44	127.2	127.27	73223.0
2021-05-26 08:00:00	AAPL	Stock	127.3501	127.47	127.19	127.26	254232.0
2021-05-26 09:00:00	AAPL	Stock	127.29	127.39	126.67	126.93	7147742.0
2021-05-26 10:00:00	AAPL	Stock	126.93	127.18	126.64	127.02	9361795.0
2021-05-26 11:00:00	AAPL	Stock	127.02	127.26	126.74	126.955	5262942.0
2021-05-26 12:00:00	AAPL	Stock	126.96	127.1	126.71	126.71	4552695.0
2021-05-26 13:00:00	AAPL	Stock	126.71	126.92	126.42	126.565	5122112.0
2021-05-26 14:00:00	AAPL	Stock	126.56	126.855	126.485	126.785	4712253.0
2021-05-26 15:00:00	AAPL	Stock	126.78	126.87	126.6298	126.85	7572661.0
2021-05-26 16:00:00	AAPL	Stock	126.85	126.87	126.71	126.82	5482863.0
2021-05-26 17:00:00	AAPL	Stock	126.82	126.83	126.75	126.8	29041.0
2021-05-26 18:00:00	AAPL	Stock	126.8	126.85	126.76	126.8	47271.0
2021-05-26 19:00:00	AAPL	Stock	126.8	126.8	126.7	126.7	31231.0
2021-05-26 05:00:00	MSFT	Stock	252.27	252.3	251.98	251.98	3176.0
2021-05-26 06:00:00	MSFT	Stock	252.14	252.24	252.14	252.24	888.0
2021-05-26 07:00:00	MSFT	Stock	252.28	252.87	252.25	252.42	15203.0
2021-05-26 08:00:00	MSFT	Stock	252.3498	252.86	251.091	252.31	25329.0
2021-05-26 09:00:00	MSFT	Stock	252.26	252.94	251.0	251.31	2201967.0
2021-05-26 10:00:00	MSFT	Stock	251.305	251.79	250.875	251.5392	1652877.0
2021-05-26 11:00:00	MSFT	Stock	251.56	251.77	251.05	251.35	1238397.0
2021-05-26 12:00:00	MSFT	Stock	251.35	251.64	251.25	251.3709	884662.0
2021-05-26 13:00:00	MSFT	Stock	251.37	251.48	250.81	250.9803	1151103.0
2021-05-26 14:00:00	MSFT	Stock	250.97	251.22	250.895	251.0848	864584.0
2021-05-26 15:00:00	MSFT	Stock	251.08	251.61	250.75	251.5	2206916.0
2021-05-26 16:00:00	MSFT	Stock	251.49	251.6	250.98	251.3	2609703.0
2021-05-26 17:00:00	MSFT	Stock	251.4	251.49	251.3	251.4894	2254.0
2021-05-26 18:00:00	MSFT	Stock	251.49	251.8	251.49	251.66	4389.0
2021-05-26 19:00:00	MSFT	Stock	251.54	251.55	251.32	251.55	4595.0
2021-05-26 04:00:00	NVDA	Stock	15.7678	15.7678	15.72	15.72	22680.0
2021-05-26 06:00:00	NVDA	Stock	15.7222	15.7222	15.7175	15.7175	24000.0
2021-05-26 07:00:00	NVDA	Stock	15.7178	15.7768	15.7125	15.745	518480.0
2021-05-26 08:00:00	NVDA	Stock	15.7484	15.7875	15.7188	15.7198	1553600.0
2021-05-26 09:00:00	NVDA	Stock	15.7252	15.7938	15.591	15.606	36304720.0
2021-05-26 10:00:00	NVDA	Stock	15.6092	15.7298	15.6023	15.6992	29080720.0
2021-05-26 11:00:00	NVDA	Stock	15.7022	15.703	15.5863	15.6872	21027520.0
2021-05-26 12:00:00	NVDA	Stock	15.6876	15.7122	15.6545	15.675	12562680.0
2021-05-26 13:00:00	NVDA	Stock	15.675	15.6965	15.6403	15.6545	13891080.0
2021-05-26 14:00:00	NVDA	Stock	15.6548	15.7008	15.6265	15.698	15504320.0
2021-05-26 15:00:00	NVDA	Stock	15.697	15.7118	15.6499	15.7052	35793440.0
2021-05-26 16:00:00	NVDA	Stock	15.7	15.875	15.2755	15.6358	50241480.0
2021-05-26 17:00:00	NVDA	Stock	15.6358	15.6435	15.4	15.5423	8984640.0
2021-05-26 18:00:00	NVDA	Stock	15.5363	15.6175	15.5153	15.5625	1934200.0
2021-05-26 19:00:00	NVDA	Stock	15.5575	15.57	15.5325	15.55	1358240.0
2021-05-26 06:00:00	AMZN	Stock	163.25	163.325	163.25	163.325	10000.0
2021-05-26 07:00:00	AMZN	Stock	163.3395	163.59	163.3395	163.5	20260.0
2021-05-26 08:00:00	AMZN	Stock	163.5	164.15	163.5	163.99	94360.0
2021-05-26 09:00:00	AMZN	Stock	163.75	163.9495	162.9525	163.5695	3666880.0

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

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