PREVIEW / stock_1hour / 2022-04-11

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-04-11.parquet
  size:    1.4 MB
  rows:    64,393
  symbols: 2,443

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-11 04:00:00	AAPL	Stock	168.99	169.81	168.01	168.46	26867.0
2022-04-11 05:00:00	AAPL	Stock	168.23	168.8	168.19	168.7	24118.0
2022-04-11 06:00:00	AAPL	Stock	168.75	169.08	167.75	168.77	39007.0
2022-04-11 07:00:00	AAPL	Stock	168.79	168.85	167.75	167.87	162585.0
2022-04-11 08:00:00	AAPL	Stock	168.49	169.665	167.65	168.06	693272.0
2022-04-11 09:00:00	AAPL	Stock	168.09	169.03	166.88	167.0	9416513.0
2022-04-11 10:00:00	AAPL	Stock	166.98	167.33	166.1	166.16	10125658.0
2022-04-11 11:00:00	AAPL	Stock	166.15	167.205	166.11	167.025	6209835.0
2022-04-11 12:00:00	AAPL	Stock	167.023	167.145	166.48	167.03	5026553.0
2022-04-11 13:00:00	AAPL	Stock	167.02	167.46	166.7716	166.995	5099327.0
2022-04-11 14:00:00	AAPL	Stock	166.995	167.25	166.49	166.83	5603924.0
2022-04-11 15:00:00	AAPL	Stock	166.83	167.1	165.5	165.78	13425835.0
2022-04-11 16:00:00	AAPL	Stock	165.79	165.81	165.4	165.55	7015235.0
2022-04-11 17:00:00	AAPL	Stock	165.56	165.75	165.38	165.5	149636.0
2022-04-11 18:00:00	AAPL	Stock	165.52	165.83	165.52	165.74	56683.0
2022-04-11 19:00:00	AAPL	Stock	165.72	165.75	165.25	165.26	83773.0
2022-04-11 04:00:00	MSFT	Stock	295.23	295.23	292.51	292.8	6977.0
2022-04-11 05:00:00	MSFT	Stock	293.0	293.92	292.91	293.79	4052.0
2022-04-11 06:00:00	MSFT	Stock	293.81	294.89	292.7	294.0	8721.0
2022-04-11 07:00:00	MSFT	Stock	294.0	294.58	293.06	293.21	16009.0
2022-04-11 08:00:00	MSFT	Stock	293.5996	294.64	291.83	292.5	83728.0
2022-04-11 09:00:00	MSFT	Stock	292.45	292.61	287.66	287.72	4208070.0
2022-04-11 10:00:00	MSFT	Stock	287.71	288.48	285.4	286.47	5110426.0
2022-04-11 11:00:00	MSFT	Stock	286.45	286.8	285.32	286.075	2703623.0
2022-04-11 12:00:00	MSFT	Stock	286.07	286.91	285.56	286.9	1662970.0
2022-04-11 13:00:00	MSFT	Stock	286.895	287.68	286.55	287.0	1942176.0
2022-04-11 14:00:00	MSFT	Stock	287.01	287.76	286.25	287.1163	2068044.0
2022-04-11 15:00:00	MSFT	Stock	287.115	287.8	285.0	285.26	4860935.0
2022-04-11 16:00:00	MSFT	Stock	285.26	285.62	285.26	285.5	3660847.0
2022-04-11 17:00:00	MSFT	Stock	285.5	285.6	285.1	285.11	29282.0
2022-04-11 18:00:00	MSFT	Stock	285.28	285.49	285.2	285.49	25244.0
2022-04-11 19:00:00	MSFT	Stock	285.47	285.47	284.77	284.8	21431.0
2022-04-11 04:00:00	NVDA	Stock	23.0	23.0	22.395	22.5	441920.0
2022-04-11 05:00:00	NVDA	Stock	22.5	22.625	22.487	22.625	171830.0
2022-04-11 06:00:00	NVDA	Stock	22.588	22.625	22.476	22.6	255330.0
2022-04-11 07:00:00	NVDA	Stock	22.625	22.63	22.211	22.212	1919840.0
2022-04-11 08:00:00	NVDA	Stock	22.57	22.981	22.1	22.219	2885680.0
2022-04-11 09:00:00	NVDA	Stock	22.219	22.286	21.8726	21.9835	77138300.0
2022-04-11 10:00:00	NVDA	Stock	21.975	22.3199	21.795	21.879	76459960.0
2022-04-11 11:00:00	NVDA	Stock	21.875	21.972	21.778	21.8173	47542770.0
2022-04-11 12:00:00	NVDA	Stock	21.816	21.895	21.66	21.864	41248190.0
2022-04-11 13:00:00	NVDA	Stock	21.863	22.038	21.793	21.875	42078710.0
2022-04-11 14:00:00	NVDA	Stock	21.877	22.143	21.8	22.055	42821610.0
2022-04-11 15:00:00	NVDA	Stock	22.058	22.137	21.84	21.924	54621740.0
2022-04-11 16:00:00	NVDA	Stock	21.917	21.946	21.9	21.915	20082100.0
2022-04-11 17:00:00	NVDA	Stock	21.914	21.925	21.8401	21.859	414490.0
2022-04-11 18:00:00	NVDA	Stock	21.86	21.89	21.851	21.888	253590.0
2022-04-11 19:00:00	NVDA	Stock	21.88	21.88	21.77	21.78	556720.0
2022-04-11 05:00:00	AMZN	Stock	152.9285	152.9285	152.9285	152.9285	2800.0
2022-04-11 07:00:00	AMZN	Stock	153.0055	153.1625	152.4	152.5	49000.0

> showing 50 of 64,393 rows — these rows as CSV

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