PREVIEW / stock_1hour / 2022-04-18

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-04-18.parquet
  size:    1.4 MB
  rows:    63,469
  symbols: 2,512

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-04-18 04:00:00	AAPL	Stock	165.0	165.0	163.0	164.11	25566.0
2022-04-18 05:00:00	AAPL	Stock	164.03	164.29	163.51	164.1	7904.0
2022-04-18 06:00:00	AAPL	Stock	164.26	164.37	164.21	164.33	2970.0
2022-04-18 07:00:00	AAPL	Stock	164.35	164.96	164.31	164.49	68669.0
2022-04-18 08:00:00	AAPL	Stock	164.5203	164.95	164.0	164.7	296157.0
2022-04-18 09:00:00	AAPL	Stock	164.68	165.7392	163.57	164.4897	10382624.0
2022-04-18 10:00:00	AAPL	Stock	164.48	166.5984	164.09	165.51	9362662.0
2022-04-18 11:00:00	AAPL	Stock	165.51	165.63	164.29	164.745	6232258.0
2022-04-18 12:00:00	AAPL	Stock	164.745	164.8453	163.69	163.98	5445971.0
2022-04-18 13:00:00	AAPL	Stock	163.99	165.61	163.8	165.32	5679893.0
2022-04-18 14:00:00	AAPL	Stock	165.32	165.8296	164.89	165.25	5375388.0
2022-04-18 15:00:00	AAPL	Stock	165.2516	165.325	163.98	165.11	7869407.0
2022-04-18 16:00:00	AAPL	Stock	165.09	165.99	165.07	165.7001	5356339.0
2022-04-18 17:00:00	AAPL	Stock	165.7	165.86	165.61	165.84	34592.0
2022-04-18 18:00:00	AAPL	Stock	165.79	165.85	165.69	165.75	36375.0
2022-04-18 19:00:00	AAPL	Stock	165.73	166.35	165.63	166.22	85783.0
2022-04-18 04:00:00	MSFT	Stock	277.0	279.1	277.0	278.4	2630.0
2022-04-18 05:00:00	MSFT	Stock	278.01	278.01	277.36	277.78	1305.0
2022-04-18 06:00:00	MSFT	Stock	278.02	278.79	278.02	278.79	1679.0
2022-04-18 07:00:00	MSFT	Stock	279.1	279.58	278.71	279.16	11833.0
2022-04-18 08:00:00	MSFT	Stock	279.0001	279.58	277.2612	279.15	36580.0
2022-04-18 09:00:00	MSFT	Stock	278.87	281.9	278.55	279.85	2424199.0
2022-04-18 10:00:00	MSFT	Stock	279.86	282.46	279.6795	281.04	2425755.0
2022-04-18 11:00:00	MSFT	Stock	281.04	281.39	279.36	279.96	1576050.0
2022-04-18 12:00:00	MSFT	Stock	279.96	280.07	278.64	278.89	1601751.0
2022-04-18 13:00:00	MSFT	Stock	278.9	281.37	278.63	280.9	1377200.0
2022-04-18 14:00:00	MSFT	Stock	280.93	281.47	280.22	280.48	1479300.0
2022-04-18 15:00:00	MSFT	Stock	280.476	280.65	278.34	280.6	2462635.0
2022-04-18 16:00:00	MSFT	Stock	280.52	282.0	280.52	281.38	2295972.0
2022-04-18 17:00:00	MSFT	Stock	281.48	281.7	281.3	281.45	7146.0
2022-04-18 18:00:00	MSFT	Stock	281.51	281.98	281.51	281.81	7803.0
2022-04-18 19:00:00	MSFT	Stock	281.86	283.0	281.52	282.5	12890.0
2022-04-18 04:00:00	NVDA	Stock	21.205	21.271	21.079	21.201	364690.0
2022-04-18 05:00:00	NVDA	Stock	21.193	21.197	21.098	21.117	71100.0
2022-04-18 06:00:00	NVDA	Stock	21.119	21.178	21.119	21.168	41620.0
2022-04-18 07:00:00	NVDA	Stock	21.166	21.246	21.155	21.163	307120.0
2022-04-18 08:00:00	NVDA	Stock	21.19	21.25	20.945	21.15	1349110.0
2022-04-18 09:00:00	NVDA	Stock	21.153	21.56	21.079	21.2681	52901340.0
2022-04-18 10:00:00	NVDA	Stock	21.265	21.893	21.166	21.695	72636060.0
2022-04-18 11:00:00	NVDA	Stock	21.697	21.7949	21.392	21.541	42999430.0
2022-04-18 12:00:00	NVDA	Stock	21.541	21.545	21.25	21.432	33862610.0
2022-04-18 13:00:00	NVDA	Stock	21.432	22.014	21.366	21.9405	64548340.0
2022-04-18 14:00:00	NVDA	Stock	21.941	22.088	21.83	21.8502	59333900.0
2022-04-18 15:00:00	NVDA	Stock	21.851	21.889	21.503	21.783	60706340.0
2022-04-18 16:00:00	NVDA	Stock	21.783	21.957	21.775	21.9	13103240.0
2022-04-18 17:00:00	NVDA	Stock	21.914	21.935	21.885	21.92	140390.0
2022-04-18 18:00:00	NVDA	Stock	21.926	21.985	21.916	21.95	295580.0
2022-04-18 19:00:00	NVDA	Stock	21.955	22.077	21.95	22.075	566740.0
2022-04-18 07:00:00	AMZN	Stock	151.5	151.5	151.5	151.5	2000.0
2022-04-18 08:00:00	AMZN	Stock	151.0055	151.5845	151.0	151.48	20900.0

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

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