PREVIEW / stock_1hour / 2019-04-26

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-04-26.parquet
  size:    1.1 MB
  rows:    48,831
  symbols: 2,604

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-04-26 04:00:00	AAPL	Stock	51.2475	51.2475	51.0125	51.0375	33492.0
2019-04-26 05:00:00	AAPL	Stock	51.015	51.065	51.015	51.0325	8360.0
2019-04-26 06:00:00	AAPL	Stock	51.1025	51.125	51.0375	51.125	6632.0
2019-04-26 07:00:00	AAPL	Stock	51.175	51.225	51.09	51.09	42136.0
2019-04-26 08:00:00	AAPL	Stock	51.1175	51.2675	51.07	51.2175	420452.0
2019-04-26 09:00:00	AAPL	Stock	51.2175	51.3	50.53	50.82	12323416.0
2019-04-26 10:00:00	AAPL	Stock	50.82	51.1375	50.7375	50.97	10735788.0
2019-04-26 11:00:00	AAPL	Stock	50.9725	51.19	50.895	51.12	6368096.0
2019-04-26 12:00:00	AAPL	Stock	51.1175	51.2025	51.0425	51.0525	4300620.0
2019-04-26 13:00:00	AAPL	Stock	51.0525	51.0575	50.925	50.96	4677176.0
2019-04-26 14:00:00	AAPL	Stock	50.9625	50.9625	50.8375	50.8925	6128112.0
2019-04-26 15:00:00	AAPL	Stock	50.895	51.1625	50.8925	51.0725	13376360.0
2019-04-26 16:00:00	AAPL	Stock	51.075	51.125	51.07	51.095	7159496.0
2019-04-26 17:00:00	AAPL	Stock	51.1125	51.1125	51.0075	51.0075	55292.0
2019-04-26 18:00:00	AAPL	Stock	51.0125	51.0625	51.0125	51.0425	20308.0
2019-04-26 19:00:00	AAPL	Stock	51.05	51.1	51.05	51.0875	37880.0
2019-04-26 04:00:00	MSFT	Stock	129.1	129.14	129.07	129.14	427.0
2019-04-26 05:00:00	MSFT	Stock	129.12	129.15	129.1	129.15	2507.0
2019-04-26 06:00:00	MSFT	Stock	129.19	129.2	129.18	129.18	300.0
2019-04-26 07:00:00	MSFT	Stock	129.33	129.33	129.0	129.0	18417.0
2019-04-26 08:00:00	MSFT	Stock	129.39	129.98	128.82	129.58	100119.0
2019-04-26 09:00:00	MSFT	Stock	129.57	130.515	129.08	129.3	4312451.0
2019-04-26 10:00:00	MSFT	Stock	129.305	129.63	129.02	129.45	3042985.0
2019-04-26 11:00:00	MSFT	Stock	129.455	130.04	129.235	129.78	2283225.0
2019-04-26 12:00:00	MSFT	Stock	129.78	130.026	129.66	129.684	1509363.0
2019-04-26 13:00:00	MSFT	Stock	129.68	129.717	129.43	129.465	1338084.0
2019-04-26 14:00:00	MSFT	Stock	129.46	129.89	129.35	129.74	1434244.0
2019-04-26 15:00:00	MSFT	Stock	129.75	129.91	129.565	129.89	3144429.0
2019-04-26 16:00:00	MSFT	Stock	129.89	129.92	129.5	129.88	3856119.0
2019-04-26 17:00:00	MSFT	Stock	129.67	129.67	129.63	129.67	2285.0
2019-04-26 18:00:00	MSFT	Stock	129.7	129.75	129.62	129.67	9065.0
2019-04-26 19:00:00	MSFT	Stock	129.7	129.75	129.7	129.75	1266.0
2019-04-26 04:00:00	NVDA	Stock	4.5588	4.5588	4.5525	4.5525	51320.0
2019-04-26 05:00:00	NVDA	Stock	4.5525	4.575	4.547	4.5725	263040.0
2019-04-26 06:00:00	NVDA	Stock	4.55	4.5505	4.5455	4.5455	44000.0
2019-04-26 07:00:00	NVDA	Stock	4.55	4.565	4.5273	4.5275	1320600.0
2019-04-26 08:00:00	NVDA	Stock	4.5525	4.5625	4.5202	4.525	4971080.0
2019-04-26 09:00:00	NVDA	Stock	4.525	4.542	4.3438	4.3595	207994120.0
2019-04-26 10:00:00	NVDA	Stock	4.36	4.4412	4.3325	4.4276	180232560.0
2019-04-26 11:00:00	NVDA	Stock	4.4278	4.452	4.3928	4.4	96036880.0
2019-04-26 12:00:00	NVDA	Stock	4.4007	4.427	4.394	4.4019	74420240.0
2019-04-26 13:00:00	NVDA	Stock	4.4025	4.4178	4.3909	4.4111	43627480.0
2019-04-26 14:00:00	NVDA	Stock	4.4112	4.4308	4.4018	4.4285	50637440.0
2019-04-26 15:00:00	NVDA	Stock	4.4288	4.4522	4.4248	4.4522	103581120.0
2019-04-26 16:00:00	NVDA	Stock	4.4522	4.4588	4.4388	4.4388	6014320.0
2019-04-26 17:00:00	NVDA	Stock	4.4392	4.4465	4.4362	4.4465	451280.0
2019-04-26 18:00:00	NVDA	Stock	4.4472	4.45	4.4412	4.45	149000.0
2019-04-26 19:00:00	NVDA	Stock	4.4498	4.45	4.445	4.445	190400.0
2019-04-26 04:00:00	AMZN	Stock	95.9825	96.25	95.9825	96.176	48140.0
2019-04-26 05:00:00	AMZN	Stock	96.1735	96.1735	95.9875	96.006	26660.0

> showing 50 of 48,831 rows — these rows as CSV

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