PREVIEW / stock_1hour / 2020-10-21

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-10-21.parquet
  size:    1.3 MB
  rows:    57,388
  symbols: 2,514

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-21 04:00:00	AAPL	Stock	117.61	117.88	116.53	116.59	48651.0
2020-10-21 05:00:00	AAPL	Stock	116.65	117.79	116.5	117.4	29835.0
2020-10-21 06:00:00	AAPL	Stock	117.5	117.94	117.25	117.33	37876.0
2020-10-21 07:00:00	AAPL	Stock	117.35	117.5	116.77	116.82	217860.0
2020-10-21 08:00:00	AAPL	Stock	117.12	117.5	116.8	117.17	409245.0
2020-10-21 09:00:00	AAPL	Stock	117.19	118.27	116.45	118.13	11453586.0
2020-10-21 10:00:00	AAPL	Stock	118.13	118.705	117.76	118.08	12039758.0
2020-10-21 11:00:00	AAPL	Stock	118.07	118.2	117.17	117.385	10341348.0
2020-10-21 12:00:00	AAPL	Stock	117.381	118.1	116.74	116.89	11726237.0
2020-10-21 13:00:00	AAPL	Stock	116.89	117.51	116.8	117.12	7434659.0
2020-10-21 14:00:00	AAPL	Stock	117.12	117.95	116.99	117.94	8050951.0
2020-10-21 15:00:00	AAPL	Stock	117.95	118.05	116.81	116.86	13122233.0
2020-10-21 16:00:00	AAPL	Stock	116.87	117.05	116.72	116.9	7147454.0
2020-10-21 17:00:00	AAPL	Stock	116.931	116.94	116.63	116.82	162960.0
2020-10-21 18:00:00	AAPL	Stock	116.81	116.81	116.5	116.59	225082.0
2020-10-21 19:00:00	AAPL	Stock	116.6	116.68	116.0	116.39	310171.0
2020-10-21 04:00:00	MSFT	Stock	215.46	215.46	213.0	213.0	9481.0
2020-10-21 05:00:00	MSFT	Stock	212.6	214.89	212.6	214.61	10186.0
2020-10-21 06:00:00	MSFT	Stock	214.8	215.0	214.58	215.0	2590.0
2020-10-21 07:00:00	MSFT	Stock	214.96	214.97	213.12	213.15	28631.0
2020-10-21 08:00:00	MSFT	Stock	214.402	214.402	213.05	213.88	63510.0
2020-10-21 09:00:00	MSFT	Stock	214.0	216.29	213.0	216.22	2879213.0
2020-10-21 10:00:00	MSFT	Stock	216.24	216.46	214.91	215.22	2027530.0
2020-10-21 11:00:00	MSFT	Stock	215.22	215.49	213.69	214.2	2038025.0
2020-10-21 12:00:00	MSFT	Stock	214.225	215.718	213.71	214.16	1856981.0
2020-10-21 13:00:00	MSFT	Stock	214.11	215.94	213.93	215.48	1413634.0
2020-10-21 14:00:00	MSFT	Stock	215.51	216.92	215.24	216.87	1719083.0
2020-10-21 15:00:00	MSFT	Stock	216.88	216.92	214.76	214.785	3138760.0
2020-10-21 16:00:00	MSFT	Stock	214.8	215.55	214.65	214.89	3691369.0
2020-10-21 17:00:00	MSFT	Stock	215.05	215.05	214.66	214.78	4512.0
2020-10-21 18:00:00	MSFT	Stock	214.75	215.05	214.6	214.7	7228.0
2020-10-21 19:00:00	MSFT	Stock	214.7	214.91	213.15	213.99	18458.0
2020-10-21 04:00:00	NVDA	Stock	13.5625	13.5625	13.5625	13.5625	14720.0
2020-10-21 05:00:00	NVDA	Stock	13.45	13.55	13.45	13.55	76160.0
2020-10-21 06:00:00	NVDA	Stock	13.5625	13.5625	13.5625	13.5625	20200.0
2020-10-21 07:00:00	NVDA	Stock	13.552	13.57	13.5375	13.5375	526800.0
2020-10-21 08:00:00	NVDA	Stock	13.5375	13.6795	13.5375	13.5711	629120.0
2020-10-21 09:00:00	NVDA	Stock	13.5725	13.7732	13.55	13.768	31573800.0
2020-10-21 10:00:00	NVDA	Stock	13.7702	13.7915	13.6174	13.6282	30339960.0
2020-10-21 11:00:00	NVDA	Stock	13.6358	13.643	13.4775	13.5405	30410480.0
2020-10-21 12:00:00	NVDA	Stock	13.5448	13.6542	13.5093	13.5315	15845640.0
2020-10-21 13:00:00	NVDA	Stock	13.5314	13.6252	13.5143	13.572	12597680.0
2020-10-21 14:00:00	NVDA	Stock	13.5735	13.645	13.538	13.638	15833280.0
2020-10-21 15:00:00	NVDA	Stock	13.6418	13.6433	13.4908	13.525	45896840.0
2020-10-21 16:00:00	NVDA	Stock	13.5248	13.5692	13.5248	13.549	2574440.0
2020-10-21 17:00:00	NVDA	Stock	13.5312	13.5418	13.5312	13.541	30440.0
2020-10-21 18:00:00	NVDA	Stock	13.5412	13.565	13.5412	13.557	164080.0
2020-10-21 19:00:00	NVDA	Stock	13.5575	13.5575	13.492	13.4925	414400.0
2020-10-21 04:00:00	AMZN	Stock	160.63	160.63	160.63	160.63	6540.0
2020-10-21 07:00:00	AMZN	Stock	161.108	161.108	160.25	160.25	34480.0

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

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