PREVIEW / stock_1hour / 2019-11-29

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-11-29.parquet
  size:    775 KB
  rows:    31,965
  symbols: 2,458

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
2019-11-29 04:00:00	AAPL	Stock	66.675	66.75	66.675	66.7	5148.0
2019-11-29 05:00:00	AAPL	Stock	66.735	66.7925	66.735	66.775	19024.0
2019-11-29 06:00:00	AAPL	Stock	66.7825	66.8375	66.7825	66.8375	17068.0
2019-11-29 07:00:00	AAPL	Stock	66.775	66.8625	66.725	66.765	55444.0
2019-11-29 08:00:00	AAPL	Stock	66.78	66.85	66.725	66.7628	156100.0
2019-11-29 09:00:00	AAPL	Stock	66.7525	66.9075	66.475	66.86	8588892.0
2019-11-29 10:00:00	AAPL	Stock	66.86	67.0	66.755	66.925	7231624.0
2019-11-29 11:00:00	AAPL	Stock	66.9325	66.995	66.835	66.9275	6468916.0
2019-11-29 12:00:00	AAPL	Stock	66.9275	66.97	66.7375	66.795	8843032.0
2019-11-29 13:00:00	AAPL	Stock	66.795	66.9525	66.795	66.8625	6894820.0
2019-11-29 14:00:00	AAPL	Stock	66.85	66.895	66.8125	66.895	66336.0
2019-11-29 15:00:00	AAPL	Stock	66.8925	66.8925	66.85	66.85	14540.0
2019-11-29 16:00:00	AAPL	Stock	66.8725	66.9	66.85	66.85	6328.0
2019-11-29 04:00:00	MSFT	Stock	151.65	152.14	151.65	152.0	2112.0
2019-11-29 05:00:00	MSFT	Stock	152.1	152.23	152.1	152.1	1643.0
2019-11-29 06:00:00	MSFT	Stock	152.2	152.2	152.2	152.2	3464.0
2019-11-29 07:00:00	MSFT	Stock	152.1	152.25	152.1	152.2	9903.0
2019-11-29 08:00:00	MSFT	Stock	152.1	152.17	152.054	152.1	7431.0
2019-11-29 09:00:00	MSFT	Stock	152.11	152.14	151.43	152.13	1598135.0
2019-11-29 10:00:00	MSFT	Stock	152.12	152.3	151.6	151.7	1450599.0
2019-11-29 11:00:00	MSFT	Stock	151.69	151.81	151.48	151.795	1324473.0
2019-11-29 12:00:00	MSFT	Stock	151.79	151.81	151.28	151.38	2727306.0
2019-11-29 13:00:00	MSFT	Stock	151.38	151.73	151.38	151.6	3141274.0
2019-11-29 14:00:00	MSFT	Stock	151.65	151.76	151.38	151.76	14974.0
2019-11-29 15:00:00	MSFT	Stock	151.6	151.69	151.57	151.69	600.0
2019-11-29 16:00:00	MSFT	Stock	151.58	151.67	151.57	151.67	2432.0
2019-11-29 04:00:00	NVDA	Stock	5.3878	5.4288	5.3878	5.4282	47480.0
2019-11-29 06:00:00	NVDA	Stock	5.4345	5.4345	5.4345	5.4345	12000.0
2019-11-29 07:00:00	NVDA	Stock	5.4288	5.435	5.4288	5.4343	110640.0
2019-11-29 08:00:00	NVDA	Stock	5.4288	5.4398	5.4263	5.433	408400.0
2019-11-29 09:00:00	NVDA	Stock	5.429	5.4535	5.4	5.4465	29521000.0
2019-11-29 10:00:00	NVDA	Stock	5.4455	5.4478	5.415	5.4278	27300960.0
2019-11-29 11:00:00	NVDA	Stock	5.4278	5.433	5.4095	5.4278	19215560.0
2019-11-29 12:00:00	NVDA	Stock	5.4278	5.4282	5.3945	5.4185	37949960.0
2019-11-29 13:00:00	NVDA	Stock	5.4183	5.4185	5.406	5.41	10133400.0
2019-11-29 14:00:00	NVDA	Stock	5.4105	5.4185	5.41	5.4185	119240.0
2019-11-29 15:00:00	NVDA	Stock	5.4135	5.4142	5.4112	5.4136	140360.0
2019-11-29 04:00:00	AMZN	Stock	90.775	90.8	90.775	90.8	14000.0
2019-11-29 06:00:00	AMZN	Stock	90.9	90.9	90.9	90.9	7220.0
2019-11-29 07:00:00	AMZN	Stock	90.9	90.9235	90.8615	90.875	50160.0
2019-11-29 08:00:00	AMZN	Stock	90.8575	90.9	90.8145	90.8375	85040.0
2019-11-29 09:00:00	AMZN	Stock	90.8625	91.2345	90.654	91.036	7263360.0
2019-11-29 10:00:00	AMZN	Stock	90.9915	91.0435	90.7	90.7204	5044620.0
2019-11-29 11:00:00	AMZN	Stock	90.701	90.7345	90.1705	90.4448	6711400.0
2019-11-29 12:00:00	AMZN	Stock	90.439	90.5	90.0395	90.048	7782720.0
2019-11-29 13:00:00	AMZN	Stock	90.048	90.125	89.849	89.9	3884060.0
2019-11-29 14:00:00	AMZN	Stock	89.8965	90.04	89.7275	89.924	354580.0
2019-11-29 15:00:00	AMZN	Stock	89.9375	89.9375	89.9375	89.9375	7840.0
2019-11-29 16:00:00	AMZN	Stock	89.94	89.94	89.94	89.94	2440.0
2019-11-29 07:00:00	GOOGL	Stock	65.5	65.5	65.5	65.5	4420.0

> showing 50 of 31,965 rows — these rows as CSV

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