PREVIEW / stock_1hour / 2020-10-22

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-10-22.parquet
  size:    1.3 MB
  rows:    57,481
  symbols: 2,519

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-10-22 04:00:00	AAPL	Stock	116.0	116.7	116.0	116.31	49125.0
2020-10-22 05:00:00	AAPL	Stock	116.32	116.47	116.31	116.47	15366.0
2020-10-22 06:00:00	AAPL	Stock	116.32	117.12	116.2	116.91	50195.0
2020-10-22 07:00:00	AAPL	Stock	116.93	117.05	116.69	116.98	270396.0
2020-10-22 08:00:00	AAPL	Stock	116.68	117.58	116.68	117.29	830960.0
2020-10-22 09:00:00	AAPL	Stock	117.29	118.04	117.15	117.275	10331878.0
2020-10-22 10:00:00	AAPL	Stock	117.27	117.37	114.59	115.61	21760844.0
2020-10-22 11:00:00	AAPL	Stock	115.6	116.1	115.32	115.39	13704085.0
2020-10-22 12:00:00	AAPL	Stock	115.4	115.74	114.97	115.64	10585905.0
2020-10-22 13:00:00	AAPL	Stock	115.63	116.125	115.38	115.538	9994482.0
2020-10-22 14:00:00	AAPL	Stock	115.535	115.93	115.32	115.82	7255314.0
2020-10-22 15:00:00	AAPL	Stock	115.82	116.34	115.5	115.774	12991691.0
2020-10-22 16:00:00	AAPL	Stock	115.75	115.98	115.6	115.8	5352717.0
2020-10-22 17:00:00	AAPL	Stock	115.79	115.94	115.79	115.93	109825.0
2020-10-22 18:00:00	AAPL	Stock	115.93	116.23	115.91	116.05	164770.0
2020-10-22 19:00:00	AAPL	Stock	116.05	116.1	115.84	116.1	150094.0
2020-10-22 04:00:00	MSFT	Stock	214.28	214.28	214.28	214.28	1150.0
2020-10-22 05:00:00	MSFT	Stock	214.58	214.68	214.58	214.68	380.0
2020-10-22 06:00:00	MSFT	Stock	214.31	214.69	214.0	214.28	5798.0
2020-10-22 07:00:00	MSFT	Stock	214.04	214.66	214.01	214.25	23919.0
2020-10-22 08:00:00	MSFT	Stock	214.51	214.7	213.52	214.1	82922.0
2020-10-22 09:00:00	MSFT	Stock	214.22	216.055	213.9	214.257	2408800.0
2020-10-22 10:00:00	MSFT	Stock	214.24	214.354	211.7	212.83	3016566.0
2020-10-22 11:00:00	MSFT	Stock	212.8	213.85	212.27	213.12	1773756.0
2020-10-22 12:00:00	MSFT	Stock	213.16	213.81	212.16	213.72	1525847.0
2020-10-22 13:00:00	MSFT	Stock	213.72	215.15	213.51	214.92	1728472.0
2020-10-22 14:00:00	MSFT	Stock	214.915	215.36	214.6	215.04	1282689.0
2020-10-22 15:00:00	MSFT	Stock	215.06	215.69	214.31	214.84	2663624.0
2020-10-22 16:00:00	MSFT	Stock	214.89	214.89	214.42	214.8	2369092.0
2020-10-22 17:00:00	MSFT	Stock	214.6	214.85	214.6	214.85	6521.0
2020-10-22 18:00:00	MSFT	Stock	214.88	215.39	214.88	215.2	14466.0
2020-10-22 19:00:00	MSFT	Stock	215.3	215.3	214.81	215.2	4732.0
2020-10-22 04:00:00	NVDA	Stock	13.496	13.4978	13.496	13.4978	51560.0
2020-10-22 05:00:00	NVDA	Stock	13.475	13.475	13.475	13.475	24200.0
2020-10-22 06:00:00	NVDA	Stock	13.4742	13.4742	13.45	13.45	13120.0
2020-10-22 07:00:00	NVDA	Stock	13.515	13.55	13.5125	13.535	230080.0
2020-10-22 08:00:00	NVDA	Stock	13.517	13.5585	13.5	13.5075	407920.0
2020-10-22 09:00:00	NVDA	Stock	13.5075	13.6118	13.495	13.5925	24673080.0
2020-10-22 10:00:00	NVDA	Stock	13.59	13.61	13.2578	13.3198	44368120.0
2020-10-22 11:00:00	NVDA	Stock	13.3175	13.3945	13.2875	13.3406	32337520.0
2020-10-22 12:00:00	NVDA	Stock	13.337	13.3545	13.2318	13.3206	23819200.0
2020-10-22 13:00:00	NVDA	Stock	13.3182	13.4348	13.3032	13.4129	29683680.0
2020-10-22 14:00:00	NVDA	Stock	13.417	13.434	13.3393	13.3595	19640440.0
2020-10-22 15:00:00	NVDA	Stock	13.3572	13.3993	13.325	13.3622	41457120.0
2020-10-22 16:00:00	NVDA	Stock	13.361	13.3875	13.25	13.3625	6317760.0
2020-10-22 17:00:00	NVDA	Stock	13.35	13.3668	13.35	13.3668	24600.0
2020-10-22 18:00:00	NVDA	Stock	13.3668	13.4102	13.3668	13.4102	188760.0
2020-10-22 19:00:00	NVDA	Stock	13.4	13.4	13.37	13.4	242480.0
2020-10-22 04:00:00	AMZN	Stock	158.8	158.8	158.5	158.5	4000.0
2020-10-22 07:00:00	AMZN	Stock	159.375	159.75	159.375	159.75	40760.0

> showing 50 of 57,481 rows — these rows as CSV

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