PREVIEW / stock_1hour / 2020-10-30

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-10-30.parquet
  size:    1.2 MB
  rows:    57,279
  symbols: 2,516

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-10-30 04:00:00	AAPL	Stock	109.82	109.89	108.7	109.8	150413.0
2020-10-30 05:00:00	AAPL	Stock	109.78	110.64	109.5	110.51	82165.0
2020-10-30 06:00:00	AAPL	Stock	110.45	111.28	110.1	111.05	153550.0
2020-10-30 07:00:00	AAPL	Stock	111.06	111.12	110.5	110.73	434688.0
2020-10-30 08:00:00	AAPL	Stock	110.95	111.4	110.15	110.96	1235188.0
2020-10-30 09:00:00	AAPL	Stock	110.9	111.99	108.85	109.698	29387401.0
2020-10-30 10:00:00	AAPL	Stock	109.69	110.44	108.3	108.57	29328849.0
2020-10-30 11:00:00	AAPL	Stock	108.57	109.852	108.55	108.77	18182503.0
2020-10-30 12:00:00	AAPL	Stock	108.77	109.97	108.7	108.889	15214610.0
2020-10-30 13:00:00	AAPL	Stock	108.88	109.19	108.1	108.35	15174654.0
2020-10-30 14:00:00	AAPL	Stock	108.34	108.79	108.0	108.15	14327454.0
2020-10-30 15:00:00	AAPL	Stock	108.14	109.3	107.72	108.9	30784575.0
2020-10-30 16:00:00	AAPL	Stock	109.0	109.15	108.81	109.07	15063817.0
2020-10-30 17:00:00	AAPL	Stock	109.03	109.05	108.5	108.86	167238.0
2020-10-30 18:00:00	AAPL	Stock	108.86	108.93	108.75	108.76	126990.0
2020-10-30 19:00:00	AAPL	Stock	108.76	108.79	108.5	108.51	157274.0
2020-10-30 04:00:00	MSFT	Stock	201.8	202.0	200.05	200.49	23073.0
2020-10-30 05:00:00	MSFT	Stock	200.77	201.79	200.54	201.7	12399.0
2020-10-30 06:00:00	MSFT	Stock	201.94	202.85	201.22	202.85	12581.0
2020-10-30 07:00:00	MSFT	Stock	202.54	202.82	202.33	202.79	18275.0
2020-10-30 08:00:00	MSFT	Stock	202.71	203.3	201.8	202.72	88643.0
2020-10-30 09:00:00	MSFT	Stock	202.8	204.29	202.56	203.17	2659000.0
2020-10-30 10:00:00	MSFT	Stock	203.1	203.2	199.76	199.77	4809157.0
2020-10-30 11:00:00	MSFT	Stock	199.77	200.93	199.62	200.515	3612450.0
2020-10-30 12:00:00	MSFT	Stock	200.5	202.44	200.32	201.545	2466030.0
2020-10-30 13:00:00	MSFT	Stock	201.53	201.91	200.125	200.65	1973543.0
2020-10-30 14:00:00	MSFT	Stock	200.67	201.36	199.94	200.67	2249893.0
2020-10-30 15:00:00	MSFT	Stock	200.62	203.32	200.15	202.58	6049558.0
2020-10-30 16:00:00	MSFT	Stock	202.47	203.41	202.47	202.95	5459783.0
2020-10-30 17:00:00	MSFT	Stock	202.83	202.92	202.6	202.66	16492.0
2020-10-30 18:00:00	MSFT	Stock	202.77	202.77	202.31	202.37	14278.0
2020-10-30 19:00:00	MSFT	Stock	202.55	202.55	202.06	202.3	5684.0
2020-10-30 05:00:00	NVDA	Stock	12.7708	12.7875	12.7708	12.7875	20040.0
2020-10-30 06:00:00	NVDA	Stock	12.8	12.85	12.8	12.85	48680.0
2020-10-30 07:00:00	NVDA	Stock	12.85	12.8723	12.8405	12.8405	210720.0
2020-10-30 08:00:00	NVDA	Stock	12.8526	12.875	12.75	12.8251	1322880.0
2020-10-30 09:00:00	NVDA	Stock	12.8348	12.9364	12.7245	12.8	37191200.0
2020-10-30 10:00:00	NVDA	Stock	12.8001	12.8255	12.4059	12.407	74183920.0
2020-10-30 11:00:00	NVDA	Stock	12.4092	12.5213	12.3868	12.4079	45245600.0
2020-10-30 12:00:00	NVDA	Stock	12.3998	12.5553	12.3715	12.3795	38279960.0
2020-10-30 13:00:00	NVDA	Stock	12.3778	12.418	12.3	12.3338	30746520.0
2020-10-30 14:00:00	NVDA	Stock	12.3282	12.3732	12.3	12.3597	34762400.0
2020-10-30 15:00:00	NVDA	Stock	12.3542	12.5598	12.3403	12.5595	78288960.0
2020-10-30 16:00:00	NVDA	Stock	12.55	12.575	12.534	12.5468	9686840.0
2020-10-30 17:00:00	NVDA	Stock	12.5545	12.5545	12.54	12.5543	199320.0
2020-10-30 18:00:00	NVDA	Stock	12.538	12.55	12.5375	12.5398	65320.0
2020-10-30 19:00:00	NVDA	Stock	12.5398	12.5425	12.5005	12.52	304760.0
2020-10-30 04:00:00	AMZN	Stock	157.25	157.25	156.9055	157.166	10360.0
2020-10-30 05:00:00	AMZN	Stock	157.5515	157.926	157.5515	157.926	11240.0
2020-10-30 06:00:00	AMZN	Stock	158.4625	158.4625	158.2	158.3945	14040.0

> showing 50 of 57,279 rows — these rows as CSV

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