PREVIEW / stock_1hour / 2020-08-17

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-08-17.parquet
  size:    1.3 MB
  rows:    56,915
  symbols: 2,442

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-08-17 04:00:00	AAPL	Stock	115.6	115.6225	115.45	115.6	15624.0
2020-08-17 05:00:00	AAPL	Stock	115.56	115.6	115.5525	115.5925	11776.0
2020-08-17 06:00:00	AAPL	Stock	115.6125	115.65	115.5775	115.5775	14784.0
2020-08-17 07:00:00	AAPL	Stock	115.6025	115.6625	115.2575	115.4625	312348.0
2020-08-17 08:00:00	AAPL	Stock	115.5275	116.0	115.1925	115.975	666696.0
2020-08-17 09:00:00	AAPL	Stock	115.9975	116.1225	115.1725	115.4625	15396652.0
2020-08-17 10:00:00	AAPL	Stock	115.46	115.5825	114.2925	114.5525	17184240.0
2020-08-17 11:00:00	AAPL	Stock	114.5535	114.72	113.9625	114.335	11877056.0
2020-08-17 12:00:00	AAPL	Stock	114.3362	114.6825	114.27	114.6725	7646980.0
2020-08-17 13:00:00	AAPL	Stock	114.675	114.795	114.285	114.6662	6379496.0
2020-08-17 14:00:00	AAPL	Stock	114.66	115.2275	114.6	115.0738	9669664.0
2020-08-17 15:00:00	AAPL	Stock	115.0675	115.2025	114.5	114.5975	11738304.0
2020-08-17 16:00:00	AAPL	Stock	114.5975	114.6875	114.51	114.655	8462252.0
2020-08-17 17:00:00	AAPL	Stock	114.62	114.6525	114.58	114.58	35212.0
2020-08-17 18:00:00	AAPL	Stock	114.61	114.625	114.575	114.6025	40840.0
2020-08-17 19:00:00	AAPL	Stock	114.59	114.7625	114.575	114.75	154284.0
2020-08-17 04:00:00	MSFT	Stock	209.75	209.88	209.0	209.53	2851.0
2020-08-17 05:00:00	MSFT	Stock	209.69	209.75	209.69	209.7	600.0
2020-08-17 06:00:00	MSFT	Stock	209.7	209.87	209.7	209.87	1491.0
2020-08-17 07:00:00	MSFT	Stock	209.79	209.94	209.26	209.35	23277.0
2020-08-17 08:00:00	MSFT	Stock	209.61	209.7	209.08	209.54	49534.0
2020-08-17 09:00:00	MSFT	Stock	209.536	210.37	208.9	210.31	2346617.0
2020-08-17 10:00:00	MSFT	Stock	210.32	211.187	209.97	210.508	2585751.0
2020-08-17 11:00:00	MSFT	Stock	210.51	210.524	209.595	209.86	1409282.0
2020-08-17 12:00:00	MSFT	Stock	209.88	210.269	209.51	210.01	1098388.0
2020-08-17 13:00:00	MSFT	Stock	210.01	210.4	209.78	209.913	914211.0
2020-08-17 14:00:00	MSFT	Stock	209.907	210.39	209.82	210.36	951714.0
2020-08-17 15:00:00	MSFT	Stock	210.33	210.6	209.89	210.249	2079491.0
2020-08-17 16:00:00	MSFT	Stock	210.28	210.28	209.86	210.0	3600160.0
2020-08-17 17:00:00	MSFT	Stock	210.05	210.09	210.0	210.08	3909.0
2020-08-17 18:00:00	MSFT	Stock	210.09	210.18	210.08	210.16	2757.0
2020-08-17 19:00:00	MSFT	Stock	210.21	210.4	210.2	210.4	13626.0
2020-08-17 04:00:00	NVDA	Stock	11.6102	11.7045	11.6102	11.7045	284960.0
2020-08-17 05:00:00	NVDA	Stock	11.7045	11.731	11.7045	11.7125	136560.0
2020-08-17 06:00:00	NVDA	Stock	11.7095	11.7095	11.7095	11.7095	23320.0
2020-08-17 07:00:00	NVDA	Stock	11.7348	11.8145	11.7125	11.7983	2150680.0
2020-08-17 08:00:00	NVDA	Stock	11.7975	11.8972	11.7125	11.862	4799720.0
2020-08-17 09:00:00	NVDA	Stock	11.8612	12.1513	11.8172	12.1472	120509840.0
2020-08-17 10:00:00	NVDA	Stock	12.15	12.283	12.1302	12.2455	106526760.0
2020-08-17 11:00:00	NVDA	Stock	12.244	12.3062	12.2065	12.2438	65692600.0
2020-08-17 12:00:00	NVDA	Stock	12.2448	12.3862	12.2438	12.3664	52738800.0
2020-08-17 13:00:00	NVDA	Stock	12.3658	12.3975	12.3293	12.3585	46762680.0
2020-08-17 14:00:00	NVDA	Stock	12.3565	12.4098	12.3252	12.3928	43451760.0
2020-08-17 15:00:00	NVDA	Stock	12.393	12.393	12.2768	12.3395	62035160.0
2020-08-17 16:00:00	NVDA	Stock	12.337	12.3725	12.315	12.3675	39286480.0
2020-08-17 17:00:00	NVDA	Stock	12.3655	12.3925	12.3645	12.382	1147360.0
2020-08-17 18:00:00	NVDA	Stock	12.385	12.3998	12.3825	12.3963	727320.0
2020-08-17 19:00:00	NVDA	Stock	12.3905	12.4225	12.3702	12.4188	760880.0
2020-08-17 06:00:00	AMZN	Stock	157.85	157.85	157.85	157.85	2000.0
2020-08-17 07:00:00	AMZN	Stock	158.094	158.65	158.094	158.5925	105800.0

> showing 50 of 56,915 rows — these rows as CSV

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