PREVIEW / stock_1hour / 2018-09-25

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-09-25.parquet
  size:    1.1 MB
  rows:    49,698
  symbols: 2,781

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
2018-09-25 04:00:00	AAPL	Stock	55.375	55.3975	55.3	55.3075	11704.0
2018-09-25 05:00:00	AAPL	Stock	55.245	55.3	55.245	55.3	17768.0
2018-09-25 06:00:00	AAPL	Stock	55.3	55.335	55.275	55.3	51092.0
2018-09-25 07:00:00	AAPL	Stock	55.32	55.3675	55.2125	55.25	312340.0
2018-09-25 08:00:00	AAPL	Stock	55.3125	55.35	54.8375	55.0825	551960.0
2018-09-25 09:00:00	AAPL	Stock	55.0825	55.2975	54.8125	55.2225	13462928.0
2018-09-25 10:00:00	AAPL	Stock	55.22	55.3975	55.035	55.12	10788280.0
2018-09-25 11:00:00	AAPL	Stock	55.1175	55.705	55.09	55.631	11533848.0
2018-09-25 12:00:00	AAPL	Stock	55.6325	55.6748	55.5025	55.525	6101656.0
2018-09-25 13:00:00	AAPL	Stock	55.525	55.635	55.445	55.5	6435432.0
2018-09-25 14:00:00	AAPL	Stock	55.4975	55.505	55.4225	55.4348	4745692.0
2018-09-25 15:00:00	AAPL	Stock	55.4425	55.6225	55.4158	55.5475	11162896.0
2018-09-25 16:00:00	AAPL	Stock	55.5475	55.595	55.515	55.5475	14543492.0
2018-09-25 17:00:00	AAPL	Stock	55.526	55.5525	55.52	55.5525	33352.0
2018-09-25 18:00:00	AAPL	Stock	55.5475	55.555	55.5	55.525	56988.0
2018-09-25 19:00:00	AAPL	Stock	55.5375	55.585	55.5375	55.565	81828.0
2018-09-25 05:00:00	MSFT	Stock	114.95	114.95	114.95	114.95	300.0
2018-09-25 06:00:00	MSFT	Stock	114.95	115.22	114.95	115.2	3117.0
2018-09-25 07:00:00	MSFT	Stock	115.0	115.12	114.95	115.1	5349.0
2018-09-25 08:00:00	MSFT	Stock	114.95	115.13	114.92	115.01	9673.0
2018-09-25 09:00:00	MSFT	Stock	114.95	115.1	114.26	114.75	2591401.0
2018-09-25 10:00:00	MSFT	Stock	114.75	114.92	113.78	113.81	2542336.0
2018-09-25 11:00:00	MSFT	Stock	113.8	114.49	113.75	114.335	1827665.0
2018-09-25 12:00:00	MSFT	Stock	114.335	114.37	113.95	114.01	1096144.0
2018-09-25 13:00:00	MSFT	Stock	114.01	114.22	113.945	114.03	1440432.0
2018-09-25 14:00:00	MSFT	Stock	114.025	114.08	113.91	114.055	1226721.0
2018-09-25 15:00:00	MSFT	Stock	114.05	114.52	114.05	114.46	4125064.0
2018-09-25 16:00:00	MSFT	Stock	114.45	114.52	114.411	114.52	3132470.0
2018-09-25 17:00:00	MSFT	Stock	114.45	114.49	114.41	114.49	2460.0
2018-09-25 18:00:00	MSFT	Stock	114.5	114.5	114.48	114.48	862.0
2018-09-25 19:00:00	MSFT	Stock	114.45	114.64	114.45	114.64	9425.0
2018-09-25 05:00:00	NVDA	Stock	6.6688	6.7498	6.6688	6.7375	419320.0
2018-09-25 06:00:00	NVDA	Stock	6.715	6.7442	6.715	6.725	450040.0
2018-09-25 07:00:00	NVDA	Stock	6.7038	6.7495	6.6752	6.725	1521240.0
2018-09-25 08:00:00	NVDA	Stock	6.7	6.7488	6.6752	6.7208	1596800.0
2018-09-25 09:00:00	NVDA	Stock	6.7208	6.7355	6.672	6.7125	46801080.0
2018-09-25 10:00:00	NVDA	Stock	6.7118	6.7213	6.6228	6.6268	40628520.0
2018-09-25 11:00:00	NVDA	Stock	6.626	6.6845	6.6244	6.6742	28479880.0
2018-09-25 12:00:00	NVDA	Stock	6.6748	6.6998	6.6678	6.6728	20454880.0
2018-09-25 13:00:00	NVDA	Stock	6.6742	6.7025	6.6688	6.6992	16538120.0
2018-09-25 14:00:00	NVDA	Stock	6.6994	6.7195	6.6922	6.7085	16919800.0
2018-09-25 15:00:00	NVDA	Stock	6.7098	6.7275	6.7002	6.71	49823880.0
2018-09-25 16:00:00	NVDA	Stock	6.7103	6.716	6.704	6.7138	11165040.0
2018-09-25 17:00:00	NVDA	Stock	6.7145	6.715	6.7068	6.707	59560.0
2018-09-25 18:00:00	NVDA	Stock	6.7103	6.7105	6.705	6.7075	164400.0
2018-09-25 19:00:00	NVDA	Stock	6.7075	6.7125	6.6988	6.6988	124960.0
2018-09-25 06:00:00	AMZN	Stock	96.8995	97.2225	96.8995	97.15	55240.0
2018-09-25 07:00:00	AMZN	Stock	97.1545	97.45	97.1545	97.45	202980.0
2018-09-25 08:00:00	AMZN	Stock	97.2597	97.418	97.0555	97.1825	389860.0
2018-09-25 09:00:00	AMZN	Stock	97.1085	97.6795	96.9995	97.6331	9204300.0

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

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