PREVIEW / stock_1hour / 2021-03-30

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-03-30.parquet
  size:    1.4 MB
  rows:    65,666
  symbols: 2,933

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-30 04:00:00	AAPL	Stock	120.78	120.88	120.02	120.41	24454.0
2021-03-30 05:00:00	AAPL	Stock	120.44	120.75	120.43	120.75	6677.0
2021-03-30 06:00:00	AAPL	Stock	120.74	120.81	119.92	120.32	43324.0
2021-03-30 07:00:00	AAPL	Stock	120.32	120.49	120.08	120.2	199021.0
2021-03-30 08:00:00	AAPL	Stock	120.2	121.693	120.04	120.27	364528.0
2021-03-30 09:00:00	AAPL	Stock	120.27	120.55	119.23	119.49	11219600.0
2021-03-30 10:00:00	AAPL	Stock	119.49	119.64	118.86	119.5	14390065.0
2021-03-30 11:00:00	AAPL	Stock	119.505	120.36	119.35	119.87	9655950.0
2021-03-30 12:00:00	AAPL	Stock	119.87	119.965	119.58	119.7351	6621868.0
2021-03-30 13:00:00	AAPL	Stock	119.74	120.08	119.515	119.7401	5558596.0
2021-03-30 14:00:00	AAPL	Stock	119.74	119.8221	119.46	119.7	6427401.0
2021-03-30 15:00:00	AAPL	Stock	119.708	120.2364	119.4	119.98	13788363.0
2021-03-30 16:00:00	AAPL	Stock	119.98	119.99	119.75	119.87	6257757.0
2021-03-30 17:00:00	AAPL	Stock	119.86	119.9	119.82	119.89	74263.0
2021-03-30 18:00:00	AAPL	Stock	119.89	119.89	119.75	119.81	54356.0
2021-03-30 19:00:00	AAPL	Stock	119.82	119.94	119.75	119.93	99266.0
2021-03-30 04:00:00	MSFT	Stock	234.32	234.5	233.04	233.51	4770.0
2021-03-30 05:00:00	MSFT	Stock	233.44	233.8	233.44	233.8	300.0
2021-03-30 06:00:00	MSFT	Stock	233.69	233.69	232.65	233.17	9066.0
2021-03-30 07:00:00	MSFT	Stock	233.08	233.58	232.76	233.12	30877.0
2021-03-30 08:00:00	MSFT	Stock	233.1	234.652	232.72	233.11	23882.0
2021-03-30 09:00:00	MSFT	Stock	233.4	234.25	231.54	232.25	2438819.0
2021-03-30 10:00:00	MSFT	Stock	232.23	232.9	231.1	231.95	2932086.0
2021-03-30 11:00:00	MSFT	Stock	231.96	232.685	231.61	231.985	2307041.0
2021-03-30 12:00:00	MSFT	Stock	231.98	232.2	231.58	231.83	1567746.0
2021-03-30 13:00:00	MSFT	Stock	231.84	232.45	231.58	231.95	1168682.0
2021-03-30 14:00:00	MSFT	Stock	231.9486	232.33	231.59	232.25	1277003.0
2021-03-30 15:00:00	MSFT	Stock	232.2506	232.5	231.32	232.43	3808524.0
2021-03-30 16:00:00	MSFT	Stock	232.43	232.43	231.7	231.91	2924180.0
2021-03-30 17:00:00	MSFT	Stock	231.92	231.96	231.83	231.88	17557.0
2021-03-30 18:00:00	MSFT	Stock	231.88	231.8999	231.61	231.61	5100.0
2021-03-30 19:00:00	MSFT	Stock	231.81	231.9	231.69	231.89	13198.0
2021-03-30 04:00:00	NVDA	Stock	12.9	12.9	12.9	12.9	4000.0
2021-03-30 06:00:00	NVDA	Stock	12.875	12.875	12.875	12.875	6360.0
2021-03-30 07:00:00	NVDA	Stock	12.8	12.8038	12.8	12.8	50520.0
2021-03-30 08:00:00	NVDA	Stock	12.8725	12.8725	12.7875	12.79	85360.0
2021-03-30 09:00:00	NVDA	Stock	12.8423	12.8613	12.705	12.7942	16859440.0
2021-03-30 10:00:00	NVDA	Stock	12.7812	12.9435	12.7145	12.915	20730880.0
2021-03-30 11:00:00	NVDA	Stock	12.9162	12.9753	12.864	12.8975	15124440.0
2021-03-30 12:00:00	NVDA	Stock	12.8918	12.9098	12.8243	12.8382	8520120.0
2021-03-30 13:00:00	NVDA	Stock	12.8325	12.8888	12.8	12.8305	6833760.0
2021-03-30 14:00:00	NVDA	Stock	12.8288	12.8875	12.781	12.8753	9110880.0
2021-03-30 15:00:00	NVDA	Stock	12.8765	12.9278	12.808	12.8718	21820280.0
2021-03-30 16:00:00	NVDA	Stock	12.8718	12.885	12.8255	12.875	19793040.0
2021-03-30 17:00:00	NVDA	Stock	12.8795	12.8875	12.8688	12.8688	186280.0
2021-03-30 18:00:00	NVDA	Stock	12.8625	12.8625	12.85	12.8563	33600.0
2021-03-30 19:00:00	NVDA	Stock	12.8663	12.8825	12.8663	12.8813	63680.0
2021-03-30 07:00:00	AMZN	Stock	152.8915	152.8995	152.6	152.65	25600.0
2021-03-30 08:00:00	AMZN	Stock	152.99	153.1	152.6	152.9625	73240.0
2021-03-30 09:00:00	AMZN	Stock	153.2815	153.65	152.1615	152.481	2971220.0

> showing 50 of 65,666 rows — these rows as CSV

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