PREVIEW / stock_1hour / 2019-11-11

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-11-11.parquet
  size:    1.1 MB
  rows:    49,684
  symbols: 2,482

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-11-11 04:00:00	AAPL	Stock	64.775	64.775	64.5475	64.5925	31656.0
2019-11-11 05:00:00	AAPL	Stock	64.625	64.6875	64.545	64.5875	28040.0
2019-11-11 06:00:00	AAPL	Stock	64.5875	64.65	64.5875	64.65	11428.0
2019-11-11 07:00:00	AAPL	Stock	64.66	64.6725	64.5875	64.625	93852.0
2019-11-11 08:00:00	AAPL	Stock	64.6125	64.6875	64.5925	64.6375	218224.0
2019-11-11 09:00:00	AAPL	Stock	64.6425	64.9	64.5675	64.825	10465080.0
2019-11-11 10:00:00	AAPL	Stock	64.825	65.1475	64.7675	65.0225	10469172.0
2019-11-11 11:00:00	AAPL	Stock	65.0238	65.18	65.015	65.122	6640596.0
2019-11-11 12:00:00	AAPL	Stock	65.1275	65.3888	65.095	65.3762	8033596.0
2019-11-11 13:00:00	AAPL	Stock	65.3775	65.6175	65.3575	65.571	8468252.0
2019-11-11 14:00:00	AAPL	Stock	65.5675	65.5675	65.3675	65.4	5920460.0
2019-11-11 15:00:00	AAPL	Stock	65.4025	65.5575	65.385	65.55	8648144.0
2019-11-11 16:00:00	AAPL	Stock	65.55	65.5875	65.5175	65.5875	3472832.0
2019-11-11 17:00:00	AAPL	Stock	65.5825	65.6075	65.55	65.585	2821324.0
2019-11-11 18:00:00	AAPL	Stock	65.585	65.6	65.57	65.5775	65544.0
2019-11-11 19:00:00	AAPL	Stock	65.575	65.6125	65.5375	65.6	133064.0
2019-11-11 04:00:00	MSFT	Stock	145.51	145.59	145.3	145.59	646.0
2019-11-11 05:00:00	MSFT	Stock	145.43	145.45	145.22	145.45	2978.0
2019-11-11 06:00:00	MSFT	Stock	145.45	145.74	145.4	145.5	5392.0
2019-11-11 07:00:00	MSFT	Stock	145.59	145.7	145.38	145.55	18854.0
2019-11-11 08:00:00	MSFT	Stock	145.533	145.73	145.36	145.6	48029.0
2019-11-11 09:00:00	MSFT	Stock	145.6	145.78	144.73	145.62	2395071.0
2019-11-11 10:00:00	MSFT	Stock	145.62	145.94	145.27	145.665	1573787.0
2019-11-11 11:00:00	MSFT	Stock	145.67	145.88	145.435	145.845	1150806.0
2019-11-11 12:00:00	MSFT	Stock	145.84	146.15	145.77	146.087	1221435.0
2019-11-11 13:00:00	MSFT	Stock	146.085	146.27	146.06	146.14	1184506.0
2019-11-11 14:00:00	MSFT	Stock	146.14	146.42	146.114	146.21	1259921.0
2019-11-11 15:00:00	MSFT	Stock	146.21	146.255	145.765	146.12	2279572.0
2019-11-11 16:00:00	MSFT	Stock	146.12	146.41	146.004	146.41	1154498.0
2019-11-11 17:00:00	MSFT	Stock	146.36	146.42	146.31	146.36	5243.0
2019-11-11 18:00:00	MSFT	Stock	146.38	146.38	146.23	146.3	4155.0
2019-11-11 19:00:00	MSFT	Stock	146.23	146.32	146.19	146.32	3226.0
2019-11-11 04:00:00	NVDA	Stock	5.175	5.175	5.15	5.1575	132200.0
2019-11-11 05:00:00	NVDA	Stock	5.151	5.151	5.15	5.15	24400.0
2019-11-11 06:00:00	NVDA	Stock	5.1565	5.1648	5.1565	5.1625	54000.0
2019-11-11 07:00:00	NVDA	Stock	5.1698	5.175	5.1638	5.175	130000.0
2019-11-11 08:00:00	NVDA	Stock	5.1634	5.2098	5.1615	5.2085	1058160.0
2019-11-11 09:00:00	NVDA	Stock	5.206	5.2362	5.107	5.13	49203440.0
2019-11-11 10:00:00	NVDA	Stock	5.1288	5.1691	5.1283	5.16	29256360.0
2019-11-11 11:00:00	NVDA	Stock	5.1615	5.1955	5.1556	5.1897	22346480.0
2019-11-11 12:00:00	NVDA	Stock	5.1903	5.2278	5.1868	5.2219	34554080.0
2019-11-11 13:00:00	NVDA	Stock	5.2222	5.2232	5.2058	5.2135	13210840.0
2019-11-11 14:00:00	NVDA	Stock	5.213	5.2178	5.1981	5.2118	22988520.0
2019-11-11 15:00:00	NVDA	Stock	5.2123	5.2175	5.2003	5.2033	25764680.0
2019-11-11 16:00:00	NVDA	Stock	5.2045	5.2058	5.1992	5.203	6969320.0
2019-11-11 17:00:00	NVDA	Stock	5.205	5.2088	5.203	5.2045	7037440.0
2019-11-11 18:00:00	NVDA	Stock	5.2075	5.2075	5.2025	5.2038	140680.0
2019-11-11 19:00:00	NVDA	Stock	5.2045	5.2095	5.2025	5.2075	194240.0
2019-11-11 06:00:00	AMZN	Stock	88.955	88.955	88.955	88.955	4020.0
2019-11-11 07:00:00	AMZN	Stock	88.911	89.0375	88.911	88.925	53820.0

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

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