PREVIEW / stock_1hour / 2021-06-22

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-06-22.parquet
  size:    1.4 MB
  rows:    65,207
  symbols: 2,940

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-06-22 04:00:00	AAPL	Stock	131.65	131.84	131.39	131.65	28443.0
2021-06-22 05:00:00	AAPL	Stock	131.7	132.0	131.67	131.82	12243.0
2021-06-22 06:00:00	AAPL	Stock	131.87	132.12	131.87	132.04	6615.0
2021-06-22 07:00:00	AAPL	Stock	132.1	132.63	132.09	132.5	80988.0
2021-06-22 08:00:00	AAPL	Stock	132.2101	132.65	132.04	132.18	300633.0
2021-06-22 09:00:00	AAPL	Stock	132.19	132.83	131.77	131.875	9293273.0
2021-06-22 10:00:00	AAPL	Stock	131.88	132.44	131.62	132.28	9325468.0
2021-06-22 11:00:00	AAPL	Stock	132.275	132.76	132.2401	132.45	5690116.0
2021-06-22 12:00:00	AAPL	Stock	132.46	133.38	132.4	133.1784	8131986.0
2021-06-22 13:00:00	AAPL	Stock	133.17	133.415	133.0423	133.205	4394912.0
2021-06-22 14:00:00	AAPL	Stock	133.205	133.58	133.08	133.565	5260632.0
2021-06-22 15:00:00	AAPL	Stock	133.56	134.08	133.56	133.97	13391355.0
2021-06-22 16:00:00	AAPL	Stock	133.98	134.1	132.8606	133.98	11575221.0
2021-06-22 17:00:00	AAPL	Stock	134.0	134.05	133.92	133.97	53945.0
2021-06-22 18:00:00	AAPL	Stock	133.97	134.08	133.89	133.98	94488.0
2021-06-22 19:00:00	AAPL	Stock	133.98	134.09	133.96	134.07	53227.0
2021-06-22 04:00:00	MSFT	Stock	261.69	262.3	261.69	262.3	1662.0
2021-06-22 05:00:00	MSFT	Stock	262.39	262.63	262.34	262.5	2124.0
2021-06-22 06:00:00	MSFT	Stock	262.63	263.0	262.63	262.63	1881.0
2021-06-22 07:00:00	MSFT	Stock	263.4	263.77	263.24	263.35	12287.0
2021-06-22 08:00:00	MSFT	Stock	263.5	263.65	262.7	263.0	38915.0
2021-06-22 09:00:00	MSFT	Stock	262.96	264.69	262.4	264.08	2650357.0
2021-06-22 10:00:00	MSFT	Stock	264.08	264.81	263.46	263.6882	2282407.0
2021-06-22 11:00:00	MSFT	Stock	263.69	264.56	263.37	264.2599	1330526.0
2021-06-22 12:00:00	MSFT	Stock	264.27	264.785	264.15	264.57	1556029.0
2021-06-22 13:00:00	MSFT	Stock	264.56	264.76	264.24	264.58	1031125.0
2021-06-22 14:00:00	MSFT	Stock	264.5886	265.14	264.435	265.125	1606309.0
2021-06-22 15:00:00	MSFT	Stock	265.125	265.79	265.06	265.51	3656868.0
2021-06-22 16:00:00	MSFT	Stock	265.51	265.75	265.41	265.51	3782759.0
2021-06-22 17:00:00	MSFT	Stock	265.74	265.85	265.74	265.75	8168.0
2021-06-22 18:00:00	MSFT	Stock	265.7	265.82	265.61	265.82	4120.0
2021-06-22 19:00:00	MSFT	Stock	265.82	266.0	265.8	266.0	3587.0
2021-06-22 04:00:00	NVDA	Stock	18.3598	18.3598	18.3282	18.3282	15320.0
2021-06-22 05:00:00	NVDA	Stock	18.33	18.3475	18.33	18.3455	29920.0
2021-06-22 06:00:00	NVDA	Stock	18.4028	18.4572	18.3775	18.4572	56040.0
2021-06-22 07:00:00	NVDA	Stock	18.475	18.6	18.475	18.5375	1402360.0
2021-06-22 08:00:00	NVDA	Stock	18.4752	18.6	18.35	18.3998	2347440.0
2021-06-22 09:00:00	NVDA	Stock	18.3775	18.7186	18.3775	18.5503	70381160.0
2021-06-22 10:00:00	NVDA	Stock	18.5495	18.8722	18.4852	18.8308	107267080.0
2021-06-22 11:00:00	NVDA	Stock	18.8315	18.8742	18.723	18.8315	43040360.0
2021-06-22 12:00:00	NVDA	Stock	18.8347	18.9638	18.83	18.8686	28949400.0
2021-06-22 13:00:00	NVDA	Stock	18.8712	18.8725	18.7643	18.8	30473800.0
2021-06-22 14:00:00	NVDA	Stock	18.8035	18.819	18.7005	18.7861	26136520.0
2021-06-22 15:00:00	NVDA	Stock	18.785	18.918	18.7679	18.884	47092160.0
2021-06-22 16:00:00	NVDA	Stock	18.8868	18.895	18.878	18.8898	24102000.0
2021-06-22 17:00:00	NVDA	Stock	18.8895	18.8925	18.8625	18.8905	411240.0
2021-06-22 18:00:00	NVDA	Stock	18.8865	18.8868	18.8755	18.8812	114480.0
2021-06-22 19:00:00	NVDA	Stock	18.8812	18.9	18.8812	18.8975	334560.0
2021-06-22 06:00:00	AMZN	Stock	171.7655	172.4	171.7655	172.4	20600.0
2021-06-22 07:00:00	AMZN	Stock	172.7	173.2	172.7	173.153	52260.0

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

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