PREVIEW / stock_1hour / 2022-07-21

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-07-21.parquet
  size:    1.3 MB
  rows:    61,368
  symbols: 2,268

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-07-21 04:00:00	AAPL	Stock	152.46	153.01	152.46	152.99	27251.0
2022-07-21 05:00:00	AAPL	Stock	152.93	153.27	152.89	153.26	14916.0
2022-07-21 06:00:00	AAPL	Stock	153.33	153.7	153.25	153.36	22757.0
2022-07-21 07:00:00	AAPL	Stock	153.3	153.56	153.11	153.48	81962.0
2022-07-21 08:00:00	AAPL	Stock	153.3	154.51	152.38	154.15	762130.0
2022-07-21 09:00:00	AAPL	Stock	154.2	154.74	152.965	153.37	8321885.0
2022-07-21 10:00:00	AAPL	Stock	153.39	153.97	151.94	153.26	8418710.0
2022-07-21 11:00:00	AAPL	Stock	153.2582	154.1	152.96	153.97	5790491.0
2022-07-21 12:00:00	AAPL	Stock	153.995	155.26	153.9	155.15	6621798.0
2022-07-21 13:00:00	AAPL	Stock	155.16	155.4799	154.534	155.16	5845341.0
2022-07-21 14:00:00	AAPL	Stock	155.16	155.45	154.9001	155.2601	4550891.0
2022-07-21 15:00:00	AAPL	Stock	155.2686	155.57	154.7	155.38	8533896.0
2022-07-21 16:00:00	AAPL	Stock	155.38	155.4	154.75	155.24	6224085.0
2022-07-21 17:00:00	AAPL	Stock	155.25	155.26	154.77	154.88	139791.0
2022-07-21 18:00:00	AAPL	Stock	154.94	155.09	154.63	154.85	82549.0
2022-07-21 19:00:00	AAPL	Stock	154.8	154.92	154.71	154.92	41868.0
2022-07-21 04:00:00	MSFT	Stock	260.02	260.73	259.5	259.77	10174.0
2022-07-21 05:00:00	MSFT	Stock	259.89	260.38	259.89	260.2	5415.0
2022-07-21 06:00:00	MSFT	Stock	260.46	260.7	260.11	260.11	6592.0
2022-07-21 07:00:00	MSFT	Stock	260.48	260.56	260.0	260.46	14971.0
2022-07-21 08:00:00	MSFT	Stock	260.2101	262.19	259.6	261.37	82594.0
2022-07-21 09:00:00	MSFT	Stock	261.34	261.7	257.03	260.17	2612648.0
2022-07-21 10:00:00	MSFT	Stock	260.155	261.35	257.32	259.15	2311155.0
2022-07-21 11:00:00	MSFT	Stock	259.11	261.59	258.96	261.4	1568644.0
2022-07-21 12:00:00	MSFT	Stock	261.36	264.38	261.28	264.22	1878460.0
2022-07-21 13:00:00	MSFT	Stock	264.23	264.62	263.19	263.8	1291303.0
2022-07-21 14:00:00	MSFT	Stock	263.8218	264.37	263.31	263.77	946220.0
2022-07-21 15:00:00	MSFT	Stock	263.71	264.89	263.52	264.87	2170236.0
2022-07-21 16:00:00	MSFT	Stock	264.85	265.02	263.65	264.28	3394673.0
2022-07-21 17:00:00	MSFT	Stock	264.1	264.29	263.85	264.1	16926.0
2022-07-21 18:00:00	MSFT	Stock	264.1	264.15	263.53	264.0	12715.0
2022-07-21 19:00:00	MSFT	Stock	263.94	264.28	263.67	264.0	10650.0
2022-07-21 04:00:00	NVDA	Stock	17.682	17.703	17.575	17.65	247920.0
2022-07-21 05:00:00	NVDA	Stock	17.65	17.74	17.644	17.712	68220.0
2022-07-21 06:00:00	NVDA	Stock	17.709	17.82	17.709	17.739	111660.0
2022-07-21 07:00:00	NVDA	Stock	17.74	17.77	17.704	17.752	210300.0
2022-07-21 08:00:00	NVDA	Stock	17.7	18.027	17.585	17.98	3406400.0
2022-07-21 09:00:00	NVDA	Stock	17.97	17.992	17.646	17.893	66025850.0
2022-07-21 10:00:00	NVDA	Stock	17.882	18.024	17.5446	17.886	93838160.0
2022-07-21 11:00:00	NVDA	Stock	17.8865	17.9965	17.7456	17.97	64220720.0
2022-07-21 12:00:00	NVDA	Stock	17.97	18.144	17.9567	18.0485	56705440.0
2022-07-21 13:00:00	NVDA	Stock	18.049	18.06	17.851	17.94	38740910.0
2022-07-21 14:00:00	NVDA	Stock	17.943	17.999	17.876	17.935	33962480.0
2022-07-21 15:00:00	NVDA	Stock	17.935	18.061	17.872	18.05	57690630.0
2022-07-21 16:00:00	NVDA	Stock	18.05	18.077	17.7	17.8	22154130.0
2022-07-21 17:00:00	NVDA	Stock	17.775	17.82	17.712	17.76	792680.0
2022-07-21 18:00:00	NVDA	Stock	17.759	17.76	17.681	17.714	605720.0
2022-07-21 19:00:00	NVDA	Stock	17.716	17.76	17.69	17.69	562770.0
2022-07-21 04:00:00	AMZN	Stock	122.0	122.22	121.59	121.7	24341.0
2022-07-21 05:00:00	AMZN	Stock	121.89	122.62	121.85	122.56	26396.0

> showing 50 of 61,368 rows — these rows as CSV

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