PREVIEW / stock_1hour / 2020-03-19

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-03-19.parquet
  size:    1.2 MB
  rows:    54,871
  symbols: 2,446

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-03-19 04:00:00	AAPL	Stock	61.4975	62.75	61.15	62.5	79144.0
2020-03-19 05:00:00	AAPL	Stock	62.495	62.5725	61.5875	61.5875	17176.0
2020-03-19 06:00:00	AAPL	Stock	61.3925	61.5825	61.035	61.26	57804.0
2020-03-19 07:00:00	AAPL	Stock	61.4325	61.915	60.7625	60.9025	326724.0
2020-03-19 08:00:00	AAPL	Stock	61.41	61.745	60.375	61.3785	793424.0
2020-03-19 09:00:00	AAPL	Stock	61.4475	62.605	60.6525	62.5412	29225700.0
2020-03-19 10:00:00	AAPL	Stock	62.5375	63.21	60.7425	61.1625	41835516.0
2020-03-19 11:00:00	AAPL	Stock	61.1875	62.8125	61.14	61.79	30802736.0
2020-03-19 12:00:00	AAPL	Stock	61.78	62.305	61.3	61.8938	24768336.0
2020-03-19 13:00:00	AAPL	Stock	61.9025	62.658	61.765	62.3375	19270256.0
2020-03-19 14:00:00	AAPL	Stock	62.3525	62.955	62.02	62.4025	21914380.0
2020-03-19 15:00:00	AAPL	Stock	62.3875	62.5275	60.9175	61.195	34865504.0
2020-03-19 16:00:00	AAPL	Stock	61.1925	61.2775	60.8775	61.1	22943760.0
2020-03-19 17:00:00	AAPL	Stock	61.1	61.2475	61.025	61.15	228968.0
2020-03-19 18:00:00	AAPL	Stock	61.15	61.37	61.0	61.0625	363804.0
2020-03-19 19:00:00	AAPL	Stock	61.125	61.1875	60.8075	60.8125	216312.0
2020-03-19 04:00:00	MSFT	Stock	140.08	143.4	139.0	143.4	14514.0
2020-03-19 05:00:00	MSFT	Stock	143.4	143.4	141.5	141.62	18773.0
2020-03-19 06:00:00	MSFT	Stock	141.3	141.3	140.0	140.5	24685.0
2020-03-19 07:00:00	MSFT	Stock	140.64	141.74	139.07	139.16	114169.0
2020-03-19 08:00:00	MSFT	Stock	141.49	141.75	138.3	140.0	192619.0
2020-03-19 09:00:00	MSFT	Stock	140.45	144.8	139.0	144.735	8569693.0
2020-03-19 10:00:00	MSFT	Stock	144.717	148.5	141.16	143.05	12539943.0
2020-03-19 11:00:00	MSFT	Stock	143.01	147.42	142.22	145.645	8736092.0
2020-03-19 12:00:00	MSFT	Stock	145.61	148.0	143.92	146.908	6340580.0
2020-03-19 13:00:00	MSFT	Stock	146.95	150.15	146.21	149.48	5383542.0
2020-03-19 14:00:00	MSFT	Stock	149.49	149.695	146.82	147.41	5740007.0
2020-03-19 15:00:00	MSFT	Stock	147.46	148.6	141.58	142.67	12642781.0
2020-03-19 16:00:00	MSFT	Stock	143.04	144.957	141.8	142.65	12793953.0
2020-03-19 17:00:00	MSFT	Stock	142.68	142.71	142.0	142.42	28886.0
2020-03-19 18:00:00	MSFT	Stock	142.2	142.99	141.99	142.23	74510.0
2020-03-19 19:00:00	MSFT	Stock	142.66	142.66	141.71	141.8	50077.0
2020-03-19 04:00:00	NVDA	Stock	5.0525	5.1735	5.0372	5.1393	89640.0
2020-03-19 05:00:00	NVDA	Stock	5.1548	5.1548	5.05	5.05	60240.0
2020-03-19 06:00:00	NVDA	Stock	5.0625	5.0625	5.0125	5.025	115040.0
2020-03-19 07:00:00	NVDA	Stock	5.0002	5.0632	4.8875	4.8875	1178720.0
2020-03-19 08:00:00	NVDA	Stock	5.0375	5.075	4.8498	4.975	2527640.0
2020-03-19 09:00:00	NVDA	Stock	4.9705	5.225	4.8348	5.22	98922200.0
2020-03-19 10:00:00	NVDA	Stock	5.2213	5.2665	4.9788	5.0375	114018320.0
2020-03-19 11:00:00	NVDA	Stock	5.0316	5.2476	5.0292	5.129	91330800.0
2020-03-19 12:00:00	NVDA	Stock	5.126	5.2063	5.055	5.1558	50857480.0
2020-03-19 13:00:00	NVDA	Stock	5.1554	5.2875	5.1002	5.2868	63016120.0
2020-03-19 14:00:00	NVDA	Stock	5.2835	5.4183	5.251	5.3198	77164440.0
2020-03-19 15:00:00	NVDA	Stock	5.3153	5.4018	5.2448	5.3242	139891280.0
2020-03-19 16:00:00	NVDA	Stock	5.3242	5.3562	5.2875	5.3125	56000320.0
2020-03-19 17:00:00	NVDA	Stock	5.3025	5.3253	5.2833	5.32	1002760.0
2020-03-19 18:00:00	NVDA	Stock	5.3013	5.3313	5.295	5.3145	908160.0
2020-03-19 19:00:00	NVDA	Stock	5.3142	5.3144	5.2575	5.2575	1049880.0
2020-03-19 04:00:00	AMZN	Stock	90.725	93.2105	90.725	92.95	82860.0
2020-03-19 05:00:00	AMZN	Stock	92.1155	92.1155	92.1155	92.1155	2100.0

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

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