PREVIEW / stock_1hour / 2018-12-07

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-12-07.parquet
  size:    1.1 MB
  rows:    50,246
  symbols: 2,720

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-07 04:00:00	AAPL	Stock	43.4375	43.4675	43.2375	43.4025	16272.0
2018-12-07 05:00:00	AAPL	Stock	43.3825	43.485	43.3825	43.475	9620.0
2018-12-07 06:00:00	AAPL	Stock	43.4275	43.4275	43.3375	43.3375	8832.0
2018-12-07 07:00:00	AAPL	Stock	43.3375	43.4125	43.315	43.4075	107704.0
2018-12-07 08:00:00	AAPL	Stock	43.35	43.8	43.315	43.6	631648.0
2018-12-07 09:00:00	AAPL	Stock	43.5875	43.6625	43.14	43.415	14790308.0
2018-12-07 10:00:00	AAPL	Stock	43.425	43.4875	42.7575	42.9025	19619236.0
2018-12-07 11:00:00	AAPL	Stock	42.9	42.955	42.5225	42.53	19648788.0
2018-12-07 12:00:00	AAPL	Stock	42.5275	42.865	42.5	42.815	13842992.0
2018-12-07 13:00:00	AAPL	Stock	42.815	42.8575	42.4045	42.4268	13003400.0
2018-12-07 14:00:00	AAPL	Stock	42.425	42.64	42.205	42.26	19664220.0
2018-12-07 15:00:00	AAPL	Stock	42.27	42.4125	42.075	42.0975	30811092.0
2018-12-07 16:00:00	AAPL	Stock	42.095	42.1875	42.095	42.1125	15749548.0
2018-12-07 17:00:00	AAPL	Stock	42.1372	42.1625	42.0875	42.1	94628.0
2018-12-07 18:00:00	AAPL	Stock	42.1	42.1225	42.025	42.045	2228684.0
2018-12-07 19:00:00	AAPL	Stock	42.0625	42.0775	42.0225	42.0225	92116.0
2018-12-07 04:00:00	MSFT	Stock	108.42	108.63	108.42	108.63	2332.0
2018-12-07 05:00:00	MSFT	Stock	108.71	108.73	108.54	108.54	1500.0
2018-12-07 06:00:00	MSFT	Stock	108.31	108.31	108.31	108.31	100.0
2018-12-07 07:00:00	MSFT	Stock	108.2	108.5	108.17	108.44	7065.0
2018-12-07 08:00:00	MSFT	Stock	108.35	109.16	108.19	108.52	38967.0
2018-12-07 09:00:00	MSFT	Stock	108.54	109.45	108.11	109.05	3240164.0
2018-12-07 10:00:00	MSFT	Stock	109.06	109.35	107.21	107.37	5169965.0
2018-12-07 11:00:00	MSFT	Stock	107.375	107.6	106.12	106.12	5266365.0
2018-12-07 12:00:00	MSFT	Stock	106.117	106.87	105.97	106.69	3419064.0
2018-12-07 13:00:00	MSFT	Stock	106.68	106.993	105.45	105.49	3388147.0
2018-12-07 14:00:00	MSFT	Stock	105.5	105.74	104.58	104.65	5275281.0
2018-12-07 15:00:00	MSFT	Stock	104.66	105.63	104.3	104.79	8607642.0
2018-12-07 16:00:00	MSFT	Stock	104.82	105.07	104.67	105.0	5813553.0
2018-12-07 17:00:00	MSFT	Stock	104.98	105.05	104.9	105.0	3425.0
2018-12-07 18:00:00	MSFT	Stock	105.02	105.02	104.62	104.62	635621.0
2018-12-07 19:00:00	MSFT	Stock	104.85	104.89	104.55	104.56	13206.0
2018-12-07 04:00:00	NVDA	Stock	3.925	3.9338	3.9225	3.9303	71360.0
2018-12-07 05:00:00	NVDA	Stock	3.935	3.9693	3.9335	3.9625	241600.0
2018-12-07 07:00:00	NVDA	Stock	3.9352	3.9532	3.925	3.9528	465760.0
2018-12-07 08:00:00	NVDA	Stock	3.9623	3.985	3.9252	3.97	2645040.0
2018-12-07 09:00:00	NVDA	Stock	3.9663	3.975	3.8603	3.8682	68980200.0
2018-12-07 10:00:00	NVDA	Stock	3.8695	3.887	3.7968	3.8192	95722440.0
2018-12-07 11:00:00	NVDA	Stock	3.8192	3.8255	3.692	3.697	100921040.0
2018-12-07 12:00:00	NVDA	Stock	3.696	3.7448	3.68	3.74	71162240.0
2018-12-07 13:00:00	NVDA	Stock	3.739	3.7498	3.697	3.6985	55306920.0
2018-12-07 14:00:00	NVDA	Stock	3.6982	3.735	3.6632	3.67	67075520.0
2018-12-07 15:00:00	NVDA	Stock	3.671	3.723	3.6404	3.69	106954600.0
2018-12-07 16:00:00	NVDA	Stock	3.6903	3.6938	3.6822	3.688	27329360.0
2018-12-07 17:00:00	NVDA	Stock	3.6882	3.6882	3.675	3.6752	349400.0
2018-12-07 18:00:00	NVDA	Stock	3.6775	3.6825	3.6725	3.6788	263920.0
2018-12-07 19:00:00	NVDA	Stock	3.6822	3.6822	3.6712	3.6752	199400.0
2018-12-07 04:00:00	AMZN	Stock	84.675	84.675	84.675	84.675	2020.0
2018-12-07 06:00:00	AMZN	Stock	84.88	84.88	84.55	84.55	23940.0
2018-12-07 07:00:00	AMZN	Stock	84.504	85.1625	84.376	85.1625	162940.0

> showing 50 of 50,246 rows — these rows as CSV

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