PREVIEW / stock_1hour / 2019-07-08

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-07-08.parquet
  size:    1.1 MB
  rows:    49,373
  symbols: 2,591

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-07-08 04:00:00	AAPL	Stock	50.8	50.835	50.6725	50.7025	12700.0
2019-07-08 05:00:00	AAPL	Stock	50.6575	50.6575	50.165	50.1775	53192.0
2019-07-08 06:00:00	AAPL	Stock	50.185	50.2425	50.125	50.175	47324.0
2019-07-08 07:00:00	AAPL	Stock	50.2	50.3525	50.1625	50.2775	201256.0
2019-07-08 08:00:00	AAPL	Stock	50.2507	50.375	50.165	50.275	584260.0
2019-07-08 09:00:00	AAPL	Stock	50.275	50.35	49.6025	49.7125	20709676.0
2019-07-08 10:00:00	AAPL	Stock	49.7138	49.9675	49.6825	49.8125	15215968.0
2019-07-08 11:00:00	AAPL	Stock	49.8125	50.045	49.805	49.9818	10206788.0
2019-07-08 12:00:00	AAPL	Stock	49.98	50.0225	49.9175	49.9975	5550676.0
2019-07-08 13:00:00	AAPL	Stock	49.9975	50.0225	49.885	49.91	4692616.0
2019-07-08 14:00:00	AAPL	Stock	49.9125	50.0075	49.825	49.9955	6592620.0
2019-07-08 15:00:00	AAPL	Stock	49.9975	50.0425	49.9325	50.0025	11547692.0
2019-07-08 16:00:00	AAPL	Stock	50.005	50.005	49.925	50.0	7304240.0
2019-07-08 17:00:00	AAPL	Stock	49.9925	50.0175	49.9575	50.0048	100052.0
2019-07-08 18:00:00	AAPL	Stock	49.9825	50.0375	49.9825	50.01	59412.0
2019-07-08 19:00:00	AAPL	Stock	50.0325	50.125	50.025	50.08	124868.0
2019-07-08 04:00:00	MSFT	Stock	136.88	136.88	136.58	136.65	1906.0
2019-07-08 05:00:00	MSFT	Stock	136.5	136.5	136.44	136.5	600.0
2019-07-08 06:00:00	MSFT	Stock	136.21	136.27	136.21	136.27	230.0
2019-07-08 07:00:00	MSFT	Stock	136.41	136.5	136.35	136.35	5349.0
2019-07-08 08:00:00	MSFT	Stock	136.4	137.4	136.26	136.43	15352.0
2019-07-08 09:00:00	MSFT	Stock	136.39	136.49	135.37	135.51	2197396.0
2019-07-08 10:00:00	MSFT	Stock	135.505	136.42	135.385	136.415	2851685.0
2019-07-08 11:00:00	MSFT	Stock	136.41	136.63	136.152	136.27	1445846.0
2019-07-08 12:00:00	MSFT	Stock	136.27	136.47	136.06	136.43	1016655.0
2019-07-08 13:00:00	MSFT	Stock	136.434	136.65	136.37	136.5	980814.0
2019-07-08 14:00:00	MSFT	Stock	136.5	136.96	136.44	136.865	1205479.0
2019-07-08 15:00:00	MSFT	Stock	136.865	137.1	136.79	136.97	2231951.0
2019-07-08 16:00:00	MSFT	Stock	136.96	137.01	136.872	136.9	2398513.0
2019-07-08 17:00:00	MSFT	Stock	136.86	136.936	136.82	136.936	4052.0
2019-07-08 19:00:00	MSFT	Stock	136.84	136.9	136.45	136.45	6859.0
2019-07-08 04:00:00	NVDA	Stock	3.9875	3.9875	3.9875	3.9875	8200.0
2019-07-08 05:00:00	NVDA	Stock	3.9635	3.9635	3.9625	3.9625	35000.0
2019-07-08 06:00:00	NVDA	Stock	3.9745	3.9788	3.9725	3.9725	60680.0
2019-07-08 07:00:00	NVDA	Stock	3.9725	3.9725	3.9438	3.9583	604440.0
2019-07-08 08:00:00	NVDA	Stock	3.9642	4.0158	3.938	3.9513	1673640.0
2019-07-08 09:00:00	NVDA	Stock	3.9513	3.9648	3.9	3.9238	80663080.0
2019-07-08 10:00:00	NVDA	Stock	3.9228	3.9478	3.9083	3.9135	62655960.0
2019-07-08 11:00:00	NVDA	Stock	3.913	3.9308	3.9098	3.9283	34733040.0
2019-07-08 12:00:00	NVDA	Stock	3.9285	3.9388	3.917	3.9375	25250200.0
2019-07-08 13:00:00	NVDA	Stock	3.9378	3.946	3.9225	3.9232	26258320.0
2019-07-08 14:00:00	NVDA	Stock	3.924	3.9335	3.9202	3.929	17496600.0
2019-07-08 15:00:00	NVDA	Stock	3.9284	3.9388	3.921	3.9315	43900960.0
2019-07-08 16:00:00	NVDA	Stock	3.9303	3.9303	3.9225	3.9225	12728280.0
2019-07-08 17:00:00	NVDA	Stock	3.9245	3.9245	3.919	3.9202	321320.0
2019-07-08 18:00:00	NVDA	Stock	3.9202	3.9222	3.9198	3.922	167960.0
2019-07-08 19:00:00	NVDA	Stock	3.922	3.926	3.9182	3.92	353520.0
2019-07-08 04:00:00	AMZN	Stock	96.75	96.75	96.75	96.75	6020.0
2019-07-08 05:00:00	AMZN	Stock	96.625	96.625	96.625	96.625	3760.0
2019-07-08 06:00:00	AMZN	Stock	96.545	96.545	96.545	96.545	2000.0

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

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