PREVIEW / stock_1hour / 2020-05-12

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-05-12.parquet
  size:    1.2 MB
  rows:    55,254
  symbols: 2,373

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-12 04:00:00	AAPL	Stock	78.8025	78.8025	78.56	78.63	18924.0
2020-05-12 05:00:00	AAPL	Stock	78.6	78.75	78.5025	78.7175	16884.0
2020-05-12 06:00:00	AAPL	Stock	78.7475	79.0375	78.7475	78.9	32704.0
2020-05-12 07:00:00	AAPL	Stock	78.995	79.4975	78.995	79.3725	494948.0
2020-05-12 08:00:00	AAPL	Stock	79.375	79.4975	79.0	79.36	565564.0
2020-05-12 09:00:00	AAPL	Stock	79.375	79.775	78.9375	79.38	24779848.0
2020-05-12 10:00:00	AAPL	Stock	79.38	79.6	79.02	79.5512	17120556.0
2020-05-12 11:00:00	AAPL	Stock	79.555	79.7825	79.4075	79.5923	11389556.0
2020-05-12 12:00:00	AAPL	Stock	79.5975	79.922	79.495	79.84	10544000.0
2020-05-12 13:00:00	AAPL	Stock	79.8372	79.8525	79.085	79.6075	14260188.0
2020-05-12 14:00:00	AAPL	Stock	79.615	79.6275	79.0725	79.3175	11922360.0
2020-05-12 15:00:00	AAPL	Stock	79.3125	79.375	77.7275	77.835	29790024.0
2020-05-12 16:00:00	AAPL	Stock	77.8358	79.1002	77.275	77.275	10558268.0
2020-05-12 17:00:00	AAPL	Stock	77.3125	77.49	77.15	77.4375	393396.0
2020-05-12 18:00:00	AAPL	Stock	77.4375	77.625	77.3	77.3875	298344.0
2020-05-12 19:00:00	AAPL	Stock	77.365	77.435	77.25	77.25	377940.0
2020-05-12 04:00:00	MSFT	Stock	186.04	186.48	186.04	186.48	225.0
2020-05-12 05:00:00	MSFT	Stock	186.21	186.3	186.07	186.3	1464.0
2020-05-12 06:00:00	MSFT	Stock	186.69	186.9	186.69	186.9	200.0
2020-05-12 07:00:00	MSFT	Stock	187.4	187.49	186.76	187.24	31991.0
2020-05-12 08:00:00	MSFT	Stock	186.9	187.49	186.74	187.35	141085.0
2020-05-12 09:00:00	MSFT	Stock	187.37	187.45	185.09	185.82	4333805.0
2020-05-12 10:00:00	MSFT	Stock	185.84	186.55	185.25	186.37	3467840.0
2020-05-12 11:00:00	MSFT	Stock	186.42	187.04	186.05	186.48	2091091.0
2020-05-12 12:00:00	MSFT	Stock	186.49	186.94	186.44	186.8	1680226.0
2020-05-12 13:00:00	MSFT	Stock	186.79	186.82	185.5	186.17	2006962.0
2020-05-12 14:00:00	MSFT	Stock	186.15	186.17	185.19	185.96	2143137.0
2020-05-12 15:00:00	MSFT	Stock	185.95	186.038	182.3	182.31	6937684.0
2020-05-12 16:00:00	MSFT	Stock	182.51	185.47	181.0	181.12	4844876.0
2020-05-12 17:00:00	MSFT	Stock	181.1	181.7	180.6	181.45	53257.0
2020-05-12 18:00:00	MSFT	Stock	181.37	181.99	181.03	181.12	25530.0
2020-05-12 19:00:00	MSFT	Stock	181.13	181.37	180.2	180.6	46621.0
2020-05-12 04:00:00	NVDA	Stock	8.05	8.0573	8.0168	8.0573	183760.0
2020-05-12 05:00:00	NVDA	Stock	8.0435	8.0492	8.036	8.0492	212760.0
2020-05-12 06:00:00	NVDA	Stock	8.061	8.097	8.061	8.0812	112920.0
2020-05-12 07:00:00	NVDA	Stock	8.0865	8.1375	8.0843	8.1285	889920.0
2020-05-12 08:00:00	NVDA	Stock	8.0998	8.1513	8.0998	8.1475	2133920.0
2020-05-12 09:00:00	NVDA	Stock	8.1462	8.1725	7.9555	7.9963	87064920.0
2020-05-12 10:00:00	NVDA	Stock	7.9936	8.12	7.9842	8.1005	70356880.0
2020-05-12 11:00:00	NVDA	Stock	8.1005	8.1342	8.0678	8.0898	27654040.0
2020-05-12 12:00:00	NVDA	Stock	8.0908	8.142	8.0688	8.1351	21284840.0
2020-05-12 13:00:00	NVDA	Stock	8.1355	8.141	8.0158	8.09	43267240.0
2020-05-12 14:00:00	NVDA	Stock	8.0903	8.0948	8.0102	8.0398	32042600.0
2020-05-12 15:00:00	NVDA	Stock	8.0391	8.0435	7.7928	7.7938	95135720.0
2020-05-12 16:00:00	NVDA	Stock	7.7965	8.018	7.7255	7.735	16727000.0
2020-05-12 17:00:00	NVDA	Stock	7.7275	7.7688	7.7255	7.7648	652960.0
2020-05-12 18:00:00	NVDA	Stock	7.75	7.8048	7.7455	7.7768	726840.0
2020-05-12 19:00:00	NVDA	Stock	7.775	7.775	7.725	7.725	634840.0
2020-05-12 07:00:00	AMZN	Stock	120.4915	120.8415	120.4	120.8415	54320.0
2020-05-12 08:00:00	AMZN	Stock	120.5	120.8495	120.149	120.749	122000.0

> showing 50 of 55,254 rows — these rows as CSV

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