PREVIEW / stock_1hour / 2021-04-15

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-04-15.parquet
  size:    1.4 MB
  rows:    65,062
  symbols: 2,956

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-04-15 04:00:00	AAPL	Stock	132.77	133.07	132.62	132.75	16734.0
2021-04-15 05:00:00	AAPL	Stock	132.82	132.83	132.72	132.8	6830.0
2021-04-15 06:00:00	AAPL	Stock	132.72	133.07	132.65	133.01	8021.0
2021-04-15 07:00:00	AAPL	Stock	132.95	133.43	132.9	133.29	177785.0
2021-04-15 08:00:00	AAPL	Stock	132.9701	133.75	132.36	133.69	486398.0
2021-04-15 09:00:00	AAPL	Stock	133.69	134.96	133.44	134.3599	13539007.0
2021-04-15 10:00:00	AAPL	Stock	134.36	135.0	134.07	134.31	13366190.0
2021-04-15 11:00:00	AAPL	Stock	134.3	134.695	134.05	134.3119	7915033.0
2021-04-15 12:00:00	AAPL	Stock	134.31	134.5872	133.7	134.57	9406649.0
2021-04-15 13:00:00	AAPL	Stock	134.575	134.76	134.27	134.585	5790280.0
2021-04-15 14:00:00	AAPL	Stock	134.59	134.6899	134.13	134.28	5597969.0
2021-04-15 15:00:00	AAPL	Stock	134.27	134.51	133.94	134.51	10769175.0
2021-04-15 16:00:00	AAPL	Stock	134.5	134.5	134.2	134.28	11164206.0
2021-04-15 17:00:00	AAPL	Stock	134.26	134.35	134.2	134.34	39459.0
2021-04-15 18:00:00	AAPL	Stock	134.27	134.4	134.19	134.4	48378.0
2021-04-15 19:00:00	AAPL	Stock	134.39	134.39	134.3	134.37	35492.0
2021-04-15 04:00:00	MSFT	Stock	257.52	257.52	257.15	257.4	2284.0
2021-04-15 05:00:00	MSFT	Stock	257.46	257.53	257.1	257.1	3654.0
2021-04-15 06:00:00	MSFT	Stock	257.07	257.5	257.07	257.5	7208.0
2021-04-15 07:00:00	MSFT	Stock	257.63	257.71	257.04	257.65	16772.0
2021-04-15 08:00:00	MSFT	Stock	257.16	258.29	254.952	258.0	55353.0
2021-04-15 09:00:00	MSFT	Stock	258.01	259.35	257.7	258.53	1985769.0
2021-04-15 10:00:00	MSFT	Stock	258.54	259.68	258.12	259.11	2348373.0
2021-04-15 11:00:00	MSFT	Stock	259.11	259.59	258.0	258.21	1952728.0
2021-04-15 12:00:00	MSFT	Stock	258.21	259.69	257.9	259.67	1487962.0
2021-04-15 13:00:00	MSFT	Stock	259.67	259.93	259.09	259.14	1471865.0
2021-04-15 14:00:00	MSFT	Stock	259.18	259.2377	258.5	258.8	1570112.0
2021-04-15 15:00:00	MSFT	Stock	258.8	259.91	258.47	259.51	3225231.0
2021-04-15 16:00:00	MSFT	Stock	259.5	259.7	258.72	259.0	5450863.0
2021-04-15 17:00:00	MSFT	Stock	259.3567	259.5	259.1	259.1	20018.0
2021-04-15 18:00:00	MSFT	Stock	259.1	259.26	259.06	259.13	7023.0
2021-04-15 19:00:00	MSFT	Stock	259.2	259.35	259.2	259.35	1711.0
2021-04-15 04:00:00	NVDA	Stock	15.4738	15.4738	15.4125	15.45	78520.0
2021-04-15 05:00:00	NVDA	Stock	15.4252	15.4425	15.4252	15.4425	18360.0
2021-04-15 06:00:00	NVDA	Stock	15.4425	15.5568	15.4425	15.5562	236640.0
2021-04-15 07:00:00	NVDA	Stock	15.5282	15.592	15.5125	15.5745	1010440.0
2021-04-15 08:00:00	NVDA	Stock	15.5568	15.6722	15.2388	15.6512	1823200.0
2021-04-15 09:00:00	NVDA	Stock	15.6598	16.0237	15.6225	15.9388	84881160.0
2021-04-15 10:00:00	NVDA	Stock	15.9404	16.0653	15.8568	15.9773	70323840.0
2021-04-15 11:00:00	NVDA	Stock	15.976	16.0175	15.9108	15.9571	26141280.0
2021-04-15 12:00:00	NVDA	Stock	15.9598	16.0875	15.9162	16.0862	46384200.0
2021-04-15 13:00:00	NVDA	Stock	16.0852	16.208	16.0137	16.1941	46565480.0
2021-04-15 14:00:00	NVDA	Stock	16.1951	16.2125	16.1395	16.1982	34618120.0
2021-04-15 15:00:00	NVDA	Stock	16.1965	16.2142	16.088	16.1373	59116120.0
2021-04-15 16:00:00	NVDA	Stock	16.1455	16.1455	16.1125	16.1252	22141520.0
2021-04-15 17:00:00	NVDA	Stock	16.13	16.1338	16.12	16.125	155760.0
2021-04-15 18:00:00	NVDA	Stock	16.125	16.125	16.1025	16.122	181960.0
2021-04-15 19:00:00	NVDA	Stock	16.1078	16.1125	16.0952	16.1	367240.0
2021-04-15 04:00:00	AMZN	Stock	168.0	168.0	168.0	168.0	2000.0
2021-04-15 05:00:00	AMZN	Stock	167.75	167.75	167.75	167.75	3000.0

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

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