PREVIEW / stock_1hour / 2019-05-31

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-05-31.parquet
  size:    1.1 MB
  rows:    50,737
  symbols: 2,610

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-05-31 04:00:00	AAPL	Stock	43.8	43.9075	43.8	43.8475	25732.0
2019-05-31 05:00:00	AAPL	Stock	43.8675	43.875	43.62	43.6675	59028.0
2019-05-31 06:00:00	AAPL	Stock	43.6875	43.75	43.6	43.75	26516.0
2019-05-31 07:00:00	AAPL	Stock	43.725	43.965	43.7025	43.875	220576.0
2019-05-31 08:00:00	AAPL	Stock	43.805	44.05	43.7625	43.9425	431476.0
2019-05-31 09:00:00	AAPL	Stock	43.945	44.275	43.905	44.225	12982764.0
2019-05-31 10:00:00	AAPL	Stock	44.2175	44.4975	44.2025	44.3575	13639356.0
2019-05-31 11:00:00	AAPL	Stock	44.3525	44.4175	44.19	44.275	8616876.0
2019-05-31 12:00:00	AAPL	Stock	44.2725	44.2925	44.1325	44.21	6850484.0
2019-05-31 13:00:00	AAPL	Stock	44.2075	44.39	44.165	44.3078	6252704.0
2019-05-31 14:00:00	AAPL	Stock	44.3125	44.3525	43.9625	44.035	11405588.0
2019-05-31 15:00:00	AAPL	Stock	44.035	44.0475	43.7475	43.75	19185196.0
2019-05-31 16:00:00	AAPL	Stock	43.76	43.8	43.745	43.755	9744252.0
2019-05-31 17:00:00	AAPL	Stock	43.7625	43.825	43.735	43.7525	122620.0
2019-05-31 18:00:00	AAPL	Stock	43.7625	43.7675	43.71	43.71	37636.0
2019-05-31 19:00:00	AAPL	Stock	43.7	43.7375	43.6925	43.705	45460.0
2019-05-31 04:00:00	MSFT	Stock	124.0	124.27	123.99	124.21	2456.0
2019-05-31 05:00:00	MSFT	Stock	124.15	124.16	123.59	123.65	1953.0
2019-05-31 06:00:00	MSFT	Stock	123.6	123.73	123.42	123.7	6801.0
2019-05-31 07:00:00	MSFT	Stock	123.55	124.17	123.55	124.0	14956.0
2019-05-31 08:00:00	MSFT	Stock	123.726	124.27	123.65	124.15	36279.0
2019-05-31 09:00:00	MSFT	Stock	124.2	124.615	123.52	123.83	2530718.0
2019-05-31 10:00:00	MSFT	Stock	123.85	124.28	123.59	123.94	2500831.0
2019-05-31 11:00:00	MSFT	Stock	123.94	124.2	123.61	123.712	2293935.0
2019-05-31 12:00:00	MSFT	Stock	123.71	123.835	123.32	123.51	1731356.0
2019-05-31 13:00:00	MSFT	Stock	123.5	123.98	123.44	123.93	1406837.0
2019-05-31 14:00:00	MSFT	Stock	123.93	124.0	123.45	123.805	2214678.0
2019-05-31 15:00:00	MSFT	Stock	123.8	123.94	123.41	123.59	4346317.0
2019-05-31 16:00:00	MSFT	Stock	123.64	123.88	123.64	123.78	4772772.0
2019-05-31 17:00:00	MSFT	Stock	123.72	123.8	123.7	123.8	3750.0
2019-05-31 18:00:00	MSFT	Stock	123.75	123.8	123.68	123.7	3706.0
2019-05-31 19:00:00	MSFT	Stock	123.7	123.71	123.65	123.65	2953.0
2019-05-31 04:00:00	NVDA	Stock	3.4013	3.4062	3.4008	3.4042	21720.0
2019-05-31 05:00:00	NVDA	Stock	3.4075	3.4128	3.4008	3.4025	45600.0
2019-05-31 06:00:00	NVDA	Stock	3.4	3.412	3.3868	3.412	112560.0
2019-05-31 07:00:00	NVDA	Stock	3.414	3.425	3.4088	3.4225	558080.0
2019-05-31 08:00:00	NVDA	Stock	3.4222	3.4352	3.4088	3.4295	2053200.0
2019-05-31 09:00:00	NVDA	Stock	3.4252	3.4571	3.4055	3.4502	60620560.0
2019-05-31 10:00:00	NVDA	Stock	3.4495	3.4612	3.4305	3.456	60451040.0
2019-05-31 11:00:00	NVDA	Stock	3.455	3.4553	3.4318	3.4403	32274720.0
2019-05-31 12:00:00	NVDA	Stock	3.4392	3.4414	3.4102	3.413	30827760.0
2019-05-31 13:00:00	NVDA	Stock	3.413	3.4288	3.4118	3.4265	25827880.0
2019-05-31 14:00:00	NVDA	Stock	3.4265	3.4288	3.4005	3.4023	42833600.0
2019-05-31 15:00:00	NVDA	Stock	3.4025	3.408	3.3848	3.3865	83503480.0
2019-05-31 16:00:00	NVDA	Stock	3.3865	3.3875	3.3798	3.385	5184560.0
2019-05-31 17:00:00	NVDA	Stock	3.3838	3.3895	3.3832	3.3895	441880.0
2019-05-31 18:00:00	NVDA	Stock	3.389	3.3892	3.3825	3.3868	305440.0
2019-05-31 19:00:00	NVDA	Stock	3.3825	3.3915	3.3825	3.3915	367600.0
2019-05-31 04:00:00	AMZN	Stock	89.15	89.25	89.15	89.25	20680.0
2019-05-31 05:00:00	AMZN	Stock	89.1225	89.125	88.75	88.7555	32200.0

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

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