PREVIEW / stock_1hour / 2018-12-03

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-12-03.parquet
  size:    1.2 MB
  rows:    51,921
  symbols: 2,739

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
2018-12-03 04:00:00	AAPL	Stock	46.05	46.4625	46.05	46.3325	212148.0
2018-12-03 05:00:00	AAPL	Stock	46.35	46.4025	46.2125	46.275	163528.0
2018-12-03 06:00:00	AAPL	Stock	46.2525	46.2775	46.05	46.1125	299020.0
2018-12-03 07:00:00	AAPL	Stock	46.1725	46.25	46.025	46.1	837824.0
2018-12-03 08:00:00	AAPL	Stock	46.1	46.215	45.9875	46.0025	1695556.0
2018-12-03 09:00:00	AAPL	Stock	46.0	46.17	45.3325	45.415	28218016.0
2018-12-03 10:00:00	AAPL	Stock	45.4175	45.7925	45.3675	45.405	25442368.0
2018-12-03 11:00:00	AAPL	Stock	45.405	45.6725	45.3025	45.35	15790220.0
2018-12-03 12:00:00	AAPL	Stock	45.3525	45.5707	45.3525	45.535	8656488.0
2018-12-03 13:00:00	AAPL	Stock	45.535	45.7225	45.5075	45.6125	8109168.0
2018-12-03 14:00:00	AAPL	Stock	45.615	45.9375	45.4475	45.875	11924736.0
2018-12-03 15:00:00	AAPL	Stock	45.8725	46.235	45.7325	46.2325	25565428.0
2018-12-03 16:00:00	AAPL	Stock	46.2325	46.2375	45.5475	46.1225	16665976.0
2018-12-03 17:00:00	AAPL	Stock	46.125	46.205	45.75	45.7875	371028.0
2018-12-03 18:00:00	AAPL	Stock	45.775	45.8625	45.7525	45.7625	128444.0
2018-12-03 19:00:00	AAPL	Stock	45.7625	45.7625	45.45	45.5	322904.0
2018-12-03 04:00:00	MSFT	Stock	113.05	114.0	113.05	113.85	22523.0
2018-12-03 05:00:00	MSFT	Stock	113.84	113.84	113.3	113.31	14138.0
2018-12-03 06:00:00	MSFT	Stock	113.33	113.47	113.2	113.3	4640.0
2018-12-03 07:00:00	MSFT	Stock	113.36	113.47	113.01	113.34	58940.0
2018-12-03 08:00:00	MSFT	Stock	113.456	113.49	112.62	112.9	104483.0
2018-12-03 09:00:00	MSFT	Stock	112.85	113.42	111.71	111.97	5566281.0
2018-12-03 10:00:00	MSFT	Stock	111.99	112.57	110.93	110.995	5237481.0
2018-12-03 11:00:00	MSFT	Stock	111.0	112.06	110.73	111.34	4169095.0
2018-12-03 12:00:00	MSFT	Stock	111.349	111.97	111.34	111.75	1776985.0
2018-12-03 13:00:00	MSFT	Stock	111.76	112.08	111.36	111.734	1927680.0
2018-12-03 14:00:00	MSFT	Stock	111.74	112.18	111.31	112.066	2034645.0
2018-12-03 15:00:00	MSFT	Stock	112.07	112.3	111.68	112.09	5236756.0
2018-12-03 16:00:00	MSFT	Stock	112.09	112.1	111.9	111.9	4953199.0
2018-12-03 17:00:00	MSFT	Stock	111.9	112.09	110.89	112.09	42327.0
2018-12-03 18:00:00	MSFT	Stock	111.95	112.01	111.81	111.86	1694.0
2018-12-03 19:00:00	MSFT	Stock	111.81	111.99	111.53	111.93	4512.0
2018-12-03 04:00:00	NVDA	Stock	4.2378	4.321	4.2378	4.3198	906920.0
2018-12-03 05:00:00	NVDA	Stock	4.322	4.345	4.3028	4.3125	1510920.0
2018-12-03 06:00:00	NVDA	Stock	4.3153	4.3153	4.2913	4.3038	464520.0
2018-12-03 07:00:00	NVDA	Stock	4.2992	4.3062	4.2785	4.297	4048920.0
2018-12-03 08:00:00	NVDA	Stock	4.2849	4.3062	4.2752	4.296	6654360.0
2018-12-03 09:00:00	NVDA	Stock	4.2955	4.367	4.2593	4.2768	192928960.0
2018-12-03 10:00:00	NVDA	Stock	4.2788	4.3263	4.2288	4.2315	152064400.0
2018-12-03 11:00:00	NVDA	Stock	4.232	4.2798	4.205	4.2116	89535280.0
2018-12-03 12:00:00	NVDA	Stock	4.2125	4.2265	4.1835	4.2125	72393640.0
2018-12-03 13:00:00	NVDA	Stock	4.2135	4.2417	4.1852	4.1992	55775680.0
2018-12-03 14:00:00	NVDA	Stock	4.1983	4.2505	4.1862	4.2424	59080720.0
2018-12-03 15:00:00	NVDA	Stock	4.2432	4.2678	4.2305	4.2513	88438360.0
2018-12-03 16:00:00	NVDA	Stock	4.2513	4.2525	4.2425	4.245	41927600.0
2018-12-03 17:00:00	NVDA	Stock	4.244	4.251	4.244	4.251	308960.0
2018-12-03 18:00:00	NVDA	Stock	4.2488	4.2502	4.245	4.2478	552000.0
2018-12-03 19:00:00	NVDA	Stock	4.2495	4.2518	4.2385	4.2403	564320.0
2018-12-03 04:00:00	AMZN	Stock	88.2	88.35	87.9945	88.225	118880.0
2018-12-03 05:00:00	AMZN	Stock	88.25	88.35	88.25	88.271	58680.0

> showing 50 of 51,921 rows — these rows as CSV

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