PREVIEW / stock_1hour / 2022-05-16

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-05-16.parquet
  size:    1.4 MB
  rows:    63,325
  symbols: 2,432

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-05-16 04:00:00	AAPL	Stock	146.68	146.68	145.66	146.53	22294.0
2022-05-16 05:00:00	AAPL	Stock	146.55	146.67	145.7	145.7	20797.0
2022-05-16 06:00:00	AAPL	Stock	145.82	146.15	145.81	146.14	15185.0
2022-05-16 07:00:00	AAPL	Stock	146.19	146.5	146.08	146.39	73259.0
2022-05-16 08:00:00	AAPL	Stock	146.18	147.39	145.99	146.81	545234.0
2022-05-16 09:00:00	AAPL	Stock	146.81	146.98	144.34	145.02	10588569.0
2022-05-16 10:00:00	AAPL	Stock	145.025	146.66	144.42	144.43	12362766.0
2022-05-16 11:00:00	AAPL	Stock	144.44	146.94	144.18	146.65	9131030.0
2022-05-16 12:00:00	AAPL	Stock	146.65	146.8	145.23	145.38	6668329.0
2022-05-16 13:00:00	AAPL	Stock	145.37	146.769	145.15	146.305	6830249.0
2022-05-16 14:00:00	AAPL	Stock	146.31	147.5199	146.06	146.955	8647577.0
2022-05-16 15:00:00	AAPL	Stock	146.9448	147.17	145.0	145.54	11458377.0
2022-05-16 16:00:00	AAPL	Stock	145.56	145.6	145.11	145.28	5965906.0
2022-05-16 17:00:00	AAPL	Stock	145.26	145.37	145.06	145.2	61515.0
2022-05-16 18:00:00	AAPL	Stock	145.21	145.64	145.2	145.6	31384.0
2022-05-16 19:00:00	AAPL	Stock	145.6	146.01	145.42	146.01	56771.0
2022-05-16 04:00:00	MSFT	Stock	259.07	259.6	259.04	259.6	1422.0
2022-05-16 05:00:00	MSFT	Stock	260.55	260.55	259.51	259.52	4355.0
2022-05-16 06:00:00	MSFT	Stock	259.9	259.94	259.75	259.94	1038.0
2022-05-16 07:00:00	MSFT	Stock	259.9	260.35	259.6	259.9	4697.0
2022-05-16 08:00:00	MSFT	Stock	260.1666	262.0	259.6	260.4729	50330.0
2022-05-16 09:00:00	MSFT	Stock	260.5	260.65	255.78	256.6812	2731913.0
2022-05-16 10:00:00	MSFT	Stock	256.69	258.8	255.86	257.24	2820484.0
2022-05-16 11:00:00	MSFT	Stock	257.24	260.73	256.765	260.365	2169360.0
2022-05-16 12:00:00	MSFT	Stock	260.4	260.94	259.565	260.17	1892824.0
2022-05-16 13:00:00	MSFT	Stock	260.15	264.38	259.81	264.13	3196373.0
2022-05-16 14:00:00	MSFT	Stock	264.13	265.82	263.51	264.15	3054526.0
2022-05-16 15:00:00	MSFT	Stock	264.1401	264.46	260.8	261.54	4585174.0
2022-05-16 16:00:00	MSFT	Stock	261.6	261.8938	261.11	261.3882	3759703.0
2022-05-16 17:00:00	MSFT	Stock	261.4	261.4	260.7	261.07	12891.0
2022-05-16 18:00:00	MSFT	Stock	261.3	261.92	261.3	261.7499	7509.0
2022-05-16 19:00:00	MSFT	Stock	261.7499	261.83	261.21	261.33	24027.0
2022-05-16 04:00:00	NVDA	Stock	17.626	17.842	17.502	17.635	274570.0
2022-05-16 05:00:00	NVDA	Stock	17.64	17.66	17.502	17.502	92210.0
2022-05-16 06:00:00	NVDA	Stock	17.536	17.598	17.536	17.598	31810.0
2022-05-16 07:00:00	NVDA	Stock	17.592	17.651	17.55	17.588	250780.0
2022-05-16 08:00:00	NVDA	Stock	17.625	17.725	17.54	17.57	2536410.0
2022-05-16 09:00:00	NVDA	Stock	17.599	17.685	17.106	17.538	69727930.0
2022-05-16 10:00:00	NVDA	Stock	17.5382	17.788	17.26	17.2632	80104330.0
2022-05-16 11:00:00	NVDA	Stock	17.262	17.548	17.188	17.509	65922560.0
2022-05-16 12:00:00	NVDA	Stock	17.506	17.589	17.274	17.302	44530730.0
2022-05-16 13:00:00	NVDA	Stock	17.304	17.608	17.25	17.5263	43994840.0
2022-05-16 14:00:00	NVDA	Stock	17.533	17.68	17.449	17.586	48096270.0
2022-05-16 15:00:00	NVDA	Stock	17.5835	17.615	17.182	17.259	55230820.0
2022-05-16 16:00:00	NVDA	Stock	17.264	17.264	17.2	17.24	18747670.0
2022-05-16 17:00:00	NVDA	Stock	17.242	17.243	17.2281	17.23	81460.0
2022-05-16 18:00:00	NVDA	Stock	17.239	17.27	17.237	17.268	89370.0
2022-05-16 19:00:00	NVDA	Stock	17.252	17.255	17.21	17.21	213900.0
2022-05-16 04:00:00	AMZN	Stock	112.5	112.5	112.5	112.5	2000.0
2022-05-16 06:00:00	AMZN	Stock	112.1	112.1	112.1	112.1	6400.0

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

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