PREVIEW / stock_1hour / 2022-09-14

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-09-14.parquet
  size:    1.4 MB
  rows:    61,902
  symbols: 2,206

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-09-14 04:00:00	AAPL	Stock	154.9	155.33	154.59	155.2	56373.0
2022-09-14 05:00:00	AAPL	Stock	155.12	155.17	154.71	154.8	31634.0
2022-09-14 06:00:00	AAPL	Stock	154.81	155.03	154.76	154.89	9661.0
2022-09-14 07:00:00	AAPL	Stock	154.84	154.89	153.26	153.38	214436.0
2022-09-14 08:00:00	AAPL	Stock	154.73	156.7	153.25	154.54	595052.0
2022-09-14 09:00:00	AAPL	Stock	154.49	156.19	154.03	156.05	11689908.0
2022-09-14 10:00:00	AAPL	Stock	156.06	156.6	154.8801	156.561	13396260.0
2022-09-14 11:00:00	AAPL	Stock	156.56	157.1	155.72	155.79	9525702.0
2022-09-14 12:00:00	AAPL	Stock	155.8	155.8675	154.93	155.1401	6572899.0
2022-09-14 13:00:00	AAPL	Stock	155.14	155.3	154.14	154.33	6335949.0
2022-09-14 14:00:00	AAPL	Stock	154.33	154.6352	153.88	154.115	6628190.0
2022-09-14 15:00:00	AAPL	Stock	154.12	155.585	153.6106	155.31	11630922.0
2022-09-14 16:00:00	AAPL	Stock	155.31	155.71	155.25	155.63	8581940.0
2022-09-14 17:00:00	AAPL	Stock	155.64	155.75	155.31	155.7	55454.0
2022-09-14 18:00:00	AAPL	Stock	155.67	155.89	155.55	155.84	43500.0
2022-09-14 19:00:00	AAPL	Stock	155.82	156.0	155.71	155.99	54600.0
2022-09-14 04:00:00	MSFT	Stock	253.97	254.5	253.32	254.36	18261.0
2022-09-14 05:00:00	MSFT	Stock	254.39	254.97	254.01	254.01	7840.0
2022-09-14 06:00:00	MSFT	Stock	254.06	254.06	253.31	253.31	2752.0
2022-09-14 07:00:00	MSFT	Stock	253.57	253.63	252.0	252.2	21868.0
2022-09-14 08:00:00	MSFT	Stock	253.4341	253.79	251.361	253.579	47827.0
2022-09-14 09:00:00	MSFT	Stock	253.35	254.23	251.13	253.46	2063414.0
2022-09-14 10:00:00	MSFT	Stock	253.47	253.92	250.8947	253.415	1968974.0
2022-09-14 11:00:00	MSFT	Stock	253.4	254.005	251.9	251.96	1477237.0
2022-09-14 12:00:00	MSFT	Stock	251.99	252.7	251.43	252.5	1568047.0
2022-09-14 13:00:00	MSFT	Stock	252.55	252.96	250.57	250.79	1330866.0
2022-09-14 14:00:00	MSFT	Stock	250.77	251.83	250.37	250.79	1359173.0
2022-09-14 15:00:00	MSFT	Stock	250.79	252.71	249.86	252.25	3481999.0
2022-09-14 16:00:00	MSFT	Stock	252.25	252.94	252.22	252.94	4383950.0
2022-09-14 17:00:00	MSFT	Stock	252.85	253.08	252.8	253.0	3399.0
2022-09-14 18:00:00	MSFT	Stock	252.86	253.5	252.76	253.45	14950.0
2022-09-14 19:00:00	MSFT	Stock	253.44	253.45	252.62	252.62	8574.0
2022-09-14 04:00:00	NVDA	Stock	13.205	13.29	13.172	13.271	301540.0
2022-09-14 05:00:00	NVDA	Stock	13.27	13.283	13.241	13.245	111380.0
2022-09-14 06:00:00	NVDA	Stock	13.24	13.269	13.2	13.23	185280.0
2022-09-14 07:00:00	NVDA	Stock	13.225	13.24	13.075	13.083	665700.0
2022-09-14 08:00:00	NVDA	Stock	13.2152	13.243	13.0675	13.21	4025410.0
2022-09-14 09:00:00	NVDA	Stock	13.21	13.29	12.913	13.081	91977080.0
2022-09-14 10:00:00	NVDA	Stock	13.081	13.182	12.919	13.123	91187290.0
2022-09-14 11:00:00	NVDA	Stock	13.125	13.196	13.05	13.103	58684200.0
2022-09-14 12:00:00	NVDA	Stock	13.105	13.24	13.022	13.174	50571160.0
2022-09-14 13:00:00	NVDA	Stock	13.176	13.225	13.05	13.0653	39911910.0
2022-09-14 14:00:00	NVDA	Stock	13.063	13.084	12.992	13.0081	45447120.0
2022-09-14 15:00:00	NVDA	Stock	13.007	13.145	12.9398	13.129	69955610.0
2022-09-14 16:00:00	NVDA	Stock	13.128	13.185	13.128	13.166	23375900.0
2022-09-14 17:00:00	NVDA	Stock	13.183	13.214	13.167	13.204	592320.0
2022-09-14 18:00:00	NVDA	Stock	13.205	13.239	13.193	13.225	671170.0
2022-09-14 19:00:00	NVDA	Stock	13.233	13.234	13.2	13.206	321480.0
2022-09-14 04:00:00	AMZN	Stock	127.37	128.17	127.37	127.96	41191.0
2022-09-14 05:00:00	AMZN	Stock	127.8	128.0	127.62	127.62	7779.0

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

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