PREVIEW / stock_1hour / 2020-09-14

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-09-14.parquet
  size:    1.2 MB
  rows:    56,946
  symbols: 2,501

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
2020-09-14 04:00:00	AAPL	Stock	114.65	115.15	113.9	114.19	105117.0
2020-09-14 05:00:00	AAPL	Stock	114.18	114.61	113.8	114.2	35602.0
2020-09-14 06:00:00	AAPL	Stock	114.12	114.98	114.1	114.8	47884.0
2020-09-14 07:00:00	AAPL	Stock	114.75	114.87	113.7	113.77	601604.0
2020-09-14 08:00:00	AAPL	Stock	114.16	114.69	113.49	113.87	1024890.0
2020-09-14 09:00:00	AAPL	Stock	113.88	115.71	113.52	114.83	19347307.0
2020-09-14 10:00:00	AAPL	Stock	114.81	115.42	113.85	114.5	19894787.0
2020-09-14 11:00:00	AAPL	Stock	114.49	114.75	113.67	114.512	12217354.0
2020-09-14 12:00:00	AAPL	Stock	114.51	114.81	114.0	114.34	10244412.0
2020-09-14 13:00:00	AAPL	Stock	114.35	114.48	112.8	113.72	12696007.0
2020-09-14 14:00:00	AAPL	Stock	113.72	114.61	113.43	114.438	13381934.0
2020-09-14 15:00:00	AAPL	Stock	114.45	115.93	114.2	115.36	21418775.0
2020-09-14 16:00:00	AAPL	Stock	115.35	115.95	115.13	115.63	10025851.0
2020-09-14 17:00:00	AAPL	Stock	115.62	115.94	115.51	115.88	238614.0
2020-09-14 18:00:00	AAPL	Stock	115.88	116.0	115.75	115.94	197478.0
2020-09-14 19:00:00	AAPL	Stock	115.93	115.95	115.75	115.94	279344.0
2020-09-14 04:00:00	MSFT	Stock	203.93	204.0	202.31	203.3	47832.0
2020-09-14 05:00:00	MSFT	Stock	203.28	203.45	203.0	203.0	10801.0
2020-09-14 06:00:00	MSFT	Stock	203.2	204.77	203.2	204.5	8289.0
2020-09-14 07:00:00	MSFT	Stock	204.38	204.5	202.75	202.75	113251.0
2020-09-14 08:00:00	MSFT	Stock	203.35	204.115	202.349	203.27	156780.0
2020-09-14 09:00:00	MSFT	Stock	203.25	207.84	202.97	207.28	3829366.0
2020-09-14 10:00:00	MSFT	Stock	207.31	209.2	206.87	208.59	3626023.0
2020-09-14 11:00:00	MSFT	Stock	208.54	208.85	207.66	208.07	1843405.0
2020-09-14 12:00:00	MSFT	Stock	208.06	208.37	206.68	206.94	1680631.0
2020-09-14 13:00:00	MSFT	Stock	206.94	207.28	205.04	205.83	2018432.0
2020-09-14 14:00:00	MSFT	Stock	205.82	206.385	204.8	205.72	2213032.0
2020-09-14 15:00:00	MSFT	Stock	205.73	207.03	205.14	205.3	4437402.0
2020-09-14 16:00:00	MSFT	Stock	205.41	206.18	205.284	205.69	4657008.0
2020-09-14 17:00:00	MSFT	Stock	205.69	206.0	205.6	205.99	18109.0
2020-09-14 18:00:00	MSFT	Stock	205.94	206.0	205.6	205.9	29839.0
2020-09-14 19:00:00	MSFT	Stock	205.9	205.96	205.5	205.7	14119.0
2020-09-14 04:00:00	NVDA	Stock	12.65	13.05	12.6265	12.774	2558240.0
2020-09-14 05:00:00	NVDA	Stock	12.8065	12.85	12.7625	12.8125	371280.0
2020-09-14 06:00:00	NVDA	Stock	12.825	12.995	12.825	12.9625	1000280.0
2020-09-14 07:00:00	NVDA	Stock	12.9382	12.975	12.7788	12.9248	7096560.0
2020-09-14 08:00:00	NVDA	Stock	12.9145	12.964	12.7983	12.9068	10925680.0
2020-09-14 09:00:00	NVDA	Stock	12.9192	13.315	12.9192	13.1613	263999560.0
2020-09-14 10:00:00	NVDA	Stock	13.1592	13.185	12.8725	12.998	234576120.0
2020-09-14 11:00:00	NVDA	Stock	12.9963	13.0388	12.8092	12.952	145767440.0
2020-09-14 12:00:00	NVDA	Stock	12.9488	12.9973	12.7729	12.7976	81274320.0
2020-09-14 13:00:00	NVDA	Stock	12.7996	12.8196	12.6312	12.7742	111074920.0
2020-09-14 14:00:00	NVDA	Stock	12.7708	12.854	12.7275	12.7828	71534120.0
2020-09-14 15:00:00	NVDA	Stock	12.7845	12.95	12.7503	12.871	102344880.0
2020-09-14 16:00:00	NVDA	Stock	12.8723	12.903	12.85	12.8878	26063120.0
2020-09-14 17:00:00	NVDA	Stock	12.8935	12.9998	12.8888	12.975	2048800.0
2020-09-14 18:00:00	NVDA	Stock	12.9748	13.0	12.9602	12.988	956560.0
2020-09-14 19:00:00	NVDA	Stock	12.9943	12.9943	12.941	12.9575	900320.0
2020-09-14 04:00:00	AMZN	Stock	158.26	159.05	158.26	159.05	14960.0
2020-09-14 06:00:00	AMZN	Stock	158.5	158.5	158.5	158.5	2000.0

> showing 50 of 56,946 rows — these rows as CSV

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