PREVIEW / stock_1hour / 2020-07-20

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-07-20.parquet
  size:    1.2 MB
  rows:    57,124
  symbols: 2,443

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-07-20 04:00:00	AAPL	Stock	95.8	96.12	95.75	96.095	21324.0
2020-07-20 05:00:00	AAPL	Stock	96.1975	96.3775	96.055	96.25	23708.0
2020-07-20 06:00:00	AAPL	Stock	96.185	96.22	96.185	96.22	2176.0
2020-07-20 07:00:00	AAPL	Stock	96.25	96.475	96.2125	96.38	108492.0
2020-07-20 08:00:00	AAPL	Stock	96.2505	96.64	96.195	96.5	300572.0
2020-07-20 09:00:00	AAPL	Stock	96.48	96.6418	96.0625	96.37	8532008.0
2020-07-20 10:00:00	AAPL	Stock	96.3625	97.1075	96.205	96.9625	12609176.0
2020-07-20 11:00:00	AAPL	Stock	96.97	97.645	96.9075	97.4578	10239172.0
2020-07-20 12:00:00	AAPL	Stock	97.4575	97.565	97.18	97.485	6001872.0
2020-07-20 13:00:00	AAPL	Stock	97.4842	97.7125	97.3675	97.5805	5123964.0
2020-07-20 14:00:00	AAPL	Stock	97.5805	97.76	97.5575	97.7432	5359768.0
2020-07-20 15:00:00	AAPL	Stock	97.745	98.5	97.745	98.3575	14487536.0
2020-07-20 16:00:00	AAPL	Stock	98.3575	98.3875	98.25	98.37	8085656.0
2020-07-20 17:00:00	AAPL	Stock	98.375	98.385	98.275	98.35	62112.0
2020-07-20 18:00:00	AAPL	Stock	98.385	98.4625	98.2775	98.28	61688.0
2020-07-20 19:00:00	AAPL	Stock	98.2875	98.5	98.28	98.45	88348.0
2020-07-20 04:00:00	MSFT	Stock	202.7	203.85	202.35	203.85	5047.0
2020-07-20 05:00:00	MSFT	Stock	203.85	204.6	203.85	204.36	14736.0
2020-07-20 06:00:00	MSFT	Stock	204.36	204.5	203.99	204.5	11222.0
2020-07-20 07:00:00	MSFT	Stock	204.49	205.21	204.05	205.02	107522.0
2020-07-20 08:00:00	MSFT	Stock	205.13	205.22	203.38	205.22	130846.0
2020-07-20 09:00:00	MSFT	Stock	205.22	206.03	203.01	205.77	4516669.0
2020-07-20 10:00:00	MSFT	Stock	205.78	207.16	205.05	206.78	4690323.0
2020-07-20 11:00:00	MSFT	Stock	206.775	208.57	206.41	208.56	3040930.0
2020-07-20 12:00:00	MSFT	Stock	208.57	208.74	207.8	208.49	2764442.0
2020-07-20 13:00:00	MSFT	Stock	208.49	209.5	208.42	209.41	1994538.0
2020-07-20 14:00:00	MSFT	Stock	209.41	210.57	209.34	210.52	2739589.0
2020-07-20 15:00:00	MSFT	Stock	210.51	212.3	210.37	211.49	5689878.0
2020-07-20 16:00:00	MSFT	Stock	211.6	212.19	211.36	211.97	5447778.0
2020-07-20 17:00:00	MSFT	Stock	211.95	211.98	211.8	211.89	24984.0
2020-07-20 18:00:00	MSFT	Stock	211.98	212.48	211.85	211.89	42251.0
2020-07-20 19:00:00	MSFT	Stock	211.89	212.92	211.85	212.92	36413.0
2020-07-20 06:00:00	NVDA	Stock	10.2	10.2373	10.2	10.2373	294200.0
2020-07-20 07:00:00	NVDA	Stock	10.2482	10.2678	10.2482	10.2665	300360.0
2020-07-20 08:00:00	NVDA	Stock	10.249	10.284	10.249	10.2838	813560.0
2020-07-20 09:00:00	NVDA	Stock	10.2818	10.3125	10.1568	10.238	33967760.0
2020-07-20 10:00:00	NVDA	Stock	10.2428	10.375	10.2262	10.3488	58994200.0
2020-07-20 11:00:00	NVDA	Stock	10.3555	10.4461	10.3285	10.4148	42918120.0
2020-07-20 12:00:00	NVDA	Stock	10.4145	10.4198	10.3668	10.4038	32263120.0
2020-07-20 13:00:00	NVDA	Stock	10.4031	10.4086	10.354	10.3713	21098320.0
2020-07-20 14:00:00	NVDA	Stock	10.3681	10.4548	10.3655	10.437	26209800.0
2020-07-20 15:00:00	NVDA	Stock	10.434	10.5312	10.42	10.5108	50510880.0
2020-07-20 16:00:00	NVDA	Stock	10.5108	10.5108	10.4088	10.51	4033960.0
2020-07-20 17:00:00	NVDA	Stock	10.5138	10.5175	10.5033	10.5063	321080.0
2020-07-20 18:00:00	NVDA	Stock	10.5112	10.5168	10.504	10.5125	40920.0
2020-07-20 19:00:00	NVDA	Stock	10.5075	10.5235	10.5033	10.5165	236520.0
2020-07-20 04:00:00	AMZN	Stock	148.5	148.5	148.5	148.5	5360.0
2020-07-20 05:00:00	AMZN	Stock	148.982	149.25	148.982	149.25	18800.0
2020-07-20 06:00:00	AMZN	Stock	149.25	149.25	149.2	149.2	40420.0
2020-07-20 07:00:00	AMZN	Stock	148.6705	149.9	148.6705	149.801	348020.0

> showing 50 of 57,124 rows — these rows as CSV

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