PREVIEW / stock_1hour / 2020-01-29

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-01-29.parquet
  size:    1.1 MB
  rows:    50,714
  symbols: 2,428

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-29 04:00:00	AAPL	Stock	81.0625	81.1625	80.8	81.1075	124604.0
2020-01-29 05:00:00	AAPL	Stock	81.08	81.15	80.9375	81.1475	69460.0
2020-01-29 06:00:00	AAPL	Stock	81.1375	81.2675	80.92	80.9625	165168.0
2020-01-29 07:00:00	AAPL	Stock	80.9625	81.1025	80.6475	80.775	771372.0
2020-01-29 08:00:00	AAPL	Stock	80.975	81.2125	80.65	80.8325	2005060.0
2020-01-29 09:00:00	AAPL	Stock	80.8275	81.8125	80.665	80.84	41592824.0
2020-01-29 10:00:00	AAPL	Stock	80.835	81.375	80.345	81.3475	36011124.0
2020-01-29 11:00:00	AAPL	Stock	81.345	81.95	81.31	81.7875	29029108.0
2020-01-29 12:00:00	AAPL	Stock	81.7917	81.9075	81.53	81.585	14781240.0
2020-01-29 13:00:00	AAPL	Stock	81.585	81.73	81.365	81.6675	9896776.0
2020-01-29 14:00:00	AAPL	Stock	81.6675	81.9625	81.5625	81.7575	15567316.0
2020-01-29 15:00:00	AAPL	Stock	81.7612	81.8875	81.0175	81.08	25412136.0
2020-01-29 16:00:00	AAPL	Stock	81.085	81.215	80.7775	81.0	9482132.0
2020-01-29 17:00:00	AAPL	Stock	80.995	81.0675	80.9375	81.045	145232.0
2020-01-29 18:00:00	AAPL	Stock	81.0625	81.1875	80.97	81.025	184368.0
2020-01-29 19:00:00	AAPL	Stock	81.005	81.07	80.8125	81.0375	240112.0
2020-01-29 04:00:00	MSFT	Stock	166.55	166.99	166.55	166.73	8627.0
2020-01-29 05:00:00	MSFT	Stock	166.75	166.75	166.66	166.75	3822.0
2020-01-29 06:00:00	MSFT	Stock	166.75	167.0	166.7	166.7	9379.0
2020-01-29 07:00:00	MSFT	Stock	166.95	167.4	166.9	167.28	105681.0
2020-01-29 08:00:00	MSFT	Stock	167.25	167.42	166.9	167.3	156379.0
2020-01-29 09:00:00	MSFT	Stock	167.3	168.05	166.09	166.37	4137688.0
2020-01-29 10:00:00	MSFT	Stock	166.36	167.15	165.69	167.08	3454988.0
2020-01-29 11:00:00	MSFT	Stock	167.075	167.3	166.89	167.23	2264899.0
2020-01-29 12:00:00	MSFT	Stock	167.23	168.1	167.215	167.88	2358540.0
2020-01-29 13:00:00	MSFT	Stock	167.885	168.38	167.46	168.12	1971008.0
2020-01-29 14:00:00	MSFT	Stock	168.1	168.75	167.97	168.403	2748684.0
2020-01-29 15:00:00	MSFT	Stock	168.41	168.5	167.61	168.18	5200522.0
2020-01-29 16:00:00	MSFT	Stock	168.04	173.11	167.5	173.11	6161777.0
2020-01-29 17:00:00	MSFT	Stock	173.14	173.69	172.3	173.3	411877.0
2020-01-29 18:00:00	MSFT	Stock	173.65	176.2	173.3	175.22	620989.0
2020-01-29 19:00:00	MSFT	Stock	175.16	175.43	174.3	175.0	148152.0
2020-01-29 04:00:00	NVDA	Stock	6.1678	6.1678	6.1432	6.1432	9000.0
2020-01-29 05:00:00	NVDA	Stock	6.1625	6.1648	6.1603	6.1648	20000.0
2020-01-29 06:00:00	NVDA	Stock	6.1655	6.1875	6.1655	6.175	66000.0
2020-01-29 07:00:00	NVDA	Stock	6.1822	6.1985	6.1382	6.1695	247320.0
2020-01-29 08:00:00	NVDA	Stock	6.155	6.1874	6.1385	6.1595	739320.0
2020-01-29 09:00:00	NVDA	Stock	6.1572	6.221	6.145	6.162	49214000.0
2020-01-29 10:00:00	NVDA	Stock	6.1603	6.1615	6.1136	6.1308	47774160.0
2020-01-29 11:00:00	NVDA	Stock	6.1324	6.1418	6.0985	6.1238	34762720.0
2020-01-29 12:00:00	NVDA	Stock	6.1212	6.1572	6.1178	6.1448	19146760.0
2020-01-29 13:00:00	NVDA	Stock	6.1452	6.1615	6.136	6.1568	14285640.0
2020-01-29 14:00:00	NVDA	Stock	6.157	6.1843	6.145	6.1673	21747480.0
2020-01-29 15:00:00	NVDA	Stock	6.169	6.1722	6.134	6.1385	28905640.0
2020-01-29 16:00:00	NVDA	Stock	6.1385	6.15	6.128	6.1373	18867760.0
2020-01-29 17:00:00	NVDA	Stock	6.1368	6.1373	6.1225	6.1322	321560.0
2020-01-29 18:00:00	NVDA	Stock	6.1322	6.147	6.1322	6.1388	505600.0
2020-01-29 19:00:00	NVDA	Stock	6.1385	6.14	6.1275	6.14	127840.0
2020-01-29 04:00:00	AMZN	Stock	93.0	93.0	93.0	93.0	3700.0
2020-01-29 05:00:00	AMZN	Stock	92.95	92.95	92.95	92.95	15960.0

> showing 50 of 50,714 rows — these rows as CSV

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