PREVIEW / stock_1hour / 2019-01-29

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-01-29.parquet
  size:    1.1 MB
  rows:    48,986
  symbols: 2,696

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-01-29 04:00:00	AAPL	Stock	38.9125	39.055	38.9125	39.055	6896.0
2019-01-29 05:00:00	AAPL	Stock	39.1	39.125	39.0875	39.125	7828.0
2019-01-29 06:00:00	AAPL	Stock	39.055	39.075	39.0275	39.075	15492.0
2019-01-29 07:00:00	AAPL	Stock	39.04	39.1625	39.0225	39.12	123468.0
2019-01-29 08:00:00	AAPL	Stock	39.1	39.175	39.025	39.1275	359512.0
2019-01-29 09:00:00	AAPL	Stock	39.125	39.5325	38.975	39.3312	15734180.0
2019-01-29 10:00:00	AAPL	Stock	39.3325	39.495	38.88	38.94	19123380.0
2019-01-29 11:00:00	AAPL	Stock	38.9375	39.125	38.8112	39.1025	13505188.0
2019-01-29 12:00:00	AAPL	Stock	39.1	39.25	38.9975	39.1862	9187996.0
2019-01-29 13:00:00	AAPL	Stock	39.185	39.1875	38.9875	39.0288	9819408.0
2019-01-29 14:00:00	AAPL	Stock	39.0295	39.045	38.655	38.6775	14944716.0
2019-01-29 15:00:00	AAPL	Stock	38.6825	38.7175	38.5275	38.6595	30594432.0
2019-01-29 16:00:00	AAPL	Stock	38.67	40.4225	37.75	40.1575	21079636.0
2019-01-29 17:00:00	AAPL	Stock	40.1525	41.2125	40.0025	40.785	10472000.0
2019-01-29 18:00:00	AAPL	Stock	40.82	40.9925	40.75	40.9	1433924.0
2019-01-29 19:00:00	AAPL	Stock	40.8975	40.8975	40.7325	40.875	954176.0
2019-01-29 04:00:00	MSFT	Stock	104.85	105.23	104.85	105.0	1770.0
2019-01-29 05:00:00	MSFT	Stock	105.0	105.05	104.91	104.91	5101.0
2019-01-29 06:00:00	MSFT	Stock	104.83	104.9	104.75	104.9	5431.0
2019-01-29 07:00:00	MSFT	Stock	104.95	105.2	104.84	105.0	16740.0
2019-01-29 08:00:00	MSFT	Stock	104.854	105.34	104.81	105.15	82916.0
2019-01-29 09:00:00	MSFT	Stock	105.22	105.25	103.84	103.935	3104634.0
2019-01-29 10:00:00	MSFT	Stock	103.93	104.19	102.52	102.617	5489675.0
2019-01-29 11:00:00	MSFT	Stock	102.62	102.975	102.28	102.29	3874553.0
2019-01-29 12:00:00	MSFT	Stock	102.28	102.86	102.17	102.764	3077621.0
2019-01-29 13:00:00	MSFT	Stock	102.768	103.11	102.63	103.109	2475594.0
2019-01-29 14:00:00	MSFT	Stock	103.11	103.12	102.57	102.59	2008115.0
2019-01-29 15:00:00	MSFT	Stock	102.585	103.06	102.545	102.94	4814846.0
2019-01-29 16:00:00	MSFT	Stock	102.94	103.88	102.585	103.7	2491801.0
2019-01-29 17:00:00	MSFT	Stock	103.65	104.61	103.5	104.44	127026.0
2019-01-29 18:00:00	MSFT	Stock	104.38	104.46	103.76	103.76	67220.0
2019-01-29 19:00:00	MSFT	Stock	103.76	103.99	103.5	103.99	71853.0
2019-01-29 04:00:00	NVDA	Stock	3.425	3.45	3.42	3.425	363680.0
2019-01-29 05:00:00	NVDA	Stock	3.4225	3.4312	3.4055	3.4312	215720.0
2019-01-29 06:00:00	NVDA	Stock	3.4312	3.4325	3.4	3.4002	883280.0
2019-01-29 07:00:00	NVDA	Stock	3.4002	3.425	3.3875	3.419	2895680.0
2019-01-29 08:00:00	NVDA	Stock	3.4038	3.424	3.3588	3.3693	12484520.0
2019-01-29 09:00:00	NVDA	Stock	3.3688	3.4525	3.3618	3.375	192131920.0
2019-01-29 10:00:00	NVDA	Stock	3.3756	3.4208	3.3303	3.333	207213800.0
2019-01-29 11:00:00	NVDA	Stock	3.3333	3.3588	3.3238	3.3252	105727960.0
2019-01-29 12:00:00	NVDA	Stock	3.3254	3.3355	3.2918	3.3058	134345120.0
2019-01-29 13:00:00	NVDA	Stock	3.3058	3.3108	3.2835	3.3015	90849000.0
2019-01-29 14:00:00	NVDA	Stock	3.3015	3.3135	3.288	3.3025	70011760.0
2019-01-29 15:00:00	NVDA	Stock	3.303	3.3125	3.2752	3.2888	136640160.0
2019-01-29 16:00:00	NVDA	Stock	3.29	3.3512	3.279	3.3425	43081000.0
2019-01-29 17:00:00	NVDA	Stock	3.3404	3.3598	3.339	3.3538	4134360.0
2019-01-29 18:00:00	NVDA	Stock	3.3538	3.354	3.342	3.343	2168560.0
2019-01-29 19:00:00	NVDA	Stock	3.3428	3.345	3.3428	3.345	1088560.0
2019-01-29 06:00:00	AMZN	Stock	81.6395	81.6395	81.6395	81.6395	3300.0
2019-01-29 07:00:00	AMZN	Stock	81.65	81.86	81.5105	81.85	172000.0

> showing 50 of 48,986 rows — these rows as CSV

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