PREVIEW / stock_1hour / 2021-12-08

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-12-08.parquet
  size:    1.4 MB
  rows:    65,449
  symbols: 2,670

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-12-08 04:00:00	AAPL	Stock	172.86	173.48	172.38	172.78	96918.0
2021-12-08 05:00:00	AAPL	Stock	172.81	172.87	171.9	172.24	45515.0
2021-12-08 06:00:00	AAPL	Stock	172.18	173.1	172.15	172.4	102638.0
2021-12-08 07:00:00	AAPL	Stock	172.48	172.74	172.0	172.29	269544.0
2021-12-08 08:00:00	AAPL	Stock	172.5499	172.7398	171.55	172.091	510323.0
2021-12-08 09:00:00	AAPL	Stock	172.09	173.46	170.7	172.7201	16401835.0
2021-12-08 10:00:00	AAPL	Stock	172.68	174.4465	172.57	173.92	19824294.0
2021-12-08 11:00:00	AAPL	Stock	173.92	174.87	173.27	174.8301	13755516.0
2021-12-08 12:00:00	AAPL	Stock	174.83	174.83	173.75	174.27	8238136.0
2021-12-08 13:00:00	AAPL	Stock	174.28	174.82	174.035	174.54	5842020.0
2021-12-08 14:00:00	AAPL	Stock	174.54	175.96	174.0726	174.7754	13161056.0
2021-12-08 15:00:00	AAPL	Stock	174.7729	175.28	174.05	175.01	13794979.0
2021-12-08 16:00:00	AAPL	Stock	175.13	175.35	174.96	175.2	8896290.0
2021-12-08 17:00:00	AAPL	Stock	175.15	175.25	174.62	174.87	66659.0
2021-12-08 18:00:00	AAPL	Stock	174.87	174.92	174.48	174.72	103520.0
2021-12-08 19:00:00	AAPL	Stock	174.71	174.79	174.6	174.75	74378.0
2021-12-08 04:00:00	MSFT	Stock	336.5	336.74	335.61	336.5	12718.0
2021-12-08 05:00:00	MSFT	Stock	336.5	336.69	336.2	336.3	4338.0
2021-12-08 06:00:00	MSFT	Stock	336.29	338.5	336.29	336.96	13242.0
2021-12-08 07:00:00	MSFT	Stock	336.98	337.49	335.23	335.9	37912.0
2021-12-08 08:00:00	MSFT	Stock	336.5899	337.3001	334.11	334.48	35744.0
2021-12-08 09:00:00	MSFT	Stock	334.25	335.5	332.272	332.8237	2036561.0
2021-12-08 10:00:00	MSFT	Stock	332.76	333.53	331.46	331.69	2069695.0
2021-12-08 11:00:00	MSFT	Stock	331.71	332.29	330.8	331.6599	1593747.0
2021-12-08 12:00:00	MSFT	Stock	331.62	331.88	330.98	331.5642	1183452.0
2021-12-08 13:00:00	MSFT	Stock	331.57	332.94	331.33	332.61	1236266.0
2021-12-08 14:00:00	MSFT	Stock	332.61	333.11	332.11	333.1	1166190.0
2021-12-08 15:00:00	MSFT	Stock	333.1	335.31	331.46	334.96	3101919.0
2021-12-08 16:00:00	MSFT	Stock	334.96	335.2	334.71	334.71	5226429.0
2021-12-08 17:00:00	MSFT	Stock	334.71	334.94	334.71	334.85	3782.0
2021-12-08 18:00:00	MSFT	Stock	334.8	334.97	334.72	334.72	4874.0
2021-12-08 19:00:00	MSFT	Stock	334.73	334.73	334.5	334.6	11899.0
2021-12-08 04:00:00	NVDA	Stock	32.527	32.58	31.915	32.024	299150.0
2021-12-08 05:00:00	NVDA	Stock	32.02	32.125	31.989	32.099	80530.0
2021-12-08 06:00:00	NVDA	Stock	32.075	32.379	32.0	32.0	249880.0
2021-12-08 07:00:00	NVDA	Stock	32.0	32.18	31.97	32.152	743340.0
2021-12-08 08:00:00	NVDA	Stock	32.0188	32.247	31.91	31.95	1335060.0
2021-12-08 09:00:00	NVDA	Stock	31.967	32.29	31.6	31.7545	68708510.0
2021-12-08 10:00:00	NVDA	Stock	31.747	32.053	31.573	31.869	68059820.0
2021-12-08 11:00:00	NVDA	Stock	31.868	32.213	31.8	32.075	46624090.0
2021-12-08 12:00:00	NVDA	Stock	32.071	32.099	31.761	31.7925	34344420.0
2021-12-08 13:00:00	NVDA	Stock	31.797	32.058	31.741	31.9882	28900010.0
2021-12-08 14:00:00	NVDA	Stock	31.988	32.073	31.421	31.8125	48437610.0
2021-12-08 15:00:00	NVDA	Stock	31.807	32.01	31.6085	31.824	56567600.0
2021-12-08 16:00:00	NVDA	Stock	31.826	31.826	31.738	31.814	17686790.0
2021-12-08 17:00:00	NVDA	Stock	31.812	31.814	31.74	31.78	196830.0
2021-12-08 18:00:00	NVDA	Stock	31.78	31.785	31.68	31.7	181120.0
2021-12-08 19:00:00	NVDA	Stock	31.681	31.73	31.6	31.619	355310.0
2021-12-08 05:00:00	AMZN	Stock	176.642	176.642	176.642	176.642	8000.0
2021-12-08 07:00:00	AMZN	Stock	176.8	176.9	176.35	176.6	35340.0

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

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