PREVIEW / stock_1hour / 2022-04-12

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-04-12.parquet
  size:    1.4 MB
  rows:    63,084
  symbols: 2,480

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-12 04:00:00	AAPL	Stock	165.0	165.85	165.0	165.6	40405.0
2022-04-12 05:00:00	AAPL	Stock	165.68	165.95	165.39	165.95	16262.0
2022-04-12 06:00:00	AAPL	Stock	165.95	165.95	165.5	165.74	13135.0
2022-04-12 07:00:00	AAPL	Stock	165.71	165.87	165.26	165.87	74406.0
2022-04-12 08:00:00	AAPL	Stock	165.83	168.9899	163.0	168.85	1229461.0
2022-04-12 09:00:00	AAPL	Stock	168.84	169.79	166.92	169.33	11070588.0
2022-04-12 10:00:00	AAPL	Stock	169.34	169.87	168.07	168.12	11414474.0
2022-04-12 11:00:00	AAPL	Stock	168.11	169.375	167.82	168.85	6981471.0
2022-04-12 12:00:00	AAPL	Stock	168.86	168.88	167.7028	168.23	6325830.0
2022-04-12 13:00:00	AAPL	Stock	168.22	168.57	167.04	167.155	5657897.0
2022-04-12 14:00:00	AAPL	Stock	167.15	167.8	166.64	167.47	8038536.0
2022-04-12 15:00:00	AAPL	Stock	167.47	168.095	166.6929	167.64	12045560.0
2022-04-12 16:00:00	AAPL	Stock	167.64	167.9	167.44	167.69	5511439.0
2022-04-12 17:00:00	AAPL	Stock	167.67	167.93	167.6	167.78	36757.0
2022-04-12 18:00:00	AAPL	Stock	167.8	167.8	167.65	167.79	16310.0
2022-04-12 19:00:00	AAPL	Stock	167.84	168.5	167.82	168.5	53744.0
2022-04-12 04:00:00	MSFT	Stock	285.0	286.29	284.5	285.97	22385.0
2022-04-12 05:00:00	MSFT	Stock	285.69	286.5	285.2	286.5	5537.0
2022-04-12 06:00:00	MSFT	Stock	286.41	286.48	285.58	286.34	3108.0
2022-04-12 07:00:00	MSFT	Stock	285.81	286.5	285.06	286.48	31353.0
2022-04-12 08:00:00	MSFT	Stock	285.92	290.75	285.2	290.16	220012.0
2022-04-12 09:00:00	MSFT	Stock	290.15	290.64	286.66	290.22	3508428.0
2022-04-12 10:00:00	MSFT	Stock	290.2515	290.739	286.09	286.42	2994800.0
2022-04-12 11:00:00	MSFT	Stock	286.4	287.97	285.91	286.35	2180161.0
2022-04-12 12:00:00	MSFT	Stock	286.37	286.53	284.5007	285.15	2219588.0
2022-04-12 13:00:00	MSFT	Stock	285.15	286.29	283.65	283.89	1800412.0
2022-04-12 14:00:00	MSFT	Stock	283.82	284.53	280.49	282.37	3263831.0
2022-04-12 15:00:00	MSFT	Stock	282.37	282.58	280.52	281.98	3937256.0
2022-04-12 16:00:00	MSFT	Stock	282.06	282.75	281.7	282.45	2877669.0
2022-04-12 17:00:00	MSFT	Stock	282.45	282.6	282.25	282.42	4752.0
2022-04-12 18:00:00	MSFT	Stock	282.47	282.58	282.33	282.58	10662.0
2022-04-12 19:00:00	MSFT	Stock	282.54	283.29	282.5	283.29	21882.0
2022-04-12 04:00:00	NVDA	Stock	21.878	22.18	21.8	22.1	457790.0
2022-04-12 05:00:00	NVDA	Stock	22.087	22.18	22.081	22.16	142190.0
2022-04-12 06:00:00	NVDA	Stock	22.153	22.181	22.005	22.022	142120.0
2022-04-12 07:00:00	NVDA	Stock	22.02	22.09	21.92	22.082	358120.0
2022-04-12 08:00:00	NVDA	Stock	21.85	22.788	21.751	22.74	6553830.0
2022-04-12 09:00:00	NVDA	Stock	22.754	22.758	21.906	22.554	85678820.0
2022-04-12 10:00:00	NVDA	Stock	22.57	22.725	21.718	21.8005	88655640.0
2022-04-12 11:00:00	NVDA	Stock	21.795	22.0775	21.66	21.903	59939360.0
2022-04-12 12:00:00	NVDA	Stock	21.906	21.941	21.695	21.842	41661460.0
2022-04-12 13:00:00	NVDA	Stock	21.834	21.898	21.5	21.547	43348740.0
2022-04-12 14:00:00	NVDA	Stock	21.544	21.666	21.315	21.445	62492690.0
2022-04-12 15:00:00	NVDA	Stock	21.44	21.6248	21.282	21.502	63151580.0
2022-04-12 16:00:00	NVDA	Stock	21.499	21.521	21.429	21.485	13450930.0
2022-04-12 17:00:00	NVDA	Stock	21.485	21.511	21.475	21.498	332010.0
2022-04-12 18:00:00	NVDA	Stock	21.502	21.533	21.475	21.533	395590.0
2022-04-12 19:00:00	NVDA	Stock	21.53	21.633	21.53	21.595	512200.0
2022-04-12 07:00:00	AMZN	Stock	151.6	151.6	150.995	151.15	78520.0
2022-04-12 08:00:00	AMZN	Stock	150.862	154.835	150.8597	154.5	391720.0

> showing 50 of 63,084 rows — these rows as CSV

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