PREVIEW / stock_1hour / 2021-04-13

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-04-13.parquet
  size:    1.4 MB
  rows:    65,731
  symbols: 2,950

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-04-13 04:00:00	AAPL	Stock	131.03	131.22	130.81	130.81	14448.0
2021-04-13 05:00:00	AAPL	Stock	130.87	131.09	130.8	131.09	16750.0
2021-04-13 06:00:00	AAPL	Stock	131.08	131.08	130.71	130.71	5602.0
2021-04-13 07:00:00	AAPL	Stock	130.84	130.94	130.62	130.78	142333.0
2021-04-13 08:00:00	AAPL	Stock	130.8	131.95	130.65	131.85	692084.0
2021-04-13 09:00:00	AAPL	Stock	131.84	133.69	131.38	133.115	13115695.0
2021-04-13 10:00:00	AAPL	Stock	133.12	133.64	132.77	133.155	11801537.0
2021-04-13 11:00:00	AAPL	Stock	133.155	133.435	132.82	133.053	7070948.0
2021-04-13 12:00:00	AAPL	Stock	133.06	134.66	133.0	134.13	15812491.0
2021-04-13 13:00:00	AAPL	Stock	134.135	134.53	134.0701	134.27	6244970.0
2021-04-13 14:00:00	AAPL	Stock	134.2757	134.55	134.05	134.36	6233377.0
2021-04-13 15:00:00	AAPL	Stock	134.355	134.64	134.22	134.41	11183624.0
2021-04-13 16:00:00	AAPL	Stock	134.43	134.59	134.4	134.46	7919052.0
2021-04-13 17:00:00	AAPL	Stock	134.44	134.48	134.31	134.35	84964.0
2021-04-13 18:00:00	AAPL	Stock	134.35	134.4	134.24	134.28	47478.0
2021-04-13 19:00:00	AAPL	Stock	134.28	134.3	134.19	134.22	119122.0
2021-04-13 04:00:00	MSFT	Stock	256.36	256.67	256.14	256.14	837.0
2021-04-13 05:00:00	MSFT	Stock	256.06	256.41	255.71	256.22	3287.0
2021-04-13 06:00:00	MSFT	Stock	256.51	256.51	256.05	256.05	758.0
2021-04-13 07:00:00	MSFT	Stock	256.13	256.55	255.5	255.98	15553.0
2021-04-13 08:00:00	MSFT	Stock	255.91	257.71	255.14	257.5	75695.0
2021-04-13 09:00:00	MSFT	Stock	257.4804	259.19	256.89	258.895	2601161.0
2021-04-13 10:00:00	MSFT	Stock	258.93	259.0	257.0	257.475	2680395.0
2021-04-13 11:00:00	MSFT	Stock	257.475	257.6606	256.83	257.16	1685508.0
2021-04-13 12:00:00	MSFT	Stock	257.16	258.06	257.09	257.3509	1728992.0
2021-04-13 13:00:00	MSFT	Stock	257.35	258.0967	257.27	257.88	1134821.0
2021-04-13 14:00:00	MSFT	Stock	257.875	258.46	257.58	258.38	1365642.0
2021-04-13 15:00:00	MSFT	Stock	258.385	258.75	257.99	258.49	2895335.0
2021-04-13 16:00:00	MSFT	Stock	258.49	258.75	258.05	258.5989	4083725.0
2021-04-13 17:00:00	MSFT	Stock	258.4568	258.65	258.4	258.41	3498.0
2021-04-13 18:00:00	MSFT	Stock	258.4	258.42	258.08	258.08	3970.0
2021-04-13 19:00:00	MSFT	Stock	258.29	258.29	258.08	258.22	9339.0
2021-04-13 04:00:00	NVDA	Stock	15.15	15.15	15.1188	15.1273	78080.0
2021-04-13 05:00:00	NVDA	Stock	15.13	15.17	15.13	15.17	84320.0
2021-04-13 06:00:00	NVDA	Stock	15.1802	15.1875	15.1702	15.1768	117200.0
2021-04-13 07:00:00	NVDA	Stock	15.1802	15.1875	15.15	15.1688	413440.0
2021-04-13 08:00:00	NVDA	Stock	15.175	15.3228	15.1515	15.3082	3253000.0
2021-04-13 09:00:00	NVDA	Stock	15.3082	15.6222	15.1258	15.5645	146109880.0
2021-04-13 10:00:00	NVDA	Stock	15.5642	15.635	15.4528	15.5541	95005280.0
2021-04-13 11:00:00	NVDA	Stock	15.5533	15.5715	15.4162	15.4518	45239840.0
2021-04-13 12:00:00	NVDA	Stock	15.4506	15.5275	15.4148	15.4548	30797520.0
2021-04-13 13:00:00	NVDA	Stock	15.4615	15.6162	15.4613	15.5798	27443000.0
2021-04-13 14:00:00	NVDA	Stock	15.5857	15.6298	15.5	15.61	28207320.0
2021-04-13 15:00:00	NVDA	Stock	15.6118	15.7	15.5818	15.6795	54949680.0
2021-04-13 16:00:00	NVDA	Stock	15.6795	15.6795	15.6625	15.6788	26571640.0
2021-04-13 17:00:00	NVDA	Stock	15.6792	15.6792	15.638	15.6575	486120.0
2021-04-13 18:00:00	NVDA	Stock	15.6442	15.65	15.6325	15.6363	153360.0
2021-04-13 19:00:00	NVDA	Stock	15.6525	15.6525	15.6125	15.6375	421520.0
2021-04-13 07:00:00	AMZN	Stock	169.3475	169.5	169.3395	169.5	26840.0
2021-04-13 08:00:00	AMZN	Stock	169.4	170.4	168.5471	170.35	222500.0

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

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