PREVIEW / stock_1hour / 2020-03-26

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-03-26.parquet
  size:    1.2 MB
  rows:    55,153
  symbols: 2,443

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-03-26 04:00:00	AAPL	Stock	60.8	61.0	60.5	60.825	90688.0
2020-03-26 05:00:00	AAPL	Stock	61.0	61.1325	60.75	60.98	14040.0
2020-03-26 06:00:00	AAPL	Stock	61.03	61.45	61.025	61.07	49696.0
2020-03-26 07:00:00	AAPL	Stock	61.0075	61.4	60.625	60.6725	489748.0
2020-03-26 08:00:00	AAPL	Stock	60.6275	61.575	60.1	61.5025	1969556.0
2020-03-26 09:00:00	AAPL	Stock	61.5	63.0475	61.2528	62.1975	28357748.0
2020-03-26 10:00:00	AAPL	Stock	62.2	63.155	61.8475	62.7322	31963468.0
2020-03-26 11:00:00	AAPL	Stock	62.7125	63.669	62.4775	63.445	22455660.0
2020-03-26 12:00:00	AAPL	Stock	63.4575	63.75	63.2075	63.5475	17057860.0
2020-03-26 13:00:00	AAPL	Stock	63.555	63.7325	62.54	62.985	18388612.0
2020-03-26 14:00:00	AAPL	Stock	62.9825	63.5888	62.9275	63.2408	19483324.0
2020-03-26 15:00:00	AAPL	Stock	63.2325	64.67	62.6475	64.62	41716108.0
2020-03-26 16:00:00	AAPL	Stock	64.4375	64.62	63.1992	64.375	28454572.0
2020-03-26 17:00:00	AAPL	Stock	64.3925	64.49	64.18	64.49	174748.0
2020-03-26 18:00:00	AAPL	Stock	64.4575	64.55	64.125	64.125	274312.0
2020-03-26 19:00:00	AAPL	Stock	64.15	64.75	64.0525	64.7325	241844.0
2020-03-26 04:00:00	MSFT	Stock	144.99	145.97	144.05	144.16	16611.0
2020-03-26 05:00:00	MSFT	Stock	144.56	145.5	144.45	145.38	9591.0
2020-03-26 06:00:00	MSFT	Stock	145.52	147.24	145.52	146.4	15777.0
2020-03-26 07:00:00	MSFT	Stock	146.85	146.88	144.88	145.0	61347.0
2020-03-26 08:00:00	MSFT	Stock	146.5	148.35	143.65	148.2	224975.0
2020-03-26 09:00:00	MSFT	Stock	148.0	152.63	147.26	151.94	6195637.0
2020-03-26 10:00:00	MSFT	Stock	152.0	154.24	151.22	153.2	8114007.0
2020-03-26 11:00:00	MSFT	Stock	153.14	153.975	151.76	153.4	5304007.0
2020-03-26 12:00:00	MSFT	Stock	153.47	154.0	152.84	153.85	4371749.0
2020-03-26 13:00:00	MSFT	Stock	153.85	154.0	151.67	152.62	4023969.0
2020-03-26 14:00:00	MSFT	Stock	152.62	154.07	152.159	153.6	4428281.0
2020-03-26 15:00:00	MSFT	Stock	153.59	156.66	152.421	156.11	12473474.0
2020-03-26 16:00:00	MSFT	Stock	155.88	156.13	153.126	155.55	9941701.0
2020-03-26 17:00:00	MSFT	Stock	155.56	155.9	155.0	155.7	53500.0
2020-03-26 18:00:00	MSFT	Stock	155.95	156.03	154.6	154.6	54175.0
2020-03-26 19:00:00	MSFT	Stock	154.7	156.0	154.34	155.69	76676.0
2020-03-26 04:00:00	NVDA	Stock	6.0915	6.1472	6.0915	6.1085	125800.0
2020-03-26 05:00:00	NVDA	Stock	6.1128	6.1128	6.0875	6.1	61240.0
2020-03-26 06:00:00	NVDA	Stock	6.0968	6.1252	6.0968	6.1252	103280.0
2020-03-26 07:00:00	NVDA	Stock	6.15	6.195	6.118	6.1315	679320.0
2020-03-26 08:00:00	NVDA	Stock	6.134	6.2293	6.0578	6.2238	3070280.0
2020-03-26 09:00:00	NVDA	Stock	6.225	6.3992	6.1875	6.3663	87815280.0
2020-03-26 10:00:00	NVDA	Stock	6.3682	6.501	6.3598	6.4522	95802640.0
2020-03-26 11:00:00	NVDA	Stock	6.4548	6.5555	6.429	6.4925	81249640.0
2020-03-26 12:00:00	NVDA	Stock	6.493	6.5032	6.419	6.4808	59762720.0
2020-03-26 13:00:00	NVDA	Stock	6.4811	6.484	6.2826	6.3536	85468240.0
2020-03-26 14:00:00	NVDA	Stock	6.3558	6.4125	6.2878	6.3838	68655680.0
2020-03-26 15:00:00	NVDA	Stock	6.3835	6.4415	6.2938	6.431	105069400.0
2020-03-26 16:00:00	NVDA	Stock	6.431	6.442	6.4	6.4189	15174280.0
2020-03-26 17:00:00	NVDA	Stock	6.4162	6.4347	6.4162	6.425	229200.0
2020-03-26 18:00:00	NVDA	Stock	6.4312	6.4548	6.41	6.41	1007880.0
2020-03-26 19:00:00	NVDA	Stock	6.4125	6.4475	6.4025	6.4475	678760.0
2020-03-26 04:00:00	AMZN	Stock	93.15	93.275	93.15	93.275	12820.0
2020-03-26 05:00:00	AMZN	Stock	93.8	93.9	93.618	93.618	12000.0

> showing 50 of 55,153 rows — these rows as CSV

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