PREVIEW / stock_1hour / 2019-07-09

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-07-09.parquet
  size:    1.1 MB
  rows:    49,807
  symbols: 2,599

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-09 04:00:00	AAPL	Stock	49.4	49.6	49.4	49.5125	64852.0
2019-07-09 05:00:00	AAPL	Stock	49.555	49.85	49.555	49.85	60836.0
2019-07-09 06:00:00	AAPL	Stock	49.8375	49.8525	49.7625	49.795	65460.0
2019-07-09 07:00:00	AAPL	Stock	49.8125	50.1025	49.7625	50.075	173100.0
2019-07-09 08:00:00	AAPL	Stock	49.7625	50.13	49.7625	50.0	375672.0
2019-07-09 09:00:00	AAPL	Stock	49.975	50.0895	49.7025	50.0625	14394344.0
2019-07-09 10:00:00	AAPL	Stock	50.065	50.19	49.9862	50.015	10984692.0
2019-07-09 11:00:00	AAPL	Stock	50.015	50.2075	49.9475	50.195	7902896.0
2019-07-09 12:00:00	AAPL	Stock	50.195	50.31	50.16	50.236	5969568.0
2019-07-09 13:00:00	AAPL	Stock	50.237	50.345	50.1882	50.3445	4125060.0
2019-07-09 14:00:00	AAPL	Stock	50.3438	50.3713	50.2525	50.2725	4307448.0
2019-07-09 15:00:00	AAPL	Stock	50.27	50.3775	50.155	50.305	10719264.0
2019-07-09 16:00:00	AAPL	Stock	50.31	50.3325	50.265	50.31	4814864.0
2019-07-09 17:00:00	AAPL	Stock	50.3125	50.32	50.295	50.315	812608.0
2019-07-09 18:00:00	AAPL	Stock	50.3125	50.3375	50.285	50.285	13664.0
2019-07-09 19:00:00	AAPL	Stock	50.285	50.3	50.2025	50.2175	45048.0
2019-07-09 04:00:00	MSFT	Stock	136.0	136.25	136.0	136.06	550.0
2019-07-09 05:00:00	MSFT	Stock	136.03	136.1	136.01	136.1	1899.0
2019-07-09 06:00:00	MSFT	Stock	136.07	136.27	136.07	136.19	458.0
2019-07-09 07:00:00	MSFT	Stock	136.15	136.35	136.1	136.15	7726.0
2019-07-09 08:00:00	MSFT	Stock	136.1	136.35	135.97	136.3	15972.0
2019-07-09 09:00:00	MSFT	Stock	136.2	136.27	135.8	136.07	2610520.0
2019-07-09 10:00:00	MSFT	Stock	136.07	136.64	136.07	136.46	2361346.0
2019-07-09 11:00:00	MSFT	Stock	136.45	136.77	136.28	136.54	1724605.0
2019-07-09 12:00:00	MSFT	Stock	136.54	136.97	136.5	136.863	1439277.0
2019-07-09 13:00:00	MSFT	Stock	136.87	136.94	136.75	136.77	1064879.0
2019-07-09 14:00:00	MSFT	Stock	136.77	136.84	136.43	136.56	1441976.0
2019-07-09 15:00:00	MSFT	Stock	136.56	136.65	136.215	136.435	3425369.0
2019-07-09 16:00:00	MSFT	Stock	136.46	136.8	136.36	136.45	2920039.0
2019-07-09 17:00:00	MSFT	Stock	136.499	136.5	136.423	136.49	332507.0
2019-07-09 18:00:00	MSFT	Stock	136.41	136.55	136.41	136.55	3109.0
2019-07-09 19:00:00	MSFT	Stock	136.43	136.43	136.24	136.24	1749.0
2019-07-09 04:00:00	NVDA	Stock	3.8768	3.8875	3.8698	3.8875	34040.0
2019-07-09 06:00:00	NVDA	Stock	3.8938	3.894	3.8915	3.8915	13680.0
2019-07-09 07:00:00	NVDA	Stock	3.9	3.9062	3.8875	3.903	463320.0
2019-07-09 08:00:00	NVDA	Stock	3.8975	3.9152	3.895	3.9105	974560.0
2019-07-09 09:00:00	NVDA	Stock	3.911	3.9275	3.875	3.9272	84748960.0
2019-07-09 10:00:00	NVDA	Stock	3.9272	3.961	3.9258	3.9448	66756960.0
2019-07-09 11:00:00	NVDA	Stock	3.9438	3.957	3.9255	3.9345	41204280.0
2019-07-09 12:00:00	NVDA	Stock	3.9346	3.9452	3.922	3.9224	26297640.0
2019-07-09 13:00:00	NVDA	Stock	3.9228	3.931	3.9148	3.9305	26519600.0
2019-07-09 14:00:00	NVDA	Stock	3.9308	3.9338	3.9168	3.9205	20172200.0
2019-07-09 15:00:00	NVDA	Stock	3.9208	3.935	3.9112	3.933	39923280.0
2019-07-09 16:00:00	NVDA	Stock	3.9328	3.935	3.9275	3.935	10003960.0
2019-07-09 17:00:00	NVDA	Stock	3.9325	3.935	3.9305	3.935	1152040.0
2019-07-09 18:00:00	NVDA	Stock	3.935	3.9375	3.9315	3.9343	257360.0
2019-07-09 19:00:00	NVDA	Stock	3.9315	3.9378	3.9295	3.934	358080.0
2019-07-09 04:00:00	AMZN	Stock	97.046	97.046	97.046	97.046	12960.0
2019-07-09 05:00:00	AMZN	Stock	96.922	96.95	96.922	96.95	4000.0
2019-07-09 07:00:00	AMZN	Stock	97.2	97.35	97.2	97.295	73480.0

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

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