PREVIEW / stock_1hour / 2019-04-10

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-04-10.parquet
  size:    1.1 MB
  rows:    49,918
  symbols: 2,629

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-04-10 04:00:00	AAPL	Stock	49.4475	49.4575	49.295	49.435	90256.0
2019-04-10 05:00:00	AAPL	Stock	49.3775	49.475	49.375	49.47	58304.0
2019-04-10 06:00:00	AAPL	Stock	49.475	49.5475	49.35	49.45	144640.0
2019-04-10 07:00:00	AAPL	Stock	49.4675	49.81	49.38	49.6925	675128.0
2019-04-10 08:00:00	AAPL	Stock	49.55	49.8625	49.4	49.7125	593556.0
2019-04-10 09:00:00	AAPL	Stock	49.725	49.9925	49.595	49.6608	16258640.0
2019-04-10 10:00:00	AAPL	Stock	49.6588	49.9275	49.545	49.8502	14338416.0
2019-04-10 11:00:00	AAPL	Stock	49.85	49.9225	49.8022	49.835	8376200.0
2019-04-10 12:00:00	AAPL	Stock	49.8375	49.9325	49.785	49.8935	4871556.0
2019-04-10 13:00:00	AAPL	Stock	49.895	50.0	49.8175	49.9968	4778572.0
2019-04-10 14:00:00	AAPL	Stock	49.9952	50.0	49.8315	49.9208	7243256.0
2019-04-10 15:00:00	AAPL	Stock	49.9225	50.185	49.8975	50.165	15487552.0
2019-04-10 16:00:00	AAPL	Stock	50.155	50.2	50.15	50.1575	4013060.0
2019-04-10 17:00:00	AAPL	Stock	50.1625	50.165	50.125	50.155	54752.0
2019-04-10 18:00:00	AAPL	Stock	50.16	50.185	50.14	50.1725	49368.0
2019-04-10 19:00:00	AAPL	Stock	50.155	50.2375	50.15	50.225	64088.0
2019-04-10 04:00:00	MSFT	Stock	119.3	119.65	119.3	119.65	436.0
2019-04-10 05:00:00	MSFT	Stock	119.63	119.63	119.63	119.63	100.0
2019-04-10 06:00:00	MSFT	Stock	119.63	119.7	119.63	119.7	648.0
2019-04-10 07:00:00	MSFT	Stock	119.68	119.83	119.45	119.55	2930.0
2019-04-10 08:00:00	MSFT	Stock	119.54	119.9	119.3	119.51	25852.0
2019-04-10 09:00:00	MSFT	Stock	119.5	120.095	119.38	119.77	2340933.0
2019-04-10 10:00:00	MSFT	Stock	119.76	120.21	119.66	120.03	2056977.0
2019-04-10 11:00:00	MSFT	Stock	120.025	120.35	119.99	120.21	1392846.0
2019-04-10 12:00:00	MSFT	Stock	120.21	120.27	119.99	120.03	919177.0
2019-04-10 13:00:00	MSFT	Stock	120.024	120.09	119.88	120.054	903537.0
2019-04-10 14:00:00	MSFT	Stock	120.06	120.12	119.63	120.01	1358525.0
2019-04-10 15:00:00	MSFT	Stock	120.01	120.29	119.975	120.22	2435814.0
2019-04-10 16:00:00	MSFT	Stock	120.19	120.35	120.19	120.35	1625072.0
2019-04-10 17:00:00	MSFT	Stock	120.34	120.35	120.2	120.25	12107.0
2019-04-10 18:00:00	MSFT	Stock	120.2	120.25	120.18	120.2	5072.0
2019-04-10 19:00:00	MSFT	Stock	120.27	120.54	120.27	120.51	13271.0
2019-04-10 05:00:00	NVDA	Stock	4.7315	4.7315	4.73	4.73	20000.0
2019-04-10 06:00:00	NVDA	Stock	4.757	4.757	4.757	4.757	4000.0
2019-04-10 07:00:00	NVDA	Stock	4.7405	4.7593	4.735	4.7468	1344560.0
2019-04-10 08:00:00	NVDA	Stock	4.74	4.7563	4.7228	4.7315	2244120.0
2019-04-10 09:00:00	NVDA	Stock	4.7315	4.7922	4.7238	4.7888	83586880.0
2019-04-10 10:00:00	NVDA	Stock	4.7881	4.8184	4.7828	4.8038	90294560.0
2019-04-10 11:00:00	NVDA	Stock	4.8045	4.8285	4.7995	4.8	51759720.0
2019-04-10 12:00:00	NVDA	Stock	4.801	4.8042	4.7888	4.7992	31646080.0
2019-04-10 13:00:00	NVDA	Stock	4.7992	4.8055	4.7878	4.7908	19963600.0
2019-04-10 14:00:00	NVDA	Stock	4.7922	4.794	4.76	4.7788	45925120.0
2019-04-10 15:00:00	NVDA	Stock	4.779	4.8108	4.7775	4.8037	67570920.0
2019-04-10 16:00:00	NVDA	Stock	4.8025	4.8088	4.8025	4.8062	3744760.0
2019-04-10 17:00:00	NVDA	Stock	4.805	4.8083	4.805	4.8083	186680.0
2019-04-10 18:00:00	NVDA	Stock	4.8075	4.8088	4.8062	4.8062	182240.0
2019-04-10 19:00:00	NVDA	Stock	4.8085	4.8125	4.8062	4.8095	400040.0
2019-04-10 04:00:00	AMZN	Stock	92.0255	92.0255	92.0155	92.0155	8300.0
2019-04-10 06:00:00	AMZN	Stock	92.1225	92.196	92.1005	92.174	21000.0
2019-04-10 07:00:00	AMZN	Stock	92.1875	92.2415	92.15	92.1875	159740.0

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

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