PREVIEW / stock_1hour / 2019-07-26

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-07-26.parquet
  size:    1.1 MB
  rows:    50,115
  symbols: 2,578

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
2019-07-26 04:00:00	AAPL	Stock	51.9	51.95	51.85	51.95	7520.0
2019-07-26 05:00:00	AAPL	Stock	51.9	51.9	51.9	51.9	1828.0
2019-07-26 06:00:00	AAPL	Stock	51.95	51.95	51.8575	51.8575	7676.0
2019-07-26 07:00:00	AAPL	Stock	51.9375	51.95	51.8525	51.8525	45436.0
2019-07-26 08:00:00	AAPL	Stock	51.89	51.95	51.8125	51.9	119120.0
2019-07-26 09:00:00	AAPL	Stock	51.8938	52.1975	51.8475	52.1575	9719456.0
2019-07-26 10:00:00	AAPL	Stock	52.1575	52.4325	51.785	52.06	15046640.0
2019-07-26 11:00:00	AAPL	Stock	52.0575	52.1375	51.9912	52.0255	5483444.0
2019-07-26 12:00:00	AAPL	Stock	52.0275	52.0725	51.955	51.9625	3646708.0
2019-07-26 13:00:00	AAPL	Stock	51.9625	52.01	51.9392	52.0012	2862480.0
2019-07-26 14:00:00	AAPL	Stock	52.0012	52.0725	51.97	52.0425	4143864.0
2019-07-26 15:00:00	AAPL	Stock	52.0425	52.13	51.935	51.9375	9351088.0
2019-07-26 16:00:00	AAPL	Stock	51.9375	52.303	51.875	51.875	7018488.0
2019-07-26 17:00:00	AAPL	Stock	51.875	51.9525	51.875	51.9375	61036.0
2019-07-26 18:00:00	AAPL	Stock	51.925	51.935	51.9	51.9125	36480.0
2019-07-26 19:00:00	AAPL	Stock	51.9125	51.9475	51.9125	51.9475	22968.0
2019-07-26 04:00:00	MSFT	Stock	140.49	140.66	140.48	140.57	740.0
2019-07-26 05:00:00	MSFT	Stock	140.6	140.66	140.6	140.66	227.0
2019-07-26 06:00:00	MSFT	Stock	140.66	140.66	140.18	140.27	3016.0
2019-07-26 07:00:00	MSFT	Stock	140.18	140.62	140.18	140.48	22700.0
2019-07-26 08:00:00	MSFT	Stock	140.38	140.62	140.25	140.36	26391.0
2019-07-26 09:00:00	MSFT	Stock	140.26	140.95	140.26	140.81	1723181.0
2019-07-26 10:00:00	MSFT	Stock	140.8	140.87	140.4	140.72	2059441.0
2019-07-26 11:00:00	MSFT	Stock	140.71	141.23	140.57	141.16	1851392.0
2019-07-26 12:00:00	MSFT	Stock	141.165	141.275	141.015	141.16	1281490.0
2019-07-26 13:00:00	MSFT	Stock	141.17	141.5	141.12	141.49	1304794.0
2019-07-26 14:00:00	MSFT	Stock	141.5	141.58	141.4	141.57	1209179.0
2019-07-26 15:00:00	MSFT	Stock	141.57	141.675	141.3	141.34	2586369.0
2019-07-26 16:00:00	MSFT	Stock	141.34	141.48	141.16	141.18	2664585.0
2019-07-26 17:00:00	MSFT	Stock	141.16	141.292	141.16	141.2	3607.0
2019-07-26 18:00:00	MSFT	Stock	141.22	141.25	141.14	141.2	1274.0
2019-07-26 19:00:00	MSFT	Stock	141.14	141.25	141.14	141.14	2024.0
2019-07-26 04:00:00	NVDA	Stock	4.3562	4.371	4.3562	4.371	14400.0
2019-07-26 06:00:00	NVDA	Stock	4.3682	4.3682	4.3682	4.3682	4000.0
2019-07-26 07:00:00	NVDA	Stock	4.3703	4.3738	4.3608	4.3738	175960.0
2019-07-26 08:00:00	NVDA	Stock	4.3692	4.3738	4.3608	4.3688	1114800.0
2019-07-26 09:00:00	NVDA	Stock	4.3699	4.4	4.36	4.395	49321600.0
2019-07-26 10:00:00	NVDA	Stock	4.3945	4.4181	4.3862	4.3978	44684400.0
2019-07-26 11:00:00	NVDA	Stock	4.3975	4.4238	4.3855	4.42	26990600.0
2019-07-26 12:00:00	NVDA	Stock	4.42	4.423	4.3978	4.398	16925640.0
2019-07-26 13:00:00	NVDA	Stock	4.3985	4.403	4.3892	4.3937	15072160.0
2019-07-26 14:00:00	NVDA	Stock	4.3935	4.4053	4.3875	4.4023	14022280.0
2019-07-26 15:00:00	NVDA	Stock	4.4025	4.4032	4.3752	4.376	37789160.0
2019-07-26 16:00:00	NVDA	Stock	4.3768	4.3772	4.374	4.375	24419200.0
2019-07-26 17:00:00	NVDA	Stock	4.3768	4.3768	4.3675	4.369	231840.0
2019-07-26 18:00:00	NVDA	Stock	4.3688	4.3705	4.3675	4.3695	183000.0
2019-07-26 19:00:00	NVDA	Stock	4.3712	4.3775	4.37	4.3775	122920.0
2019-07-26 05:00:00	AMZN	Stock	97.15	97.25	97.15	97.25	11920.0
2019-07-26 06:00:00	AMZN	Stock	97.4025	97.4025	97.4025	97.4025	2000.0
2019-07-26 07:00:00	AMZN	Stock	97.3495	97.8995	97.2105	97.6	322380.0

> showing 50 of 50,115 rows — these rows as CSV

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