PREVIEW / stock_1hour / 2018-01-08

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-01-08.parquet
  size:    1.1 MB
  rows:    51,594
  symbols: 2,909

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-01-08 04:00:00	AAPL	Stock	43.775	43.775	43.775	43.775	1888.0
2018-01-08 06:00:00	AAPL	Stock	43.825	43.825	43.725	43.725	2884.0
2018-01-08 07:00:00	AAPL	Stock	43.7725	43.7725	43.6875	43.7125	84800.0
2018-01-08 08:00:00	AAPL	Stock	43.755	43.77	43.6275	43.6875	194944.0
2018-01-08 09:00:00	AAPL	Stock	43.6875	43.9025	43.5675	43.75	12261100.0
2018-01-08 10:00:00	AAPL	Stock	43.75	43.7738	43.6175	43.7125	11623024.0
2018-01-08 11:00:00	AAPL	Stock	43.7138	43.785	43.695	43.725	6755072.0
2018-01-08 12:00:00	AAPL	Stock	43.7275	43.7388	43.6175	43.6325	5446836.0
2018-01-08 13:00:00	AAPL	Stock	43.635	43.7325	43.635	43.675	4618628.0
2018-01-08 14:00:00	AAPL	Stock	43.675	43.6775	43.57	43.61	5862756.0
2018-01-08 15:00:00	AAPL	Stock	43.61	43.64	43.4825	43.585	15824328.0
2018-01-08 16:00:00	AAPL	Stock	43.6	43.6	43.5475	43.5475	9879452.0
2018-01-08 17:00:00	AAPL	Stock	43.5875	43.6475	43.555	43.61	152912.0
2018-01-08 18:00:00	AAPL	Stock	43.625	43.6375	43.6125	43.6275	27664.0
2018-01-08 19:00:00	AAPL	Stock	43.625	43.7	43.6225	43.7	94152.0
2018-01-08 05:00:00	MSFT	Stock	88.44	88.67	88.44	88.67	4301.0
2018-01-08 06:00:00	MSFT	Stock	88.55	88.6	88.5	88.5	1300.0
2018-01-08 07:00:00	MSFT	Stock	88.35	88.45	88.23	88.34	15275.0
2018-01-08 08:00:00	MSFT	Stock	88.3	88.51	88.21	88.31	29761.0
2018-01-08 09:00:00	MSFT	Stock	88.37	88.51	87.62	87.63	2448567.0
2018-01-08 10:00:00	MSFT	Stock	87.635	88.32	87.605	88.31	2658313.0
2018-01-08 11:00:00	MSFT	Stock	88.31	88.58	88.3	88.45	1627645.0
2018-01-08 12:00:00	MSFT	Stock	88.45	88.485	88.25	88.355	1139434.0
2018-01-08 13:00:00	MSFT	Stock	88.36	88.395	88.26	88.305	958231.0
2018-01-08 14:00:00	MSFT	Stock	88.31	88.31	88.15	88.195	1109357.0
2018-01-08 15:00:00	MSFT	Stock	88.195	88.44	88.15	88.22	3333389.0
2018-01-08 16:00:00	MSFT	Stock	88.28	88.35	88.18	88.33	6024104.0
2018-01-08 17:00:00	MSFT	Stock	88.33	88.34	88.28	88.3	8234.0
2018-01-08 19:00:00	MSFT	Stock	88.34	88.35	88.34	88.35	1734.0
2018-01-08 04:00:00	NVDA	Stock	5.4238	5.4498	5.4238	5.4498	90760.0
2018-01-08 05:00:00	NVDA	Stock	5.443	5.4685	5.443	5.4625	208520.0
2018-01-08 06:00:00	NVDA	Stock	5.475	5.5295	5.475	5.492	930000.0
2018-01-08 07:00:00	NVDA	Stock	5.479	5.5475	5.465	5.5075	8699600.0
2018-01-08 08:00:00	NVDA	Stock	5.5095	5.5438	5.465	5.5042	11552240.0
2018-01-08 09:00:00	NVDA	Stock	5.5042	5.5948	5.4645	5.5481	197728160.0
2018-01-08 10:00:00	NVDA	Stock	5.5482	5.5612	5.4948	5.552	133993200.0
2018-01-08 11:00:00	NVDA	Stock	5.5515	5.6193	5.5405	5.5852	117287720.0
2018-01-08 12:00:00	NVDA	Stock	5.5862	5.6012	5.577	5.594	51723840.0
2018-01-08 13:00:00	NVDA	Stock	5.594	5.625	5.584	5.6184	75962040.0
2018-01-08 14:00:00	NVDA	Stock	5.6178	5.621	5.58	5.595	58346760.0
2018-01-08 15:00:00	NVDA	Stock	5.5952	5.5972	5.5435	5.5495	112820760.0
2018-01-08 16:00:00	NVDA	Stock	5.565	5.565	5.5405	5.5478	48443320.0
2018-01-08 17:00:00	NVDA	Stock	5.5478	5.55	5.5362	5.5375	907640.0
2018-01-08 18:00:00	NVDA	Stock	5.5375	5.5413	5.53	5.5312	1579480.0
2018-01-08 19:00:00	NVDA	Stock	5.532	5.5463	5.532	5.5413	552440.0
2018-01-08 04:00:00	AMZN	Stock	61.6695	61.6695	61.6	61.6	8500.0
2018-01-08 05:00:00	AMZN	Stock	61.6055	61.65	61.6	61.6	6840.0
2018-01-08 06:00:00	AMZN	Stock	61.675	61.675	61.615	61.615	9540.0
2018-01-08 07:00:00	AMZN	Stock	61.618	61.625	61.5	61.552	176040.0
2018-01-08 08:00:00	AMZN	Stock	61.55	61.625	61.5	61.55	189640.0

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

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