PREVIEW / stock_1hour / 2020-09-28

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-09-28.parquet
  size:    1.2 MB
  rows:    57,527
  symbols: 2,507

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
2020-09-28 04:00:00	AAPL	Stock	113.8	114.42	113.7	114.19	70536.0
2020-09-28 05:00:00	AAPL	Stock	114.2	114.4	114.2	114.26	30864.0
2020-09-28 06:00:00	AAPL	Stock	114.21	114.9	114.18	114.7	137323.0
2020-09-28 07:00:00	AAPL	Stock	114.6	115.45	114.35	115.4	822224.0
2020-09-28 08:00:00	AAPL	Stock	115.41	115.5	114.35	115.15	1245102.0
2020-09-28 09:00:00	AAPL	Stock	115.16	115.32	112.96	113.487	21401470.0
2020-09-28 10:00:00	AAPL	Stock	113.49	113.89	112.78	112.9	19446434.0
2020-09-28 11:00:00	AAPL	Stock	112.908	113.85	112.9	113.67	13158795.0
2020-09-28 12:00:00	AAPL	Stock	113.67	113.97	113.13	113.91	10498575.0
2020-09-28 13:00:00	AAPL	Stock	113.914	114.72	113.64	114.565	13869340.0
2020-09-28 14:00:00	AAPL	Stock	114.56	114.68	113.81	114.335	12155962.0
2020-09-28 15:00:00	AAPL	Stock	114.34	115.0	114.16	115.0	22225006.0
2020-09-28 16:00:00	AAPL	Stock	115.0	115.37	113.35	115.18	9970919.0
2020-09-28 17:00:00	AAPL	Stock	115.19	115.2	114.91	114.98	189406.0
2020-09-28 18:00:00	AAPL	Stock	115.0	115.25	115.0	115.18	160098.0
2020-09-28 19:00:00	AAPL	Stock	115.18	115.5	115.17	115.5	210469.0
2020-09-28 04:00:00	MSFT	Stock	209.48	209.58	209.16	209.16	6242.0
2020-09-28 05:00:00	MSFT	Stock	209.16	209.58	209.16	209.57	3781.0
2020-09-28 06:00:00	MSFT	Stock	209.57	211.2	209.57	210.96	57981.0
2020-09-28 07:00:00	MSFT	Stock	210.52	211.3	210.15	211.3	62719.0
2020-09-28 08:00:00	MSFT	Stock	210.5	212.0	210.1	211.46	84190.0
2020-09-28 09:00:00	MSFT	Stock	211.44	212.57	209.61	209.75	4666889.0
2020-09-28 10:00:00	MSFT	Stock	209.755	210.38	208.06	208.55	3531576.0
2020-09-28 11:00:00	MSFT	Stock	208.56	209.93	208.32	209.155	2400769.0
2020-09-28 12:00:00	MSFT	Stock	209.18	209.29	208.3	209.29	1741641.0
2020-09-28 13:00:00	MSFT	Stock	209.26	209.7	208.66	209.41	2556419.0
2020-09-28 14:00:00	MSFT	Stock	209.395	209.59	209.03	209.45	2401187.0
2020-09-28 15:00:00	MSFT	Stock	209.43	209.74	208.776	209.61	5794552.0
2020-09-28 16:00:00	MSFT	Stock	209.44	211.0	209.2	210.0	4251690.0
2020-09-28 17:00:00	MSFT	Stock	209.9	210.0	209.77	210.0	10133.0
2020-09-28 18:00:00	MSFT	Stock	210.0	211.04	209.44	210.48	19294.0
2020-09-28 19:00:00	MSFT	Stock	210.36	211.0	210.36	210.95	22491.0
2020-09-28 04:00:00	NVDA	Stock	12.9988	13.0585	12.9875	13.038	119040.0
2020-09-28 05:00:00	NVDA	Stock	13.0305	13.039	13.025	13.0325	34840.0
2020-09-28 06:00:00	NVDA	Stock	13.0325	13.1108	13.0325	13.107	470840.0
2020-09-28 07:00:00	NVDA	Stock	13.105	13.106	13.0525	13.0925	1318160.0
2020-09-28 08:00:00	NVDA	Stock	13.0949	13.1458	13.05	13.1155	2610160.0
2020-09-28 09:00:00	NVDA	Stock	13.1118	13.125	12.75	12.8298	105426640.0
2020-09-28 10:00:00	NVDA	Stock	12.8264	12.917	12.7775	12.7995	105910520.0
2020-09-28 11:00:00	NVDA	Stock	12.7988	12.925	12.7925	12.8286	49076520.0
2020-09-28 12:00:00	NVDA	Stock	12.8312	12.8956	12.7738	12.8885	38352640.0
2020-09-28 13:00:00	NVDA	Stock	12.8876	12.925	12.8355	12.9189	41718560.0
2020-09-28 14:00:00	NVDA	Stock	12.9175	13.0023	12.8873	12.9934	46366760.0
2020-09-28 15:00:00	NVDA	Stock	12.9943	13.035	12.9363	13.035	70515640.0
2020-09-28 16:00:00	NVDA	Stock	13.035	13.0625	13.0125	13.0505	37013600.0
2020-09-28 17:00:00	NVDA	Stock	13.0512	13.0562	13.035	13.0358	937680.0
2020-09-28 18:00:00	NVDA	Stock	13.0355	13.0662	13.035	13.05	325960.0
2020-09-28 19:00:00	NVDA	Stock	13.035	13.075	13.035	13.07	498200.0
2020-09-28 04:00:00	AMZN	Stock	156.0	156.0	156.0	156.0	2920.0
2020-09-28 05:00:00	AMZN	Stock	156.6	156.6	156.6	156.6	2000.0

> showing 50 of 57,527 rows — these rows as CSV

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