PREVIEW / stock_1hour / 2020-05-27

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-05-27.parquet
  size:    1.2 MB
  rows:    56,705
  symbols: 2,375

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-05-27 04:00:00	AAPL	Stock	79.8	79.9625	79.8	79.8825	9884.0
2020-05-27 05:00:00	AAPL	Stock	79.9725	80.255	79.9725	80.25	49064.0
2020-05-27 06:00:00	AAPL	Stock	80.3025	80.3025	79.955	80.025	40548.0
2020-05-27 07:00:00	AAPL	Stock	80.0125	80.0125	79.445	79.475	202080.0
2020-05-27 08:00:00	AAPL	Stock	79.4975	79.95	79.15	79.2525	424612.0
2020-05-27 09:00:00	AAPL	Stock	79.23	79.6775	78.7925	78.995	13470456.0
2020-05-27 10:00:00	AAPL	Stock	78.9988	79.515	78.2725	78.6875	18284564.0
2020-05-27 11:00:00	AAPL	Stock	78.6875	78.9875	78.3525	78.7075	11587144.0
2020-05-27 12:00:00	AAPL	Stock	78.715	78.96	78.3875	78.835	8272752.0
2020-05-27 13:00:00	AAPL	Stock	78.83	78.93	78.615	78.815	5874440.0
2020-05-27 14:00:00	AAPL	Stock	78.8175	79.2575	78.8175	79.25	7455828.0
2020-05-27 15:00:00	AAPL	Stock	79.255	79.6	79.09	79.52	12130552.0
2020-05-27 16:00:00	AAPL	Stock	79.5275	79.6	79.435	79.5125	7276464.0
2020-05-27 17:00:00	AAPL	Stock	79.5125	79.55	79.4825	79.4825	76708.0
2020-05-27 18:00:00	AAPL	Stock	79.475	79.5	79.3125	79.4475	43108.0
2020-05-27 19:00:00	AAPL	Stock	79.43	79.4625	79.305	79.45	45404.0
2020-05-27 04:00:00	MSFT	Stock	183.26	183.5	182.82	182.82	12045.0
2020-05-27 05:00:00	MSFT	Stock	183.04	183.48	183.0	183.48	9508.0
2020-05-27 06:00:00	MSFT	Stock	183.46	183.48	183.1	183.24	7484.0
2020-05-27 07:00:00	MSFT	Stock	183.15	183.24	182.05	182.1	33312.0
2020-05-27 08:00:00	MSFT	Stock	182.29	183.1	181.0	181.05	113137.0
2020-05-27 09:00:00	MSFT	Stock	181.12	181.4	177.1	178.08	6655853.0
2020-05-27 10:00:00	MSFT	Stock	178.079	179.14	176.6	177.68	6137736.0
2020-05-27 11:00:00	MSFT	Stock	177.68	178.84	176.876	178.64	3387080.0
2020-05-27 12:00:00	MSFT	Stock	178.65	180.29	178.39	179.81	2676503.0
2020-05-27 13:00:00	MSFT	Stock	179.8	180.13	179.2	179.517	1815041.0
2020-05-27 14:00:00	MSFT	Stock	179.53	181.0	179.52	180.982	2358246.0
2020-05-27 15:00:00	MSFT	Stock	180.99	181.988	180.315	181.81	4218880.0
2020-05-27 16:00:00	MSFT	Stock	181.81	182.09	181.56	181.96	2879461.0
2020-05-27 17:00:00	MSFT	Stock	181.91	181.98	181.81	181.81	14107.0
2020-05-27 18:00:00	MSFT	Stock	181.81	181.85	181.51	181.55	12730.0
2020-05-27 19:00:00	MSFT	Stock	181.75	181.95	181.65	181.95	8701.0
2020-05-27 04:00:00	NVDA	Stock	8.825	8.825	8.8	8.8125	268960.0
2020-05-27 05:00:00	NVDA	Stock	8.8075	8.8075	8.7925	8.8	184960.0
2020-05-27 06:00:00	NVDA	Stock	8.79	8.79	8.775	8.775	52120.0
2020-05-27 07:00:00	NVDA	Stock	8.7785	8.7995	8.735	8.75	1162440.0
2020-05-27 08:00:00	NVDA	Stock	8.7875	8.7974	8.625	8.6475	2840800.0
2020-05-27 09:00:00	NVDA	Stock	8.6475	8.681	8.2153	8.2795	198199480.0
2020-05-27 10:00:00	NVDA	Stock	8.281	8.3312	8.0363	8.0492	230847840.0
2020-05-27 11:00:00	NVDA	Stock	8.0495	8.2812	7.9968	8.256	165623000.0
2020-05-27 12:00:00	NVDA	Stock	8.257	8.575	8.2375	8.296	110350560.0
2020-05-27 13:00:00	NVDA	Stock	8.2962	8.575	8.2405	8.3651	98093920.0
2020-05-27 14:00:00	NVDA	Stock	8.3665	8.5002	8.3655	8.4934	112406280.0
2020-05-27 15:00:00	NVDA	Stock	8.4942	8.5375	8.4625	8.5282	128002000.0
2020-05-27 16:00:00	NVDA	Stock	8.5252	8.5472	8.5165	8.5438	9966520.0
2020-05-27 17:00:00	NVDA	Stock	8.5438	8.5438	8.5138	8.5248	440040.0
2020-05-27 18:00:00	NVDA	Stock	8.5358	8.5375	8.5162	8.5192	375320.0
2020-05-27 19:00:00	NVDA	Stock	8.5188	8.525	8.4888	8.505	621360.0
2020-05-27 04:00:00	AMZN	Stock	121.8	122.026	121.8	122.0	14000.0
2020-05-27 05:00:00	AMZN	Stock	121.9	121.9	121.9	121.9	2000.0

> showing 50 of 56,705 rows — these rows as CSV

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