PREVIEW / stock_1hour / 2020-06-30

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-06-30.parquet
  size:    1.2 MB
  rows:    57,318
  symbols: 2,456

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-06-30 04:00:00	AAPL	Stock	90.675	90.675	90.5575	90.5575	19844.0
2020-06-30 05:00:00	AAPL	Stock	90.565	90.6875	90.5275	90.5275	5668.0
2020-06-30 06:00:00	AAPL	Stock	90.535	90.555	89.625	89.65	140016.0
2020-06-30 07:00:00	AAPL	Stock	89.7875	90.435	89.7875	90.1625	212624.0
2020-06-30 08:00:00	AAPL	Stock	90.355	90.4245	89.7775	90.015	276676.0
2020-06-30 09:00:00	AAPL	Stock	90.05	91.045	89.8875	90.9575	13724256.0
2020-06-30 10:00:00	AAPL	Stock	90.9425	91.385	90.8875	91.323	17939340.0
2020-06-30 11:00:00	AAPL	Stock	91.325	91.47	91.054	91.3425	10198100.0
2020-06-30 12:00:00	AAPL	Stock	91.3425	91.3925	90.8125	90.855	8232748.0
2020-06-30 13:00:00	AAPL	Stock	90.85	90.9175	90.4325	90.76	10166064.0
2020-06-30 14:00:00	AAPL	Stock	90.7582	90.8962	90.295	90.88	10672416.0
2020-06-30 15:00:00	AAPL	Stock	90.8825	91.495	90.5625	91.15	21367832.0
2020-06-30 16:00:00	AAPL	Stock	91.1625	91.2625	90.9725	91.19	14786776.0
2020-06-30 17:00:00	AAPL	Stock	91.1875	91.195	91.05	91.1025	77188.0
2020-06-30 18:00:00	AAPL	Stock	91.1	91.1875	91.0875	91.1125	40180.0
2020-06-30 19:00:00	AAPL	Stock	91.0	91.1	91.0	91.0025	62016.0
2020-06-30 04:00:00	MSFT	Stock	199.06	199.29	198.87	198.87	964.0
2020-06-30 05:00:00	MSFT	Stock	198.53	198.8	198.53	198.8	306.0
2020-06-30 06:00:00	MSFT	Stock	198.99	199.0	198.96	198.96	412.0
2020-06-30 07:00:00	MSFT	Stock	198.82	199.1	198.5	198.53	21808.0
2020-06-30 08:00:00	MSFT	Stock	199.0	199.0	197.72	197.92	17419.0
2020-06-30 09:00:00	MSFT	Stock	197.829	200.03	197.675	199.68	2408484.0
2020-06-30 10:00:00	MSFT	Stock	199.7	201.36	199.67	201.35	3341506.0
2020-06-30 11:00:00	MSFT	Stock	201.36	201.622	200.94	201.2	2218274.0
2020-06-30 12:00:00	MSFT	Stock	201.2	201.85	200.88	201.37	1936481.0
2020-06-30 13:00:00	MSFT	Stock	201.38	201.73	200.81	201.21	1794116.0
2020-06-30 14:00:00	MSFT	Stock	201.21	202.28	200.77	202.22	2100033.0
2020-06-30 15:00:00	MSFT	Stock	202.23	204.4	201.37	203.5	8424806.0
2020-06-30 16:00:00	MSFT	Stock	203.45	203.91	202.049	203.77	6464516.0
2020-06-30 17:00:00	MSFT	Stock	203.84	203.84	203.62	203.63	7153.0
2020-06-30 18:00:00	MSFT	Stock	203.67	203.69	203.51	203.55	5219.0
2020-06-30 19:00:00	MSFT	Stock	203.51	203.51	203.11	203.15	7687.0
2020-06-30 04:00:00	NVDA	Stock	9.2772	9.2772	9.25	9.25	29560.0
2020-06-30 05:00:00	NVDA	Stock	9.25	9.3	9.25	9.3	48080.0
2020-06-30 06:00:00	NVDA	Stock	9.3	9.3125	9.3	9.3125	49720.0
2020-06-30 07:00:00	NVDA	Stock	9.32	9.3202	9.2782	9.3	393320.0
2020-06-30 08:00:00	NVDA	Stock	9.32	9.325	9.2625	9.2752	764440.0
2020-06-30 09:00:00	NVDA	Stock	9.275	9.4865	9.2558	9.475	63623400.0
2020-06-30 10:00:00	NVDA	Stock	9.4772	9.5095	9.4328	9.468	53179160.0
2020-06-30 11:00:00	NVDA	Stock	9.4666	9.491	9.4208	9.4531	26946400.0
2020-06-30 12:00:00	NVDA	Stock	9.4537	9.5263	9.4188	9.4352	43825840.0
2020-06-30 13:00:00	NVDA	Stock	9.4339	9.462	9.3832	9.4572	25351360.0
2020-06-30 14:00:00	NVDA	Stock	9.4565	9.49	9.4263	9.4885	20829240.0
2020-06-30 15:00:00	NVDA	Stock	9.4892	9.5002	9.4436	9.4862	48291920.0
2020-06-30 16:00:00	NVDA	Stock	9.4832	9.4978	9.4738	9.49	31887440.0
2020-06-30 17:00:00	NVDA	Stock	9.49	9.49	9.475	9.482	228560.0
2020-06-30 18:00:00	NVDA	Stock	9.475	9.4897	9.475	9.4792	212000.0
2020-06-30 19:00:00	NVDA	Stock	9.4648	9.4818	9.4588	9.4608	260840.0
2020-06-30 04:00:00	AMZN	Stock	134.713	134.713	134.713	134.713	2840.0
2020-06-30 05:00:00	AMZN	Stock	134.653	134.653	134.5	134.5	8280.0

> showing 50 of 57,318 rows — these rows as CSV

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