PREVIEW / stock_1hour / 2018-10-08

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-10-08.parquet
  size:    1.1 MB
  rows:    49,415
  symbols: 2,761

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-10-08 04:00:00	AAPL	Stock	55.9975	55.9975	55.72	55.72	5176.0
2018-10-08 05:00:00	AAPL	Stock	55.75	55.94	55.75	55.9375	21060.0
2018-10-08 06:00:00	AAPL	Stock	55.97	56.0	55.8675	55.9475	32780.0
2018-10-08 07:00:00	AAPL	Stock	55.945	56.1875	55.8275	56.09	338736.0
2018-10-08 08:00:00	AAPL	Stock	55.9462	56.1425	55.8275	55.9375	314640.0
2018-10-08 09:00:00	AAPL	Stock	55.9625	55.9625	55.255	55.71	16632160.0
2018-10-08 10:00:00	AAPL	Stock	55.715	56.075	55.6175	55.78	13338272.0
2018-10-08 11:00:00	AAPL	Stock	55.78	55.8025	55.05	55.39	14130796.0
2018-10-08 12:00:00	AAPL	Stock	55.385	55.5925	55.1375	55.2425	9032936.0
2018-10-08 13:00:00	AAPL	Stock	55.235	55.82	55.235	55.6225	8315684.0
2018-10-08 14:00:00	AAPL	Stock	55.62	55.9375	55.6	55.8525	8331332.0
2018-10-08 15:00:00	AAPL	Stock	55.8488	56.2	55.8325	55.94	15152892.0
2018-10-08 16:00:00	AAPL	Stock	55.9425	56.0125	55.94	55.985	10314884.0
2018-10-08 17:00:00	AAPL	Stock	55.98	56.01	55.95	55.95	40892.0
2018-10-08 18:00:00	AAPL	Stock	55.9675	56.0	55.9675	55.97	25244.0
2018-10-08 19:00:00	AAPL	Stock	55.97	55.975	55.95	55.96	37940.0
2018-10-08 05:00:00	MSFT	Stock	111.77	111.95	111.77	111.91	2045.0
2018-10-08 06:00:00	MSFT	Stock	111.97	111.97	111.97	111.97	200.0
2018-10-08 07:00:00	MSFT	Stock	111.98	112.29	111.84	112.27	10368.0
2018-10-08 08:00:00	MSFT	Stock	111.81	112.35	111.81	111.99	24990.0
2018-10-08 09:00:00	MSFT	Stock	111.86	112.03	111.35	111.92	2907225.0
2018-10-08 10:00:00	MSFT	Stock	111.93	112.0	111.15	111.5	2629222.0
2018-10-08 11:00:00	MSFT	Stock	111.5	111.505	109.34	110.44	5217019.0
2018-10-08 12:00:00	MSFT	Stock	110.44	110.45	109.51	109.57	2589314.0
2018-10-08 13:00:00	MSFT	Stock	109.57	110.73	109.52	110.398	2501407.0
2018-10-08 14:00:00	MSFT	Stock	110.4	111.26	110.39	110.91	2710608.0
2018-10-08 15:00:00	MSFT	Stock	110.91	111.28	110.835	110.86	4227373.0
2018-10-08 16:00:00	MSFT	Stock	110.85	111.133	110.8	111.0	3799907.0
2018-10-08 17:00:00	MSFT	Stock	111.07	111.07	110.99	111.048	2591.0
2018-10-08 18:00:00	MSFT	Stock	110.98	111.04	110.97	110.98	1862.0
2018-10-08 19:00:00	MSFT	Stock	110.97	111.04	110.95	110.95	4878.0
2018-10-08 04:00:00	NVDA	Stock	6.7285	6.7335	6.725	6.7252	48000.0
2018-10-08 06:00:00	NVDA	Stock	6.7235	6.7235	6.722	6.722	24000.0
2018-10-08 07:00:00	NVDA	Stock	6.725	6.735	6.7125	6.7325	225080.0
2018-10-08 08:00:00	NVDA	Stock	6.735	6.7493	6.675	6.675	534680.0
2018-10-08 09:00:00	NVDA	Stock	6.6792	6.7498	6.6152	6.7308	53263200.0
2018-10-08 10:00:00	NVDA	Stock	6.731	6.779	6.6585	6.673	55062680.0
2018-10-08 11:00:00	NVDA	Stock	6.67	6.671	6.5108	6.5671	74217960.0
2018-10-08 12:00:00	NVDA	Stock	6.5645	6.5795	6.502	6.5162	49140760.0
2018-10-08 13:00:00	NVDA	Stock	6.5135	6.6075	6.5125	6.5728	42564200.0
2018-10-08 14:00:00	NVDA	Stock	6.573	6.6478	6.573	6.6342	39851040.0
2018-10-08 15:00:00	NVDA	Stock	6.636	6.6652	6.6335	6.6438	53362720.0
2018-10-08 16:00:00	NVDA	Stock	6.6442	6.662	6.6017	6.65	4191640.0
2018-10-08 17:00:00	NVDA	Stock	6.65	6.6584	6.65	6.6562	79880.0
2018-10-08 18:00:00	NVDA	Stock	6.6588	6.6625	6.655	6.6552	127200.0
2018-10-08 19:00:00	NVDA	Stock	6.66	6.6622	6.6532	6.6562	99720.0
2018-10-08 04:00:00	AMZN	Stock	93.8	93.85	93.5	93.5	17960.0
2018-10-08 05:00:00	AMZN	Stock	93.584	93.75	93.584	93.75	17180.0
2018-10-08 06:00:00	AMZN	Stock	93.7495	93.8	93.7495	93.75	17460.0
2018-10-08 07:00:00	AMZN	Stock	93.7	94.1435	93.6665	94.1375	188760.0

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

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