PREVIEW / stock_1hour / 2020-01-16

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-01-16.parquet
  size:    1.2 MB
  rows:    51,431
  symbols: 2,455

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-16 04:00:00	AAPL	Stock	78.2625	78.525	78.2625	78.45	29184.0
2020-01-16 05:00:00	AAPL	Stock	78.4	78.445	78.3775	78.425	24360.0
2020-01-16 06:00:00	AAPL	Stock	78.4275	78.4575	78.32	78.425	19148.0
2020-01-16 07:00:00	AAPL	Stock	78.4075	78.6225	78.4	78.4025	481532.0
2020-01-16 08:00:00	AAPL	Stock	78.45	78.5925	78.375	78.5125	472212.0
2020-01-16 09:00:00	AAPL	Stock	78.4875	78.8175	78.375	78.6422	16982796.0
2020-01-16 10:00:00	AAPL	Stock	78.6375	78.925	78.175	78.2	17994524.0
2020-01-16 11:00:00	AAPL	Stock	78.215	78.455	78.0225	78.3275	12309456.0
2020-01-16 12:00:00	AAPL	Stock	78.3232	78.3675	78.1125	78.21	5101256.0
2020-01-16 13:00:00	AAPL	Stock	78.215	78.47	78.165	78.425	5321652.0
2020-01-16 14:00:00	AAPL	Stock	78.4225	78.581	78.38	78.465	6418008.0
2020-01-16 15:00:00	AAPL	Stock	78.47	78.8425	78.4	78.8325	13825636.0
2020-01-16 16:00:00	AAPL	Stock	78.81	78.82	78.7275	78.775	7504916.0
2020-01-16 17:00:00	AAPL	Stock	78.7875	78.81	78.7375	78.7875	2870976.0
2020-01-16 18:00:00	AAPL	Stock	78.75	78.8725	78.75	78.825	141712.0
2020-01-16 19:00:00	AAPL	Stock	78.8125	78.8475	78.8	78.8225	77652.0
2020-01-16 04:00:00	MSFT	Stock	164.05	164.6	164.05	164.21	3758.0
2020-01-16 05:00:00	MSFT	Stock	164.19	164.34	164.11	164.34	4359.0
2020-01-16 06:00:00	MSFT	Stock	164.23	164.39	164.2	164.39	7131.0
2020-01-16 07:00:00	MSFT	Stock	164.31	164.36	164.12	164.13	29402.0
2020-01-16 08:00:00	MSFT	Stock	164.3	164.38	164.1	164.38	32114.0
2020-01-16 09:00:00	MSFT	Stock	164.38	164.76	164.03	164.69	2308085.0
2020-01-16 10:00:00	MSFT	Stock	164.68	165.15	164.54	164.84	2618198.0
2020-01-16 11:00:00	MSFT	Stock	164.85	165.1	164.53	164.985	1627418.0
2020-01-16 12:00:00	MSFT	Stock	164.97	165.295	164.94	165.01	1419137.0
2020-01-16 13:00:00	MSFT	Stock	165.02	165.178	164.834	165.105	1245198.0
2020-01-16 14:00:00	MSFT	Stock	165.11	165.54	165.074	165.44	1499531.0
2020-01-16 15:00:00	MSFT	Stock	165.44	166.24	165.38	166.21	3831976.0
2020-01-16 16:00:00	MSFT	Stock	166.17	166.48	165.381	166.3	5114503.0
2020-01-16 17:00:00	MSFT	Stock	166.17	166.87	166.17	166.81	1302883.0
2020-01-16 18:00:00	MSFT	Stock	166.87	166.95	166.6	166.65	24292.0
2020-01-16 19:00:00	MSFT	Stock	166.62	166.88	166.62	166.8	18681.0
2020-01-16 04:00:00	NVDA	Stock	6.2003	6.2158	6.2	6.2123	112520.0
2020-01-16 05:00:00	NVDA	Stock	6.2188	6.2188	6.2188	6.2188	4000.0
2020-01-16 06:00:00	NVDA	Stock	6.205	6.2102	6.2008	6.2013	51920.0
2020-01-16 07:00:00	NVDA	Stock	6.2065	6.2072	6.19	6.19	597080.0
2020-01-16 08:00:00	NVDA	Stock	6.2055	6.21	6.1875	6.2085	1153160.0
2020-01-16 09:00:00	NVDA	Stock	6.207	6.2293	6.1782	6.2055	43569440.0
2020-01-16 10:00:00	NVDA	Stock	6.2035	6.2244	6.171	6.176	30942200.0
2020-01-16 11:00:00	NVDA	Stock	6.1775	6.1948	6.1694	6.1858	20128880.0
2020-01-16 12:00:00	NVDA	Stock	6.1866	6.2038	6.1838	6.1868	19449680.0
2020-01-16 13:00:00	NVDA	Stock	6.187	6.1992	6.174	6.1905	17374800.0
2020-01-16 14:00:00	NVDA	Stock	6.1904	6.1968	6.183	6.1925	11167400.0
2020-01-16 15:00:00	NVDA	Stock	6.1918	6.225	6.19	6.225	37131160.0
2020-01-16 16:00:00	NVDA	Stock	6.2232	6.2245	6.2138	6.2178	19856880.0
2020-01-16 17:00:00	NVDA	Stock	6.22	6.2232	6.2153	6.2175	5082320.0
2020-01-16 18:00:00	NVDA	Stock	6.2153	6.2245	6.2153	6.2225	260680.0
2020-01-16 19:00:00	NVDA	Stock	6.219	6.2232	6.2188	6.2232	45320.0
2020-01-16 04:00:00	AMZN	Stock	93.5	93.5	93.5	93.5	8940.0
2020-01-16 05:00:00	AMZN	Stock	93.5	93.5	93.5	93.5	2400.0

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

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