PREVIEW / stock_1hour / 2019-07-01

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-07-01.parquet
  size:    1.2 MB
  rows:    53,307
  symbols: 2,604

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-07-01 04:00:00	AAPL	Stock	50.37	50.9225	50.37	50.7825	115200.0
2019-07-01 05:00:00	AAPL	Stock	50.83	50.8475	50.785	50.805	35888.0
2019-07-01 06:00:00	AAPL	Stock	50.78	50.9375	50.755	50.87	61992.0
2019-07-01 07:00:00	AAPL	Stock	50.8475	50.875	50.6025	50.8375	570108.0
2019-07-01 08:00:00	AAPL	Stock	50.7925	50.8875	50.593	50.755	946736.0
2019-07-01 09:00:00	AAPL	Stock	50.77	51.1225	50.675	50.8625	20805140.0
2019-07-01 10:00:00	AAPL	Stock	50.8625	51.0	50.5935	50.7355	14831176.0
2019-07-01 11:00:00	AAPL	Stock	50.7375	50.7825	50.525	50.5575	7654456.0
2019-07-01 12:00:00	AAPL	Stock	50.555	50.575	50.235	50.28	7349376.0
2019-07-01 13:00:00	AAPL	Stock	50.28	50.4425	50.2112	50.3725	7834692.0
2019-07-01 14:00:00	AAPL	Stock	50.3738	50.38	50.1625	50.1815	7018572.0
2019-07-01 15:00:00	AAPL	Stock	50.1818	50.4825	50.1675	50.42	13239640.0
2019-07-01 16:00:00	AAPL	Stock	50.4025	50.4025	50.21	50.3425	7631336.0
2019-07-01 17:00:00	AAPL	Stock	50.3375	50.3475	50.2875	50.3475	65180.0
2019-07-01 18:00:00	AAPL	Stock	50.3475	50.365	50.2875	50.305	146528.0
2019-07-01 19:00:00	AAPL	Stock	50.3	50.3325	50.29	50.3125	48448.0
2019-07-01 04:00:00	MSFT	Stock	135.5	136.5	135.5	136.38	7977.0
2019-07-01 05:00:00	MSFT	Stock	136.3	136.35	136.24	136.35	9720.0
2019-07-01 06:00:00	MSFT	Stock	136.28	136.35	135.36	136.28	5587.0
2019-07-01 07:00:00	MSFT	Stock	136.2	136.2	135.95	136.02	18037.0
2019-07-01 08:00:00	MSFT	Stock	136.25	136.3	133.96	135.89	88941.0
2019-07-01 09:00:00	MSFT	Stock	135.88	136.77	135.7	136.0	3210180.0
2019-07-01 10:00:00	MSFT	Stock	136.0	136.34	135.72	135.89	2567039.0
2019-07-01 11:00:00	MSFT	Stock	135.89	136.19	135.75	135.98	1765643.0
2019-07-01 12:00:00	MSFT	Stock	135.985	136.11	135.24	135.29	1519224.0
2019-07-01 13:00:00	MSFT	Stock	135.296	135.578	135.21	135.305	1472826.0
2019-07-01 14:00:00	MSFT	Stock	135.31	135.32	134.97	135.146	1723432.0
2019-07-01 15:00:00	MSFT	Stock	135.152	135.75	135.125	135.69	3782195.0
2019-07-01 16:00:00	MSFT	Stock	135.68	135.71	135.5	135.63	2452200.0
2019-07-01 17:00:00	MSFT	Stock	135.65	135.65	135.54	135.55	1193.0
2019-07-01 18:00:00	MSFT	Stock	135.6	135.65	135.47	135.47	3391.0
2019-07-01 19:00:00	MSFT	Stock	135.2	135.5	135.2	135.35	4440.0
2019-07-01 04:00:00	NVDA	Stock	4.19	4.2563	4.19	4.2563	1288080.0
2019-07-01 05:00:00	NVDA	Stock	4.2575	4.2715	4.247	4.2715	362080.0
2019-07-01 06:00:00	NVDA	Stock	4.2653	4.287	4.2625	4.2752	486000.0
2019-07-01 07:00:00	NVDA	Stock	4.2755	4.31	4.2645	4.3078	3491280.0
2019-07-01 08:00:00	NVDA	Stock	4.2658	4.3182	4.1057	4.3125	5009200.0
2019-07-01 09:00:00	NVDA	Stock	4.3128	4.3488	4.231	4.2638	149406640.0
2019-07-01 10:00:00	NVDA	Stock	4.263	4.2875	4.2178	4.235	107792680.0
2019-07-01 11:00:00	NVDA	Stock	4.2368	4.2408	4.1763	4.1781	87741160.0
2019-07-01 12:00:00	NVDA	Stock	4.178	4.186	4.1408	4.1472	82050680.0
2019-07-01 13:00:00	NVDA	Stock	4.1485	4.175	4.1373	4.1553	65111520.0
2019-07-01 14:00:00	NVDA	Stock	4.1555	4.1558	4.1165	4.1288	55938880.0
2019-07-01 15:00:00	NVDA	Stock	4.128	4.1605	4.1224	4.155	90762880.0
2019-07-01 16:00:00	NVDA	Stock	4.1542	4.1588	4.15	4.155	22000240.0
2019-07-01 17:00:00	NVDA	Stock	4.155	4.1575	4.1505	4.157	417320.0
2019-07-01 18:00:00	NVDA	Stock	4.1575	4.16	4.1498	4.1525	572560.0
2019-07-01 19:00:00	NVDA	Stock	4.1528	4.1562	4.1515	4.1525	256760.0
2019-07-01 04:00:00	AMZN	Stock	95.82	96.1355	95.82	96.1	23560.0
2019-07-01 05:00:00	AMZN	Stock	96.0	96.0	96.0	96.0	2000.0

> showing 50 of 53,307 rows — these rows as CSV

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