PREVIEW / stock_1hour / 2018-11-12

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-11-12.parquet
  size:    1.1 MB
  rows:    49,307
  symbols: 2,738

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-12 04:00:00	AAPL	Stock	50.975	51.085	50.975	51.0	4836.0
2018-11-12 05:00:00	AAPL	Stock	50.995	51.0575	50.9275	51.0575	18920.0
2018-11-12 06:00:00	AAPL	Stock	50.9625	50.9975	50.8275	50.875	13948.0
2018-11-12 07:00:00	AAPL	Stock	50.89	50.89	50.6775	50.6775	255984.0
2018-11-12 08:00:00	AAPL	Stock	50.7005	50.8675	49.7	49.8575	2400640.0
2018-11-12 09:00:00	AAPL	Stock	49.8675	49.9825	49.03	49.1925	31395284.0
2018-11-12 10:00:00	AAPL	Stock	49.185	49.22	48.58	48.6748	34397816.0
2018-11-12 11:00:00	AAPL	Stock	48.6775	48.8975	48.4475	48.8525	28637604.0
2018-11-12 12:00:00	AAPL	Stock	48.8562	49.1	48.8425	48.935	14634412.0
2018-11-12 13:00:00	AAPL	Stock	48.9375	49.058	48.7875	48.94	11099444.0
2018-11-12 14:00:00	AAPL	Stock	48.93	49.1675	48.823	48.9355	12513592.0
2018-11-12 15:00:00	AAPL	Stock	48.9375	48.94	48.4725	48.55	30708884.0
2018-11-12 16:00:00	AAPL	Stock	48.5425	48.5875	48.25	48.375	10100188.0
2018-11-12 17:00:00	AAPL	Stock	48.3875	48.5428	48.3625	48.3775	204832.0
2018-11-12 18:00:00	AAPL	Stock	48.3775	48.4	48.25	48.3	203036.0
2018-11-12 19:00:00	AAPL	Stock	48.3025	48.325	48.175	48.2	179308.0
2018-11-12 05:00:00	MSFT	Stock	109.57	109.57	109.57	109.57	100.0
2018-11-12 06:00:00	MSFT	Stock	109.5	109.5	109.5	109.5	100.0
2018-11-12 07:00:00	MSFT	Stock	109.5	109.5	109.3	109.35	8196.0
2018-11-12 08:00:00	MSFT	Stock	109.2	109.4	108.71	109.0	26185.0
2018-11-12 09:00:00	MSFT	Stock	109.17	109.96	108.31	108.49	2505400.0
2018-11-12 10:00:00	MSFT	Stock	108.495	108.505	107.13	107.28	4301787.0
2018-11-12 11:00:00	MSFT	Stock	107.29	107.31	106.1	107.015	4276268.0
2018-11-12 12:00:00	MSFT	Stock	107.02	107.5	106.865	106.94	2826423.0
2018-11-12 13:00:00	MSFT	Stock	106.94	107.08	106.27	106.76	2890147.0
2018-11-12 14:00:00	MSFT	Stock	106.73	107.75	106.615	107.11	3529754.0
2018-11-12 15:00:00	MSFT	Stock	107.11	107.49	106.67	106.92	6116335.0
2018-11-12 16:00:00	MSFT	Stock	106.87	107.07	106.7	106.77	4507206.0
2018-11-12 17:00:00	MSFT	Stock	106.8	106.88	106.8	106.86	18189.0
2018-11-12 18:00:00	MSFT	Stock	106.87	107.07	106.87	106.9	8197.0
2018-11-12 19:00:00	MSFT	Stock	106.92	107.04	106.35	106.48	13467.0
2018-11-12 04:00:00	NVDA	Stock	5.138	5.1588	5.113	5.1498	69840.0
2018-11-12 05:00:00	NVDA	Stock	5.1475	5.1748	5.1475	5.1748	51200.0
2018-11-12 06:00:00	NVDA	Stock	5.1315	5.1315	5.1238	5.1238	38440.0
2018-11-12 07:00:00	NVDA	Stock	5.1032	5.1125	5.051	5.051	1066600.0
2018-11-12 08:00:00	NVDA	Stock	5.1125	5.1195	5.0263	5.05	1962200.0
2018-11-12 09:00:00	NVDA	Stock	5.0525	5.0718	4.82	4.8596	90693640.0
2018-11-12 10:00:00	NVDA	Stock	4.859	4.875	4.7688	4.7765	111953920.0
2018-11-12 11:00:00	NVDA	Stock	4.7762	4.7978	4.7165	4.7938	102849200.0
2018-11-12 12:00:00	NVDA	Stock	4.7923	4.82	4.7752	4.787	48496600.0
2018-11-12 13:00:00	NVDA	Stock	4.7872	4.7902	4.7188	4.7542	52200320.0
2018-11-12 14:00:00	NVDA	Stock	4.7542	4.8098	4.7486	4.7696	39484440.0
2018-11-12 15:00:00	NVDA	Stock	4.7672	4.7875	4.7318	4.736	82154840.0
2018-11-12 16:00:00	NVDA	Stock	4.7385	4.7498	4.7276	4.744	2459080.0
2018-11-12 17:00:00	NVDA	Stock	4.7385	4.7525	4.7375	4.74	346040.0
2018-11-12 18:00:00	NVDA	Stock	4.7438	4.7732	4.74	4.7593	574560.0
2018-11-12 19:00:00	NVDA	Stock	4.755	4.775	4.75	4.7588	611320.0
2018-11-12 04:00:00	AMZN	Stock	86.022	86.022	85.7945	85.7945	20100.0
2018-11-12 05:00:00	AMZN	Stock	85.8875	85.9	85.8875	85.9	15940.0
2018-11-12 06:00:00	AMZN	Stock	85.672	85.672	85.5	85.5	6760.0

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

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