PREVIEW / stock_1hour / 2019-06-27

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-06-27.parquet
  size:    1.1 MB
  rows:    49,938
  symbols: 2,621

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-06-27 04:00:00	AAPL	Stock	50.2275	50.3125	50.1875	50.245	12404.0
2019-06-27 05:00:00	AAPL	Stock	50.2375	50.43	50.175	50.1825	58464.0
2019-06-27 06:00:00	AAPL	Stock	50.165	50.165	50.0	50.1175	70560.0
2019-06-27 07:00:00	AAPL	Stock	50.1025	50.1175	50.0075	50.0325	147532.0
2019-06-27 08:00:00	AAPL	Stock	50.1	50.205	50.0375	50.1375	508088.0
2019-06-27 09:00:00	AAPL	Stock	50.15	50.3925	50.0275	50.3125	11855488.0
2019-06-27 10:00:00	AAPL	Stock	50.305	50.3375	50.03	50.145	8723656.0
2019-06-27 11:00:00	AAPL	Stock	50.1425	50.1925	49.8925	49.95	8872660.0
2019-06-27 12:00:00	AAPL	Stock	49.95	50.1	49.9325	49.9775	5340644.0
2019-06-27 13:00:00	AAPL	Stock	49.9775	50.0625	49.9775	49.9975	3742736.0
2019-06-27 14:00:00	AAPL	Stock	49.99	50.045	49.9675	49.995	4335116.0
2019-06-27 15:00:00	AAPL	Stock	49.995	50.0175	49.915	49.9325	8435764.0
2019-06-27 16:00:00	AAPL	Stock	49.935	50.01	49.2525	49.495	11603444.0
2019-06-27 17:00:00	AAPL	Stock	49.4975	49.935	49.315	49.375	1537848.0
2019-06-27 18:00:00	AAPL	Stock	49.44	49.5625	49.3625	49.5275	301976.0
2019-06-27 19:00:00	AAPL	Stock	49.525	49.6625	49.5125	49.6	200808.0
2019-06-27 04:00:00	MSFT	Stock	134.9	134.9	134.68	134.68	721.0
2019-06-27 05:00:00	MSFT	Stock	134.61	134.61	134.46	134.46	900.0
2019-06-27 06:00:00	MSFT	Stock	134.23	134.29	134.06	134.24	2512.0
2019-06-27 07:00:00	MSFT	Stock	134.45	134.5	134.15	134.33	6237.0
2019-06-27 08:00:00	MSFT	Stock	134.4	134.8	134.34	134.612	16492.0
2019-06-27 09:00:00	MSFT	Stock	134.63	134.71	133.51	133.989	1903670.0
2019-06-27 10:00:00	MSFT	Stock	133.99	134.57	133.805	134.247	1803535.0
2019-06-27 11:00:00	MSFT	Stock	134.245	134.31	133.58	133.93	2042182.0
2019-06-27 12:00:00	MSFT	Stock	133.93	134.23	133.91	133.99	1276423.0
2019-06-27 13:00:00	MSFT	Stock	133.99	134.44	133.95	134.33	976361.0
2019-06-27 14:00:00	MSFT	Stock	134.33	134.48	134.11	134.17	1028977.0
2019-06-27 15:00:00	MSFT	Stock	134.17	134.34	134.01	134.14	2458104.0
2019-06-27 16:00:00	MSFT	Stock	134.15	134.49	134.05	134.45	2475183.0
2019-06-27 17:00:00	MSFT	Stock	134.15	134.44	134.15	134.44	7848.0
2019-06-27 18:00:00	MSFT	Stock	134.43	134.67	134.31	134.33	6122.0
2019-06-27 19:00:00	MSFT	Stock	134.31	134.47	134.3	134.47	5221.0
2019-06-27 04:00:00	NVDA	Stock	4.0628	4.0688	4.0628	4.065	24000.0
2019-06-27 05:00:00	NVDA	Stock	4.068	4.068	4.0545	4.055	90320.0
2019-06-27 06:00:00	NVDA	Stock	4.0515	4.0515	4.0242	4.0498	458160.0
2019-06-27 07:00:00	NVDA	Stock	4.0425	4.05	4.0153	4.0425	878160.0
2019-06-27 08:00:00	NVDA	Stock	4.04	4.06	4.0252	4.0513	3145920.0
2019-06-27 09:00:00	NVDA	Stock	4.05	4.096	4.0315	4.0808	97362560.0
2019-06-27 10:00:00	NVDA	Stock	4.0825	4.1	4.0438	4.06	80534760.0
2019-06-27 11:00:00	NVDA	Stock	4.06	4.0708	4.0333	4.0422	42058920.0
2019-06-27 12:00:00	NVDA	Stock	4.042	4.0718	4.0398	4.0692	40262600.0
2019-06-27 13:00:00	NVDA	Stock	4.0688	4.08	4.0655	4.0735	31103280.0
2019-06-27 14:00:00	NVDA	Stock	4.0736	4.0964	4.0695	4.0858	34287200.0
2019-06-27 15:00:00	NVDA	Stock	4.0859	4.094	4.0803	4.0808	63160400.0
2019-06-27 16:00:00	NVDA	Stock	4.0808	4.089	4.0778	4.0872	4031360.0
2019-06-27 17:00:00	NVDA	Stock	4.0872	4.0913	4.0808	4.0848	475240.0
2019-06-27 18:00:00	NVDA	Stock	4.0895	4.0928	4.0875	4.0922	190640.0
2019-06-27 19:00:00	NVDA	Stock	4.0913	4.1048	4.091	4.1048	760520.0
2019-06-27 05:00:00	AMZN	Stock	95.402	95.8	95.3	95.3	34240.0
2019-06-27 06:00:00	AMZN	Stock	95.151	95.151	95.061	95.061	10620.0

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

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