PREVIEW / stock_1hour / 2020-11-04

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-11-04.parquet
  size:    1.3 MB
  rows:    57,624
  symbols: 2,524

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-11-04 04:00:00	AAPL	Stock	113.3	114.58	113.0	113.89	251683.0
2020-11-04 05:00:00	AAPL	Stock	113.77	113.77	112.15	113.12	146508.0
2020-11-04 06:00:00	AAPL	Stock	113.14	113.59	112.3	112.97	63609.0
2020-11-04 07:00:00	AAPL	Stock	112.9	114.29	112.5	114.18	949666.0
2020-11-04 08:00:00	AAPL	Stock	114.17	114.89	112.52	114.35	1822457.0
2020-11-04 09:00:00	AAPL	Stock	114.34	114.48	112.35	113.55	20224386.0
2020-11-04 10:00:00	AAPL	Stock	113.55	115.51	113.5	114.89	24133461.0
2020-11-04 11:00:00	AAPL	Stock	114.89	115.22	113.81	115.11	13700038.0
2020-11-04 12:00:00	AAPL	Stock	115.1	115.59	114.67	115.193	12321040.0
2020-11-04 13:00:00	AAPL	Stock	115.191	115.505	114.62	114.86	11754454.0
2020-11-04 14:00:00	AAPL	Stock	114.87	115.17	114.44	115.03	11233063.0
2020-11-04 15:00:00	AAPL	Stock	115.035	115.5	114.57	114.94	17904907.0
2020-11-04 16:00:00	AAPL	Stock	114.94	116.0	114.88	115.8	10846340.0
2020-11-04 17:00:00	AAPL	Stock	115.75	115.89	115.52	115.61	160049.0
2020-11-04 18:00:00	AAPL	Stock	115.6	115.9	115.43	115.5	237196.0
2020-11-04 19:00:00	AAPL	Stock	115.5	116.0	115.48	115.99	189639.0
2020-11-04 04:00:00	MSFT	Stock	210.6	214.18	210.6	213.0	44158.0
2020-11-04 05:00:00	MSFT	Stock	212.32	212.7	210.0	212.1	18923.0
2020-11-04 06:00:00	MSFT	Stock	211.34	212.5	210.17	212.09	24105.0
2020-11-04 07:00:00	MSFT	Stock	211.45	214.51	210.75	214.51	203929.0
2020-11-04 08:00:00	MSFT	Stock	214.5	215.88	210.75	214.8	396022.0
2020-11-04 09:00:00	MSFT	Stock	214.85	215.13	212.418	213.75	4983698.0
2020-11-04 10:00:00	MSFT	Stock	213.75	216.535	213.53	216.48	5498575.0
2020-11-04 11:00:00	MSFT	Stock	216.48	217.42	215.69	217.27	3906142.0
2020-11-04 12:00:00	MSFT	Stock	217.27	218.32	216.64	217.588	3667517.0
2020-11-04 13:00:00	MSFT	Stock	217.61	218.0	216.54	217.17	2934397.0
2020-11-04 14:00:00	MSFT	Stock	217.21	217.67	216.1	216.984	2594046.0
2020-11-04 15:00:00	MSFT	Stock	217.04	217.45	215.87	216.32	5395342.0
2020-11-04 16:00:00	MSFT	Stock	216.32	217.42	216.13	216.9	4781753.0
2020-11-04 17:00:00	MSFT	Stock	217.04	217.8	216.92	217.6	19951.0
2020-11-04 18:00:00	MSFT	Stock	217.51	218.1	216.52	217.84	32336.0
2020-11-04 19:00:00	MSFT	Stock	217.24	217.79	216.82	217.0	14314.0
2020-11-04 04:00:00	NVDA	Stock	13.3875	13.525	13.35	13.4868	259600.0
2020-11-04 05:00:00	NVDA	Stock	13.492	13.492	13.4248	13.4248	18920.0
2020-11-04 06:00:00	NVDA	Stock	13.375	13.38	13.325	13.325	110200.0
2020-11-04 07:00:00	NVDA	Stock	13.3078	13.4625	13.275	13.461	1733800.0
2020-11-04 08:00:00	NVDA	Stock	13.4413	13.5378	13.25	13.4408	4007080.0
2020-11-04 09:00:00	NVDA	Stock	13.4415	13.5848	13.33	13.421	51931440.0
2020-11-04 10:00:00	NVDA	Stock	13.425	13.6775	13.3888	13.6225	56440040.0
2020-11-04 11:00:00	NVDA	Stock	13.6228	13.6895	13.5058	13.672	24625880.0
2020-11-04 12:00:00	NVDA	Stock	13.6685	13.762	13.6292	13.694	31916960.0
2020-11-04 13:00:00	NVDA	Stock	13.6975	13.764	13.6405	13.7412	26249280.0
2020-11-04 14:00:00	NVDA	Stock	13.7435	13.817	13.719	13.7972	27069520.0
2020-11-04 15:00:00	NVDA	Stock	13.801	13.8275	13.7152	13.7945	39821320.0
2020-11-04 16:00:00	NVDA	Stock	13.7942	13.845	13.7743	13.825	21668320.0
2020-11-04 17:00:00	NVDA	Stock	13.83	13.843	13.8122	13.8235	263960.0
2020-11-04 18:00:00	NVDA	Stock	13.8128	13.8248	13.775	13.7988	193840.0
2020-11-04 19:00:00	NVDA	Stock	13.8	13.8065	13.7705	13.8	316080.0
2020-11-04 04:00:00	AMZN	Stock	156.75	157.497	156.7	157.3745	83760.0
2020-11-04 05:00:00	AMZN	Stock	157.232	157.232	155.9	156.745	12460.0

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

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