PREVIEW / stock_1hour / 2020-06-09

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-06-09.parquet
  size:    1.3 MB
  rows:    58,262
  symbols: 2,415

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-06-09 04:00:00	AAPL	Stock	82.9	82.9	82.25	82.6	47432.0
2020-06-09 05:00:00	AAPL	Stock	82.625	82.7125	82.625	82.7125	13676.0
2020-06-09 06:00:00	AAPL	Stock	82.715	82.825	82.6175	82.825	13296.0
2020-06-09 07:00:00	AAPL	Stock	82.785	82.96	82.7125	82.855	110476.0
2020-06-09 08:00:00	AAPL	Stock	82.7505	83.365	82.7275	83.025	186328.0
2020-06-09 09:00:00	AAPL	Stock	83.0125	84.275	82.99	83.995	15013888.0
2020-06-09 10:00:00	AAPL	Stock	83.9875	84.905	83.8875	84.88	16966828.0
2020-06-09 11:00:00	AAPL	Stock	84.87	85.5548	84.8425	85.2838	19535320.0
2020-06-09 12:00:00	AAPL	Stock	85.2825	86.22	85.268	86.0975	15935480.0
2020-06-09 13:00:00	AAPL	Stock	86.09	86.355	85.915	86.3125	10529568.0
2020-06-09 14:00:00	AAPL	Stock	86.3088	86.4025	85.6725	85.9595	13119104.0
2020-06-09 15:00:00	AAPL	Stock	85.9562	86.2725	85.9075	85.955	16048448.0
2020-06-09 16:00:00	AAPL	Stock	85.9975	85.9975	85.2812	85.8475	7169836.0
2020-06-09 17:00:00	AAPL	Stock	85.8875	86.185	85.8875	86.125	88268.0
2020-06-09 18:00:00	AAPL	Stock	86.125	86.365	86.0625	86.34	106468.0
2020-06-09 19:00:00	AAPL	Stock	86.34	86.3925	86.25	86.35	71960.0
2020-06-09 04:00:00	MSFT	Stock	187.3	187.4	186.5	186.5	14174.0
2020-06-09 05:00:00	MSFT	Stock	186.86	187.0	186.82	187.0	5829.0
2020-06-09 06:00:00	MSFT	Stock	187.25	187.35	186.7	186.76	8527.0
2020-06-09 07:00:00	MSFT	Stock	186.97	187.38	186.97	187.32	13163.0
2020-06-09 08:00:00	MSFT	Stock	187.0	188.83	187.0	187.58	49367.0
2020-06-09 09:00:00	MSFT	Stock	187.5	188.87	187.26	187.715	3289320.0
2020-06-09 10:00:00	MSFT	Stock	187.72	189.62	187.26	189.58	4174206.0
2020-06-09 11:00:00	MSFT	Stock	189.56	189.71	188.55	188.72	3048550.0
2020-06-09 12:00:00	MSFT	Stock	188.72	189.61	188.72	189.44	2198241.0
2020-06-09 13:00:00	MSFT	Stock	189.435	190.41	189.25	190.385	2832096.0
2020-06-09 14:00:00	MSFT	Stock	190.385	190.7	189.73	190.23	2799983.0
2020-06-09 15:00:00	MSFT	Stock	190.24	190.47	189.41	189.78	4004794.0
2020-06-09 16:00:00	MSFT	Stock	189.8	189.81	189.1	189.49	2990102.0
2020-06-09 17:00:00	MSFT	Stock	189.45	189.74	189.45	189.55	10839.0
2020-06-09 18:00:00	MSFT	Stock	189.54	190.03	189.54	189.9	19729.0
2020-06-09 19:00:00	MSFT	Stock	190.1	190.3	189.95	190.3	26093.0
2020-06-09 04:00:00	NVDA	Stock	8.7288	8.7385	8.7	8.7	83560.0
2020-06-09 05:00:00	NVDA	Stock	8.7075	8.7075	8.7075	8.7075	8040.0
2020-06-09 07:00:00	NVDA	Stock	8.7668	8.7668	8.7262	8.7482	502160.0
2020-06-09 08:00:00	NVDA	Stock	8.75	8.7625	8.73	8.7562	707080.0
2020-06-09 09:00:00	NVDA	Stock	8.7594	9.0145	8.7491	9.003	91607960.0
2020-06-09 10:00:00	NVDA	Stock	9.0073	9.0875	8.9333	9.0849	103258400.0
2020-06-09 11:00:00	NVDA	Stock	9.0862	9.1098	9.0265	9.0763	58362800.0
2020-06-09 12:00:00	NVDA	Stock	9.0748	9.1	9.0272	9.0612	35559560.0
2020-06-09 13:00:00	NVDA	Stock	9.0595	9.08	9.0355	9.0765	23658000.0
2020-06-09 14:00:00	NVDA	Stock	9.0758	9.0812	8.99	9.0415	49300960.0
2020-06-09 15:00:00	NVDA	Stock	9.0438	9.0675	8.9918	9.0475	60714600.0
2020-06-09 16:00:00	NVDA	Stock	9.0478	9.0588	9.04	9.0475	3371000.0
2020-06-09 17:00:00	NVDA	Stock	9.05	9.0612	9.05	9.0608	261440.0
2020-06-09 18:00:00	NVDA	Stock	9.0622	9.075	9.0562	9.0745	238960.0
2020-06-09 19:00:00	NVDA	Stock	9.0745	9.0935	9.0745	9.0935	578640.0
2020-06-09 04:00:00	AMZN	Stock	126.0	126.0025	125.5155	125.65	48020.0
2020-06-09 05:00:00	AMZN	Stock	125.552	125.851	125.552	125.851	50060.0
2020-06-09 06:00:00	AMZN	Stock	125.8105	125.9	125.8105	125.9	8560.0

> showing 50 of 58,262 rows — these rows as CSV

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