PREVIEW / stock_1hour / 2022-06-02

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-06-02.parquet
  size:    1.4 MB
  rows:    62,046
  symbols: 2,369

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-06-02 04:00:00	AAPL	Stock	148.57	149.6	148.57	149.29	25352.0
2022-06-02 05:00:00	AAPL	Stock	149.23	149.48	149.23	149.34	5100.0
2022-06-02 06:00:00	AAPL	Stock	149.34	149.7	149.19	149.6	27413.0
2022-06-02 07:00:00	AAPL	Stock	149.58	149.65	149.24	149.41	76407.0
2022-06-02 08:00:00	AAPL	Stock	149.4	149.56	148.66	148.7	415392.0
2022-06-02 09:00:00	AAPL	Stock	148.74	148.92	146.86	148.1601	8611480.0
2022-06-02 10:00:00	AAPL	Stock	148.16	149.03	147.24	148.23	10695785.0
2022-06-02 11:00:00	AAPL	Stock	148.21	149.9399	148.11	149.4412	8943813.0
2022-06-02 12:00:00	AAPL	Stock	149.45	150.69	149.3512	150.48	6833357.0
2022-06-02 13:00:00	AAPL	Stock	150.49	150.6153	149.96	150.305	4775844.0
2022-06-02 14:00:00	AAPL	Stock	150.31	150.83	150.0701	150.11	5180945.0
2022-06-02 15:00:00	AAPL	Stock	150.1091	151.27	150.06	151.23	10307274.0
2022-06-02 16:00:00	AAPL	Stock	151.2	151.21	150.8	151.15	6967523.0
2022-06-02 17:00:00	AAPL	Stock	151.1599	151.21	151.03	151.0902	35833.0
2022-06-02 18:00:00	AAPL	Stock	151.1	151.49	151.1	151.41	53134.0
2022-06-02 19:00:00	AAPL	Stock	151.41	151.6	151.41	151.55	57050.0
2022-06-02 04:00:00	MSFT	Stock	274.06	275.0	273.71	274.4	2772.0
2022-06-02 05:00:00	MSFT	Stock	274.1	274.46	274.0	274.4	2599.0
2022-06-02 06:00:00	MSFT	Stock	274.35	274.7	274.35	274.53	2954.0
2022-06-02 07:00:00	MSFT	Stock	274.5	274.89	274.0	274.31	20870.0
2022-06-02 08:00:00	MSFT	Stock	274.68	274.87	273.21	273.4001	27429.0
2022-06-02 09:00:00	MSFT	Stock	273.403	275.88	261.6	266.21	9011540.0
2022-06-02 10:00:00	MSFT	Stock	266.17	267.76	264.54	266.276	4279214.0
2022-06-02 11:00:00	MSFT	Stock	266.27	269.05	266.06	268.0305	3497685.0
2022-06-02 12:00:00	MSFT	Stock	268.05	270.84	267.8	270.67	3197422.0
2022-06-02 13:00:00	MSFT	Stock	270.6928	272.38	270.4	272.365	2832535.0
2022-06-02 14:00:00	MSFT	Stock	272.375	273.6399	272.05	272.38	2911482.0
2022-06-02 15:00:00	MSFT	Stock	272.37	274.65	272.26	274.63	4843556.0
2022-06-02 16:00:00	MSFT	Stock	274.62	274.71	273.44	274.0858	3059442.0
2022-06-02 17:00:00	MSFT	Stock	274.2	274.25	274.0	274.1	13009.0
2022-06-02 18:00:00	MSFT	Stock	274.1	274.74	274.07	274.58	18707.0
2022-06-02 19:00:00	MSFT	Stock	274.58	274.95	274.22	274.7	12610.0
2022-06-02 04:00:00	NVDA	Stock	18.408	18.544	18.398	18.47	166320.0
2022-06-02 05:00:00	NVDA	Stock	18.471	18.5	18.457	18.496	43120.0
2022-06-02 06:00:00	NVDA	Stock	18.482	18.556	18.46	18.55	145830.0
2022-06-02 07:00:00	NVDA	Stock	18.532	18.54	18.457	18.51	478060.0
2022-06-02 08:00:00	NVDA	Stock	18.4905	18.54	18.399	18.41	1191600.0
2022-06-02 09:00:00	NVDA	Stock	18.418	18.8164	18.198	18.752	79316120.0
2022-06-02 10:00:00	NVDA	Stock	18.748	19.145	18.688	18.9779	106043060.0
2022-06-02 11:00:00	NVDA	Stock	18.976	19.507	18.9547	19.3144	86646880.0
2022-06-02 12:00:00	NVDA	Stock	19.314	19.547	19.305	19.4985	47982640.0
2022-06-02 13:00:00	NVDA	Stock	19.5	19.6	19.42	19.55	47752860.0
2022-06-02 14:00:00	NVDA	Stock	19.5505	19.619	19.371	19.3809	50175960.0
2022-06-02 15:00:00	NVDA	Stock	19.3813	19.603	19.3632	19.592	71866950.0
2022-06-02 16:00:00	NVDA	Stock	19.592	19.596	19.557	19.591	22770690.0
2022-06-02 17:00:00	NVDA	Stock	19.592	19.637	19.585	19.611	383240.0
2022-06-02 18:00:00	NVDA	Stock	19.615	19.778	19.604	19.71	890940.0
2022-06-02 19:00:00	NVDA	Stock	19.71	19.745	19.697	19.711	450660.0
2022-06-02 04:00:00	AMZN	Stock	123.25	123.25	123.175	123.175	5000.0
2022-06-02 06:00:00	AMZN	Stock	122.9305	123.005	122.78	123.005	9560.0

> showing 50 of 62,046 rows — these rows as CSV

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