PREVIEW / stock_1hour / 2020-11-10

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-11-10.parquet
  size:    1.3 MB
  rows:    59,389
  symbols: 2,528

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-11-10 04:00:00	AAPL	Stock	116.84	117.0	115.55	115.84	188667.0
2020-11-10 05:00:00	AAPL	Stock	115.84	115.96	114.02	114.02	154546.0
2020-11-10 06:00:00	AAPL	Stock	114.02	115.09	114.0	114.95	129500.0
2020-11-10 07:00:00	AAPL	Stock	115.05	115.7	114.72	114.81	666318.0
2020-11-10 08:00:00	AAPL	Stock	114.9	115.7	114.5	115.43	899733.0
2020-11-10 09:00:00	AAPL	Stock	115.4	117.59	115.179	115.805	15502004.0
2020-11-10 10:00:00	AAPL	Stock	115.8	116.94	114.13	115.0	19177091.0
2020-11-10 11:00:00	AAPL	Stock	115.0	117.33	114.9	116.674	14130427.0
2020-11-10 12:00:00	AAPL	Stock	116.678	117.47	115.81	116.92	12572622.0
2020-11-10 13:00:00	AAPL	Stock	116.93	117.59	115.88	116.87	14711170.0
2020-11-10 14:00:00	AAPL	Stock	116.85	117.29	115.99	116.75	15221781.0
2020-11-10 15:00:00	AAPL	Stock	116.74	117.018	115.73	115.97	17222384.0
2020-11-10 16:00:00	AAPL	Stock	115.97	116.913	115.95	116.06	9654769.0
2020-11-10 17:00:00	AAPL	Stock	116.04	116.13	115.99	116.04	70051.0
2020-11-10 18:00:00	AAPL	Stock	116.03	116.24	115.9	115.94	205347.0
2020-11-10 19:00:00	AAPL	Stock	115.95	116.08	115.68	116.05	171152.0
2020-11-10 04:00:00	MSFT	Stock	218.0	218.0	215.69	216.5	19700.0
2020-11-10 05:00:00	MSFT	Stock	216.67	216.7	214.12	214.29	32470.0
2020-11-10 06:00:00	MSFT	Stock	214.05	215.0	213.9	214.54	29364.0
2020-11-10 07:00:00	MSFT	Stock	214.55	215.33	213.58	213.9	117148.0
2020-11-10 08:00:00	MSFT	Stock	214.343	215.4	213.8	215.11	124793.0
2020-11-10 09:00:00	MSFT	Stock	215.1	216.5	212.9	213.904	4176618.0
2020-11-10 10:00:00	MSFT	Stock	213.945	214.59	210.3	211.21	6055221.0
2020-11-10 11:00:00	MSFT	Stock	211.195	213.21	210.74	211.08	4147674.0
2020-11-10 12:00:00	MSFT	Stock	211.088	213.2	211.04	212.43	2935020.0
2020-11-10 13:00:00	MSFT	Stock	212.47	212.95	210.32	211.73	3037115.0
2020-11-10 14:00:00	MSFT	Stock	211.7	212.31	209.85	210.11	4622365.0
2020-11-10 15:00:00	MSFT	Stock	210.1	211.28	209.72	211.02	5195258.0
2020-11-10 16:00:00	MSFT	Stock	211.01	211.45	211.01	211.15	3396717.0
2020-11-10 17:00:00	MSFT	Stock	211.2	211.39	211.15	211.29	10289.0
2020-11-10 18:00:00	MSFT	Stock	211.27	211.4	210.8	210.8	25452.0
2020-11-10 19:00:00	MSFT	Stock	210.8	211.1	210.52	211.01	28824.0
2020-11-10 04:00:00	NVDA	Stock	13.7	13.7248	13.55	13.55	504880.0
2020-11-10 05:00:00	NVDA	Stock	13.5002	13.5125	13.2752	13.2752	301000.0
2020-11-10 06:00:00	NVDA	Stock	13.2688	13.3975	13.2688	13.3975	147080.0
2020-11-10 07:00:00	NVDA	Stock	13.415	13.52	13.3562	13.3778	2199160.0
2020-11-10 08:00:00	NVDA	Stock	13.4051	13.5	13.355	13.4972	2719880.0
2020-11-10 09:00:00	NVDA	Stock	13.463	13.6068	12.9778	13.0852	85070080.0
2020-11-10 10:00:00	NVDA	Stock	13.0827	13.086	12.6283	12.823	94784920.0
2020-11-10 11:00:00	NVDA	Stock	12.8235	13.14	12.8065	13.0148	69599920.0
2020-11-10 12:00:00	NVDA	Stock	13.021	13.1916	12.9262	12.9368	51401880.0
2020-11-10 13:00:00	NVDA	Stock	12.9375	12.9933	12.79	12.8586	50631320.0
2020-11-10 14:00:00	NVDA	Stock	12.8618	12.922	12.7495	12.8508	40445960.0
2020-11-10 15:00:00	NVDA	Stock	12.8442	12.8903	12.7025	12.7638	65360880.0
2020-11-10 16:00:00	NVDA	Stock	12.77	12.8526	12.77	12.7825	19930080.0
2020-11-10 17:00:00	NVDA	Stock	12.7838	12.7875	12.7768	12.777	183200.0
2020-11-10 18:00:00	NVDA	Stock	12.7875	12.8145	12.7675	12.7675	927160.0
2020-11-10 19:00:00	NVDA	Stock	12.775	12.7778	12.7038	12.7745	839040.0
2020-11-10 04:00:00	AMZN	Stock	157.0	157.25	156.7	156.7	33180.0
2020-11-10 05:00:00	AMZN	Stock	156.15	156.15	154.8805	154.8805	78440.0

> showing 50 of 59,389 rows — these rows as CSV

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