PREVIEW / stock_1hour / 2020-02-13

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-02-13.parquet
  size:    1.2 MB
  rows:    50,929
  symbols: 2,412

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
2020-02-13 04:00:00	AAPL	Stock	81.04	81.1	80.6	80.72	70912.0
2020-02-13 05:00:00	AAPL	Stock	80.65	80.725	80.36	80.6	41908.0
2020-02-13 06:00:00	AAPL	Stock	80.6	81.0	80.5	80.775	88868.0
2020-02-13 07:00:00	AAPL	Stock	80.785	80.9925	80.59	80.825	676800.0
2020-02-13 08:00:00	AAPL	Stock	80.825	81.0875	80.6	80.9675	1225336.0
2020-02-13 09:00:00	AAPL	Stock	80.9675	81.49	80.8375	81.157	16099032.0
2020-02-13 10:00:00	AAPL	Stock	81.1588	81.3725	80.885	81.3325	15573900.0
2020-02-13 11:00:00	AAPL	Stock	81.335	81.4325	81.1875	81.2475	8312404.0
2020-02-13 12:00:00	AAPL	Stock	81.245	81.555	81.0975	81.155	7901416.0
2020-02-13 13:00:00	AAPL	Stock	81.1625	81.52	81.1	81.4375	6772560.0
2020-02-13 14:00:00	AAPL	Stock	81.44	81.5525	81.2875	81.5075	5846472.0
2020-02-13 15:00:00	AAPL	Stock	81.5092	81.545	81.107	81.2275	9591888.0
2020-02-13 16:00:00	AAPL	Stock	81.2175	81.3875	81.2175	81.3525	6214096.0
2020-02-13 17:00:00	AAPL	Stock	81.3525	81.385	81.275	81.385	67476.0
2020-02-13 18:00:00	AAPL	Stock	81.385	81.385	81.175	81.1875	129456.0
2020-02-13 19:00:00	AAPL	Stock	81.2375	81.275	81.0825	81.225	94996.0
2020-02-13 04:00:00	MSFT	Stock	183.2	183.2	182.84	182.84	4948.0
2020-02-13 05:00:00	MSFT	Stock	182.63	182.86	182.21	182.73	6446.0
2020-02-13 06:00:00	MSFT	Stock	182.63	183.22	182.55	182.91	11282.0
2020-02-13 07:00:00	MSFT	Stock	183.0	183.15	182.23	182.75	76104.0
2020-02-13 08:00:00	MSFT	Stock	182.95	183.797	182.31	183.5	112936.0
2020-02-13 09:00:00	MSFT	Stock	183.45	185.17	182.872	184.47	3703944.0
2020-02-13 10:00:00	MSFT	Stock	184.48	185.58	183.8	185.53	3385746.0
2020-02-13 11:00:00	MSFT	Stock	185.52	186.23	185.1	185.325	3851225.0
2020-02-13 12:00:00	MSFT	Stock	185.32	185.6	184.33	184.36	2317206.0
2020-02-13 13:00:00	MSFT	Stock	184.37	185.75	184.25	185.43	2423095.0
2020-02-13 14:00:00	MSFT	Stock	185.41	185.685	182.92	184.3	8470908.0
2020-02-13 15:00:00	MSFT	Stock	184.31	184.49	183.5	183.76	3918523.0
2020-02-13 16:00:00	MSFT	Stock	183.71	184.446	183.51	183.85	2477510.0
2020-02-13 17:00:00	MSFT	Stock	183.92	183.98	183.75	183.8	13181.0
2020-02-13 18:00:00	MSFT	Stock	183.93	183.94	183.62	183.62	5724.0
2020-02-13 19:00:00	MSFT	Stock	183.7	183.84	183.33	183.73	37094.0
2020-02-13 04:00:00	NVDA	Stock	6.7738	6.7738	6.7375	6.7375	147120.0
2020-02-13 05:00:00	NVDA	Stock	6.725	6.742	6.725	6.742	528840.0
2020-02-13 06:00:00	NVDA	Stock	6.7332	6.755	6.7258	6.755	60120.0
2020-02-13 07:00:00	NVDA	Stock	6.762	6.7738	6.7375	6.7625	1746840.0
2020-02-13 08:00:00	NVDA	Stock	6.7581	6.7965	6.7312	6.7862	2292920.0
2020-02-13 09:00:00	NVDA	Stock	6.7862	6.7867	6.7278	6.7478	62950600.0
2020-02-13 10:00:00	NVDA	Stock	6.7485	6.8368	6.7372	6.8082	65040280.0
2020-02-13 11:00:00	NVDA	Stock	6.8082	6.8272	6.797	6.8184	31895800.0
2020-02-13 12:00:00	NVDA	Stock	6.819	6.837	6.7668	6.7672	40653480.0
2020-02-13 13:00:00	NVDA	Stock	6.7678	6.806	6.765	6.8007	33101560.0
2020-02-13 14:00:00	NVDA	Stock	6.8008	6.8239	6.788	6.8048	41591200.0
2020-02-13 15:00:00	NVDA	Stock	6.8054	6.8118	6.75	6.7703	87298880.0
2020-02-13 16:00:00	NVDA	Stock	6.7695	7.3128	6.75	7.1528	81056320.0
2020-02-13 17:00:00	NVDA	Stock	7.1575	7.2375	7.155	7.1665	12273160.0
2020-02-13 18:00:00	NVDA	Stock	7.1578	7.1662	7.076	7.0825	12734440.0
2020-02-13 19:00:00	NVDA	Stock	7.0865	7.1535	7.0825	7.1213	5211120.0
2020-02-13 04:00:00	AMZN	Stock	107.25	107.25	106.85	106.85	18320.0
2020-02-13 05:00:00	AMZN	Stock	106.8	107.0	106.56	107.0	39720.0

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

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