PREVIEW / stock_1hour / 2021-11-22

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-11-22.parquet
  size:    1.5 MB
  rows:    68,112
  symbols: 2,712

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
2021-11-22 04:00:00	AAPL	Stock	161.15	161.2	160.8	161.15	52613.0
2021-11-22 05:00:00	AAPL	Stock	161.19	161.2	160.9	160.97	39608.0
2021-11-22 06:00:00	AAPL	Stock	161.0	161.11	160.98	161.11	31175.0
2021-11-22 07:00:00	AAPL	Stock	161.07	161.67	161.06	161.52	180199.0
2021-11-22 08:00:00	AAPL	Stock	161.47	161.75	161.08	161.72	487913.0
2021-11-22 09:00:00	AAPL	Stock	161.69	164.78	161.46	164.69	17386300.0
2021-11-22 10:00:00	AAPL	Stock	164.67	165.7	164.52	164.7425	23662088.0
2021-11-22 11:00:00	AAPL	Stock	164.7	165.22	163.04	163.54	15666802.0
2021-11-22 12:00:00	AAPL	Stock	163.5201	164.38	163.04	163.945	10988940.0
2021-11-22 13:00:00	AAPL	Stock	163.945	163.98	163.33	163.68	5921881.0
2021-11-22 14:00:00	AAPL	Stock	163.69	164.28	163.6	163.7989	5946834.0
2021-11-22 15:00:00	AAPL	Stock	163.8	164.0	161.0	161.08	14271820.0
2021-11-22 16:00:00	AAPL	Stock	161.08	161.3	160.52	161.25	6579018.0
2021-11-22 17:00:00	AAPL	Stock	161.3	161.45	161.02	161.11	110118.0
2021-11-22 18:00:00	AAPL	Stock	161.11	161.5	161.1	161.38	68811.0
2021-11-22 19:00:00	AAPL	Stock	161.2501	161.5	161.05	161.5	55610.0
2021-11-22 04:00:00	MSFT	Stock	344.1	344.61	343.6	344.61	7551.0
2021-11-22 05:00:00	MSFT	Stock	344.69	344.93	344.0	344.0	7029.0
2021-11-22 06:00:00	MSFT	Stock	344.39	344.53	344.02	344.53	6142.0
2021-11-22 07:00:00	MSFT	Stock	344.59	344.59	343.85	344.08	19910.0
2021-11-22 08:00:00	MSFT	Stock	344.3272	344.6986	343.75	343.9175	43684.0
2021-11-22 09:00:00	MSFT	Stock	343.97	348.38	343.41	346.91	3010072.0
2021-11-22 10:00:00	MSFT	Stock	346.96	349.67	346.96	347.68	3674846.0
2021-11-22 11:00:00	MSFT	Stock	347.7	348.085	342.86	343.64	3592422.0
2021-11-22 12:00:00	MSFT	Stock	343.58	343.89	341.59	342.22	2451491.0
2021-11-22 13:00:00	MSFT	Stock	342.23	343.13	341.74	342.59	1144669.0
2021-11-22 14:00:00	MSFT	Stock	342.6	343.87	342.5	343.31	1343248.0
2021-11-22 15:00:00	MSFT	Stock	343.32	343.85	339.55	339.89	2819122.0
2021-11-22 16:00:00	MSFT	Stock	339.83	339.99	339.49	339.9	4490477.0
2021-11-22 17:00:00	MSFT	Stock	339.9	339.9	339.75	339.8999	8419.0
2021-11-22 18:00:00	MSFT	Stock	339.97	340.45	339.97	340.25	9662.0
2021-11-22 19:00:00	MSFT	Stock	340.11	340.22	339.88	340.12	12419.0
2021-11-22 04:00:00	NVDA	Stock	33.521	33.603	33.352	33.405	514360.0
2021-11-22 05:00:00	NVDA	Stock	33.427	33.475	33.41	33.418	119340.0
2021-11-22 06:00:00	NVDA	Stock	33.443	33.514	33.418	33.49	166390.0
2021-11-22 07:00:00	NVDA	Stock	33.457	33.83	33.435	33.672	1376520.0
2021-11-22 08:00:00	NVDA	Stock	33.5714	33.839	33.435	33.787	3336580.0
2021-11-22 09:00:00	NVDA	Stock	33.781	34.5484	33.35	34.1281	87475380.0
2021-11-22 10:00:00	NVDA	Stock	34.132	34.647	34.034	34.289	83201120.0
2021-11-22 11:00:00	NVDA	Stock	34.284	34.371	32.3	32.617	133552900.0
2021-11-22 12:00:00	NVDA	Stock	32.6043	33.099	32.146	32.7795	80745490.0
2021-11-22 13:00:00	NVDA	Stock	32.7773	33.038	32.554	32.5633	49863440.0
2021-11-22 14:00:00	NVDA	Stock	32.575	32.787	32.451	32.491	40673680.0
2021-11-22 15:00:00	NVDA	Stock	32.491	32.849	31.9	31.914	68061490.0
2021-11-22 16:00:00	NVDA	Stock	31.913	32.048	31.85	32.02	20049320.0
2021-11-22 17:00:00	NVDA	Stock	32.021	32.073	31.9	31.95	439110.0
2021-11-22 18:00:00	NVDA	Stock	31.94	32.045	31.922	31.982	589630.0
2021-11-22 19:00:00	NVDA	Stock	31.98	32.018	31.95	31.975	506040.0
2021-11-22 04:00:00	AMZN	Stock	184.4075	185.0	184.4075	184.9	23120.0
2021-11-22 06:00:00	AMZN	Stock	184.8	184.8675	184.8	184.8	10520.0

> showing 50 of 68,112 rows — these rows as CSV

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