PREVIEW / stock_1hour / 2019-02-22

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-02-22.parquet
  size:    1.1 MB
  rows:    49,545
  symbols: 2,654

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-22 04:00:00	AAPL	Stock	42.9225	42.9225	42.9	42.9	4048.0
2019-02-22 05:00:00	AAPL	Stock	42.9	42.925	42.88	42.925	3404.0
2019-02-22 06:00:00	AAPL	Stock	42.96	43.0	42.8925	43.0	25944.0
2019-02-22 07:00:00	AAPL	Stock	42.975	43.0325	42.9425	42.9425	54032.0
2019-02-22 08:00:00	AAPL	Stock	43.0	43.0	42.82	42.8525	207732.0
2019-02-22 09:00:00	AAPL	Stock	42.85	43.085	42.8375	43.0462	9168112.0
2019-02-22 10:00:00	AAPL	Stock	43.0462	43.155	42.9198	43.1525	10054156.0
2019-02-22 11:00:00	AAPL	Stock	43.1512	43.17	43.0175	43.0612	7081044.0
2019-02-22 12:00:00	AAPL	Stock	43.06	43.095	43.01	43.055	3977388.0
2019-02-22 13:00:00	AAPL	Stock	43.0575	43.1125	43.01	43.1125	4509848.0
2019-02-22 14:00:00	AAPL	Stock	43.1108	43.145	42.9625	42.995	6902584.0
2019-02-22 15:00:00	AAPL	Stock	42.9925	43.25	42.9725	43.2425	11702152.0
2019-02-22 16:00:00	AAPL	Stock	43.2475	43.27	43.0845	43.185	12432488.0
2019-02-22 17:00:00	AAPL	Stock	43.185	43.22	43.175	43.1875	70468.0
2019-02-22 18:00:00	AAPL	Stock	43.2175	43.2175	43.19	43.205	17600.0
2019-02-22 19:00:00	AAPL	Stock	43.205	43.23	43.19	43.19	54452.0
2019-02-22 04:00:00	MSFT	Stock	109.41	109.7	109.41	109.42	6875.0
2019-02-22 05:00:00	MSFT	Stock	109.55	109.66	109.5	109.66	1898.0
2019-02-22 06:00:00	MSFT	Stock	109.6	109.93	109.6	109.93	5724.0
2019-02-22 07:00:00	MSFT	Stock	109.76	109.99	109.73	109.9	17492.0
2019-02-22 08:00:00	MSFT	Stock	109.91	109.99	109.63	109.73	34019.0
2019-02-22 09:00:00	MSFT	Stock	109.746	110.82	109.6	110.82	3482177.0
2019-02-22 10:00:00	MSFT	Stock	110.82	111.1	110.48	110.86	4233788.0
2019-02-22 11:00:00	MSFT	Stock	110.855	111.2	110.67	111.06	3059474.0
2019-02-22 12:00:00	MSFT	Stock	111.06	111.07	110.73	110.91	1631450.0
2019-02-22 13:00:00	MSFT	Stock	110.91	111.04	110.74	111.01	1863951.0
2019-02-22 14:00:00	MSFT	Stock	111.012	111.19	110.49	110.515	2543162.0
2019-02-22 15:00:00	MSFT	Stock	110.51	111.0	110.46	110.965	4497406.0
2019-02-22 16:00:00	MSFT	Stock	110.97	110.97	110.64	110.89	3220047.0
2019-02-22 17:00:00	MSFT	Stock	110.89	110.96	110.88	110.96	8021.0
2019-02-22 18:00:00	MSFT	Stock	110.95	110.95	110.87	110.94	3765.0
2019-02-22 19:00:00	MSFT	Stock	110.87	110.95	110.87	110.95	10070.0
2019-02-22 04:00:00	NVDA	Stock	3.9115	3.9115	3.9115	3.9115	4000.0
2019-02-22 05:00:00	NVDA	Stock	3.9238	3.925	3.9238	3.925	12000.0
2019-02-22 06:00:00	NVDA	Stock	3.9488	3.9488	3.9488	3.9488	22960.0
2019-02-22 07:00:00	NVDA	Stock	3.9355	3.956	3.9228	3.945	1313480.0
2019-02-22 08:00:00	NVDA	Stock	3.9425	3.9485	3.925	3.9348	1388600.0
2019-02-22 09:00:00	NVDA	Stock	3.9312	3.993	3.9312	3.9913	92945760.0
2019-02-22 10:00:00	NVDA	Stock	3.9913	3.9988	3.9705	3.9805	75007800.0
2019-02-22 11:00:00	NVDA	Stock	3.981	3.995	3.9725	3.9792	45821560.0
2019-02-22 12:00:00	NVDA	Stock	3.9792	3.9925	3.9758	3.9792	27962920.0
2019-02-22 13:00:00	NVDA	Stock	3.9792	3.9818	3.9612	3.9742	24794200.0
2019-02-22 14:00:00	NVDA	Stock	3.9742	3.978	3.9424	3.9555	38891880.0
2019-02-22 15:00:00	NVDA	Stock	3.9558	3.9805	3.9522	3.9805	60953440.0
2019-02-22 16:00:00	NVDA	Stock	3.9798	3.9842	3.975	3.9842	4417440.0
2019-02-22 17:00:00	NVDA	Stock	3.9845	3.9922	3.98	3.9852	955160.0
2019-02-22 18:00:00	NVDA	Stock	3.9858	3.9913	3.9858	3.9885	318320.0
2019-02-22 19:00:00	NVDA	Stock	3.9913	3.9922	3.9858	3.9922	546520.0
2019-02-22 04:00:00	AMZN	Stock	81.0	81.0	81.0	81.0	2000.0
2019-02-22 05:00:00	AMZN	Stock	81.3	81.3	81.3	81.3	2000.0

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

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