PREVIEW / stock_1hour / 2021-11-11

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-11-11.parquet
  size:    1.4 MB
  rows:    66,072
  symbols: 2,675

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-11 04:00:00	AAPL	Stock	148.21	148.75	148.1	148.67	35517.0
2021-11-11 05:00:00	AAPL	Stock	148.7	148.7	148.38	148.57	18684.0
2021-11-11 06:00:00	AAPL	Stock	148.63	148.74	148.51	148.68	6786.0
2021-11-11 07:00:00	AAPL	Stock	148.69	148.78	148.41	148.65	81132.0
2021-11-11 08:00:00	AAPL	Stock	148.65	148.8	147.551	148.79	217422.0
2021-11-11 09:00:00	AAPL	Stock	148.78	149.43	148.15	148.67	5708353.0
2021-11-11 10:00:00	AAPL	Stock	148.68	148.68	148.17	148.375	5131040.0
2021-11-11 11:00:00	AAPL	Stock	148.38	148.57	148.16	148.263	3699012.0
2021-11-11 12:00:00	AAPL	Stock	148.2689	148.31	147.87	147.98	3387920.0
2021-11-11 13:00:00	AAPL	Stock	147.975	147.9752	147.681	147.845	2941171.0
2021-11-11 14:00:00	AAPL	Stock	147.845	148.3	147.805	148.0601	3317303.0
2021-11-11 15:00:00	AAPL	Stock	148.06	148.15	147.76	147.87	5019006.0
2021-11-11 16:00:00	AAPL	Stock	147.87	147.95	147.8	147.9	3632096.0
2021-11-11 17:00:00	AAPL	Stock	147.92	147.98	147.8	147.9	57755.0
2021-11-11 18:00:00	AAPL	Stock	147.9	148.05	147.88	148.03	45501.0
2021-11-11 19:00:00	AAPL	Stock	148.05	148.29	148.05	148.25	71206.0
2021-11-11 04:00:00	MSFT	Stock	331.5	332.34	331.22	332.34	2678.0
2021-11-11 05:00:00	MSFT	Stock	332.34	332.34	331.8	332.17	3186.0
2021-11-11 06:00:00	MSFT	Stock	332.17	332.24	332.02	332.24	3203.0
2021-11-11 07:00:00	MSFT	Stock	332.16	332.88	332.16	332.46	22076.0
2021-11-11 08:00:00	MSFT	Stock	332.35	332.94	332.2	332.54	37433.0
2021-11-11 09:00:00	MSFT	Stock	332.64	333.31	330.51	333.11	1353260.0
2021-11-11 10:00:00	MSFT	Stock	333.11	333.4	332.23	332.5466	1217338.0
2021-11-11 11:00:00	MSFT	Stock	332.55	333.7746	332.33	333.36	1020630.0
2021-11-11 12:00:00	MSFT	Stock	333.37	333.54	332.62	333.09	850522.0
2021-11-11 13:00:00	MSFT	Stock	333.06	333.49	332.6252	333.27	812878.0
2021-11-11 14:00:00	MSFT	Stock	333.255	333.42	332.41	332.46	809299.0
2021-11-11 15:00:00	MSFT	Stock	332.47	332.92	332.0	332.46	1571075.0
2021-11-11 16:00:00	MSFT	Stock	332.43	333.5	332.43	332.6	1951354.0
2021-11-11 17:00:00	MSFT	Stock	332.78	332.8	332.62	332.62	840.0
2021-11-11 18:00:00	MSFT	Stock	332.65	333.47	332.65	333.4	3227.0
2021-11-11 19:00:00	MSFT	Stock	333.1	333.98	333.1	333.85	4165.0
2021-11-11 04:00:00	NVDA	Stock	29.936	30.286	29.936	30.175	236880.0
2021-11-11 05:00:00	NVDA	Stock	30.198	30.211	30.068	30.11	154080.0
2021-11-11 06:00:00	NVDA	Stock	30.107	30.174	30.1	30.119	109480.0
2021-11-11 07:00:00	NVDA	Stock	30.14	30.35	30.083	30.348	875710.0
2021-11-11 08:00:00	NVDA	Stock	30.155	30.48	29.5326	30.456	2335300.0
2021-11-11 09:00:00	NVDA	Stock	30.47	30.5	29.856	30.0935	49722240.0
2021-11-11 10:00:00	NVDA	Stock	30.093	30.284	29.777	30.164	42084260.0
2021-11-11 11:00:00	NVDA	Stock	30.168	30.202	30.02	30.0715	18721110.0
2021-11-11 12:00:00	NVDA	Stock	30.0692	30.17	29.914	30.1098	19674000.0
2021-11-11 13:00:00	NVDA	Stock	30.111	30.498	30.068	30.459	24180410.0
2021-11-11 14:00:00	NVDA	Stock	30.4668	30.59	30.331	30.358	26381390.0
2021-11-11 15:00:00	NVDA	Stock	30.3545	30.505	30.193	30.391	32640310.0
2021-11-11 16:00:00	NVDA	Stock	30.39	30.4	30.35	30.381	21421260.0
2021-11-11 17:00:00	NVDA	Stock	30.397	30.4	30.35	30.396	310130.0
2021-11-11 18:00:00	NVDA	Stock	30.38	30.694	30.38	30.675	487920.0
2021-11-11 19:00:00	NVDA	Stock	30.65	30.85	30.633	30.796	728760.0
2021-11-11 04:00:00	AMZN	Stock	175.7035	175.704	175.7035	175.704	15600.0
2021-11-11 06:00:00	AMZN	Stock	175.5	175.5	175.5	175.5	2000.0

> showing 50 of 66,072 rows — these rows as CSV

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