PREVIEW / stock_1hour / 2020-09-09

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-09-09.parquet
  size:    1.2 MB
  rows:    56,320
  symbols: 2,463

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-09-09 04:00:00	AAPL	Stock	114.51	116.24	114.51	116.07	220484.0
2020-09-09 05:00:00	AAPL	Stock	116.1	117.19	115.61	117.1	128786.0
2020-09-09 06:00:00	AAPL	Stock	117.02	117.19	116.36	116.6	96478.0
2020-09-09 07:00:00	AAPL	Stock	116.59	116.64	115.03	116.18	900969.0
2020-09-09 08:00:00	AAPL	Stock	115.761	116.49	115.03	115.75	1791468.0
2020-09-09 09:00:00	AAPL	Stock	115.74	118.0	115.26	116.39	27138532.0
2020-09-09 10:00:00	AAPL	Stock	116.39	118.18	115.81	117.85	26570414.0
2020-09-09 11:00:00	AAPL	Stock	117.85	118.47	116.97	117.85	17205702.0
2020-09-09 12:00:00	AAPL	Stock	117.85	118.53	117.66	118.417	13068158.0
2020-09-09 13:00:00	AAPL	Stock	118.415	119.14	117.3	117.42	17485552.0
2020-09-09 14:00:00	AAPL	Stock	117.42	118.29	117.1	117.87	13024131.0
2020-09-09 15:00:00	AAPL	Stock	117.87	118.15	116.8	117.18	20955857.0
2020-09-09 16:00:00	AAPL	Stock	117.25	117.48	116.8	116.99	14225420.0
2020-09-09 17:00:00	AAPL	Stock	116.95	117.35	116.9	117.26	136338.0
2020-09-09 18:00:00	AAPL	Stock	117.29	118.41	117.29	118.32	451515.0
2020-09-09 19:00:00	AAPL	Stock	118.31	118.54	118.0	118.52	300793.0
2020-09-09 04:00:00	MSFT	Stock	205.5	207.2	205.5	207.19	14512.0
2020-09-09 05:00:00	MSFT	Stock	207.17	207.48	206.32	207.1	12739.0
2020-09-09 06:00:00	MSFT	Stock	207.01	207.38	206.1	206.93	9543.0
2020-09-09 07:00:00	MSFT	Stock	206.65	207.0	205.15	206.2	126215.0
2020-09-09 08:00:00	MSFT	Stock	205.6	207.0	205.02	205.49	180236.0
2020-09-09 09:00:00	MSFT	Stock	205.32	209.89	205.32	209.86	6177138.0
2020-09-09 10:00:00	MSFT	Stock	209.89	212.06	209.41	211.11	5675512.0
2020-09-09 11:00:00	MSFT	Stock	211.14	211.86	209.83	211.85	3220878.0
2020-09-09 12:00:00	MSFT	Stock	211.87	213.485	211.8	213.34	2731161.0
2020-09-09 13:00:00	MSFT	Stock	213.38	213.93	212.2	212.49	2817317.0
2020-09-09 14:00:00	MSFT	Stock	212.51	213.64	212.0	213.245	2198855.0
2020-09-09 15:00:00	MSFT	Stock	213.25	214.84	210.91	211.18	7948046.0
2020-09-09 16:00:00	MSFT	Stock	211.29	211.61	210.15	211.11	6193006.0
2020-09-09 17:00:00	MSFT	Stock	211.28	211.3	210.82	211.3	19819.0
2020-09-09 18:00:00	MSFT	Stock	211.44	212.48	211.0	212.4	43154.0
2020-09-09 19:00:00	MSFT	Stock	212.43	212.65	211.77	212.65	42171.0
2020-09-09 04:00:00	NVDA	Stock	12.15	12.2875	12.15	12.25	322720.0
2020-09-09 05:00:00	NVDA	Stock	12.25	12.375	12.235	12.35	238400.0
2020-09-09 06:00:00	NVDA	Stock	12.375	12.3925	12.32	12.32	278120.0
2020-09-09 07:00:00	NVDA	Stock	12.3258	12.35	12.2	12.3	1626920.0
2020-09-09 08:00:00	NVDA	Stock	12.225	12.3625	12.175	12.175	3036280.0
2020-09-09 09:00:00	NVDA	Stock	12.225	12.4973	12.1784	12.356	117104280.0
2020-09-09 10:00:00	NVDA	Stock	12.355	12.6975	12.3055	12.6415	161716440.0
2020-09-09 11:00:00	NVDA	Stock	12.6425	12.7375	12.5405	12.6012	67026720.0
2020-09-09 12:00:00	NVDA	Stock	12.605	12.7495	12.5875	12.7375	49634040.0
2020-09-09 13:00:00	NVDA	Stock	12.7385	12.8092	12.5922	12.6	63297440.0
2020-09-09 14:00:00	NVDA	Stock	12.6025	12.737	12.5755	12.705	53234440.0
2020-09-09 15:00:00	NVDA	Stock	12.7045	12.8	12.657	12.7105	89937600.0
2020-09-09 16:00:00	NVDA	Stock	12.715	12.7352	12.6688	12.7075	29059040.0
2020-09-09 17:00:00	NVDA	Stock	12.7125	12.7125	12.6888	12.7	242680.0
2020-09-09 18:00:00	NVDA	Stock	12.7162	12.8442	12.7162	12.837	1200440.0
2020-09-09 19:00:00	NVDA	Stock	12.8363	12.8625	12.8312	12.855	872800.0
2020-09-09 04:00:00	AMZN	Stock	159.35	159.5	159.25	159.5	6000.0
2020-09-09 05:00:00	AMZN	Stock	159.995	159.996	159.995	159.996	4000.0

> showing 50 of 56,320 rows — these rows as CSV

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