PREVIEW / stock_1hour / 2020-10-09

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-10-09.parquet
  size:    1.3 MB
  rows:    57,314
  symbols: 2,515

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-09 04:00:00	AAPL	Stock	115.56	115.58	115.22	115.37	18732.0
2020-10-09 05:00:00	AAPL	Stock	115.37	115.48	115.3	115.3	17301.0
2020-10-09 06:00:00	AAPL	Stock	115.29	115.34	115.05	115.1	17637.0
2020-10-09 07:00:00	AAPL	Stock	115.15	115.4	115.05	115.22	150672.0
2020-10-09 08:00:00	AAPL	Stock	115.14	115.7	115.07	115.58	524768.0
2020-10-09 09:00:00	AAPL	Stock	115.56	116.28	114.92	115.94	15004189.0
2020-10-09 10:00:00	AAPL	Stock	115.935	116.36	115.68	116.265	13189510.0
2020-10-09 11:00:00	AAPL	Stock	116.26	116.37	115.78	116.13	10631410.0
2020-10-09 12:00:00	AAPL	Stock	116.13	116.35	115.77	116.29	9026259.0
2020-10-09 13:00:00	AAPL	Stock	116.29	116.63	115.99	116.13	9588998.0
2020-10-09 14:00:00	AAPL	Stock	116.13	116.45	116.05	116.09	8449225.0
2020-10-09 15:00:00	AAPL	Stock	116.1	117.0	116.03	116.98	15595381.0
2020-10-09 16:00:00	AAPL	Stock	116.97	117.54	116.92	117.48	8966397.0
2020-10-09 17:00:00	AAPL	Stock	117.47	117.78	117.39	117.7	371648.0
2020-10-09 18:00:00	AAPL	Stock	117.7	117.95	117.55	117.91	295763.0
2020-10-09 19:00:00	AAPL	Stock	117.92	118.0	117.9	118.0	307446.0
2020-10-09 04:00:00	MSFT	Stock	211.29	211.29	211.29	211.29	400.0
2020-10-09 05:00:00	MSFT	Stock	211.0	211.0	211.0	211.0	400.0
2020-10-09 06:00:00	MSFT	Stock	211.0	211.0	211.0	211.0	393.0
2020-10-09 07:00:00	MSFT	Stock	211.0	211.49	211.0	211.23	10882.0
2020-10-09 08:00:00	MSFT	Stock	211.25	211.86	210.58	211.85	25918.0
2020-10-09 09:00:00	MSFT	Stock	211.868	212.87	211.12	212.38	2420367.0
2020-10-09 10:00:00	MSFT	Stock	212.38	213.825	212.29	213.56	3041775.0
2020-10-09 11:00:00	MSFT	Stock	213.56	214.68	213.4	214.29	2964799.0
2020-10-09 12:00:00	MSFT	Stock	214.235	215.15	213.66	214.906	2598098.0
2020-10-09 13:00:00	MSFT	Stock	214.895	215.45	214.38	215.1	2309909.0
2020-10-09 14:00:00	MSFT	Stock	215.09	215.45	214.35	214.73	1931935.0
2020-10-09 15:00:00	MSFT	Stock	214.71	215.86	214.59	215.81	3858853.0
2020-10-09 16:00:00	MSFT	Stock	215.81	215.98	212.431	215.97	2866289.0
2020-10-09 17:00:00	MSFT	Stock	215.95	216.0	215.79	215.81	15478.0
2020-10-09 18:00:00	MSFT	Stock	215.63	215.63	215.3	215.45	16808.0
2020-10-09 19:00:00	MSFT	Stock	215.5	215.74	215.5	215.71	9980.0
2020-10-09 04:00:00	NVDA	Stock	13.8613	13.8625	13.8613	13.8625	52200.0
2020-10-09 05:00:00	NVDA	Stock	13.8643	13.8643	13.85	13.85	68600.0
2020-10-09 06:00:00	NVDA	Stock	13.778	13.825	13.778	13.8225	195360.0
2020-10-09 07:00:00	NVDA	Stock	13.7998	13.8125	13.79	13.8078	330320.0
2020-10-09 08:00:00	NVDA	Stock	13.7912	13.8188	13.7032	13.7775	1924520.0
2020-10-09 09:00:00	NVDA	Stock	13.781	13.8242	13.6805	13.7758	51738320.0
2020-10-09 10:00:00	NVDA	Stock	13.7765	13.7868	13.6608	13.7021	42453560.0
2020-10-09 11:00:00	NVDA	Stock	13.7022	13.7366	13.6722	13.7266	36257960.0
2020-10-09 12:00:00	NVDA	Stock	13.7265	13.7848	13.6952	13.7485	35245840.0
2020-10-09 13:00:00	NVDA	Stock	13.7505	13.7935	13.7067	13.7423	25928520.0
2020-10-09 14:00:00	NVDA	Stock	13.7425	13.7508	13.678	13.6884	27010720.0
2020-10-09 15:00:00	NVDA	Stock	13.6868	13.766	13.6805	13.7635	52521440.0
2020-10-09 16:00:00	NVDA	Stock	13.7628	13.7702	13.7538	13.755	19197720.0
2020-10-09 17:00:00	NVDA	Stock	13.7502	13.76	13.75	13.76	111160.0
2020-10-09 18:00:00	NVDA	Stock	13.756	13.7575	13.75	13.7505	103160.0
2020-10-09 19:00:00	NVDA	Stock	13.75	13.757	13.7475	13.757	141080.0
2020-10-09 04:00:00	AMZN	Stock	160.0	160.0	160.0	160.0	4400.0
2020-10-09 05:00:00	AMZN	Stock	160.2495	160.2495	160.2495	160.2495	6160.0

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

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