PREVIEW / stock_1hour / 2022-03-14

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-03-14.parquet
  size:    1.4 MB
  rows:    65,543
  symbols: 2,493

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-03-14 04:00:00	AAPL	Stock	154.0	155.02	153.77	154.2	87034.0
2022-03-14 05:00:00	AAPL	Stock	154.21	155.6	154.14	155.15	78539.0
2022-03-14 06:00:00	AAPL	Stock	155.04	155.36	154.32	154.4	72143.0
2022-03-14 07:00:00	AAPL	Stock	154.38	154.4	152.0	152.15	511174.0
2022-03-14 08:00:00	AAPL	Stock	154.309	156.1	151.5	152.36	1254254.0
2022-03-14 09:00:00	AAPL	Stock	152.32	153.32	151.06	152.47	14101710.0
2022-03-14 10:00:00	AAPL	Stock	152.46	154.0	152.13	153.99	12322297.0
2022-03-14 11:00:00	AAPL	Stock	153.99	154.12	152.13	152.485	8102446.0
2022-03-14 12:00:00	AAPL	Stock	152.475	152.53	150.96	150.98	10726424.0
2022-03-14 13:00:00	AAPL	Stock	150.9841	151.44	150.44	151.0021	10174463.0
2022-03-14 14:00:00	AAPL	Stock	150.99	151.35	150.4	151.1401	9752711.0
2022-03-14 15:00:00	AAPL	Stock	151.14	151.73	150.1	150.64	15023095.0
2022-03-14 16:00:00	AAPL	Stock	150.64	150.9899	150.17	150.84	10352951.0
2022-03-14 17:00:00	AAPL	Stock	150.8001	150.84	150.21	150.47	124942.0
2022-03-14 18:00:00	AAPL	Stock	150.43	151.0	150.2699	150.65	106461.0
2022-03-14 19:00:00	AAPL	Stock	150.68	151.0	150.45	150.9	84907.0
2022-03-14 04:00:00	MSFT	Stock	280.78	282.34	280.4	281.28	10306.0
2022-03-14 05:00:00	MSFT	Stock	281.55	283.5	280.43	283.2	16122.0
2022-03-14 06:00:00	MSFT	Stock	282.89	283.32	281.73	282.23	3282.0
2022-03-14 07:00:00	MSFT	Stock	282.06	282.21	279.34	279.53	52847.0
2022-03-14 08:00:00	MSFT	Stock	281.8499	282.5	279.5	282.4	43094.0
2022-03-14 09:00:00	MSFT	Stock	282.388	284.77	280.01	283.035	3156852.0
2022-03-14 10:00:00	MSFT	Stock	283.03	285.3992	282.0	284.415	2576567.0
2022-03-14 11:00:00	MSFT	Stock	284.43	284.55	281.68	282.15	2063368.0
2022-03-14 12:00:00	MSFT	Stock	282.07	282.07	278.68	279.085	2026090.0
2022-03-14 13:00:00	MSFT	Stock	279.08	279.66	278.04	278.86	1875363.0
2022-03-14 14:00:00	MSFT	Stock	278.83	279.16	277.52	278.51	1957640.0
2022-03-14 15:00:00	MSFT	Stock	278.51	279.25	275.82	276.47	4023839.0
2022-03-14 16:00:00	MSFT	Stock	276.44	277.4	276.17	277.35	4459979.0
2022-03-14 17:00:00	MSFT	Stock	277.39	277.99	277.2499	277.71	12491.0
2022-03-14 18:00:00	MSFT	Stock	277.55	278.7	277.49	278.25	19913.0
2022-03-14 19:00:00	MSFT	Stock	278.03	278.6	277.6	278.0	18712.0
2022-03-14 04:00:00	NVDA	Stock	22.1	22.2	21.949	22.05	60150.0
2022-03-14 05:00:00	NVDA	Stock	22.005	22.38	22.005	22.38	106900.0
2022-03-14 06:00:00	NVDA	Stock	22.38	22.38	22.202	22.231	93160.0
2022-03-14 07:00:00	NVDA	Stock	22.251	22.253	21.77	21.853	476940.0
2022-03-14 08:00:00	NVDA	Stock	22.208	22.2755	21.76	22.012	972980.0
2022-03-14 09:00:00	NVDA	Stock	21.968	22.023	21.5921	21.863	33174630.0
2022-03-14 10:00:00	NVDA	Stock	21.867	22.262	21.746	22.209	46979370.0
2022-03-14 11:00:00	NVDA	Stock	22.207	22.224	21.6037	21.682	34656960.0
2022-03-14 12:00:00	NVDA	Stock	21.679	21.699	21.361	21.3925	35149390.0
2022-03-14 13:00:00	NVDA	Stock	21.395	21.446	21.217	21.313	32744490.0
2022-03-14 14:00:00	NVDA	Stock	21.318	21.397	21.159	21.3695	29662860.0
2022-03-14 15:00:00	NVDA	Stock	21.37	21.497	21.23	21.319	44585880.0
2022-03-14 16:00:00	NVDA	Stock	21.317	21.399	21.317	21.378	23598670.0
2022-03-14 17:00:00	NVDA	Stock	21.38	21.388	21.345	21.358	132750.0
2022-03-14 18:00:00	NVDA	Stock	21.358	21.57	21.351	21.49	360760.0
2022-03-14 19:00:00	NVDA	Stock	21.489	21.56	21.405	21.545	425290.0
2022-03-14 05:00:00	AMZN	Stock	146.45	147.0	146.45	147.0	58080.0
2022-03-14 06:00:00	AMZN	Stock	146.5005	146.5005	146.5005	146.5005	3600.0

> showing 50 of 65,543 rows — these rows as CSV

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