PREVIEW / stock_1hour / 2021-11-03

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-11-03.parquet
  size:    1.5 MB
  rows:    66,881
  symbols: 2,717

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-11-03 04:00:00	AAPL	Stock	150.05	150.39	150.05	150.19	10171.0
2021-11-03 05:00:00	AAPL	Stock	150.1	150.21	150.05	150.08	5522.0
2021-11-03 06:00:00	AAPL	Stock	150.01	150.11	149.99	150.0	13874.0
2021-11-03 07:00:00	AAPL	Stock	150.0	150.26	149.98	150.23	43699.0
2021-11-03 08:00:00	AAPL	Stock	149.95	150.45	149.95	150.33	195289.0
2021-11-03 09:00:00	AAPL	Stock	150.34	150.97	149.82	150.72	6499538.0
2021-11-03 10:00:00	AAPL	Stock	150.73	150.82	150.1103	150.2684	5045736.0
2021-11-03 11:00:00	AAPL	Stock	150.265	150.58	150.16	150.515	3391582.0
2021-11-03 12:00:00	AAPL	Stock	150.51	150.7	150.35	150.3795	2761810.0
2021-11-03 13:00:00	AAPL	Stock	150.38	150.45	150.19	150.36	2392495.0
2021-11-03 14:00:00	AAPL	Stock	150.37	151.41	150.21	151.22	7148741.0
2021-11-03 15:00:00	AAPL	Stock	151.22	151.97	151.04	151.49	8780547.0
2021-11-03 16:00:00	AAPL	Stock	151.48	151.52	151.39	151.47	8707394.0
2021-11-03 17:00:00	AAPL	Stock	151.45	151.46	151.38	151.39	51088.0
2021-11-03 18:00:00	AAPL	Stock	151.41	151.62	151.38	151.6	48997.0
2021-11-03 19:00:00	AAPL	Stock	151.62	152.0	151.61	151.77	111131.0
2021-11-03 04:00:00	MSFT	Stock	333.15	334.46	333.15	334.19	3819.0
2021-11-03 05:00:00	MSFT	Stock	334.4	334.45	334.4	334.41	388.0
2021-11-03 06:00:00	MSFT	Stock	334.58	334.58	334.01	334.01	2453.0
2021-11-03 07:00:00	MSFT	Stock	334.0	334.35	333.78	334.35	3303.0
2021-11-03 08:00:00	MSFT	Stock	334.0	334.4	333.6	333.9	37132.0
2021-11-03 09:00:00	MSFT	Stock	333.8401	334.58	331.36	332.85	1888066.0
2021-11-03 10:00:00	MSFT	Stock	332.91	332.97	330.7798	331.48	1867441.0
2021-11-03 11:00:00	MSFT	Stock	331.49	332.03	330.65	331.99	1209375.0
2021-11-03 12:00:00	MSFT	Stock	331.97	332.06	331.168	331.75	967943.0
2021-11-03 13:00:00	MSFT	Stock	331.77	332.5499	331.43	332.085	770780.0
2021-11-03 14:00:00	MSFT	Stock	332.11	334.84	331.8	334.01	2044729.0
2021-11-03 15:00:00	MSFT	Stock	334.04	334.9	333.77	333.98	2692668.0
2021-11-03 16:00:00	MSFT	Stock	334.0	334.19	333.52	333.81	3300844.0
2021-11-03 17:00:00	MSFT	Stock	333.9	333.96	333.71	333.9	7583.0
2021-11-03 18:00:00	MSFT	Stock	333.7601	334.3	333.7601	334.0001	3833.0
2021-11-03 19:00:00	MSFT	Stock	334.25	334.8	334.25	334.8	7890.0
2021-11-03 04:00:00	NVDA	Stock	26.6	26.643	26.5	26.63	86020.0
2021-11-03 05:00:00	NVDA	Stock	26.673	26.784	26.673	26.784	39970.0
2021-11-03 06:00:00	NVDA	Stock	26.756	26.777	26.632	26.66	159940.0
2021-11-03 07:00:00	NVDA	Stock	26.655	26.7	26.645	26.698	136650.0
2021-11-03 08:00:00	NVDA	Stock	26.6562	26.722	26.62	26.7	867880.0
2021-11-03 09:00:00	NVDA	Stock	26.685	26.784	26.378	26.577	36027310.0
2021-11-03 10:00:00	NVDA	Stock	26.583	26.584	26.235	26.3767	29041880.0
2021-11-03 11:00:00	NVDA	Stock	26.379	26.517	26.299	26.4948	16743470.0
2021-11-03 12:00:00	NVDA	Stock	26.4945	26.4945	26.357	26.435	14374000.0
2021-11-03 13:00:00	NVDA	Stock	26.437	26.472	26.26	26.262	11263370.0
2021-11-03 14:00:00	NVDA	Stock	26.2695	26.62	26.255	26.5695	28521230.0
2021-11-03 15:00:00	NVDA	Stock	26.567	26.65	26.527	26.597	23760370.0
2021-11-03 16:00:00	NVDA	Stock	26.598	26.619	26.535	26.575	13641860.0
2021-11-03 17:00:00	NVDA	Stock	26.579	26.645	26.575	26.626	154250.0
2021-11-03 18:00:00	NVDA	Stock	26.624	26.68	26.613	26.678	131660.0
2021-11-03 19:00:00	NVDA	Stock	26.698	26.75	26.675	26.75	299000.0
2021-11-03 07:00:00	AMZN	Stock	165.825	165.825	165.7625	165.7625	13360.0
2021-11-03 08:00:00	AMZN	Stock	165.4511	165.7645	165.4511	165.7645	18000.0

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

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