PREVIEW / stock_1hour / 2020-01-30

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-01-30.parquet
  size:    1.2 MB
  rows:    51,354
  symbols: 2,448

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-01-30 04:00:00	AAPL	Stock	80.25	80.6025	80.2	80.3525	141792.0
2020-01-30 05:00:00	AAPL	Stock	80.32	80.35	80.195	80.3475	66148.0
2020-01-30 06:00:00	AAPL	Stock	80.255	80.275	80.04	80.2125	91396.0
2020-01-30 07:00:00	AAPL	Stock	80.25	80.375	80.025	80.045	439172.0
2020-01-30 08:00:00	AAPL	Stock	80.2625	80.3625	79.8125	80.1925	1121068.0
2020-01-30 09:00:00	AAPL	Stock	80.19	81.0225	80.0325	80.5925	16500980.0
2020-01-30 10:00:00	AAPL	Stock	80.59	80.9325	79.695	79.74	17717200.0
2020-01-30 11:00:00	AAPL	Stock	79.745	80.6325	79.6875	80.4835	14861744.0
2020-01-30 12:00:00	AAPL	Stock	80.4838	80.525	79.97	80.1075	9538688.0
2020-01-30 13:00:00	AAPL	Stock	80.1125	80.1625	79.8275	80.0	7914660.0
2020-01-30 14:00:00	AAPL	Stock	80.0	80.47	79.8875	80.23	11296492.0
2020-01-30 15:00:00	AAPL	Stock	80.2575	80.9925	80.1588	80.969	17344232.0
2020-01-30 16:00:00	AAPL	Stock	80.9675	81.19	80.415	81.0325	6629236.0
2020-01-30 17:00:00	AAPL	Stock	81.0275	81.045	80.89	80.975	188608.0
2020-01-30 18:00:00	AAPL	Stock	80.9525	80.9925	80.75	80.7875	119964.0
2020-01-30 19:00:00	AAPL	Stock	80.8125	80.9125	80.7075	80.9	108028.0
2020-01-30 04:00:00	MSFT	Stock	174.2	174.32	173.6	173.8	31096.0
2020-01-30 05:00:00	MSFT	Stock	173.8	173.92	173.6	173.85	16692.0
2020-01-30 06:00:00	MSFT	Stock	173.5	174.25	173.2	174.25	23397.0
2020-01-30 07:00:00	MSFT	Stock	174.1	175.0	173.42	173.95	330183.0
2020-01-30 08:00:00	MSFT	Stock	173.8	175.05	173.55	174.35	403291.0
2020-01-30 09:00:00	MSFT	Stock	174.35	174.89	172.41	172.44	11409990.0
2020-01-30 10:00:00	MSFT	Stock	172.44	172.79	171.33	171.69	7814089.0
2020-01-30 11:00:00	MSFT	Stock	171.7	172.39	171.59	171.78	4175286.0
2020-01-30 12:00:00	MSFT	Stock	171.789	172.185	170.79	171.378	3909522.0
2020-01-30 13:00:00	MSFT	Stock	171.39	171.69	170.95	171.275	2534202.0
2020-01-30 14:00:00	MSFT	Stock	171.28	172.89	171.25	172.58	4320805.0
2020-01-30 15:00:00	MSFT	Stock	172.6	173.305	172.24	172.74	6826670.0
2020-01-30 16:00:00	MSFT	Stock	172.73	173.27	172.51	172.99	3818997.0
2020-01-30 17:00:00	MSFT	Stock	172.86	173.2	172.78	172.9	25304.0
2020-01-30 18:00:00	MSFT	Stock	172.9	173.0	172.72	172.8	40213.0
2020-01-30 19:00:00	MSFT	Stock	172.9	173.0	172.7	172.95	18395.0
2020-01-30 04:00:00	NVDA	Stock	6.088	6.088	6.088	6.088	8000.0
2020-01-30 05:00:00	NVDA	Stock	6.04	6.04	6.04	6.04	23520.0
2020-01-30 06:00:00	NVDA	Stock	6.035	6.0375	5.9983	6.0002	94800.0
2020-01-30 07:00:00	NVDA	Stock	6.0025	6.0375	5.9845	6.0055	982720.0
2020-01-30 08:00:00	NVDA	Stock	6.0068	6.0378	5.9825	6.0126	1350440.0
2020-01-30 09:00:00	NVDA	Stock	6.0125	6.1588	6.0125	6.0998	37332320.0
2020-01-30 10:00:00	NVDA	Stock	6.0993	6.134	5.985	6.0014	51707840.0
2020-01-30 11:00:00	NVDA	Stock	5.9992	6.1026	5.9981	6.079	31030680.0
2020-01-30 12:00:00	NVDA	Stock	6.08	6.087	6.0225	6.0275	17047560.0
2020-01-30 13:00:00	NVDA	Stock	6.029	6.0532	6.023	6.0405	19615720.0
2020-01-30 14:00:00	NVDA	Stock	6.041	6.1169	6.0385	6.096	38521120.0
2020-01-30 15:00:00	NVDA	Stock	6.0978	6.1475	6.0858	6.1453	45875480.0
2020-01-30 16:00:00	NVDA	Stock	6.1453	6.18	6.145	6.1785	4686240.0
2020-01-30 17:00:00	NVDA	Stock	6.1775	6.18	6.1725	6.1788	250440.0
2020-01-30 18:00:00	NVDA	Stock	6.1822	6.1822	6.1705	6.175	103440.0
2020-01-30 19:00:00	NVDA	Stock	6.1725	6.1805	6.164	6.1805	150800.0
2020-01-30 06:00:00	AMZN	Stock	92.4375	92.5	92.4375	92.5	5840.0
2020-01-30 07:00:00	AMZN	Stock	92.7	92.8475	92.5625	92.7	128880.0

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

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