PREVIEW / stock_1hour / 2019-01-02

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-01-02.parquet
  size:    1.1 MB
  rows:    50,930
  symbols: 2,701

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
2019-01-02 04:00:00	AAPL	Stock	38.6	38.675	38.2525	38.675	82848.0
2019-01-02 05:00:00	AAPL	Stock	38.625	38.675	38.5875	38.615	28964.0
2019-01-02 06:00:00	AAPL	Stock	38.645	38.6625	38.525	38.615	64488.0
2019-01-02 07:00:00	AAPL	Stock	38.625	38.8375	38.625	38.625	277004.0
2019-01-02 08:00:00	AAPL	Stock	38.75	39.435	38.6	38.625	421816.0
2019-01-02 09:00:00	AAPL	Stock	38.645	38.8875	38.5575	38.7975	16251020.0
2019-01-02 10:00:00	AAPL	Stock	38.7925	39.3	38.6425	39.22	20953888.0
2019-01-02 11:00:00	AAPL	Stock	39.22	39.6075	39.1825	39.2575	17023820.0
2019-01-02 12:00:00	AAPL	Stock	39.2662	39.5975	39.23	39.5425	10016684.0
2019-01-02 13:00:00	AAPL	Stock	39.5425	39.7125	39.5375	39.685	10036680.0
2019-01-02 14:00:00	AAPL	Stock	39.6825	39.6825	39.44	39.4802	8751152.0
2019-01-02 15:00:00	AAPL	Stock	39.4775	39.5075	39.1825	39.48	18198632.0
2019-01-02 16:00:00	AAPL	Stock	39.48	39.4925	36.1275	36.5275	20174892.0
2019-01-02 17:00:00	AAPL	Stock	36.5275	36.925	36.4575	36.535	8113000.0
2019-01-02 18:00:00	AAPL	Stock	36.535	36.67	36.475	36.525	1535168.0
2019-01-02 19:00:00	AAPL	Stock	36.525	36.6175	36.48	36.5	879588.0
2019-01-02 04:00:00	MSFT	Stock	99.4	99.4	98.88	99.2	3303.0
2019-01-02 05:00:00	MSFT	Stock	99.49	99.9	99.4	99.4	4914.0
2019-01-02 06:00:00	MSFT	Stock	99.41	99.5	99.04	99.12	17092.0
2019-01-02 07:00:00	MSFT	Stock	99.38	99.65	99.01	99.26	108658.0
2019-01-02 08:00:00	MSFT	Stock	99.43	101.57	99.0	99.34	104751.0
2019-01-02 09:00:00	MSFT	Stock	99.28	99.88	98.94	99.55	3909812.0
2019-01-02 10:00:00	MSFT	Stock	99.55	100.89	99.22	100.72	4824171.0
2019-01-02 11:00:00	MSFT	Stock	100.72	101.35	100.44	100.475	4040593.0
2019-01-02 12:00:00	MSFT	Stock	100.47	101.438	100.35	101.33	2517883.0
2019-01-02 13:00:00	MSFT	Stock	101.32	101.75	101.23	101.72	2362722.0
2019-01-02 14:00:00	MSFT	Stock	101.72	101.72	101.01	101.033	2392507.0
2019-01-02 15:00:00	MSFT	Stock	101.03	101.34	100.3	101.12	4787535.0
2019-01-02 16:00:00	MSFT	Stock	101.13	101.22	99.3	99.98	5088123.0
2019-01-02 17:00:00	MSFT	Stock	99.86	101.12	98.57	98.66	110083.0
2019-01-02 18:00:00	MSFT	Stock	98.66	99.2	98.63	98.79	73446.0
2019-01-02 19:00:00	MSFT	Stock	98.8	99.2	98.79	99.0	19104.0
2019-01-02 04:00:00	NVDA	Stock	3.25	3.2588	3.2312	3.2588	109040.0
2019-01-02 05:00:00	NVDA	Stock	3.253	3.275	3.253	3.275	101320.0
2019-01-02 06:00:00	NVDA	Stock	3.2565	3.2748	3.233	3.2548	174360.0
2019-01-02 07:00:00	NVDA	Stock	3.2502	3.275	3.2492	3.25	1364720.0
2019-01-02 08:00:00	NVDA	Stock	3.2626	3.3375	3.2428	3.2553	2200480.0
2019-01-02 09:00:00	NVDA	Stock	3.2598	3.3195	3.2513	3.3078	58209520.0
2019-01-02 10:00:00	NVDA	Stock	3.308	3.4218	3.2818	3.4098	95896800.0
2019-01-02 11:00:00	NVDA	Stock	3.411	3.4373	3.4038	3.4062	58651120.0
2019-01-02 12:00:00	NVDA	Stock	3.4056	3.4422	3.3938	3.4358	42299000.0
2019-01-02 13:00:00	NVDA	Stock	3.436	3.4542	3.424	3.4481	47690880.0
2019-01-02 14:00:00	NVDA	Stock	3.4484	3.462	3.4195	3.4237	44963360.0
2019-01-02 15:00:00	NVDA	Stock	3.4225	3.4333	3.3882	3.4055	76944200.0
2019-01-02 16:00:00	NVDA	Stock	3.4055	3.4138	3.3312	3.3312	29634120.0
2019-01-02 17:00:00	NVDA	Stock	3.3312	3.3325	3.283	3.284	6557240.0
2019-01-02 18:00:00	NVDA	Stock	3.2892	3.29	3.2575	3.275	2421800.0
2019-01-02 19:00:00	NVDA	Stock	3.275	3.2812	3.2708	3.275	813600.0
2019-01-02 04:00:00	AMZN	Stock	73.6505	73.6505	73.071	73.275	61340.0
2019-01-02 05:00:00	AMZN	Stock	73.6075	73.66	73.51	73.51	54860.0

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

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