PREVIEW / stock_1hour / 2021-06-11

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-06-11.parquet
  size:    1.4 MB
  rows:    65,582
  symbols: 2,972

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-06-11 04:00:00	AAPL	Stock	126.33	126.59	126.33	126.56	8751.0
2021-06-11 05:00:00	AAPL	Stock	126.54	126.58	126.43	126.47	4659.0
2021-06-11 06:00:00	AAPL	Stock	126.46	126.68	126.36	126.68	10611.0
2021-06-11 07:00:00	AAPL	Stock	126.69	126.75	126.5	126.6	156339.0
2021-06-11 08:00:00	AAPL	Stock	126.59	126.74	126.425	126.5499	338723.0
2021-06-11 09:00:00	AAPL	Stock	126.55	127.12	126.1	126.9033	9015136.0
2021-06-11 10:00:00	AAPL	Stock	126.9	127.275	126.58	126.7092	8254438.0
2021-06-11 11:00:00	AAPL	Stock	126.7	127.165	126.515	127.08	5537279.0
2021-06-11 12:00:00	AAPL	Stock	127.0701	127.255	126.91	127.0619	4441292.0
2021-06-11 13:00:00	AAPL	Stock	127.07	127.41	126.91	127.3348	3894551.0
2021-06-11 14:00:00	AAPL	Stock	127.34	127.44	127.19	127.375	3738732.0
2021-06-11 15:00:00	AAPL	Stock	127.37	127.3784	127.04	127.3521	6909400.0
2021-06-11 16:00:00	AAPL	Stock	127.35	127.4	127.2	127.24	5465729.0
2021-06-11 17:00:00	AAPL	Stock	127.22	127.28	127.2	127.26	40382.0
2021-06-11 18:00:00	AAPL	Stock	127.27	127.29	127.2	127.26	35228.0
2021-06-11 19:00:00	AAPL	Stock	127.26	127.4	127.2599	127.4	73615.0
2021-06-11 04:00:00	MSFT	Stock	257.52	257.6	257.0	257.52	2329.0
2021-06-11 05:00:00	MSFT	Stock	257.5	257.5	257.35	257.41	2706.0
2021-06-11 06:00:00	MSFT	Stock	257.3	258.1	257.15	257.93	3395.0
2021-06-11 07:00:00	MSFT	Stock	258.09	258.5	258.09	258.14	10895.0
2021-06-11 08:00:00	MSFT	Stock	258.15	258.55	256.597	257.7	39310.0
2021-06-11 09:00:00	MSFT	Stock	257.85	258.5	256.8	257.71	2216091.0
2021-06-11 10:00:00	MSFT	Stock	257.68	258.4868	257.67	257.97	2269839.0
2021-06-11 11:00:00	MSFT	Stock	257.97	258.18	257.34	257.43	1391181.0
2021-06-11 12:00:00	MSFT	Stock	257.43	257.57	256.61	256.925	1754860.0
2021-06-11 13:00:00	MSFT	Stock	256.92	257.16	256.6199	257.14	1099458.0
2021-06-11 14:00:00	MSFT	Stock	257.13	257.62	257.12	257.595	1151211.0
2021-06-11 15:00:00	MSFT	Stock	257.59	257.92	257.27	257.89	2449976.0
2021-06-11 16:00:00	MSFT	Stock	257.89	257.89	257.54	257.6501	2752362.0
2021-06-11 17:00:00	MSFT	Stock	257.65	257.7	257.55	257.7	4127.0
2021-06-11 18:00:00	MSFT	Stock	257.7	257.7	257.57	257.7	1100.0
2021-06-11 19:00:00	MSFT	Stock	257.61	257.7	257.61	257.65	1785.0
2021-06-11 04:00:00	NVDA	Stock	17.491	17.491	17.491	17.491	4000.0
2021-06-11 06:00:00	NVDA	Stock	17.5165	17.5165	17.5162	17.5162	12120.0
2021-06-11 07:00:00	NVDA	Stock	17.525	17.54	17.4762	17.4972	191320.0
2021-06-11 08:00:00	NVDA	Stock	17.55	17.55	17.4628	17.49	664840.0
2021-06-11 09:00:00	NVDA	Stock	17.494	17.7455	17.4438	17.7152	51692760.0
2021-06-11 10:00:00	NVDA	Stock	17.7113	17.7818	17.6378	17.7042	48757280.0
2021-06-11 11:00:00	NVDA	Stock	17.7059	17.7591	17.6138	17.7591	24373600.0
2021-06-11 12:00:00	NVDA	Stock	17.7592	17.8968	17.7558	17.8844	36176240.0
2021-06-11 13:00:00	NVDA	Stock	17.8832	17.9392	17.8333	17.9005	29953920.0
2021-06-11 14:00:00	NVDA	Stock	17.9028	17.9325	17.8252	17.8393	23304160.0
2021-06-11 15:00:00	NVDA	Stock	17.8432	17.8557	17.7955	17.8213	34153960.0
2021-06-11 16:00:00	NVDA	Stock	17.8252	17.8252	17.8045	17.8128	11365240.0
2021-06-11 17:00:00	NVDA	Stock	17.8065	17.825	17.8065	17.8185	184880.0
2021-06-11 18:00:00	NVDA	Stock	17.8185	17.8333	17.8165	17.825	209880.0
2021-06-11 19:00:00	NVDA	Stock	17.8288	17.8375	17.825	17.825	210200.0
2021-06-11 06:00:00	AMZN	Stock	167.75	167.75	167.75	167.75	2000.0
2021-06-11 07:00:00	AMZN	Stock	167.8045	167.9125	167.7	167.708	142600.0
2021-06-11 08:00:00	AMZN	Stock	167.85	167.995	167.5015	167.55	74640.0

> showing 50 of 65,582 rows — these rows as CSV

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