PREVIEW / stock_1hour / 2019-10-30

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-10-30.parquet
  size:    1.1 MB
  rows:    49,644
  symbols: 2,503

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
2019-10-30 04:00:00	AAPL	Stock	60.9575	60.9575	60.7525	60.8725	17200.0
2019-10-30 05:00:00	AAPL	Stock	60.8725	60.9575	60.8475	60.9575	15464.0
2019-10-30 06:00:00	AAPL	Stock	60.95	61.04	60.95	61.0	10484.0
2019-10-30 07:00:00	AAPL	Stock	60.975	61.25	60.975	61.2125	227764.0
2019-10-30 08:00:00	AAPL	Stock	61.0	61.3425	60.9725	61.32	463684.0
2019-10-30 09:00:00	AAPL	Stock	61.325	61.3975	60.5775	60.89	16311920.0
2019-10-30 10:00:00	AAPL	Stock	60.885	60.9975	60.625	60.75	10438036.0
2019-10-30 11:00:00	AAPL	Stock	60.7525	60.81	60.3025	60.5125	11546420.0
2019-10-30 12:00:00	AAPL	Stock	60.5125	60.7425	60.4325	60.5725	8209860.0
2019-10-30 13:00:00	AAPL	Stock	60.5725	60.6125	60.385	60.415	7101064.0
2019-10-30 14:00:00	AAPL	Stock	60.405	60.7125	60.325	60.67	11273200.0
2019-10-30 15:00:00	AAPL	Stock	60.67	60.9375	60.645	60.8225	20020016.0
2019-10-30 16:00:00	AAPL	Stock	60.815	63.125	60.815	61.5625	14492676.0
2019-10-30 17:00:00	AAPL	Stock	61.5675	62.185	61.5	62.05	3010648.0
2019-10-30 18:00:00	AAPL	Stock	62.065	62.065	61.875	61.9375	433860.0
2019-10-30 19:00:00	AAPL	Stock	61.9375	62.0625	61.9	62.0475	357856.0
2019-10-30 04:00:00	MSFT	Stock	142.9	142.9	142.9	142.9	460.0
2019-10-30 05:00:00	MSFT	Stock	143.08	143.25	143.08	143.19	323.0
2019-10-30 06:00:00	MSFT	Stock	143.19	143.2	143.19	143.2	1106.0
2019-10-30 07:00:00	MSFT	Stock	143.29	143.29	142.94	143.02	1956.0
2019-10-30 08:00:00	MSFT	Stock	143.15	143.18	142.61	143.05	19858.0
2019-10-30 09:00:00	MSFT	Stock	143.01	143.72	143.01	143.32	2004966.0
2019-10-30 10:00:00	MSFT	Stock	143.315	143.89	142.79	143.8	2563986.0
2019-10-30 11:00:00	MSFT	Stock	143.79	143.86	143.5	143.629	1536093.0
2019-10-30 12:00:00	MSFT	Stock	143.63	143.91	143.55	143.715	940077.0
2019-10-30 13:00:00	MSFT	Stock	143.715	143.85	143.39	143.46	1010166.0
2019-10-30 14:00:00	MSFT	Stock	143.45	144.31	143.2	144.19	2414007.0
2019-10-30 15:00:00	MSFT	Stock	144.19	145.0	144.17	144.56	3407683.0
2019-10-30 16:00:00	MSFT	Stock	144.57	144.8	144.45	144.594	1874890.0
2019-10-30 17:00:00	MSFT	Stock	144.626	144.8	144.62	144.75	10084.0
2019-10-30 18:00:00	MSFT	Stock	144.7	144.76	144.5	144.68	11951.0
2019-10-30 19:00:00	MSFT	Stock	144.68	144.69	144.6	144.62	10688.0
2019-10-30 04:00:00	NVDA	Stock	5.0998	5.1125	5.0862	5.0862	116320.0
2019-10-30 05:00:00	NVDA	Stock	5.0888	5.09	5.0888	5.09	24000.0
2019-10-30 06:00:00	NVDA	Stock	5.084	5.0875	5.084	5.0875	112880.0
2019-10-30 07:00:00	NVDA	Stock	5.084	5.0932	5.084	5.0932	79920.0
2019-10-30 08:00:00	NVDA	Stock	5.0875	5.1012	5.0825	5.1002	401920.0
2019-10-30 09:00:00	NVDA	Stock	5.1012	5.1062	5.0396	5.0795	23280120.0
2019-10-30 10:00:00	NVDA	Stock	5.0792	5.0792	5.0325	5.0642	24065840.0
2019-10-30 11:00:00	NVDA	Stock	5.0645	5.0653	5.024	5.0297	19059960.0
2019-10-30 12:00:00	NVDA	Stock	5.0288	5.0493	5.02	5.0346	15904600.0
2019-10-30 13:00:00	NVDA	Stock	5.0353	5.048	5.0233	5.0238	12165720.0
2019-10-30 14:00:00	NVDA	Stock	5.024	5.0773	5.0065	5.0773	23391960.0
2019-10-30 15:00:00	NVDA	Stock	5.0771	5.087	5.0655	5.0775	27487800.0
2019-10-30 16:00:00	NVDA	Stock	5.075	5.0938	5.0712	5.0778	13249080.0
2019-10-30 17:00:00	NVDA	Stock	5.084	5.0862	5.0778	5.0788	211920.0
2019-10-30 18:00:00	NVDA	Stock	5.0825	5.09	5.0825	5.0875	122480.0
2019-10-30 19:00:00	NVDA	Stock	5.085	5.0935	5.0825	5.0935	179600.0
2019-10-30 06:00:00	AMZN	Stock	88.1995	88.1995	88.1995	88.1995	2000.0
2019-10-30 07:00:00	AMZN	Stock	88.1355	88.2	88.1355	88.2	8220.0

> showing 50 of 49,644 rows — these rows as CSV

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