PREVIEW / stock_1hour / 2023-04-18

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-04-18.parquet
  size:    1.4 MB
  rows:    60,288
  symbols: 1,716

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-04-18 04:00:00	AAPL	Stock	165.25	165.85	165.25	165.76	9690.0
2023-04-18 05:00:00	AAPL	Stock	165.71	166.27	165.66	166.2	11377.0
2023-04-18 06:00:00	AAPL	Stock	166.1	166.38	166.06	166.06	25152.0
2023-04-18 07:00:00	AAPL	Stock	166.05	166.59	166.0	166.37	68761.0
2023-04-18 08:00:00	AAPL	Stock	166.06	166.7	164.63	166.37	193005.0
2023-04-18 09:00:00	AAPL	Stock	166.36	167.41	165.75	166.95	7613478.0
2023-04-18 10:00:00	AAPL	Stock	166.94	166.95	165.79	165.93	6683547.0
2023-04-18 11:00:00	AAPL	Stock	165.94	166.26	165.65	165.71	4154669.0
2023-04-18 12:00:00	AAPL	Stock	165.71	166.32	165.68	165.7683	3346391.0
2023-04-18 13:00:00	AAPL	Stock	165.765	166.48	165.7	166.29	2949825.0
2023-04-18 14:00:00	AAPL	Stock	166.2877	166.74	166.0	166.3025	3927436.0
2023-04-18 15:00:00	AAPL	Stock	166.31	166.6901	166.05	166.46	5854173.0
2023-04-18 16:00:00	AAPL	Stock	166.45	166.53	166.02	166.42	6876247.0
2023-04-18 17:00:00	AAPL	Stock	166.46	166.46	166.35	166.37	20937.0
2023-04-18 18:00:00	AAPL	Stock	166.38	166.4	166.31	166.3508	18300.0
2023-04-18 19:00:00	AAPL	Stock	166.37	166.46	166.31	166.46	19691.0
2023-04-18 04:00:00	MSFT	Stock	288.95	290.69	288.95	290.45	4433.0
2023-04-18 05:00:00	MSFT	Stock	290.31	291.38	290.1	290.95	7789.0
2023-04-18 06:00:00	MSFT	Stock	290.9	291.08	290.4	290.4	6051.0
2023-04-18 07:00:00	MSFT	Stock	290.61	290.85	290.02	290.38	23292.0
2023-04-18 08:00:00	MSFT	Stock	290.46	290.93	288.75	290.8152	40098.0
2023-04-18 09:00:00	MSFT	Stock	290.86	292.8	289.21	289.82	2630898.0
2023-04-18 10:00:00	MSFT	Stock	289.81	289.9	287.01	287.7	2443651.0
2023-04-18 11:00:00	MSFT	Stock	287.68	288.25	287.18	287.35	1430151.0
2023-04-18 12:00:00	MSFT	Stock	287.33	288.03	287.22	287.73	1151994.0
2023-04-18 13:00:00	MSFT	Stock	287.75	288.53	287.65	287.85	1216215.0
2023-04-18 14:00:00	MSFT	Stock	287.85	288.5	287.32	287.77	1304086.0
2023-04-18 15:00:00	MSFT	Stock	287.79	288.71	287.54	288.28	1971579.0
2023-04-18 16:00:00	MSFT	Stock	288.27	288.63	287.6	288.02	3297882.0
2023-04-18 17:00:00	MSFT	Stock	288.0265	288.37	287.86	287.86	4883.0
2023-04-18 18:00:00	MSFT	Stock	287.75	288.1499	287.7	288.1499	4110.0
2023-04-18 19:00:00	MSFT	Stock	288.15	288.15	287.75	288.0	3198.0
2023-04-18 04:00:00	NVDA	Stock	27.334	27.485	27.334	27.474	206960.0
2023-04-18 05:00:00	NVDA	Stock	27.479	27.62	27.476	27.57	212420.0
2023-04-18 06:00:00	NVDA	Stock	27.584	27.595	27.53	27.56	181380.0
2023-04-18 07:00:00	NVDA	Stock	27.563	27.69	27.506	27.641	1190250.0
2023-04-18 08:00:00	NVDA	Stock	27.22	27.776	27.062	27.749	3962840.0
2023-04-18 09:00:00	NVDA	Stock	27.75	28.11	27.245	27.79	119391090.0
2023-04-18 10:00:00	NVDA	Stock	27.7925	27.931	27.619	27.8718	103039040.0
2023-04-18 11:00:00	NVDA	Stock	27.872	27.961	27.728	27.813	56595080.0
2023-04-18 12:00:00	NVDA	Stock	27.812	27.945	27.745	27.84	46585860.0
2023-04-18 13:00:00	NVDA	Stock	27.84	27.92	27.6725	27.69	34410820.0
2023-04-18 14:00:00	NVDA	Stock	27.689	27.71	27.357	27.4391	59786440.0
2023-04-18 15:00:00	NVDA	Stock	27.445	27.713	27.431	27.665	54745320.0
2023-04-18 16:00:00	NVDA	Stock	27.667	27.7	27.5474	27.68	14485750.0
2023-04-18 17:00:00	NVDA	Stock	27.694	27.715	27.658	27.662	369290.0
2023-04-18 18:00:00	NVDA	Stock	27.664	27.675	27.651	27.675	157010.0
2023-04-18 19:00:00	NVDA	Stock	27.676	27.715	27.676	27.715	294660.0
2023-04-18 04:00:00	AMZN	Stock	102.75	103.78	102.74	103.2	17952.0
2023-04-18 05:00:00	AMZN	Stock	103.16	103.45	102.99	103.4	10068.0

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

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