PREVIEW / stock_1hour / 2018-12-14

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-12-14.parquet
  size:    1.1 MB
  rows:    49,462
  symbols: 2,719

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-14 04:00:00	AAPL	Stock	42.1875	42.1875	42.0575	42.1125	32688.0
2018-12-14 05:00:00	AAPL	Stock	42.125	42.2225	42.125	42.125	26592.0
2018-12-14 06:00:00	AAPL	Stock	42.15	42.25	42.125	42.25	12100.0
2018-12-14 07:00:00	AAPL	Stock	42.275	42.425	42.2125	42.2475	340360.0
2018-12-14 08:00:00	AAPL	Stock	42.315	42.375	42.1675	42.2825	595808.0
2018-12-14 09:00:00	AAPL	Stock	42.275	42.3	41.715	41.805	20766632.0
2018-12-14 10:00:00	AAPL	Stock	41.805	41.93	41.5052	41.7375	24820388.0
2018-12-14 11:00:00	AAPL	Stock	41.7375	41.925	41.625	41.7025	16413272.0
2018-12-14 12:00:00	AAPL	Stock	41.7	41.7725	41.5875	41.6838	12789244.0
2018-12-14 13:00:00	AAPL	Stock	41.685	41.87	41.625	41.6987	11854032.0
2018-12-14 14:00:00	AAPL	Stock	41.6987	41.76	41.5175	41.6375	14642844.0
2018-12-14 15:00:00	AAPL	Stock	41.64	41.7075	41.32	41.35	30243204.0
2018-12-14 16:00:00	AAPL	Stock	41.37	41.375	41.325	41.35	14924624.0
2018-12-14 17:00:00	AAPL	Stock	41.325	41.3625	41.3125	41.3425	112556.0
2018-12-14 18:00:00	AAPL	Stock	41.3375	41.3575	41.3025	41.3325	64300.0
2018-12-14 19:00:00	AAPL	Stock	41.3125	41.325	41.275	41.275	91992.0
2018-12-14 04:00:00	MSFT	Stock	108.0	108.0	108.0	108.0	205.0
2018-12-14 05:00:00	MSFT	Stock	107.9	107.9	107.9	107.9	1000.0
2018-12-14 06:00:00	MSFT	Stock	108.09	108.25	108.08	108.23	3080.0
2018-12-14 07:00:00	MSFT	Stock	108.1	108.6	108.1	108.44	8058.0
2018-12-14 08:00:00	MSFT	Stock	108.48	108.55	108.21	108.41	30791.0
2018-12-14 09:00:00	MSFT	Stock	108.45	108.67	107.68	108.48	3637193.0
2018-12-14 10:00:00	MSFT	Stock	108.47	109.26	108.32	108.85	4989916.0
2018-12-14 11:00:00	MSFT	Stock	108.86	109.13	107.31	107.415	5340165.0
2018-12-14 12:00:00	MSFT	Stock	107.42	108.0	107.34	107.48	4706832.0
2018-12-14 13:00:00	MSFT	Stock	107.48	107.65	106.23	106.436	4462519.0
2018-12-14 14:00:00	MSFT	Stock	106.43	106.59	105.5	106.14	4362180.0
2018-12-14 15:00:00	MSFT	Stock	106.14	106.71	105.73	106.02	8655117.0
2018-12-14 16:00:00	MSFT	Stock	106.03	106.04	105.8	105.99	6313522.0
2018-12-14 17:00:00	MSFT	Stock	106.03	106.13	105.99	106.04	18833.0
2018-12-14 18:00:00	MSFT	Stock	106.04	106.04	105.92	105.95	2334.0
2018-12-14 19:00:00	MSFT	Stock	105.92	105.97	105.8	105.84	3940.0
2018-12-14 04:00:00	NVDA	Stock	3.6605	3.6605	3.6435	3.657	86880.0
2018-12-14 05:00:00	NVDA	Stock	3.6572	3.6678	3.65	3.6678	34560.0
2018-12-14 06:00:00	NVDA	Stock	3.6558	3.6922	3.6558	3.6655	155840.0
2018-12-14 07:00:00	NVDA	Stock	3.68	3.685	3.6675	3.6682	910920.0
2018-12-14 08:00:00	NVDA	Stock	3.6665	3.6897	3.6625	3.6755	1252760.0
2018-12-14 09:00:00	NVDA	Stock	3.687	3.7188	3.6375	3.711	72616800.0
2018-12-14 10:00:00	NVDA	Stock	3.7098	3.7648	3.703	3.7435	75814680.0
2018-12-14 11:00:00	NVDA	Stock	3.7438	3.7572	3.6932	3.701	50444320.0
2018-12-14 12:00:00	NVDA	Stock	3.7018	3.7121	3.6888	3.6954	32572760.0
2018-12-14 13:00:00	NVDA	Stock	3.6948	3.7118	3.6873	3.6912	36574400.0
2018-12-14 14:00:00	NVDA	Stock	3.6903	3.7084	3.6708	3.6985	42213040.0
2018-12-14 15:00:00	NVDA	Stock	3.6964	3.71	3.655	3.6605	86953960.0
2018-12-14 16:00:00	NVDA	Stock	3.6612	3.6675	3.6578	3.6635	8162320.0
2018-12-14 17:00:00	NVDA	Stock	3.6635	3.6675	3.6612	3.6638	212760.0
2018-12-14 18:00:00	NVDA	Stock	3.665	3.667	3.6612	3.6625	96640.0
2018-12-14 19:00:00	NVDA	Stock	3.6662	3.667	3.6538	3.6553	225240.0
2018-12-14 04:00:00	AMZN	Stock	81.5	81.5	81.4	81.4	8600.0
2018-12-14 05:00:00	AMZN	Stock	81.7065	81.7065	81.425	81.5	26620.0

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

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