PREVIEW / stock_1hour / 2022-05-09

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-05-09.parquet
  size:    1.5 MB
  rows:    67,347
  symbols: 2,523

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-05-09 04:00:00	AAPL	Stock	155.26	155.32	154.14	154.43	74910.0
2022-05-09 05:00:00	AAPL	Stock	154.45	154.86	153.99	154.29	54520.0
2022-05-09 06:00:00	AAPL	Stock	154.28	154.33	153.16	153.4	51104.0
2022-05-09 07:00:00	AAPL	Stock	153.46	154.0	152.78	153.72	329442.0
2022-05-09 08:00:00	AAPL	Stock	153.6989	155.7	152.78	154.0201	866752.0
2022-05-09 09:00:00	AAPL	Stock	154.0203	155.83	153.38	153.57	13187045.0
2022-05-09 10:00:00	AAPL	Stock	153.58	154.53	152.78	152.85	16208106.0
2022-05-09 11:00:00	AAPL	Stock	152.85	153.31	151.955	152.16	15438284.0
2022-05-09 12:00:00	AAPL	Stock	152.17	153.66	151.56	152.41	11426784.0
2022-05-09 13:00:00	AAPL	Stock	152.41	153.54	152.1001	152.55	9337798.0
2022-05-09 14:00:00	AAPL	Stock	152.5483	153.2	151.81	153.09	9866987.0
2022-05-09 15:00:00	AAPL	Stock	153.08	153.61	151.49	152.15	19734944.0
2022-05-09 16:00:00	AAPL	Stock	152.15	152.93	151.85	152.04	11099894.0
2022-05-09 17:00:00	AAPL	Stock	152.03	152.06	151.72	151.95	189911.0
2022-05-09 18:00:00	AAPL	Stock	151.95	152.67	151.95	152.54	84087.0
2022-05-09 19:00:00	AAPL	Stock	152.6	152.75	152.2	152.75	87481.0
2022-05-09 04:00:00	MSFT	Stock	271.81	272.2	269.82	270.74	12006.0
2022-05-09 05:00:00	MSFT	Stock	270.16	270.6	269.57	269.63	11204.0
2022-05-09 06:00:00	MSFT	Stock	269.8	269.8	267.09	267.8	40256.0
2022-05-09 07:00:00	MSFT	Stock	268.05	268.77	266.85	268.7	56933.0
2022-05-09 08:00:00	MSFT	Stock	268.06	269.8	266.8002	268.77	132907.0
2022-05-09 09:00:00	MSFT	Stock	268.86	272.36	267.58	268.26	4472976.0
2022-05-09 10:00:00	MSFT	Stock	268.27	268.65	264.55	265.9668	4878952.0
2022-05-09 11:00:00	MSFT	Stock	265.94	267.84	264.97	267.08	3318555.0
2022-05-09 12:00:00	MSFT	Stock	267.07	269.2	266.01	266.84	2824513.0
2022-05-09 13:00:00	MSFT	Stock	266.83	267.5	265.3	265.705	2206397.0
2022-05-09 14:00:00	MSFT	Stock	265.65	267.01	264.75	266.69	2414632.0
2022-05-09 15:00:00	MSFT	Stock	266.69	267.5	263.32	264.59	6277690.0
2022-05-09 16:00:00	MSFT	Stock	264.43	265.88	264.01	264.59	6315944.0
2022-05-09 17:00:00	MSFT	Stock	264.4335	264.9706	263.0	264.4	27964.0
2022-05-09 18:00:00	MSFT	Stock	264.4	265.77	264.0	265.72	29569.0
2022-05-09 19:00:00	MSFT	Stock	265.55	265.7	264.3	265.0	22832.0
2022-05-09 04:00:00	NVDA	Stock	18.522	18.522	18.174	18.27	286220.0
2022-05-09 05:00:00	NVDA	Stock	18.271	18.307	18.123	18.123	206890.0
2022-05-09 06:00:00	NVDA	Stock	18.189	18.189	18.061	18.11	175940.0
2022-05-09 07:00:00	NVDA	Stock	18.109	18.151	17.879	17.98	1440740.0
2022-05-09 08:00:00	NVDA	Stock	18.12	18.1981	17.875	18.085	2518290.0
2022-05-09 09:00:00	NVDA	Stock	18.0738	18.255	17.861	18.056	66131700.0
2022-05-09 10:00:00	NVDA	Stock	18.06	18.099	17.387	17.426	87054470.0
2022-05-09 11:00:00	NVDA	Stock	17.427	17.542	17.209	17.455	70955820.0
2022-05-09 12:00:00	NVDA	Stock	17.452	17.674	17.28	17.3	52377540.0
2022-05-09 13:00:00	NVDA	Stock	17.302	17.348	17.022	17.094	50672510.0
2022-05-09 14:00:00	NVDA	Stock	17.095	17.177	16.921	17.143	58462980.0
2022-05-09 15:00:00	NVDA	Stock	17.145	17.268	16.827	16.96	81983360.0
2022-05-09 16:00:00	NVDA	Stock	16.954	17.077	16.852	16.886	31053790.0
2022-05-09 17:00:00	NVDA	Stock	16.886	16.898	16.84	16.867	390440.0
2022-05-09 18:00:00	NVDA	Stock	16.865	17.049	16.865	17.007	746010.0
2022-05-09 19:00:00	NVDA	Stock	17.01	17.01	16.93	16.953	518570.0
2022-05-09 04:00:00	AMZN	Stock	113.45	113.45	112.86	112.86	4000.0
2022-05-09 05:00:00	AMZN	Stock	113.0	113.0	112.4	112.4	6000.0

> showing 50 of 67,347 rows — these rows as CSV

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