PREVIEW / stock_1hour / 2019-12-04

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-12-04.parquet
  size:    1.1 MB
  rows:    51,041
  symbols: 2,503

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-12-04 04:00:00	AAPL	Stock	64.855	65.35	64.855	65.3475	60160.0
2019-12-04 05:00:00	AAPL	Stock	65.3375	65.35	65.25	65.28	19700.0
2019-12-04 06:00:00	AAPL	Stock	65.285	65.35	65.2525	65.35	31696.0
2019-12-04 07:00:00	AAPL	Stock	65.3525	65.545	65.3	65.4125	307480.0
2019-12-04 08:00:00	AAPL	Stock	65.3875	65.5458	65.18	65.3875	585184.0
2019-12-04 09:00:00	AAPL	Stock	65.375	65.4725	65.17	65.37	9866208.0
2019-12-04 10:00:00	AAPL	Stock	65.37	65.5375	65.28	65.5375	8135012.0
2019-12-04 11:00:00	AAPL	Stock	65.537	65.8275	65.515	65.7148	9209304.0
2019-12-04 12:00:00	AAPL	Stock	65.7175	65.74	65.5325	65.705	5756252.0
2019-12-04 13:00:00	AAPL	Stock	65.705	65.7083	65.52	65.573	3122120.0
2019-12-04 14:00:00	AAPL	Stock	65.575	65.745	65.5485	65.7125	4720840.0
2019-12-04 15:00:00	AAPL	Stock	65.71	65.7175	65.435	65.435	7737340.0
2019-12-04 16:00:00	AAPL	Stock	65.435	65.445	64.8625	65.38	6182708.0
2019-12-04 17:00:00	AAPL	Stock	65.3675	65.435	65.3025	65.3675	84996.0
2019-12-04 18:00:00	AAPL	Stock	65.365	65.3925	65.335	65.3525	23568.0
2019-12-04 19:00:00	AAPL	Stock	65.3325	65.375	65.3175	65.375	27364.0
2019-12-04 04:00:00	MSFT	Stock	149.85	150.2	149.85	150.09	2400.0
2019-12-04 05:00:00	MSFT	Stock	150.24	150.45	150.04	150.38	8408.0
2019-12-04 06:00:00	MSFT	Stock	150.36	150.5	150.36	150.49	1100.0
2019-12-04 07:00:00	MSFT	Stock	150.45	150.45	150.0	150.1	27704.0
2019-12-04 08:00:00	MSFT	Stock	150.388	150.388	149.6	150.185	36383.0
2019-12-04 09:00:00	MSFT	Stock	150.08	150.4	149.2	149.73	2420584.0
2019-12-04 10:00:00	MSFT	Stock	149.7	149.809	149.25	149.76	2362283.0
2019-12-04 11:00:00	MSFT	Stock	149.765	149.98	149.5	149.75	1844967.0
2019-12-04 12:00:00	MSFT	Stock	149.76	149.79	149.31	149.53	1331202.0
2019-12-04 13:00:00	MSFT	Stock	149.53	149.64	149.36	149.51	1215312.0
2019-12-04 14:00:00	MSFT	Stock	149.515	149.895	149.49	149.82	1186433.0
2019-12-04 15:00:00	MSFT	Stock	149.83	149.99	149.675	149.83	2320059.0
2019-12-04 16:00:00	MSFT	Stock	149.85	149.9	149.31	149.73	2394036.0
2019-12-04 17:00:00	MSFT	Stock	149.7	149.84	149.7	149.83	913.0
2019-12-04 18:00:00	MSFT	Stock	149.87	149.87	149.87	149.87	472.0
2019-12-04 19:00:00	MSFT	Stock	149.72	149.81	149.65	149.65	4080.0
2019-12-04 04:00:00	NVDA	Stock	5.2325	5.2703	5.2295	5.2333	148600.0
2019-12-04 05:00:00	NVDA	Stock	5.2533	5.2533	5.2533	5.2533	25040.0
2019-12-04 06:00:00	NVDA	Stock	5.2492	5.2535	5.2492	5.252	17440.0
2019-12-04 07:00:00	NVDA	Stock	5.2625	5.2812	5.2525	5.275	998680.0
2019-12-04 08:00:00	NVDA	Stock	5.275	5.2875	5.2563	5.2718	2437080.0
2019-12-04 09:00:00	NVDA	Stock	5.2715	5.2872	5.2385	5.2676	46515680.0
2019-12-04 10:00:00	NVDA	Stock	5.2665	5.298	5.2513	5.2613	58558960.0
2019-12-04 11:00:00	NVDA	Stock	5.262	5.2673	5.2275	5.231	29399560.0
2019-12-04 12:00:00	NVDA	Stock	5.2304	5.2428	5.2205	5.2413	17529760.0
2019-12-04 13:00:00	NVDA	Stock	5.2415	5.2415	5.2068	5.226	20764400.0
2019-12-04 14:00:00	NVDA	Stock	5.2268	5.2528	5.2261	5.25	14502880.0
2019-12-04 15:00:00	NVDA	Stock	5.2502	5.2502	5.2273	5.2353	41784240.0
2019-12-04 16:00:00	NVDA	Stock	5.2355	5.2355	5.1915	5.2355	1307560.0
2019-12-04 17:00:00	NVDA	Stock	5.2312	5.235	5.23	5.235	84800.0
2019-12-04 18:00:00	NVDA	Stock	5.235	5.2355	5.2312	5.2312	55920.0
2019-12-04 19:00:00	NVDA	Stock	5.231	5.2325	5.225	5.2265	113160.0
2019-12-04 05:00:00	AMZN	Stock	89.07	89.07	89.07	89.07	10540.0
2019-12-04 06:00:00	AMZN	Stock	88.981	89.0075	88.981	89.0075	11640.0

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

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