PREVIEW / stock_1hour / 2022-04-14

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-04-14.parquet
  size:    1.4 MB
  rows:    62,566
  symbols: 2,463

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-04-14 04:00:00	AAPL	Stock	170.52	170.7	170.1	170.28	25120.0
2022-04-14 05:00:00	AAPL	Stock	170.17	170.29	170.05	170.29	6620.0
2022-04-14 06:00:00	AAPL	Stock	170.34	170.45	170.0	170.22	12493.0
2022-04-14 07:00:00	AAPL	Stock	170.2	170.66	170.06	170.13	66765.0
2022-04-14 08:00:00	AAPL	Stock	170.2299	170.93	169.974	170.16	254716.0
2022-04-14 09:00:00	AAPL	Stock	170.17	171.27	169.27	169.37	9554289.0
2022-04-14 10:00:00	AAPL	Stock	169.37	169.615	167.76	168.0101	9295549.0
2022-04-14 11:00:00	AAPL	Stock	168.0	168.35	167.35	167.46	6168892.0
2022-04-14 12:00:00	AAPL	Stock	167.45	167.8481	166.57	166.8501	6164817.0
2022-04-14 13:00:00	AAPL	Stock	166.85	167.165	166.45	167.1401	5479881.0
2022-04-14 14:00:00	AAPL	Stock	167.145	167.39	165.9236	165.94	6126248.0
2022-04-14 15:00:00	AAPL	Stock	165.9401	166.2715	165.04	165.28	12892057.0
2022-04-14 16:00:00	AAPL	Stock	165.28	165.48	165.18	165.39	9041997.0
2022-04-14 17:00:00	AAPL	Stock	165.43	165.43	165.16	165.2	78738.0
2022-04-14 18:00:00	AAPL	Stock	165.2	165.25	165.16	165.22	23699.0
2022-04-14 19:00:00	AAPL	Stock	165.24	165.24	165.0	165.0	36465.0
2022-04-14 04:00:00	MSFT	Stock	288.51	288.73	288.1	288.1	1522.0
2022-04-14 05:00:00	MSFT	Stock	287.9	287.9	287.9	287.9	348.0
2022-04-14 06:00:00	MSFT	Stock	288.26	288.26	287.75	287.75	871.0
2022-04-14 07:00:00	MSFT	Stock	288.0	288.26	286.7	286.7	22353.0
2022-04-14 08:00:00	MSFT	Stock	287.8005	288.3099	286.9	287.17	33809.0
2022-04-14 09:00:00	MSFT	Stock	287.18	289.45	284.72	285.12	2827710.0
2022-04-14 10:00:00	MSFT	Stock	285.12	285.43	282.64	283.68	2778748.0
2022-04-14 11:00:00	MSFT	Stock	283.66	284.75	283.0	283.17	1237494.0
2022-04-14 12:00:00	MSFT	Stock	283.17	283.38	281.46	282.15	1720653.0
2022-04-14 13:00:00	MSFT	Stock	282.13	283.135	281.91	283.09	1335409.0
2022-04-14 14:00:00	MSFT	Stock	283.09	283.53	281.22	281.22	1634464.0
2022-04-14 15:00:00	MSFT	Stock	281.23	281.59	279.32	279.78	4703505.0
2022-04-14 16:00:00	MSFT	Stock	279.8	280.1	279.55	280.0	4585898.0
2022-04-14 17:00:00	MSFT	Stock	279.9627	279.98	279.75	279.93	16205.0
2022-04-14 18:00:00	MSFT	Stock	280.0	280.0	279.9	279.92	9193.0
2022-04-14 19:00:00	MSFT	Stock	279.9	279.99	279.75	279.75	7625.0
2022-04-14 04:00:00	NVDA	Stock	22.45	22.543	22.33	22.44	300320.0
2022-04-14 05:00:00	NVDA	Stock	22.44	22.478	22.365	22.459	105120.0
2022-04-14 06:00:00	NVDA	Stock	22.468	22.468	22.283	22.325	143370.0
2022-04-14 07:00:00	NVDA	Stock	22.32	22.394	22.24	22.269	525020.0
2022-04-14 08:00:00	NVDA	Stock	22.307	22.557	22.2215	22.374	1647210.0
2022-04-14 09:00:00	NVDA	Stock	22.3681	22.777	21.983	22.026	77443130.0
2022-04-14 10:00:00	NVDA	Stock	22.021	22.1	21.556	21.66	88740160.0
2022-04-14 11:00:00	NVDA	Stock	21.66	21.844	21.6	21.6891	43637970.0
2022-04-14 12:00:00	NVDA	Stock	21.685	21.717	21.529	21.666	33263860.0
2022-04-14 13:00:00	NVDA	Stock	21.663	21.694	21.551	21.6707	30920290.0
2022-04-14 14:00:00	NVDA	Stock	21.669	21.766	21.4	21.423	40829200.0
2022-04-14 15:00:00	NVDA	Stock	21.427	21.537	21.163	21.257	73114360.0
2022-04-14 16:00:00	NVDA	Stock	21.258	21.258	21.1932	21.244	28163110.0
2022-04-14 17:00:00	NVDA	Stock	21.241	21.252	21.227	21.245	488540.0
2022-04-14 18:00:00	NVDA	Stock	21.248	21.253	21.202	21.221	341500.0
2022-04-14 19:00:00	NVDA	Stock	21.215	21.22	21.2	21.21	227060.0
2022-04-14 04:00:00	AMZN	Stock	155.756	155.756	155.4	155.4	19700.0
2022-04-14 06:00:00	AMZN	Stock	155.595	155.595	155.595	155.595	6100.0

> showing 50 of 62,566 rows — these rows as CSV

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