PREVIEW / stock_1hour / 2019-02-11

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-02-11.parquet
  size:    1.1 MB
  rows:    49,393
  symbols: 2,675

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-02-11 04:00:00	AAPL	Stock	42.8175	42.8175	42.7375	42.8125	2800.0
2019-02-11 05:00:00	AAPL	Stock	42.75	42.8125	42.705	42.705	18124.0
2019-02-11 06:00:00	AAPL	Stock	42.75	42.75	42.6375	42.6875	17064.0
2019-02-11 07:00:00	AAPL	Stock	42.6975	42.785	42.6375	42.785	126356.0
2019-02-11 08:00:00	AAPL	Stock	42.6875	42.845	42.67	42.7875	267228.0
2019-02-11 09:00:00	AAPL	Stock	42.795	42.8025	42.3525	42.554	11152420.0
2019-02-11 10:00:00	AAPL	Stock	42.555	42.675	42.5025	42.53	12664392.0
2019-02-11 11:00:00	AAPL	Stock	42.5325	42.5425	42.345	42.45	8761840.0
2019-02-11 12:00:00	AAPL	Stock	42.45	42.6675	42.4225	42.615	6228412.0
2019-02-11 13:00:00	AAPL	Stock	42.615	42.625	42.4075	42.48	5656596.0
2019-02-11 14:00:00	AAPL	Stock	42.4775	42.525	42.3588	42.3825	6523812.0
2019-02-11 15:00:00	AAPL	Stock	42.385	42.48	42.3125	42.3625	12238796.0
2019-02-11 16:00:00	AAPL	Stock	42.3575	42.36	42.2575	42.275	7186312.0
2019-02-11 17:00:00	AAPL	Stock	42.2675	42.3575	42.255	42.2625	48296.0
2019-02-11 18:00:00	AAPL	Stock	42.2625	42.27	42.225	42.2625	35316.0
2019-02-11 19:00:00	AAPL	Stock	42.2625	42.3575	42.25	42.345	136752.0
2019-02-11 05:00:00	MSFT	Stock	106.3	106.3	106.14	106.14	1531.0
2019-02-11 07:00:00	MSFT	Stock	106.0	106.3	105.99	106.3	5758.0
2019-02-11 08:00:00	MSFT	Stock	106.2	106.36	105.85	106.13	15480.0
2019-02-11 09:00:00	MSFT	Stock	106.11	106.58	105.78	105.9	2140786.0
2019-02-11 10:00:00	MSFT	Stock	105.9	106.09	105.42	105.51	2322810.0
2019-02-11 11:00:00	MSFT	Stock	105.51	105.65	105.16	105.33	1978021.0
2019-02-11 12:00:00	MSFT	Stock	105.322	105.65	105.26	105.485	1203747.0
2019-02-11 13:00:00	MSFT	Stock	105.495	105.52	105.084	105.23	1337856.0
2019-02-11 14:00:00	MSFT	Stock	105.228	105.4	104.965	105.145	1438475.0
2019-02-11 15:00:00	MSFT	Stock	105.14	105.51	105.12	105.28	3048779.0
2019-02-11 16:00:00	MSFT	Stock	105.25	105.34	105.2	105.25	2619230.0
2019-02-11 17:00:00	MSFT	Stock	105.29	105.29	105.21	105.25	1391.0
2019-02-11 18:00:00	MSFT	Stock	105.24	105.26	105.24	105.26	2175.0
2019-02-11 19:00:00	MSFT	Stock	105.26	105.85	105.26	105.69	20604.0
2019-02-11 04:00:00	NVDA	Stock	3.6795	3.7163	3.6625	3.6908	818000.0
2019-02-11 05:00:00	NVDA	Stock	3.695	3.7	3.659	3.659	212600.0
2019-02-11 06:00:00	NVDA	Stock	3.674	3.6922	3.6535	3.6545	805280.0
2019-02-11 07:00:00	NVDA	Stock	3.6625	3.6728	3.64	3.6632	2486080.0
2019-02-11 08:00:00	NVDA	Stock	3.6625	3.6725	3.6375	3.642	4214720.0
2019-02-11 09:00:00	NVDA	Stock	3.6425	3.6738	3.6125	3.6378	86455560.0
2019-02-11 10:00:00	NVDA	Stock	3.6386	3.7145	3.6335	3.6818	118014240.0
2019-02-11 11:00:00	NVDA	Stock	3.6838	3.6918	3.6568	3.6647	53285840.0
2019-02-11 12:00:00	NVDA	Stock	3.6641	3.686	3.6628	3.6758	34049480.0
2019-02-11 13:00:00	NVDA	Stock	3.676	3.6763	3.6516	3.6628	32217000.0
2019-02-11 14:00:00	NVDA	Stock	3.6622	3.6738	3.6508	3.6528	31069360.0
2019-02-11 15:00:00	NVDA	Stock	3.6528	3.6638	3.6485	3.6618	64411600.0
2019-02-11 16:00:00	NVDA	Stock	3.6612	3.6615	3.6476	3.6523	25415680.0
2019-02-11 17:00:00	NVDA	Stock	3.6525	3.6612	3.6505	3.6535	1401400.0
2019-02-11 18:00:00	NVDA	Stock	3.6515	3.6535	3.65	3.6535	167040.0
2019-02-11 19:00:00	NVDA	Stock	3.6538	3.6675	3.6525	3.6622	1167240.0
2019-02-11 04:00:00	AMZN	Stock	79.95	80.0	79.95	80.0	23480.0
2019-02-11 05:00:00	AMZN	Stock	80.125	80.125	80.125	80.125	5540.0
2019-02-11 06:00:00	AMZN	Stock	80.013	80.013	79.98	80.0	17980.0
2019-02-11 07:00:00	AMZN	Stock	79.958	80.25	79.8555	80.25	287380.0

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

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