PREVIEW / stock_1hour / 2022-03-16

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-03-16.parquet
  size:    1.4 MB
  rows:    66,114
  symbols: 2,524

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-03-16 04:00:00	AAPL	Stock	156.7	158.38	156.23	158.09	115078.0
2022-03-16 05:00:00	AAPL	Stock	158.11	158.21	157.75	157.8	25246.0
2022-03-16 06:00:00	AAPL	Stock	157.79	158.35	157.61	158.0	69529.0
2022-03-16 07:00:00	AAPL	Stock	158.11	158.34	157.4	158.29	236711.0
2022-03-16 08:00:00	AAPL	Stock	157.6501	158.55	155.78	157.63	875095.0
2022-03-16 09:00:00	AAPL	Stock	157.62	157.73	155.53	157.365	10597661.0
2022-03-16 10:00:00	AAPL	Stock	157.37	158.64	156.55	158.42	12640506.0
2022-03-16 11:00:00	AAPL	Stock	158.42	158.49	157.635	158.0869	6861561.0
2022-03-16 12:00:00	AAPL	Stock	158.09	158.3	157.21	157.305	5846434.0
2022-03-16 13:00:00	AAPL	Stock	157.305	157.48	156.53	157.3504	6026283.0
2022-03-16 14:00:00	AAPL	Stock	157.33	157.56	154.46	157.11	15061726.0
2022-03-16 15:00:00	AAPL	Stock	157.12	160.0	156.75	159.59	15883486.0
2022-03-16 16:00:00	AAPL	Stock	159.49	160.2	159.2	159.78	12159920.0
2022-03-16 17:00:00	AAPL	Stock	159.74	159.78	159.37	159.57	128315.0
2022-03-16 18:00:00	AAPL	Stock	159.58	159.6	159.14	159.18	78101.0
2022-03-16 19:00:00	AAPL	Stock	159.18	159.39	159.05	159.25	59520.0
2022-03-16 04:00:00	MSFT	Stock	290.72	292.0	290.1	291.5	14101.0
2022-03-16 05:00:00	MSFT	Stock	292.0	292.69	291.89	292.11	4617.0
2022-03-16 06:00:00	MSFT	Stock	292.14	292.45	291.45	292.25	15140.0
2022-03-16 07:00:00	MSFT	Stock	292.02	292.3	291.29	291.9	32185.0
2022-03-16 08:00:00	MSFT	Stock	291.78	292.5	288.0	289.58	106402.0
2022-03-16 09:00:00	MSFT	Stock	289.97	292.23	288.72	290.635	3065592.0
2022-03-16 10:00:00	MSFT	Stock	290.63	292.81	289.775	291.8174	3223358.0
2022-03-16 11:00:00	MSFT	Stock	291.78	291.9	290.7	291.01	1842302.0
2022-03-16 12:00:00	MSFT	Stock	290.99	291.6	289.0	289.42	1944342.0
2022-03-16 13:00:00	MSFT	Stock	289.43	289.54	287.69	289.075	1974279.0
2022-03-16 14:00:00	MSFT	Stock	289.02	289.77	283.2	288.6525	4368772.0
2022-03-16 15:00:00	MSFT	Stock	288.67	294.57	288.19	294.42	5310280.0
2022-03-16 16:00:00	MSFT	Stock	294.46	296.0	293.91	295.2	5799583.0
2022-03-16 17:00:00	MSFT	Stock	295.2	295.6081	294.82	295.22	40970.0
2022-03-16 18:00:00	MSFT	Stock	295.15	295.15	294.05	294.05	25899.0
2022-03-16 19:00:00	MSFT	Stock	294.22	295.4	293.8	295.35	11438.0
2022-03-16 04:00:00	NVDA	Stock	23.5	23.684	23.2	23.494	342010.0
2022-03-16 05:00:00	NVDA	Stock	23.493	23.595	23.493	23.591	140100.0
2022-03-16 06:00:00	NVDA	Stock	23.54	23.6	23.528	23.57	119550.0
2022-03-16 07:00:00	NVDA	Stock	23.57	23.675	23.5	23.659	696210.0
2022-03-16 08:00:00	NVDA	Stock	23.5817	23.778	23.367	23.6	1822120.0
2022-03-16 09:00:00	NVDA	Stock	23.581	23.774	23.172	23.709	56242250.0
2022-03-16 10:00:00	NVDA	Stock	23.72	24.597	23.72	24.231	103014370.0
2022-03-16 11:00:00	NVDA	Stock	24.237	24.347	24.109	24.285	41557780.0
2022-03-16 12:00:00	NVDA	Stock	24.286	24.43	23.8568	23.917	39804790.0
2022-03-16 13:00:00	NVDA	Stock	23.92	23.98	23.457	23.9759	58502950.0
2022-03-16 14:00:00	NVDA	Stock	23.968	24.259	23.205	24.043	95712930.0
2022-03-16 15:00:00	NVDA	Stock	24.049	24.5	23.94	24.5	71112290.0
2022-03-16 16:00:00	NVDA	Stock	24.496	24.719	24.424	24.5524	26306810.0
2022-03-16 17:00:00	NVDA	Stock	24.56	24.647	24.53	24.599	468910.0
2022-03-16 18:00:00	NVDA	Stock	24.599	24.6	24.544	24.57	457450.0
2022-03-16 19:00:00	NVDA	Stock	24.555	24.6	24.501	24.55	367760.0
2022-03-16 04:00:00	AMZN	Stock	149.4	149.4	149.4	149.4	2000.0
2022-03-16 05:00:00	AMZN	Stock	149.55	149.75	149.55	149.75	27980.0

> showing 50 of 66,114 rows — these rows as CSV

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