PREVIEW / stock_1hour / 2023-03-27

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-03-27.parquet
  size:    1.3 MB
  rows:    59,896
  symbols: 1,770

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
2023-03-27 04:00:00	AAPL	Stock	160.25	160.25	159.38	159.82	20666.0
2023-03-27 05:00:00	AAPL	Stock	159.79	159.87	159.52	159.6	12826.0
2023-03-27 06:00:00	AAPL	Stock	159.77	160.11	159.66	159.84	8361.0
2023-03-27 07:00:00	AAPL	Stock	159.88	160.22	159.84	160.12	98075.0
2023-03-27 08:00:00	AAPL	Stock	160.11	160.25	159.72	159.8	285145.0
2023-03-27 09:00:00	AAPL	Stock	159.8	160.77	159.45	160.365	6541899.0
2023-03-27 10:00:00	AAPL	Stock	160.37	160.72	159.62	159.7605	6193345.0
2023-03-27 11:00:00	AAPL	Stock	159.76	159.83	158.4	158.44	5061149.0
2023-03-27 12:00:00	AAPL	Stock	158.4365	158.83	158.04	158.2789	4172481.0
2023-03-27 13:00:00	AAPL	Stock	158.28	158.5997	157.87	158.29	3910214.0
2023-03-27 14:00:00	AAPL	Stock	158.3	159.0634	158.11	159.06	3749023.0
2023-03-27 15:00:00	AAPL	Stock	159.06	159.21	157.97	158.3	7046826.0
2023-03-27 16:00:00	AAPL	Stock	158.31	158.38	158.09	158.25	6708720.0
2023-03-27 17:00:00	AAPL	Stock	158.25	158.28	158.12	158.2	27321.0
2023-03-27 18:00:00	AAPL	Stock	158.18	158.21	158.03	158.18	26809.0
2023-03-27 19:00:00	AAPL	Stock	158.18	158.48	158.18	158.37	30394.0
2023-03-27 04:00:00	MSFT	Stock	280.19	281.5	280.0	281.29	9193.0
2023-03-27 05:00:00	MSFT	Stock	281.2	281.5	280.91	281.04	4005.0
2023-03-27 06:00:00	MSFT	Stock	281.4	281.79	281.4	281.5	10024.0
2023-03-27 07:00:00	MSFT	Stock	281.5	281.82	280.73	280.75	33446.0
2023-03-27 08:00:00	MSFT	Stock	280.88	281.99	279.869	280.25	75627.0
2023-03-27 09:00:00	MSFT	Stock	280.4	281.4589	278.51	280.1908	2974606.0
2023-03-27 10:00:00	MSFT	Stock	280.19	281.4	278.22	278.27	3035850.0
2023-03-27 11:00:00	MSFT	Stock	278.27	278.315	275.73	275.9373	2839792.0
2023-03-27 12:00:00	MSFT	Stock	275.95	276.9135	275.57	276.42	1827683.0
2023-03-27 13:00:00	MSFT	Stock	276.44	276.84	275.52	276.44	1653184.0
2023-03-27 14:00:00	MSFT	Stock	276.44	277.17	275.9	276.8301	1579829.0
2023-03-27 15:00:00	MSFT	Stock	276.88	277.24	275.7243	276.38	3421592.0
2023-03-27 16:00:00	MSFT	Stock	276.38	276.8	276.0	276.5	3559671.0
2023-03-27 17:00:00	MSFT	Stock	276.46	276.6518	276.15	276.15	30705.0
2023-03-27 18:00:00	MSFT	Stock	276.554	276.554	276.2	276.49	10590.0
2023-03-27 19:00:00	MSFT	Stock	276.57	276.75	276.2701	276.75	9672.0
2023-03-27 04:00:00	NVDA	Stock	26.74	26.838	26.713	26.821	90420.0
2023-03-27 05:00:00	NVDA	Stock	26.84	26.88	26.794	26.848	149800.0
2023-03-27 06:00:00	NVDA	Stock	26.88	26.945	26.855	26.9	131700.0
2023-03-27 07:00:00	NVDA	Stock	26.9	27.045	26.9	26.97	819920.0
2023-03-27 08:00:00	NVDA	Stock	26.9	27.049	26.805	26.855	1421210.0
2023-03-27 09:00:00	NVDA	Stock	26.862	27.0	26.619	26.836	45046170.0
2023-03-27 10:00:00	NVDA	Stock	26.8355	26.994	26.706	26.714	50760580.0
2023-03-27 11:00:00	NVDA	Stock	26.714	26.7481	26.365	26.411	45288530.0
2023-03-27 12:00:00	NVDA	Stock	26.4091	26.569	26.37	26.537	35034100.0
2023-03-27 13:00:00	NVDA	Stock	26.54	26.697	26.485	26.595	32126300.0
2023-03-27 14:00:00	NVDA	Stock	26.6	26.7067	26.522	26.6666	29500500.0
2023-03-27 15:00:00	NVDA	Stock	26.67	26.704	26.462	26.542	37237860.0
2023-03-27 16:00:00	NVDA	Stock	26.542	26.5707	26.5	26.535	14609990.0
2023-03-27 17:00:00	NVDA	Stock	26.536	26.545	26.53	26.545	98210.0
2023-03-27 18:00:00	NVDA	Stock	26.539	26.555	26.524	26.553	162340.0
2023-03-27 19:00:00	NVDA	Stock	26.553	26.58	26.54	26.568	206020.0
2023-03-27 04:00:00	AMZN	Stock	98.1	98.15	97.81	98.15	4999.0
2023-03-27 05:00:00	AMZN	Stock	98.11	98.39	98.06	98.14	5297.0

> showing 50 of 59,896 rows — these rows as CSV

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