PREVIEW / stock_1hour / 2019-08-01

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-08-01.parquet
  size:    1.2 MB
  rows:    51,525
  symbols: 2,572

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-08-01 04:00:00	AAPL	Stock	53.5	53.5	53.445	53.45	17004.0
2019-08-01 05:00:00	AAPL	Stock	53.52	53.625	53.52	53.625	21952.0
2019-08-01 06:00:00	AAPL	Stock	53.625	53.7075	53.575	53.625	29232.0
2019-08-01 07:00:00	AAPL	Stock	53.62	53.7	53.5375	53.6375	239088.0
2019-08-01 08:00:00	AAPL	Stock	53.6425	53.715	53.1275	53.58	464104.0
2019-08-01 09:00:00	AAPL	Stock	53.58	53.9725	53.4025	53.7325	20569560.0
2019-08-01 10:00:00	AAPL	Stock	53.7275	54.3975	53.6875	54.3038	21186292.0
2019-08-01 11:00:00	AAPL	Stock	54.305	54.5075	54.2175	54.3772	14895932.0
2019-08-01 12:00:00	AAPL	Stock	54.3775	54.3892	54.165	54.1925	9591944.0
2019-08-01 13:00:00	AAPL	Stock	54.195	54.2462	52.05	52.4475	39179012.0
2019-08-01 14:00:00	AAPL	Stock	52.455	52.6725	51.686	52.4975	39641596.0
2019-08-01 15:00:00	AAPL	Stock	52.5	52.575	51.875	52.115	31081268.0
2019-08-01 16:00:00	AAPL	Stock	52.115	53.4458	52.0	52.025	7255576.0
2019-08-01 17:00:00	AAPL	Stock	52.0125	52.0875	51.985	52.0875	91472.0
2019-08-01 18:00:00	AAPL	Stock	52.075	52.1	51.7525	51.795	272876.0
2019-08-01 19:00:00	AAPL	Stock	51.795	51.855	51.6875	51.71	230752.0
2019-08-01 04:00:00	MSFT	Stock	136.96	137.0	136.87	137.0	6156.0
2019-08-01 05:00:00	MSFT	Stock	136.98	137.44	136.95	137.44	9946.0
2019-08-01 06:00:00	MSFT	Stock	137.5	137.5	137.3	137.3	3178.0
2019-08-01 07:00:00	MSFT	Stock	137.14	137.45	137.09	137.25	33464.0
2019-08-01 08:00:00	MSFT	Stock	137.2	137.44	136.27	137.15	71787.0
2019-08-01 09:00:00	MSFT	Stock	137.11	138.83	136.8	138.805	3947925.0
2019-08-01 10:00:00	MSFT	Stock	138.8	140.33	138.603	140.3	5096756.0
2019-08-01 11:00:00	MSFT	Stock	140.3	140.938	140.16	140.55	4389023.0
2019-08-01 12:00:00	MSFT	Stock	140.574	140.74	140.26	140.651	2192661.0
2019-08-01 13:00:00	MSFT	Stock	140.65	140.84	138.22	138.902	4992775.0
2019-08-01 14:00:00	MSFT	Stock	138.89	139.078	137.58	138.21	5199995.0
2019-08-01 15:00:00	MSFT	Stock	138.21	138.92	137.87	138.06	6045133.0
2019-08-01 16:00:00	MSFT	Stock	138.06	138.71	137.88	137.98	2989428.0
2019-08-01 17:00:00	MSFT	Stock	137.99	138.06	137.85	138.05	12874.0
2019-08-01 18:00:00	MSFT	Stock	137.9	138.0	137.53	137.6	15206.0
2019-08-01 19:00:00	MSFT	Stock	137.6	137.83	137.6	137.65	8298.0
2019-08-01 06:00:00	NVDA	Stock	4.2318	4.2412	4.2318	4.2412	20840.0
2019-08-01 07:00:00	NVDA	Stock	4.2375	4.244	4.225	4.225	152160.0
2019-08-01 08:00:00	NVDA	Stock	4.2425	4.25	4.218	4.2373	775840.0
2019-08-01 09:00:00	NVDA	Stock	4.2375	4.2844	4.225	4.2732	37421280.0
2019-08-01 10:00:00	NVDA	Stock	4.2722	4.3058	4.265	4.3015	38340960.0
2019-08-01 11:00:00	NVDA	Stock	4.301	4.3195	4.2955	4.3085	26935440.0
2019-08-01 12:00:00	NVDA	Stock	4.309	4.3175	4.2985	4.3078	14874280.0
2019-08-01 13:00:00	NVDA	Stock	4.3082	4.3112	4.1395	4.1752	65042640.0
2019-08-01 14:00:00	NVDA	Stock	4.1765	4.1815	4.0705	4.104	87585280.0
2019-08-01 15:00:00	NVDA	Stock	4.1038	4.1338	4.0842	4.123	84897480.0
2019-08-01 16:00:00	NVDA	Stock	4.123	4.1375	4.1125	4.1225	3498000.0
2019-08-01 17:00:00	NVDA	Stock	4.1138	4.1218	4.1125	4.1218	228960.0
2019-08-01 18:00:00	NVDA	Stock	4.115	4.1175	4.0875	4.0888	1114160.0
2019-08-01 19:00:00	NVDA	Stock	4.0925	4.0993	4.0838	4.0838	592440.0
2019-08-01 04:00:00	AMZN	Stock	93.55	93.563	93.55	93.55	14300.0
2019-08-01 06:00:00	AMZN	Stock	93.999	94.15	93.9925	94.0965	52080.0
2019-08-01 07:00:00	AMZN	Stock	93.9315	93.9315	93.756	93.756	87940.0
2019-08-01 08:00:00	AMZN	Stock	93.9961	93.9961	93.572	93.9	348920.0

> showing 50 of 51,525 rows — these rows as CSV

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