PREVIEW / stock_1hour / 2018-01-04

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-01-04.parquet
  size:    1.1 MB
  rows:    49,890
  symbols: 2,924

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-01-04 04:00:00	AAPL	Stock	43.1	43.1025	43.1	43.1	4312.0
2018-01-04 05:00:00	AAPL	Stock	43.15	43.2	43.15	43.2	6508.0
2018-01-04 06:00:00	AAPL	Stock	43.1525	43.17	43.125	43.17	21460.0
2018-01-04 07:00:00	AAPL	Stock	43.14	43.1925	43.1325	43.1525	62336.0
2018-01-04 08:00:00	AAPL	Stock	43.17	43.22	43.14	43.2	262992.0
2018-01-04 09:00:00	AAPL	Stock	43.2	43.29	43.02	43.235	14549600.0
2018-01-04 10:00:00	AAPL	Stock	43.235	43.3675	43.165	43.2388	14315304.0
2018-01-04 11:00:00	AAPL	Stock	43.24	43.3675	43.1875	43.2575	10844148.0
2018-01-04 12:00:00	AAPL	Stock	43.255	43.304	43.165	43.21	7030724.0
2018-01-04 13:00:00	AAPL	Stock	43.2075	43.235	43.15	43.235	5520300.0
2018-01-04 14:00:00	AAPL	Stock	43.2325	43.2975	43.2125	43.2825	6724952.0
2018-01-04 15:00:00	AAPL	Stock	43.2825	43.31	43.2375	43.255	12077976.0
2018-01-04 16:00:00	AAPL	Stock	43.2625	43.305	43.25	43.305	8898676.0
2018-01-04 17:00:00	AAPL	Stock	43.3	43.31	43.2925	43.2925	99984.0
2018-01-04 18:00:00	AAPL	Stock	43.2975	43.3	43.175	43.245	152844.0
2018-01-04 19:00:00	AAPL	Stock	43.25	43.3325	43.225	43.3325	122684.0
2018-01-04 04:00:00	MSFT	Stock	86.6	86.6	86.6	86.6	200.0
2018-01-04 06:00:00	MSFT	Stock	86.6	86.6	86.6	86.6	4946.0
2018-01-04 07:00:00	MSFT	Stock	86.6	86.69	86.6	86.69	2873.0
2018-01-04 08:00:00	MSFT	Stock	86.6	86.78	86.6	86.7	16850.0
2018-01-04 09:00:00	MSFT	Stock	86.69	87.06	86.57	87.01	3532025.0
2018-01-04 10:00:00	MSFT	Stock	87.015	87.64	87.006	87.605	3200279.0
2018-01-04 11:00:00	MSFT	Stock	87.61	87.66	87.245	87.495	2610413.0
2018-01-04 12:00:00	MSFT	Stock	87.5	87.64	87.28	87.295	1747594.0
2018-01-04 13:00:00	MSFT	Stock	87.295	87.36	87.245	87.347	1262310.0
2018-01-04 14:00:00	MSFT	Stock	87.35	87.39	87.16	87.21	1378625.0
2018-01-04 15:00:00	MSFT	Stock	87.205	87.3	87.02	87.12	3067530.0
2018-01-04 16:00:00	MSFT	Stock	87.11	87.15	87.05	87.15	2720595.0
2018-01-04 17:00:00	MSFT	Stock	87.15	87.15	87.15	87.15	1350.0
2018-01-04 18:00:00	MSFT	Stock	87.15	87.2	87.15	87.2	4613.0
2018-01-04 19:00:00	MSFT	Stock	87.25	87.25	87.22	87.22	1067.0
2018-01-04 04:00:00	NVDA	Stock	5.3375	5.3375	5.3375	5.3375	40160.0
2018-01-04 05:00:00	NVDA	Stock	5.3512	5.3512	5.3512	5.3512	4000.0
2018-01-04 06:00:00	NVDA	Stock	5.3485	5.3485	5.3343	5.3425	208880.0
2018-01-04 07:00:00	NVDA	Stock	5.3425	5.36	5.3375	5.3562	1500480.0
2018-01-04 08:00:00	NVDA	Stock	5.3568	5.424	5.3338	5.4138	11858920.0
2018-01-04 09:00:00	NVDA	Stock	5.4112	5.4513	5.3173	5.3418	202037440.0
2018-01-04 10:00:00	NVDA	Stock	5.3422	5.3898	5.3215	5.375	100848440.0
2018-01-04 11:00:00	NVDA	Stock	5.375	5.3768	5.346	5.3668	51294080.0
2018-01-04 12:00:00	NVDA	Stock	5.3668	5.373	5.345	5.3516	39908640.0
2018-01-04 13:00:00	NVDA	Stock	5.3512	5.3612	5.337	5.3475	32650240.0
2018-01-04 14:00:00	NVDA	Stock	5.35	5.3562	5.341	5.353	25586800.0
2018-01-04 15:00:00	NVDA	Stock	5.354	5.3573	5.3333	5.3398	59737480.0
2018-01-04 16:00:00	NVDA	Stock	5.3398	5.3438	5.3378	5.3413	3510000.0
2018-01-04 17:00:00	NVDA	Stock	5.3438	5.3448	5.3398	5.344	1020040.0
2018-01-04 18:00:00	NVDA	Stock	5.3425	5.3475	5.34	5.34	468840.0
2018-01-04 19:00:00	NVDA	Stock	5.3413	5.3498	5.34	5.3448	377640.0
2018-01-04 05:00:00	AMZN	Stock	60.4	60.4	60.4	60.4	4160.0
2018-01-04 07:00:00	AMZN	Stock	60.394	60.4	60.35	60.353	81500.0
2018-01-04 08:00:00	AMZN	Stock	60.3995	60.4	60.2975	60.348	369400.0

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

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