PREVIEW / stock_1hour / 2023-09-19

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-09-19.parquet
  size:    1.3 MB
  rows:    57,819
  symbols: 1,422

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
2023-09-19 04:00:00	AAPL	Stock	178.57	178.61	178.44	178.58	7422.0
2023-09-19 05:00:00	AAPL	Stock	178.55	178.82	178.46	178.73	9360.0
2023-09-19 06:00:00	AAPL	Stock	178.7	178.75	178.46	178.51	9224.0
2023-09-19 07:00:00	AAPL	Stock	178.5	178.96	178.49	178.68	57948.0
2023-09-19 08:00:00	AAPL	Stock	178.5	178.99	177.8	177.99	268067.0
2023-09-19 09:00:00	AAPL	Stock	177.98	178.67	177.13	177.595	7385785.0
2023-09-19 10:00:00	AAPL	Stock	177.6	177.91	177.13	177.2288	6528279.0
2023-09-19 11:00:00	AAPL	Stock	177.22	178.12	177.15	178.0601	4129178.0
2023-09-19 12:00:00	AAPL	Stock	178.07	178.2376	177.63	178.19	3622275.0
2023-09-19 13:00:00	AAPL	Stock	178.19	179.17	178.14	179.09	5126661.0
2023-09-19 14:00:00	AAPL	Stock	179.1	179.63	178.9	178.9	5211074.0
2023-09-19 15:00:00	AAPL	Stock	178.9	179.44	178.74	179.1	6315132.0
2023-09-19 16:00:00	AAPL	Stock	179.07	179.35	179.05	179.14	5736064.0
2023-09-19 17:00:00	AAPL	Stock	179.14	179.18	179.1	179.14	19770.0
2023-09-19 18:00:00	AAPL	Stock	179.1404	179.1999	179.08	179.15	7207.0
2023-09-19 19:00:00	AAPL	Stock	179.17	179.18	178.9	179.0	36781.0
2023-09-19 04:00:00	MSFT	Stock	329.55	329.55	329.45	329.55	675.0
2023-09-19 05:00:00	MSFT	Stock	329.5	329.51	329.46	329.51	393.0
2023-09-19 06:00:00	MSFT	Stock	329.4	329.65	329.23	329.29	1728.0
2023-09-19 07:00:00	MSFT	Stock	329.5	329.5	328.6	328.76	5079.0
2023-09-19 08:00:00	MSFT	Stock	329.21	330.2	327.8	327.9	17264.0
2023-09-19 09:00:00	MSFT	Stock	327.85	328.75	324.87	326.66	2308995.0
2023-09-19 10:00:00	MSFT	Stock	326.67	326.765	324.51	325.1401	1854784.0
2023-09-19 11:00:00	MSFT	Stock	325.14	326.58	325.02	326.45	1133001.0
2023-09-19 12:00:00	MSFT	Stock	326.45	326.678	325.56	326.34	823321.0
2023-09-19 13:00:00	MSFT	Stock	326.34	328.3699	326.28	328.23	870753.0
2023-09-19 14:00:00	MSFT	Stock	328.25	329.19	327.65	327.65	1096865.0
2023-09-19 15:00:00	MSFT	Stock	327.67	329.39	327.5501	328.63	1448021.0
2023-09-19 16:00:00	MSFT	Stock	328.63	328.85	328.46	328.66	2780750.0
2023-09-19 17:00:00	MSFT	Stock	328.83	328.8821	328.83	328.84	500.0
2023-09-19 18:00:00	MSFT	Stock	328.79	328.9	328.79	328.79	2442.0
2023-09-19 19:00:00	MSFT	Stock	328.79	328.91	328.72	328.91	1670.0
2023-09-19 04:00:00	NVDA	Stock	44.0	44.0	43.871	43.906	32140.0
2023-09-19 05:00:00	NVDA	Stock	43.87	43.935	43.869	43.902	13330.0
2023-09-19 06:00:00	NVDA	Stock	43.955	44.059	43.93	44.059	14000.0
2023-09-19 07:00:00	NVDA	Stock	44.045	44.335	44.043	44.182	292280.0
2023-09-19 08:00:00	NVDA	Stock	44.059	44.349	43.802	44.021	1263060.0
2023-09-19 09:00:00	NVDA	Stock	44.0091	44.02	43.3175	43.44	46142730.0
2023-09-19 10:00:00	NVDA	Stock	43.454	43.7428	43.088	43.16	60882070.0
2023-09-19 11:00:00	NVDA	Stock	43.1605	43.361	43.11	43.2345	38319500.0
2023-09-19 12:00:00	NVDA	Stock	43.2341	43.335	43.002	43.32	28425730.0
2023-09-19 13:00:00	NVDA	Stock	43.3205	43.672	43.291	43.609	30210780.0
2023-09-19 14:00:00	NVDA	Stock	43.609	43.79	43.447	43.469	36338060.0
2023-09-19 15:00:00	NVDA	Stock	43.463	43.623	43.381	43.509	34837090.0
2023-09-19 16:00:00	NVDA	Stock	43.52	43.5727	43.458	43.46	12208380.0
2023-09-19 17:00:00	NVDA	Stock	43.4659	43.5	43.454	43.486	119820.0
2023-09-19 18:00:00	NVDA	Stock	43.48	43.4984	43.476	43.489	134150.0
2023-09-19 19:00:00	NVDA	Stock	43.49	43.574	43.484	43.546	251980.0
2023-09-19 04:00:00	AMZN	Stock	140.04	140.11	140.0	140.08	3360.0
2023-09-19 05:00:00	AMZN	Stock	140.0	140.15	140.0	140.1	3645.0

> showing 50 of 57,819 rows — these rows as CSV

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