PREVIEW / stock_1hour / 2018-09-21

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-09-21.parquet
  size:    1.1 MB
  rows:    50,368
  symbols: 2,786

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-09-21 04:00:00	AAPL	Stock	55.19	55.36	55.1	55.1	24056.0
2018-09-21 05:00:00	AAPL	Stock	55.1	55.1875	55.08	55.175	8668.0
2018-09-21 06:00:00	AAPL	Stock	55.175	55.2	55.125	55.125	8320.0
2018-09-21 07:00:00	AAPL	Stock	55.1575	55.1575	54.98	55.075	82528.0
2018-09-21 08:00:00	AAPL	Stock	55.155	55.225	55.0	55.185	284440.0
2018-09-21 09:00:00	AAPL	Stock	55.18	55.34	54.935	54.9508	46031328.0
2018-09-21 10:00:00	AAPL	Stock	54.95	54.9925	54.595	54.7585	16767472.0
2018-09-21 11:00:00	AAPL	Stock	54.7575	54.875	54.6125	54.8368	12408280.0
2018-09-21 12:00:00	AAPL	Stock	54.8375	54.9975	54.735	54.845	9476924.0
2018-09-21 13:00:00	AAPL	Stock	54.845	54.8625	54.61	54.7418	8006888.0
2018-09-21 14:00:00	AAPL	Stock	54.74	54.745	54.525	54.565	9636844.0
2018-09-21 15:00:00	AAPL	Stock	54.565	54.618	54.3225	54.4138	41023028.0
2018-09-21 16:00:00	AAPL	Stock	54.415	54.5	54.37	54.43	165321068.0
2018-09-21 17:00:00	AAPL	Stock	54.43	54.4975	54.415	54.4725	704440.0
2018-09-21 18:00:00	AAPL	Stock	54.4725	54.49	54.4375	54.4375	30156.0
2018-09-21 19:00:00	AAPL	Stock	54.455	54.5	54.44	54.46	76256.0
2018-09-21 04:00:00	MSFT	Stock	113.7	113.9	113.7	113.8	7287.0
2018-09-21 05:00:00	MSFT	Stock	113.8	113.8	113.8	113.8	300.0
2018-09-21 06:00:00	MSFT	Stock	113.8	113.8	113.66	113.66	300.0
2018-09-21 07:00:00	MSFT	Stock	113.67	113.7	113.64	113.64	2412.0
2018-09-21 08:00:00	MSFT	Stock	113.7	113.8	113.6	113.8	21504.0
2018-09-21 09:00:00	MSFT	Stock	113.8	114.3	113.74	114.05	14925498.0
2018-09-21 10:00:00	MSFT	Stock	114.05	114.25	113.66	113.946	3251529.0
2018-09-21 11:00:00	MSFT	Stock	113.945	114.45	113.72	114.43	2863361.0
2018-09-21 12:00:00	MSFT	Stock	114.425	114.55	114.11	114.3	2344194.0
2018-09-21 13:00:00	MSFT	Stock	114.29	114.49	114.22	114.355	1744680.0
2018-09-21 14:00:00	MSFT	Stock	114.355	114.367	113.96	114.13	2369749.0
2018-09-21 15:00:00	MSFT	Stock	114.13	115.29	113.51	114.81	9439201.0
2018-09-21 16:00:00	MSFT	Stock	114.81	114.81	113.65	114.05	22056328.0
2018-09-21 17:00:00	MSFT	Stock	114.02	114.26	114.02	114.18	46039.0
2018-09-21 18:00:00	MSFT	Stock	114.05	114.09	114.01	114.01	2032.0
2018-09-21 19:00:00	MSFT	Stock	114.01	114.01	113.95	113.95	3249.0
2018-09-21 04:00:00	NVDA	Stock	6.6918	6.694	6.6918	6.694	11040.0
2018-09-21 06:00:00	NVDA	Stock	6.6412	6.6412	6.6275	6.6275	108840.0
2018-09-21 07:00:00	NVDA	Stock	6.6295	6.6395	6.6262	6.6395	146200.0
2018-09-21 08:00:00	NVDA	Stock	6.6395	6.6888	6.6252	6.675	635200.0
2018-09-21 09:00:00	NVDA	Stock	6.674	6.715	6.6445	6.684	76748360.0
2018-09-21 10:00:00	NVDA	Stock	6.6842	6.7008	6.63	6.6422	38352040.0
2018-09-21 11:00:00	NVDA	Stock	6.6422	6.6808	6.6288	6.654	24100640.0
2018-09-21 12:00:00	NVDA	Stock	6.6528	6.6625	6.6255	6.6342	18506800.0
2018-09-21 13:00:00	NVDA	Stock	6.6345	6.6498	6.62	6.625	15094120.0
2018-09-21 14:00:00	NVDA	Stock	6.6255	6.6256	6.5888	6.5938	28395280.0
2018-09-21 15:00:00	NVDA	Stock	6.5944	6.5998	6.5528	6.586	75668960.0
2018-09-21 16:00:00	NVDA	Stock	6.5862	6.5975	6.5565	6.57	107471880.0
2018-09-21 17:00:00	NVDA	Stock	6.57	6.5713	6.5625	6.5638	60960.0
2018-09-21 18:00:00	NVDA	Stock	6.5638	6.575	6.5638	6.5715	103320.0
2018-09-21 19:00:00	NVDA	Stock	6.5748	6.5788	6.5675	6.5675	176600.0
2018-09-21 04:00:00	AMZN	Stock	97.9225	97.925	97.9225	97.925	8000.0
2018-09-21 05:00:00	AMZN	Stock	97.65	97.65	97.5935	97.5935	6280.0
2018-09-21 06:00:00	AMZN	Stock	97.5075	97.5075	97.5	97.5	4720.0

> showing 50 of 50,368 rows — these rows as CSV

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