PREVIEW / stock_1hour / 2020-09-08

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-09-08.parquet
  size:    1.3 MB
  rows:    58,502
  symbols: 2,481

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-09-08 04:00:00	AAPL	Stock	120.36	120.4	116.53	117.3	195256.0
2020-09-08 05:00:00	AAPL	Stock	117.3	117.93	116.49	116.74	152441.0
2020-09-08 06:00:00	AAPL	Stock	116.61	117.5	115.87	117.45	163968.0
2020-09-08 07:00:00	AAPL	Stock	117.34	117.7	115.0	115.25	918828.0
2020-09-08 08:00:00	AAPL	Stock	115.3	117.68	113.5	116.09	3227101.0
2020-09-08 09:00:00	AAPL	Stock	116.06	117.3	113.25	117.26	33791135.0
2020-09-08 10:00:00	AAPL	Stock	117.3	118.99	116.12	116.742	31634995.0
2020-09-08 11:00:00	AAPL	Stock	116.77	118.05	115.5	116.28	27983759.0
2020-09-08 12:00:00	AAPL	Stock	116.28	117.21	115.7	116.92	17379633.0
2020-09-08 13:00:00	AAPL	Stock	116.92	117.06	115.64	115.79	13556195.0
2020-09-08 14:00:00	AAPL	Stock	115.77	116.03	113.47	114.491	22926583.0
2020-09-08 15:00:00	AAPL	Stock	114.51	114.51	112.68	112.83	33499727.0
2020-09-08 16:00:00	AAPL	Stock	112.82	113.25	112.25	113.01	12365681.0
2020-09-08 17:00:00	AAPL	Stock	113.04	113.3	110.59	111.2	957074.0
2020-09-08 18:00:00	AAPL	Stock	111.27	112.82	110.88	112.15	702694.0
2020-09-08 19:00:00	AAPL	Stock	112.11	112.7	111.89	112.48	456921.0
2020-09-08 04:00:00	MSFT	Stock	214.0	214.0	209.75	209.75	19259.0
2020-09-08 05:00:00	MSFT	Stock	210.45	210.45	207.15	207.98	12506.0
2020-09-08 06:00:00	MSFT	Stock	207.85	208.57	207.13	208.57	18616.0
2020-09-08 07:00:00	MSFT	Stock	208.35	209.9	206.8	207.0	140989.0
2020-09-08 08:00:00	MSFT	Stock	207.632	209.77	205.9	206.87	266913.0
2020-09-08 09:00:00	MSFT	Stock	206.657	208.8	205.03	207.95	6943552.0
2020-09-08 10:00:00	MSFT	Stock	208.0	210.03	207.04	207.61	5399182.0
2020-09-08 11:00:00	MSFT	Stock	207.69	208.42	205.32	206.34	4387619.0
2020-09-08 12:00:00	MSFT	Stock	206.36	207.17	205.45	206.61	2997023.0
2020-09-08 13:00:00	MSFT	Stock	206.575	207.29	205.73	206.73	2482983.0
2020-09-08 14:00:00	MSFT	Stock	206.737	207.13	203.33	204.24	4340820.0
2020-09-08 15:00:00	MSFT	Stock	204.265	205.31	202.2	202.65	8040756.0
2020-09-08 16:00:00	MSFT	Stock	202.66	203.2	202.2	202.52	5281383.0
2020-09-08 17:00:00	MSFT	Stock	202.6	202.7	200.7	201.2	214278.0
2020-09-08 18:00:00	MSFT	Stock	201.2	202.89	201.12	202.71	84931.0
2020-09-08 19:00:00	MSFT	Stock	202.84	203.2	202.4	203.0	46970.0
2020-09-08 04:00:00	NVDA	Stock	12.497	12.497	12.1902	12.1902	321640.0
2020-09-08 05:00:00	NVDA	Stock	12.175	12.2095	11.975	11.975	201240.0
2020-09-08 06:00:00	NVDA	Stock	11.9675	12.06	11.9252	12.06	236760.0
2020-09-08 07:00:00	NVDA	Stock	12.0372	12.0625	11.8302	11.9002	3755680.0
2020-09-08 08:00:00	NVDA	Stock	12.0298	12.0425	11.6378	11.85	5324680.0
2020-09-08 09:00:00	NVDA	Stock	11.8498	12.2668	11.7038	12.2636	152921560.0
2020-09-08 10:00:00	NVDA	Stock	12.2685	12.55	12.1875	12.4405	150839160.0
2020-09-08 11:00:00	NVDA	Stock	12.4493	12.5245	12.2272	12.3195	100869240.0
2020-09-08 12:00:00	NVDA	Stock	12.3194	12.3948	12.281	12.3774	41860120.0
2020-09-08 13:00:00	NVDA	Stock	12.3772	12.3845	12.1878	12.211	47161840.0
2020-09-08 14:00:00	NVDA	Stock	12.2195	12.2384	11.958	12.074	64934960.0
2020-09-08 15:00:00	NVDA	Stock	12.07	12.144	11.8878	11.8966	106549680.0
2020-09-08 16:00:00	NVDA	Stock	11.8968	11.9173	11.8065	11.875	3109240.0
2020-09-08 17:00:00	NVDA	Stock	11.875	11.8875	11.7253	11.8358	1164760.0
2020-09-08 18:00:00	NVDA	Stock	11.818	11.9	11.8	11.875	1211520.0
2020-09-08 19:00:00	NVDA	Stock	11.8988	11.9062	11.8625	11.9062	598800.0
2020-09-08 04:00:00	AMZN	Stock	163.3605	163.69	162.0	162.0	29260.0
2020-09-08 05:00:00	AMZN	Stock	162.0	162.0	159.65	159.65	80960.0

> showing 50 of 58,502 rows — these rows as CSV

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