PREVIEW / stock_1hour / 2023-11-13

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-11-13.parquet
  size:    1.3 MB
  rows:    58,296
  symbols: 1,305

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-11-13 04:00:00	AAPL	Stock	185.35	185.7	185.35	185.61	10453.0
2023-11-13 05:00:00	AAPL	Stock	185.6	185.75	185.55	185.75	5436.0
2023-11-13 06:00:00	AAPL	Stock	185.74	185.75	185.47	185.7	9639.0
2023-11-13 07:00:00	AAPL	Stock	185.7	186.4	185.7	186.13	87994.0
2023-11-13 08:00:00	AAPL	Stock	185.7519	186.39	185.03	185.69	114826.0
2023-11-13 09:00:00	AAPL	Stock	185.7	186.03	184.27	184.6	5774535.0
2023-11-13 10:00:00	AAPL	Stock	184.6	184.97	184.21	184.645	5817469.0
2023-11-13 11:00:00	AAPL	Stock	184.64	185.14	184.64	184.79	4238983.0
2023-11-13 12:00:00	AAPL	Stock	184.79	184.9	184.39	184.82	2750854.0
2023-11-13 13:00:00	AAPL	Stock	184.82	184.99	184.46	184.7228	2397317.0
2023-11-13 14:00:00	AAPL	Stock	184.7275	185.01	184.6	184.95	2456265.0
2023-11-13 15:00:00	AAPL	Stock	184.94	185.08	184.6105	184.77	5194850.0
2023-11-13 16:00:00	AAPL	Stock	184.77	184.84	184.6	184.72	4907154.0
2023-11-13 17:00:00	AAPL	Stock	184.69	184.79	184.69	184.77	14019.0
2023-11-13 18:00:00	AAPL	Stock	184.71	184.95	184.71	184.8999	15381.0
2023-11-13 19:00:00	AAPL	Stock	184.83	185.02	184.83	185.02	13935.0
2023-11-13 04:00:00	MSFT	Stock	369.01	369.67	368.91	369.48	5318.0
2023-11-13 05:00:00	MSFT	Stock	369.34	369.7	369.24	369.61	3918.0
2023-11-13 06:00:00	MSFT	Stock	369.77	369.82	369.47	369.66	2018.0
2023-11-13 07:00:00	MSFT	Stock	369.5	369.73	368.34	368.6	30721.0
2023-11-13 08:00:00	MSFT	Stock	369.55	369.8	367.69	367.8156	65597.0
2023-11-13 09:00:00	MSFT	Stock	368.15	368.75	365.9	366.53	2396896.0
2023-11-13 10:00:00	MSFT	Stock	366.59	368.04	366.11	367.76	2318558.0
2023-11-13 11:00:00	MSFT	Stock	367.7585	368.36	367.23	367.3707	1516840.0
2023-11-13 12:00:00	MSFT	Stock	367.425	367.86	366.93	367.5649	834019.0
2023-11-13 13:00:00	MSFT	Stock	367.57	368.01	366.9238	367.46	866057.0
2023-11-13 14:00:00	MSFT	Stock	367.45	367.825	367.11	367.45	1146753.0
2023-11-13 15:00:00	MSFT	Stock	367.47	367.64	366.3	366.66	2630370.0
2023-11-13 16:00:00	MSFT	Stock	366.67	366.84	366.59	366.84	2360621.0
2023-11-13 17:00:00	MSFT	Stock	366.8	367.05	366.8	366.89	4439.0
2023-11-13 18:00:00	MSFT	Stock	366.95	366.95	366.8	366.8	2100.0
2023-11-13 19:00:00	MSFT	Stock	366.9	367.96	366.8	367.95	20721.0
2023-11-13 04:00:00	NVDA	Stock	48.274	48.3	48.175	48.26	161520.0
2023-11-13 05:00:00	NVDA	Stock	48.241	48.57	48.222	48.55	133430.0
2023-11-13 06:00:00	NVDA	Stock	48.55	48.641	48.477	48.63	150970.0
2023-11-13 07:00:00	NVDA	Stock	48.611	48.799	48.6	48.68	683970.0
2023-11-13 08:00:00	NVDA	Stock	48.607	48.8	48.0	48.44	2860500.0
2023-11-13 09:00:00	NVDA	Stock	48.45	48.647	48.099	48.382	58207280.0
2023-11-13 10:00:00	NVDA	Stock	48.3885	49.005	48.36	48.679	69167080.0
2023-11-13 11:00:00	NVDA	Stock	48.682	49.0441	48.6718	48.832	38571730.0
2023-11-13 12:00:00	NVDA	Stock	48.829	48.88	48.6711	48.8275	23912840.0
2023-11-13 13:00:00	NVDA	Stock	48.8275	49.0	48.69	48.853	22918160.0
2023-11-13 14:00:00	NVDA	Stock	48.855	49.063	48.814	48.937	24119120.0
2023-11-13 15:00:00	NVDA	Stock	48.938	49.116	48.587	48.618	44010120.0
2023-11-13 16:00:00	NVDA	Stock	48.61	48.71	48.54	48.66	9296970.0
2023-11-13 17:00:00	NVDA	Stock	48.668	48.679	48.6	48.651	272480.0
2023-11-13 18:00:00	NVDA	Stock	48.659	48.73	48.656	48.716	297260.0
2023-11-13 19:00:00	NVDA	Stock	48.725	48.8	48.711	48.76	631910.0
2023-11-13 04:00:00	AMZN	Stock	142.86	143.0	142.84	142.96	4897.0
2023-11-13 05:00:00	AMZN	Stock	142.88	143.09	142.88	143.09	6630.0

> showing 50 of 58,296 rows — these rows as CSV

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