PREVIEW / stock_1hour / 2020-12-28

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-12-28.parquet
  size:    1.4 MB
  rows:    67,772
  symbols: 2,687

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-12-28 04:00:00	AAPL	Stock	132.72	133.0	132.6	132.99	19506.0
2020-12-28 05:00:00	AAPL	Stock	133.0	133.0	132.57	132.8	28554.0
2020-12-28 06:00:00	AAPL	Stock	132.87	132.99	132.75	132.87	11617.0
2020-12-28 07:00:00	AAPL	Stock	132.88	133.65	132.81	133.65	368579.0
2020-12-28 08:00:00	AAPL	Stock	133.18	134.0	132.915	133.98	963382.0
2020-12-28 09:00:00	AAPL	Stock	133.99	135.74	133.51	135.44	21676829.0
2020-12-28 10:00:00	AAPL	Stock	135.43	135.58	134.15	134.975	17398711.0
2020-12-28 11:00:00	AAPL	Stock	134.98	136.39	134.95	136.29	15450867.0
2020-12-28 12:00:00	AAPL	Stock	136.29	136.4	135.79	136.309	10825526.0
2020-12-28 13:00:00	AAPL	Stock	136.31	136.44	135.985	136.155	7954316.0
2020-12-28 14:00:00	AAPL	Stock	136.155	136.98	136.15	136.885	11106002.0
2020-12-28 15:00:00	AAPL	Stock	136.885	137.34	136.34	136.73	17974278.0
2020-12-28 16:00:00	AAPL	Stock	136.73	137.25	136.67	137.07	6786774.0
2020-12-28 17:00:00	AAPL	Stock	137.05	137.24	136.69	137.03	288286.0
2020-12-28 18:00:00	AAPL	Stock	137.05	137.18	136.69	137.0	318111.0
2020-12-28 19:00:00	AAPL	Stock	136.98	137.2	136.92	137.2	173019.0
2020-12-28 04:00:00	MSFT	Stock	223.44	223.98	223.44	223.98	1741.0
2020-12-28 05:00:00	MSFT	Stock	223.96	223.97	223.77	223.95	2510.0
2020-12-28 06:00:00	MSFT	Stock	223.96	223.98	222.9	223.3	7365.0
2020-12-28 07:00:00	MSFT	Stock	223.0	224.36	223.0	224.36	20189.0
2020-12-28 08:00:00	MSFT	Stock	224.21	224.5	222.2	224.4	29510.0
2020-12-28 09:00:00	MSFT	Stock	224.45	224.55	223.15	223.74	1558718.0
2020-12-28 10:00:00	MSFT	Stock	223.75	226.03	223.02	225.922	3086819.0
2020-12-28 11:00:00	MSFT	Stock	225.93	225.95	224.81	225.165	1739106.0
2020-12-28 12:00:00	MSFT	Stock	225.17	225.4	224.83	225.24	1221056.0
2020-12-28 13:00:00	MSFT	Stock	225.23	225.69	225.02	225.5	1094669.0
2020-12-28 14:00:00	MSFT	Stock	225.495	225.88	225.19	225.64	1491112.0
2020-12-28 15:00:00	MSFT	Stock	225.63	225.66	224.865	224.96	2194217.0
2020-12-28 16:00:00	MSFT	Stock	224.96	224.96	224.72	224.8	2059524.0
2020-12-28 17:00:00	MSFT	Stock	224.9	224.96	224.72	224.89	106463.0
2020-12-28 18:00:00	MSFT	Stock	224.89	225.0	224.71	225.0	10965.0
2020-12-28 19:00:00	MSFT	Stock	225.07	225.15	224.99	225.15	9199.0
2020-12-28 04:00:00	NVDA	Stock	12.9875	13.0305	12.9875	13.0305	9200.0
2020-12-28 05:00:00	NVDA	Stock	13.047	13.05	13.047	13.05	8840.0
2020-12-28 06:00:00	NVDA	Stock	13.037	13.037	13.037	13.037	4400.0
2020-12-28 07:00:00	NVDA	Stock	13.0298	13.045	13.025	13.045	207320.0
2020-12-28 08:00:00	NVDA	Stock	13.04	13.0625	13.03	13.055	774600.0
2020-12-28 09:00:00	NVDA	Stock	13.055	13.0715	12.9724	12.9933	23615840.0
2020-12-28 10:00:00	NVDA	Stock	12.9928	13.0014	12.7632	12.9192	43193040.0
2020-12-28 11:00:00	NVDA	Stock	12.9225	12.9545	12.8475	12.8885	16558920.0
2020-12-28 12:00:00	NVDA	Stock	12.8882	12.9165	12.8593	12.8898	11460720.0
2020-12-28 13:00:00	NVDA	Stock	12.8925	12.9662	12.8843	12.908	11733080.0
2020-12-28 14:00:00	NVDA	Stock	12.9065	12.9212	12.8798	12.8988	9687320.0
2020-12-28 15:00:00	NVDA	Stock	12.899	12.9198	12.8598	12.9055	21223560.0
2020-12-28 16:00:00	NVDA	Stock	12.9	12.9013	12.8753	12.8875	944920.0
2020-12-28 17:00:00	NVDA	Stock	12.9	12.9088	12.8765	12.8765	616120.0
2020-12-28 18:00:00	NVDA	Stock	12.879	12.895	12.879	12.895	27280.0
2020-12-28 19:00:00	NVDA	Stock	12.894	12.9105	12.894	12.9088	31440.0
2020-12-28 04:00:00	AMZN	Stock	159.25	160.0	159.25	159.7355	12440.0
2020-12-28 05:00:00	AMZN	Stock	159.6325	159.6325	159.6325	159.6325	4680.0

> showing 50 of 67,772 rows — these rows as CSV

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