PREVIEW / stock_1hour / 2020-02-14

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-02-14.parquet
  size:    1.1 MB
  rows:    50,243
  symbols: 2,409

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-14 04:00:00	AAPL	Stock	81.3575	81.5625	81.3575	81.5325	22416.0
2020-02-14 05:00:00	AAPL	Stock	81.55	81.625	81.5225	81.625	10192.0
2020-02-14 06:00:00	AAPL	Stock	81.5025	81.5025	81.4675	81.5	5628.0
2020-02-14 07:00:00	AAPL	Stock	81.52	81.6	81.485	81.5475	100864.0
2020-02-14 08:00:00	AAPL	Stock	81.55	81.6	81.2375	81.32	458532.0
2020-02-14 09:00:00	AAPL	Stock	81.3	81.495	80.8775	80.9875	9551692.0
2020-02-14 10:00:00	AAPL	Stock	80.9825	81.485	80.7125	81.4325	13416280.0
2020-02-14 11:00:00	AAPL	Stock	81.435	81.47	81.13	81.2482	7011540.0
2020-02-14 12:00:00	AAPL	Stock	81.2425	81.2825	81.0028	81.05	4749064.0
2020-02-14 13:00:00	AAPL	Stock	81.05	81.2725	80.9875	81.0212	6366040.0
2020-02-14 14:00:00	AAPL	Stock	81.0202	81.1555	80.835	81.1175	6390456.0
2020-02-14 15:00:00	AAPL	Stock	81.115	81.25	80.9032	81.235	10611560.0
2020-02-14 16:00:00	AAPL	Stock	81.235	81.2725	81.1875	81.255	9061516.0
2020-02-14 17:00:00	AAPL	Stock	81.2525	81.253	81.215	81.2275	51176.0
2020-02-14 18:00:00	AAPL	Stock	81.25	81.2625	81.225	81.26	46860.0
2020-02-14 19:00:00	AAPL	Stock	81.23	81.2625	81.225	81.2625	33440.0
2020-02-14 04:00:00	MSFT	Stock	184.26	184.26	184.26	184.26	100.0
2020-02-14 05:00:00	MSFT	Stock	184.22	184.43	184.22	184.42	4436.0
2020-02-14 06:00:00	MSFT	Stock	184.4	184.43	184.26	184.38	3357.0
2020-02-14 07:00:00	MSFT	Stock	184.27	184.38	184.12	184.36	19095.0
2020-02-14 08:00:00	MSFT	Stock	184.2	184.38	183.56	183.78	73468.0
2020-02-14 09:00:00	MSFT	Stock	183.73	183.93	182.65	182.96	3252172.0
2020-02-14 10:00:00	MSFT	Stock	182.97	185.24	182.865	185.1	3488879.0
2020-02-14 11:00:00	MSFT	Stock	185.12	185.12	184.41	184.426	1612491.0
2020-02-14 12:00:00	MSFT	Stock	184.42	184.63	183.9	184.123	1801788.0
2020-02-14 13:00:00	MSFT	Stock	184.121	184.6	184.05	184.23	1492546.0
2020-02-14 14:00:00	MSFT	Stock	184.238	184.85	184.07	184.75	1669892.0
2020-02-14 15:00:00	MSFT	Stock	184.755	185.41	184.33	185.35	3682777.0
2020-02-14 16:00:00	MSFT	Stock	185.35	185.66	184.677	185.48	3435158.0
2020-02-14 17:00:00	MSFT	Stock	185.44	185.48	185.31	185.36	15834.0
2020-02-14 18:00:00	MSFT	Stock	185.38	185.4	185.31	185.33	18914.0
2020-02-14 19:00:00	MSFT	Stock	185.37	185.37	185.2	185.3	14456.0
2020-02-14 04:00:00	NVDA	Stock	7.1458	7.222	7.1458	7.205	270120.0
2020-02-14 05:00:00	NVDA	Stock	7.2145	7.2695	7.2145	7.2378	755120.0
2020-02-14 06:00:00	NVDA	Stock	7.2468	7.25	7.2	7.25	582920.0
2020-02-14 07:00:00	NVDA	Stock	7.255	7.26	7.175	7.2125	3359000.0
2020-02-14 08:00:00	NVDA	Stock	7.219	7.233	7.175	7.2125	7075280.0
2020-02-14 09:00:00	NVDA	Stock	7.2142	7.3052	7.15	7.2154	209362920.0
2020-02-14 10:00:00	NVDA	Stock	7.215	7.36	7.1565	7.3295	202747800.0
2020-02-14 11:00:00	NVDA	Stock	7.3285	7.3743	7.275	7.3118	115351240.0
2020-02-14 12:00:00	NVDA	Stock	7.3112	7.3222	7.2148	7.2244	89957080.0
2020-02-14 13:00:00	NVDA	Stock	7.223	7.283	7.2194	7.245	75003600.0
2020-02-14 14:00:00	NVDA	Stock	7.2438	7.2755	7.2238	7.2621	61486960.0
2020-02-14 15:00:00	NVDA	Stock	7.2615	7.27	7.2375	7.245	91774600.0
2020-02-14 16:00:00	NVDA	Stock	7.2448	7.2515	7.2438	7.2438	7495080.0
2020-02-14 17:00:00	NVDA	Stock	7.2438	7.2448	7.235	7.2438	523520.0
2020-02-14 18:00:00	NVDA	Stock	7.2432	7.2442	7.2362	7.2442	303640.0
2020-02-14 19:00:00	NVDA	Stock	7.2442	7.2498	7.2442	7.245	178920.0
2020-02-14 04:00:00	AMZN	Stock	107.8955	107.8955	107.85	107.85	4200.0
2020-02-14 07:00:00	AMZN	Stock	107.8945	108.05	107.8	107.95	76200.0

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

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