PREVIEW / stock_1hour / 2019-04-23

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-04-23.parquet
  size:    1.1 MB
  rows:    50,219
  symbols: 2,632

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-23 04:00:00	AAPL	Stock	51.155	51.155	51.0	51.0075	20968.0
2019-04-23 05:00:00	AAPL	Stock	51.05	51.075	51.01	51.01	5140.0
2019-04-23 06:00:00	AAPL	Stock	51.0525	51.075	50.615	50.9125	162052.0
2019-04-23 07:00:00	AAPL	Stock	50.93	51.1075	50.8875	51.0925	171464.0
2019-04-23 08:00:00	AAPL	Stock	50.9175	51.2625	50.88	50.995	367376.0
2019-04-23 09:00:00	AAPL	Stock	51.0125	51.385	50.97	51.348	13379416.0
2019-04-23 10:00:00	AAPL	Stock	51.3525	51.4975	51.2775	51.4925	12469740.0
2019-04-23 11:00:00	AAPL	Stock	51.49	51.69	51.4225	51.6612	9495092.0
2019-04-23 12:00:00	AAPL	Stock	51.661	51.885	51.6425	51.8325	8707164.0
2019-04-23 13:00:00	AAPL	Stock	51.8325	51.8575	51.7275	51.745	5255136.0
2019-04-23 14:00:00	AAPL	Stock	51.7488	51.8975	51.72	51.8825	6084484.0
2019-04-23 15:00:00	AAPL	Stock	51.8825	51.9375	51.75	51.8775	13360100.0
2019-04-23 16:00:00	AAPL	Stock	51.87	51.9075	51.815	51.8875	11282464.0
2019-04-23 17:00:00	AAPL	Stock	51.8975	51.8975	51.855	51.88	53600.0
2019-04-23 18:00:00	AAPL	Stock	51.87	51.8875	51.8675	51.88	8896.0
2019-04-23 19:00:00	AAPL	Stock	51.87	51.89	51.8375	51.89	40952.0
2019-04-23 04:00:00	MSFT	Stock	123.85	123.99	123.85	123.98	2084.0
2019-04-23 05:00:00	MSFT	Stock	123.98	123.98	123.9	123.97	1236.0
2019-04-23 06:00:00	MSFT	Stock	123.95	123.95	123.78	123.78	1580.0
2019-04-23 07:00:00	MSFT	Stock	123.84	123.94	123.62	123.8	17225.0
2019-04-23 08:00:00	MSFT	Stock	123.82	124.1	123.69	123.91	49414.0
2019-04-23 09:00:00	MSFT	Stock	124.0	124.995	123.83	124.84	2984957.0
2019-04-23 10:00:00	MSFT	Stock	124.845	125.25	124.372	124.44	3496773.0
2019-04-23 11:00:00	MSFT	Stock	124.445	124.88	124.122	124.84	2314062.0
2019-04-23 12:00:00	MSFT	Stock	124.835	125.04	124.77	125.03	1802871.0
2019-04-23 13:00:00	MSFT	Stock	125.03	125.068	124.895	124.938	1453702.0
2019-04-23 14:00:00	MSFT	Stock	124.93	128.28	124.88	125.34	1616386.0
2019-04-23 15:00:00	MSFT	Stock	125.34	125.58	125.18	125.44	3671679.0
2019-04-23 16:00:00	MSFT	Stock	125.44	125.69	125.33	125.43	2529803.0
2019-04-23 17:00:00	MSFT	Stock	125.45	125.55	125.41	125.49	15182.0
2019-04-23 18:00:00	MSFT	Stock	125.49	125.49	125.43	125.48	2739.0
2019-04-23 19:00:00	MSFT	Stock	125.48	125.59	125.44	125.59	1638.0
2019-04-23 04:00:00	NVDA	Stock	4.7138	4.7182	4.7138	4.7182	13280.0
2019-04-23 05:00:00	NVDA	Stock	4.725	4.725	4.725	4.725	20000.0
2019-04-23 06:00:00	NVDA	Stock	4.725	4.725	4.7188	4.7188	78520.0
2019-04-23 07:00:00	NVDA	Stock	4.725	4.7328	4.7213	4.7328	207080.0
2019-04-23 08:00:00	NVDA	Stock	4.7325	4.7425	4.7138	4.7222	943320.0
2019-04-23 09:00:00	NVDA	Stock	4.7222	4.7905	4.7152	4.7558	72314080.0
2019-04-23 10:00:00	NVDA	Stock	4.7565	4.781	4.7502	4.7699	42970520.0
2019-04-23 11:00:00	NVDA	Stock	4.7708	4.7978	4.7575	4.795	36050560.0
2019-04-23 12:00:00	NVDA	Stock	4.7943	4.7982	4.7775	4.7878	26617920.0
2019-04-23 13:00:00	NVDA	Stock	4.7883	4.795	4.7762	4.7842	22842520.0
2019-04-23 14:00:00	NVDA	Stock	4.7835	4.794	4.78	4.7862	19723640.0
2019-04-23 15:00:00	NVDA	Stock	4.7865	4.7982	4.7593	4.7668	50447080.0
2019-04-23 16:00:00	NVDA	Stock	4.7668	4.78	4.7575	4.7612	20295440.0
2019-04-23 17:00:00	NVDA	Stock	4.771	4.772	4.7312	4.7475	846080.0
2019-04-23 18:00:00	NVDA	Stock	4.7438	4.7525	4.7438	4.7475	391880.0
2019-04-23 19:00:00	NVDA	Stock	4.7455	4.7525	4.7455	4.7525	341440.0
2019-04-23 04:00:00	AMZN	Stock	94.4	94.4	94.27	94.2925	18240.0
2019-04-23 06:00:00	AMZN	Stock	94.285	94.285	94.285	94.285	2100.0

> showing 50 of 50,219 rows — these rows as CSV

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