PREVIEW / stock_1hour / 2018-11-28

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-11-28.parquet
  size:    1.1 MB
  rows:    50,076
  symbols: 2,755

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-28 04:00:00	AAPL	Stock	43.9225	43.95	43.85	43.95	14368.0
2018-11-28 05:00:00	AAPL	Stock	43.9	43.975	43.8775	43.975	23460.0
2018-11-28 06:00:00	AAPL	Stock	43.9875	44.0375	43.9625	43.995	21856.0
2018-11-28 07:00:00	AAPL	Stock	44.03	44.1	43.9775	44.01	514292.0
2018-11-28 08:00:00	AAPL	Stock	44.1	44.15	43.98	44.085	703164.0
2018-11-28 09:00:00	AAPL	Stock	44.085	44.2225	43.87	44.0	19894408.0
2018-11-28 10:00:00	AAPL	Stock	44.01	44.135	43.7325	43.9725	20684860.0
2018-11-28 11:00:00	AAPL	Stock	43.9675	44.11	43.8025	44.025	15376532.0
2018-11-28 12:00:00	AAPL	Stock	44.0275	44.92	44.0275	44.6325	33580704.0
2018-11-28 13:00:00	AAPL	Stock	44.6375	45.0275	44.55	44.9162	17829248.0
2018-11-28 14:00:00	AAPL	Stock	44.915	45.005	44.735	44.86	13039436.0
2018-11-28 15:00:00	AAPL	Stock	44.8575	45.3225	44.69	45.2425	27865688.0
2018-11-28 16:00:00	AAPL	Stock	45.24	45.375	45.2325	45.3725	12901568.0
2018-11-28 17:00:00	AAPL	Stock	45.37	45.55	45.35	45.47	397184.0
2018-11-28 18:00:00	AAPL	Stock	45.4375	45.4875	45.3825	45.4875	137780.0
2018-11-28 19:00:00	AAPL	Stock	45.4875	45.5	45.3875	45.465	115156.0
2018-11-28 04:00:00	MSFT	Stock	107.1	107.75	107.1	107.75	5361.0
2018-11-28 05:00:00	MSFT	Stock	107.9	107.9	107.9	107.9	977.0
2018-11-28 06:00:00	MSFT	Stock	107.94	108.0	107.8	108.0	4772.0
2018-11-28 07:00:00	MSFT	Stock	108.0	108.1	107.85	108.01	24904.0
2018-11-28 08:00:00	MSFT	Stock	108.01	108.35	107.9	108.12	79224.0
2018-11-28 09:00:00	MSFT	Stock	108.11	108.72	107.72	108.215	4869149.0
2018-11-28 10:00:00	MSFT	Stock	108.21	108.918	108.07	108.265	4308158.0
2018-11-28 11:00:00	MSFT	Stock	108.26	109.03	108.06	108.89	2946120.0
2018-11-28 12:00:00	MSFT	Stock	108.89	111.0	108.88	110.455	8315150.0
2018-11-28 13:00:00	MSFT	Stock	110.46	111.08	109.96	110.64	5284222.0
2018-11-28 14:00:00	MSFT	Stock	110.65	110.87	109.973	110.075	5123049.0
2018-11-28 15:00:00	MSFT	Stock	110.07	111.33	109.8	111.11	6684099.0
2018-11-28 16:00:00	MSFT	Stock	111.12	111.12	110.86	110.97	4658491.0
2018-11-28 17:00:00	MSFT	Stock	111.0	111.0	110.88	110.9	15178.0
2018-11-28 18:00:00	MSFT	Stock	110.92	110.99	110.89	110.9	11924.0
2018-11-28 19:00:00	MSFT	Stock	110.95	110.95	110.71	110.71	15169.0
2018-11-28 04:00:00	NVDA	Stock	3.9172	3.9175	3.9	3.9	43120.0
2018-11-28 05:00:00	NVDA	Stock	3.9	3.9225	3.9	3.9198	60680.0
2018-11-28 06:00:00	NVDA	Stock	3.9038	3.9235	3.8938	3.9222	214120.0
2018-11-28 07:00:00	NVDA	Stock	3.9182	3.94	3.9	3.933	2486920.0
2018-11-28 08:00:00	NVDA	Stock	3.9125	3.9595	3.9	3.9562	4885640.0
2018-11-28 09:00:00	NVDA	Stock	3.9525	3.982	3.8858	3.889	130666160.0
2018-11-28 10:00:00	NVDA	Stock	3.8928	3.9125	3.8443	3.849	100213080.0
2018-11-28 11:00:00	NVDA	Stock	3.848	3.8722	3.8281	3.8505	58465160.0
2018-11-28 12:00:00	NVDA	Stock	3.852	3.9688	3.85	3.8894	150518920.0
2018-11-28 13:00:00	NVDA	Stock	3.8895	3.9638	3.8758	3.956	82832440.0
2018-11-28 14:00:00	NVDA	Stock	3.9559	3.9685	3.9163	3.939	77373120.0
2018-11-28 15:00:00	NVDA	Stock	3.9385	4.007	3.9275	4.002	124948720.0
2018-11-28 16:00:00	NVDA	Stock	4.0018	4.0018	3.9925	3.9938	26181120.0
2018-11-28 17:00:00	NVDA	Stock	3.9945	4.016	3.9945	4.0038	3323800.0
2018-11-28 18:00:00	NVDA	Stock	4.0025	4.0088	3.995	3.9965	842040.0
2018-11-28 19:00:00	NVDA	Stock	3.997	3.9988	3.9913	3.995	449640.0
2018-11-28 04:00:00	AMZN	Stock	79.8	79.8	79.8	79.8	2880.0
2018-11-28 05:00:00	AMZN	Stock	79.8	79.8985	79.8	79.8985	14000.0

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

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