PREVIEW / stock_1hour / 2019-12-06

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-12-06.parquet
  size:    1.1 MB
  rows:    50,623
  symbols: 2,485

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-12-06 04:00:00	AAPL	Stock	66.5	66.6825	66.5	66.65	19808.0
2019-12-06 06:00:00	AAPL	Stock	66.625	66.65	66.6225	66.65	7620.0
2019-12-06 07:00:00	AAPL	Stock	66.62	66.63	66.4375	66.5325	154464.0
2019-12-06 08:00:00	AAPL	Stock	66.5275	66.825	66.475	66.7725	988336.0
2019-12-06 09:00:00	AAPL	Stock	66.775	67.2975	66.75	67.2745	15794408.0
2019-12-06 10:00:00	AAPL	Stock	67.2725	67.4075	67.165	67.354	12231100.0
2019-12-06 11:00:00	AAPL	Stock	67.3525	67.6175	67.3275	67.555	12245984.0
2019-12-06 12:00:00	AAPL	Stock	67.55	67.75	67.5425	67.6972	10532136.0
2019-12-06 13:00:00	AAPL	Stock	67.6975	67.7125	67.49	67.52	7752428.0
2019-12-06 14:00:00	AAPL	Stock	67.5225	67.6675	67.47	67.5988	6502256.0
2019-12-06 15:00:00	AAPL	Stock	67.5988	67.7	67.495	67.675	13969516.0
2019-12-06 16:00:00	AAPL	Stock	67.6775	67.6775	67.6	67.6175	8907028.0
2019-12-06 17:00:00	AAPL	Stock	67.6225	67.65	67.615	67.64	67676.0
2019-12-06 18:00:00	AAPL	Stock	67.6625	67.6625	67.6275	67.6275	36052.0
2019-12-06 19:00:00	AAPL	Stock	67.65	67.6725	67.6275	67.6525	76580.0
2019-12-06 04:00:00	MSFT	Stock	150.38	150.65	150.38	150.55	1495.0
2019-12-06 05:00:00	MSFT	Stock	150.27	150.4	150.27	150.4	297.0
2019-12-06 06:00:00	MSFT	Stock	150.59	150.59	150.45	150.45	306.0
2019-12-06 07:00:00	MSFT	Stock	150.4	150.4	150.2	150.28	4887.0
2019-12-06 08:00:00	MSFT	Stock	150.28	150.9	150.02	150.8	89698.0
2019-12-06 09:00:00	MSFT	Stock	150.8	151.1	150.27	150.65	1845728.0
2019-12-06 10:00:00	MSFT	Stock	150.63	151.3	150.4	151.02	2408901.0
2019-12-06 11:00:00	MSFT	Stock	151.01	151.5	150.94	151.26	1351418.0
2019-12-06 12:00:00	MSFT	Stock	151.26	151.39	151.06	151.175	997744.0
2019-12-06 13:00:00	MSFT	Stock	151.18	151.5	151.15	151.396	879306.0
2019-12-06 14:00:00	MSFT	Stock	151.39	151.64	151.39	151.508	1259296.0
2019-12-06 15:00:00	MSFT	Stock	151.506	151.87	151.343	151.75	2279284.0
2019-12-06 16:00:00	MSFT	Stock	151.75	151.87	151.275	151.77	3067519.0
2019-12-06 17:00:00	MSFT	Stock	151.775	151.8	151.72	151.75	4086.0
2019-12-06 18:00:00	MSFT	Stock	151.75	151.75	151.75	151.75	470.0
2019-12-06 19:00:00	MSFT	Stock	151.75	151.8	151.7	151.8	5367.0
2019-12-06 05:00:00	NVDA	Stock	5.2438	5.2438	5.2438	5.2438	15240.0
2019-12-06 06:00:00	NVDA	Stock	5.2498	5.2498	5.2498	5.2498	24000.0
2019-12-06 07:00:00	NVDA	Stock	5.2478	5.25	5.2375	5.242	133160.0
2019-12-06 08:00:00	NVDA	Stock	5.2502	5.2915	5.24	5.2808	1892160.0
2019-12-06 09:00:00	NVDA	Stock	5.2875	5.3373	5.275	5.307	51014720.0
2019-12-06 10:00:00	NVDA	Stock	5.3071	5.3248	5.295	5.3153	37428400.0
2019-12-06 11:00:00	NVDA	Stock	5.3145	5.3288	5.3076	5.315	19471640.0
2019-12-06 12:00:00	NVDA	Stock	5.3165	5.3179	5.2916	5.2975	14773800.0
2019-12-06 13:00:00	NVDA	Stock	5.298	5.319	5.2878	5.3182	16408160.0
2019-12-06 14:00:00	NVDA	Stock	5.3178	5.3206	5.3055	5.3119	15987200.0
2019-12-06 15:00:00	NVDA	Stock	5.3116	5.3119	5.2955	5.3045	30337000.0
2019-12-06 16:00:00	NVDA	Stock	5.3042	5.3042	5.29	5.298	5747160.0
2019-12-06 17:00:00	NVDA	Stock	5.3013	5.3025	5.3013	5.3013	3196480.0
2019-12-06 18:00:00	NVDA	Stock	5.3015	5.3015	5.299	5.299	45800.0
2019-12-06 19:00:00	NVDA	Stock	5.2988	5.3025	5.2965	5.3025	93360.0
2019-12-06 07:00:00	AMZN	Stock	87.35	87.35	87.1605	87.253	86540.0
2019-12-06 08:00:00	AMZN	Stock	87.2	87.908	87.15	87.75	654100.0
2019-12-06 09:00:00	AMZN	Stock	87.705	87.72	87.182	87.637	8542940.0
2019-12-06 10:00:00	AMZN	Stock	87.6343	87.7025	87.2875	87.365	6935160.0

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

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