PREVIEW / stock_1hour / 2023-03-22

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-03-22.parquet
  size:    1.3 MB
  rows:    59,766
  symbols: 1,731

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-22 04:00:00	AAPL	Stock	158.0	158.85	158.0	158.21	17120.0
2023-03-22 05:00:00	AAPL	Stock	158.16	160.0	158.09	158.61	18813.0
2023-03-22 06:00:00	AAPL	Stock	158.7	158.77	158.44	158.77	10373.0
2023-03-22 07:00:00	AAPL	Stock	158.78	159.12	158.55	158.77	42767.0
2023-03-22 08:00:00	AAPL	Stock	158.79	159.25	158.2885	158.89	102292.0
2023-03-22 09:00:00	AAPL	Stock	158.93	159.99	158.8	159.72	5383440.0
2023-03-22 10:00:00	AAPL	Stock	159.73	160.41	159.118	160.2	8178168.0
2023-03-22 11:00:00	AAPL	Stock	160.1909	160.52	159.89	160.46	4538413.0
2023-03-22 12:00:00	AAPL	Stock	160.46	160.46	159.47	159.7574	4081792.0
2023-03-22 13:00:00	AAPL	Stock	159.75	160.26	159.61	160.11	3829835.0
2023-03-22 14:00:00	AAPL	Stock	160.11	162.14	159.825	160.3954	13219097.0
2023-03-22 15:00:00	AAPL	Stock	160.39	160.95	157.81	157.815	16159592.0
2023-03-22 16:00:00	AAPL	Stock	157.82	158.2	157.5732	158.0	5195562.0
2023-03-22 17:00:00	AAPL	Stock	158.08	158.1	157.91	158.0	53055.0
2023-03-22 18:00:00	AAPL	Stock	158.0	158.38	157.93	158.19	35348.0
2023-03-22 19:00:00	AAPL	Stock	158.2	158.7	158.06	158.42	27471.0
2023-03-22 04:00:00	MSFT	Stock	273.08	273.08	271.98	272.48	7687.0
2023-03-22 05:00:00	MSFT	Stock	272.14	273.33	271.92	272.74	3116.0
2023-03-22 06:00:00	MSFT	Stock	272.91	273.0	272.31	272.95	3275.0
2023-03-22 07:00:00	MSFT	Stock	272.84	273.65	272.84	273.01	14423.0
2023-03-22 08:00:00	MSFT	Stock	272.8283	274.23	271.8915	273.23	32902.0
2023-03-22 09:00:00	MSFT	Stock	273.328	274.24	272.62	273.14	1840239.0
2023-03-22 10:00:00	MSFT	Stock	273.13	277.3	272.85	276.09	4029150.0
2023-03-22 11:00:00	MSFT	Stock	276.07	278.26	275.6	277.85	2272561.0
2023-03-22 12:00:00	MSFT	Stock	277.86	277.89	275.764	276.94	1888368.0
2023-03-22 13:00:00	MSFT	Stock	276.94	277.41	276.49	277.285	1301464.0
2023-03-22 14:00:00	MSFT	Stock	277.34	281.04	276.37	277.16	5047722.0
2023-03-22 15:00:00	MSFT	Stock	277.17	278.57	272.18	272.28	5877799.0
2023-03-22 16:00:00	MSFT	Stock	272.28	273.23	271.85	272.82	4025473.0
2023-03-22 17:00:00	MSFT	Stock	272.87	273.0	272.75	272.9318	20599.0
2023-03-22 18:00:00	MSFT	Stock	272.87	273.3	272.85	273.25	15742.0
2023-03-22 19:00:00	MSFT	Stock	273.25	273.3	272.89	273.0	12323.0
2023-03-22 04:00:00	NVDA	Stock	26.191	26.241	26.061	26.124	183250.0
2023-03-22 05:00:00	NVDA	Stock	26.1	26.16	26.1	26.145	31190.0
2023-03-22 06:00:00	NVDA	Stock	26.15	26.342	26.136	26.329	183890.0
2023-03-22 07:00:00	NVDA	Stock	26.329	26.415	26.266	26.282	681240.0
2023-03-22 08:00:00	NVDA	Stock	26.07	26.4239	26.07	26.3244	1677320.0
2023-03-22 09:00:00	NVDA	Stock	26.305	26.927	26.237	26.883	90725220.0
2023-03-22 10:00:00	NVDA	Stock	26.8798	27.077	26.836	26.91	101944370.0
2023-03-22 11:00:00	NVDA	Stock	26.9045	27.183	26.87	27.1042	75607690.0
2023-03-22 12:00:00	NVDA	Stock	27.104	27.132	26.8945	26.939	48901100.0
2023-03-22 13:00:00	NVDA	Stock	26.9395	27.097	26.856	27.065	40294690.0
2023-03-22 14:00:00	NVDA	Stock	27.065	27.589	27.027	27.2	130483660.0
2023-03-22 15:00:00	NVDA	Stock	27.1995	27.389	26.439	26.46	126585340.0
2023-03-22 16:00:00	NVDA	Stock	26.455	26.62	26.4228	26.591	20825440.0
2023-03-22 17:00:00	NVDA	Stock	26.597	26.613	26.551	26.57	607490.0
2023-03-22 18:00:00	NVDA	Stock	26.57	26.712	26.57	26.7	689930.0
2023-03-22 19:00:00	NVDA	Stock	26.701	26.72	26.651	26.68	760930.0
2023-03-22 04:00:00	AMZN	Stock	100.14	100.2	99.67	99.81	22439.0
2023-03-22 05:00:00	AMZN	Stock	99.82	100.12	99.71	99.9	11798.0

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

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