PREVIEW / stock_1hour / 2023-07-11

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-07-11.parquet
  size:    1.3 MB
  rows:    60,173
  symbols: 1,561

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-07-11 04:00:00	AAPL	Stock	188.8	189.0	188.55	188.61	21265.0
2023-07-11 05:00:00	AAPL	Stock	188.78	189.37	188.78	189.37	22658.0
2023-07-11 06:00:00	AAPL	Stock	189.2	189.3	188.91	188.92	10484.0
2023-07-11 07:00:00	AAPL	Stock	189.0	189.54	189.0	189.44	39918.0
2023-07-11 08:00:00	AAPL	Stock	189.1	189.96	188.63	189.62	185773.0
2023-07-11 09:00:00	AAPL	Stock	189.63	189.67	187.59	187.83	5371728.0
2023-07-11 10:00:00	AAPL	Stock	187.84	188.5601	187.45	188.16	4780884.0
2023-07-11 11:00:00	AAPL	Stock	188.16	188.4609	187.26	188.1917	3999134.0
2023-07-11 12:00:00	AAPL	Stock	188.2	188.38	187.46	187.7	3559331.0
2023-07-11 13:00:00	AAPL	Stock	187.7	187.7869	187.175	187.47	3243463.0
2023-07-11 14:00:00	AAPL	Stock	187.47	187.5199	186.6	187.359	4132421.0
2023-07-11 15:00:00	AAPL	Stock	187.35	188.27	186.97	188.06	7153559.0
2023-07-11 16:00:00	AAPL	Stock	188.05	188.15	187.7182	188.05	4880823.0
2023-07-11 17:00:00	AAPL	Stock	188.04	188.17	188.01	188.08	54314.0
2023-07-11 18:00:00	AAPL	Stock	188.07	188.2	188.05	188.18	19129.0
2023-07-11 19:00:00	AAPL	Stock	188.19	188.26	188.04	188.2	24206.0
2023-07-11 04:00:00	MSFT	Stock	332.14	332.34	331.5	331.5	9005.0
2023-07-11 05:00:00	MSFT	Stock	331.5	332.25	331.5	332.25	2205.0
2023-07-11 06:00:00	MSFT	Stock	332.3	332.48	331.76	331.84	4414.0
2023-07-11 07:00:00	MSFT	Stock	332.0	332.6	331.84	332.45	13261.0
2023-07-11 08:00:00	MSFT	Stock	331.73	333.3	331.12	332.1883	90120.0
2023-07-11 09:00:00	MSFT	Stock	332.2	332.24	328.28	328.715	2967291.0
2023-07-11 10:00:00	MSFT	Stock	328.72	330.23	327.0	329.86	3464939.0
2023-07-11 11:00:00	MSFT	Stock	329.875	332.3443	329.331	332.335	2539317.0
2023-07-11 12:00:00	MSFT	Stock	332.32	332.86	330.06	331.175	2174686.0
2023-07-11 13:00:00	MSFT	Stock	331.155	332.03	330.45	331.96	1489355.0
2023-07-11 14:00:00	MSFT	Stock	331.94	332.05	330.13	331.62	1495766.0
2023-07-11 15:00:00	MSFT	Stock	331.64	332.73	330.84	332.47	2730696.0
2023-07-11 16:00:00	MSFT	Stock	332.25	332.67	332.25	332.35	2429582.0
2023-07-11 17:00:00	MSFT	Stock	332.35	332.72	332.2	332.28	19608.0
2023-07-11 18:00:00	MSFT	Stock	332.3781	332.72	332.28	332.72	8304.0
2023-07-11 19:00:00	MSFT	Stock	332.7	332.84	332.52	332.5501	16551.0
2023-07-11 04:00:00	NVDA	Stock	42.31	42.44	42.25	42.348	95180.0
2023-07-11 05:00:00	NVDA	Stock	42.354	42.578	42.325	42.467	138750.0
2023-07-11 06:00:00	NVDA	Stock	42.485	42.568	42.45	42.51	42670.0
2023-07-11 07:00:00	NVDA	Stock	42.454	42.57	42.45	42.507	303090.0
2023-07-11 08:00:00	NVDA	Stock	42.452	42.579	42.25	42.388	1595190.0
2023-07-11 09:00:00	NVDA	Stock	42.399	42.733	42.209	42.374	42440610.0
2023-07-11 10:00:00	NVDA	Stock	42.373	42.758	42.067	42.5635	50652050.0
2023-07-11 11:00:00	NVDA	Stock	42.572	42.67	42.184	42.395	29407800.0
2023-07-11 12:00:00	NVDA	Stock	42.395	42.434	42.214	42.318	17771830.0
2023-07-11 13:00:00	NVDA	Stock	42.313	42.358	42.132	42.311	17851510.0
2023-07-11 14:00:00	NVDA	Stock	42.3105	42.32	42.084	42.2693	17592860.0
2023-07-11 15:00:00	NVDA	Stock	42.261	42.432	42.163	42.401	26211080.0
2023-07-11 16:00:00	NVDA	Stock	42.4	42.425	42.349	42.374	13417130.0
2023-07-11 17:00:00	NVDA	Stock	42.36	42.3764	42.335	42.345	110320.0
2023-07-11 18:00:00	NVDA	Stock	42.368	42.41	42.361	42.41	134270.0
2023-07-11 19:00:00	NVDA	Stock	42.415	42.43	42.4	42.414	208740.0
2023-07-11 04:00:00	AMZN	Stock	127.45	127.78	127.32	127.5	17152.0
2023-07-11 05:00:00	AMZN	Stock	127.45	127.82	127.45	127.71	9678.0

> showing 50 of 60,173 rows — these rows as CSV

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