PREVIEW / stock_1hour / 2020-09-15

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-09-15.parquet
  size:    1.2 MB
  rows:    56,229
  symbols: 2,491

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-09-15 04:00:00	AAPL	Stock	116.54	117.22	116.11	117.19	66573.0
2020-09-15 05:00:00	AAPL	Stock	117.19	117.65	117.08	117.49	54333.0
2020-09-15 06:00:00	AAPL	Stock	117.55	117.6	116.65	117.48	89261.0
2020-09-15 07:00:00	AAPL	Stock	117.51	117.89	117.0	117.54	515769.0
2020-09-15 08:00:00	AAPL	Stock	117.55	118.48	117.0	118.255	1596723.0
2020-09-15 09:00:00	AAPL	Stock	118.254	118.88	117.23	118.038	20295355.0
2020-09-15 10:00:00	AAPL	Stock	118.04	118.08	115.64	116.48	22157840.0
2020-09-15 11:00:00	AAPL	Stock	116.49	117.568	116.26	117.4	15369924.0
2020-09-15 12:00:00	AAPL	Stock	117.41	118.11	117.13	117.86	13013146.0
2020-09-15 13:00:00	AAPL	Stock	117.86	118.2	116.5	116.79	23358297.0
2020-09-15 14:00:00	AAPL	Stock	116.79	116.94	115.0	115.335	27557012.0
2020-09-15 15:00:00	AAPL	Stock	115.338	115.79	113.61	115.58	29709978.0
2020-09-15 16:00:00	AAPL	Stock	115.535	116.439	115.25	115.3	7215408.0
2020-09-15 17:00:00	AAPL	Stock	115.29	115.5	114.91	115.1	390773.0
2020-09-15 18:00:00	AAPL	Stock	115.11	115.31	115.0	115.12	130501.0
2020-09-15 19:00:00	AAPL	Stock	115.12	115.14	114.5	114.77	348665.0
2020-09-15 04:00:00	MSFT	Stock	206.4	206.6	205.84	205.86	2005.0
2020-09-15 05:00:00	MSFT	Stock	206.13	207.65	206.12	207.65	1722.0
2020-09-15 06:00:00	MSFT	Stock	207.4	207.45	206.65	207.25	4376.0
2020-09-15 07:00:00	MSFT	Stock	207.1	207.99	206.63	207.34	58726.0
2020-09-15 08:00:00	MSFT	Stock	207.46	207.99	206.62	207.19	66823.0
2020-09-15 09:00:00	MSFT	Stock	207.16	209.78	207.16	209.48	3116341.0
2020-09-15 10:00:00	MSFT	Stock	209.404	209.65	206.93	207.75	2071776.0
2020-09-15 11:00:00	MSFT	Stock	207.79	209.22	207.46	208.64	1825465.0
2020-09-15 12:00:00	MSFT	Stock	208.65	209.16	208.39	208.605	1080922.0
2020-09-15 13:00:00	MSFT	Stock	208.59	209.32	208.54	208.89	1024569.0
2020-09-15 14:00:00	MSFT	Stock	208.91	208.98	208.11	208.39	1198257.0
2020-09-15 15:00:00	MSFT	Stock	208.4	208.95	207.16	208.85	2870570.0
2020-09-15 16:00:00	MSFT	Stock	208.78	210.48	208.491	209.66	3285091.0
2020-09-15 17:00:00	MSFT	Stock	209.65	209.75	209.35	209.6	12307.0
2020-09-15 18:00:00	MSFT	Stock	209.5	209.75	209.0	209.34	13189.0
2020-09-15 19:00:00	MSFT	Stock	209.34	209.8	208.8	209.75	37851.0
2020-09-15 04:00:00	NVDA	Stock	12.975	13.0448	12.975	13.025	259960.0
2020-09-15 05:00:00	NVDA	Stock	13.025	13.1243	13.025	13.1125	350760.0
2020-09-15 06:00:00	NVDA	Stock	13.087	13.225	13.064	13.225	713720.0
2020-09-15 07:00:00	NVDA	Stock	13.1908	13.242	13.1775	13.1988	2134640.0
2020-09-15 08:00:00	NVDA	Stock	13.2017	13.2944	13.1752	13.2493	7414280.0
2020-09-15 09:00:00	NVDA	Stock	13.25	13.2988	13.0312	13.136	117687760.0
2020-09-15 10:00:00	NVDA	Stock	13.134	13.1928	12.8833	12.9556	154380680.0
2020-09-15 11:00:00	NVDA	Stock	12.9538	12.9888	12.8355	12.9188	75284880.0
2020-09-15 12:00:00	NVDA	Stock	12.9202	13.0455	12.9	12.9758	65765880.0
2020-09-15 13:00:00	NVDA	Stock	12.9758	13.0222	12.886	12.8875	44305840.0
2020-09-15 14:00:00	NVDA	Stock	12.8926	12.9898	12.8593	12.9835	51624160.0
2020-09-15 15:00:00	NVDA	Stock	12.9843	12.9993	12.8278	12.997	83142760.0
2020-09-15 16:00:00	NVDA	Stock	12.991	13.025	12.9855	13.0125	5065680.0
2020-09-15 17:00:00	NVDA	Stock	13.0125	13.0375	13.0125	13.025	724680.0
2020-09-15 18:00:00	NVDA	Stock	13.028	13.0468	13.0202	13.0202	342080.0
2020-09-15 19:00:00	NVDA	Stock	13.025	13.025	12.9558	12.9813	1024960.0
2020-09-15 04:00:00	AMZN	Stock	156.211	156.35	156.211	156.35	7580.0
2020-09-15 05:00:00	AMZN	Stock	156.5	156.9	156.5	156.9	9000.0

> showing 50 of 56,229 rows — these rows as CSV

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