PREVIEW / stock_1hour / 2021-11-26

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-11-26.parquet
  size:    1.1 MB
  rows:    48,307
  symbols: 2,605

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-26 04:00:00	AAPL	Stock	160.0	160.59	157.85	158.28	187345.0
2021-11-26 05:00:00	AAPL	Stock	158.16	158.84	158.16	158.49	43442.0
2021-11-26 06:00:00	AAPL	Stock	158.49	159.37	158.32	158.99	60430.0
2021-11-26 07:00:00	AAPL	Stock	158.75	159.76	158.58	159.36	267691.0
2021-11-26 08:00:00	AAPL	Stock	159.51	161.536	158.79	158.9599	761692.0
2021-11-26 09:00:00	AAPL	Stock	158.98	160.45	158.36	158.75	11730152.0
2021-11-26 10:00:00	AAPL	Stock	158.74	158.97	157.43	157.6101	13867877.0
2021-11-26 11:00:00	AAPL	Stock	157.61	158.185	156.9	158.09	12602907.0
2021-11-26 12:00:00	AAPL	Stock	158.09	158.225	156.36	156.88	18082346.0
2021-11-26 13:00:00	AAPL	Stock	156.88	158.69	156.77	157.45	7847203.0
2021-11-26 14:00:00	AAPL	Stock	157.46	157.5	157.3	157.36	83655.0
2021-11-26 15:00:00	AAPL	Stock	157.38	157.38	157.0	157.15	54174.0
2021-11-26 16:00:00	AAPL	Stock	157.15	157.4	156.81	157.4	21822.0
2021-11-26 04:00:00	MSFT	Stock	335.83	336.5	333.0	333.85	37839.0
2021-11-26 05:00:00	MSFT	Stock	334.0	334.3	333.1	333.7	9052.0
2021-11-26 06:00:00	MSFT	Stock	333.8	335.5	333.5	334.2	53614.0
2021-11-26 07:00:00	MSFT	Stock	334.2	335.2	333.99	334.0	60854.0
2021-11-26 08:00:00	MSFT	Stock	334.7	335.35	333.65	334.4	56343.0
2021-11-26 09:00:00	MSFT	Stock	334.38	337.93	334.03	336.42	2565502.0
2021-11-26 10:00:00	MSFT	Stock	336.44	336.8	333.1	333.48	2866309.0
2021-11-26 11:00:00	MSFT	Stock	333.48	333.48	330.34	330.99	3129056.0
2021-11-26 12:00:00	MSFT	Stock	331.0	332.42	328.12	329.77	5742053.0
2021-11-26 13:00:00	MSFT	Stock	329.68	331.25	329.2	329.89	3662433.0
2021-11-26 14:00:00	MSFT	Stock	329.9	330.37	329.68	329.7	11849.0
2021-11-26 15:00:00	MSFT	Stock	329.68	329.79	329.42	329.53	8145.0
2021-11-26 16:00:00	MSFT	Stock	329.68	330.0	329.6	330.0	5581.0
2021-11-26 04:00:00	NVDA	Stock	31.944	32.6	31.341	31.789	682180.0
2021-11-26 05:00:00	NVDA	Stock	31.789	31.999	31.711	31.898	365450.0
2021-11-26 06:00:00	NVDA	Stock	31.897	32.14	31.87	32.136	224590.0
2021-11-26 07:00:00	NVDA	Stock	32.105	32.189	31.871	32.015	1667200.0
2021-11-26 08:00:00	NVDA	Stock	32.0346	32.674	31.851	31.938	3675650.0
2021-11-26 09:00:00	NVDA	Stock	31.946	32.71	31.938	32.291	46528670.0
2021-11-26 10:00:00	NVDA	Stock	32.283	32.346	31.675	31.7927	38590370.0
2021-11-26 11:00:00	NVDA	Stock	31.783	31.7843	31.35	31.548	42895240.0
2021-11-26 12:00:00	NVDA	Stock	31.551	31.898	31.492	31.503	48570700.0
2021-11-26 13:00:00	NVDA	Stock	31.53	31.619	31.4	31.485	20865600.0
2021-11-26 14:00:00	NVDA	Stock	31.492	31.54	31.45	31.45	269170.0
2021-11-26 15:00:00	NVDA	Stock	31.462	31.499	31.443	31.46	197610.0
2021-11-26 16:00:00	NVDA	Stock	31.46	31.47	31.441	31.464	65610.0
2021-11-26 04:00:00	AMZN	Stock	178.0	178.0	177.4825	177.649	25620.0
2021-11-26 05:00:00	AMZN	Stock	178.0	178.0	178.0	178.0	2560.0
2021-11-26 06:00:00	AMZN	Stock	178.0	178.5	178.0	178.5	9200.0
2021-11-26 07:00:00	AMZN	Stock	178.5	179.3955	178.251	178.495	101300.0
2021-11-26 08:00:00	AMZN	Stock	179.25	179.7495	178.305	179.5495	174640.0
2021-11-26 09:00:00	AMZN	Stock	179.6	181.675	177.7771	179.4833	7606960.0
2021-11-26 10:00:00	AMZN	Stock	179.446	179.6625	176.296	176.5833	5734760.0
2021-11-26 11:00:00	AMZN	Stock	176.5555	177.0085	175.755	176.534	3694700.0
2021-11-26 12:00:00	AMZN	Stock	176.5895	177.0972	175.2075	175.2695	5363980.0
2021-11-26 13:00:00	AMZN	Stock	175.228	175.7595	175.0	175.4375	4513140.0
2021-11-26 14:00:00	AMZN	Stock	175.4625	175.6495	175.228	175.255	204020.0

> showing 50 of 48,307 rows — these rows as CSV

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