PREVIEW / stock_1hour / 2019-02-07

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-02-07.parquet
  size:    1.1 MB
  rows:    49,125
  symbols: 2,645

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-02-07 04:00:00	AAPL	Stock	43.4025	43.4025	43.4025	43.4025	400.0
2019-02-07 05:00:00	AAPL	Stock	43.4225	43.445	43.265	43.265	11952.0
2019-02-07 06:00:00	AAPL	Stock	43.305	43.3275	43.2175	43.24	33384.0
2019-02-07 07:00:00	AAPL	Stock	43.275	43.345	43.0725	43.1	304920.0
2019-02-07 08:00:00	AAPL	Stock	43.3	43.6675	43.0	43.0875	557592.0
2019-02-07 09:00:00	AAPL	Stock	43.1	43.2975	42.95	43.28	14543560.0
2019-02-07 10:00:00	AAPL	Stock	43.28	43.485	43.13	43.135	16227432.0
2019-02-07 11:00:00	AAPL	Stock	43.1375	43.2028	42.77	42.8032	18135912.0
2019-02-07 12:00:00	AAPL	Stock	42.8	42.9475	42.585	42.68	13836012.0
2019-02-07 13:00:00	AAPL	Stock	42.675	42.8375	42.645	42.7925	9949100.0
2019-02-07 14:00:00	AAPL	Stock	42.7875	42.845	42.6725	42.745	7769216.0
2019-02-07 15:00:00	AAPL	Stock	42.7435	42.7925	42.6175	42.7475	18095380.0
2019-02-07 16:00:00	AAPL	Stock	42.7475	43.2875	42.735	42.7675	8465776.0
2019-02-07 17:00:00	AAPL	Stock	42.7525	42.77	42.72	42.7475	93320.0
2019-02-07 18:00:00	AAPL	Stock	42.7475	42.7475	42.65	42.65	92676.0
2019-02-07 19:00:00	AAPL	Stock	42.6825	42.6825	42.6425	42.6725	103840.0
2019-02-07 05:00:00	MSFT	Stock	105.72	105.72	105.34	105.44	631.0
2019-02-07 06:00:00	MSFT	Stock	105.4	105.4	105.19	105.19	1657.0
2019-02-07 07:00:00	MSFT	Stock	105.19	105.4	105.19	105.3	25877.0
2019-02-07 08:00:00	MSFT	Stock	105.24	106.29	105.11	105.34	32076.0
2019-02-07 09:00:00	MSFT	Stock	105.25	105.4	104.95	105.29	2399363.0
2019-02-07 10:00:00	MSFT	Stock	105.29	105.59	104.92	105.015	3143118.0
2019-02-07 11:00:00	MSFT	Stock	105.02	105.16	104.64	104.64	4404388.0
2019-02-07 12:00:00	MSFT	Stock	104.645	104.92	104.29	104.4	2344861.0
2019-02-07 13:00:00	MSFT	Stock	104.39	105.0	104.37	104.83	1881050.0
2019-02-07 14:00:00	MSFT	Stock	104.82	105.14	104.57	104.99	1939817.0
2019-02-07 15:00:00	MSFT	Stock	105.0	105.41	104.87	105.32	3727162.0
2019-02-07 16:00:00	MSFT	Stock	105.27	105.48	105.27	105.28	6038996.0
2019-02-07 17:00:00	MSFT	Stock	105.28	105.35	105.2	105.26	5575.0
2019-02-07 18:00:00	MSFT	Stock	105.26	105.26	105.0	105.0	5423.0
2019-02-07 19:00:00	MSFT	Stock	105.15	105.2	104.89	105.01	7393.0
2019-02-07 04:00:00	NVDA	Stock	3.8248	3.8248	3.8248	3.8248	12000.0
2019-02-07 05:00:00	NVDA	Stock	3.8192	3.8192	3.79	3.79	60720.0
2019-02-07 06:00:00	NVDA	Stock	3.7812	3.7988	3.7812	3.7988	15680.0
2019-02-07 07:00:00	NVDA	Stock	3.7828	3.7948	3.775	3.775	587480.0
2019-02-07 08:00:00	NVDA	Stock	3.7862	3.8345	3.765	3.7775	2021080.0
2019-02-07 09:00:00	NVDA	Stock	3.7778	3.7912	3.692	3.7091	98299120.0
2019-02-07 10:00:00	NVDA	Stock	3.709	3.7591	3.6875	3.6981	121308000.0
2019-02-07 11:00:00	NVDA	Stock	3.6981	3.7185	3.6615	3.6618	90235680.0
2019-02-07 12:00:00	NVDA	Stock	3.6625	3.6742	3.6422	3.6682	63961480.0
2019-02-07 13:00:00	NVDA	Stock	3.6668	3.6935	3.6668	3.6782	49260280.0
2019-02-07 14:00:00	NVDA	Stock	3.6778	3.6812	3.6545	3.663	49478520.0
2019-02-07 15:00:00	NVDA	Stock	3.6636	3.6855	3.6488	3.6855	75065080.0
2019-02-07 16:00:00	NVDA	Stock	3.6855	3.694	3.6775	3.6815	34517640.0
2019-02-07 17:00:00	NVDA	Stock	3.685	3.6862	3.6805	3.6862	316960.0
2019-02-07 18:00:00	NVDA	Stock	3.685	3.685	3.6578	3.6658	385720.0
2019-02-07 19:00:00	NVDA	Stock	3.6662	3.6722	3.6578	3.6625	358720.0
2019-02-07 05:00:00	AMZN	Stock	81.7645	81.7645	81.292	81.292	33000.0
2019-02-07 06:00:00	AMZN	Stock	81.1375	81.1375	81.0895	81.0895	8220.0
2019-02-07 07:00:00	AMZN	Stock	81.3	81.495	81.3	81.4	106440.0

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

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