PREVIEW / stock_1hour / 2022-03-11

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-03-11.parquet
  size:    1.4 MB
  rows:    63,854
  symbols: 2,495

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-03-11 04:00:00	AAPL	Stock	158.4	159.39	158.4	159.37	20123.0
2022-03-11 05:00:00	AAPL	Stock	159.39	159.54	159.0	159.22	11608.0
2022-03-11 06:00:00	AAPL	Stock	159.22	162.0	159.1	161.1	89254.0
2022-03-11 07:00:00	AAPL	Stock	161.14	161.29	160.17	160.19	290702.0
2022-03-11 08:00:00	AAPL	Stock	160.5421	161.01	158.52	159.94	811900.0
2022-03-11 09:00:00	AAPL	Stock	159.92	160.0	156.97	157.65	10922048.0
2022-03-11 10:00:00	AAPL	Stock	157.66	158.125	156.93	157.865	9583318.0
2022-03-11 11:00:00	AAPL	Stock	157.861	157.89	154.78	155.5	13646914.0
2022-03-11 12:00:00	AAPL	Stock	155.5	155.605	154.74	155.3833	9647598.0
2022-03-11 13:00:00	AAPL	Stock	155.39	156.795	155.28	156.09	8520586.0
2022-03-11 14:00:00	AAPL	Stock	156.09	156.61	155.62	155.9	7105289.0
2022-03-11 15:00:00	AAPL	Stock	155.91	156.02	154.5	154.73	14437336.0
2022-03-11 16:00:00	AAPL	Stock	154.75	154.96	154.42	154.42	8746638.0
2022-03-11 17:00:00	AAPL	Stock	154.48	154.72	154.41	154.62	48737.0
2022-03-11 18:00:00	AAPL	Stock	154.67	154.68	154.33	154.49	41629.0
2022-03-11 19:00:00	AAPL	Stock	154.49	154.59	154.44	154.44	72849.0
2022-03-11 04:00:00	MSFT	Stock	285.24	286.67	285.24	286.67	4867.0
2022-03-11 05:00:00	MSFT	Stock	286.8	287.41	286.71	286.71	2024.0
2022-03-11 06:00:00	MSFT	Stock	286.3	293.0	286.0	290.0	12541.0
2022-03-11 07:00:00	MSFT	Stock	289.89	291.51	289.4	289.5	44154.0
2022-03-11 08:00:00	MSFT	Stock	290.0	291.5	288.5	288.88	71850.0
2022-03-11 09:00:00	MSFT	Stock	288.85	289.51	286.11	286.8676	2144145.0
2022-03-11 10:00:00	MSFT	Stock	286.79	288.08	284.93	287.28	2552338.0
2022-03-11 11:00:00	MSFT	Stock	287.27	287.3	283.84	284.5	1718258.0
2022-03-11 12:00:00	MSFT	Stock	284.46	285.21	283.25	284.24	1408355.0
2022-03-11 13:00:00	MSFT	Stock	284.23	286.29	284.01	284.51	1447310.0
2022-03-11 14:00:00	MSFT	Stock	284.51	285.72	283.17	283.82	1343072.0
2022-03-11 15:00:00	MSFT	Stock	283.84	283.88	279.43	280.02	4045883.0
2022-03-11 16:00:00	MSFT	Stock	280.07	280.65	279.5	280.02	5047826.0
2022-03-11 17:00:00	MSFT	Stock	280.12	280.12	279.8088	279.9983	3761.0
2022-03-11 18:00:00	MSFT	Stock	279.95	280.0	279.58	279.9	5041.0
2022-03-11 19:00:00	MSFT	Stock	279.9	279.9	279.65	279.65	4737.0
2022-03-11 04:00:00	NVDA	Stock	22.6	22.899	22.6	22.881	85110.0
2022-03-11 05:00:00	NVDA	Stock	22.897	23.06	22.897	23.05	179110.0
2022-03-11 06:00:00	NVDA	Stock	23.028	23.39	22.9	23.297	300900.0
2022-03-11 07:00:00	NVDA	Stock	23.243	23.35	23.13	23.193	671420.0
2022-03-11 08:00:00	NVDA	Stock	23.1829	23.363	22.713	23.1657	1609540.0
2022-03-11 09:00:00	NVDA	Stock	23.171	23.23	22.692	22.754	36707820.0
2022-03-11 10:00:00	NVDA	Stock	22.758	22.846	22.541	22.708	44332250.0
2022-03-11 11:00:00	NVDA	Stock	22.7156	22.716	22.174	22.409	39164120.0
2022-03-11 12:00:00	NVDA	Stock	22.3985	22.535	22.263	22.477	25340660.0
2022-03-11 13:00:00	NVDA	Stock	22.474	22.658	22.43	22.444	27002530.0
2022-03-11 14:00:00	NVDA	Stock	22.436	22.617	22.415	22.427	21270340.0
2022-03-11 15:00:00	NVDA	Stock	22.422	22.471	22.046	22.1	41133060.0
2022-03-11 16:00:00	NVDA	Stock	22.1	22.124	22.019	22.05	22490590.0
2022-03-11 17:00:00	NVDA	Stock	22.052	22.095	22.023	22.095	182620.0
2022-03-11 18:00:00	NVDA	Stock	22.088	22.094	22.036	22.043	155050.0
2022-03-11 19:00:00	NVDA	Stock	22.045	22.135	22.035	22.1	326660.0
2022-03-11 04:00:00	AMZN	Stock	146.75	147.753	146.75	147.75	22080.0
2022-03-11 05:00:00	AMZN	Stock	148.15	148.15	148.15	148.15	2000.0

> showing 50 of 63,854 rows — these rows as CSV

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