PREVIEW / stock_1hour / 2021-01-15

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-01-15.parquet
  size:    1.4 MB
  rows:    66,186
  symbols: 2,707

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-15 04:00:00	AAPL	Stock	129.22	129.22	128.8	128.8	16949.0
2021-01-15 05:00:00	AAPL	Stock	128.72	129.04	128.72	128.84	17234.0
2021-01-15 06:00:00	AAPL	Stock	128.82	129.0	128.63	128.84	28586.0
2021-01-15 07:00:00	AAPL	Stock	128.86	129.26	128.77	129.06	138826.0
2021-01-15 08:00:00	AAPL	Stock	129.12	129.25	128.75	129.01	333848.0
2021-01-15 09:00:00	AAPL	Stock	129.01	130.224	128.63	129.15	16921446.0
2021-01-15 10:00:00	AAPL	Stock	129.154	129.16	127.5	128.225	14507049.0
2021-01-15 11:00:00	AAPL	Stock	128.23	129.35	127.592	128.75	11527527.0
2021-01-15 12:00:00	AAPL	Stock	128.755	128.8	128.19	128.485	7538285.0
2021-01-15 13:00:00	AAPL	Stock	128.48	128.93	128.27	128.492	5546931.0
2021-01-15 14:00:00	AAPL	Stock	128.5	128.73	127.65	127.728	7216718.0
2021-01-15 15:00:00	AAPL	Stock	127.74	127.97	127.0	127.07	14828601.0
2021-01-15 16:00:00	AAPL	Stock	127.14	128.48	126.9	126.92	12063343.0
2021-01-15 17:00:00	AAPL	Stock	126.92	127.18	126.9	127.12	134851.0
2021-01-15 18:00:00	AAPL	Stock	127.12	127.15	127.01	127.06	76682.0
2021-01-15 19:00:00	AAPL	Stock	127.06	127.14	126.8	126.82	123430.0
2021-01-15 04:00:00	MSFT	Stock	213.52	213.6	213.25	213.4	20036.0
2021-01-15 05:00:00	MSFT	Stock	213.4	213.5	213.11	213.16	6155.0
2021-01-15 06:00:00	MSFT	Stock	213.16	213.78	212.83	213.4	9431.0
2021-01-15 07:00:00	MSFT	Stock	213.11	213.86	213.11	213.71	21557.0
2021-01-15 08:00:00	MSFT	Stock	213.677	213.88	212.49	213.7	38527.0
2021-01-15 09:00:00	MSFT	Stock	213.71	214.51	212.95	213.635	5022378.0
2021-01-15 10:00:00	MSFT	Stock	213.655	214.03	212.03	213.2	3347567.0
2021-01-15 11:00:00	MSFT	Stock	213.22	214.22	212.24	213.771	2227369.0
2021-01-15 12:00:00	MSFT	Stock	213.76	213.98	212.94	213.15	1611458.0
2021-01-15 13:00:00	MSFT	Stock	213.14	214.02	212.95	213.714	1234894.0
2021-01-15 14:00:00	MSFT	Stock	213.72	214.21	213.5	213.52	1362820.0
2021-01-15 15:00:00	MSFT	Stock	213.514	214.0	212.57	212.58	3184509.0
2021-01-15 16:00:00	MSFT	Stock	212.58	213.04	212.34	212.47	6546695.0
2021-01-15 17:00:00	MSFT	Stock	212.47	212.59	212.42	212.59	19350.0
2021-01-15 18:00:00	MSFT	Stock	212.64	212.64	212.22	212.36	5576.0
2021-01-15 19:00:00	MSFT	Stock	212.36	212.55	212.36	212.45	6623.0
2021-01-15 05:00:00	NVDA	Stock	13.1752	13.1752	13.1658	13.1658	8000.0
2021-01-15 07:00:00	NVDA	Stock	13.1775	13.2673	13.1752	13.2673	389760.0
2021-01-15 08:00:00	NVDA	Stock	13.1813	13.3	13.1625	13.25	509560.0
2021-01-15 09:00:00	NVDA	Stock	13.2405	13.3252	13.1333	13.1692	38818240.0
2021-01-15 10:00:00	NVDA	Stock	13.1752	13.1838	12.9134	12.9588	53295520.0
2021-01-15 11:00:00	NVDA	Stock	12.961	13.055	12.8955	12.9929	22300920.0
2021-01-15 12:00:00	NVDA	Stock	12.9928	13.0372	12.9433	13.0248	16253720.0
2021-01-15 13:00:00	NVDA	Stock	13.0217	13.0572	12.9938	13.0325	10870600.0
2021-01-15 14:00:00	NVDA	Stock	13.0322	13.0485	12.9595	12.9668	12989080.0
2021-01-15 15:00:00	NVDA	Stock	12.9713	12.9785	12.8485	12.8595	46455760.0
2021-01-15 16:00:00	NVDA	Stock	12.8595	12.8858	12.8125	12.8125	9562600.0
2021-01-15 17:00:00	NVDA	Stock	12.8125	12.846	12.8002	12.846	376960.0
2021-01-15 18:00:00	NVDA	Stock	12.8418	12.8623	12.8418	12.8575	111520.0
2021-01-15 19:00:00	NVDA	Stock	12.8623	12.8625	12.8275	12.8625	120160.0
2021-01-15 04:00:00	AMZN	Stock	156.6	156.6	156.55	156.55	7800.0
2021-01-15 07:00:00	AMZN	Stock	156.575	156.8	156.5	156.5	35360.0
2021-01-15 08:00:00	AMZN	Stock	156.35	157.15	156.35	156.875	240820.0
2021-01-15 09:00:00	AMZN	Stock	157.0	157.1272	155.711	155.721	9278540.0

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

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