PREVIEW / stock_1hour / 2019-10-15

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-10-15.parquet
  size:    1.1 MB
  rows:    49,112
  symbols: 2,500

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-10-15 04:00:00	AAPL	Stock	59.3125	59.3525	59.2625	59.2625	18764.0
2019-10-15 05:00:00	AAPL	Stock	59.2725	59.2725	59.25	59.2525	3128.0
2019-10-15 06:00:00	AAPL	Stock	59.25	59.255	59.05	59.1425	33304.0
2019-10-15 07:00:00	AAPL	Stock	59.2	59.275	59.1275	59.18	183744.0
2019-10-15 08:00:00	AAPL	Stock	59.2575	59.2575	59.08	59.11	239076.0
2019-10-15 09:00:00	AAPL	Stock	59.11	59.3075	59.0125	59.19	9848972.0
2019-10-15 10:00:00	AAPL	Stock	59.1925	59.4125	59.0925	59.3625	11337888.0
2019-10-15 11:00:00	AAPL	Stock	59.365	59.365	58.72	58.9238	14970116.0
2019-10-15 12:00:00	AAPL	Stock	58.9275	59.055	58.8875	59.0075	6201992.0
2019-10-15 13:00:00	AAPL	Stock	59.01	59.025	58.88	58.9515	5018048.0
2019-10-15 14:00:00	AAPL	Stock	58.955	59.0425	58.9175	58.975	5014952.0
2019-10-15 15:00:00	AAPL	Stock	58.9725	59.015	58.755	58.83	10693092.0
2019-10-15 16:00:00	AAPL	Stock	58.83	58.9	58.83	58.865	11087144.0
2019-10-15 17:00:00	AAPL	Stock	58.8875	59.574	58.875	58.9	72476.0
2019-10-15 18:00:00	AAPL	Stock	58.9	58.91	58.8625	58.8625	38664.0
2019-10-15 19:00:00	AAPL	Stock	58.8575	58.8575	58.735	58.75	132716.0
2019-10-15 04:00:00	MSFT	Stock	140.24	140.25	140.24	140.25	700.0
2019-10-15 05:00:00	MSFT	Stock	140.29	140.3	140.29	140.3	1041.0
2019-10-15 06:00:00	MSFT	Stock	140.29	140.29	140.02	140.02	1041.0
2019-10-15 07:00:00	MSFT	Stock	140.15	140.2	139.85	140.2	10662.0
2019-10-15 08:00:00	MSFT	Stock	139.9	140.05	139.85	140.05	10768.0
2019-10-15 09:00:00	MSFT	Stock	140.1	140.65	139.81	140.46	1814369.0
2019-10-15 10:00:00	MSFT	Stock	140.465	141.79	140.465	141.61	3770533.0
2019-10-15 11:00:00	MSFT	Stock	141.61	141.74	141.16	141.415	2080734.0
2019-10-15 12:00:00	MSFT	Stock	141.41	141.63	141.333	141.47	1449525.0
2019-10-15 13:00:00	MSFT	Stock	141.48	141.67	141.454	141.61	1485559.0
2019-10-15 14:00:00	MSFT	Stock	141.61	141.68	141.38	141.478	1398751.0
2019-10-15 15:00:00	MSFT	Stock	141.47	141.61	141.28	141.57	2988946.0
2019-10-15 16:00:00	MSFT	Stock	141.575	141.76	141.45	141.575	2538848.0
2019-10-15 17:00:00	MSFT	Stock	141.75	141.8	135.617	141.8	8679.0
2019-10-15 18:00:00	MSFT	Stock	141.73	141.75	141.25	141.52	24521.0
2019-10-15 19:00:00	MSFT	Stock	141.5	141.57	141.4	141.54	6731.0
2019-10-15 04:00:00	NVDA	Stock	4.6938	4.6938	4.6938	4.6938	41160.0
2019-10-15 05:00:00	NVDA	Stock	4.6912	4.6912	4.6908	4.6908	31080.0
2019-10-15 06:00:00	NVDA	Stock	4.6908	4.6908	4.6908	4.6908	10320.0
2019-10-15 07:00:00	NVDA	Stock	4.6875	4.7575	4.6825	4.7575	2534880.0
2019-10-15 08:00:00	NVDA	Stock	4.68	4.77	4.6778	4.76	3212800.0
2019-10-15 09:00:00	NVDA	Stock	4.7625	4.8478	4.74	4.8202	117097400.0
2019-10-15 10:00:00	NVDA	Stock	4.8211	4.8863	4.8131	4.8843	96200520.0
2019-10-15 11:00:00	NVDA	Stock	4.8854	4.934	4.8628	4.933	103706120.0
2019-10-15 12:00:00	NVDA	Stock	4.9335	4.9823	4.9328	4.9629	105578240.0
2019-10-15 13:00:00	NVDA	Stock	4.9633	4.9698	4.9288	4.9362	51630920.0
2019-10-15 14:00:00	NVDA	Stock	4.9368	4.9473	4.9115	4.9202	53336920.0
2019-10-15 15:00:00	NVDA	Stock	4.9193	4.9325	4.9036	4.9105	66415600.0
2019-10-15 16:00:00	NVDA	Stock	4.9092	4.9185	4.9	4.91	17647720.0
2019-10-15 17:00:00	NVDA	Stock	4.9125	4.9185	4.9122	4.9172	106000.0
2019-10-15 18:00:00	NVDA	Stock	4.916	4.9213	4.9138	4.9175	163000.0
2019-10-15 19:00:00	NVDA	Stock	4.9163	4.9175	4.9	4.9038	473840.0
2019-10-15 06:00:00	AMZN	Stock	87.25	87.4	87.2485	87.25	21240.0
2019-10-15 07:00:00	AMZN	Stock	87.2	87.2	87.05	87.05	43700.0

> showing 50 of 49,112 rows — these rows as CSV

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