PREVIEW / stock_1hour / 2021-03-29

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-03-29.parquet
  size:    1.4 MB
  rows:    66,419
  symbols: 2,938

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-29 04:00:00	AAPL	Stock	120.69	120.72	120.21	120.5	18793.0
2021-03-29 05:00:00	AAPL	Stock	120.5	120.88	120.43	120.88	10322.0
2021-03-29 06:00:00	AAPL	Stock	120.81	120.96	120.74	120.85	7035.0
2021-03-29 07:00:00	AAPL	Stock	120.86	121.44	120.84	121.05	97699.0
2021-03-29 08:00:00	AAPL	Stock	121.0999	122.0	120.8	121.13	500718.0
2021-03-29 09:00:00	AAPL	Stock	121.15	122.58	121.0	121.3299	11161519.0
2021-03-29 10:00:00	AAPL	Stock	121.33	122.09	120.81	121.6	11887102.0
2021-03-29 11:00:00	AAPL	Stock	121.6	121.6093	120.935	121.195	7628137.0
2021-03-29 12:00:00	AAPL	Stock	121.1983	121.39	120.7299	121.3615	6954214.0
2021-03-29 13:00:00	AAPL	Stock	121.37	121.98	121.37	121.65	6866370.0
2021-03-29 14:00:00	AAPL	Stock	121.655	121.69	121.02	121.17	6094284.0
2021-03-29 15:00:00	AAPL	Stock	121.18	121.73	120.97	121.4	10778867.0
2021-03-29 16:00:00	AAPL	Stock	121.39	121.4	120.95	121.32	6804041.0
2021-03-29 17:00:00	AAPL	Stock	121.31	121.32	121.27	121.32	20879.0
2021-03-29 18:00:00	AAPL	Stock	121.32	121.45	121.32	121.35	43536.0
2021-03-29 19:00:00	AAPL	Stock	121.37	121.44	121.25	121.35	38405.0
2021-03-29 04:00:00	MSFT	Stock	235.96	235.96	234.95	234.95	923.0
2021-03-29 05:00:00	MSFT	Stock	234.9	235.8	234.9	235.8	2258.0
2021-03-29 06:00:00	MSFT	Stock	235.8	235.94	235.6	235.94	1836.0
2021-03-29 07:00:00	MSFT	Stock	236.4	236.5	235.72	236.25	11235.0
2021-03-29 08:00:00	MSFT	Stock	235.95	236.5373	235.0	235.1	20601.0
2021-03-29 09:00:00	MSFT	Stock	235.1	237.0	232.98	233.1	2390516.0
2021-03-29 10:00:00	MSFT	Stock	233.1	233.975	231.88	233.56	2772507.0
2021-03-29 11:00:00	MSFT	Stock	233.58	234.0	232.95	233.6	1584760.0
2021-03-29 12:00:00	MSFT	Stock	233.6	234.96	233.02	234.9305	1551404.0
2021-03-29 13:00:00	MSFT	Stock	234.95	235.64	234.82	235.1155	1577857.0
2021-03-29 14:00:00	MSFT	Stock	235.15	235.16	234.26	234.45	1406723.0
2021-03-29 15:00:00	MSFT	Stock	234.47	235.31	234.3762	235.28	2322134.0
2021-03-29 16:00:00	MSFT	Stock	235.24	235.95	234.5923	235.3	4514067.0
2021-03-29 17:00:00	MSFT	Stock	235.3017	235.3113	235.0563	235.3113	5189.0
2021-03-29 18:00:00	MSFT	Stock	235.32	235.66	235.26	235.58	8234.0
2021-03-29 19:00:00	MSFT	Stock	235.29	235.5	235.15	235.49	6055.0
2021-03-29 04:00:00	NVDA	Stock	12.75	12.75	12.75	12.75	5080.0
2021-03-29 05:00:00	NVDA	Stock	12.764	12.764	12.764	12.764	16000.0
2021-03-29 06:00:00	NVDA	Stock	12.7772	12.825	12.7772	12.825	20200.0
2021-03-29 07:00:00	NVDA	Stock	12.8	12.8448	12.8	12.814	145480.0
2021-03-29 08:00:00	NVDA	Stock	12.8245	12.8713	12.775	12.775	180080.0
2021-03-29 09:00:00	NVDA	Stock	12.775	12.975	12.7463	12.7735	23892840.0
2021-03-29 10:00:00	NVDA	Stock	12.7623	12.8958	12.7	12.8	19474120.0
2021-03-29 11:00:00	NVDA	Stock	12.794	12.882	12.7335	12.85	13138320.0
2021-03-29 12:00:00	NVDA	Stock	12.849	13.0	12.8	12.9946	15961320.0
2021-03-29 13:00:00	NVDA	Stock	12.999	13.0625	12.939	12.9425	18508720.0
2021-03-29 14:00:00	NVDA	Stock	12.9425	12.9565	12.8387	12.871	15292280.0
2021-03-29 15:00:00	NVDA	Stock	12.8751	12.9731	12.8751	12.9518	22851520.0
2021-03-29 16:00:00	NVDA	Stock	12.9482	12.9562	12.8928	12.9555	25755280.0
2021-03-29 17:00:00	NVDA	Stock	12.9625	12.9688	12.9545	12.9545	165560.0
2021-03-29 18:00:00	NVDA	Stock	12.9607	12.9665	12.9607	12.9665	26280.0
2021-03-29 19:00:00	NVDA	Stock	12.955	12.955	12.955	12.955	5720.0
2021-03-29 07:00:00	AMZN	Stock	152.65	152.9495	152.625	152.625	31360.0
2021-03-29 08:00:00	AMZN	Stock	152.5	152.899	152.2596	152.425	66560.0

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

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