PREVIEW / stock_1hour / 2021-01-12

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-01-12.parquet
  size:    1.4 MB
  rows:    66,022
  symbols: 2,697

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-01-12 04:00:00	AAPL	Stock	129.1	129.63	129.0	129.62	24069.0
2021-01-12 05:00:00	AAPL	Stock	129.62	129.9	129.13	129.41	15099.0
2021-01-12 06:00:00	AAPL	Stock	129.49	129.87	129.3	129.5	34582.0
2021-01-12 07:00:00	AAPL	Stock	129.49	129.97	129.4	129.65	270537.0
2021-01-12 08:00:00	AAPL	Stock	129.428	129.95	128.61	128.88	674400.0
2021-01-12 09:00:00	AAPL	Stock	128.86	129.69	128.08	128.36	12389090.0
2021-01-12 10:00:00	AAPL	Stock	128.36	129.33	128.18	128.91	11828164.0
2021-01-12 11:00:00	AAPL	Stock	128.91	129.18	128.15	128.355	9452530.0
2021-01-12 12:00:00	AAPL	Stock	128.358	128.39	126.86	127.945	13617792.0
2021-01-12 13:00:00	AAPL	Stock	127.95	128.44	127.71	128.195	7042840.0
2021-01-12 14:00:00	AAPL	Stock	128.195	128.79	128.08	128.4	7797931.0
2021-01-12 15:00:00	AAPL	Stock	128.4	129.19	128.2	128.82	10920526.0
2021-01-12 16:00:00	AAPL	Stock	128.8	129.0	127.895	128.95	5239800.0
2021-01-12 17:00:00	AAPL	Stock	128.94	128.99	128.8	128.9	800183.0
2021-01-12 18:00:00	AAPL	Stock	128.9	129.0	128.8	129.0	82284.0
2021-01-12 19:00:00	AAPL	Stock	128.99	129.23	128.95	129.22	120308.0
2021-01-12 04:00:00	MSFT	Stock	217.68	218.09	217.51	218.09	1393.0
2021-01-12 05:00:00	MSFT	Stock	218.06	218.06	217.51	217.51	3132.0
2021-01-12 06:00:00	MSFT	Stock	217.51	217.51	217.5	217.5	1221.0
2021-01-12 07:00:00	MSFT	Stock	217.8	217.85	217.5	217.5	17965.0
2021-01-12 08:00:00	MSFT	Stock	217.985	217.99	216.01	216.73	51124.0
2021-01-12 09:00:00	MSFT	Stock	216.51	217.1	214.365	215.03	2772408.0
2021-01-12 10:00:00	MSFT	Stock	215.06	215.758	214.392	214.79	2744309.0
2021-01-12 11:00:00	MSFT	Stock	214.8	215.56	214.55	214.66	2385128.0
2021-01-12 12:00:00	MSFT	Stock	214.65	214.7	213.32	214.42	2212125.0
2021-01-12 13:00:00	MSFT	Stock	214.419	215.38	214.33	215.17	1255418.0
2021-01-12 14:00:00	MSFT	Stock	215.18	215.67	214.75	215.05	1722797.0
2021-01-12 15:00:00	MSFT	Stock	215.06	215.4	214.76	214.93	2521166.0
2021-01-12 16:00:00	MSFT	Stock	214.93	215.32	214.2	215.05	2377450.0
2021-01-12 17:00:00	MSFT	Stock	214.95	215.0	214.95	214.96	6184.0
2021-01-12 18:00:00	MSFT	Stock	214.95	215.07	214.93	215.04	6419.0
2021-01-12 19:00:00	MSFT	Stock	215.03	215.23	214.88	215.05	9855.0
2021-01-12 04:00:00	NVDA	Stock	13.75	13.7775	13.725	13.7412	66600.0
2021-01-12 05:00:00	NVDA	Stock	13.7412	13.775	13.74	13.7525	64000.0
2021-01-12 06:00:00	NVDA	Stock	13.7775	13.8	13.765	13.8	126160.0
2021-01-12 07:00:00	NVDA	Stock	13.8	13.8	13.7175	13.7502	899440.0
2021-01-12 08:00:00	NVDA	Stock	13.7679	13.775	13.6912	13.7192	1746560.0
2021-01-12 09:00:00	NVDA	Stock	13.708	13.755	13.345	13.4845	55188000.0
2021-01-12 10:00:00	NVDA	Stock	13.4846	13.522	13.3875	13.482	31906080.0
2021-01-12 11:00:00	NVDA	Stock	13.4842	13.6562	13.4671	13.5239	35960440.0
2021-01-12 12:00:00	NVDA	Stock	13.526	13.55	13.4032	13.5452	27197640.0
2021-01-12 13:00:00	NVDA	Stock	13.5445	13.5668	13.4958	13.5382	14359480.0
2021-01-12 14:00:00	NVDA	Stock	13.529	13.569	13.4362	13.4505	20516080.0
2021-01-12 15:00:00	NVDA	Stock	13.454	13.5018	13.405	13.485	31317280.0
2021-01-12 16:00:00	NVDA	Stock	13.4848	13.5479	13.4275	13.4628	7206760.0
2021-01-12 17:00:00	NVDA	Stock	13.475	13.4848	13.475	13.4848	93800.0
2021-01-12 18:00:00	NVDA	Stock	13.4923	13.4923	13.4738	13.4773	133840.0
2021-01-12 19:00:00	NVDA	Stock	13.475	13.4848	13.465	13.465	64440.0
2021-01-12 06:00:00	AMZN	Stock	156.25	156.25	156.1	156.1	11740.0
2021-01-12 07:00:00	AMZN	Stock	156.2	156.534	156.2	156.325	159640.0

> showing 50 of 66,022 rows — these rows as CSV

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