PREVIEW / stock_1hour / 2018-04-27

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-04-27.parquet
  size:    1.1 MB
  rows:    48,194
  symbols: 2,848

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-27 05:00:00	AAPL	Stock	41.2	41.205	41.175	41.205	14044.0
2018-04-27 06:00:00	AAPL	Stock	41.2	41.2425	41.2	41.225	5628.0
2018-04-27 07:00:00	AAPL	Stock	41.225	41.225	41.175	41.2175	56200.0
2018-04-27 08:00:00	AAPL	Stock	41.205	41.29	41.1525	41.235	276716.0
2018-04-27 09:00:00	AAPL	Stock	41.2325	41.2375	40.485	40.51	24668556.0
2018-04-27 10:00:00	AAPL	Stock	40.505	40.545	40.1575	40.4275	32754320.0
2018-04-27 11:00:00	AAPL	Stock	40.4238	40.6475	40.3825	40.4225	15889840.0
2018-04-27 12:00:00	AAPL	Stock	40.4225	40.58	40.36	40.5775	10347392.0
2018-04-27 13:00:00	AAPL	Stock	40.58	40.7025	40.525	40.5513	7747724.0
2018-04-27 14:00:00	AAPL	Stock	40.5525	40.8025	40.5325	40.7125	9717376.0
2018-04-27 15:00:00	AAPL	Stock	40.7125	40.7975	40.5625	40.5825	19671544.0
2018-04-27 16:00:00	AAPL	Stock	40.58	40.62	40.5075	40.6	7989404.0
2018-04-27 17:00:00	AAPL	Stock	40.6225	40.625	40.555	40.605	28116.0
2018-04-27 18:00:00	AAPL	Stock	40.6125	40.625	40.5525	40.575	78132.0
2018-04-27 19:00:00	AAPL	Stock	40.575	40.575	40.535	40.5425	49832.0
2018-04-27 04:00:00	MSFT	Stock	96.03	96.99	96.03	96.99	12232.0
2018-04-27 05:00:00	MSFT	Stock	97.05	97.7	97.05	97.6	12707.0
2018-04-27 06:00:00	MSFT	Stock	97.61	97.61	97.25	97.54	2238.0
2018-04-27 07:00:00	MSFT	Stock	97.35	98.3	97.0	97.6	145743.0
2018-04-27 08:00:00	MSFT	Stock	97.7	98.4	97.2	97.5	405568.0
2018-04-27 09:00:00	MSFT	Stock	97.5	98.0	95.01	95.165	12332573.0
2018-04-27 10:00:00	MSFT	Stock	95.18	95.85	93.91	94.22	9124271.0
2018-04-27 11:00:00	MSFT	Stock	94.21	95.63	94.16	95.0	5350546.0
2018-04-27 12:00:00	MSFT	Stock	95.0	95.615	94.85	95.34	3128576.0
2018-04-27 13:00:00	MSFT	Stock	95.34	95.53	95.1	95.15	2026912.0
2018-04-27 14:00:00	MSFT	Stock	95.155	95.8	95.11	95.64	3028334.0
2018-04-27 15:00:00	MSFT	Stock	95.64	96.05	95.35	95.82	5727010.0
2018-04-27 16:00:00	MSFT	Stock	95.82	95.93	95.678	95.8	2867301.0
2018-04-27 17:00:00	MSFT	Stock	95.9	95.9	95.67	95.72	7982.0
2018-04-27 18:00:00	MSFT	Stock	95.72	95.81	95.72	95.81	3346.0
2018-04-27 19:00:00	MSFT	Stock	95.82	95.86	95.72	95.85	3574.0
2018-04-27 04:00:00	NVDA	Stock	5.7	5.7	5.7	5.7	92600.0
2018-04-27 05:00:00	NVDA	Stock	5.7	5.7	5.6975	5.6975	48000.0
2018-04-27 06:00:00	NVDA	Stock	5.7	5.7	5.695	5.6975	36000.0
2018-04-27 07:00:00	NVDA	Stock	5.706	5.7155	5.703	5.7155	264440.0
2018-04-27 08:00:00	NVDA	Stock	5.7153	5.748	5.7053	5.748	1907800.0
2018-04-27 09:00:00	NVDA	Stock	5.75	5.7595	5.6608	5.6743	79132520.0
2018-04-27 10:00:00	NVDA	Stock	5.6722	5.7218	5.6155	5.645	68726840.0
2018-04-27 11:00:00	NVDA	Stock	5.645	5.7015	5.641	5.6685	35556720.0
2018-04-27 12:00:00	NVDA	Stock	5.6708	5.6975	5.6335	5.6665	32192920.0
2018-04-27 13:00:00	NVDA	Stock	5.667	5.685	5.6412	5.6478	20704480.0
2018-04-27 14:00:00	NVDA	Stock	5.6478	5.685	5.637	5.6672	23510840.0
2018-04-27 15:00:00	NVDA	Stock	5.666	5.6755	5.645	5.6585	43319840.0
2018-04-27 16:00:00	NVDA	Stock	5.6583	5.6675	5.6583	5.665	13427240.0
2018-04-27 17:00:00	NVDA	Stock	5.6675	5.6675	5.6518	5.6625	162520.0
2018-04-27 18:00:00	NVDA	Stock	5.667	5.667	5.6625	5.6625	58520.0
2018-04-27 19:00:00	NVDA	Stock	5.667	5.667	5.6625	5.6663	156160.0
2018-04-27 04:00:00	AMZN	Stock	80.3605	81.2	80.3605	81.2	200760.0
2018-04-27 05:00:00	AMZN	Stock	81.217	81.375	81.217	81.25	63160.0
2018-04-27 06:00:00	AMZN	Stock	81.2605	81.5475	81.2605	81.3	201580.0

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

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