PREVIEW / stock_1hour / 2022-01-24

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-01-24.parquet
  size:    1.5 MB
  rows:    70,214
  symbols: 2,718

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-01-24 04:00:00	AAPL	Stock	162.27	163.17	162.27	162.52	52744.0
2022-01-24 05:00:00	AAPL	Stock	162.33	162.33	160.12	161.4	160215.0
2022-01-24 06:00:00	AAPL	Stock	161.36	162.25	160.7	161.71	73118.0
2022-01-24 07:00:00	AAPL	Stock	161.62	162.11	160.01	160.27	336213.0
2022-01-24 08:00:00	AAPL	Stock	160.5201	161.7	158.9	159.4001	1494471.0
2022-01-24 09:00:00	AAPL	Stock	159.37	161.08	158.5	159.28	18798838.0
2022-01-24 10:00:00	AAPL	Stock	159.29	160.1303	157.64	158.47	19452718.0
2022-01-24 11:00:00	AAPL	Stock	158.46	158.72	156.38	157.2	15979914.0
2022-01-24 12:00:00	AAPL	Stock	157.19	157.42	154.7	156.95	17638176.0
2022-01-24 13:00:00	AAPL	Stock	156.95	158.89	156.78	158.83	13282444.0
2022-01-24 14:00:00	AAPL	Stock	158.83	159.58	156.02	157.84	13641510.0
2022-01-24 15:00:00	AAPL	Stock	157.84	162.3	157.39	162.19	19063976.0
2022-01-24 16:00:00	AAPL	Stock	162.25	162.25	160.81	161.73	15678453.0
2022-01-24 17:00:00	AAPL	Stock	161.75	161.79	160.98	161.44	64733.0
2022-01-24 18:00:00	AAPL	Stock	161.4399	161.4399	160.52	161.07	90963.0
2022-01-24 19:00:00	AAPL	Stock	161.13	161.62	159.32	159.75	200899.0
2022-01-24 04:00:00	MSFT	Stock	297.01	298.61	296.91	297.58	23227.0
2022-01-24 05:00:00	MSFT	Stock	297.27	297.49	294.52	295.24	51857.0
2022-01-24 06:00:00	MSFT	Stock	295.1	297.18	295.03	296.92	35107.0
2022-01-24 07:00:00	MSFT	Stock	296.77	297.39	295.13	295.43	82466.0
2022-01-24 08:00:00	MSFT	Stock	296.0198	297.5	292.9	292.9	231431.0
2022-01-24 09:00:00	MSFT	Stock	292.82	294.0	289.12	290.47	7249118.0
2022-01-24 10:00:00	MSFT	Stock	290.46	292.25	284.56	286.29	8240591.0
2022-01-24 11:00:00	MSFT	Stock	286.285	286.48	280.0	282.0	7613997.0
2022-01-24 12:00:00	MSFT	Stock	282.025	285.98	276.05	284.78	7881485.0
2022-01-24 13:00:00	MSFT	Stock	284.71	290.45	283.99	289.89	7503686.0
2022-01-24 14:00:00	MSFT	Stock	289.86	291.82	285.46	289.6	5840634.0
2022-01-24 15:00:00	MSFT	Stock	289.6	297.11	288.75	296.72	10142562.0
2022-01-24 16:00:00	MSFT	Stock	296.73	298.6	296.07	298.4	8330087.0
2022-01-24 17:00:00	MSFT	Stock	298.38	298.8	297.05	297.98	52020.0
2022-01-24 18:00:00	MSFT	Stock	297.84	298.8	296.72	298.05	104640.0
2022-01-24 19:00:00	MSFT	Stock	298.22	298.39	296.0	296.1	156007.0
2022-01-24 04:00:00	NVDA	Stock	23.496	23.505	23.101	23.2	255820.0
2022-01-24 05:00:00	NVDA	Stock	23.145	23.175	22.605	22.755	585900.0
2022-01-24 06:00:00	NVDA	Stock	22.8	22.99	22.771	22.91	518880.0
2022-01-24 07:00:00	NVDA	Stock	22.91	22.985	22.515	22.57	1473430.0
2022-01-24 08:00:00	NVDA	Stock	22.6503	23.374	22.115	22.28	6128300.0
2022-01-24 09:00:00	NVDA	Stock	22.255	22.915	21.874	21.885	96162980.0
2022-01-24 10:00:00	NVDA	Stock	21.8755	22.242	21.5	21.9985	124134140.0
2022-01-24 11:00:00	NVDA	Stock	22.0018	22.0018	21.337	21.575	81341040.0
2022-01-24 12:00:00	NVDA	Stock	21.565	21.686	20.888	21.566	80834230.0
2022-01-24 13:00:00	NVDA	Stock	21.556	22.306	21.499	22.303	69792500.0
2022-01-24 14:00:00	NVDA	Stock	22.303	22.574	21.955	22.506	70256840.0
2022-01-24 15:00:00	NVDA	Stock	22.516	23.38	22.3561	23.376	100208640.0
2022-01-24 16:00:00	NVDA	Stock	23.365	23.428	23.197	23.417	30849040.0
2022-01-24 17:00:00	NVDA	Stock	23.4	23.46	23.301	23.315	398920.0
2022-01-24 18:00:00	NVDA	Stock	23.301	23.31	23.012	23.16	432430.0
2022-01-24 19:00:00	NVDA	Stock	23.172	23.372	23.0	23.175	1039390.0
2022-01-24 04:00:00	AMZN	Stock	143.343	143.4	143.2	143.25	22380.0
2022-01-24 05:00:00	AMZN	Stock	141.25	141.45	141.1	141.351	20680.0

> showing 50 of 70,214 rows — these rows as CSV

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