PREVIEW / stock_1hour / 2019-05-16

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-05-16.parquet
  size:    1.1 MB
  rows:    49,754
  symbols: 2,597

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-05-16 04:00:00	AAPL	Stock	47.5	47.655	47.5	47.655	25640.0
2019-05-16 05:00:00	AAPL	Stock	47.6525	47.7475	47.65	47.7475	3424.0
2019-05-16 06:00:00	AAPL	Stock	47.705	47.915	47.6975	47.875	36920.0
2019-05-16 07:00:00	AAPL	Stock	47.8775	47.96	47.765	47.875	309448.0
2019-05-16 08:00:00	AAPL	Stock	47.8625	47.96	47.48	47.5525	723852.0
2019-05-16 09:00:00	AAPL	Stock	47.52	47.5338	47.275	47.4	17638364.0
2019-05-16 10:00:00	AAPL	Stock	47.395	47.8875	47.21	47.81	20764200.0
2019-05-16 11:00:00	AAPL	Stock	47.81	48.025	47.725	47.9925	10097444.0
2019-05-16 12:00:00	AAPL	Stock	48.0025	48.1172	47.8525	47.915	8923324.0
2019-05-16 13:00:00	AAPL	Stock	47.915	47.955	47.565	47.625	10607000.0
2019-05-16 14:00:00	AAPL	Stock	47.625	47.745	47.5575	47.6325	9629876.0
2019-05-16 15:00:00	AAPL	Stock	47.6275	47.6825	47.2975	47.535	20682316.0
2019-05-16 16:00:00	AAPL	Stock	47.535	47.5425	47.4325	47.5	11058600.0
2019-05-16 17:00:00	AAPL	Stock	47.5	47.525	47.4475	47.45	30772.0
2019-05-16 18:00:00	AAPL	Stock	47.4525	47.4975	47.45	47.455	17736.0
2019-05-16 19:00:00	AAPL	Stock	47.465	47.515	47.4625	47.4875	57464.0
2019-05-16 04:00:00	MSFT	Stock	125.71	125.71	125.71	125.71	649.0
2019-05-16 05:00:00	MSFT	Stock	126.2	126.3	126.2	126.3	1200.0
2019-05-16 06:00:00	MSFT	Stock	126.43	126.9	126.43	126.65	2663.0
2019-05-16 07:00:00	MSFT	Stock	126.57	126.83	126.52	126.6	5569.0
2019-05-16 08:00:00	MSFT	Stock	126.6	126.87	126.0	126.4	59609.0
2019-05-16 09:00:00	MSFT	Stock	126.42	128.08	126.26	128.023	3083962.0
2019-05-16 10:00:00	MSFT	Stock	128.02	129.33	127.99	129.16	5206046.0
2019-05-16 11:00:00	MSFT	Stock	129.16	129.34	128.91	129.165	2462672.0
2019-05-16 12:00:00	MSFT	Stock	129.165	129.38	128.83	128.95	2008994.0
2019-05-16 13:00:00	MSFT	Stock	128.96	129.13	128.68	128.89	1859457.0
2019-05-16 14:00:00	MSFT	Stock	128.9	129.23	128.628	129.1	2165403.0
2019-05-16 15:00:00	MSFT	Stock	129.1	129.1	128.43	128.95	5067834.0
2019-05-16 16:00:00	MSFT	Stock	128.96	129.05	128.78	128.93	3601191.0
2019-05-16 17:00:00	MSFT	Stock	128.93	128.95	128.9	128.9	3928.0
2019-05-16 18:00:00	MSFT	Stock	128.99	129.09	128.95	129.0	4241.0
2019-05-16 19:00:00	MSFT	Stock	129.0	129.09	128.95	129.01	9052.0
2019-05-16 04:00:00	NVDA	Stock	3.9775	3.9885	3.9775	3.9885	20480.0
2019-05-16 05:00:00	NVDA	Stock	3.9903	3.9953	3.9903	3.9932	72920.0
2019-05-16 06:00:00	NVDA	Stock	3.983	4.0112	3.954	4.0048	266400.0
2019-05-16 07:00:00	NVDA	Stock	4.0	4.0075	3.9875	3.9875	1529760.0
2019-05-16 08:00:00	NVDA	Stock	3.9975	4.0075	3.975	3.986	1998200.0
2019-05-16 09:00:00	NVDA	Stock	3.9845	4.0042	3.9412	3.9805	86628360.0
2019-05-16 10:00:00	NVDA	Stock	3.982	4.0193	3.961	4.0058	99675400.0
2019-05-16 11:00:00	NVDA	Stock	4.005	4.0476	4.0042	4.0348	72530200.0
2019-05-16 12:00:00	NVDA	Stock	4.035	4.04	4.0145	4.015	41625240.0
2019-05-16 13:00:00	NVDA	Stock	4.0168	4.0325	3.9938	3.9995	44025960.0
2019-05-16 14:00:00	NVDA	Stock	4.0	4.0331	3.9955	4.0176	59332120.0
2019-05-16 15:00:00	NVDA	Stock	4.0172	4.02	3.9935	4.006	112002520.0
2019-05-16 16:00:00	NVDA	Stock	4.006	4.2995	4.0005	4.2518	100223160.0
2019-05-16 17:00:00	NVDA	Stock	4.2518	4.2838	4.0268	4.047	36130720.0
2019-05-16 18:00:00	NVDA	Stock	4.047	4.0875	4.0175	4.0682	24850040.0
2019-05-16 19:00:00	NVDA	Stock	4.0675	4.0925	4.0602	4.0848	7031720.0
2019-05-16 04:00:00	AMZN	Stock	93.25	93.467	93.25	93.467	23000.0
2019-05-16 05:00:00	AMZN	Stock	93.8525	94.0	93.8525	93.952	16580.0

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

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