PREVIEW / stock_1hour / 2021-03-12

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-03-12.parquet
  size:    1.5 MB
  rows:    68,459
  symbols: 2,893

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-12 04:00:00	AAPL	Stock	120.37	120.5	119.58	119.68	87854.0
2021-03-12 05:00:00	AAPL	Stock	119.8	119.97	119.54	119.86	23003.0
2021-03-12 06:00:00	AAPL	Stock	119.87	120.16	119.66	120.0	37438.0
2021-03-12 07:00:00	AAPL	Stock	120.08	120.61	119.99	120.51	373663.0
2021-03-12 08:00:00	AAPL	Stock	120.5	122.112	120.0	120.15	685067.0
2021-03-12 09:00:00	AAPL	Stock	120.15	120.59	119.16	119.94	15142647.0
2021-03-12 10:00:00	AAPL	Stock	119.94	120.3	119.27	119.595	14665346.0
2021-03-12 11:00:00	AAPL	Stock	119.59	120.2	119.425	120.11	9129333.0
2021-03-12 12:00:00	AAPL	Stock	120.12	121.07	119.99	120.6808	9480962.0
2021-03-12 13:00:00	AAPL	Stock	120.68	121.01	120.427	120.642	6120077.0
2021-03-12 14:00:00	AAPL	Stock	120.65	120.9	120.5	120.76	5119784.0
2021-03-12 15:00:00	AAPL	Stock	120.76	121.17	120.465	121.05	10604968.0
2021-03-12 16:00:00	AAPL	Stock	121.06	121.06	120.91	121.01	5312724.0
2021-03-12 17:00:00	AAPL	Stock	121.02	121.11	120.98	121.11	54633.0
2021-03-12 18:00:00	AAPL	Stock	121.09	121.1	120.97	121.09	62163.0
2021-03-12 19:00:00	AAPL	Stock	121.06	121.1	120.99	121.08	73137.0
2021-03-12 04:00:00	MSFT	Stock	234.01	234.24	233.5	233.5	12494.0
2021-03-12 05:00:00	MSFT	Stock	233.58	233.81	232.68	232.68	10527.0
2021-03-12 06:00:00	MSFT	Stock	232.64	233.43	232.5	233.06	4094.0
2021-03-12 07:00:00	MSFT	Stock	233.68	234.57	233.05	234.39	44309.0
2021-03-12 08:00:00	MSFT	Stock	234.3	236.537	233.21	234.1	64280.0
2021-03-12 09:00:00	MSFT	Stock	234.0	235.46	233.33	235.37	2348999.0
2021-03-12 10:00:00	MSFT	Stock	235.4	235.445	233.36	233.64	3027469.0
2021-03-12 11:00:00	MSFT	Stock	233.64	234.95	233.23	234.59	1855256.0
2021-03-12 12:00:00	MSFT	Stock	234.62	235.54	234.4	234.71	1274437.0
2021-03-12 13:00:00	MSFT	Stock	234.72	235.35	234.32	235.01	1201735.0
2021-03-12 14:00:00	MSFT	Stock	235.02	235.54	234.22	235.17	1528855.0
2021-03-12 15:00:00	MSFT	Stock	235.17	235.82	234.88	235.8	2575805.0
2021-03-12 16:00:00	MSFT	Stock	235.75	235.8	235.28	235.5221	3371764.0
2021-03-12 17:00:00	MSFT	Stock	235.5	235.75	235.5	235.75	2907.0
2021-03-12 18:00:00	MSFT	Stock	235.75	235.8	235.75	235.8	1694.0
2021-03-12 19:00:00	MSFT	Stock	235.8	235.89	235.75	235.75	1995.0
2021-03-12 04:00:00	NVDA	Stock	12.7285	12.7285	12.55	12.5875	80760.0
2021-03-12 05:00:00	NVDA	Stock	12.6712	12.675	12.6712	12.675	24560.0
2021-03-12 06:00:00	NVDA	Stock	12.675	12.725	12.675	12.725	48320.0
2021-03-12 07:00:00	NVDA	Stock	12.737	12.7775	12.7	12.7775	472160.0
2021-03-12 08:00:00	NVDA	Stock	12.7	13.0098	12.7	12.725	875960.0
2021-03-12 09:00:00	NVDA	Stock	12.7198	12.8773	12.59	12.8675	32869600.0
2021-03-12 10:00:00	NVDA	Stock	12.8737	12.8738	12.6565	12.6851	25693400.0
2021-03-12 11:00:00	NVDA	Stock	12.6835	12.818	12.6573	12.7847	12369720.0
2021-03-12 12:00:00	NVDA	Stock	12.7855	12.8888	12.768	12.8062	15451240.0
2021-03-12 13:00:00	NVDA	Stock	12.8102	12.8528	12.7597	12.7765	8196080.0
2021-03-12 14:00:00	NVDA	Stock	12.7855	12.847	12.7403	12.837	10291840.0
2021-03-12 15:00:00	NVDA	Stock	12.8392	12.8775	12.795	12.856	20984560.0
2021-03-12 16:00:00	NVDA	Stock	12.856	12.8698	12.8395	12.8597	26750440.0
2021-03-12 17:00:00	NVDA	Stock	12.856	12.8675	12.855	12.855	128720.0
2021-03-12 18:00:00	NVDA	Stock	12.85	12.85	12.85	12.85	8960.0
2021-03-12 19:00:00	NVDA	Stock	12.8503	12.8625	12.847	12.8575	31720.0
2021-03-12 05:00:00	AMZN	Stock	153.039	153.039	153.039	153.039	2000.0
2021-03-12 06:00:00	AMZN	Stock	152.868	153.5	152.868	153.5	11680.0

> showing 50 of 68,459 rows — these rows as CSV

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