PREVIEW / stock_1hour / 2021-03-25

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-03-25.parquet
  size:    1.4 MB
  rows:    67,496
  symbols: 2,921

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-25 04:00:00	AAPL	Stock	120.15	120.82	120.15	120.6	16849.0
2021-03-25 05:00:00	AAPL	Stock	120.5	120.59	120.3	120.41	6196.0
2021-03-25 06:00:00	AAPL	Stock	120.47	120.88	120.47	120.6	9149.0
2021-03-25 07:00:00	AAPL	Stock	120.64	120.7	119.0	119.1	317746.0
2021-03-25 08:00:00	AAPL	Stock	120.4499	120.68	118.8	119.02	872550.0
2021-03-25 09:00:00	AAPL	Stock	119.02	121.05	118.59	121.0214	13496338.0
2021-03-25 10:00:00	AAPL	Stock	121.02	121.66	119.28	119.71	16638308.0
2021-03-25 11:00:00	AAPL	Stock	119.71	119.95	119.09	119.715	12082114.0
2021-03-25 12:00:00	AAPL	Stock	119.72	120.36	119.49	120.16	9202617.0
2021-03-25 13:00:00	AAPL	Stock	120.16	120.6	119.77	119.96	7808985.0
2021-03-25 14:00:00	AAPL	Stock	119.96	120.61	119.485	120.5702	6841117.0
2021-03-25 15:00:00	AAPL	Stock	120.57	121.0901	120.54	120.6	12340744.0
2021-03-25 16:00:00	AAPL	Stock	120.59	120.67	120.35	120.51	6002371.0
2021-03-25 17:00:00	AAPL	Stock	120.55	120.64	120.5	120.59	48043.0
2021-03-25 18:00:00	AAPL	Stock	120.59	120.6	120.45	120.58	59892.0
2021-03-25 19:00:00	AAPL	Stock	120.58	120.85	120.56	120.75	93611.0
2021-03-25 04:00:00	MSFT	Stock	235.0	236.17	235.0	236.17	829.0
2021-03-25 05:00:00	MSFT	Stock	235.6	235.6	235.29	235.29	586.0
2021-03-25 06:00:00	MSFT	Stock	235.47	235.67	235.47	235.67	360.0
2021-03-25 07:00:00	MSFT	Stock	235.72	236.0	234.5	235.25	15904.0
2021-03-25 08:00:00	MSFT	Stock	235.0	236.0	234.3	235.34	52781.0
2021-03-25 09:00:00	MSFT	Stock	235.49	236.805	234.595	235.85	2630390.0
2021-03-25 10:00:00	MSFT	Stock	235.83	236.94	232.73	232.88	3460885.0
2021-03-25 11:00:00	MSFT	Stock	232.89	233.13	231.57	232.31	3651466.0
2021-03-25 12:00:00	MSFT	Stock	232.32	232.72	231.78	232.155	2404427.0
2021-03-25 13:00:00	MSFT	Stock	232.15	233.12	231.57	232.3	2457663.0
2021-03-25 14:00:00	MSFT	Stock	232.33	233.12	231.61	232.935	2279820.0
2021-03-25 15:00:00	MSFT	Stock	232.93	233.61	232.22	232.27	4156685.0
2021-03-25 16:00:00	MSFT	Stock	232.34	232.63	232.295	232.43	3743254.0
2021-03-25 17:00:00	MSFT	Stock	232.62	232.79	232.34	232.75	31076.0
2021-03-25 18:00:00	MSFT	Stock	232.54	232.6	232.4	232.6	14562.0
2021-03-25 19:00:00	MSFT	Stock	232.64	234.0	232.55	233.52	27940.0
2021-03-25 04:00:00	NVDA	Stock	12.7	12.717	12.6768	12.717	18840.0
2021-03-25 05:00:00	NVDA	Stock	12.725	12.725	12.705	12.705	20000.0
2021-03-25 07:00:00	NVDA	Stock	12.703	12.703	12.5635	12.5758	628040.0
2021-03-25 08:00:00	NVDA	Stock	12.6024	12.7125	12.503	12.5065	701160.0
2021-03-25 09:00:00	NVDA	Stock	12.5213	12.6758	12.3928	12.64	20625600.0
2021-03-25 10:00:00	NVDA	Stock	12.6399	12.7148	12.3435	12.395	24966440.0
2021-03-25 11:00:00	NVDA	Stock	12.3925	12.488	12.284	12.4718	27177240.0
2021-03-25 12:00:00	NVDA	Stock	12.4738	12.5886	12.4538	12.5198	16658000.0
2021-03-25 13:00:00	NVDA	Stock	12.518	12.5418	12.3743	12.3795	15052960.0
2021-03-25 14:00:00	NVDA	Stock	12.375	12.541	12.272	12.5302	20014520.0
2021-03-25 15:00:00	NVDA	Stock	12.525	12.597	12.4825	12.5298	24312040.0
2021-03-25 16:00:00	NVDA	Stock	12.5353	12.5462	12.5253	12.5375	14456600.0
2021-03-25 17:00:00	NVDA	Stock	12.525	12.55	12.525	12.55	47400.0
2021-03-25 18:00:00	NVDA	Stock	12.5375	12.55	12.5325	12.5372	90080.0
2021-03-25 19:00:00	NVDA	Stock	12.5462	12.5743	12.5375	12.572	230040.0
2021-03-25 07:00:00	AMZN	Stock	154.25	154.25	153.8075	153.8075	57520.0
2021-03-25 08:00:00	AMZN	Stock	154.55	154.55	153.4275	153.7	62920.0
2021-03-25 09:00:00	AMZN	Stock	153.9395	155.239	153.35	154.749	3578920.0

> showing 50 of 67,496 rows — these rows as CSV

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