PREVIEW / stock_1hour / 2023-03-16

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-03-16.parquet
  size:    1.4 MB
  rows:    61,000
  symbols: 1,743

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-16 04:00:00	AAPL	Stock	152.88	153.44	152.85	153.02	18233.0
2023-03-16 05:00:00	AAPL	Stock	153.15	153.2	152.69	152.99	14051.0
2023-03-16 06:00:00	AAPL	Stock	152.94	153.03	152.71	152.76	11491.0
2023-03-16 07:00:00	AAPL	Stock	152.9	153.25	152.51	152.96	29443.0
2023-03-16 08:00:00	AAPL	Stock	152.55	153.22	152.11	152.55	195290.0
2023-03-16 09:00:00	AAPL	Stock	152.58	153.22	151.64	153.155	5614074.0
2023-03-16 10:00:00	AAPL	Stock	153.14	154.2959	152.74	154.088	9115521.0
2023-03-16 11:00:00	AAPL	Stock	154.08	155.49	153.71	155.2	10091045.0
2023-03-16 12:00:00	AAPL	Stock	155.18	155.34	154.28	155.1071	7904652.0
2023-03-16 13:00:00	AAPL	Stock	155.1	155.4	154.4	155.31	5636074.0
2023-03-16 14:00:00	AAPL	Stock	155.31	155.95	154.9	155.915	6169116.0
2023-03-16 15:00:00	AAPL	Stock	155.915	156.46	155.6	155.91	12843611.0
2023-03-16 16:00:00	AAPL	Stock	155.91	155.97	155.59	155.95	9034393.0
2023-03-16 17:00:00	AAPL	Stock	155.92	155.99	155.8	155.93	29102.0
2023-03-16 18:00:00	AAPL	Stock	155.88	155.9	155.67	155.86	32225.0
2023-03-16 19:00:00	AAPL	Stock	155.87	155.96	155.73	155.81	48041.0
2023-03-16 04:00:00	MSFT	Stock	267.0	267.28	265.8	266.28	7428.0
2023-03-16 05:00:00	MSFT	Stock	266.35	266.5	265.62	266.0	8636.0
2023-03-16 06:00:00	MSFT	Stock	266.07	266.16	265.35	265.65	16761.0
2023-03-16 07:00:00	MSFT	Stock	265.85	266.0	265.5	265.69	34947.0
2023-03-16 08:00:00	MSFT	Stock	265.9	266.5	264.777	265.4	53996.0
2023-03-16 09:00:00	MSFT	Stock	265.2754	265.9	263.43	264.53	2922089.0
2023-03-16 10:00:00	MSFT	Stock	264.5438	266.63	263.28	266.54	3817249.0
2023-03-16 11:00:00	MSFT	Stock	266.55	273.94	266.12	273.1	8067495.0
2023-03-16 12:00:00	MSFT	Stock	273.11	276.52	272.54	275.175	6239156.0
2023-03-16 13:00:00	MSFT	Stock	275.17	275.81	274.08	275.48	3803040.0
2023-03-16 14:00:00	MSFT	Stock	275.5	276.0	274.23	275.362	3044858.0
2023-03-16 15:00:00	MSFT	Stock	275.3705	276.56	275.3	276.22	6946859.0
2023-03-16 16:00:00	MSFT	Stock	276.095	276.58	275.75	276.25	6076079.0
2023-03-16 17:00:00	MSFT	Stock	276.31	276.34	275.79	275.94	19462.0
2023-03-16 18:00:00	MSFT	Stock	275.94	276.18	274.9	276.08	26638.0
2023-03-16 19:00:00	MSFT	Stock	276.2	276.5	276.01	276.31	17191.0
2023-03-16 04:00:00	NVDA	Stock	24.38	24.425	24.331	24.358	237350.0
2023-03-16 05:00:00	NVDA	Stock	24.35	24.35	24.199	24.24	144340.0
2023-03-16 06:00:00	NVDA	Stock	24.241	24.29	24.201	24.25	39880.0
2023-03-16 07:00:00	NVDA	Stock	24.27	24.349	24.253	24.3	263590.0
2023-03-16 08:00:00	NVDA	Stock	24.261	24.4	24.2	24.26	1300160.0
2023-03-16 09:00:00	NVDA	Stock	24.242	24.322	23.894	24.308	44228220.0
2023-03-16 10:00:00	NVDA	Stock	24.308	24.75	24.233	24.6584	82803130.0
2023-03-16 11:00:00	NVDA	Stock	24.6502	25.209	24.605	25.167	75134760.0
2023-03-16 12:00:00	NVDA	Stock	25.171	25.338	25.007	25.2525	64457180.0
2023-03-16 13:00:00	NVDA	Stock	25.251	25.3	25.11	25.175	37717460.0
2023-03-16 14:00:00	NVDA	Stock	25.175	25.345	25.113	25.2692	36418780.0
2023-03-16 15:00:00	NVDA	Stock	25.27	25.588	25.229	25.549	81222410.0
2023-03-16 16:00:00	NVDA	Stock	25.541	25.573	24.3	25.485	31667730.0
2023-03-16 17:00:00	NVDA	Stock	25.5021	25.813	25.485	25.713	2640080.0
2023-03-16 18:00:00	NVDA	Stock	25.722	25.79	25.7	25.745	956650.0
2023-03-16 19:00:00	NVDA	Stock	25.74	25.8	25.722	25.8	708350.0
2023-03-16 04:00:00	AMZN	Stock	96.31	96.66	96.27	96.27	17657.0
2023-03-16 05:00:00	AMZN	Stock	96.26	96.3	95.65	96.08	12166.0

> showing 50 of 61,000 rows — these rows as CSV

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