PREVIEW / stock_1hour / 2021-09-28

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-09-28.parquet
  size:    1.4 MB
  rows:    65,747
  symbols: 2,683

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-09-28 04:00:00	AAPL	Stock	143.64	144.0	142.95	143.35	59769.0
2021-09-28 05:00:00	AAPL	Stock	143.35	143.55	142.8	142.89	41793.0
2021-09-28 06:00:00	AAPL	Stock	142.85	143.05	142.75	142.95	22792.0
2021-09-28 07:00:00	AAPL	Stock	142.98	143.24	142.72	143.17	303915.0
2021-09-28 08:00:00	AAPL	Stock	142.8901	145.733	142.75	143.0	838972.0
2021-09-28 09:00:00	AAPL	Stock	142.99	144.75	142.0	144.6001	13712229.0
2021-09-28 10:00:00	AAPL	Stock	144.6	144.6	142.77	142.87	14118918.0
2021-09-28 11:00:00	AAPL	Stock	142.87	143.09	142.42	142.75	10941898.0
2021-09-28 12:00:00	AAPL	Stock	142.74	142.94	141.91	141.9901	9664191.0
2021-09-28 13:00:00	AAPL	Stock	141.99	142.47	141.81	141.94	8813257.0
2021-09-28 14:00:00	AAPL	Stock	141.95	142.77	141.69	142.655	9077081.0
2021-09-28 15:00:00	AAPL	Stock	142.65	142.88	141.76	141.92	15987802.0
2021-09-28 16:00:00	AAPL	Stock	141.9	142.41	141.75	142.0299	14211181.0
2021-09-28 17:00:00	AAPL	Stock	142.01	142.05	141.9	141.96	63175.0
2021-09-28 18:00:00	AAPL	Stock	141.96	142.24	141.95	142.08	71062.0
2021-09-28 19:00:00	AAPL	Stock	142.06	142.4	141.97	142.4	59164.0
2021-09-28 04:00:00	MSFT	Stock	291.21	291.47	289.78	290.74	7548.0
2021-09-28 05:00:00	MSFT	Stock	290.51	290.64	289.5	289.5	12412.0
2021-09-28 06:00:00	MSFT	Stock	289.61	290.5	288.74	288.74	6843.0
2021-09-28 07:00:00	MSFT	Stock	289.97	290.48	288.51	289.6	44891.0
2021-09-28 08:00:00	MSFT	Stock	289.5243	289.9	288.5	289.4	97957.0
2021-09-28 09:00:00	MSFT	Stock	289.4	290.78	287.54	288.91	3518656.0
2021-09-28 10:00:00	MSFT	Stock	288.9	288.9	285.21	285.61	4456724.0
2021-09-28 11:00:00	MSFT	Stock	285.61	285.8499	284.36	285.69	3800252.0
2021-09-28 12:00:00	MSFT	Stock	285.7	286.44	284.8	285.04	2657548.0
2021-09-28 13:00:00	MSFT	Stock	285.02	286.055	284.56	285.065	2022743.0
2021-09-28 14:00:00	MSFT	Stock	285.08	286.6799	284.7	285.806	2724927.0
2021-09-28 15:00:00	MSFT	Stock	285.8	286.105	282.75	283.52	7301184.0
2021-09-28 16:00:00	MSFT	Stock	283.52	283.85	283.05	283.55	6102319.0
2021-09-28 17:00:00	MSFT	Stock	283.52	283.55	283.35	283.54	134792.0
2021-09-28 18:00:00	MSFT	Stock	283.54	283.8	283.35	283.6	22756.0
2021-09-28 19:00:00	MSFT	Stock	283.6	284.55	283.35	284.05	20956.0
2021-09-28 04:00:00	NVDA	Stock	21.29	21.29	21.059	21.207	99220.0
2021-09-28 05:00:00	NVDA	Stock	21.207	21.25	21.069	21.069	66790.0
2021-09-28 06:00:00	NVDA	Stock	21.058	21.1	21.005	21.04	164920.0
2021-09-28 07:00:00	NVDA	Stock	21.065	21.189	21.029	21.14	771920.0
2021-09-28 08:00:00	NVDA	Stock	21.0511	21.18	21.0253	21.095	1469120.0
2021-09-28 09:00:00	NVDA	Stock	21.081	21.419	20.965	21.063	47329730.0
2021-09-28 10:00:00	NVDA	Stock	21.06	21.063	20.757	20.82	57099750.0
2021-09-28 11:00:00	NVDA	Stock	20.817	20.846	20.664	20.8315	34988330.0
2021-09-28 12:00:00	NVDA	Stock	20.83	20.9045	20.682	20.709	21203390.0
2021-09-28 13:00:00	NVDA	Stock	20.71	20.85	20.651	20.717	23059550.0
2021-09-28 14:00:00	NVDA	Stock	20.7165	20.944	20.657	20.904	24243300.0
2021-09-28 15:00:00	NVDA	Stock	20.9035	20.96	20.6667	20.689	35020590.0
2021-09-28 16:00:00	NVDA	Stock	20.697	20.747	20.58	20.631	20464600.0
2021-09-28 17:00:00	NVDA	Stock	20.624	20.627	20.592	20.607	166070.0
2021-09-28 18:00:00	NVDA	Stock	20.607	20.674	20.607	20.674	218870.0
2021-09-28 19:00:00	NVDA	Stock	20.66	20.725	20.629	20.725	352040.0
2021-09-28 04:00:00	AMZN	Stock	167.5	168.101	167.5	168.101	6780.0
2021-09-28 06:00:00	AMZN	Stock	167.45	167.9885	167.45	167.9885	6000.0

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

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