PREVIEW / stock_1hour / 2021-04-05

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-04-05.parquet
  size:    1.5 MB
  rows:    67,724
  symbols: 2,953

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
2021-04-05 04:00:00	AAPL	Stock	123.12	123.46	122.81	123.12	27583.0
2021-04-05 05:00:00	AAPL	Stock	123.08	123.5	123.07	123.38	13597.0
2021-04-05 06:00:00	AAPL	Stock	123.4	123.45	123.0	123.09	20299.0
2021-04-05 07:00:00	AAPL	Stock	123.14	123.39	123.04	123.35	218595.0
2021-04-05 08:00:00	AAPL	Stock	123.35	124.0	123.05	123.8899	440369.0
2021-04-05 09:00:00	AAPL	Stock	123.89	125.13	123.07	124.8161	13690751.0
2021-04-05 10:00:00	AAPL	Stock	124.81	125.62	124.56	125.16	14466874.0
2021-04-05 11:00:00	AAPL	Stock	125.165	125.57	124.8301	125.325	8167246.0
2021-04-05 12:00:00	AAPL	Stock	125.33	125.96	125.315	125.5614	7882910.0
2021-04-05 13:00:00	AAPL	Stock	125.57	126.08	125.53	126.05	6458525.0
2021-04-05 14:00:00	AAPL	Stock	126.0439	126.1601	125.6	125.63	7188672.0
2021-04-05 15:00:00	AAPL	Stock	125.635	126.0	125.3101	125.9	12533448.0
2021-04-05 16:00:00	AAPL	Stock	125.9	126.22	125.81	126.2	6772335.0
2021-04-05 17:00:00	AAPL	Stock	126.19	126.32	126.19	126.31	106405.0
2021-04-05 18:00:00	AAPL	Stock	126.3	126.34	126.2	126.2999	92375.0
2021-04-05 19:00:00	AAPL	Stock	126.3	126.5	126.3	126.5	177002.0
2021-04-05 04:00:00	MSFT	Stock	242.65	243.0	242.42	242.45	2276.0
2021-04-05 05:00:00	MSFT	Stock	242.05	243.05	242.05	243.0	4231.0
2021-04-05 06:00:00	MSFT	Stock	242.84	242.96	241.95	241.95	5248.0
2021-04-05 07:00:00	MSFT	Stock	242.48	242.76	241.91	242.29	45766.0
2021-04-05 08:00:00	MSFT	Stock	242.5	242.85	241.745	242.8	122405.0
2021-04-05 09:00:00	MSFT	Stock	242.8	247.3	242.42	247.26	4272420.0
2021-04-05 10:00:00	MSFT	Stock	247.26	249.75	246.72	248.9	5806223.0
2021-04-05 11:00:00	MSFT	Stock	248.92	249.505	248.03	248.85	3477270.0
2021-04-05 12:00:00	MSFT	Stock	248.87	249.54	248.87	249.1	2544592.0
2021-04-05 13:00:00	MSFT	Stock	249.1	249.96	248.97	249.3442	2688429.0
2021-04-05 14:00:00	MSFT	Stock	249.34	249.56	248.955	249.215	1776587.0
2021-04-05 15:00:00	MSFT	Stock	249.2117	249.58	247.82	249.0	5075745.0
2021-04-05 16:00:00	MSFT	Stock	249.0	249.45	248.9	249.3931	3825893.0
2021-04-05 17:00:00	MSFT	Stock	249.4	249.4	249.3	249.32	6138.0
2021-04-05 18:00:00	MSFT	Stock	249.38	249.38	249.23	249.34	10729.0
2021-04-05 19:00:00	MSFT	Stock	249.32	249.47	249.3	249.47	9557.0
2021-04-05 04:00:00	NVDA	Stock	13.825	13.875	13.825	13.865	59200.0
2021-04-05 05:00:00	NVDA	Stock	13.9125	13.9125	13.9125	13.9125	4000.0
2021-04-05 06:00:00	NVDA	Stock	13.9125	13.9125	13.88	13.88	22520.0
2021-04-05 07:00:00	NVDA	Stock	13.85	13.908	13.8438	13.8695	187040.0
2021-04-05 08:00:00	NVDA	Stock	13.875	13.9325	13.8377	13.9113	834200.0
2021-04-05 09:00:00	NVDA	Stock	13.8938	13.925	13.7562	13.872	28472640.0
2021-04-05 10:00:00	NVDA	Stock	13.875	13.9635	13.773	13.7755	26286960.0
2021-04-05 11:00:00	NVDA	Stock	13.7795	13.8625	13.733	13.816	15418800.0
2021-04-05 12:00:00	NVDA	Stock	13.8195	13.9325	13.8186	13.9254	12980240.0
2021-04-05 13:00:00	NVDA	Stock	13.9285	13.9875	13.9202	13.9789	11286960.0
2021-04-05 14:00:00	NVDA	Stock	13.9822	14.0128	13.9793	14.0042	11606720.0
2021-04-05 15:00:00	NVDA	Stock	14.0053	14.014	13.925	13.9875	24979520.0
2021-04-05 16:00:00	NVDA	Stock	13.9875	14.0025	13.95	13.985	34148960.0
2021-04-05 17:00:00	NVDA	Stock	13.983	13.9878	13.9662	13.9662	137480.0
2021-04-05 18:00:00	NVDA	Stock	13.9745	13.9972	13.9745	13.9925	32040.0
2021-04-05 19:00:00	NVDA	Stock	13.985	14.025	13.98	14.025	190800.0
2021-04-05 07:00:00	AMZN	Stock	158.25	158.5	158.25	158.4	102020.0
2021-04-05 08:00:00	AMZN	Stock	158.3152	158.9	158.284	158.85	132680.0

> showing 50 of 67,724 rows — these rows as CSV

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