PREVIEW / stock_1hour / 2019-03-11

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-03-11.parquet
  size:    1.1 MB
  rows:    49,920
  symbols: 2,657

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-03-11 04:00:00	AAPL	Stock	43.3425	43.3425	43.325	43.325	800.0
2019-03-11 05:00:00	AAPL	Stock	43.325	43.3725	43.325	43.35	14668.0
2019-03-11 06:00:00	AAPL	Stock	43.3725	44.085	43.3725	44.0475	231648.0
2019-03-11 07:00:00	AAPL	Stock	43.965	44.0	43.855	43.975	228108.0
2019-03-11 08:00:00	AAPL	Stock	44.0	44.06	43.8375	44.0	586376.0
2019-03-11 09:00:00	AAPL	Stock	44.0125	44.3375	43.8325	44.3338	18947672.0
2019-03-11 10:00:00	AAPL	Stock	44.335	44.5425	44.2525	44.533	20184252.0
2019-03-11 11:00:00	AAPL	Stock	44.5325	44.7275	44.5	44.6938	13771544.0
2019-03-11 12:00:00	AAPL	Stock	44.695	44.745	44.6175	44.635	9167824.0
2019-03-11 13:00:00	AAPL	Stock	44.6375	44.7375	44.615	44.71	7614280.0
2019-03-11 14:00:00	AAPL	Stock	44.71	44.7152	44.6275	44.66	7828960.0
2019-03-11 15:00:00	AAPL	Stock	44.66	44.78	44.6125	44.745	19167408.0
2019-03-11 16:00:00	AAPL	Stock	44.725	44.875	44.7225	44.85	11492760.0
2019-03-11 17:00:00	AAPL	Stock	44.86	44.86	44.7975	44.825	39856.0
2019-03-11 18:00:00	AAPL	Stock	44.7975	44.95	44.7975	44.95	100560.0
2019-03-11 19:00:00	AAPL	Stock	44.935	44.96	44.8875	44.96	74316.0
2019-03-11 04:00:00	MSFT	Stock	110.81	110.81	110.81	110.81	100.0
2019-03-11 06:00:00	MSFT	Stock	110.82	110.82	110.53	110.75	8197.0
2019-03-11 07:00:00	MSFT	Stock	110.75	110.96	110.55	110.87	10842.0
2019-03-11 08:00:00	MSFT	Stock	110.8	111.21	110.7	111.17	28755.0
2019-03-11 09:00:00	MSFT	Stock	111.11	112.29	110.85	112.09	2740715.0
2019-03-11 10:00:00	MSFT	Stock	112.09	112.45	112.04	112.425	2706186.0
2019-03-11 11:00:00	MSFT	Stock	112.43	112.86	112.22	112.685	2527822.0
2019-03-11 12:00:00	MSFT	Stock	112.685	112.93	112.54	112.565	2010752.0
2019-03-11 13:00:00	MSFT	Stock	112.57	112.94	112.47	112.795	1580448.0
2019-03-11 14:00:00	MSFT	Stock	112.799	112.82	112.485	112.74	1685666.0
2019-03-11 15:00:00	MSFT	Stock	112.73	112.95	112.62	112.83	4221727.0
2019-03-11 16:00:00	MSFT	Stock	112.83	112.95	112.65	112.9	3984305.0
2019-03-11 17:00:00	MSFT	Stock	112.9	112.9	112.83	112.87	1935.0
2019-03-11 18:00:00	MSFT	Stock	112.84	113.3	112.8	113.29	19334.0
2019-03-11 19:00:00	MSFT	Stock	113.25	113.25	113.1	113.16	2968.0
2019-03-11 04:00:00	NVDA	Stock	3.7773	3.7773	3.7135	3.7185	457640.0
2019-03-11 05:00:00	NVDA	Stock	3.7105	3.7188	3.7072	3.71	158320.0
2019-03-11 06:00:00	NVDA	Stock	3.7008	3.7008	3.6763	3.6938	510440.0
2019-03-11 07:00:00	NVDA	Stock	3.6932	3.8195	3.6932	3.8	3806920.0
2019-03-11 08:00:00	NVDA	Stock	3.8175	3.8625	3.7	3.8362	6438520.0
2019-03-11 09:00:00	NVDA	Stock	3.8375	3.8568	3.7422	3.8512	82876080.0
2019-03-11 10:00:00	NVDA	Stock	3.851	3.9288	3.851	3.9288	85206080.0
2019-03-11 11:00:00	NVDA	Stock	3.9288	3.9675	3.9241	3.9661	111317720.0
2019-03-11 12:00:00	NVDA	Stock	3.967	4.025	3.956	4.0185	126088040.0
2019-03-11 13:00:00	NVDA	Stock	4.0185	4.0515	4.0185	4.0413	124809880.0
2019-03-11 14:00:00	NVDA	Stock	4.0413	4.0502	4.0205	4.0348	101972640.0
2019-03-11 15:00:00	NVDA	Stock	4.0345	4.0498	4.023	4.0282	122056200.0
2019-03-11 16:00:00	NVDA	Stock	4.0285	4.0353	4.025	4.0288	34000800.0
2019-03-11 17:00:00	NVDA	Stock	4.0288	4.0325	4.0285	4.03	4844360.0
2019-03-11 18:00:00	NVDA	Stock	4.0265	4.05	4.026	4.0488	1972200.0
2019-03-11 19:00:00	NVDA	Stock	4.0485	4.05	4.0455	4.0475	1185600.0
2019-03-11 04:00:00	AMZN	Stock	81.125	81.3405	81.125	81.265	14000.0
2019-03-11 05:00:00	AMZN	Stock	81.25	81.2505	81.2485	81.25	15680.0
2019-03-11 06:00:00	AMZN	Stock	81.385	81.472	81.385	81.403	14000.0

> showing 50 of 49,920 rows — these rows as CSV

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