PREVIEW / stock_1hour / 2018-11-07

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-11-07.parquet
  size:    1.1 MB
  rows:    50,226
  symbols: 2,750

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-11-07 04:00:00	AAPL	Stock	51.58	51.8	51.5525	51.75	102720.0
2018-11-07 05:00:00	AAPL	Stock	51.7525	51.7525	51.625	51.6625	36980.0
2018-11-07 06:00:00	AAPL	Stock	51.6625	51.6625	51.5	51.525	106404.0
2018-11-07 07:00:00	AAPL	Stock	51.5	51.6725	51.45	51.4725	626772.0
2018-11-07 08:00:00	AAPL	Stock	51.5475	51.6625	51.3125	51.4075	969012.0
2018-11-07 09:00:00	AAPL	Stock	51.3925	51.5475	51.0325	51.2075	17864808.0
2018-11-07 10:00:00	AAPL	Stock	51.2075	51.615	51.15	51.535	19402616.0
2018-11-07 11:00:00	AAPL	Stock	51.5425	51.885	51.4475	51.8638	13830868.0
2018-11-07 12:00:00	AAPL	Stock	51.87	51.975	51.775	51.9125	10451968.0
2018-11-07 13:00:00	AAPL	Stock	51.92	51.99	51.815	51.8725	8273424.0
2018-11-07 14:00:00	AAPL	Stock	51.8775	52.0475	51.835	51.9875	9925908.0
2018-11-07 15:00:00	AAPL	Stock	51.9903	52.515	51.97	52.49	22379008.0
2018-11-07 16:00:00	AAPL	Stock	52.4875	52.4925	52.4075	52.4102	11851508.0
2018-11-07 17:00:00	AAPL	Stock	52.415	52.4875	52.375	52.46	159132.0
2018-11-07 18:00:00	AAPL	Stock	52.4475	52.585	52.4375	52.5075	283908.0
2018-11-07 19:00:00	AAPL	Stock	52.525	52.6125	52.5175	52.5625	116504.0
2018-11-07 04:00:00	MSFT	Stock	109.0	109.3	109.0	109.3	400.0
2018-11-07 05:00:00	MSFT	Stock	109.15	109.29	109.15	109.2	1399.0
2018-11-07 06:00:00	MSFT	Stock	109.14	109.19	109.0	109.14	13876.0
2018-11-07 07:00:00	MSFT	Stock	109.14	109.48	108.8	109.03	32546.0
2018-11-07 08:00:00	MSFT	Stock	109.1	109.48	108.8	108.86	59424.0
2018-11-07 09:00:00	MSFT	Stock	108.83	110.75	108.31	110.38	5686600.0
2018-11-07 10:00:00	MSFT	Stock	110.38	112.02	110.32	111.73	6436614.0
2018-11-07 11:00:00	MSFT	Stock	111.74	112.015	111.23	111.9	3834786.0
2018-11-07 12:00:00	MSFT	Stock	111.91	111.985	111.72	111.83	2171577.0
2018-11-07 13:00:00	MSFT	Stock	111.83	112.0	111.59	111.856	2208310.0
2018-11-07 14:00:00	MSFT	Stock	111.86	112.16	111.78	111.86	3417413.0
2018-11-07 15:00:00	MSFT	Stock	111.85	112.24	111.7	111.96	6631896.0
2018-11-07 16:00:00	MSFT	Stock	111.99	112.07	111.85	111.92	4151212.0
2018-11-07 17:00:00	MSFT	Stock	112.0	112.09	111.86	112.03	7078.0
2018-11-07 18:00:00	MSFT	Stock	112.03	112.08	111.95	112.08	15001.0
2018-11-07 19:00:00	MSFT	Stock	112.0	112.0	111.9	111.95	3082.0
2018-11-07 04:00:00	NVDA	Stock	5.35	5.4298	5.35	5.4	51360.0
2018-11-07 05:00:00	NVDA	Stock	5.385	5.3868	5.385	5.3868	8160.0
2018-11-07 06:00:00	NVDA	Stock	5.382	5.382	5.3375	5.3375	43600.0
2018-11-07 07:00:00	NVDA	Stock	5.342	5.3668	5.333	5.34	602920.0
2018-11-07 08:00:00	NVDA	Stock	5.3498	5.3813	5.333	5.3495	1394200.0
2018-11-07 09:00:00	NVDA	Stock	5.3495	5.3868	5.2795	5.3348	74172200.0
2018-11-07 10:00:00	NVDA	Stock	5.3335	5.4062	5.3175	5.3889	87563880.0
2018-11-07 11:00:00	NVDA	Stock	5.3898	5.4352	5.3733	5.4112	52568240.0
2018-11-07 12:00:00	NVDA	Stock	5.412	5.414	5.3655	5.3903	31213200.0
2018-11-07 13:00:00	NVDA	Stock	5.393	5.4075	5.3368	5.366	32095800.0
2018-11-07 14:00:00	NVDA	Stock	5.3658	5.3712	5.3253	5.3271	34713800.0
2018-11-07 15:00:00	NVDA	Stock	5.3255	5.3448	5.3085	5.3445	83089600.0
2018-11-07 16:00:00	NVDA	Stock	5.3448	5.3502	5.3288	5.3375	18723880.0
2018-11-07 17:00:00	NVDA	Stock	5.3413	5.3445	5.325	5.3445	1707920.0
2018-11-07 18:00:00	NVDA	Stock	5.3425	5.3623	5.3425	5.358	245960.0
2018-11-07 19:00:00	NVDA	Stock	5.3575	5.3738	5.355	5.3738	441720.0
2018-11-07 04:00:00	AMZN	Stock	83.25	83.75	83.25	83.75	49220.0
2018-11-07 05:00:00	AMZN	Stock	83.75	83.75	83.562	83.562	26840.0

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

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