PREVIEW / stock_1hour / 2018-04-25

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-04-25.parquet
  size:    1.1 MB
  rows:    49,364
  symbols: 2,852

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-04-25 04:00:00	AAPL	Stock	40.775	40.795	40.525	40.525	11944.0
2018-04-25 05:00:00	AAPL	Stock	40.5275	40.6025	40.5275	40.6	5896.0
2018-04-25 06:00:00	AAPL	Stock	40.6025	40.675	40.6025	40.6125	25520.0
2018-04-25 07:00:00	AAPL	Stock	40.55	40.62	40.475	40.62	179640.0
2018-04-25 08:00:00	AAPL	Stock	40.5475	40.6875	40.46	40.6475	286348.0
2018-04-25 09:00:00	AAPL	Stock	40.65	41.145	40.6025	40.925	16905308.0
2018-04-25 10:00:00	AAPL	Stock	40.9263	41.26	40.7825	41.2	19548580.0
2018-04-25 11:00:00	AAPL	Stock	41.1975	41.29	41.0125	41.1275	12680276.0
2018-04-25 12:00:00	AAPL	Stock	41.1275	41.275	41.0275	41.1775	7646848.0
2018-04-25 13:00:00	AAPL	Stock	41.18	41.355	41.1585	41.246	8385124.0
2018-04-25 14:00:00	AAPL	Stock	41.25	41.265	41.0425	41.25	8282084.0
2018-04-25 15:00:00	AAPL	Stock	41.25	41.2925	40.835	40.943	17609796.0
2018-04-25 16:00:00	AAPL	Stock	40.9525	41.14	40.895	41.0375	10398384.0
2018-04-25 17:00:00	AAPL	Stock	41.05	41.17	40.9125	41.17	229216.0
2018-04-25 18:00:00	AAPL	Stock	41.17	41.1875	41.1125	41.175	43528.0
2018-04-25 19:00:00	AAPL	Stock	41.1625	41.2475	41.1625	41.2475	59096.0
2018-04-25 04:00:00	MSFT	Stock	93.0	93.0	93.0	93.0	840.0
2018-04-25 05:00:00	MSFT	Stock	92.67	92.67	92.6	92.6	2000.0
2018-04-25 07:00:00	MSFT	Stock	92.95	93.2	92.36	92.85	24461.0
2018-04-25 08:00:00	MSFT	Stock	92.35	93.14	92.35	93.14	40078.0
2018-04-25 09:00:00	MSFT	Stock	93.03	93.3	90.64	90.705	4841815.0
2018-04-25 10:00:00	MSFT	Stock	90.71	91.88	90.28	91.68	6653212.0
2018-04-25 11:00:00	MSFT	Stock	91.69	92.29	91.28	91.32	3668324.0
2018-04-25 12:00:00	MSFT	Stock	91.32	92.28	91.28	91.87	2208008.0
2018-04-25 13:00:00	MSFT	Stock	91.855	92.37	91.7	92.235	1964457.0
2018-04-25 14:00:00	MSFT	Stock	92.235	92.5	91.6	92.48	2657973.0
2018-04-25 15:00:00	MSFT	Stock	92.48	92.54	91.68	92.44	4981580.0
2018-04-25 16:00:00	MSFT	Stock	92.31	93.51	91.938	93.25	2483633.0
2018-04-25 17:00:00	MSFT	Stock	93.31	93.73	92.31	93.59	94185.0
2018-04-25 18:00:00	MSFT	Stock	93.56	93.95	93.56	93.9	56897.0
2018-04-25 19:00:00	MSFT	Stock	93.9	93.95	93.67	93.9	14937.0
2018-04-25 04:00:00	NVDA	Stock	5.5263	5.5263	5.495	5.495	74160.0
2018-04-25 05:00:00	NVDA	Stock	5.5	5.5	5.4943	5.5	49840.0
2018-04-25 06:00:00	NVDA	Stock	5.5038	5.5038	5.5038	5.5038	32000.0
2018-04-25 07:00:00	NVDA	Stock	5.4938	5.5118	5.4725	5.51	391000.0
2018-04-25 08:00:00	NVDA	Stock	5.5	5.5175	5.475	5.5138	763120.0
2018-04-25 09:00:00	NVDA	Stock	5.512	5.5394	5.3188	5.3233	89204480.0
2018-04-25 10:00:00	NVDA	Stock	5.3242	5.425	5.2575	5.4013	134658560.0
2018-04-25 11:00:00	NVDA	Stock	5.3978	5.467	5.3918	5.401	58286960.0
2018-04-25 12:00:00	NVDA	Stock	5.4038	5.455	5.3858	5.4352	32429240.0
2018-04-25 13:00:00	NVDA	Stock	5.4355	5.4555	5.4055	5.4303	27409800.0
2018-04-25 14:00:00	NVDA	Stock	5.4343	5.4375	5.3832	5.4337	34897880.0
2018-04-25 15:00:00	NVDA	Stock	5.4336	5.4395	5.372	5.4165	48687640.0
2018-04-25 16:00:00	NVDA	Stock	5.4165	5.5212	5.4125	5.4925	34161040.0
2018-04-25 17:00:00	NVDA	Stock	5.4998	5.5585	5.4998	5.5585	2611480.0
2018-04-25 18:00:00	NVDA	Stock	5.5623	5.5692	5.5425	5.5425	1198200.0
2018-04-25 19:00:00	NVDA	Stock	5.5422	5.5475	5.53	5.5475	669360.0
2018-04-25 04:00:00	AMZN	Stock	73.1325	73.1325	72.993	72.993	8440.0
2018-04-25 05:00:00	AMZN	Stock	72.9	72.9	72.875	72.875	18360.0
2018-04-25 06:00:00	AMZN	Stock	72.982	73.25	72.982	73.2275	47460.0

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

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