PREVIEW / stock_1hour / 2018-12-10

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-12-10.parquet
  size:    1.1 MB
  rows:    49,935
  symbols: 2,731

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
2018-12-10 04:00:00	AAPL	Stock	41.7	41.85	41.7	41.85	62644.0
2018-12-10 05:00:00	AAPL	Stock	41.825	41.8475	41.775	41.81	7656.0
2018-12-10 06:00:00	AAPL	Stock	41.8125	42.05	41.8125	41.9725	50920.0
2018-12-10 07:00:00	AAPL	Stock	41.9875	42.055	41.8125	41.99	377928.0
2018-12-10 08:00:00	AAPL	Stock	41.9775	42.0675	41.57	41.625	1804708.0
2018-12-10 09:00:00	AAPL	Stock	41.625	41.6875	40.8325	41.1125	42578028.0
2018-12-10 10:00:00	AAPL	Stock	41.1075	41.72	41.055	41.4462	33840564.0
2018-12-10 11:00:00	AAPL	Stock	41.44	41.4625	41.1375	41.2712	26173992.0
2018-12-10 12:00:00	AAPL	Stock	41.2675	42.3775	41.0975	42.08	38207656.0
2018-12-10 13:00:00	AAPL	Stock	42.085	42.4625	41.95	42.2425	26466112.0
2018-12-10 14:00:00	AAPL	Stock	42.245	42.5225	42.0925	42.25	18273132.0
2018-12-10 15:00:00	AAPL	Stock	42.246	42.47	42.0825	42.4025	21787408.0
2018-12-10 16:00:00	AAPL	Stock	42.4	42.5625	42.4	42.525	13292892.0
2018-12-10 17:00:00	AAPL	Stock	42.5225	42.575	42.5125	42.545	127296.0
2018-12-10 18:00:00	AAPL	Stock	42.5525	42.5525	42.425	42.425	158016.0
2018-12-10 19:00:00	AAPL	Stock	42.425	42.4625	42.2675	42.2875	124044.0
2018-12-10 04:00:00	MSFT	Stock	104.33	104.4	104.33	104.4	517.0
2018-12-10 05:00:00	MSFT	Stock	104.4	104.61	104.4	104.61	300.0
2018-12-10 06:00:00	MSFT	Stock	104.7	104.7	104.7	104.7	100.0
2018-12-10 07:00:00	MSFT	Stock	104.52	105.38	104.42	105.17	20064.0
2018-12-10 08:00:00	MSFT	Stock	104.5	105.88	104.42	105.12	58889.0
2018-12-10 09:00:00	MSFT	Stock	105.11	106.66	104.58	105.09	3927411.0
2018-12-10 10:00:00	MSFT	Stock	105.08	106.29	104.4	104.74	5439729.0
2018-12-10 11:00:00	MSFT	Stock	104.74	105.22	103.89	104.705	5365304.0
2018-12-10 12:00:00	MSFT	Stock	104.67	105.97	104.21	105.855	3667577.0
2018-12-10 13:00:00	MSFT	Stock	105.86	106.48	105.64	106.23	2949184.0
2018-12-10 14:00:00	MSFT	Stock	106.24	107.42	106.185	106.87	3800304.0
2018-12-10 15:00:00	MSFT	Stock	106.87	107.98	106.77	107.54	6784522.0
2018-12-10 16:00:00	MSFT	Stock	107.54	107.89	107.54	107.81	4068222.0
2018-12-10 17:00:00	MSFT	Stock	107.79	107.88	107.76	107.83	2280.0
2018-12-10 18:00:00	MSFT	Stock	107.82	107.82	107.33	107.34	31917.0
2018-12-10 19:00:00	MSFT	Stock	107.55	107.6	107.14	107.34	5915.0
2018-12-10 04:00:00	NVDA	Stock	3.6718	3.675	3.6718	3.675	16240.0
2018-12-10 05:00:00	NVDA	Stock	3.67	3.67	3.6475	3.665	177320.0
2018-12-10 06:00:00	NVDA	Stock	3.6735	3.6775	3.6735	3.6752	70920.0
2018-12-10 07:00:00	NVDA	Stock	3.669	3.679	3.6212	3.6712	2460880.0
2018-12-10 08:00:00	NVDA	Stock	3.621	3.7125	3.621	3.668	1782400.0
2018-12-10 09:00:00	NVDA	Stock	3.6628	3.8164	3.6375	3.7535	118313800.0
2018-12-10 10:00:00	NVDA	Stock	3.754	3.8215	3.7252	3.7454	91525840.0
2018-12-10 11:00:00	NVDA	Stock	3.749	3.7979	3.712	3.7592	63263120.0
2018-12-10 12:00:00	NVDA	Stock	3.7586	3.8108	3.7342	3.8006	56129040.0
2018-12-10 13:00:00	NVDA	Stock	3.7995	3.8075	3.7645	3.7923	41821720.0
2018-12-10 14:00:00	NVDA	Stock	3.7932	3.8148	3.76	3.7731	49377440.0
2018-12-10 15:00:00	NVDA	Stock	3.7745	3.8138	3.7608	3.7965	60692520.0
2018-12-10 16:00:00	NVDA	Stock	3.7965	3.8104	3.768	3.805	19257400.0
2018-12-10 17:00:00	NVDA	Stock	3.805	3.805	3.7988	3.7988	215880.0
2018-12-10 18:00:00	NVDA	Stock	3.8	3.8013	3.7972	3.7972	310880.0
2018-12-10 19:00:00	NVDA	Stock	3.8	3.8	3.7812	3.7825	420880.0
2018-12-10 05:00:00	AMZN	Stock	81.2345	81.25	81.2345	81.25	6340.0
2018-12-10 06:00:00	AMZN	Stock	81.35	81.5315	81.35	81.5315	23040.0

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

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