PREVIEW / stock_1hour / 2020-10-12

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-10-12.parquet
  size:    1.3 MB
  rows:    57,761
  symbols: 2,506

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
2020-10-12 04:00:00	AAPL	Stock	118.55	120.95	118.55	120.2	362936.0
2020-10-12 05:00:00	AAPL	Stock	120.15	120.34	119.74	119.75	94215.0
2020-10-12 06:00:00	AAPL	Stock	119.82	120.59	119.78	120.5	103165.0
2020-10-12 07:00:00	AAPL	Stock	120.41	120.84	120.03	120.77	710036.0
2020-10-12 08:00:00	AAPL	Stock	120.36	121.0	117.26	120.58	1806871.0
2020-10-12 09:00:00	AAPL	Stock	120.57	121.49	119.284	120.45	29624577.0
2020-10-12 10:00:00	AAPL	Stock	120.445	121.82	120.19	121.78	21830851.0
2020-10-12 11:00:00	AAPL	Stock	121.78	123.63	121.78	122.71	34352236.0
2020-10-12 12:00:00	AAPL	Stock	122.72	123.75	122.57	123.55	23525598.0
2020-10-12 13:00:00	AAPL	Stock	123.555	124.48	123.35	124.3	23122974.0
2020-10-12 14:00:00	AAPL	Stock	124.3	125.18	124.16	124.29	31726146.0
2020-10-12 15:00:00	AAPL	Stock	124.296	124.66	123.62	124.42	34059261.0
2020-10-12 16:00:00	AAPL	Stock	124.4	124.75	124.3	124.54	17052965.0
2020-10-12 17:00:00	AAPL	Stock	124.54	124.95	124.53	124.95	425339.0
2020-10-12 18:00:00	AAPL	Stock	124.94	124.98	124.63	124.67	455754.0
2020-10-12 19:00:00	AAPL	Stock	124.7	124.98	124.67	124.92	433902.0
2020-10-12 04:00:00	MSFT	Stock	216.21	217.86	216.21	217.39	6984.0
2020-10-12 05:00:00	MSFT	Stock	217.61	217.76	217.39	217.39	4922.0
2020-10-12 06:00:00	MSFT	Stock	217.39	219.5	217.3	218.89	18236.0
2020-10-12 07:00:00	MSFT	Stock	217.5	219.64	217.5	219.59	121319.0
2020-10-12 08:00:00	MSFT	Stock	218.37	220.0	215.28	219.05	161001.0
2020-10-12 09:00:00	MSFT	Stock	219.0	220.25	217.1	217.4	4370274.0
2020-10-12 10:00:00	MSFT	Stock	217.41	219.6	216.81	219.55	3498242.0
2020-10-12 11:00:00	MSFT	Stock	219.55	220.571	219.41	220.164	3128762.0
2020-10-12 12:00:00	MSFT	Stock	220.16	223.49	220.12	222.645	4915009.0
2020-10-12 13:00:00	MSFT	Stock	222.68	223.81	222.2	222.68	3497435.0
2020-10-12 14:00:00	MSFT	Stock	222.68	223.86	222.675	222.93	3575484.0
2020-10-12 15:00:00	MSFT	Stock	222.93	223.22	221.25	221.41	5255799.0
2020-10-12 16:00:00	MSFT	Stock	221.41	221.75	221.2	221.27	5787525.0
2020-10-12 17:00:00	MSFT	Stock	221.395	221.46	221.26	221.45	6444.0
2020-10-12 18:00:00	MSFT	Stock	221.4	221.7	221.21	221.3	12377.0
2020-10-12 19:00:00	MSFT	Stock	221.5	221.79	221.41	221.56	15469.0
2020-10-12 04:00:00	NVDA	Stock	13.8375	13.9325	13.8375	13.9275	419360.0
2020-10-12 05:00:00	NVDA	Stock	13.9402	13.9625	13.9402	13.9625	93320.0
2020-10-12 06:00:00	NVDA	Stock	13.96	13.9748	13.9512	13.9748	130320.0
2020-10-12 07:00:00	NVDA	Stock	13.969	13.9712	13.9275	13.9712	1183680.0
2020-10-12 08:00:00	NVDA	Stock	13.9562	13.997	13.9275	13.975	2208600.0
2020-10-12 09:00:00	NVDA	Stock	13.974	14.1875	13.9125	14.0899	82937120.0
2020-10-12 10:00:00	NVDA	Stock	14.0858	14.1523	14.0303	14.1485	42415440.0
2020-10-12 11:00:00	NVDA	Stock	14.1485	14.1905	14.101	14.144	31862760.0
2020-10-12 12:00:00	NVDA	Stock	14.145	14.2538	14.1429	14.2015	39530120.0
2020-10-12 13:00:00	NVDA	Stock	14.206	14.275	14.1942	14.247	30678840.0
2020-10-12 14:00:00	NVDA	Stock	14.2495	14.347	14.2463	14.2965	38770440.0
2020-10-12 15:00:00	NVDA	Stock	14.2982	14.3242	14.2001	14.218	54407080.0
2020-10-12 16:00:00	NVDA	Stock	14.226	14.26	14.2125	14.255	14656000.0
2020-10-12 17:00:00	NVDA	Stock	14.2495	14.255	14.242	14.255	190720.0
2020-10-12 18:00:00	NVDA	Stock	14.2562	14.2713	14.226	14.265	235320.0
2020-10-12 19:00:00	NVDA	Stock	14.25	14.275	14.25	14.25	417480.0
2020-10-12 04:00:00	AMZN	Stock	166.65	166.65	166.65	166.65	2000.0
2020-10-12 05:00:00	AMZN	Stock	166.269	166.269	166.269	166.269	4540.0

> showing 50 of 57,761 rows — these rows as CSV

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