PREVIEW / stock_1hour / 2019-07-15

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-07-15.parquet
  size:    1.1 MB
  rows:    49,331
  symbols: 2,572

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-07-15 04:00:00	AAPL	Stock	50.8825	50.8825	50.865	50.865	1200.0
2019-07-15 05:00:00	AAPL	Stock	50.8875	50.8875	50.8625	50.865	3400.0
2019-07-15 06:00:00	AAPL	Stock	50.865	50.865	50.865	50.865	4320.0
2019-07-15 07:00:00	AAPL	Stock	50.88	50.9625	50.88	50.95	39428.0
2019-07-15 08:00:00	AAPL	Stock	50.9125	51.0	50.9	50.9775	111980.0
2019-07-15 09:00:00	AAPL	Stock	50.9675	51.4675	50.965	51.29	14681300.0
2019-07-15 10:00:00	AAPL	Stock	51.286	51.3525	51.215	51.2325	8902364.0
2019-07-15 11:00:00	AAPL	Stock	51.2325	51.2738	51.1825	51.2088	4724792.0
2019-07-15 12:00:00	AAPL	Stock	51.2125	51.2325	51.03	51.11	5052664.0
2019-07-15 13:00:00	AAPL	Stock	51.1088	51.2425	51.105	51.23	3672176.0
2019-07-15 14:00:00	AAPL	Stock	51.2288	51.2825	51.2175	51.2675	3850368.0
2019-07-15 15:00:00	AAPL	Stock	51.2675	51.305	51.19	51.3	7702128.0
2019-07-15 16:00:00	AAPL	Stock	51.3	51.3025	51.275	51.2775	6711032.0
2019-07-15 17:00:00	AAPL	Stock	51.2775	51.2975	51.275	51.2975	23860.0
2019-07-15 18:00:00	AAPL	Stock	51.2975	51.2975	51.275	51.275	7300.0
2019-07-15 19:00:00	AAPL	Stock	51.2975	51.3	51.2875	51.2975	23864.0
2019-07-15 04:00:00	MSFT	Stock	139.46	139.46	139.0	139.2	1780.0
2019-07-15 05:00:00	MSFT	Stock	139.25	139.25	139.0	139.15	1339.0
2019-07-15 06:00:00	MSFT	Stock	139.15	139.35	139.15	139.35	1250.0
2019-07-15 07:00:00	MSFT	Stock	139.2	139.4	139.2	139.3	6414.0
2019-07-15 08:00:00	MSFT	Stock	139.25	139.49	138.9	139.474	287571.0
2019-07-15 09:00:00	MSFT	Stock	139.447	139.635	138.46	138.93	2299168.0
2019-07-15 10:00:00	MSFT	Stock	138.935	138.99	138.56	138.86	1894579.0
2019-07-15 11:00:00	MSFT	Stock	138.86	139.0	138.715	138.81	1523172.0
2019-07-15 12:00:00	MSFT	Stock	138.815	138.9	138.69	138.77	994424.0
2019-07-15 13:00:00	MSFT	Stock	138.76	138.89	138.71	138.8	864065.0
2019-07-15 14:00:00	MSFT	Stock	138.8	139.0	138.76	138.902	1326344.0
2019-07-15 15:00:00	MSFT	Stock	138.905	139.0	138.65	138.94	2721529.0
2019-07-15 16:00:00	MSFT	Stock	138.9	138.98	138.867	138.9	2034682.0
2019-07-15 17:00:00	MSFT	Stock	138.94	138.94	138.72	138.93	4498.0
2019-07-15 18:00:00	MSFT	Stock	138.9	138.92	138.81	138.92	578.0
2019-07-15 19:00:00	MSFT	Stock	138.89	138.96	138.85	138.96	2781.0
2019-07-15 04:00:00	NVDA	Stock	4.1965	4.2218	4.1965	4.2125	26560.0
2019-07-15 05:00:00	NVDA	Stock	4.209	4.209	4.209	4.209	5000.0
2019-07-15 06:00:00	NVDA	Stock	4.1987	4.1987	4.1987	4.1987	12720.0
2019-07-15 07:00:00	NVDA	Stock	4.205	4.225	4.1925	4.2208	476240.0
2019-07-15 08:00:00	NVDA	Stock	4.2	4.225	4.195	4.2138	1238280.0
2019-07-15 09:00:00	NVDA	Stock	4.2138	4.2276	4.1638	4.1778	65912960.0
2019-07-15 10:00:00	NVDA	Stock	4.1772	4.1862	4.1556	4.1648	38429640.0
2019-07-15 11:00:00	NVDA	Stock	4.166	4.188	4.1565	4.1858	40375760.0
2019-07-15 12:00:00	NVDA	Stock	4.1862	4.1873	4.1532	4.1552	25127960.0
2019-07-15 13:00:00	NVDA	Stock	4.1555	4.1742	4.155	4.1705	20664520.0
2019-07-15 14:00:00	NVDA	Stock	4.1702	4.1768	4.1622	4.1759	16653960.0
2019-07-15 15:00:00	NVDA	Stock	4.176	4.1832	4.1675	4.1828	36865680.0
2019-07-15 16:00:00	NVDA	Stock	4.1818	4.19	4.18	4.1858	15361840.0
2019-07-15 17:00:00	NVDA	Stock	4.1851	4.1851	4.1832	4.1845	171240.0
2019-07-15 18:00:00	NVDA	Stock	4.1845	4.1868	4.1828	4.1855	306360.0
2019-07-15 19:00:00	NVDA	Stock	4.1868	4.1888	4.1835	4.1873	284440.0
2019-07-15 04:00:00	AMZN	Stock	100.725	100.95	100.725	100.95	14980.0
2019-07-15 05:00:00	AMZN	Stock	100.825	100.855	100.825	100.855	13700.0

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

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