PREVIEW / stock_1hour / 2022-01-05

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-01-05.parquet
  size:    1.5 MB
  rows:    65,565
  symbols: 2,626

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-01-05 04:00:00	AAPL	Stock	179.52	179.8	179.32	179.64	16598.0
2022-01-05 05:00:00	AAPL	Stock	179.76	180.24	179.59	179.6	9195.0
2022-01-05 06:00:00	AAPL	Stock	179.6	179.6	179.34	179.4	10492.0
2022-01-05 07:00:00	AAPL	Stock	179.47	179.67	179.13	179.26	69651.0
2022-01-05 08:00:00	AAPL	Stock	179.34	179.7958	178.77	179.35	321771.0
2022-01-05 09:00:00	AAPL	Stock	179.4	180.17	177.56	179.29	8905570.0
2022-01-05 10:00:00	AAPL	Stock	179.28	179.48	177.97	178.725	9305706.0
2022-01-05 11:00:00	AAPL	Stock	178.74	179.431	178.53	178.81	6135278.0
2022-01-05 12:00:00	AAPL	Stock	178.801	179.25	178.25	178.3472	5759086.0
2022-01-05 13:00:00	AAPL	Stock	178.3345	178.55	177.67	178.04	5858391.0
2022-01-05 14:00:00	AAPL	Stock	178.0482	178.72	176.1	176.505	11783772.0
2022-01-05 15:00:00	AAPL	Stock	176.51	176.84	174.64	174.835	20526563.0
2022-01-05 16:00:00	AAPL	Stock	174.93	179.7958	174.43	174.43	10687426.0
2022-01-05 17:00:00	AAPL	Stock	174.92	174.92	174.4	174.7	137127.0
2022-01-05 18:00:00	AAPL	Stock	174.69	175.08	174.08	175.06	145205.0
2022-01-05 19:00:00	AAPL	Stock	175.07	175.35	174.75	175.07	110853.0
2022-01-05 04:00:00	MSFT	Stock	328.21	328.62	327.9	328.62	5979.0
2022-01-05 05:00:00	MSFT	Stock	328.7	328.7	328.7	328.7	100.0
2022-01-05 06:00:00	MSFT	Stock	328.33	328.96	328.09	328.59	6624.0
2022-01-05 07:00:00	MSFT	Stock	328.32	328.4	327.31	327.7	12027.0
2022-01-05 08:00:00	MSFT	Stock	327.4	328.49	327.0	327.8	34761.0
2022-01-05 09:00:00	MSFT	Stock	327.78	327.78	320.81	322.84	4646200.0
2022-01-05 10:00:00	MSFT	Stock	322.83	323.58	321.58	322.75	3396905.0
2022-01-05 11:00:00	MSFT	Stock	322.74	323.2499	321.75	321.81	1946252.0
2022-01-05 12:00:00	MSFT	Stock	321.79	322.4	320.15	320.58	2221455.0
2022-01-05 13:00:00	MSFT	Stock	320.52	321.6	320.342	321.2	1835043.0
2022-01-05 14:00:00	MSFT	Stock	321.15	324.0	318.49	318.97	3624103.0
2022-01-05 15:00:00	MSFT	Stock	318.97	319.2703	315.98	316.34	6534268.0
2022-01-05 16:00:00	MSFT	Stock	316.2	320.2222	315.49	316.11	5491586.0
2022-01-05 17:00:00	MSFT	Stock	316.38	316.38	315.85	316.34	48001.0
2022-01-05 18:00:00	MSFT	Stock	316.2	317.0	315.4	317.0	37329.0
2022-01-05 19:00:00	MSFT	Stock	317.1	317.5	316.74	317.1	27830.0
2022-01-05 04:00:00	NVDA	Stock	29.098	29.098	28.761	28.949	126550.0
2022-01-05 05:00:00	NVDA	Stock	28.975	29.089	28.955	28.955	108640.0
2022-01-05 06:00:00	NVDA	Stock	28.95	28.95	28.861	28.933	65980.0
2022-01-05 07:00:00	NVDA	Stock	28.961	29.025	28.887	28.927	509700.0
2022-01-05 08:00:00	NVDA	Stock	28.9704	29.3632	28.8	29.035	883900.0
2022-01-05 09:00:00	NVDA	Stock	29.022	29.319	28.582	29.256	43753120.0
2022-01-05 10:00:00	NVDA	Stock	29.255	29.416	28.545	28.781	47763170.0
2022-01-05 11:00:00	NVDA	Stock	28.781	28.84	28.44	28.5055	33525750.0
2022-01-05 12:00:00	NVDA	Stock	28.5085	28.556	28.17	28.196	36189650.0
2022-01-05 13:00:00	NVDA	Stock	28.196	28.44	28.1071	28.37	36120630.0
2022-01-05 14:00:00	NVDA	Stock	28.38	28.58	27.843	27.945	53578950.0
2022-01-05 15:00:00	NVDA	Stock	27.932	27.937	27.533	27.6	69257630.0
2022-01-05 16:00:00	NVDA	Stock	27.599	27.665	27.525	27.54	25628460.0
2022-01-05 17:00:00	NVDA	Stock	27.5325	27.604	27.502	27.589	900650.0
2022-01-05 18:00:00	NVDA	Stock	27.57	27.75	27.5	27.73	771000.0
2022-01-05 19:00:00	NVDA	Stock	27.735	27.795	27.675	27.77	592820.0
2022-01-05 04:00:00	AMZN	Stock	167.237	167.237	167.2	167.2	4320.0
2022-01-05 06:00:00	AMZN	Stock	167.05	167.05	166.8	166.9675	34400.0

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

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