PREVIEW / stock_1hour / 2019-02-08

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-02-08.parquet
  size:    1.1 MB
  rows:    48,898
  symbols: 2,641

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-08 04:00:00	AAPL	Stock	42.185	42.45	42.1675	42.275	44836.0
2019-02-08 05:00:00	AAPL	Stock	42.275	42.32	42.225	42.25	44256.0
2019-02-08 06:00:00	AAPL	Stock	42.255	42.3125	42.105	42.1375	21400.0
2019-02-08 07:00:00	AAPL	Stock	42.2225	42.295	42.125	42.2725	274004.0
2019-02-08 08:00:00	AAPL	Stock	42.13	42.84	42.125	42.2975	381328.0
2019-02-08 09:00:00	AAPL	Stock	42.2825	42.42	42.105	42.2975	13601028.0
2019-02-08 10:00:00	AAPL	Stock	42.295	42.59	42.22	42.387	15980992.0
2019-02-08 11:00:00	AAPL	Stock	42.39	42.4575	42.255	42.444	9468440.0
2019-02-08 12:00:00	AAPL	Stock	42.445	42.51	42.3225	42.45	7122004.0
2019-02-08 13:00:00	AAPL	Stock	42.4525	42.5765	42.4365	42.5625	7151396.0
2019-02-08 14:00:00	AAPL	Stock	42.56	42.665	42.5125	42.62	8050756.0
2019-02-08 15:00:00	AAPL	Stock	42.6175	42.63	42.4575	42.625	14991160.0
2019-02-08 16:00:00	AAPL	Stock	42.6325	42.6325	42.52	42.55	7944356.0
2019-02-08 17:00:00	AAPL	Stock	42.5625	42.5825	42.5375	42.5525	63916.0
2019-02-08 18:00:00	AAPL	Stock	42.5675	42.575	42.5525	42.5725	15828.0
2019-02-08 19:00:00	AAPL	Stock	42.5725	42.595	42.5575	42.58	56852.0
2019-02-08 05:00:00	MSFT	Stock	104.72	104.74	104.23	104.74	1796.0
2019-02-08 06:00:00	MSFT	Stock	104.53	104.53	104.42	104.5	10564.0
2019-02-08 07:00:00	MSFT	Stock	104.5	104.67	104.38	104.5	24638.0
2019-02-08 08:00:00	MSFT	Stock	104.38	105.53	104.38	104.63	27184.0
2019-02-08 09:00:00	MSFT	Stock	104.55	105.218	104.25	104.81	2589912.0
2019-02-08 10:00:00	MSFT	Stock	104.81	105.34	104.63	105.03	2960750.0
2019-02-08 11:00:00	MSFT	Stock	105.03	105.16	104.61	105.0	2358297.0
2019-02-08 12:00:00	MSFT	Stock	105.01	105.12	104.71	104.77	1586125.0
2019-02-08 13:00:00	MSFT	Stock	104.77	104.99	104.7	104.925	1340895.0
2019-02-08 14:00:00	MSFT	Stock	104.93	105.27	104.902	105.095	1424643.0
2019-02-08 15:00:00	MSFT	Stock	105.09	105.78	104.98	105.75	3336695.0
2019-02-08 16:00:00	MSFT	Stock	105.75	105.75	105.36	105.57	3532000.0
2019-02-08 17:00:00	MSFT	Stock	105.57	105.67	105.57	105.66	2199.0
2019-02-08 18:00:00	MSFT	Stock	105.57	105.6	105.57	105.57	753.0
2019-02-08 19:00:00	MSFT	Stock	105.62	105.67	105.6	105.67	3681.0
2019-02-08 04:00:00	NVDA	Stock	3.6625	3.6625	3.6625	3.6625	42560.0
2019-02-08 05:00:00	NVDA	Stock	3.65	3.653	3.65	3.653	8000.0
2019-02-08 07:00:00	NVDA	Stock	3.6502	3.6502	3.6158	3.6225	826200.0
2019-02-08 08:00:00	NVDA	Stock	3.6375	3.6488	3.6138	3.615	1918280.0
2019-02-08 09:00:00	NVDA	Stock	3.6145	3.6612	3.6025	3.6238	79064600.0
2019-02-08 10:00:00	NVDA	Stock	3.6225	3.6575	3.609	3.633	75406440.0
2019-02-08 11:00:00	NVDA	Stock	3.6335	3.6418	3.6035	3.6305	44184560.0
2019-02-08 12:00:00	NVDA	Stock	3.6303	3.6535	3.6188	3.6528	36147480.0
2019-02-08 13:00:00	NVDA	Stock	3.6534	3.6935	3.6525	3.689	58478240.0
2019-02-08 14:00:00	NVDA	Stock	3.69	3.715	3.6828	3.6975	60587560.0
2019-02-08 15:00:00	NVDA	Stock	3.696	3.7062	3.6845	3.7055	55826080.0
2019-02-08 16:00:00	NVDA	Stock	3.7042	3.7105	3.693	3.7025	18821520.0
2019-02-08 17:00:00	NVDA	Stock	3.7	3.715	3.7	3.7093	946320.0
2019-02-08 18:00:00	NVDA	Stock	3.708	3.7093	3.7032	3.7093	194960.0
2019-02-08 19:00:00	NVDA	Stock	3.7088	3.71	3.7038	3.705	326360.0
2019-02-08 04:00:00	AMZN	Stock	80.242	80.242	80.242	80.242	3180.0
2019-02-08 06:00:00	AMZN	Stock	79.75	79.75	79.75	79.75	2320.0
2019-02-08 07:00:00	AMZN	Stock	79.7505	79.753	79.075	79.135	712100.0
2019-02-08 08:00:00	AMZN	Stock	79.7515	79.85	79.1125	79.45	834180.0

> showing 50 of 48,898 rows — these rows as CSV

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