PREVIEW / stock_1hour / 2018-08-20

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-08-20.parquet
  size:    1.1 MB
  rows:    49,316
  symbols: 2,797

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
2018-08-20 04:00:00	AAPL	Stock	54.5625	54.8375	54.5625	54.825	38320.0
2018-08-20 05:00:00	AAPL	Stock	54.81	54.81	54.725	54.7625	63068.0
2018-08-20 06:00:00	AAPL	Stock	54.75	54.75	54.65	54.6775	72044.0
2018-08-20 07:00:00	AAPL	Stock	54.645	54.7225	54.465	54.5	629292.0
2018-08-20 08:00:00	AAPL	Stock	54.66	54.725	54.395	54.49	1090472.0
2018-08-20 09:00:00	AAPL	Stock	54.4775	54.795	54.2825	54.3675	22156460.0
2018-08-20 10:00:00	AAPL	Stock	54.3575	54.51	53.9345	53.9622	21854236.0
2018-08-20 11:00:00	AAPL	Stock	53.96	53.9822	53.7775	53.8275	15115204.0
2018-08-20 12:00:00	AAPL	Stock	53.83	54.0525	53.7775	54.0485	7592776.0
2018-08-20 13:00:00	AAPL	Stock	54.05	54.2	54.0235	54.0825	7219216.0
2018-08-20 14:00:00	AAPL	Stock	54.0825	54.105	53.8125	53.9038	8087896.0
2018-08-20 15:00:00	AAPL	Stock	53.9025	53.935	53.805	53.8625	11413196.0
2018-08-20 16:00:00	AAPL	Stock	53.865	53.8875	53.8275	53.8375	8388496.0
2018-08-20 17:00:00	AAPL	Stock	53.835	53.865	53.8325	53.8375	108600.0
2018-08-20 18:00:00	AAPL	Stock	53.8475	53.8725	53.835	53.865	39052.0
2018-08-20 19:00:00	AAPL	Stock	53.865	53.88	53.84	53.88	50436.0
2018-08-20 04:00:00	MSFT	Stock	107.9	108.1	107.9	108.1	900.0
2018-08-20 06:00:00	MSFT	Stock	107.99	107.99	107.96	107.96	900.0
2018-08-20 07:00:00	MSFT	Stock	107.9	108.0	107.75	107.85	4839.0
2018-08-20 08:00:00	MSFT	Stock	107.999	107.999	107.81	107.81	2286.0
2018-08-20 09:00:00	MSFT	Stock	107.84	107.96	106.83	106.925	1945558.0
2018-08-20 10:00:00	MSFT	Stock	106.92	107.205	106.725	106.745	2210438.0
2018-08-20 11:00:00	MSFT	Stock	106.745	107.03	106.48	106.91	2488437.0
2018-08-20 12:00:00	MSFT	Stock	106.93	107.245	106.84	107.136	1343190.0
2018-08-20 13:00:00	MSFT	Stock	107.14	107.18	106.98	107.1	932225.0
2018-08-20 14:00:00	MSFT	Stock	107.11	107.16	106.95	107.08	1206889.0
2018-08-20 15:00:00	MSFT	Stock	107.09	107.13	106.8	106.87	2618882.0
2018-08-20 16:00:00	MSFT	Stock	106.87	106.95	106.75	106.87	2831372.0
2018-08-20 17:00:00	MSFT	Stock	106.94	106.94	106.87	106.877	12985.0
2018-08-20 18:00:00	MSFT	Stock	106.9	106.9	106.82	106.82	2752.0
2018-08-20 19:00:00	MSFT	Stock	106.89	106.89	106.79	106.79	15017.0
2018-08-20 04:00:00	NVDA	Stock	6.105	6.147	6.105	6.147	64800.0
2018-08-20 05:00:00	NVDA	Stock	6.1472	6.1732	6.1472	6.15	39000.0
2018-08-20 06:00:00	NVDA	Stock	6.1625	6.1625	6.1502	6.1513	24000.0
2018-08-20 07:00:00	NVDA	Stock	6.1438	6.1438	6.125	6.135	412440.0
2018-08-20 08:00:00	NVDA	Stock	6.135	6.1525	6.075	6.081	3089040.0
2018-08-20 09:00:00	NVDA	Stock	6.0875	6.129	6.005	6.0282	108814400.0
2018-08-20 10:00:00	NVDA	Stock	6.0292	6.039	5.968	6.0056	140776240.0
2018-08-20 11:00:00	NVDA	Stock	6.0052	6.0225	5.9953	6.0009	53626760.0
2018-08-20 12:00:00	NVDA	Stock	6.001	6.088	5.999	6.0873	57588480.0
2018-08-20 13:00:00	NVDA	Stock	6.0871	6.2355	6.0661	6.2348	114258040.0
2018-08-20 14:00:00	NVDA	Stock	6.2338	6.33	6.2118	6.2456	174606560.0
2018-08-20 15:00:00	NVDA	Stock	6.2456	6.252	6.1843	6.1962	114130600.0
2018-08-20 16:00:00	NVDA	Stock	6.196	6.1962	6.186	6.1938	9130120.0
2018-08-20 17:00:00	NVDA	Stock	6.1912	6.196	6.1878	6.1915	341880.0
2018-08-20 18:00:00	NVDA	Stock	6.1912	6.2068	6.1912	6.2025	515120.0
2018-08-20 19:00:00	NVDA	Stock	6.2045	6.2048	6.1988	6.1988	290840.0
2018-08-20 07:00:00	AMZN	Stock	94.508	94.6	94.456	94.5	66080.0
2018-08-20 08:00:00	AMZN	Stock	94.6495	94.6495	94.4	94.411	191500.0
2018-08-20 09:00:00	AMZN	Stock	94.44	94.5875	93.408	93.4755	9300780.0

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

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