PREVIEW / stock_1hour / 2019-03-26

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-03-26.parquet
  size:    1.1 MB
  rows:    49,971
  symbols: 2,652

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
2019-03-26 04:00:00	AAPL	Stock	47.445	47.4625	47.0	47.1625	77328.0
2019-03-26 05:00:00	AAPL	Stock	47.25	47.38	47.2475	47.375	22020.0
2019-03-26 06:00:00	AAPL	Stock	47.485	47.58	47.3975	47.575	58724.0
2019-03-26 07:00:00	AAPL	Stock	47.5475	47.805	47.515	47.6925	569452.0
2019-03-26 08:00:00	AAPL	Stock	47.5625	48.0325	47.5425	47.7725	1298312.0
2019-03-26 09:00:00	AAPL	Stock	47.775	48.125	47.54	48.1175	24419484.0
2019-03-26 10:00:00	AAPL	Stock	48.12	48.22	47.7675	48.07	25136904.0
2019-03-26 11:00:00	AAPL	Stock	48.0675	48.11	47.6925	47.7875	15605732.0
2019-03-26 12:00:00	AAPL	Stock	47.79	47.88	47.5425	47.655	11747588.0
2019-03-26 13:00:00	AAPL	Stock	47.6525	47.77	47.2	47.269	17676336.0
2019-03-26 14:00:00	AAPL	Stock	47.2675	47.345	46.71	46.7375	20602564.0
2019-03-26 15:00:00	AAPL	Stock	46.7375	46.9022	46.145	46.6975	35123472.0
2019-03-26 16:00:00	AAPL	Stock	46.6975	47.2575	46.62	46.89	18498204.0
2019-03-26 17:00:00	AAPL	Stock	46.84	47.1375	46.84	47.0	194960.0
2019-03-26 18:00:00	AAPL	Stock	47.0175	47.1475	47.0	47.0	164348.0
2019-03-26 19:00:00	AAPL	Stock	46.97	47.045	46.88	46.97	119544.0
2019-03-26 04:00:00	MSFT	Stock	118.1	118.13	117.96	117.96	1331.0
2019-03-26 05:00:00	MSFT	Stock	117.9	118.39	117.9	118.35	1300.0
2019-03-26 06:00:00	MSFT	Stock	118.39	118.45	118.23	118.45	8182.0
2019-03-26 07:00:00	MSFT	Stock	118.26	118.35	118.2	118.28	14164.0
2019-03-26 08:00:00	MSFT	Stock	118.28	118.5	118.05	118.1	74823.0
2019-03-26 09:00:00	MSFT	Stock	118.13	118.62	117.82	118.53	2826317.0
2019-03-26 10:00:00	MSFT	Stock	118.54	118.705	117.535	117.99	4485242.0
2019-03-26 11:00:00	MSFT	Stock	117.99	118.23	117.31	117.61	2870299.0
2019-03-26 12:00:00	MSFT	Stock	117.61	117.76	117.12	117.39	2133292.0
2019-03-26 13:00:00	MSFT	Stock	117.4	117.58	117.01	117.015	1824982.0
2019-03-26 14:00:00	MSFT	Stock	117.02	117.26	116.85	117.22	2040648.0
2019-03-26 15:00:00	MSFT	Stock	117.22	117.94	117.05	117.93	3942264.0
2019-03-26 16:00:00	MSFT	Stock	117.93	117.93	117.6	117.85	2681395.0
2019-03-26 17:00:00	MSFT	Stock	117.899	117.9	117.8	117.8	2136.0
2019-03-26 18:00:00	MSFT	Stock	117.81	117.81	117.63	117.63	2173.0
2019-03-26 19:00:00	MSFT	Stock	117.65	117.77	117.52	117.7	10678.0
2019-03-26 04:00:00	NVDA	Stock	4.3765	4.3765	4.37	4.37	8000.0
2019-03-26 05:00:00	NVDA	Stock	4.3815	4.3815	4.3815	4.3815	4000.0
2019-03-26 06:00:00	NVDA	Stock	4.3843	4.3875	4.3843	4.385	58600.0
2019-03-26 07:00:00	NVDA	Stock	4.3802	4.447	4.3802	4.439	1840040.0
2019-03-26 08:00:00	NVDA	Stock	4.4	4.4862	4.3553	4.467	6255960.0
2019-03-26 09:00:00	NVDA	Stock	4.473	4.5438	4.45	4.5252	168858440.0
2019-03-26 10:00:00	NVDA	Stock	4.5268	4.5275	4.465	4.4786	114145160.0
2019-03-26 11:00:00	NVDA	Stock	4.4785	4.4835	4.4252	4.4365	78777280.0
2019-03-26 12:00:00	NVDA	Stock	4.4355	4.4568	4.4055	4.4228	55503200.0
2019-03-26 13:00:00	NVDA	Stock	4.4231	4.4302	4.377	4.3789	57128040.0
2019-03-26 14:00:00	NVDA	Stock	4.3783	4.3998	4.3649	4.3988	59117600.0
2019-03-26 15:00:00	NVDA	Stock	4.3985	4.425	4.3816	4.4238	94613720.0
2019-03-26 16:00:00	NVDA	Stock	4.4218	4.4218	4.415	4.4208	4474760.0
2019-03-26 17:00:00	NVDA	Stock	4.4208	4.4275	4.4188	4.425	422720.0
2019-03-26 18:00:00	NVDA	Stock	4.425	4.425	4.4075	4.4145	467920.0
2019-03-26 19:00:00	NVDA	Stock	4.41	4.4193	4.4083	4.4125	820360.0
2019-03-26 04:00:00	AMZN	Stock	89.427	89.427	89.046	89.046	20200.0
2019-03-26 06:00:00	AMZN	Stock	89.25	89.4	89.25	89.4	27120.0

> showing 50 of 49,971 rows — these rows as CSV

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