PREVIEW / stock_1hour / 2021-01-06

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-01-06.parquet
  size:    1.4 MB
  rows:    66,402
  symbols: 2,679

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-06 04:00:00	AAPL	Stock	128.5	129.03	128.0	128.56	108575.0
2021-01-06 05:00:00	AAPL	Stock	128.43	128.93	127.8	128.08	145877.0
2021-01-06 06:00:00	AAPL	Stock	128.08	128.55	127.52	128.48	100235.0
2021-01-06 07:00:00	AAPL	Stock	128.55	129.2	128.2	128.36	738427.0
2021-01-06 08:00:00	AAPL	Stock	128.36	129.16	128.01	128.15	1013563.0
2021-01-06 09:00:00	AAPL	Stock	128.149	128.78	126.55	128.06	21999519.0
2021-01-06 10:00:00	AAPL	Stock	128.07	129.74	127.59	129.387	19119823.0
2021-01-06 11:00:00	AAPL	Stock	129.39	131.05	129.1	130.12	16862298.0
2021-01-06 12:00:00	AAPL	Stock	130.13	130.705	129.88	130.01	9119465.0
2021-01-06 13:00:00	AAPL	Stock	130.02	130.26	128.94	129.25	11522942.0
2021-01-06 14:00:00	AAPL	Stock	129.255	129.45	127.1	127.94	18981336.0
2021-01-06 15:00:00	AAPL	Stock	127.93	128.22	126.382	126.58	26214319.0
2021-01-06 16:00:00	AAPL	Stock	126.68	127.24	126.31	127.08	10677595.0
2021-01-06 17:00:00	AAPL	Stock	127.1	127.46	127.0	127.26	320158.0
2021-01-06 18:00:00	AAPL	Stock	127.251	127.47	127.05	127.35	200523.0
2021-01-06 19:00:00	AAPL	Stock	127.28	127.8	127.28	127.62	266325.0
2021-01-06 04:00:00	MSFT	Stock	213.95	214.5	213.04	214.48	45281.0
2021-01-06 05:00:00	MSFT	Stock	214.48	214.84	212.56	212.86	51034.0
2021-01-06 06:00:00	MSFT	Stock	213.4	214.26	212.5	213.72	29230.0
2021-01-06 07:00:00	MSFT	Stock	214.15	214.94	213.61	213.9	91529.0
2021-01-06 08:00:00	MSFT	Stock	214.45	215.27	213.24	213.352	178153.0
2021-01-06 09:00:00	MSFT	Stock	213.38	214.66	212.0	213.25	5472328.0
2021-01-06 10:00:00	MSFT	Stock	213.24	216.15	212.83	215.13	3916223.0
2021-01-06 11:00:00	MSFT	Stock	215.13	216.49	214.86	215.51	2233303.0
2021-01-06 12:00:00	MSFT	Stock	215.52	216.43	215.52	215.748	1789103.0
2021-01-06 13:00:00	MSFT	Stock	215.77	216.295	215.01	215.56	1734568.0
2021-01-06 14:00:00	MSFT	Stock	215.56	215.704	213.86	214.24	2653466.0
2021-01-06 15:00:00	MSFT	Stock	214.21	214.5	211.94	212.22	5224060.0
2021-01-06 16:00:00	MSFT	Stock	212.12	213.0	212.05	212.83	4978869.0
2021-01-06 17:00:00	MSFT	Stock	212.82	213.2	212.51	213.0	30530.0
2021-01-06 18:00:00	MSFT	Stock	213.2	213.3	212.93	213.3	28089.0
2021-01-06 19:00:00	MSFT	Stock	213.3	213.65	213.0	213.55	13786.0
2021-01-06 04:00:00	NVDA	Stock	13.07	13.1835	13.035	13.1255	150160.0
2021-01-06 05:00:00	NVDA	Stock	13.1308	13.1308	13.0808	13.0938	173720.0
2021-01-06 06:00:00	NVDA	Stock	13.05	13.0887	13.05	13.0887	80600.0
2021-01-06 07:00:00	NVDA	Stock	13.0652	13.2042	13.0652	13.1252	1533440.0
2021-01-06 08:00:00	NVDA	Stock	13.1962	13.2	13.125	13.125	3337480.0
2021-01-06 09:00:00	NVDA	Stock	13.1325	13.245	12.9762	13.033	61380120.0
2021-01-06 10:00:00	NVDA	Stock	13.0325	13.145	12.9625	13.0559	68457480.0
2021-01-06 11:00:00	NVDA	Stock	13.0598	13.1448	13.0395	13.072	30581560.0
2021-01-06 12:00:00	NVDA	Stock	13.072	13.1345	12.9858	12.9975	44665760.0
2021-01-06 13:00:00	NVDA	Stock	13.0	13.0602	12.9785	13.0188	37099520.0
2021-01-06 14:00:00	NVDA	Stock	13.0262	13.0475	12.8232	12.8432	70768360.0
2021-01-06 15:00:00	NVDA	Stock	12.8415	12.881	12.586	12.624	120224240.0
2021-01-06 16:00:00	NVDA	Stock	12.6145	12.7305	12.6142	12.712	34328520.0
2021-01-06 17:00:00	NVDA	Stock	12.712	12.75	12.712	12.7338	982400.0
2021-01-06 18:00:00	NVDA	Stock	12.7395	12.7475	12.714	12.7475	782760.0
2021-01-06 19:00:00	NVDA	Stock	12.745	12.7625	12.738	12.7625	510080.0
2021-01-06 04:00:00	AMZN	Stock	158.0	158.0	156.701	157.9	182780.0
2021-01-06 05:00:00	AMZN	Stock	157.5005	157.7685	157.1	157.5	155980.0

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

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