PREVIEW / stock_1hour / 2019-07-30

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-07-30.parquet
  size:    1.1 MB
  rows:    50,637
  symbols: 2,570

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-07-30 04:00:00	AAPL	Stock	52.35	52.4	52.18	52.195	31460.0
2019-07-30 05:00:00	AAPL	Stock	52.195	52.2	52.1275	52.14	8504.0
2019-07-30 06:00:00	AAPL	Stock	52.13	52.225	52.0825	52.225	26632.0
2019-07-30 07:00:00	AAPL	Stock	52.22	52.275	51.97	51.9975	307744.0
2019-07-30 08:00:00	AAPL	Stock	51.985	52.2875	51.905	51.9375	345760.0
2019-07-30 09:00:00	AAPL	Stock	51.95	52.3975	51.9375	51.9688	13782192.0
2019-07-30 10:00:00	AAPL	Stock	51.9712	52.0952	51.8275	51.9188	12533964.0
2019-07-30 11:00:00	AAPL	Stock	51.92	52.0775	51.9175	51.9762	8143632.0
2019-07-30 12:00:00	AAPL	Stock	51.975	52.0675	51.9375	51.975	6401148.0
2019-07-30 13:00:00	AAPL	Stock	51.9762	52.215	51.9738	52.195	9559488.0
2019-07-30 14:00:00	AAPL	Stock	52.195	52.54	52.1925	52.3775	16208724.0
2019-07-30 15:00:00	AAPL	Stock	52.375	52.4825	52.086	52.221	17600688.0
2019-07-30 16:00:00	AAPL	Stock	52.215	54.495	51.3725	54.355	21006020.0
2019-07-30 17:00:00	AAPL	Stock	54.355	54.625	54.25	54.4475	4718232.0
2019-07-30 18:00:00	AAPL	Stock	54.45	54.45	54.2875	54.3825	878872.0
2019-07-30 19:00:00	AAPL	Stock	54.4125	54.5325	54.395	54.5325	777208.0
2019-07-30 04:00:00	MSFT	Stock	141.23	141.23	140.73	140.73	602.0
2019-07-30 05:00:00	MSFT	Stock	140.52	140.72	140.52	140.72	313.0
2019-07-30 06:00:00	MSFT	Stock	140.67	140.67	140.4	140.65	2403.0
2019-07-30 07:00:00	MSFT	Stock	140.43	140.45	139.94	140.04	10373.0
2019-07-30 08:00:00	MSFT	Stock	140.09	141.38	139.69	139.722	43486.0
2019-07-30 09:00:00	MSFT	Stock	139.934	140.81	139.7	140.62	1877809.0
2019-07-30 10:00:00	MSFT	Stock	140.59	141.0	140.476	140.93	2022880.0
2019-07-30 11:00:00	MSFT	Stock	140.94	141.19	140.17	140.253	1408310.0
2019-07-30 12:00:00	MSFT	Stock	140.26	140.645	140.23	140.57	1552610.0
2019-07-30 13:00:00	MSFT	Stock	140.589	140.73	140.41	140.69	1107522.0
2019-07-30 14:00:00	MSFT	Stock	140.7	141.22	140.63	140.7	1201566.0
2019-07-30 15:00:00	MSFT	Stock	140.7	140.77	140.165	140.37	2639120.0
2019-07-30 16:00:00	MSFT	Stock	140.35	140.55	140.15	140.45	1961045.0
2019-07-30 17:00:00	MSFT	Stock	140.4	140.49	140.36	140.45	17374.0
2019-07-30 18:00:00	MSFT	Stock	140.37	140.4	140.3	140.3	6776.0
2019-07-30 19:00:00	MSFT	Stock	140.35	140.35	140.15	140.34	21132.0
2019-07-30 04:00:00	NVDA	Stock	4.3612	4.3612	4.3612	4.3612	4000.0
2019-07-30 06:00:00	NVDA	Stock	4.3557	4.3557	4.35	4.35	10920.0
2019-07-30 07:00:00	NVDA	Stock	4.3572	4.3665	4.3265	4.33	1068280.0
2019-07-30 08:00:00	NVDA	Stock	4.352	4.3615	4.3218	4.3225	350000.0
2019-07-30 09:00:00	NVDA	Stock	4.32	4.338	4.3093	4.3182	29214320.0
2019-07-30 10:00:00	NVDA	Stock	4.3173	4.3392	4.3145	4.337	21812600.0
2019-07-30 11:00:00	NVDA	Stock	4.3375	4.3695	4.3366	4.3668	22363920.0
2019-07-30 12:00:00	NVDA	Stock	4.3662	4.3788	4.362	4.374	19335320.0
2019-07-30 13:00:00	NVDA	Stock	4.3745	4.3818	4.3665	4.3705	18103440.0
2019-07-30 14:00:00	NVDA	Stock	4.37	4.3985	4.37	4.3918	22729160.0
2019-07-30 15:00:00	NVDA	Stock	4.3912	4.3952	4.3733	4.3865	32081280.0
2019-07-30 16:00:00	NVDA	Stock	4.3862	4.3862	4.3	4.344	8170760.0
2019-07-30 17:00:00	NVDA	Stock	4.3455	4.3862	4.3338	4.345	4474520.0
2019-07-30 18:00:00	NVDA	Stock	4.3472	4.35	4.3325	4.35	357440.0
2019-07-30 19:00:00	NVDA	Stock	4.3515	4.355	4.3475	4.3475	52760.0
2019-07-30 04:00:00	AMZN	Stock	95.35	95.35	95.2215	95.2215	6000.0
2019-07-30 05:00:00	AMZN	Stock	95.1615	95.1615	94.9995	94.9995	16000.0
2019-07-30 06:00:00	AMZN	Stock	94.928	94.928	94.75	94.825	16000.0

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

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