PREVIEW / stock_1hour / 2020-03-10

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-03-10.parquet
  size:    1.2 MB
  rows:    54,291
  symbols: 2,431

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-03-10 04:00:00	AAPL	Stock	68.85	69.75	68.605	69.75	110948.0
2020-03-10 05:00:00	AAPL	Stock	69.755	70.4775	69.6925	70.0125	151196.0
2020-03-10 06:00:00	AAPL	Stock	70.085	70.235	69.795	70.1275	108288.0
2020-03-10 07:00:00	AAPL	Stock	70.195	70.2375	69.4475	69.6025	567024.0
2020-03-10 08:00:00	AAPL	Stock	69.625	70.175	68.6875	69.2175	1708240.0
2020-03-10 09:00:00	AAPL	Stock	69.175	70.09	68.73	69.8	30227864.0
2020-03-10 10:00:00	AAPL	Stock	69.7975	70.4575	68.7375	68.7942	35691868.0
2020-03-10 11:00:00	AAPL	Stock	68.7875	69.3525	67.3425	68.1675	37608596.0
2020-03-10 12:00:00	AAPL	Stock	68.1775	69.5898	68.175	69.0178	26959400.0
2020-03-10 13:00:00	AAPL	Stock	69.0075	69.5725	68.3125	68.5275	18398956.0
2020-03-10 14:00:00	AAPL	Stock	68.5225	69.79	68.0825	69.561	21725160.0
2020-03-10 15:00:00	AAPL	Stock	69.575	71.61	69.475	71.4225	41816948.0
2020-03-10 16:00:00	AAPL	Stock	71.42	71.42	70.935	71.0775	17612444.0
2020-03-10 17:00:00	AAPL	Stock	71.12	71.1375	70.6675	70.725	263476.0
2020-03-10 18:00:00	AAPL	Stock	70.74	71.335	69.9125	70.09	341372.0
2020-03-10 19:00:00	AAPL	Stock	70.075	70.22	69.525	69.875	223248.0
2020-03-10 04:00:00	MSFT	Stock	156.0	157.45	155.48	157.45	17888.0
2020-03-10 05:00:00	MSFT	Stock	157.5	159.56	157.43	159.13	19587.0
2020-03-10 06:00:00	MSFT	Stock	159.43	159.75	158.76	159.35	39216.0
2020-03-10 07:00:00	MSFT	Stock	159.36	159.56	158.0	158.6	108961.0
2020-03-10 08:00:00	MSFT	Stock	158.52	159.5	155.48	157.5	221537.0
2020-03-10 09:00:00	MSFT	Stock	157.2	158.31	155.38	156.86	6375986.0
2020-03-10 10:00:00	MSFT	Stock	156.84	159.01	154.77	154.79	6983723.0
2020-03-10 11:00:00	MSFT	Stock	154.78	156.19	152.58	153.94	6904387.0
2020-03-10 12:00:00	MSFT	Stock	153.95	156.94	153.95	155.69	4780783.0
2020-03-10 13:00:00	MSFT	Stock	155.71	157.06	154.08	154.59	5000949.0
2020-03-10 14:00:00	MSFT	Stock	154.635	158.07	153.41	157.21	5396906.0
2020-03-10 15:00:00	MSFT	Stock	157.21	161.03	156.795	161.03	11986065.0
2020-03-10 16:00:00	MSFT	Stock	161.03	161.2	159.9	160.25	8372638.0
2020-03-10 17:00:00	MSFT	Stock	160.25	160.58	157.359	159.6	26908.0
2020-03-10 18:00:00	MSFT	Stock	159.71	159.9	158.0	158.49	46298.0
2020-03-10 19:00:00	MSFT	Stock	158.49	158.5	157.5	158.3	40184.0
2020-03-10 04:00:00	NVDA	Stock	6.375	6.475	6.375	6.475	235960.0
2020-03-10 05:00:00	NVDA	Stock	6.4675	6.5063	6.4675	6.5025	275240.0
2020-03-10 06:00:00	NVDA	Stock	6.4882	6.5025	6.474	6.5025	229120.0
2020-03-10 07:00:00	NVDA	Stock	6.4975	6.5125	6.4405	6.4653	1009800.0
2020-03-10 08:00:00	NVDA	Stock	6.4933	6.5125	6.3628	6.395	4331200.0
2020-03-10 09:00:00	NVDA	Stock	6.395	6.4558	6.3	6.3443	70989800.0
2020-03-10 10:00:00	NVDA	Stock	6.3474	6.4638	6.2593	6.27	78366640.0
2020-03-10 11:00:00	NVDA	Stock	6.2703	6.3346	6.1498	6.2312	81163920.0
2020-03-10 12:00:00	NVDA	Stock	6.234	6.3568	6.23	6.281	44175040.0
2020-03-10 13:00:00	NVDA	Stock	6.2811	6.3502	6.2458	6.2779	37866200.0
2020-03-10 14:00:00	NVDA	Stock	6.2808	6.4238	6.2522	6.4092	52239800.0
2020-03-10 15:00:00	NVDA	Stock	6.4095	6.527	6.3972	6.527	100321880.0
2020-03-10 16:00:00	NVDA	Stock	6.527	6.532	6.4875	6.5005	4956720.0
2020-03-10 17:00:00	NVDA	Stock	6.4975	6.5125	6.4725	6.4725	310280.0
2020-03-10 18:00:00	NVDA	Stock	6.4725	6.475	6.425	6.425	266320.0
2020-03-10 19:00:00	NVDA	Stock	6.425	6.4252	6.375	6.38	854520.0
2020-03-10 04:00:00	AMZN	Stock	93.2825	93.755	92.5	93.755	45980.0
2020-03-10 05:00:00	AMZN	Stock	93.9385	94.4995	93.75	94.4995	21500.0

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

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