PREVIEW / stock_1hour / 2020-07-23

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-07-23.parquet
  size:    1.2 MB
  rows:    56,496
  symbols: 2,447

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-07-23 04:00:00	AAPL	Stock	97.7375	97.895	97.7025	97.7025	16928.0
2020-07-23 05:00:00	AAPL	Stock	97.7025	97.75	97.64	97.685	13192.0
2020-07-23 06:00:00	AAPL	Stock	97.64	97.9	97.64	97.73	18752.0
2020-07-23 07:00:00	AAPL	Stock	97.75	97.895	97.335	97.4975	248368.0
2020-07-23 08:00:00	AAPL	Stock	97.3775	97.8952	97.055	97.0875	337780.0
2020-07-23 09:00:00	AAPL	Stock	97.075	97.2125	96.4725	96.675	9218932.0
2020-07-23 10:00:00	AAPL	Stock	96.675	96.7875	95.7225	95.7875	15070112.0
2020-07-23 11:00:00	AAPL	Stock	95.7852	96.0375	95.5875	95.71	10887952.0
2020-07-23 12:00:00	AAPL	Stock	95.7025	95.7025	94.1625	94.5975	20117748.0
2020-07-23 13:00:00	AAPL	Stock	94.5975	94.9675	93.25	93.485	19544332.0
2020-07-23 14:00:00	AAPL	Stock	93.4788	93.5175	92.0825	93.127	31156840.0
2020-07-23 15:00:00	AAPL	Stock	93.1275	93.185	92.0098	92.89	30961636.0
2020-07-23 16:00:00	AAPL	Stock	92.865	93.0	92.5125	92.7025	10087132.0
2020-07-23 17:00:00	AAPL	Stock	92.725	92.8075	92.655	92.7125	110748.0
2020-07-23 18:00:00	AAPL	Stock	92.775	93.205	92.775	93.135	193708.0
2020-07-23 19:00:00	AAPL	Stock	93.1625	93.1625	92.895	93.1125	146028.0
2020-07-23 04:00:00	MSFT	Stock	208.75	208.75	207.83	207.83	41660.0
2020-07-23 05:00:00	MSFT	Stock	207.8	208.8	207.48	207.9	39746.0
2020-07-23 06:00:00	MSFT	Stock	207.9	208.8	206.6	206.99	77325.0
2020-07-23 07:00:00	MSFT	Stock	207.19	208.89	206.75	208.36	247171.0
2020-07-23 08:00:00	MSFT	Stock	208.35	208.9	206.8	207.95	424776.0
2020-07-23 09:00:00	MSFT	Stock	207.86	210.92	206.91	209.653	9398912.0
2020-07-23 10:00:00	MSFT	Stock	209.63	209.67	207.15	207.81	6967787.0
2020-07-23 11:00:00	MSFT	Stock	207.82	208.27	206.97	207.64	4648953.0
2020-07-23 12:00:00	MSFT	Stock	207.654	207.654	204.42	205.605	7368315.0
2020-07-23 13:00:00	MSFT	Stock	205.605	206.3	203.35	204.44	5384675.0
2020-07-23 14:00:00	MSFT	Stock	204.41	204.6	202.48	203.13	6750294.0
2020-07-23 15:00:00	MSFT	Stock	203.135	203.79	202.19	202.6	9088320.0
2020-07-23 16:00:00	MSFT	Stock	202.15	203.11	202.1	202.74	3619724.0
2020-07-23 17:00:00	MSFT	Stock	202.74	203.39	202.6	203.3	39184.0
2020-07-23 18:00:00	MSFT	Stock	203.25	203.92	203.25	203.6	53890.0
2020-07-23 19:00:00	MSFT	Stock	203.6	203.85	203.22	203.6	36167.0
2020-07-23 04:00:00	NVDA	Stock	10.4565	10.4698	10.4562	10.4698	167400.0
2020-07-23 06:00:00	NVDA	Stock	10.495	10.5	10.495	10.5	12840.0
2020-07-23 07:00:00	NVDA	Stock	10.485	10.4925	10.4625	10.4732	378240.0
2020-07-23 08:00:00	NVDA	Stock	10.495	10.4988	10.4363	10.4644	1269960.0
2020-07-23 09:00:00	NVDA	Stock	10.457	10.5182	10.3688	10.4794	43232920.0
2020-07-23 10:00:00	NVDA	Stock	10.4799	10.547	10.418	10.5079	58317640.0
2020-07-23 11:00:00	NVDA	Stock	10.505	10.5256	10.444	10.4505	28098680.0
2020-07-23 12:00:00	NVDA	Stock	10.4475	10.449	10.137	10.2103	85439160.0
2020-07-23 13:00:00	NVDA	Stock	10.2138	10.2598	10.0855	10.1382	50100400.0
2020-07-23 14:00:00	NVDA	Stock	10.1345	10.1534	10.0312	10.135	59355880.0
2020-07-23 15:00:00	NVDA	Stock	10.1375	10.1625	10.0628	10.1365	56870400.0
2020-07-23 16:00:00	NVDA	Stock	10.1298	10.2538	10.0513	10.1763	9331040.0
2020-07-23 17:00:00	NVDA	Stock	10.1763	10.246	10.125	10.1338	2203280.0
2020-07-23 18:00:00	NVDA	Stock	10.1353	10.1703	10.1	10.1075	1386040.0
2020-07-23 19:00:00	NVDA	Stock	10.103	10.125	10.085	10.105	513360.0
2020-07-23 04:00:00	AMZN	Stock	155.6605	155.735	155.6605	155.735	17920.0
2020-07-23 06:00:00	AMZN	Stock	155.7495	156.0	155.7495	156.0	15760.0
2020-07-23 07:00:00	AMZN	Stock	156.0	156.0	155.32	155.402	86700.0

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

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