PREVIEW / stock_1hour / 2020-05-19

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-05-19.parquet
  size:    1.2 MB
  rows:    54,700
  symbols: 2,388

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-19 04:00:00	AAPL	Stock	79.0025	79.0125	78.5025	78.625	24164.0
2020-05-19 05:00:00	AAPL	Stock	78.6375	78.64	78.6175	78.625	3088.0
2020-05-19 06:00:00	AAPL	Stock	78.5375	78.61	78.3875	78.575	8100.0
2020-05-19 07:00:00	AAPL	Stock	78.575	78.9975	78.525	78.875	142932.0
2020-05-19 08:00:00	AAPL	Stock	78.6225	79.0	78.575	78.95	179836.0
2020-05-19 09:00:00	AAPL	Stock	78.9428	79.4	78.6875	79.37	12959888.0
2020-05-19 10:00:00	AAPL	Stock	79.3675	79.63	79.155	79.46	16079528.0
2020-05-19 11:00:00	AAPL	Stock	79.4525	79.4888	79.165	79.3225	9811284.0
2020-05-19 12:00:00	AAPL	Stock	79.3275	79.4125	79.07	79.38	7200036.0
2020-05-19 13:00:00	AAPL	Stock	79.38	79.465	79.2772	79.31	5373220.0
2020-05-19 14:00:00	AAPL	Stock	79.3075	79.3975	78.6425	78.7175	8781588.0
2020-05-19 15:00:00	AAPL	Stock	78.7225	79.245	78.2525	78.2525	18170432.0
2020-05-19 16:00:00	AAPL	Stock	78.285	78.3625	78.25	78.325	5877796.0
2020-05-19 17:00:00	AAPL	Stock	78.3	78.3125	78.275	78.295	19356.0
2020-05-19 18:00:00	AAPL	Stock	78.285	78.3975	78.175	78.3975	133524.0
2020-05-19 19:00:00	AAPL	Stock	78.4125	78.6475	78.375	78.635	159276.0
2020-05-19 04:00:00	MSFT	Stock	185.45	185.79	184.85	185.61	6326.0
2020-05-19 05:00:00	MSFT	Stock	185.36	185.56	185.3	185.56	1481.0
2020-05-19 06:00:00	MSFT	Stock	185.41	185.41	184.8	185.06	3501.0
2020-05-19 07:00:00	MSFT	Stock	185.2	185.82	185.0	185.32	24426.0
2020-05-19 08:00:00	MSFT	Stock	185.08	185.69	185.01	185.35	22116.0
2020-05-19 09:00:00	MSFT	Stock	185.35	186.25	184.59	185.83	3358181.0
2020-05-19 10:00:00	MSFT	Stock	185.8	186.6	185.39	186.04	3573962.0
2020-05-19 11:00:00	MSFT	Stock	186.04	186.07	185.43	185.865	2563264.0
2020-05-19 12:00:00	MSFT	Stock	185.86	185.96	185.24	185.617	1743273.0
2020-05-19 13:00:00	MSFT	Stock	185.61	186.0	185.36	185.96	1565972.0
2020-05-19 14:00:00	MSFT	Stock	185.955	186.04	184.5	184.71	2351081.0
2020-05-19 15:00:00	MSFT	Stock	184.71	185.69	183.49	183.5	5020089.0
2020-05-19 16:00:00	MSFT	Stock	183.63	185.462	183.29	183.64	2190214.0
2020-05-19 17:00:00	MSFT	Stock	183.67	183.74	183.526	183.63	12930.0
2020-05-19 18:00:00	MSFT	Stock	183.7	183.9	183.35	183.9	32021.0
2020-05-19 19:00:00	MSFT	Stock	183.9	184.2	183.8	184.0	29775.0
2020-05-19 04:00:00	NVDA	Stock	8.8195	8.8195	8.75	8.76	181280.0
2020-05-19 06:00:00	NVDA	Stock	8.7615	8.7725	8.75	8.76	224840.0
2020-05-19 07:00:00	NVDA	Stock	8.7725	8.872	8.764	8.8425	1678960.0
2020-05-19 08:00:00	NVDA	Stock	8.844	8.8568	8.7285	8.83	2452280.0
2020-05-19 09:00:00	NVDA	Stock	8.8252	9.0476	8.7628	9.0198	134364640.0
2020-05-19 10:00:00	NVDA	Stock	9.0175	9.0462	8.94	8.9908	127794400.0
2020-05-19 11:00:00	NVDA	Stock	8.989	9.0138	8.9488	9.0002	70272840.0
2020-05-19 12:00:00	NVDA	Stock	9.0032	9.0618	8.9575	9.0418	66645400.0
2020-05-19 13:00:00	NVDA	Stock	9.0425	9.0875	9.0192	9.0408	66143600.0
2020-05-19 14:00:00	NVDA	Stock	9.0408	9.047	8.925	8.9342	63944280.0
2020-05-19 15:00:00	NVDA	Stock	8.9317	9.0145	8.8	8.8042	134874160.0
2020-05-19 16:00:00	NVDA	Stock	8.8055	8.83	8.8	8.815	21545560.0
2020-05-19 17:00:00	NVDA	Stock	8.815	8.8418	8.815	8.8418	566880.0
2020-05-19 18:00:00	NVDA	Stock	8.8355	8.8355	8.8052	8.8218	615480.0
2020-05-19 19:00:00	NVDA	Stock	8.825	8.8902	8.825	8.8868	626160.0
2020-05-19 04:00:00	AMZN	Stock	121.647	121.75	121.647	121.75	4560.0
2020-05-19 07:00:00	AMZN	Stock	121.2875	121.625	121.0505	121.625	51000.0
2020-05-19 08:00:00	AMZN	Stock	121.475	121.7	121.363	121.7	56360.0

> showing 50 of 54,700 rows — these rows as CSV

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