PREVIEW / stock_1hour / 2018-10-29

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-10-29.parquet
  size:    1.1 MB
  rows:    50,366
  symbols: 2,752

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-10-29 04:00:00	AAPL	Stock	54.25	54.7175	54.25	54.6625	6292.0
2018-10-29 05:00:00	AAPL	Stock	54.6375	54.995	54.5	54.97	68456.0
2018-10-29 06:00:00	AAPL	Stock	54.925	55.025	54.795	55.025	92436.0
2018-10-29 07:00:00	AAPL	Stock	54.9625	55.125	54.8275	54.86	468136.0
2018-10-29 08:00:00	AAPL	Stock	54.9125	55.1	54.8	54.875	544152.0
2018-10-29 09:00:00	AAPL	Stock	54.885	54.9175	54.5025	54.7525	16350032.0
2018-10-29 10:00:00	AAPL	Stock	54.7575	54.9225	54.53	54.61	16183660.0
2018-10-29 11:00:00	AAPL	Stock	54.62	54.7125	53.9625	54.005	14999984.0
2018-10-29 12:00:00	AAPL	Stock	54.005	54.275	53.69	53.865	16588008.0
2018-10-29 13:00:00	AAPL	Stock	53.8688	54.3025	53.825	54.0782	10658356.0
2018-10-29 14:00:00	AAPL	Stock	54.075	54.075	53.3	53.515	19234256.0
2018-10-29 15:00:00	AAPL	Stock	53.5125	53.5325	51.5225	53.1375	50849636.0
2018-10-29 16:00:00	AAPL	Stock	53.1225	53.1875	52.95	53.0	12738972.0
2018-10-29 17:00:00	AAPL	Stock	52.975	53.06	52.875	52.9	345344.0
2018-10-29 18:00:00	AAPL	Stock	52.9125	52.9225	52.765	52.8375	185936.0
2018-10-29 19:00:00	AAPL	Stock	52.9075	53.0675	52.895	53.0675	231448.0
2018-10-29 04:00:00	MSFT	Stock	107.1	107.5	107.0	107.5	1964.0
2018-10-29 05:00:00	MSFT	Stock	107.2	108.45	107.0	108.39	6883.0
2018-10-29 06:00:00	MSFT	Stock	108.2	108.3	108.2	108.3	700.0
2018-10-29 07:00:00	MSFT	Stock	108.1	108.59	108.04	108.17	35337.0
2018-10-29 08:00:00	MSFT	Stock	108.25	108.59	108.0	108.49	45887.0
2018-10-29 09:00:00	MSFT	Stock	108.56	108.56	107.67	107.97	3705483.0
2018-10-29 10:00:00	MSFT	Stock	107.97	108.7	106.94	107.03	5132819.0
2018-10-29 11:00:00	MSFT	Stock	107.04	107.34	105.98	106.0	4649085.0
2018-10-29 12:00:00	MSFT	Stock	106.01	106.07	104.95	105.23	5979986.0
2018-10-29 13:00:00	MSFT	Stock	105.22	106.06	105.16	105.43	4186531.0
2018-10-29 14:00:00	MSFT	Stock	105.43	105.45	103.89	104.31	6449940.0
2018-10-29 15:00:00	MSFT	Stock	104.313	104.37	101.63	104.09	14792855.0
2018-10-29 16:00:00	MSFT	Stock	103.85	104.32	103.1	103.55	5199484.0
2018-10-29 17:00:00	MSFT	Stock	103.51	103.85	103.2	103.28	109119.0
2018-10-29 18:00:00	MSFT	Stock	103.27	103.55	103.2	103.55	25596.0
2018-10-29 19:00:00	MSFT	Stock	103.54	104.25	103.5	103.83	26482.0
2018-10-29 04:00:00	NVDA	Stock	4.98	4.98	4.98	4.98	4000.0
2018-10-29 05:00:00	NVDA	Stock	4.9935	5.0593	4.975	5.0593	90960.0
2018-10-29 06:00:00	NVDA	Stock	5.0548	5.0625	5.0375	5.045	32000.0
2018-10-29 07:00:00	NVDA	Stock	5.0625	5.1373	5.05	5.129	661560.0
2018-10-29 08:00:00	NVDA	Stock	5.125	5.1325	5.0575	5.1075	1217560.0
2018-10-29 09:00:00	NVDA	Stock	5.107	5.11	5.0162	5.0615	54293800.0
2018-10-29 10:00:00	NVDA	Stock	5.0668	5.0883	4.9803	5.0018	80507680.0
2018-10-29 11:00:00	NVDA	Stock	5.005	5.0268	4.9172	4.9248	66384200.0
2018-10-29 12:00:00	NVDA	Stock	4.9247	4.948	4.71	4.7888	108880840.0
2018-10-29 13:00:00	NVDA	Stock	4.7913	4.8638	4.7755	4.7758	48892040.0
2018-10-29 14:00:00	NVDA	Stock	4.7792	4.7975	4.6752	4.6983	69674360.0
2018-10-29 15:00:00	NVDA	Stock	4.6983	4.7013	4.4002	4.6403	218294720.0
2018-10-29 16:00:00	NVDA	Stock	4.6405	4.6525	4.613	4.625	7974400.0
2018-10-29 17:00:00	NVDA	Stock	4.6162	4.6405	4.59	4.6208	954800.0
2018-10-29 18:00:00	NVDA	Stock	4.6125	4.6212	4.5963	4.5963	522560.0
2018-10-29 19:00:00	NVDA	Stock	4.6062	4.6325	4.6025	4.604	394960.0
2018-10-29 04:00:00	AMZN	Stock	82.45	82.791	82.45	82.791	9800.0
2018-10-29 05:00:00	AMZN	Stock	82.7	83.2505	82.7	83.2505	55800.0

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

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