PREVIEW / stock_1hour / 2018-12-26

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-12-26.parquet
  size:    1.1 MB
  rows:    50,622
  symbols: 2,728

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-12-26 04:00:00	AAPL	Stock	36.65	36.775	36.605	36.775	32236.0
2018-12-26 05:00:00	AAPL	Stock	36.74	36.775	36.68	36.7075	18728.0
2018-12-26 06:00:00	AAPL	Stock	36.77	36.87	36.75	36.8	147140.0
2018-12-26 07:00:00	AAPL	Stock	36.7625	37.0675	36.7525	36.98	283112.0
2018-12-26 08:00:00	AAPL	Stock	36.8125	37.0625	36.75	37.035	577664.0
2018-12-26 09:00:00	AAPL	Stock	37.025	37.48	36.9625	37.0375	26127068.0
2018-12-26 10:00:00	AAPL	Stock	37.0375	37.1425	36.695	36.7225	30856844.0
2018-12-26 11:00:00	AAPL	Stock	36.73	37.7	36.68	37.685	26230068.0
2018-12-26 12:00:00	AAPL	Stock	37.6825	38.115	37.6275	38.0865	26078776.0
2018-12-26 13:00:00	AAPL	Stock	38.0875	38.295	37.67	38.2675	17239960.0
2018-12-26 14:00:00	AAPL	Stock	38.27	38.49	38.15	38.4765	18936216.0
2018-12-26 15:00:00	AAPL	Stock	38.4675	39.3075	38.3575	39.2925	35633524.0
2018-12-26 16:00:00	AAPL	Stock	39.2925	39.2925	39.0375	39.125	22556632.0
2018-12-26 17:00:00	AAPL	Stock	39.125	39.3125	39.0825	39.3125	253096.0
2018-12-26 18:00:00	AAPL	Stock	39.2925	39.325	39.2125	39.2775	1296924.0
2018-12-26 19:00:00	AAPL	Stock	39.2775	39.325	39.075	39.1	170656.0
2018-12-26 04:00:00	MSFT	Stock	93.8	93.8	93.8	93.8	752.0
2018-12-26 05:00:00	MSFT	Stock	94.36	94.68	93.91	94.39	3235.0
2018-12-26 06:00:00	MSFT	Stock	94.47	94.5	94.35	94.5	1777.0
2018-12-26 07:00:00	MSFT	Stock	94.5	95.15	94.45	95.0	31286.0
2018-12-26 08:00:00	MSFT	Stock	94.5	95.25	94.4	94.84	53286.0
2018-12-26 09:00:00	MSFT	Stock	94.9	97.206	93.96	95.656	5421979.0
2018-12-26 10:00:00	MSFT	Stock	95.66	95.84	94.67	94.825	5788116.0
2018-12-26 11:00:00	MSFT	Stock	94.83	97.13	94.76	97.1	5692266.0
2018-12-26 12:00:00	MSFT	Stock	97.09	98.16	96.96	98.0	5406159.0
2018-12-26 13:00:00	MSFT	Stock	98.0	98.6	97.065	98.58	4076249.0
2018-12-26 14:00:00	MSFT	Stock	98.59	98.665	97.84	98.527	4293654.0
2018-12-26 15:00:00	MSFT	Stock	98.52	100.69	98.28	100.69	9897966.0
2018-12-26 16:00:00	MSFT	Stock	100.56	100.56	100.23	100.4	6460129.0
2018-12-26 17:00:00	MSFT	Stock	100.4	100.7	100.4	100.64	27828.0
2018-12-26 18:00:00	MSFT	Stock	100.56	100.9	100.35	100.45	69038.0
2018-12-26 19:00:00	MSFT	Stock	100.45	100.65	99.72	100.1	31455.0
2018-12-26 05:00:00	NVDA	Stock	3.175	3.175	3.175	3.175	8440.0
2018-12-26 07:00:00	NVDA	Stock	3.185	3.2123	3.1813	3.2075	694680.0
2018-12-26 08:00:00	NVDA	Stock	3.1925	3.2238	3.177	3.2112	1534440.0
2018-12-26 09:00:00	NVDA	Stock	3.2125	3.2375	3.152	3.1573	73164720.0
2018-12-26 10:00:00	NVDA	Stock	3.155	3.1859	3.1115	3.1201	96200280.0
2018-12-26 11:00:00	NVDA	Stock	3.1194	3.1915	3.116	3.1903	66947120.0
2018-12-26 12:00:00	NVDA	Stock	3.1912	3.2487	3.1758	3.2441	82242120.0
2018-12-26 13:00:00	NVDA	Stock	3.2458	3.262	3.2175	3.2562	71388760.0
2018-12-26 14:00:00	NVDA	Stock	3.2575	3.2593	3.2275	3.2568	63303880.0
2018-12-26 15:00:00	NVDA	Stock	3.2558	3.3285	3.24	3.328	133787880.0
2018-12-26 16:00:00	NVDA	Stock	3.3275	3.3335	3.3153	3.3265	41059240.0
2018-12-26 17:00:00	NVDA	Stock	3.3205	3.3373	3.3188	3.3373	392480.0
2018-12-26 18:00:00	NVDA	Stock	3.3312	3.3348	3.3188	3.3188	328880.0
2018-12-26 19:00:00	NVDA	Stock	3.318	3.3188	3.3015	3.307	536080.0
2018-12-26 07:00:00	AMZN	Stock	67.425	68.5445	67.25	68.5445	200500.0
2018-12-26 08:00:00	AMZN	Stock	67.56	68.5755	67.425	68.325	666260.0
2018-12-26 09:00:00	AMZN	Stock	68.3245	70.5597	68.245	68.85	24606100.0
2018-12-26 10:00:00	AMZN	Stock	68.886	69.3	68.1505	68.3381	20424980.0

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

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