PREVIEW / stock_1hour / 2021-01-28

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-01-28.parquet
  size:    1.5 MB
  rows:    68,895
  symbols: 2,739

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-01-28 04:00:00	AAPL	Stock	137.59	137.95	134.5	136.88	226371.0
2021-01-28 05:00:00	AAPL	Stock	136.83	138.95	136.52	137.6	152957.0
2021-01-28 06:00:00	AAPL	Stock	137.62	139.3	137.0	139.22	89222.0
2021-01-28 07:00:00	AAPL	Stock	139.16	140.05	137.73	138.88	892142.0
2021-01-28 08:00:00	AAPL	Stock	138.85	140.48	137.81	140.2	1237779.0
2021-01-28 09:00:00	AAPL	Stock	140.22	142.12	138.0	138.26	17774503.0
2021-01-28 10:00:00	AAPL	Stock	138.26	140.338	138.0	139.22	18597939.0
2021-01-28 11:00:00	AAPL	Stock	139.23	140.025	138.49	139.07	12390812.0
2021-01-28 12:00:00	AAPL	Stock	139.07	141.99	139.005	140.7	18835323.0
2021-01-28 13:00:00	AAPL	Stock	140.72	140.93	139.9	140.2	9693869.0
2021-01-28 14:00:00	AAPL	Stock	140.215	140.34	139.03	139.32	10740531.0
2021-01-28 15:00:00	AAPL	Stock	139.32	139.33	136.7	137.04	21382045.0
2021-01-28 16:00:00	AAPL	Stock	137.09	137.15	136.01	137.07	10493314.0
2021-01-28 17:00:00	AAPL	Stock	137.09	137.53	137.03	137.43	626792.0
2021-01-28 18:00:00	AAPL	Stock	137.44	137.57	136.75	136.91	346343.0
2021-01-28 19:00:00	AAPL	Stock	136.92	137.11	136.12	136.63	402389.0
2021-01-28 04:00:00	MSFT	Stock	230.62	230.69	228.97	229.95	51175.0
2021-01-28 05:00:00	MSFT	Stock	230.0	231.76	230.0	230.55	29014.0
2021-01-28 06:00:00	MSFT	Stock	230.55	231.98	229.56	231.98	20768.0
2021-01-28 07:00:00	MSFT	Stock	231.72	233.0	230.7	232.3	83839.0
2021-01-28 08:00:00	MSFT	Stock	232.34	234.32	229.25	234.02	305987.0
2021-01-28 09:00:00	MSFT	Stock	234.0	238.0	234.0	236.585	4741513.0
2021-01-28 10:00:00	MSFT	Stock	236.66	240.38	236.27	239.67	6963483.0
2021-01-28 11:00:00	MSFT	Stock	239.72	240.16	238.16	240.05	3674438.0
2021-01-28 12:00:00	MSFT	Stock	240.04	242.5	239.962	242.46	4980530.0
2021-01-28 13:00:00	MSFT	Stock	242.44	242.64	240.72	242.08	3033908.0
2021-01-28 14:00:00	MSFT	Stock	242.1	242.55	240.57	241.1	2781477.0
2021-01-28 15:00:00	MSFT	Stock	241.09	241.4	238.24	238.93	5362694.0
2021-01-28 16:00:00	MSFT	Stock	238.93	238.93	236.0	236.86	7092991.0
2021-01-28 17:00:00	MSFT	Stock	237.12	238.93	236.8	237.57	90075.0
2021-01-28 18:00:00	MSFT	Stock	237.48	237.9	236.24	236.5	61284.0
2021-01-28 19:00:00	MSFT	Stock	236.78	237.0	236.24	236.42	35509.0
2021-01-28 04:00:00	NVDA	Stock	12.875	12.875	12.75	12.767	206400.0
2021-01-28 05:00:00	NVDA	Stock	12.7283	12.7308	12.7275	12.7275	30920.0
2021-01-28 06:00:00	NVDA	Stock	12.725	12.8252	12.725	12.8252	50120.0
2021-01-28 07:00:00	NVDA	Stock	12.865	12.975	12.865	12.95	663600.0
2021-01-28 08:00:00	NVDA	Stock	12.7804	13.0113	12.7804	13.0113	943520.0
2021-01-28 09:00:00	NVDA	Stock	12.9688	13.0835	12.9605	13.0065	22010040.0
2021-01-28 10:00:00	NVDA	Stock	13.0143	13.17	13.014	13.1	28212640.0
2021-01-28 11:00:00	NVDA	Stock	13.1078	13.1675	13.0505	13.146	15782440.0
2021-01-28 12:00:00	NVDA	Stock	13.1532	13.275	13.1133	13.2348	22091920.0
2021-01-28 13:00:00	NVDA	Stock	13.236	13.3398	13.2131	13.3	20804280.0
2021-01-28 14:00:00	NVDA	Stock	13.2995	13.315	13.1693	13.2072	21916200.0
2021-01-28 15:00:00	NVDA	Stock	13.2032	13.2115	13.0325	13.0482	28874480.0
2021-01-28 16:00:00	NVDA	Stock	13.051	13.0697	13.025	13.0375	3758040.0
2021-01-28 17:00:00	NVDA	Stock	13.06	13.0875	13.0562	13.075	101000.0
2021-01-28 18:00:00	NVDA	Stock	13.0583	13.0583	13.025	13.025	341760.0
2021-01-28 19:00:00	NVDA	Stock	13.0478	13.0833	13.037	13.045	324560.0
2021-01-28 04:00:00	AMZN	Stock	159.75	159.75	159.5	159.5	5780.0
2021-01-28 05:00:00	AMZN	Stock	159.9625	160.6	159.9625	160.6	8620.0

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

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