PREVIEW / stock_1hour / 2019-01-08

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-01-08.parquet
  size:    1.1 MB
  rows:    49,669
  symbols: 2,696

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-01-08 04:00:00	AAPL	Stock	37.125	37.15	37.0275	37.125	21652.0
2019-01-08 05:00:00	AAPL	Stock	37.0525	37.0525	36.9975	37.05	41872.0
2019-01-08 06:00:00	AAPL	Stock	37.0875	37.1375	37.075	37.125	51632.0
2019-01-08 07:00:00	AAPL	Stock	37.11	37.1875	37.0775	37.1325	246768.0
2019-01-08 08:00:00	AAPL	Stock	37.1625	37.24	37.0675	37.24	653652.0
2019-01-08 09:00:00	AAPL	Stock	37.24	37.5125	37.1075	37.2525	25687404.0
2019-01-08 10:00:00	AAPL	Stock	37.255	37.4325	37.13	37.2225	22312228.0
2019-01-08 11:00:00	AAPL	Stock	37.2275	37.555	37.205	37.379	15295108.0
2019-01-08 12:00:00	AAPL	Stock	37.3802	37.68	37.3575	37.4975	16024844.0
2019-01-08 13:00:00	AAPL	Stock	37.5012	37.86	37.4375	37.825	17556368.0
2019-01-08 14:00:00	AAPL	Stock	37.8225	37.955	37.6875	37.855	12736104.0
2019-01-08 15:00:00	AAPL	Stock	37.855	37.8575	37.64	37.6925	20579236.0
2019-01-08 16:00:00	AAPL	Stock	37.6875	37.725	37.6118	37.6875	10181872.0
2019-01-08 17:00:00	AAPL	Stock	37.6875	37.7115	37.645	37.6875	189512.0
2019-01-08 18:00:00	AAPL	Stock	37.675	37.8	37.675	37.77	313984.0
2019-01-08 19:00:00	AAPL	Stock	37.7575	37.7875	37.7075	37.7875	218916.0
2019-01-08 04:00:00	MSFT	Stock	102.45	102.61	102.45	102.61	200.0
2019-01-08 05:00:00	MSFT	Stock	102.73	102.73	102.73	102.73	100.0
2019-01-08 06:00:00	MSFT	Stock	102.83	103.2	102.71	103.2	6308.0
2019-01-08 07:00:00	MSFT	Stock	103.09	103.19	102.65	102.71	22960.0
2019-01-08 08:00:00	MSFT	Stock	102.95	103.2	102.3	103.08	84804.0
2019-01-08 09:00:00	MSFT	Stock	103.1	103.97	102.89	103.063	4844903.0
2019-01-08 10:00:00	MSFT	Stock	103.07	103.39	101.8	101.99	4754856.0
2019-01-08 11:00:00	MSFT	Stock	102.0	102.51	101.713	102.24	3138481.0
2019-01-08 12:00:00	MSFT	Stock	102.24	102.727	102.09	102.385	2290363.0
2019-01-08 13:00:00	MSFT	Stock	102.38	103.16	102.165	102.96	2076076.0
2019-01-08 14:00:00	MSFT	Stock	102.96	103.155	102.74	102.92	2090794.0
2019-01-08 15:00:00	MSFT	Stock	102.91	103.0	102.51	102.81	4261252.0
2019-01-08 16:00:00	MSFT	Stock	102.8	102.81	102.67	102.67	4880313.0
2019-01-08 17:00:00	MSFT	Stock	102.75	102.77	102.67	102.77	3216.0
2019-01-08 18:00:00	MSFT	Stock	102.8	102.8	102.67	102.69	2999.0
2019-01-08 19:00:00	MSFT	Stock	102.7	102.99	102.7	102.99	13930.0
2019-01-08 04:00:00	NVDA	Stock	3.65	3.6925	3.65	3.665	106240.0
2019-01-08 05:00:00	NVDA	Stock	3.6588	3.6625	3.6588	3.6625	57920.0
2019-01-08 06:00:00	NVDA	Stock	3.6635	3.6635	3.6438	3.6625	479440.0
2019-01-08 07:00:00	NVDA	Stock	3.658	3.671	3.6318	3.635	2679120.0
2019-01-08 08:00:00	NVDA	Stock	3.652	3.6722	3.5938	3.6675	4908240.0
2019-01-08 09:00:00	NVDA	Stock	3.6702	3.6795	3.5005	3.5139	149079360.0
2019-01-08 10:00:00	NVDA	Stock	3.5148	3.5175	3.4225	3.4432	184582320.0
2019-01-08 11:00:00	NVDA	Stock	3.4435	3.4738	3.4312	3.4688	95617920.0
2019-01-08 12:00:00	NVDA	Stock	3.4678	3.5038	3.4658	3.4775	75938400.0
2019-01-08 13:00:00	NVDA	Stock	3.4762	3.4992	3.466	3.4925	42577000.0
2019-01-08 14:00:00	NVDA	Stock	3.4936	3.5112	3.4725	3.5016	50810040.0
2019-01-08 15:00:00	NVDA	Stock	3.5015	3.506	3.4772	3.4955	74416720.0
2019-01-08 16:00:00	NVDA	Stock	3.4958	3.498	3.4875	3.4928	28647360.0
2019-01-08 17:00:00	NVDA	Stock	3.488	3.4925	3.488	3.4922	159720.0
2019-01-08 18:00:00	NVDA	Stock	3.4915	3.4938	3.4895	3.4938	457880.0
2019-01-08 19:00:00	NVDA	Stock	3.4938	3.4992	3.4913	3.495	1954800.0
2019-01-08 04:00:00	AMZN	Stock	82.2385	82.591	82.2385	82.3005	50720.0
2019-01-08 05:00:00	AMZN	Stock	82.334	82.45	82.334	82.45	25940.0

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

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