PREVIEW / stock_1hour / 2019-03-14

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-03-14.parquet
  size:    1.1 MB
  rows:    49,683
  symbols: 2,645

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-14 04:00:00	AAPL	Stock	45.7275	45.7325	45.7275	45.7325	800.0
2019-03-14 05:00:00	AAPL	Stock	45.725	45.82	45.695	45.8	27620.0
2019-03-14 06:00:00	AAPL	Stock	45.825	45.865	45.6375	45.78	243860.0
2019-03-14 07:00:00	AAPL	Stock	45.78	45.9625	45.7675	45.9375	303188.0
2019-03-14 08:00:00	AAPL	Stock	45.8022	46.0	45.5425	45.975	585084.0
2019-03-14 09:00:00	AAPL	Stock	45.9525	46.045	45.675	45.8875	15964964.0
2019-03-14 10:00:00	AAPL	Stock	45.8925	45.8925	45.64	45.7562	12431056.0
2019-03-14 11:00:00	AAPL	Stock	45.7575	45.9325	45.7025	45.8675	8849048.0
2019-03-14 12:00:00	AAPL	Stock	45.8675	46.025	45.8575	45.965	9052664.0
2019-03-14 13:00:00	AAPL	Stock	45.965	45.97	45.855	45.9075	5689456.0
2019-03-14 14:00:00	AAPL	Stock	45.9062	45.9925	45.9038	45.9375	5871796.0
2019-03-14 15:00:00	AAPL	Stock	45.9375	46.0025	45.86	45.9325	12873120.0
2019-03-14 16:00:00	AAPL	Stock	45.9325	45.995	45.8775	45.925	12999948.0
2019-03-14 17:00:00	AAPL	Stock	45.925	45.9375	45.895	45.92	81672.0
2019-03-14 18:00:00	AAPL	Stock	45.92	45.995	45.905	45.9925	48952.0
2019-03-14 19:00:00	AAPL	Stock	45.9925	46.05	45.965	46.0125	114616.0
2019-03-14 04:00:00	MSFT	Stock	114.76	115.0	114.76	115.0	1200.0
2019-03-14 05:00:00	MSFT	Stock	115.0	115.0	115.0	115.0	2898.0
2019-03-14 06:00:00	MSFT	Stock	114.87	114.88	114.5	114.5	8583.0
2019-03-14 07:00:00	MSFT	Stock	114.57	114.84	114.57	114.75	21745.0
2019-03-14 08:00:00	MSFT	Stock	114.65	114.9	114.65	114.75	37639.0
2019-03-14 09:00:00	MSFT	Stock	114.76	114.95	114.33	114.74	2125724.0
2019-03-14 10:00:00	MSFT	Stock	114.74	114.93	114.35	114.745	2125933.0
2019-03-14 11:00:00	MSFT	Stock	114.74	115.08	114.63	115.047	2490467.0
2019-03-14 12:00:00	MSFT	Stock	115.05	115.2	114.79	114.935	1585340.0
2019-03-14 13:00:00	MSFT	Stock	114.93	114.96	114.63	114.635	1289400.0
2019-03-14 14:00:00	MSFT	Stock	114.64	114.8	114.53	114.743	1602867.0
2019-03-14 15:00:00	MSFT	Stock	114.75	115.05	114.56	114.57	4137982.0
2019-03-14 16:00:00	MSFT	Stock	114.59	114.77	114.54	114.65	10236211.0
2019-03-14 17:00:00	MSFT	Stock	114.65	114.65	114.52	114.52	4585.0
2019-03-14 18:00:00	MSFT	Stock	114.53	114.65	114.52	114.65	1105.0
2019-03-14 19:00:00	MSFT	Stock	114.56	114.65	114.56	114.65	2986.0
2019-03-14 04:00:00	NVDA	Stock	4.2438	4.2438	4.2428	4.2432	55200.0
2019-03-14 05:00:00	NVDA	Stock	4.247	4.247	4.2375	4.2438	98680.0
2019-03-14 06:00:00	NVDA	Stock	4.2428	4.2428	4.1985	4.1985	144440.0
2019-03-14 07:00:00	NVDA	Stock	4.2155	4.231	4.215	4.231	724520.0
2019-03-14 08:00:00	NVDA	Stock	4.225	4.237	4.2125	4.237	2642760.0
2019-03-14 09:00:00	NVDA	Stock	4.2375	4.2375	4.1558	4.227	104508120.0
2019-03-14 10:00:00	NVDA	Stock	4.2265	4.2368	4.169	4.1718	83091360.0
2019-03-14 11:00:00	NVDA	Stock	4.1715	4.1918	4.1658	4.1735	37343080.0
2019-03-14 12:00:00	NVDA	Stock	4.1738	4.2202	4.173	4.198	44861720.0
2019-03-14 13:00:00	NVDA	Stock	4.199	4.2062	4.1785	4.186	31555520.0
2019-03-14 14:00:00	NVDA	Stock	4.1861	4.1882	4.151	4.1528	38868600.0
2019-03-14 15:00:00	NVDA	Stock	4.1528	4.1648	4.1313	4.139	89067800.0
2019-03-14 16:00:00	NVDA	Stock	4.139	4.1633	4.1327	4.1438	48570880.0
2019-03-14 17:00:00	NVDA	Stock	4.1425	4.1538	4.1425	4.1438	220240.0
2019-03-14 18:00:00	NVDA	Stock	4.1488	4.15	4.1462	4.15	248800.0
2019-03-14 19:00:00	NVDA	Stock	4.1478	4.1488	4.1428	4.145	139920.0
2019-03-14 05:00:00	AMZN	Stock	84.9315	84.9495	84.9245	84.9495	8000.0
2019-03-14 06:00:00	AMZN	Stock	84.79	84.79	84.386	84.386	14000.0

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

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