PREVIEW / stock_1hour / 2020-09-21

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-09-21.parquet
  size:    1.3 MB
  rows:    58,893
  symbols: 2,496

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-09-21 04:00:00	AAPL	Stock	105.64	105.68	103.92	104.37	251992.0
2020-09-21 05:00:00	AAPL	Stock	104.36	105.23	103.91	104.05	159122.0
2020-09-21 06:00:00	AAPL	Stock	104.08	105.2	104.0	105.2	161898.0
2020-09-21 07:00:00	AAPL	Stock	105.15	105.44	103.36	104.49	1483942.0
2020-09-21 08:00:00	AAPL	Stock	104.52	105.35	103.38	104.47	2063513.0
2020-09-21 09:00:00	AAPL	Stock	104.44	107.85	103.1	107.36	29338942.0
2020-09-21 10:00:00	AAPL	Stock	107.36	107.7	104.56	105.22	30944671.0
2020-09-21 11:00:00	AAPL	Stock	105.225	106.51	104.9	106.47	18913844.0
2020-09-21 12:00:00	AAPL	Stock	106.471	107.57	106.471	106.785	18253144.0
2020-09-21 13:00:00	AAPL	Stock	106.78	107.8	106.3	107.099	16199302.0
2020-09-21 14:00:00	AAPL	Stock	107.1	107.45	106.461	107.34	12920441.0
2020-09-21 15:00:00	AAPL	Stock	107.33	110.19	107.23	110.13	33821988.0
2020-09-21 16:00:00	AAPL	Stock	110.08	110.7	106.909	110.04	9592211.0
2020-09-21 17:00:00	AAPL	Stock	110.06	110.17	109.44	109.86	533692.0
2020-09-21 18:00:00	AAPL	Stock	109.92	110.36	109.88	110.1	297691.0
2020-09-21 19:00:00	AAPL	Stock	110.1	111.0	109.94	110.95	362053.0
2020-09-21 04:00:00	MSFT	Stock	198.79	198.79	196.1	196.5	30373.0
2020-09-21 05:00:00	MSFT	Stock	196.45	198.0	195.59	196.34	23504.0
2020-09-21 06:00:00	MSFT	Stock	196.1	197.52	195.9	197.01	33494.0
2020-09-21 07:00:00	MSFT	Stock	197.01	197.85	195.0	197.19	117483.0
2020-09-21 08:00:00	MSFT	Stock	195.8	197.56	195.139	196.62	152931.0
2020-09-21 09:00:00	MSFT	Stock	196.79	198.75	196.5	197.99	4521308.0
2020-09-21 10:00:00	MSFT	Stock	197.98	198.2	196.38	197.727	4970577.0
2020-09-21 11:00:00	MSFT	Stock	197.72	199.24	196.89	199.174	3563052.0
2020-09-21 12:00:00	MSFT	Stock	199.19	200.39	198.9	199.54	2869357.0
2020-09-21 13:00:00	MSFT	Stock	199.55	201.28	198.97	200.03	2811391.0
2020-09-21 14:00:00	MSFT	Stock	200.05	200.45	198.55	199.84	2901685.0
2020-09-21 15:00:00	MSFT	Stock	199.84	202.71	199.73	202.64	5731394.0
2020-09-21 16:00:00	MSFT	Stock	202.58	203.48	198.94	202.71	4416747.0
2020-09-21 17:00:00	MSFT	Stock	202.7	203.2	202.57	203.2	27968.0
2020-09-21 18:00:00	MSFT	Stock	203.28	203.75	203.05	203.6	19278.0
2020-09-21 19:00:00	MSFT	Stock	203.33	204.51	203.33	204.2	37960.0
2020-09-21 04:00:00	NVDA	Stock	12.0743	12.0743	11.8113	11.8638	208480.0
2020-09-21 05:00:00	NVDA	Stock	11.8625	11.9365	11.813	11.875	499960.0
2020-09-21 06:00:00	NVDA	Stock	11.9	11.9562	11.862	11.938	106880.0
2020-09-21 07:00:00	NVDA	Stock	11.95	11.975	11.825	11.975	2282200.0
2020-09-21 08:00:00	NVDA	Stock	11.922	11.9778	11.85	11.9252	3278440.0
2020-09-21 09:00:00	NVDA	Stock	11.9318	12.249	11.878	12.0615	116978000.0
2020-09-21 10:00:00	NVDA	Stock	12.055	12.0855	11.9045	12.0058	113605240.0
2020-09-21 11:00:00	NVDA	Stock	12.0094	12.2348	11.9888	12.218	69473840.0
2020-09-21 12:00:00	NVDA	Stock	12.219	12.3345	12.2052	12.2617	66170920.0
2020-09-21 13:00:00	NVDA	Stock	12.2632	12.4212	12.2403	12.3272	50416800.0
2020-09-21 14:00:00	NVDA	Stock	12.3247	12.3564	12.1935	12.2675	58920680.0
2020-09-21 15:00:00	NVDA	Stock	12.2662	12.5225	12.248	12.5165	100471040.0
2020-09-21 16:00:00	NVDA	Stock	12.5172	12.575	12.2598	12.54	33143560.0
2020-09-21 17:00:00	NVDA	Stock	12.54	12.5472	12.5	12.532	1175720.0
2020-09-21 18:00:00	NVDA	Stock	12.535	12.55	12.525	12.55	271120.0
2020-09-21 19:00:00	NVDA	Stock	12.5485	12.5725	12.533	12.5725	470360.0
2020-09-21 04:00:00	AMZN	Stock	145.9	145.9	144.709	144.709	16080.0
2020-09-21 05:00:00	AMZN	Stock	145.1	145.1	144.7445	144.745	19820.0

> showing 50 of 58,893 rows — these rows as CSV

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