PREVIEW / stock_1hour / 2022-02-23

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-02-23.parquet
  size:    1.4 MB
  rows:    64,169
  symbols: 2,551

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-02-23 04:00:00	AAPL	Stock	166.0	166.24	165.8	165.98	26598.0
2022-02-23 05:00:00	AAPL	Stock	166.0	166.0	165.42	165.62	11499.0
2022-02-23 06:00:00	AAPL	Stock	165.52	165.56	165.08	165.27	9569.0
2022-02-23 07:00:00	AAPL	Stock	165.28	166.02	165.22	165.94	67839.0
2022-02-23 08:00:00	AAPL	Stock	165.4899	166.49	165.38	165.87	272424.0
2022-02-23 09:00:00	AAPL	Stock	165.84	166.15	164.39	164.525	8229532.0
2022-02-23 10:00:00	AAPL	Stock	164.52	164.66	163.31	163.4585	8029589.0
2022-02-23 11:00:00	AAPL	Stock	163.45	163.99	162.77	163.84	7083828.0
2022-02-23 12:00:00	AAPL	Stock	163.84	164.47	163.19	163.3	5283941.0
2022-02-23 13:00:00	AAPL	Stock	163.3	163.3	161.82	162.205	6743781.0
2022-02-23 14:00:00	AAPL	Stock	162.2	162.435	160.685	160.96	8061588.0
2022-02-23 15:00:00	AAPL	Stock	160.955	161.07	159.75	160.17	19255660.0
2022-02-23 16:00:00	AAPL	Stock	160.08	160.83	159.91	160.0	10007812.0
2022-02-23 17:00:00	AAPL	Stock	159.93	160.07	159.57	159.81	127938.0
2022-02-23 18:00:00	AAPL	Stock	159.93	160.56	159.7	160.32	156932.0
2022-02-23 19:00:00	AAPL	Stock	160.33	160.49	159.1	159.21	171825.0
2022-02-23 04:00:00	MSFT	Stock	289.91	291.83	289.91	291.03	12021.0
2022-02-23 05:00:00	MSFT	Stock	291.2	291.2	290.2	290.2	2986.0
2022-02-23 06:00:00	MSFT	Stock	290.54	290.54	289.61	289.61	1218.0
2022-02-23 07:00:00	MSFT	Stock	289.89	291.03	289.5	291.0	6309.0
2022-02-23 08:00:00	MSFT	Stock	290.972	291.43	287.72	290.65	115694.0
2022-02-23 09:00:00	MSFT	Stock	290.65	291.7	288.73	289.15	2647615.0
2022-02-23 10:00:00	MSFT	Stock	289.19	289.97	286.75	287.17	2328867.0
2022-02-23 11:00:00	MSFT	Stock	287.14	288.46	286.0	287.5577	1944010.0
2022-02-23 12:00:00	MSFT	Stock	287.57	288.37	285.98	286.29	1441692.0
2022-02-23 13:00:00	MSFT	Stock	286.2884	286.31	284.2973	284.9001	1947380.0
2022-02-23 14:00:00	MSFT	Stock	284.88	285.39	281.79	282.0	2648712.0
2022-02-23 15:00:00	MSFT	Stock	281.99	282.5	280.1	280.28	5540800.0
2022-02-23 16:00:00	MSFT	Stock	280.27	281.25	279.55	279.7	5508015.0
2022-02-23 17:00:00	MSFT	Stock	279.69	279.75	279.12	279.49	43225.0
2022-02-23 18:00:00	MSFT	Stock	279.49	280.95	279.15	280.07	36805.0
2022-02-23 19:00:00	MSFT	Stock	280.18	280.5	278.5	278.5	36455.0
2022-02-23 04:00:00	NVDA	Stock	23.902	23.948	23.82	23.872	187680.0
2022-02-23 05:00:00	NVDA	Stock	23.875	23.9	23.727	23.783	101400.0
2022-02-23 06:00:00	NVDA	Stock	23.781	23.783	23.63	23.63	32530.0
2022-02-23 07:00:00	NVDA	Stock	23.686	23.839	23.65	23.823	462730.0
2022-02-23 08:00:00	NVDA	Stock	23.7007	23.913	23.39	23.848	2911150.0
2022-02-23 09:00:00	NVDA	Stock	23.85	24.155	23.481	23.5205	60765100.0
2022-02-23 10:00:00	NVDA	Stock	23.524	23.525	23.162	23.297	57217570.0
2022-02-23 11:00:00	NVDA	Stock	23.294	23.345	23.029	23.2871	47343630.0
2022-02-23 12:00:00	NVDA	Stock	23.287	23.4982	23.0672	23.136	41037250.0
2022-02-23 13:00:00	NVDA	Stock	23.138	23.14	22.739	22.833	54448670.0
2022-02-23 14:00:00	NVDA	Stock	22.8242	22.924	22.541	22.634	46986380.0
2022-02-23 15:00:00	NVDA	Stock	22.63	22.678	22.301	22.382	70600490.0
2022-02-23 16:00:00	NVDA	Stock	22.387	22.45	22.13	22.187	28623290.0
2022-02-23 17:00:00	NVDA	Stock	22.19	22.2	22.069	22.168	639830.0
2022-02-23 18:00:00	NVDA	Stock	22.17	22.3	22.1	22.279	608940.0
2022-02-23 19:00:00	NVDA	Stock	22.236	22.275	22.0	22.012	839550.0
2022-02-23 04:00:00	AMZN	Stock	152.257	152.85	152.257	152.85	8000.0
2022-02-23 06:00:00	AMZN	Stock	151.95	151.95	151.95	151.95	2000.0

> showing 50 of 64,169 rows — these rows as CSV

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