PREVIEW / stock_1hour / 2020-10-14

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-10-14.parquet
  size:    1.2 MB
  rows:    56,582
  symbols: 2,495

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-10-14 04:00:00	AAPL	Stock	121.55	122.57	121.31	122.19	113711.0
2020-10-14 05:00:00	AAPL	Stock	122.25	122.31	121.28	121.35	58618.0
2020-10-14 06:00:00	AAPL	Stock	121.42	121.57	120.6	120.9	94185.0
2020-10-14 07:00:00	AAPL	Stock	121.06	121.6	120.73	121.42	413379.0
2020-10-14 08:00:00	AAPL	Stock	120.85	121.6	120.73	121.28	920508.0
2020-10-14 09:00:00	AAPL	Stock	121.29	123.03	120.04	122.68	23837853.0
2020-10-14 10:00:00	AAPL	Stock	122.691	122.82	121.18	122.116	22797782.0
2020-10-14 11:00:00	AAPL	Stock	122.13	122.27	120.72	120.815	15546323.0
2020-10-14 12:00:00	AAPL	Stock	120.83	121.33	119.71	120.28	19229981.0
2020-10-14 13:00:00	AAPL	Stock	120.28	120.77	119.62	120.55	13463035.0
2020-10-14 14:00:00	AAPL	Stock	120.54	121.37	120.501	121.19	14498745.0
2020-10-14 15:00:00	AAPL	Stock	121.18	122.0	121.03	121.29	20073811.0
2020-10-14 16:00:00	AAPL	Stock	121.24	121.25	120.7	120.76	8324321.0
2020-10-14 17:00:00	AAPL	Stock	120.78	120.92	120.65	120.88	118328.0
2020-10-14 18:00:00	AAPL	Stock	120.89	121.18	120.71	120.9	201450.0
2020-10-14 19:00:00	AAPL	Stock	120.9	121.2	120.76	120.81	149806.0
2020-10-14 04:00:00	MSFT	Stock	224.03	224.75	223.75	224.02	3742.0
2020-10-14 05:00:00	MSFT	Stock	223.53	223.53	223.05	223.29	1816.0
2020-10-14 06:00:00	MSFT	Stock	223.46	223.46	221.51	223.0	6249.0
2020-10-14 07:00:00	MSFT	Stock	223.0	224.25	223.0	224.03	21449.0
2020-10-14 08:00:00	MSFT	Stock	223.42	224.67	223.22	224.02	40463.0
2020-10-14 09:00:00	MSFT	Stock	224.18	224.22	221.94	223.47	2409423.0
2020-10-14 10:00:00	MSFT	Stock	223.485	223.67	221.95	222.685	2444073.0
2020-10-14 11:00:00	MSFT	Stock	222.69	223.24	220.53	220.708	2220242.0
2020-10-14 12:00:00	MSFT	Stock	220.73	221.11	219.42	219.832	2525939.0
2020-10-14 13:00:00	MSFT	Stock	219.82	220.7	219.13	220.6	1907376.0
2020-10-14 14:00:00	MSFT	Stock	220.58	221.21	220.27	220.97	1890345.0
2020-10-14 15:00:00	MSFT	Stock	220.99	221.97	220.6	220.93	3368095.0
2020-10-14 16:00:00	MSFT	Stock	220.93	223.396	220.13	220.42	3055164.0
2020-10-14 17:00:00	MSFT	Stock	220.54	220.59	220.5	220.502	3737.0
2020-10-14 18:00:00	MSFT	Stock	220.6	221.1	220.37	220.84	6258.0
2020-10-14 19:00:00	MSFT	Stock	220.6	220.79	220.3	220.3	17789.0
2020-10-14 04:00:00	NVDA	Stock	14.375	14.375	14.375	14.375	8400.0
2020-10-14 05:00:00	NVDA	Stock	14.321	14.321	14.3	14.3	21280.0
2020-10-14 06:00:00	NVDA	Stock	14.25	14.2588	14.2005	14.2005	57960.0
2020-10-14 07:00:00	NVDA	Stock	14.2315	14.3275	14.2312	14.3	570800.0
2020-10-14 08:00:00	NVDA	Stock	14.2267	14.325	14.2267	14.2965	1203280.0
2020-10-14 09:00:00	NVDA	Stock	14.2785	14.3428	14.1625	14.2198	41034520.0
2020-10-14 10:00:00	NVDA	Stock	14.2202	14.2358	14.0885	14.1865	38128200.0
2020-10-14 11:00:00	NVDA	Stock	14.1825	14.1975	14.0522	14.0609	22370240.0
2020-10-14 12:00:00	NVDA	Stock	14.0596	14.1118	13.96	14.0534	36507320.0
2020-10-14 13:00:00	NVDA	Stock	14.05	14.1058	13.9938	14.0896	17536400.0
2020-10-14 14:00:00	NVDA	Stock	14.0912	14.1335	14.05	14.1072	24068200.0
2020-10-14 15:00:00	NVDA	Stock	14.1102	14.1838	14.0832	14.0902	33499120.0
2020-10-14 16:00:00	NVDA	Stock	14.089	14.0966	14.05	14.05	27387920.0
2020-10-14 17:00:00	NVDA	Stock	14.0625	14.07	14.05	14.0698	256840.0
2020-10-14 18:00:00	NVDA	Stock	14.0875	14.0998	14.05	14.05	238840.0
2020-10-14 19:00:00	NVDA	Stock	14.075	14.075	14.05	14.05	202560.0
2020-10-14 04:00:00	AMZN	Stock	173.25	173.25	173.25	173.25	4000.0
2020-10-14 05:00:00	AMZN	Stock	172.75	172.75	172.75	172.75	4880.0

> showing 50 of 56,582 rows — these rows as CSV

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