PREVIEW / stock_1hour / 2021-05-21

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-05-21.parquet
  size:    1.4 MB
  rows:    63,570
  symbols: 2,968

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-05-21 04:00:00	AAPL	Stock	127.56	127.56	127.17	127.35	17052.0
2021-05-21 05:00:00	AAPL	Stock	127.4	127.7	127.31	127.62	8624.0
2021-05-21 06:00:00	AAPL	Stock	127.51	127.62	127.41	127.49	6555.0
2021-05-21 07:00:00	AAPL	Stock	127.47	127.97	127.44	127.95	119848.0
2021-05-21 08:00:00	AAPL	Stock	127.61	127.98	127.5	127.88	331253.0
2021-05-21 09:00:00	AAPL	Stock	127.87	128.24	126.59	127.04	12717567.0
2021-05-21 10:00:00	AAPL	Stock	127.045	127.25	126.16	126.3791	10458164.0
2021-05-21 11:00:00	AAPL	Stock	126.3706	126.475	125.7	125.755	8895045.0
2021-05-21 12:00:00	AAPL	Stock	125.75	126.0	125.4	125.585	7520685.0
2021-05-21 13:00:00	AAPL	Stock	125.58	125.925	125.395	125.88	5531528.0
2021-05-21 14:00:00	AAPL	Stock	125.88	126.09	125.52	125.9576	5617856.0
2021-05-21 15:00:00	AAPL	Stock	125.96	126.08	125.21	125.43	12180817.0
2021-05-21 16:00:00	AAPL	Stock	125.45	125.45	125.32	125.35	6765747.0
2021-05-21 17:00:00	AAPL	Stock	125.36	125.41	125.35	125.38	38939.0
2021-05-21 18:00:00	AAPL	Stock	125.4	125.4	125.37	125.37	26580.0
2021-05-21 19:00:00	AAPL	Stock	125.37	125.42	125.2	125.31	48613.0
2021-05-21 04:00:00	MSFT	Stock	247.25	247.25	246.9	246.9	438.0
2021-05-21 05:00:00	MSFT	Stock	247.0	247.4	247.0	247.2	1580.0
2021-05-21 06:00:00	MSFT	Stock	247.3	247.3	247.24	247.24	2734.0
2021-05-21 07:00:00	MSFT	Stock	247.12	247.35	247.0	247.3	5962.0
2021-05-21 08:00:00	MSFT	Stock	247.1899	247.44	246.48	247.0	52266.0
2021-05-21 09:00:00	MSFT	Stock	247.02	248.4	246.5368	247.5794	2962254.0
2021-05-21 10:00:00	MSFT	Stock	247.57	247.79	245.9	246.3835	2389771.0
2021-05-21 11:00:00	MSFT	Stock	246.37	246.58	245.47	245.49	1714007.0
2021-05-21 12:00:00	MSFT	Stock	245.46	245.775	244.96	245.26	1560341.0
2021-05-21 13:00:00	MSFT	Stock	245.25	245.93	245.14	245.59	880197.0
2021-05-21 14:00:00	MSFT	Stock	245.62	245.93	245.0	245.64	1253847.0
2021-05-21 15:00:00	MSFT	Stock	245.65	245.99	244.74	245.19	3328211.0
2021-05-21 16:00:00	MSFT	Stock	245.17	245.27	244.75	245.05	3282153.0
2021-05-21 17:00:00	MSFT	Stock	245.05	245.1	244.9	245.0	4877.0
2021-05-21 18:00:00	MSFT	Stock	245.08	245.09	244.92	245.09	1037.0
2021-05-21 19:00:00	MSFT	Stock	245.09	245.2499	244.98	245.2499	5239.0
2021-05-21 04:00:00	NVDA	Stock	14.7308	14.7308	14.6875	14.6875	24880.0
2021-05-21 05:00:00	NVDA	Stock	14.7248	14.8	14.7248	14.7248	50920.0
2021-05-21 06:00:00	NVDA	Stock	14.725	14.725	14.7075	14.7075	52760.0
2021-05-21 07:00:00	NVDA	Stock	14.7225	14.775	14.7	14.7375	556280.0
2021-05-21 08:00:00	NVDA	Stock	14.705	14.775	14.705	14.721	607720.0
2021-05-21 09:00:00	NVDA	Stock	14.742	15.2593	14.742	15.1468	125134960.0
2021-05-21 10:00:00	NVDA	Stock	15.1454	15.1738	14.8694	14.9629	82749720.0
2021-05-21 11:00:00	NVDA	Stock	14.9643	14.9988	14.905	14.9289	35750640.0
2021-05-21 12:00:00	NVDA	Stock	14.9268	15.0545	14.8908	15.0224	44129920.0
2021-05-21 13:00:00	NVDA	Stock	15.0176	15.1288	14.9798	15.1034	34761320.0
2021-05-21 14:00:00	NVDA	Stock	15.1072	15.1425	15.0286	15.0984	35757080.0
2021-05-21 15:00:00	NVDA	Stock	15.0982	15.12	14.9782	14.9923	58397520.0
2021-05-21 16:00:00	NVDA	Stock	14.9918	15.007	14.9918	15.0025	22508640.0
2021-05-21 17:00:00	NVDA	Stock	15.0038	15.048	15.0	15.0412	506720.0
2021-05-21 18:00:00	NVDA	Stock	15.0438	15.05	15.0325	15.0475	325160.0
2021-05-21 19:00:00	NVDA	Stock	15.05	15.0625	15.0485	15.0612	393920.0
2021-05-21 06:00:00	AMZN	Stock	162.55	162.55	162.55	162.55	4000.0
2021-05-21 07:00:00	AMZN	Stock	162.694	163.05	162.694	162.95	27460.0

> showing 50 of 63,570 rows — these rows as CSV

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