PREVIEW / stock_1hour / 2020-09-02

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-09-02.parquet
  size:    1.3 MB
  rows:    57,133
  symbols: 2,466

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-02 04:00:00	AAPL	Stock	136.21	136.92	136.0	136.92	148489.0
2020-09-02 05:00:00	AAPL	Stock	136.95	137.11	136.59	137.08	123345.0
2020-09-02 06:00:00	AAPL	Stock	137.02	137.1	136.05	136.35	112307.0
2020-09-02 07:00:00	AAPL	Stock	136.34	137.3	136.05	136.85	813440.0
2020-09-02 08:00:00	AAPL	Stock	136.85	137.99	136.05	137.77	1653046.0
2020-09-02 09:00:00	AAPL	Stock	137.75	138.55	127.0	128.37	47422205.0
2020-09-02 10:00:00	AAPL	Stock	128.395	132.6	128.25	130.86	31793394.0
2020-09-02 11:00:00	AAPL	Stock	130.87	131.27	127.1	129.722	26004066.0
2020-09-02 12:00:00	AAPL	Stock	129.74	131.28	129.414	130.45	15480349.0
2020-09-02 13:00:00	AAPL	Stock	130.468	131.658	129.7	131.02	12719081.0
2020-09-02 14:00:00	AAPL	Stock	131.01	131.37	130.3	130.366	9872274.0
2020-09-02 15:00:00	AAPL	Stock	130.38	131.8	130.37	131.22	17364224.0
2020-09-02 16:00:00	AAPL	Stock	131.28	132.0	130.401	131.39	9474766.0
2020-09-02 17:00:00	AAPL	Stock	131.39	131.72	131.0	131.51	270577.0
2020-09-02 18:00:00	AAPL	Stock	131.53	131.72	131.4	131.68	154287.0
2020-09-02 19:00:00	AAPL	Stock	131.68	131.97	131.5	131.54	226061.0
2020-09-02 04:00:00	MSFT	Stock	228.25	228.53	228.02	228.53	2264.0
2020-09-02 05:00:00	MSFT	Stock	228.6	229.38	228.6	229.37	8002.0
2020-09-02 06:00:00	MSFT	Stock	229.26	229.48	229.16	229.41	2497.0
2020-09-02 07:00:00	MSFT	Stock	229.23	229.23	228.22	228.63	29155.0
2020-09-02 08:00:00	MSFT	Stock	228.55	229.2	228.22	228.33	86990.0
2020-09-02 09:00:00	MSFT	Stock	228.31	231.15	227.35	230.67	4721770.0
2020-09-02 10:00:00	MSFT	Stock	230.69	231.97	229.4	230.425	4631069.0
2020-09-02 11:00:00	MSFT	Stock	230.45	230.8	228.27	229.0	2827439.0
2020-09-02 12:00:00	MSFT	Stock	229.01	231.14	228.6	230.875	1972732.0
2020-09-02 13:00:00	MSFT	Stock	230.905	232.67	230.46	231.9	2885924.0
2020-09-02 14:00:00	MSFT	Stock	231.92	232.34	231.11	231.365	2157278.0
2020-09-02 15:00:00	MSFT	Stock	231.365	232.86	231.34	231.46	3942950.0
2020-09-02 16:00:00	MSFT	Stock	231.65	231.77	231.14	231.46	3999908.0
2020-09-02 17:00:00	MSFT	Stock	231.43	232.25	231.0	231.65	31896.0
2020-09-02 18:00:00	MSFT	Stock	231.65	231.7	231.11	231.4	6960.0
2020-09-02 19:00:00	MSFT	Stock	231.5	231.9	231.5	231.62	13251.0
2020-09-02 04:00:00	NVDA	Stock	14.005	14.15	14.005	14.15	395160.0
2020-09-02 05:00:00	NVDA	Stock	14.175	14.1805	14.129	14.1625	347040.0
2020-09-02 06:00:00	NVDA	Stock	14.1393	14.1792	14.1338	14.1792	157680.0
2020-09-02 07:00:00	NVDA	Stock	14.1742	14.5173	14.1632	14.4502	4460400.0
2020-09-02 08:00:00	NVDA	Stock	14.2942	14.725	14.1532	14.6732	10150440.0
2020-09-02 09:00:00	NVDA	Stock	14.6738	14.7268	13.9	14.1138	182726240.0
2020-09-02 10:00:00	NVDA	Stock	14.1249	14.7162	14.1143	14.2743	177704640.0
2020-09-02 11:00:00	NVDA	Stock	14.2743	14.3022	14.059	14.1956	93966760.0
2020-09-02 12:00:00	NVDA	Stock	14.1979	14.3812	14.1785	14.338	65324600.0
2020-09-02 13:00:00	NVDA	Stock	14.3382	14.4212	14.3	14.3843	43706880.0
2020-09-02 14:00:00	NVDA	Stock	14.386	14.4288	14.307	14.3938	42092360.0
2020-09-02 15:00:00	NVDA	Stock	14.394	14.465	14.2758	14.3465	79838560.0
2020-09-02 16:00:00	NVDA	Stock	14.3465	14.375	14.275	14.275	7117120.0
2020-09-02 17:00:00	NVDA	Stock	14.2805	14.3112	14.275	14.3062	464400.0
2020-09-02 18:00:00	NVDA	Stock	14.2888	14.305	14.285	14.2995	340320.0
2020-09-02 19:00:00	NVDA	Stock	14.3	14.325	14.2998	14.306	385960.0
2020-09-02 04:00:00	AMZN	Stock	176.25	176.8005	176.25	176.7675	18080.0
2020-09-02 05:00:00	AMZN	Stock	177.2	177.2	177.2	177.2	3040.0

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

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