PREVIEW / stock_1hour / 2020-01-09

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-01-09.parquet
  size:    1.2 MB
  rows:    51,537
  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-01-09 04:00:00	AAPL	Stock	76.2975	76.49	76.255	76.4625	87176.0
2020-01-09 05:00:00	AAPL	Stock	76.4575	76.5	76.35	76.4225	77112.0
2020-01-09 06:00:00	AAPL	Stock	76.4225	76.4625	76.3475	76.35	32532.0
2020-01-09 07:00:00	AAPL	Stock	76.35	76.6725	76.31	76.575	758996.0
2020-01-09 08:00:00	AAPL	Stock	76.5	76.775	76.385	76.69	903924.0
2020-01-09 09:00:00	AAPL	Stock	76.7025	77.2248	76.6625	77.075	28021924.0
2020-01-09 10:00:00	AAPL	Stock	77.0725	77.365	76.855	77.2768	20540280.0
2020-01-09 11:00:00	AAPL	Stock	77.2762	77.6075	77.245	77.4812	20258148.0
2020-01-09 12:00:00	AAPL	Stock	77.485	77.5075	76.55	76.91	23945308.0
2020-01-09 13:00:00	AAPL	Stock	76.9125	77.4625	76.8575	77.2702	16795900.0
2020-01-09 14:00:00	AAPL	Stock	77.2688	77.3725	77.1825	77.2562	9382756.0
2020-01-09 15:00:00	AAPL	Stock	77.2525	77.43	77.0625	77.4275	17838164.0
2020-01-09 16:00:00	AAPL	Stock	77.425	77.45	77.355	77.4375	9206216.0
2020-01-09 17:00:00	AAPL	Stock	77.425	77.4475	77.4075	77.445	138184.0
2020-01-09 18:00:00	AAPL	Stock	77.4475	77.6	77.4475	77.5875	187428.0
2020-01-09 19:00:00	AAPL	Stock	77.5925	77.6	77.555	77.6	203684.0
2020-01-09 04:00:00	MSFT	Stock	160.89	161.39	160.89	161.3	5569.0
2020-01-09 05:00:00	MSFT	Stock	161.4	161.54	160.82	161.03	12871.0
2020-01-09 06:00:00	MSFT	Stock	161.25	161.38	161.08	161.11	7173.0
2020-01-09 07:00:00	MSFT	Stock	161.2	161.87	161.2	161.5	59688.0
2020-01-09 08:00:00	MSFT	Stock	161.44	161.88	160.49	161.8	76511.0
2020-01-09 09:00:00	MSFT	Stock	161.73	162.215	161.34	161.63	2944670.0
2020-01-09 10:00:00	MSFT	Stock	161.635	161.77	161.37	161.7	2091612.0
2020-01-09 11:00:00	MSFT	Stock	161.7	162.17	161.62	162.126	1783290.0
2020-01-09 12:00:00	MSFT	Stock	162.12	162.2	161.03	161.68	2053314.0
2020-01-09 13:00:00	MSFT	Stock	161.68	162.01	161.56	161.845	1217394.0
2020-01-09 14:00:00	MSFT	Stock	161.843	162.04	161.605	161.83	1356113.0
2020-01-09 15:00:00	MSFT	Stock	161.83	162.12	161.37	162.09	2644625.0
2020-01-09 16:00:00	MSFT	Stock	162.09	162.09	161.789	162.07	4607953.0
2020-01-09 17:00:00	MSFT	Stock	162.07	162.1	162.04	162.1	23142.0
2020-01-09 18:00:00	MSFT	Stock	162.1	162.25	162.08	162.24	8708.0
2020-01-09 19:00:00	MSFT	Stock	162.2	162.52	162.2	162.4	4905.0
2020-01-09 04:00:00	NVDA	Stock	6.0625	6.075	6.0625	6.0745	44000.0
2020-01-09 05:00:00	NVDA	Stock	6.0745	6.0753	6.0675	6.07	80840.0
2020-01-09 06:00:00	NVDA	Stock	6.0688	6.0755	6.0688	6.0755	90480.0
2020-01-09 07:00:00	NVDA	Stock	6.0728	6.0935	6.0628	6.0825	968520.0
2020-01-09 08:00:00	NVDA	Stock	6.08	6.0975	6.0625	6.0875	1676600.0
2020-01-09 09:00:00	NVDA	Stock	6.0955	6.1483	6.07	6.1285	50657240.0
2020-01-09 10:00:00	NVDA	Stock	6.1275	6.1332	6.1023	6.1128	42019480.0
2020-01-09 11:00:00	NVDA	Stock	6.1133	6.122	6.0845	6.0958	25823320.0
2020-01-09 12:00:00	NVDA	Stock	6.0958	6.1	6.0214	6.0589	30147040.0
2020-01-09 13:00:00	NVDA	Stock	6.0593	6.0725	6.044	6.0682	13173480.0
2020-01-09 14:00:00	NVDA	Stock	6.067	6.0895	6.062	6.0825	18370720.0
2020-01-09 15:00:00	NVDA	Stock	6.0818	6.0858	6.06	6.0755	26395600.0
2020-01-09 16:00:00	NVDA	Stock	6.0755	6.077	6.07	6.077	18730760.0
2020-01-09 17:00:00	NVDA	Stock	6.0775	6.081	6.075	6.081	90320.0
2020-01-09 18:00:00	NVDA	Stock	6.08	6.0888	6.08	6.0875	179200.0
2020-01-09 19:00:00	NVDA	Stock	6.085	6.0928	6.08	6.0928	86520.0
2020-01-09 05:00:00	AMZN	Stock	95.34	95.3715	95.25	95.261	18560.0
2020-01-09 06:00:00	AMZN	Stock	95.2975	95.3	95.2755	95.3	12780.0

> showing 50 of 51,537 rows — these rows as CSV

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