PREVIEW / stock_1hour / 2021-06-17

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-06-17.parquet
  size:    1.4 MB
  rows:    65,420
  symbols: 2,953

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
2021-06-17 04:00:00	AAPL	Stock	129.1	129.25	128.9	128.96	32715.0
2021-06-17 05:00:00	AAPL	Stock	128.92	129.4	128.92	129.34	10108.0
2021-06-17 06:00:00	AAPL	Stock	129.37	129.5	129.15	129.29	9218.0
2021-06-17 07:00:00	AAPL	Stock	129.26	129.75	129.1	129.37	176385.0
2021-06-17 08:00:00	AAPL	Stock	129.3701	129.74	129.24	129.5	317623.0
2021-06-17 09:00:00	AAPL	Stock	129.5	130.87	129.43	130.79	9333787.0
2021-06-17 10:00:00	AAPL	Stock	130.8	131.915	130.63	131.49	15125498.0
2021-06-17 11:00:00	AAPL	Stock	131.48	132.55	131.4	131.9382	12867243.0
2021-06-17 12:00:00	AAPL	Stock	131.94	131.99	130.95	131.2631	12053226.0
2021-06-17 13:00:00	AAPL	Stock	131.265	132.13	131.245	131.715	7123331.0
2021-06-17 14:00:00	AAPL	Stock	131.72	132.15	131.6	131.96	6158804.0
2021-06-17 15:00:00	AAPL	Stock	131.96	132.255	131.74	131.78	11818174.0
2021-06-17 16:00:00	AAPL	Stock	131.79	131.95	130.8	131.9	11068246.0
2021-06-17 17:00:00	AAPL	Stock	131.88	131.9	131.8	131.86	19767.0
2021-06-17 18:00:00	AAPL	Stock	131.87	132.01	131.82	132.01	38731.0
2021-06-17 19:00:00	AAPL	Stock	132.075	132.09	131.88	132.04	44853.0
2021-06-17 04:00:00	MSFT	Stock	255.0	256.0	255.0	255.32	2932.0
2021-06-17 05:00:00	MSFT	Stock	255.21	255.52	255.21	255.41	1825.0
2021-06-17 06:00:00	MSFT	Stock	255.84	256.2	255.84	255.85	2074.0
2021-06-17 07:00:00	MSFT	Stock	255.8	256.7	255.8	255.89	17320.0
2021-06-17 08:00:00	MSFT	Stock	256.5101	256.737	255.47	256.0	37534.0
2021-06-17 09:00:00	MSFT	Stock	256.19	257.97	255.64	257.805	1825608.0
2021-06-17 10:00:00	MSFT	Stock	257.82	259.17	257.52	258.27	2868954.0
2021-06-17 11:00:00	MSFT	Stock	258.3	260.62	258.23	260.51	2816562.0
2021-06-17 12:00:00	MSFT	Stock	260.52	260.6	259.36	260.22	2049092.0
2021-06-17 13:00:00	MSFT	Stock	260.23	261.43	260.19	260.925	1865958.0
2021-06-17 14:00:00	MSFT	Stock	260.95	261.46	260.57	261.1	1694096.0
2021-06-17 15:00:00	MSFT	Stock	261.12	261.75	260.81	260.91	3546499.0
2021-06-17 16:00:00	MSFT	Stock	260.91	261.19	260.76	261.0	4344468.0
2021-06-17 17:00:00	MSFT	Stock	261.0	261.08	260.9	260.9	3309.0
2021-06-17 18:00:00	MSFT	Stock	260.93	261.35	260.91	261.35	3910.0
2021-06-17 19:00:00	MSFT	Stock	261.01	261.33	261.01	261.17	3928.0
2021-06-17 04:00:00	NVDA	Stock	17.6818	17.6818	17.6818	17.6818	4000.0
2021-06-17 05:00:00	NVDA	Stock	17.6918	17.7	17.6918	17.7	32720.0
2021-06-17 06:00:00	NVDA	Stock	17.6865	17.6875	17.662	17.662	34120.0
2021-06-17 07:00:00	NVDA	Stock	17.675	17.747	17.66	17.7038	131960.0
2021-06-17 08:00:00	NVDA	Stock	17.722	17.73	17.6832	17.7132	598280.0
2021-06-17 09:00:00	NVDA	Stock	17.7208	18.2312	17.7125	18.2038	75412440.0
2021-06-17 10:00:00	NVDA	Stock	18.2068	18.6875	18.199	18.6338	153449320.0
2021-06-17 11:00:00	NVDA	Stock	18.6322	18.835	18.61	18.7075	110417080.0
2021-06-17 12:00:00	NVDA	Stock	18.7158	18.7467	18.5398	18.7158	83590960.0
2021-06-17 13:00:00	NVDA	Stock	18.7178	18.8175	18.693	18.7721	33118720.0
2021-06-17 14:00:00	NVDA	Stock	18.7768	18.8	18.7012	18.7029	25668640.0
2021-06-17 15:00:00	NVDA	Stock	18.7044	18.7785	18.629	18.6583	47651160.0
2021-06-17 16:00:00	NVDA	Stock	18.6572	18.725	18.2595	18.725	36197680.0
2021-06-17 17:00:00	NVDA	Stock	18.725	18.7405	18.7125	18.725	285920.0
2021-06-17 18:00:00	NVDA	Stock	18.7375	18.7412	18.725	18.7412	176040.0
2021-06-17 19:00:00	NVDA	Stock	18.7425	18.9	18.7425	18.887	1514520.0
2021-06-17 05:00:00	AMZN	Stock	169.75	169.75	169.75	169.75	8960.0
2021-06-17 07:00:00	AMZN	Stock	170.035	170.35	170.035	170.1005	47240.0

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

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