PREVIEW / stock_1hour / 2019-03-06

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-03-06.parquet
  size:    1.1 MB
  rows:    50,351
  symbols: 2,642

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-03-06 04:00:00	AAPL	Stock	43.8175	43.825	43.8175	43.825	800.0
2019-03-06 06:00:00	AAPL	Stock	43.8	43.8	43.8	43.8	2000.0
2019-03-06 07:00:00	AAPL	Stock	43.8	43.815	43.65	43.675	163844.0
2019-03-06 08:00:00	AAPL	Stock	43.6725	43.81	43.63	43.75	251932.0
2019-03-06 09:00:00	AAPL	Stock	43.7375	43.7625	43.485	43.7225	12822048.0
2019-03-06 10:00:00	AAPL	Stock	43.7238	43.8725	43.6675	43.7988	11442948.0
2019-03-06 11:00:00	AAPL	Stock	43.8025	43.8675	43.6425	43.73	8568244.0
2019-03-06 12:00:00	AAPL	Stock	43.73	43.8	43.655	43.6885	6080908.0
2019-03-06 13:00:00	AAPL	Stock	43.69	43.7125	43.62	43.6888	5593884.0
2019-03-06 14:00:00	AAPL	Stock	43.69	43.73	43.6375	43.67	5504660.0
2019-03-06 15:00:00	AAPL	Stock	43.6675	43.7175	43.59	43.6275	10997840.0
2019-03-06 16:00:00	AAPL	Stock	43.63	43.6625	43.59	43.625	11848432.0
2019-03-06 17:00:00	AAPL	Stock	43.6225	43.6225	43.5875	43.6125	23048.0
2019-03-06 18:00:00	AAPL	Stock	43.6125	43.615	43.58	43.58	49084.0
2019-03-06 19:00:00	AAPL	Stock	43.59	43.59	43.53	43.5625	20928.0
2019-03-06 04:00:00	MSFT	Stock	111.7	111.7	111.7	111.7	800.0
2019-03-06 06:00:00	MSFT	Stock	111.7	111.8	111.7	111.8	3104.0
2019-03-06 07:00:00	MSFT	Stock	111.85	111.85	111.65	111.66	30867.0
2019-03-06 08:00:00	MSFT	Stock	111.8	112.0	111.62	111.86	33916.0
2019-03-06 09:00:00	MSFT	Stock	111.88	112.61	111.8	112.54	2335588.0
2019-03-06 10:00:00	MSFT	Stock	112.545	112.66	111.765	112.02	2517372.0
2019-03-06 11:00:00	MSFT	Stock	112.01	112.21	111.43	111.74	1800153.0
2019-03-06 12:00:00	MSFT	Stock	111.74	111.97	111.63	111.75	1324497.0
2019-03-06 13:00:00	MSFT	Stock	111.76	111.96	111.61	111.846	1165469.0
2019-03-06 14:00:00	MSFT	Stock	111.85	111.95	111.58	111.83	1278814.0
2019-03-06 15:00:00	MSFT	Stock	111.82	112.0	111.54	111.74	3021996.0
2019-03-06 16:00:00	MSFT	Stock	111.75	111.88	111.67	111.67	1733903.0
2019-03-06 17:00:00	MSFT	Stock	111.69	111.75	111.65	111.65	3334.0
2019-03-06 18:00:00	MSFT	Stock	111.65	111.72	111.52	111.54	3943.0
2019-03-06 19:00:00	MSFT	Stock	111.51	111.64	111.36	111.36	14972.0
2019-03-06 04:00:00	NVDA	Stock	3.9008	3.9008	3.9008	3.9008	40000.0
2019-03-06 06:00:00	NVDA	Stock	3.9055	3.9055	3.9053	3.9053	20000.0
2019-03-06 07:00:00	NVDA	Stock	3.905	3.905	3.892	3.8988	305960.0
2019-03-06 08:00:00	NVDA	Stock	3.9	3.9228	3.8943	3.9018	499760.0
2019-03-06 09:00:00	NVDA	Stock	3.9122	3.9247	3.842	3.863	71940200.0
2019-03-06 10:00:00	NVDA	Stock	3.862	3.8717	3.8345	3.8395	64036280.0
2019-03-06 11:00:00	NVDA	Stock	3.84	3.855	3.816	3.8257	44257000.0
2019-03-06 12:00:00	NVDA	Stock	3.8237	3.841	3.8218	3.8245	23699600.0
2019-03-06 13:00:00	NVDA	Stock	3.8252	3.8605	3.8218	3.8602	31724120.0
2019-03-06 14:00:00	NVDA	Stock	3.86	3.8658	3.8278	3.8284	34920720.0
2019-03-06 15:00:00	NVDA	Stock	3.8278	3.8328	3.7985	3.801	67869520.0
2019-03-06 16:00:00	NVDA	Stock	3.8005	3.8061	3.8005	3.8048	11401320.0
2019-03-06 17:00:00	NVDA	Stock	3.8017	3.805	3.8013	3.8013	298800.0
2019-03-06 18:00:00	NVDA	Stock	3.8013	3.805	3.7972	3.7972	213440.0
2019-03-06 19:00:00	NVDA	Stock	3.7962	3.7992	3.7875	3.7972	409440.0
2019-03-06 04:00:00	AMZN	Stock	84.6605	84.6605	84.6605	84.6605	2000.0
2019-03-06 05:00:00	AMZN	Stock	84.65	84.65	84.55	84.55	12480.0
2019-03-06 07:00:00	AMZN	Stock	84.75	84.75	84.6555	84.6555	38500.0
2019-03-06 08:00:00	AMZN	Stock	84.72	84.7965	84.545	84.785	165280.0
2019-03-06 09:00:00	AMZN	Stock	84.806	84.8875	84.1746	84.494	7081760.0

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

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