PREVIEW / stock_1hour / 2019-02-14

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-02-14.parquet
  size:    1.1 MB
  rows:    49,759
  symbols: 2,647

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-14 04:00:00	AAPL	Stock	42.6525	42.7225	42.6475	42.675	16488.0
2019-02-14 05:00:00	AAPL	Stock	42.6425	42.6425	42.64	42.64	2396.0
2019-02-14 06:00:00	AAPL	Stock	42.6575	42.675	42.625	42.675	14400.0
2019-02-14 07:00:00	AAPL	Stock	42.6275	42.67	42.605	42.605	59124.0
2019-02-14 08:00:00	AAPL	Stock	42.6375	42.6575	42.3925	42.4	219156.0
2019-02-14 09:00:00	AAPL	Stock	42.4	42.7	42.2875	42.6638	12299808.0
2019-02-14 10:00:00	AAPL	Stock	42.6638	42.8155	42.4775	42.6412	15885836.0
2019-02-14 11:00:00	AAPL	Stock	42.645	42.675	42.475	42.67	7633464.0
2019-02-14 12:00:00	AAPL	Stock	42.67	42.8075	42.625	42.7525	7326732.0
2019-02-14 13:00:00	AAPL	Stock	42.7525	42.8	42.715	42.7188	4772644.0
2019-02-14 14:00:00	AAPL	Stock	42.718	42.795	42.6775	42.7	5618540.0
2019-02-14 15:00:00	AAPL	Stock	42.7025	42.79	42.6025	42.6975	11310756.0
2019-02-14 16:00:00	AAPL	Stock	42.7	42.7	42.1775	42.4	10509600.0
2019-02-14 17:00:00	AAPL	Stock	42.405	42.7	42.375	42.5	313664.0
2019-02-14 18:00:00	AAPL	Stock	42.5	42.5025	42.4525	42.475	34996.0
2019-02-14 19:00:00	AAPL	Stock	42.4625	42.48	42.3925	42.4	97608.0
2019-02-14 04:00:00	MSFT	Stock	107.07	107.07	107.07	107.07	100.0
2019-02-14 05:00:00	MSFT	Stock	107.09	107.09	107.09	107.09	200.0
2019-02-14 06:00:00	MSFT	Stock	107.09	107.25	107.09	107.2	700.0
2019-02-14 07:00:00	MSFT	Stock	107.12	107.16	107.06	107.06	3297.0
2019-02-14 08:00:00	MSFT	Stock	107.1	107.169	106.46	106.49	38317.0
2019-02-14 09:00:00	MSFT	Stock	106.37	106.5	105.66	106.29	2411708.0
2019-02-14 10:00:00	MSFT	Stock	106.27	106.77	105.9	106.25	3531986.0
2019-02-14 11:00:00	MSFT	Stock	106.25	106.63	105.98	106.505	1906082.0
2019-02-14 12:00:00	MSFT	Stock	106.51	107.22	106.41	106.995	1773087.0
2019-02-14 13:00:00	MSFT	Stock	107.0	107.06	106.79	106.89	1077627.0
2019-02-14 14:00:00	MSFT	Stock	106.89	107.148	106.785	106.92	1414475.0
2019-02-14 15:00:00	MSFT	Stock	106.92	107.29	106.82	106.875	3443642.0
2019-02-14 16:00:00	MSFT	Stock	106.9	107.0	106.77	106.782	3729041.0
2019-02-14 17:00:00	MSFT	Stock	106.78	106.86	106.72	106.86	5812.0
2019-02-14 18:00:00	MSFT	Stock	106.8	106.86	106.7	106.8	7284.0
2019-02-14 19:00:00	MSFT	Stock	106.76	106.76	106.4	106.4	17363.0
2019-02-14 04:00:00	NVDA	Stock	3.8378	3.8378	3.8378	3.8378	5880.0
2019-02-14 05:00:00	NVDA	Stock	3.8375	3.8375	3.8375	3.8375	7480.0
2019-02-14 06:00:00	NVDA	Stock	3.8425	3.8425	3.8425	3.8425	4000.0
2019-02-14 07:00:00	NVDA	Stock	3.85	3.8648	3.8452	3.8575	804960.0
2019-02-14 08:00:00	NVDA	Stock	3.85	3.8665	3.826	3.8298	4372880.0
2019-02-14 09:00:00	NVDA	Stock	3.8282	3.8892	3.7775	3.8822	116162120.0
2019-02-14 10:00:00	NVDA	Stock	3.8835	3.8916	3.8078	3.8496	126370000.0
2019-02-14 11:00:00	NVDA	Stock	3.8502	3.8546	3.829	3.8349	57427640.0
2019-02-14 12:00:00	NVDA	Stock	3.8352	3.8735	3.8282	3.8712	49807480.0
2019-02-14 13:00:00	NVDA	Stock	3.8714	3.8772	3.8568	3.8596	47866240.0
2019-02-14 14:00:00	NVDA	Stock	3.8592	3.8625	3.8438	3.8468	46959680.0
2019-02-14 15:00:00	NVDA	Stock	3.8472	3.866	3.8458	3.8632	117141600.0
2019-02-14 16:00:00	NVDA	Stock	3.8588	4.222	3.8502	4.1475	137253040.0
2019-02-14 17:00:00	NVDA	Stock	4.1475	4.2045	4.145	4.17	31587520.0
2019-02-14 18:00:00	NVDA	Stock	4.169	4.1712	4.09	4.1005	18630120.0
2019-02-14 19:00:00	NVDA	Stock	4.1	4.1	4.055	4.0688	9563920.0
2019-02-14 04:00:00	AMZN	Stock	82.25	82.2955	82.25	82.2955	6240.0
2019-02-14 05:00:00	AMZN	Stock	82.3255	82.3255	82.3255	82.3255	9920.0

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

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