PREVIEW / stock_1hour / 2022-11-21

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-11-21.parquet
  size:    1.4 MB
  rows:    61,115
  symbols: 2,089

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
2022-11-21 04:00:00	AAPL	Stock	150.1	150.65	150.01	150.17	17720.0
2022-11-21 05:00:00	AAPL	Stock	150.16	150.2	149.08	149.69	15078.0
2022-11-21 06:00:00	AAPL	Stock	149.7	149.86	149.28	149.35	7818.0
2022-11-21 07:00:00	AAPL	Stock	149.42	149.88	149.36	149.77	48024.0
2022-11-21 08:00:00	AAPL	Stock	150.65	150.79	149.4315	150.27	230770.0
2022-11-21 09:00:00	AAPL	Stock	150.2	150.49	148.46	149.64	7715387.0
2022-11-21 10:00:00	AAPL	Stock	149.66	149.96	147.78	148.0601	8220702.0
2022-11-21 11:00:00	AAPL	Stock	148.06	148.74	147.75	148.076	6061710.0
2022-11-21 12:00:00	AAPL	Stock	148.075	148.36	147.715	147.99	4392783.0
2022-11-21 13:00:00	AAPL	Stock	147.98	149.03	147.905	148.51	4946457.0
2022-11-21 14:00:00	AAPL	Stock	148.5	148.76	148.23	148.39	3933376.0
2022-11-21 15:00:00	AAPL	Stock	148.4	148.6	147.88	148.02	8180906.0
2022-11-21 16:00:00	AAPL	Stock	148.02	148.29	147.8	148.05	7174453.0
2022-11-21 17:00:00	AAPL	Stock	148.05	148.09	148.01	148.02	58393.0
2022-11-21 18:00:00	AAPL	Stock	148.05	148.1	148.01	148.03	21789.0
2022-11-21 19:00:00	AAPL	Stock	148.06	148.27	148.06	148.12	42595.0
2022-11-21 04:00:00	MSFT	Stock	240.5	240.5	239.82	240.05	1748.0
2022-11-21 05:00:00	MSFT	Stock	239.83	239.83	239.83	239.83	100.0
2022-11-21 06:00:00	MSFT	Stock	239.85	240.0	239.5	239.5	18101.0
2022-11-21 07:00:00	MSFT	Stock	239.72	240.15	239.4	240.15	10814.0
2022-11-21 08:00:00	MSFT	Stock	239.5502	240.89	239.48	240.88	20799.0
2022-11-21 09:00:00	MSFT	Stock	240.89	244.67	240.22	243.27	2441872.0
2022-11-21 10:00:00	MSFT	Stock	243.32	243.58	241.24	241.9	3296688.0
2022-11-21 11:00:00	MSFT	Stock	241.91	243.07	241.66	242.3	2023329.0
2022-11-21 12:00:00	MSFT	Stock	242.305	242.64	241.3526	241.56	1675172.0
2022-11-21 13:00:00	MSFT	Stock	241.54	243.13	241.52	242.61	1660809.0
2022-11-21 14:00:00	MSFT	Stock	242.59	242.927	242.11	242.34	1479031.0
2022-11-21 15:00:00	MSFT	Stock	242.32	242.9	242.02	242.08	2914402.0
2022-11-21 16:00:00	MSFT	Stock	242.05	242.3	242.0	242.0	3626792.0
2022-11-21 17:00:00	MSFT	Stock	242.06	242.06	241.8366	241.8366	1977.0
2022-11-21 18:00:00	MSFT	Stock	242.03	242.13	242.0	242.13	2487.0
2022-11-21 19:00:00	MSFT	Stock	242.13	242.97	242.13	242.84	7505.0
2022-11-21 04:00:00	NVDA	Stock	15.4	15.421	15.182	15.278	391970.0
2022-11-21 05:00:00	NVDA	Stock	15.282	15.32	15.24	15.265	165640.0
2022-11-21 06:00:00	NVDA	Stock	15.25	15.252	15.24	15.24	66320.0
2022-11-21 07:00:00	NVDA	Stock	15.24	15.24	15.17	15.198	338330.0
2022-11-21 08:00:00	NVDA	Stock	15.2001	15.3137	15.172	15.298	718070.0
2022-11-21 09:00:00	NVDA	Stock	15.285	15.419	15.036	15.303	50202060.0
2022-11-21 10:00:00	NVDA	Stock	15.303	15.3359	15.171	15.307	58241060.0
2022-11-21 11:00:00	NVDA	Stock	15.307	15.477	15.2923	15.3471	59471850.0
2022-11-21 12:00:00	NVDA	Stock	15.35	15.3914	15.201	15.209	36789260.0
2022-11-21 13:00:00	NVDA	Stock	15.207	15.368	15.201	15.317	33605500.0
2022-11-21 14:00:00	NVDA	Stock	15.317	15.35	15.273	15.31	22124740.0
2022-11-21 15:00:00	NVDA	Stock	15.307	15.411	15.307	15.317	44798110.0
2022-11-21 16:00:00	NVDA	Stock	15.317	15.363	15.292	15.292	23507250.0
2022-11-21 17:00:00	NVDA	Stock	15.3073	15.311	15.292	15.292	195860.0
2022-11-21 18:00:00	NVDA	Stock	15.309	15.31	15.293	15.31	59490.0
2022-11-21 19:00:00	NVDA	Stock	15.31	15.348	15.31	15.34	140780.0
2022-11-21 04:00:00	AMZN	Stock	93.87	93.87	92.92	93.15	34976.0
2022-11-21 05:00:00	AMZN	Stock	93.15	93.19	93.0	93.1	8445.0

> showing 50 of 61,115 rows — these rows as CSV

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