PREVIEW / stock_1hour / 2019-06-28

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-06-28.parquet
  size:    1.1 MB
  rows:    51,063
  symbols: 2,616

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-06-28 04:00:00	AAPL	Stock	49.65	49.69	49.4375	49.5	17472.0
2019-06-28 05:00:00	AAPL	Stock	49.5	49.5	49.4675	49.48	5168.0
2019-06-28 06:00:00	AAPL	Stock	49.5225	49.5225	49.475	49.51	6840.0
2019-06-28 07:00:00	AAPL	Stock	49.5	49.6875	49.475	49.6375	126596.0
2019-06-28 08:00:00	AAPL	Stock	49.525	49.72	49.515	49.6625	396996.0
2019-06-28 09:00:00	AAPL	Stock	49.6625	49.8738	49.3125	49.335	11300812.0
2019-06-28 10:00:00	AAPL	Stock	49.335	49.575	49.2625	49.555	9551432.0
2019-06-28 11:00:00	AAPL	Stock	49.555	49.6835	49.455	49.66	6159328.0
2019-06-28 12:00:00	AAPL	Stock	49.66	49.85	49.6525	49.735	7257188.0
2019-06-28 13:00:00	AAPL	Stock	49.74	49.745	49.475	49.5115	5776484.0
2019-06-28 14:00:00	AAPL	Stock	49.5125	49.564	49.29	49.3225	7719264.0
2019-06-28 15:00:00	AAPL	Stock	49.3237	49.5225	49.28	49.48	18967968.0
2019-06-28 16:00:00	AAPL	Stock	49.49	49.625	49.385	49.5	32321228.0
2019-06-28 17:00:00	AAPL	Stock	49.5175	49.5225	49.4825	49.5225	38652.0
2019-06-28 18:00:00	AAPL	Stock	49.5	49.575	49.5	49.55	47688.0
2019-06-28 19:00:00	AAPL	Stock	49.525	49.5625	49.4975	49.4975	88416.0
2019-06-28 07:00:00	MSFT	Stock	134.59	134.59	134.38	134.5	4696.0
2019-06-28 08:00:00	MSFT	Stock	134.58	134.9	134.42	134.79	38869.0
2019-06-28 09:00:00	MSFT	Stock	134.71	134.75	133.36	133.51	1766322.0
2019-06-28 10:00:00	MSFT	Stock	133.51	133.86	133.38	133.66	1410010.0
2019-06-28 11:00:00	MSFT	Stock	133.65	133.65	133.35	133.45	1226196.0
2019-06-28 12:00:00	MSFT	Stock	133.45	134.17	133.445	133.9	1591541.0
2019-06-28 13:00:00	MSFT	Stock	133.905	133.915	133.215	133.25	1042229.0
2019-06-28 14:00:00	MSFT	Stock	133.23	133.51	133.156	133.454	1495581.0
2019-06-28 15:00:00	MSFT	Stock	133.45	134.19	133.16	133.93	5830413.0
2019-06-28 16:00:00	MSFT	Stock	133.93	134.31	133.8	134.11	9892610.0
2019-06-28 17:00:00	MSFT	Stock	134.11	134.18	134.1	134.12	6556.0
2019-06-28 18:00:00	MSFT	Stock	134.1	134.17	134.08	134.17	10258.0
2019-06-28 19:00:00	MSFT	Stock	134.1	134.34	134.06	134.2	8069.0
2019-06-28 04:00:00	NVDA	Stock	4.1008	4.1075	4.1002	4.1075	29960.0
2019-06-28 05:00:00	NVDA	Stock	4.1105	4.1182	4.1105	4.1105	80640.0
2019-06-28 06:00:00	NVDA	Stock	4.12	4.12	4.1078	4.1078	22920.0
2019-06-28 07:00:00	NVDA	Stock	4.1055	4.1132	4.1	4.1102	330880.0
2019-06-28 08:00:00	NVDA	Stock	4.11	4.125	4.1	4.12	2276680.0
2019-06-28 09:00:00	NVDA	Stock	4.1215	4.1343	4.0682	4.0734	72644320.0
2019-06-28 10:00:00	NVDA	Stock	4.072	4.0952	4.0588	4.094	62748440.0
2019-06-28 11:00:00	NVDA	Stock	4.0928	4.1188	4.0811	4.1037	43099960.0
2019-06-28 12:00:00	NVDA	Stock	4.1038	4.122	4.1015	4.1182	27297960.0
2019-06-28 13:00:00	NVDA	Stock	4.1181	4.1188	4.099	4.103	25515720.0
2019-06-28 14:00:00	NVDA	Stock	4.1025	4.1098	4.0922	4.1052	21362600.0
2019-06-28 15:00:00	NVDA	Stock	4.105	4.1125	4.0958	4.104	54571720.0
2019-06-28 16:00:00	NVDA	Stock	4.1057	4.1175	4.1025	4.1175	44998360.0
2019-06-28 17:00:00	NVDA	Stock	4.1123	4.1188	4.1123	4.1165	131600.0
2019-06-28 18:00:00	NVDA	Stock	4.1188	4.122	4.115	4.1192	345960.0
2019-06-28 19:00:00	NVDA	Stock	4.1175	4.119	4.1125	4.1125	340760.0
2019-06-28 05:00:00	AMZN	Stock	95.45	95.45	95.45	95.45	2000.0
2019-06-28 07:00:00	AMZN	Stock	95.4	95.4	95.35	95.35	13380.0
2019-06-28 08:00:00	AMZN	Stock	95.4	95.555	95.4	95.55	36260.0
2019-06-28 09:00:00	AMZN	Stock	95.55	95.647	94.9	95.072	4199320.0
2019-06-28 10:00:00	AMZN	Stock	95.043	95.178	94.9344	95.0548	3897000.0

> showing 50 of 51,063 rows — these rows as CSV

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