PREVIEW / stock_1hour / 2021-08-19

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-08-19.parquet
  size:    1.4 MB
  rows:    66,954
  symbols: 2,801

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
2021-08-19 04:00:00	AAPL	Stock	145.66	145.66	144.24	144.62	85397.0
2021-08-19 05:00:00	AAPL	Stock	144.61	145.46	144.46	145.3	70123.0
2021-08-19 06:00:00	AAPL	Stock	145.42	145.65	145.0	145.09	35718.0
2021-08-19 07:00:00	AAPL	Stock	145.1	145.3	144.56	144.75	333954.0
2021-08-19 08:00:00	AAPL	Stock	144.75	145.48	144.57	144.68	775121.0
2021-08-19 09:00:00	AAPL	Stock	144.68	146.2899	144.5	145.11	13922904.0
2021-08-19 10:00:00	AAPL	Stock	145.11	146.52	145.1	146.3713	11363325.0
2021-08-19 11:00:00	AAPL	Stock	146.379	147.67	146.19	147.62	9472523.0
2021-08-19 12:00:00	AAPL	Stock	147.62	148.0	147.22	147.623	7331201.0
2021-08-19 13:00:00	AAPL	Stock	147.625	147.75	146.7	146.81	6998988.0
2021-08-19 14:00:00	AAPL	Stock	146.81	146.96	145.84	146.835	8318969.0
2021-08-19 15:00:00	AAPL	Stock	146.83	147.3	146.35	146.67	10532383.0
2021-08-19 16:00:00	AAPL	Stock	146.7	146.85	146.43	146.67	8449999.0
2021-08-19 17:00:00	AAPL	Stock	146.68	146.74	146.65	146.65	16017.0
2021-08-19 18:00:00	AAPL	Stock	146.65	146.75	146.63	146.7	18671.0
2021-08-19 19:00:00	AAPL	Stock	146.68	146.71	146.56	146.56	48358.0
2021-08-19 04:00:00	MSFT	Stock	289.4	289.56	287.25	287.79	25341.0
2021-08-19 05:00:00	MSFT	Stock	287.6	289.4	287.48	289.0	15507.0
2021-08-19 06:00:00	MSFT	Stock	288.97	289.47	288.22	288.22	5731.0
2021-08-19 07:00:00	MSFT	Stock	288.61	289.15	288.25	288.39	33186.0
2021-08-19 08:00:00	MSFT	Stock	288.361	291.456	288.26	288.35	938748.0
2021-08-19 09:00:00	MSFT	Stock	288.38	291.64	288.38	290.76	2261573.0
2021-08-19 10:00:00	MSFT	Stock	290.77	292.9	290.69	292.8	2025981.0
2021-08-19 11:00:00	MSFT	Stock	292.8	294.65	292.55	294.43	1833046.0
2021-08-19 12:00:00	MSFT	Stock	294.47	296.89	294.465	296.79	4112734.0
2021-08-19 13:00:00	MSFT	Stock	296.77	296.96	295.785	296.09	2155907.0
2021-08-19 14:00:00	MSFT	Stock	296.1	296.42	294.99	296.35	2207466.0
2021-08-19 15:00:00	MSFT	Stock	296.335	297.47	296.31	296.81	4234164.0
2021-08-19 16:00:00	MSFT	Stock	296.77	297.1	296.67	296.93	3292477.0
2021-08-19 17:00:00	MSFT	Stock	296.99	297.1	296.63	296.63	13160.0
2021-08-19 18:00:00	MSFT	Stock	296.87	296.94	296.66	296.79	6771.0
2021-08-19 19:00:00	MSFT	Stock	296.75	296.75	296.31	296.31	6987.0
2021-08-19 04:00:00	NVDA	Stock	19.28	19.45	19.145	19.28	481350.0
2021-08-19 05:00:00	NVDA	Stock	19.279	19.452	19.194	19.45	224700.0
2021-08-19 06:00:00	NVDA	Stock	19.45	19.467	19.3	19.34	117680.0
2021-08-19 07:00:00	NVDA	Stock	19.341	19.48	19.233	19.325	889720.0
2021-08-19 08:00:00	NVDA	Stock	19.2864	19.451	19.04	19.195	5073220.0
2021-08-19 09:00:00	NVDA	Stock	19.2	19.506	18.762	18.937	75530700.0
2021-08-19 10:00:00	NVDA	Stock	18.926	19.548	18.924	19.5436	78606690.0
2021-08-19 11:00:00	NVDA	Stock	19.543	20.484	19.543	20.408	169697480.0
2021-08-19 12:00:00	NVDA	Stock	20.413	20.495	20.097	20.1561	72221880.0
2021-08-19 13:00:00	NVDA	Stock	20.159	20.1638	19.891	19.911	47954440.0
2021-08-19 14:00:00	NVDA	Stock	19.911	19.917	19.507	19.7845	81924280.0
2021-08-19 15:00:00	NVDA	Stock	19.7845	19.9857	19.703	19.794	80029500.0
2021-08-19 16:00:00	NVDA	Stock	19.798	19.865	19.785	19.81	14016430.0
2021-08-19 17:00:00	NVDA	Stock	19.802	19.825	19.775	19.78	254120.0
2021-08-19 18:00:00	NVDA	Stock	19.8	19.817	19.798	19.815	100820.0
2021-08-19 19:00:00	NVDA	Stock	19.819	19.829	19.78	19.785	281330.0
2021-08-19 04:00:00	AMZN	Stock	158.83	158.83	158.75	158.75	18740.0
2021-08-19 05:00:00	AMZN	Stock	159.0	159.0	159.0	159.0	11460.0

> showing 50 of 66,954 rows — these rows as CSV

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