PREVIEW / stock_1hour / 2020-02-10

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-02-10.parquet
  size:    1.2 MB
  rows:    50,970
  symbols: 2,428

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-02-10 04:00:00	AAPL	Stock	79.485	79.6575	79.3875	79.3875	73020.0
2020-02-10 05:00:00	AAPL	Stock	79.3	79.4575	79.125	79.35	56660.0
2020-02-10 06:00:00	AAPL	Stock	79.3875	79.625	79.35	79.5225	71728.0
2020-02-10 07:00:00	AAPL	Stock	79.56	79.56	79.05	79.2	439332.0
2020-02-10 08:00:00	AAPL	Stock	79.2	80.2075	78.93	78.9375	1000548.0
2020-02-10 09:00:00	AAPL	Stock	78.93	79.7375	78.4625	79.5625	20344188.0
2020-02-10 10:00:00	AAPL	Stock	79.5625	80.015	79.1475	79.7358	17037168.0
2020-02-10 11:00:00	AAPL	Stock	79.7292	80.0625	79.7	79.725	10142376.0
2020-02-10 12:00:00	AAPL	Stock	79.7268	79.87	79.5375	79.8462	6384788.0
2020-02-10 13:00:00	AAPL	Stock	79.8462	80.0	79.81	79.84	4748688.0
2020-02-10 14:00:00	AAPL	Stock	79.84	80.1925	79.7525	80.164	6276268.0
2020-02-10 15:00:00	AAPL	Stock	80.1612	80.385	80.1375	80.385	13807320.0
2020-02-10 16:00:00	AAPL	Stock	80.385	80.4475	80.1625	80.2525	12549716.0
2020-02-10 17:00:00	AAPL	Stock	80.2625	80.3	80.15	80.15	81804.0
2020-02-10 18:00:00	AAPL	Stock	80.155	80.2375	80.1425	80.2375	68864.0
2020-02-10 19:00:00	AAPL	Stock	80.225	80.305	80.125	80.225	164552.0
2020-02-10 04:00:00	MSFT	Stock	183.75	184.44	183.75	184.2	5023.0
2020-02-10 05:00:00	MSFT	Stock	183.94	184.45	183.87	184.45	3985.0
2020-02-10 06:00:00	MSFT	Stock	184.31	184.5	184.28	184.4	2402.0
2020-02-10 07:00:00	MSFT	Stock	184.47	184.5	184.1	184.25	19875.0
2020-02-10 08:00:00	MSFT	Stock	184.445	184.45	183.8	183.82	87105.0
2020-02-10 09:00:00	MSFT	Stock	183.92	184.84	183.25	184.78	3491159.0
2020-02-10 10:00:00	MSFT	Stock	184.79	187.3	184.58	186.05	6681432.0
2020-02-10 11:00:00	MSFT	Stock	186.045	187.25	186.045	187.14	3125577.0
2020-02-10 12:00:00	MSFT	Stock	187.135	187.135	186.2	186.377	2258294.0
2020-02-10 13:00:00	MSFT	Stock	186.39	187.29	186.39	186.825	1849713.0
2020-02-10 14:00:00	MSFT	Stock	186.82	187.36	186.67	187.35	1756028.0
2020-02-10 15:00:00	MSFT	Stock	187.33	188.84	187.32	188.74	5309700.0
2020-02-10 16:00:00	MSFT	Stock	188.7	189.2	186.785	189.1	3776124.0
2020-02-10 17:00:00	MSFT	Stock	189.08	189.39	189.04	189.26	33744.0
2020-02-10 18:00:00	MSFT	Stock	189.27	189.33	189.01	189.12	31268.0
2020-02-10 19:00:00	MSFT	Stock	189.25	189.73	189.1	189.68	28965.0
2020-02-10 04:00:00	NVDA	Stock	6.3072	6.3072	6.282	6.295	42840.0
2020-02-10 05:00:00	NVDA	Stock	6.299	6.3188	6.2975	6.3188	37280.0
2020-02-10 06:00:00	NVDA	Stock	6.3195	6.3195	6.3175	6.3175	23680.0
2020-02-10 07:00:00	NVDA	Stock	6.3362	6.3362	6.2915	6.321	780880.0
2020-02-10 08:00:00	NVDA	Stock	6.304	6.339	6.295	6.3188	2134200.0
2020-02-10 09:00:00	NVDA	Stock	6.3192	6.4453	6.2975	6.4412	66392200.0
2020-02-10 10:00:00	NVDA	Stock	6.4425	6.4702	6.414	6.4332	64352160.0
2020-02-10 11:00:00	NVDA	Stock	6.4345	6.492	6.428	6.4898	44967680.0
2020-02-10 12:00:00	NVDA	Stock	6.4903	6.497	6.4702	6.4875	54746680.0
2020-02-10 13:00:00	NVDA	Stock	6.4878	6.5257	6.4862	6.523	54404480.0
2020-02-10 14:00:00	NVDA	Stock	6.523	6.5522	6.518	6.5482	43048520.0
2020-02-10 15:00:00	NVDA	Stock	6.5484	6.575	6.5338	6.5748	70311080.0
2020-02-10 16:00:00	NVDA	Stock	6.571	6.5938	6.571	6.5938	52705400.0
2020-02-10 17:00:00	NVDA	Stock	6.5938	6.5938	6.5775	6.5875	280600.0
2020-02-10 18:00:00	NVDA	Stock	6.5815	6.5933	6.5775	6.5933	270120.0
2020-02-10 19:00:00	NVDA	Stock	6.5912	6.6065	6.5875	6.6065	450400.0
2020-02-10 05:00:00	AMZN	Stock	104.0925	104.1	104.0925	104.0995	8340.0
2020-02-10 06:00:00	AMZN	Stock	104.15	104.4925	104.15	104.4925	9000.0

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

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