PREVIEW / stock_1hour / 2018-12-31

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-12-31.parquet
  size:    1.1 MB
  rows:    51,445
  symbols: 2,761

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-31 04:00:00	AAPL	Stock	39.32	39.47	39.32	39.47	4816.0
2018-12-31 05:00:00	AAPL	Stock	39.455	39.455	39.4375	39.4375	4648.0
2018-12-31 06:00:00	AAPL	Stock	39.4125	39.495	39.4125	39.495	5860.0
2018-12-31 07:00:00	AAPL	Stock	39.5	39.6925	39.4875	39.6125	145176.0
2018-12-31 08:00:00	AAPL	Stock	39.4838	39.6975	39.0575	39.4875	1005464.0
2018-12-31 09:00:00	AAPL	Stock	39.4975	39.84	39.37	39.4825	16822784.0
2018-12-31 10:00:00	AAPL	Stock	39.48	39.56	39.1275	39.265	19064140.0
2018-12-31 11:00:00	AAPL	Stock	39.2648	39.5425	39.2275	39.49	16464132.0
2018-12-31 12:00:00	AAPL	Stock	39.4975	39.735	39.435	39.5925	12515912.0
2018-12-31 13:00:00	AAPL	Stock	39.595	39.62	39.359	39.3925	9525392.0
2018-12-31 14:00:00	AAPL	Stock	39.395	39.455	39.2125	39.3425	11828264.0
2018-12-31 15:00:00	AAPL	Stock	39.34	39.4875	39.12	39.485	19692892.0
2018-12-31 16:00:00	AAPL	Stock	39.4825	39.4825	39.35	39.4425	14487616.0
2018-12-31 17:00:00	AAPL	Stock	39.4375	39.53	39.4375	39.525	166520.0
2018-12-31 18:00:00	AAPL	Stock	39.5125	39.5225	39.435	39.4875	1913072.0
2018-12-31 19:00:00	AAPL	Stock	39.48	39.545	39.4775	39.545	54548.0
2018-12-31 07:00:00	MSFT	Stock	101.1	101.85	101.1	101.73	21325.0
2018-12-31 08:00:00	MSFT	Stock	101.59	101.77	100.39	101.26	290881.0
2018-12-31 09:00:00	MSFT	Stock	101.26	101.68	100.67	100.963	2533839.0
2018-12-31 10:00:00	MSFT	Stock	100.966	101.465	100.78	101.405	3861031.0
2018-12-31 11:00:00	MSFT	Stock	101.405	101.64	100.86	101.46	3401961.0
2018-12-31 12:00:00	MSFT	Stock	101.46	101.96	101.1	101.86	2364627.0
2018-12-31 13:00:00	MSFT	Stock	101.86	102.4	101.44	101.51	2741951.0
2018-12-31 14:00:00	MSFT	Stock	101.507	101.68	100.94	101.39	2633769.0
2018-12-31 15:00:00	MSFT	Stock	101.39	101.67	100.44	101.66	5810492.0
2018-12-31 16:00:00	MSFT	Stock	101.57	101.99	100.89	101.7	5097598.0
2018-12-31 17:00:00	MSFT	Stock	101.6	101.79	101.6	101.62	5552.0
2018-12-31 18:00:00	MSFT	Stock	101.68	101.79	101.62	101.75	1137.0
2018-12-31 19:00:00	MSFT	Stock	101.76	101.79	101.65	101.65	8801.0
2018-12-31 07:00:00	NVDA	Stock	3.4	3.4125	3.3905	3.402	330200.0
2018-12-31 08:00:00	NVDA	Stock	3.3969	3.4138	3.3825	3.3895	1263440.0
2018-12-31 09:00:00	NVDA	Stock	3.3888	3.4178	3.3552	3.3782	69519920.0
2018-12-31 10:00:00	NVDA	Stock	3.3792	3.3965	3.3225	3.33	72825240.0
2018-12-31 11:00:00	NVDA	Stock	3.3306	3.3518	3.3112	3.3355	40386560.0
2018-12-31 12:00:00	NVDA	Stock	3.336	3.35	3.3252	3.334	38884480.0
2018-12-31 13:00:00	NVDA	Stock	3.334	3.375	3.3228	3.3236	44846760.0
2018-12-31 14:00:00	NVDA	Stock	3.3243	3.341	3.3068	3.3222	37336440.0
2018-12-31 15:00:00	NVDA	Stock	3.3225	3.3375	3.3065	3.3375	64202720.0
2018-12-31 16:00:00	NVDA	Stock	3.3375	3.345	3.3128	3.3425	31438720.0
2018-12-31 17:00:00	NVDA	Stock	3.3392	3.3548	3.337	3.3502	442200.0
2018-12-31 18:00:00	NVDA	Stock	3.3502	3.3605	3.3462	3.3482	190720.0
2018-12-31 19:00:00	NVDA	Stock	3.3502	3.3502	3.3445	3.3488	152120.0
2018-12-31 04:00:00	AMZN	Stock	75.0	75.0	75.0	75.0	19300.0
2018-12-31 05:00:00	AMZN	Stock	75.0	75.0	75.0	75.0	37660.0
2018-12-31 06:00:00	AMZN	Stock	75.19	75.35	75.1845	75.3425	26140.0
2018-12-31 07:00:00	AMZN	Stock	75.345	75.85	75.345	75.737	396820.0
2018-12-31 08:00:00	AMZN	Stock	75.25	75.85	75.25	75.4	754880.0
2018-12-31 09:00:00	AMZN	Stock	75.4	76.038	75.0	75.4523	19393820.0
2018-12-31 10:00:00	AMZN	Stock	75.4792	75.6575	74.4485	74.6425	18069720.0
2018-12-31 11:00:00	AMZN	Stock	74.625	75.625	74.35	75.425	15350360.0

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

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