PREVIEW / stock_1hour / 2019-11-27

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-11-27.parquet
  size:    1.1 MB
  rows:    49,919
  symbols: 2,477

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
2019-11-27 04:00:00	AAPL	Stock	66.375	66.45	66.375	66.45	32896.0
2019-11-27 05:00:00	AAPL	Stock	66.45	66.4625	66.4	66.4575	16080.0
2019-11-27 06:00:00	AAPL	Stock	66.425	66.425	66.3125	66.3125	18748.0
2019-11-27 07:00:00	AAPL	Stock	66.29	66.335	66.25	66.325	69272.0
2019-11-27 08:00:00	AAPL	Stock	66.3	66.4075	66.2725	66.2725	216252.0
2019-11-27 09:00:00	AAPL	Stock	66.275	66.5675	66.25	66.5375	9055512.0
2019-11-27 10:00:00	AAPL	Stock	66.5375	66.5975	66.355	66.5525	8805708.0
2019-11-27 11:00:00	AAPL	Stock	66.545	66.65	66.5375	66.6072	4919808.0
2019-11-27 12:00:00	AAPL	Stock	66.605	66.6775	66.5825	66.5925	3911892.0
2019-11-27 13:00:00	AAPL	Stock	66.5925	66.735	66.58	66.695	4250284.0
2019-11-27 14:00:00	AAPL	Stock	66.6908	66.7775	66.67	66.75	5198216.0
2019-11-27 15:00:00	AAPL	Stock	66.7525	66.995	66.7025	66.975	10124584.0
2019-11-27 16:00:00	AAPL	Stock	66.96	66.9925	66.8875	66.9775	5858240.0
2019-11-27 17:00:00	AAPL	Stock	66.9775	66.985	66.9375	66.96	27896.0
2019-11-27 18:00:00	AAPL	Stock	66.975	66.975	66.725	66.775	245476.0
2019-11-27 19:00:00	AAPL	Stock	66.7825	66.8	66.6375	66.675	106444.0
2019-11-27 04:00:00	MSFT	Stock	152.61	152.71	152.61	152.71	380.0
2019-11-27 05:00:00	MSFT	Stock	152.65	152.71	152.65	152.71	300.0
2019-11-27 06:00:00	MSFT	Stock	152.75	152.75	152.5	152.5	1944.0
2019-11-27 07:00:00	MSFT	Stock	152.5	152.57	152.45	152.55	6311.0
2019-11-27 08:00:00	MSFT	Stock	152.58	152.66	152.47	152.47	29263.0
2019-11-27 09:00:00	MSFT	Stock	152.497	152.57	151.61	151.7	2076985.0
2019-11-27 10:00:00	MSFT	Stock	151.695	152.27	151.52	152.08	1953151.0
2019-11-27 11:00:00	MSFT	Stock	152.09	152.35	152.0	152.294	1151269.0
2019-11-27 12:00:00	MSFT	Stock	152.293	152.33	152.134	152.175	901320.0
2019-11-27 13:00:00	MSFT	Stock	152.175	152.285	151.95	152.07	1115690.0
2019-11-27 14:00:00	MSFT	Stock	152.07	152.16	151.93	151.995	958786.0
2019-11-27 15:00:00	MSFT	Stock	152.0	152.35	151.935	152.34	2169538.0
2019-11-27 16:00:00	MSFT	Stock	152.32	152.4	152.22	152.4	3009638.0
2019-11-27 17:00:00	MSFT	Stock	152.45	152.45	152.33	152.42	3756.0
2019-11-27 18:00:00	MSFT	Stock	152.34	152.34	151.85	151.93	17191.0
2019-11-27 19:00:00	MSFT	Stock	151.91	151.95	151.71	151.71	4604.0
2019-11-27 04:00:00	NVDA	Stock	5.4628	5.4738	5.4625	5.4625	427240.0
2019-11-27 05:00:00	NVDA	Stock	5.4722	5.4722	5.4655	5.4655	18320.0
2019-11-27 06:00:00	NVDA	Stock	5.4625	5.4675	5.46	5.46	41680.0
2019-11-27 07:00:00	NVDA	Stock	5.461	5.4743	5.448	5.457	475600.0
2019-11-27 08:00:00	NVDA	Stock	5.4625	5.4725	5.45	5.4563	1205360.0
2019-11-27 09:00:00	NVDA	Stock	5.4553	5.5013	5.4525	5.4645	47073560.0
2019-11-27 10:00:00	NVDA	Stock	5.4648	5.4718	5.433	5.44	38388600.0
2019-11-27 11:00:00	NVDA	Stock	5.4392	5.4501	5.4295	5.4353	18087240.0
2019-11-27 12:00:00	NVDA	Stock	5.4358	5.459	5.434	5.4515	17330200.0
2019-11-27 13:00:00	NVDA	Stock	5.4515	5.4542	5.434	5.4389	13370320.0
2019-11-27 14:00:00	NVDA	Stock	5.4382	5.447	5.4362	5.4426	12495000.0
2019-11-27 15:00:00	NVDA	Stock	5.4428	5.4618	5.4392	5.456	29025160.0
2019-11-27 16:00:00	NVDA	Stock	5.456	5.456	5.4513	5.4522	9582520.0
2019-11-27 17:00:00	NVDA	Stock	5.452	5.4563	5.4518	5.455	1346560.0
2019-11-27 18:00:00	NVDA	Stock	5.4538	5.4538	5.4333	5.4352	635120.0
2019-11-27 19:00:00	NVDA	Stock	5.436	5.4412	5.4292	5.43	272920.0
2019-11-27 04:00:00	AMZN	Stock	90.2	90.2	90.15	90.15	17100.0
2019-11-27 05:00:00	AMZN	Stock	90.11	90.11	90.11	90.11	4040.0

> showing 50 of 49,919 rows — these rows as CSV

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