PREVIEW / stock_1hour / 2020-12-31

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-12-31.parquet
  size:    1.4 MB
  rows:    62,949
  symbols: 2,685

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-12-31 04:00:00	AAPL	Stock	133.81	133.81	133.38	133.43	4304.0
2020-12-31 05:00:00	AAPL	Stock	133.61	133.72	133.53	133.72	3062.0
2020-12-31 06:00:00	AAPL	Stock	133.71	133.99	133.71	133.97	5016.0
2020-12-31 07:00:00	AAPL	Stock	133.82	134.65	133.82	134.38	264786.0
2020-12-31 08:00:00	AAPL	Stock	134.298	134.65	133.9	134.35	500798.0
2020-12-31 09:00:00	AAPL	Stock	134.35	134.74	133.19	133.435	11509231.0
2020-12-31 10:00:00	AAPL	Stock	133.44	133.6	132.65	133.127	12808560.0
2020-12-31 11:00:00	AAPL	Stock	133.13	133.14	131.892	131.95	10443937.0
2020-12-31 12:00:00	AAPL	Stock	131.96	132.8	131.72	132.425	9725546.0
2020-12-31 13:00:00	AAPL	Stock	132.43	132.63	132.09	132.1	6053953.0
2020-12-31 14:00:00	AAPL	Stock	132.101	133.1	132.01	132.991	9868326.0
2020-12-31 15:00:00	AAPL	Stock	132.995	133.33	132.45	132.58	15157048.0
2020-12-31 16:00:00	AAPL	Stock	132.69	132.99	132.57	132.62	11118041.0
2020-12-31 17:00:00	AAPL	Stock	132.63	132.68	132.55	132.6	102864.0
2020-12-31 18:00:00	AAPL	Stock	132.6	132.69	132.57	132.68	35300.0
2020-12-31 19:00:00	AAPL	Stock	132.69	132.8	132.65	132.71	77458.0
2020-12-31 04:00:00	MSFT	Stock	221.9	222.45	221.85	222.45	708.0
2020-12-31 05:00:00	MSFT	Stock	222.54	222.68	222.54	222.68	252.0
2020-12-31 06:00:00	MSFT	Stock	222.35	222.35	222.35	222.35	111.0
2020-12-31 07:00:00	MSFT	Stock	222.05	222.11	221.69	221.88	5955.0
2020-12-31 08:00:00	MSFT	Stock	222.262	222.28	221.48	221.67	22609.0
2020-12-31 09:00:00	MSFT	Stock	221.67	222.5	220.97	221.493	1873392.0
2020-12-31 10:00:00	MSFT	Stock	221.5	221.83	220.63	220.652	1567590.0
2020-12-31 11:00:00	MSFT	Stock	220.65	220.88	219.68	219.74	1547379.0
2020-12-31 12:00:00	MSFT	Stock	219.75	220.34	219.75	220.18	1090794.0
2020-12-31 13:00:00	MSFT	Stock	220.18	220.406	219.94	220.04	918210.0
2020-12-31 14:00:00	MSFT	Stock	220.055	221.1	219.88	221.05	1400729.0
2020-12-31 15:00:00	MSFT	Stock	221.06	223.0	221.055	222.37	3849128.0
2020-12-31 16:00:00	MSFT	Stock	222.37	222.56	222.37	222.5	4956137.0
2020-12-31 17:00:00	MSFT	Stock	222.5	222.51	222.35	222.4	11677.0
2020-12-31 18:00:00	MSFT	Stock	222.4	222.5	222.4	222.5	5459.0
2020-12-31 19:00:00	MSFT	Stock	222.5	222.52	222.43	222.5	9322.0
2020-12-31 04:00:00	NVDA	Stock	13.1138	13.1138	13.1138	13.1138	4000.0
2020-12-31 05:00:00	NVDA	Stock	13.1033	13.125	13.1033	13.125	32240.0
2020-12-31 06:00:00	NVDA	Stock	13.1438	13.1438	13.1438	13.1438	66320.0
2020-12-31 07:00:00	NVDA	Stock	13.1625	13.1625	13.146	13.146	98600.0
2020-12-31 08:00:00	NVDA	Stock	13.147	13.1628	13.125	13.1375	277520.0
2020-12-31 09:00:00	NVDA	Stock	13.1498	13.1511	12.987	13.036	25621160.0
2020-12-31 10:00:00	NVDA	Stock	13.0395	13.1358	13.0232	13.1208	20997280.0
2020-12-31 11:00:00	NVDA	Stock	13.1206	13.1262	12.979	12.9856	18007040.0
2020-12-31 12:00:00	NVDA	Stock	12.9858	13.0238	12.9838	13.0025	12434000.0
2020-12-31 13:00:00	NVDA	Stock	13.0025	13.0025	12.941	12.9523	13106320.0
2020-12-31 14:00:00	NVDA	Stock	12.9535	13.0245	12.915	13.0123	21958640.0
2020-12-31 15:00:00	NVDA	Stock	13.0143	13.0715	12.9637	13.053	33046640.0
2020-12-31 16:00:00	NVDA	Stock	13.053	13.0713	13.0393	13.0598	21081000.0
2020-12-31 17:00:00	NVDA	Stock	13.055	13.071	13.055	13.0625	228320.0
2020-12-31 18:00:00	NVDA	Stock	13.0645	13.0645	13.05	13.0523	65440.0
2020-12-31 19:00:00	NVDA	Stock	13.0402	13.05	13.0288	13.05	48480.0
2020-12-31 07:00:00	AMZN	Stock	164.0895	164.0945	164.0895	164.094	6000.0
2020-12-31 08:00:00	AMZN	Stock	164.0266	164.1	163.8655	164.0125	55240.0

> showing 50 of 62,949 rows — these rows as CSV

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