PREVIEW / stock_1hour / 2019-06-21

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-06-21.parquet
  size:    1.1 MB
  rows:    50,300
  symbols: 2,597

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-06-21 04:00:00	AAPL	Stock	49.6875	49.6875	49.565	49.675	9168.0
2019-06-21 05:00:00	AAPL	Stock	49.625	49.655	49.625	49.655	5720.0
2019-06-21 06:00:00	AAPL	Stock	49.5375	49.5725	49.5	49.5725	11328.0
2019-06-21 07:00:00	AAPL	Stock	49.5525	49.675	49.465	49.515	186552.0
2019-06-21 08:00:00	AAPL	Stock	49.515	49.6625	49.4375	49.6225	253552.0
2019-06-21 09:00:00	AAPL	Stock	49.625	49.8325	49.5375	49.7625	27246828.0
2019-06-21 10:00:00	AAPL	Stock	49.7625	50.0625	49.7575	49.97	11103040.0
2019-06-21 11:00:00	AAPL	Stock	49.975	50.185	49.9275	49.9825	9545724.0
2019-06-21 12:00:00	AAPL	Stock	49.98	50.1125	49.9025	50.1015	6342600.0
2019-06-21 13:00:00	AAPL	Stock	50.1018	50.2125	50.0575	50.12	6173464.0
2019-06-21 14:00:00	AAPL	Stock	50.1175	50.1525	49.96	49.9725	5869972.0
2019-06-21 15:00:00	AAPL	Stock	49.975	50.0175	49.6575	49.7	17132364.0
2019-06-21 16:00:00	AAPL	Stock	49.695	49.7375	49.565	49.6625	62891068.0
2019-06-21 17:00:00	AAPL	Stock	49.64	49.695	49.625	49.625	526548.0
2019-06-21 18:00:00	AAPL	Stock	49.625	49.65	49.5625	49.5825	30464.0
2019-06-21 19:00:00	AAPL	Stock	49.61	49.6175	49.45	49.525	50516.0
2019-06-21 05:00:00	MSFT	Stock	136.78	136.92	136.78	136.92	500.0
2019-06-21 07:00:00	MSFT	Stock	136.55	136.62	136.32	136.59	12734.0
2019-06-21 08:00:00	MSFT	Stock	136.619	137.29	135.3	135.92	129987.0
2019-06-21 09:00:00	MSFT	Stock	135.8	136.99	135.8	136.99	9290433.0
2019-06-21 10:00:00	MSFT	Stock	137.0	137.47	136.8	137.18	3267199.0
2019-06-21 11:00:00	MSFT	Stock	137.19	137.73	137.12	137.245	2574022.0
2019-06-21 12:00:00	MSFT	Stock	137.24	137.38	136.92	137.19	1355936.0
2019-06-21 13:00:00	MSFT	Stock	137.2	137.35	136.93	137.0	1446269.0
2019-06-21 14:00:00	MSFT	Stock	137.0	137.16	136.72	137.06	1594992.0
2019-06-21 15:00:00	MSFT	Stock	137.06	137.35	136.87	136.94	3353180.0
2019-06-21 16:00:00	MSFT	Stock	136.95	137.09	136.71	136.99	7051957.0
2019-06-21 17:00:00	MSFT	Stock	136.99	136.99	136.9	136.97	194392.0
2019-06-21 18:00:00	MSFT	Stock	136.9	136.9	136.81	136.81	1887.0
2019-06-21 19:00:00	MSFT	Stock	136.89	136.89	136.7	136.71	1213.0
2019-06-21 04:00:00	NVDA	Stock	3.8525	3.8525	3.8525	3.8525	11000.0
2019-06-21 06:00:00	NVDA	Stock	3.8545	3.855	3.85	3.85	92000.0
2019-06-21 07:00:00	NVDA	Stock	3.85	3.8518	3.8455	3.8455	396840.0
2019-06-21 08:00:00	NVDA	Stock	3.8438	3.862	3.8375	3.8475	1224960.0
2019-06-21 09:00:00	NVDA	Stock	3.8475	3.8522	3.8002	3.8375	70658800.0
2019-06-21 10:00:00	NVDA	Stock	3.8361	3.885	3.8255	3.8715	49698080.0
2019-06-21 11:00:00	NVDA	Stock	3.8725	3.887	3.819	3.826	55965120.0
2019-06-21 12:00:00	NVDA	Stock	3.8258	3.829	3.8062	3.8163	37735080.0
2019-06-21 13:00:00	NVDA	Stock	3.8162	3.8175	3.795	3.8002	28309200.0
2019-06-21 14:00:00	NVDA	Stock	3.801	3.8035	3.7875	3.7915	28721200.0
2019-06-21 15:00:00	NVDA	Stock	3.7922	3.805	3.7898	3.794	61329160.0
2019-06-21 16:00:00	NVDA	Stock	3.794	3.794	3.785	3.785	62543000.0
2019-06-21 17:00:00	NVDA	Stock	3.79	3.794	3.785	3.7908	1141680.0
2019-06-21 18:00:00	NVDA	Stock	3.7872	3.7878	3.7825	3.7825	199760.0
2019-06-21 19:00:00	NVDA	Stock	3.7875	3.7875	3.7835	3.7875	67200.0
2019-06-21 04:00:00	AMZN	Stock	95.4345	95.621	95.4345	95.621	12000.0
2019-06-21 06:00:00	AMZN	Stock	95.475	95.475	95.0505	95.0505	18920.0
2019-06-21 07:00:00	AMZN	Stock	95.427	95.427	95.3	95.3575	55840.0
2019-06-21 08:00:00	AMZN	Stock	95.3676	96.149	95.3	95.45	142700.0
2019-06-21 09:00:00	AMZN	Stock	95.4225	95.926	95.4	95.7296	15768840.0

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

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