PREVIEW / stock_1hour / 2021-05-18

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-05-18.parquet
  size:    1.4 MB
  rows:    64,886
  symbols: 2,963

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-18 04:00:00	AAPL	Stock	126.99	127.51	126.94	127.38	16873.0
2021-05-18 05:00:00	AAPL	Stock	127.37	127.48	127.25	127.32	16667.0
2021-05-18 06:00:00	AAPL	Stock	127.38	127.5	127.1	127.15	38431.0
2021-05-18 07:00:00	AAPL	Stock	127.24	127.24	126.82	126.95	100934.0
2021-05-18 08:00:00	AAPL	Stock	126.95	127.19	126.61	126.84	258365.0
2021-05-18 09:00:00	AAPL	Stock	126.84	126.99	125.91	126.54	8474828.0
2021-05-18 10:00:00	AAPL	Stock	126.535	126.8154	126.2846	126.675	7625510.0
2021-05-18 11:00:00	AAPL	Stock	126.68	126.8699	126.21	126.275	6127893.0
2021-05-18 12:00:00	AAPL	Stock	126.2799	126.49	126.1841	126.27	4766631.0
2021-05-18 13:00:00	AAPL	Stock	126.27	126.37	126.02	126.04	4054168.0
2021-05-18 14:00:00	AAPL	Stock	126.03	126.1499	125.38	125.6382	5561307.0
2021-05-18 15:00:00	AAPL	Stock	125.635	125.79	124.78	124.85	10614185.0
2021-05-18 16:00:00	AAPL	Stock	124.85	125.05	124.55	124.67	6359030.0
2021-05-18 17:00:00	AAPL	Stock	124.66	124.69	124.6	124.64	59376.0
2021-05-18 18:00:00	AAPL	Stock	124.63	124.81	124.6	124.67	66692.0
2021-05-18 19:00:00	AAPL	Stock	124.62	124.85	124.4	124.4	144088.0
2021-05-18 04:00:00	MSFT	Stock	247.1	247.1	246.6	246.9	3376.0
2021-05-18 05:00:00	MSFT	Stock	246.66	247.21	246.66	247.1	6306.0
2021-05-18 06:00:00	MSFT	Stock	247.17	247.17	246.7	246.74	2042.0
2021-05-18 07:00:00	MSFT	Stock	246.76	246.76	246.1	246.25	16606.0
2021-05-18 08:00:00	MSFT	Stock	246.7	246.99	245.89	246.01	48055.0
2021-05-18 09:00:00	MSFT	Stock	245.96	246.41	244.94	245.3181	1748782.0
2021-05-18 10:00:00	MSFT	Stock	245.3	245.94	244.87	245.65	1734039.0
2021-05-18 11:00:00	MSFT	Stock	245.69	246.12	245.0	245.0859	1515516.0
2021-05-18 12:00:00	MSFT	Stock	245.08	245.9299	245.03	245.8	1039401.0
2021-05-18 13:00:00	MSFT	Stock	245.81	245.94	245.105	245.115	1254425.0
2021-05-18 14:00:00	MSFT	Stock	245.115	245.33	243.77	244.31	1700257.0
2021-05-18 15:00:00	MSFT	Stock	244.32	244.87	242.9	243.03	3356421.0
2021-05-18 16:00:00	MSFT	Stock	243.08	243.2999	242.51	242.73	2501418.0
2021-05-18 17:00:00	MSFT	Stock	242.65	242.99	242.65	242.83	7770.0
2021-05-18 18:00:00	MSFT	Stock	242.84	243.05	242.71	242.95	4900.0
2021-05-18 19:00:00	MSFT	Stock	242.92	243.35	242.5	242.53	14739.0
2021-05-18 04:00:00	NVDA	Stock	14.3248	14.3248	14.3248	14.3248	11120.0
2021-05-18 06:00:00	NVDA	Stock	14.3535	14.375	14.3252	14.3378	38800.0
2021-05-18 07:00:00	NVDA	Stock	14.329	14.3525	14.2755	14.3	290080.0
2021-05-18 08:00:00	NVDA	Stock	14.35	14.3613	14.2562	14.29	363280.0
2021-05-18 09:00:00	NVDA	Stock	14.2773	14.2952	14.1581	14.2596	17697800.0
2021-05-18 10:00:00	NVDA	Stock	14.2599	14.4042	14.2388	14.32	22355640.0
2021-05-18 11:00:00	NVDA	Stock	14.3262	14.3465	14.1806	14.198	14867720.0
2021-05-18 12:00:00	NVDA	Stock	14.2001	14.275	14.1922	14.227	8854840.0
2021-05-18 13:00:00	NVDA	Stock	14.2285	14.2598	14.1792	14.1829	7705560.0
2021-05-18 14:00:00	NVDA	Stock	14.1852	14.2082	14.0305	14.106	14334840.0
2021-05-18 15:00:00	NVDA	Stock	14.1023	14.1525	14.004	14.0143	20615960.0
2021-05-18 16:00:00	NVDA	Stock	14.0158	14.044	13.9728	13.9738	10959800.0
2021-05-18 17:00:00	NVDA	Stock	13.9785	13.9875	13.972	13.9875	46720.0
2021-05-18 18:00:00	NVDA	Stock	13.9888	14.0	13.9888	13.99	62360.0
2021-05-18 19:00:00	NVDA	Stock	13.9908	14.001	13.978	13.978	281160.0
2021-05-18 04:00:00	AMZN	Stock	164.5	164.5	164.3265	164.3265	6000.0
2021-05-18 06:00:00	AMZN	Stock	164.747	164.8565	164.747	164.85	6000.0
2021-05-18 07:00:00	AMZN	Stock	164.8055	165.0	164.601	164.7	82220.0

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

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