PREVIEW / stock_1hour / 2020-05-13

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-05-13.parquet
  size:    1.2 MB
  rows:    54,916
  symbols: 2,388

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
2020-05-13 04:00:00	AAPL	Stock	77.7525	78.2475	77.6875	77.975	52532.0
2020-05-13 05:00:00	AAPL	Stock	78.025	78.27	77.9775	78.27	29920.0
2020-05-13 06:00:00	AAPL	Stock	78.21	78.2975	78.1475	78.2475	50124.0
2020-05-13 07:00:00	AAPL	Stock	78.165	78.5	78.0175	78.45	379808.0
2020-05-13 08:00:00	AAPL	Stock	78.125	78.5	78.005	78.3275	771376.0
2020-05-13 09:00:00	AAPL	Stock	78.32	78.3725	77.5275	78.3075	21744924.0
2020-05-13 10:00:00	AAPL	Stock	78.3	78.9875	78.1495	78.2192	25086136.0
2020-05-13 11:00:00	AAPL	Stock	78.22	78.5982	77.195	77.315	24845568.0
2020-05-13 12:00:00	AAPL	Stock	77.3165	77.335	75.8025	76.805	29933184.0
2020-05-13 13:00:00	AAPL	Stock	76.8	76.8475	76.1325	76.1775	14797880.0
2020-05-13 14:00:00	AAPL	Stock	76.1775	76.725	75.9275	75.9362	14404268.0
2020-05-13 15:00:00	AAPL	Stock	75.9342	77.1	75.8188	76.92	26828796.0
2020-05-13 16:00:00	AAPL	Stock	76.9125	77.1	76.9	77.065	8169072.0
2020-05-13 17:00:00	AAPL	Stock	77.065	77.195	77.0475	77.195	103536.0
2020-05-13 18:00:00	AAPL	Stock	77.1925	77.2425	77.135	77.1875	78840.0
2020-05-13 19:00:00	AAPL	Stock	77.2225	77.37	77.0625	77.125	128472.0
2020-05-13 04:00:00	MSFT	Stock	182.36	183.48	182.07	182.67	12262.0
2020-05-13 05:00:00	MSFT	Stock	182.71	183.67	182.71	183.61	3635.0
2020-05-13 06:00:00	MSFT	Stock	183.65	184.27	183.6	183.89	11930.0
2020-05-13 07:00:00	MSFT	Stock	183.6	184.0	183.16	183.86	54103.0
2020-05-13 08:00:00	MSFT	Stock	183.358	184.0	183.15	183.499	72380.0
2020-05-13 09:00:00	MSFT	Stock	183.32	183.5	180.22	181.97	4519199.0
2020-05-13 10:00:00	MSFT	Stock	181.97	184.05	181.88	182.15	4711067.0
2020-05-13 11:00:00	MSFT	Stock	182.19	182.86	179.035	179.4	4797449.0
2020-05-13 12:00:00	MSFT	Stock	179.39	179.88	176.54	179.55	6899277.0
2020-05-13 13:00:00	MSFT	Stock	179.55	179.66	178.0	178.32	2844236.0
2020-05-13 14:00:00	MSFT	Stock	178.34	179.48	177.89	177.905	3001145.0
2020-05-13 15:00:00	MSFT	Stock	177.91	180.22	177.465	179.78	6581461.0
2020-05-13 16:00:00	MSFT	Stock	179.75	181.305	179.6	180.2	4740370.0
2020-05-13 17:00:00	MSFT	Stock	180.07	180.35	180.0	180.34	23009.0
2020-05-13 18:00:00	MSFT	Stock	180.3	180.75	180.0	180.3	27782.0
2020-05-13 19:00:00	MSFT	Stock	180.4	180.94	180.3	180.55	27897.0
2020-05-13 04:00:00	NVDA	Stock	7.8015	7.8625	7.8015	7.844	98320.0
2020-05-13 05:00:00	NVDA	Stock	7.8392	7.85	7.8392	7.85	30160.0
2020-05-13 06:00:00	NVDA	Stock	7.85	7.863	7.85	7.8552	173760.0
2020-05-13 07:00:00	NVDA	Stock	7.8662	7.9498	7.8493	7.9498	2017880.0
2020-05-13 08:00:00	NVDA	Stock	7.8863	7.9498	7.8493	7.92	3575240.0
2020-05-13 09:00:00	NVDA	Stock	7.9125	7.9778	7.7832	7.9668	99524240.0
2020-05-13 10:00:00	NVDA	Stock	7.965	8.0785	7.9515	7.9552	117514840.0
2020-05-13 11:00:00	NVDA	Stock	7.9565	8.0032	7.753	7.7888	119726520.0
2020-05-13 12:00:00	NVDA	Stock	7.7909	7.8062	7.5948	7.7366	90330480.0
2020-05-13 13:00:00	NVDA	Stock	7.7375	7.7425	7.6463	7.6515	41003560.0
2020-05-13 14:00:00	NVDA	Stock	7.6472	7.7375	7.625	7.6683	35730080.0
2020-05-13 15:00:00	NVDA	Stock	7.6658	7.7955	7.625	7.7805	63248280.0
2020-05-13 16:00:00	NVDA	Stock	7.78	7.9092	7.78	7.8025	12759680.0
2020-05-13 17:00:00	NVDA	Stock	7.805	7.8225	7.8	7.8225	548320.0
2020-05-13 18:00:00	NVDA	Stock	7.8225	7.8975	7.8142	7.875	1970720.0
2020-05-13 19:00:00	NVDA	Stock	7.8835	7.8925	7.875	7.8848	521000.0
2020-05-13 04:00:00	AMZN	Stock	118.0685	118.0685	118.05	118.05	27620.0
2020-05-13 05:00:00	AMZN	Stock	118.0685	118.0685	118.0685	118.0685	18100.0

> showing 50 of 54,916 rows — these rows as CSV

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