PREVIEW / stock_1hour / 2018-04-30

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-04-30.parquet
  size:    1.1 MB
  rows:    48,649
  symbols: 2,862

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-30 04:00:00	AAPL	Stock	40.675	40.8125	40.675	40.7725	15176.0
2018-04-30 05:00:00	AAPL	Stock	40.775	40.7875	40.75	40.7875	12328.0
2018-04-30 06:00:00	AAPL	Stock	40.815	40.815	40.8	40.8	2000.0
2018-04-30 07:00:00	AAPL	Stock	40.76	40.825	40.7	40.7375	137736.0
2018-04-30 08:00:00	AAPL	Stock	40.7875	40.8225	40.575	40.64	635488.0
2018-04-30 09:00:00	AAPL	Stock	40.625	41.76	40.46	41.5625	34706292.0
2018-04-30 10:00:00	AAPL	Stock	41.56	41.815	41.4725	41.55	25133612.0
2018-04-30 11:00:00	AAPL	Stock	41.5525	41.6025	41.2575	41.375	14218452.0
2018-04-30 12:00:00	AAPL	Stock	41.3825	41.415	41.1775	41.31	10808240.0
2018-04-30 13:00:00	AAPL	Stock	41.31	41.3775	41.1	41.3625	10092612.0
2018-04-30 14:00:00	AAPL	Stock	41.3598	41.3625	41.1125	41.1775	11321296.0
2018-04-30 15:00:00	AAPL	Stock	41.1752	41.4975	41.16	41.315	21907920.0
2018-04-30 16:00:00	AAPL	Stock	41.315	41.4	41.2175	41.315	13808148.0
2018-04-30 17:00:00	AAPL	Stock	41.3375	41.5125	41.315	41.4575	1396568.0
2018-04-30 18:00:00	AAPL	Stock	41.465	41.4725	41.4125	41.445	150820.0
2018-04-30 19:00:00	AAPL	Stock	41.4375	41.65	41.4375	41.5375	153736.0
2018-04-30 04:00:00	MSFT	Stock	96.6	96.75	96.6	96.75	1100.0
2018-04-30 05:00:00	MSFT	Stock	96.4	96.6	96.4	96.6	715.0
2018-04-30 06:00:00	MSFT	Stock	96.6	96.6	96.5	96.6	605.0
2018-04-30 07:00:00	MSFT	Stock	96.4	96.49	96.25	96.49	4441.0
2018-04-30 08:00:00	MSFT	Stock	96.4	96.5	96.18	96.21	46579.0
2018-04-30 09:00:00	MSFT	Stock	96.29	96.396	95.73	95.79	3201636.0
2018-04-30 10:00:00	MSFT	Stock	95.79	96.0	95.37	95.72	3899771.0
2018-04-30 11:00:00	MSFT	Stock	95.73	95.87	93.735	93.91	4851594.0
2018-04-30 12:00:00	MSFT	Stock	93.9	94.02	93.15	93.746	4785631.0
2018-04-30 13:00:00	MSFT	Stock	93.74	94.36	93.59	94.32	2663290.0
2018-04-30 14:00:00	MSFT	Stock	94.316	94.316	93.765	93.835	2391135.0
2018-04-30 15:00:00	MSFT	Stock	93.83	94.29	93.48	93.52	5854936.0
2018-04-30 16:00:00	MSFT	Stock	93.52	93.76	93.5	93.52	6756423.0
2018-04-30 17:00:00	MSFT	Stock	93.5	93.63	93.5	93.63	301223.0
2018-04-30 18:00:00	MSFT	Stock	93.61	93.62	93.41	93.48	6495.0
2018-04-30 19:00:00	MSFT	Stock	93.46	93.62	93.46	93.62	3930.0
2018-04-30 04:00:00	NVDA	Stock	5.6625	5.7	5.6625	5.7	16000.0
2018-04-30 07:00:00	NVDA	Stock	5.6875	5.7	5.6838	5.6935	195720.0
2018-04-30 08:00:00	NVDA	Stock	5.6885	5.7153	5.678	5.6983	925560.0
2018-04-30 09:00:00	NVDA	Stock	5.6935	5.6938	5.6155	5.6675	31580800.0
2018-04-30 10:00:00	NVDA	Stock	5.6668	5.725	5.6537	5.6951	40486360.0
2018-04-30 11:00:00	NVDA	Stock	5.6962	5.7078	5.6238	5.6375	29500360.0
2018-04-30 12:00:00	NVDA	Stock	5.6375	5.656	5.603	5.6375	30200280.0
2018-04-30 13:00:00	NVDA	Stock	5.639	5.656	5.6175	5.6468	18763400.0
2018-04-30 14:00:00	NVDA	Stock	5.647	5.647	5.6049	5.6092	25849680.0
2018-04-30 15:00:00	NVDA	Stock	5.6085	5.6442	5.6068	5.6242	36360920.0
2018-04-30 16:00:00	NVDA	Stock	5.6225	5.625	5.6206	5.6212	32755040.0
2018-04-30 17:00:00	NVDA	Stock	5.6208	5.6275	5.62	5.625	201440.0
2018-04-30 18:00:00	NVDA	Stock	5.625	5.6255	5.613	5.6138	113920.0
2018-04-30 19:00:00	NVDA	Stock	5.6138	5.6255	5.613	5.6255	64000.0
2018-04-30 04:00:00	AMZN	Stock	79.2505	79.375	79.2135	79.215	55400.0
2018-04-30 05:00:00	AMZN	Stock	79.2445	79.45	79.2445	79.45	12280.0
2018-04-30 06:00:00	AMZN	Stock	79.405	79.453	79.375	79.4075	67660.0
2018-04-30 07:00:00	AMZN	Stock	79.413	79.413	79.05	79.055	515720.0

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

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