PREVIEW / stock_1hour / 2022-02-24

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-02-24.parquet
  size:    1.5 MB
  rows:    70,716
  symbols: 2,638

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-02-24 04:00:00	AAPL	Stock	158.1	158.1	155.0	155.59	118628.0
2022-02-24 05:00:00	AAPL	Stock	155.51	156.06	154.71	154.83	99867.0
2022-02-24 06:00:00	AAPL	Stock	155.0	155.91	154.13	155.83	138959.0
2022-02-24 07:00:00	AAPL	Stock	155.83	155.98	152.85	153.58	883036.0
2022-02-24 08:00:00	AAPL	Stock	155.1001	156.5	152.75	153.8	1848047.0
2022-02-24 09:00:00	AAPL	Stock	153.82	156.91	151.9	156.4829	24828164.0
2022-02-24 10:00:00	AAPL	Stock	156.48	157.8	154.96	156.91	19394182.0
2022-02-24 11:00:00	AAPL	Stock	156.91	158.68	156.73	158.44	11898128.0
2022-02-24 12:00:00	AAPL	Stock	158.43	158.83	156.7	157.18	9552410.0
2022-02-24 13:00:00	AAPL	Stock	157.16	159.93	156.91	158.84	8874474.0
2022-02-24 14:00:00	AAPL	Stock	158.83	160.91	158.29	160.49	10230735.0
2022-02-24 15:00:00	AAPL	Stock	160.5	162.85	160.27	162.77	16890020.0
2022-02-24 16:00:00	AAPL	Stock	162.74	162.74	161.25	162.17	12797958.0
2022-02-24 17:00:00	AAPL	Stock	162.28	162.74	161.91	162.16	106890.0
2022-02-24 18:00:00	AAPL	Stock	161.95	161.95	160.75	160.98	113784.0
2022-02-24 19:00:00	AAPL	Stock	160.99	162.5	160.96	161.25	117522.0
2022-02-24 04:00:00	MSFT	Stock	273.39	276.0	272.35	272.69	22227.0
2022-02-24 05:00:00	MSFT	Stock	272.46	273.35	271.38	271.65	12378.0
2022-02-24 06:00:00	MSFT	Stock	271.55	272.54	270.0	272.54	39264.0
2022-02-24 07:00:00	MSFT	Stock	271.94	272.5	270.31	271.2	194358.0
2022-02-24 08:00:00	MSFT	Stock	270.7823	280.97	270.0	271.2	219137.0
2022-02-24 09:00:00	MSFT	Stock	271.0	280.27	271.0	277.935	6654865.0
2022-02-24 10:00:00	MSFT	Stock	277.91	283.65	276.77	282.73	5690026.0
2022-02-24 11:00:00	MSFT	Stock	282.78	286.47	282.3906	284.91	4567238.0
2022-02-24 12:00:00	MSFT	Stock	284.915	285.16	281.51	283.16	2720250.0
2022-02-24 13:00:00	MSFT	Stock	283.17	288.5136	282.73	286.07	3284272.0
2022-02-24 14:00:00	MSFT	Stock	286.02	290.16	285.18	289.75	3480239.0
2022-02-24 15:00:00	MSFT	Stock	289.75	295.16	289.07	294.58	7618909.0
2022-02-24 16:00:00	MSFT	Stock	294.58	294.95	287.0917	294.0	6987386.0
2022-02-24 17:00:00	MSFT	Stock	293.5	294.59	293.05	293.14	34561.0
2022-02-24 18:00:00	MSFT	Stock	293.14	293.2	291.5	292.6	26547.0
2022-02-24 19:00:00	MSFT	Stock	292.0	294.58	292.0	292.25	23758.0
2022-02-24 04:00:00	NVDA	Stock	21.0	21.698	21.0	21.253	779120.0
2022-02-24 05:00:00	NVDA	Stock	21.27	21.38	21.103	21.275	358380.0
2022-02-24 06:00:00	NVDA	Stock	21.27	21.348	21.051	21.288	537250.0
2022-02-24 07:00:00	NVDA	Stock	21.232	21.301	20.6	20.781	3959830.0
2022-02-24 08:00:00	NVDA	Stock	21.0704	21.364	20.601	20.939	5849800.0
2022-02-24 09:00:00	NVDA	Stock	20.925	22.112	20.825	22.045	95301630.0
2022-02-24 10:00:00	NVDA	Stock	22.042	22.561	21.712	22.401	107401440.0
2022-02-24 11:00:00	NVDA	Stock	22.41	22.609	22.17	22.4884	71890360.0
2022-02-24 12:00:00	NVDA	Stock	22.4895	22.521	22.1052	22.253	45627000.0
2022-02-24 13:00:00	NVDA	Stock	22.248	22.883	22.213	22.696	53710410.0
2022-02-24 14:00:00	NVDA	Stock	22.692	23.189	22.522	23.1155	57139060.0
2022-02-24 15:00:00	NVDA	Stock	23.121	23.8	23.073	23.751	82643880.0
2022-02-24 16:00:00	NVDA	Stock	23.747	23.807	23.35	23.57	36170260.0
2022-02-24 17:00:00	NVDA	Stock	23.55	23.748	23.5	23.5	883680.0
2022-02-24 18:00:00	NVDA	Stock	23.5	23.525	23.127	23.25	942750.0
2022-02-24 19:00:00	NVDA	Stock	23.252	23.45	23.23	23.339	694740.0
2022-02-24 04:00:00	AMZN	Stock	141.0	141.0	140.601	140.601	10340.0
2022-02-24 05:00:00	AMZN	Stock	140.5715	140.594	140.0	140.35	25640.0

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

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