PREVIEW / stock_1hour / 2022-12-12

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-12-12.parquet
  size:    1.4 MB
  rows:    61,534
  symbols: 2,005

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-12-12 04:00:00	AAPL	Stock	142.14	142.7	142.14	142.54	10747.0
2022-12-12 05:00:00	AAPL	Stock	142.55	142.77	142.55	142.74	7764.0
2022-12-12 06:00:00	AAPL	Stock	142.7	142.74	142.57	142.66	5235.0
2022-12-12 07:00:00	AAPL	Stock	142.62	142.65	142.41	142.54	48831.0
2022-12-12 08:00:00	AAPL	Stock	142.4899	142.8	141.56	142.52	155158.0
2022-12-12 09:00:00	AAPL	Stock	142.56	143.01	141.64	142.679	6104769.0
2022-12-12 10:00:00	AAPL	Stock	142.69	142.88	141.06	141.77	7887289.0
2022-12-12 11:00:00	AAPL	Stock	141.77	142.47	141.73	141.9481	5547463.0
2022-12-12 12:00:00	AAPL	Stock	141.95	142.45	141.84	142.2799	4105400.0
2022-12-12 13:00:00	AAPL	Stock	142.2773	142.885	142.045	142.7	4679329.0
2022-12-12 14:00:00	AAPL	Stock	142.71	143.93	142.39	143.815	6589848.0
2022-12-12 15:00:00	AAPL	Stock	143.82	144.5	143.48	144.495	10173596.0
2022-12-12 16:00:00	AAPL	Stock	144.48	144.55	142.9411	144.31	12842283.0
2022-12-12 17:00:00	AAPL	Stock	144.32	144.49	144.24	144.3	56801.0
2022-12-12 18:00:00	AAPL	Stock	144.3	144.4	144.2419	144.38	19488.0
2022-12-12 19:00:00	AAPL	Stock	144.37	144.44	144.35	144.44	18655.0
2022-12-12 04:00:00	MSFT	Stock	245.17	245.46	244.76	245.46	1953.0
2022-12-12 05:00:00	MSFT	Stock	245.9	246.57	245.9	246.45	3652.0
2022-12-12 06:00:00	MSFT	Stock	246.51	246.86	246.31	246.6	3134.0
2022-12-12 07:00:00	MSFT	Stock	246.47	246.8	246.37	246.6	9023.0
2022-12-12 08:00:00	MSFT	Stock	246.65	246.9869	246.0501	246.6162	18430.0
2022-12-12 09:00:00	MSFT	Stock	246.41	252.16	245.95	251.1855	3589409.0
2022-12-12 10:00:00	MSFT	Stock	251.21	251.3019	248.79	249.75	3312690.0
2022-12-12 11:00:00	MSFT	Stock	249.765	250.905	249.62	250.35	2356602.0
2022-12-12 12:00:00	MSFT	Stock	250.35	250.4348	249.69	250.235	1721016.0
2022-12-12 13:00:00	MSFT	Stock	250.23	250.9	249.716	250.36	1622042.0
2022-12-12 14:00:00	MSFT	Stock	250.37	251.16	249.74	251.0	1662591.0
2022-12-12 15:00:00	MSFT	Stock	251.01	252.54	250.76	252.52	3983968.0
2022-12-12 16:00:00	MSFT	Stock	252.51	252.74	250.8881	252.67	6042341.0
2022-12-12 17:00:00	MSFT	Stock	252.54	252.65	252.28	252.37	4995.0
2022-12-12 18:00:00	MSFT	Stock	252.37	252.75	252.3	252.75	4646.0
2022-12-12 19:00:00	MSFT	Stock	252.69	252.81	252.65	252.81	4381.0
2022-12-12 04:00:00	NVDA	Stock	16.929	17.0	16.905	17.0	46910.0
2022-12-12 05:00:00	NVDA	Stock	17.025	17.034	16.99	17.025	144630.0
2022-12-12 06:00:00	NVDA	Stock	17.03	17.066	17.02	17.036	60280.0
2022-12-12 07:00:00	NVDA	Stock	17.064	17.13	17.059	17.129	199650.0
2022-12-12 08:00:00	NVDA	Stock	17.07	17.1585	16.88	17.099	724880.0
2022-12-12 09:00:00	NVDA	Stock	17.109	17.129	16.797	17.103	47656590.0
2022-12-12 10:00:00	NVDA	Stock	17.106	17.265	16.988	17.087	74157570.0
2022-12-12 11:00:00	NVDA	Stock	17.087	17.203	17.0541	17.1644	45367200.0
2022-12-12 12:00:00	NVDA	Stock	17.166	17.256	17.126	17.157	33909300.0
2022-12-12 13:00:00	NVDA	Stock	17.161	17.242	17.065	17.2005	36959120.0
2022-12-12 14:00:00	NVDA	Stock	17.202	17.375	17.134	17.337	39796440.0
2022-12-12 15:00:00	NVDA	Stock	17.338	17.538	17.319	17.535	71590260.0
2022-12-12 16:00:00	NVDA	Stock	17.535	17.545	17.2151	17.5353	29887390.0
2022-12-12 17:00:00	NVDA	Stock	17.545	17.589	17.535	17.585	516750.0
2022-12-12 18:00:00	NVDA	Stock	17.586	17.61	17.582	17.605	262730.0
2022-12-12 19:00:00	NVDA	Stock	17.6	17.698	17.6	17.697	391340.0
2022-12-12 04:00:00	AMZN	Stock	89.49	89.49	89.18	89.35	20421.0
2022-12-12 05:00:00	AMZN	Stock	89.31	89.58	89.31	89.58	6251.0

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

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