PREVIEW / stock_1hour / 2021-03-10

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-03-10.parquet
  size:    1.5 MB
  rows:    67,903
  symbols: 2,890

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-03-10 04:00:00	AAPL	Stock	121.5	121.51	120.0	120.8	130116.0
2021-03-10 05:00:00	AAPL	Stock	120.81	121.16	120.49	120.49	28807.0
2021-03-10 06:00:00	AAPL	Stock	120.25	120.51	119.69	120.51	138682.0
2021-03-10 07:00:00	AAPL	Stock	120.51	120.85	119.99	120.55	319559.0
2021-03-10 08:00:00	AAPL	Stock	120.48	121.69	120.0	121.69	1465056.0
2021-03-10 09:00:00	AAPL	Stock	121.68	122.17	120.11	120.71	18576832.0
2021-03-10 10:00:00	AAPL	Stock	120.71	121.13	119.45	119.88	18389279.0
2021-03-10 11:00:00	AAPL	Stock	119.885	120.5	119.47	120.34	11783094.0
2021-03-10 12:00:00	AAPL	Stock	120.34	120.49	119.59	120.185	8918406.0
2021-03-10 13:00:00	AAPL	Stock	120.19	120.48	119.55	120.01	10550544.0
2021-03-10 14:00:00	AAPL	Stock	119.99	120.92	119.81	120.67	8141205.0
2021-03-10 15:00:00	AAPL	Stock	120.67	120.83	119.86	119.97	11556137.0
2021-03-10 16:00:00	AAPL	Stock	119.97	120.14	119.91	120.07	5556831.0
2021-03-10 17:00:00	AAPL	Stock	120.06	120.15	120.04	120.15	68165.0
2021-03-10 18:00:00	AAPL	Stock	120.15	120.2	120.09	120.1	78569.0
2021-03-10 19:00:00	AAPL	Stock	120.12	120.12	119.88	119.93	106090.0
2021-03-10 04:00:00	MSFT	Stock	233.6	233.78	233.0	233.78	3086.0
2021-03-10 05:00:00	MSFT	Stock	233.78	234.03	233.5	233.5	1373.0
2021-03-10 06:00:00	MSFT	Stock	233.0	233.03	232.66	233.03	1047.0
2021-03-10 07:00:00	MSFT	Stock	233.25	233.84	233.0	233.32	13548.0
2021-03-10 08:00:00	MSFT	Stock	233.25	235.59	232.39	235.1	76322.0
2021-03-10 09:00:00	MSFT	Stock	234.98	237.03	234.98	235.22	3247789.0
2021-03-10 10:00:00	MSFT	Stock	235.29	236.03	233.81	234.51	3313958.0
2021-03-10 11:00:00	MSFT	Stock	234.549	235.59	234.06	235.11	2062923.0
2021-03-10 12:00:00	MSFT	Stock	235.11	235.15	234.09	235.07	1889230.0
2021-03-10 13:00:00	MSFT	Stock	235.07	235.08	232.2175	232.81	2596664.0
2021-03-10 14:00:00	MSFT	Stock	232.8	233.5	232.09	233.27	1965996.0
2021-03-10 15:00:00	MSFT	Stock	233.28	233.55	232.04	232.39	3107476.0
2021-03-10 16:00:00	MSFT	Stock	232.42	232.75	231.87	232.75	2430556.0
2021-03-10 17:00:00	MSFT	Stock	232.5271	232.75	232.42	232.72	76140.0
2021-03-10 18:00:00	MSFT	Stock	232.75	232.75	232.55	232.57	9693.0
2021-03-10 19:00:00	MSFT	Stock	232.68	232.69	232.16	232.16	7217.0
2021-03-10 04:00:00	NVDA	Stock	12.513	12.513	12.513	12.513	4000.0
2021-03-10 05:00:00	NVDA	Stock	12.625	12.625	12.5502	12.5502	78080.0
2021-03-10 06:00:00	NVDA	Stock	12.525	12.5462	12.4385	12.475	29320.0
2021-03-10 07:00:00	NVDA	Stock	12.4875	12.5492	12.4875	12.4875	231480.0
2021-03-10 08:00:00	NVDA	Stock	12.519	12.6933	12.455	12.6933	1163640.0
2021-03-10 09:00:00	NVDA	Stock	12.6625	12.98	12.634	12.8475	59779120.0
2021-03-10 10:00:00	NVDA	Stock	12.853	12.962	12.5332	12.6989	60873960.0
2021-03-10 11:00:00	NVDA	Stock	12.6968	12.7678	12.5883	12.6925	18808320.0
2021-03-10 12:00:00	NVDA	Stock	12.702	12.7025	12.477	12.6406	14459880.0
2021-03-10 13:00:00	NVDA	Stock	12.6545	12.6562	12.4603	12.5276	16967720.0
2021-03-10 14:00:00	NVDA	Stock	12.5259	12.6472	12.4945	12.5933	13067600.0
2021-03-10 15:00:00	NVDA	Stock	12.597	12.6215	12.4575	12.4683	27787400.0
2021-03-10 16:00:00	NVDA	Stock	12.4683	12.5125	12.465	12.5125	19563920.0
2021-03-10 17:00:00	NVDA	Stock	12.5125	12.5188	12.5005	12.5005	33720.0
2021-03-10 18:00:00	NVDA	Stock	12.5025	12.504	12.5	12.504	23360.0
2021-03-10 19:00:00	NVDA	Stock	12.4998	12.4998	12.4638	12.475	146600.0
2021-03-10 04:00:00	AMZN	Stock	153.5	153.5	153.5	153.5	2000.0
2021-03-10 05:00:00	AMZN	Stock	153.5035	153.5035	153.5035	153.5035	2000.0

> showing 50 of 67,903 rows — these rows as CSV

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