PREVIEW / stock_1hour / 2019-12-24

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-12-24.parquet
  size:    769 KB
  rows:    31,279
  symbols: 2,413

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-12-24 04:00:00	AAPL	Stock	71.14	71.3	71.14	71.3	14944.0
2019-12-24 05:00:00	AAPL	Stock	71.3	71.32	71.25	71.25	2000.0
2019-12-24 06:00:00	AAPL	Stock	71.32	71.32	71.2625	71.2625	11560.0
2019-12-24 07:00:00	AAPL	Stock	71.2825	71.2925	71.1375	71.175	142944.0
2019-12-24 08:00:00	AAPL	Stock	71.2	71.25	70.8225	71.18	318840.0
2019-12-24 09:00:00	AAPL	Stock	71.18	71.2225	70.73	71.0312	14237768.0
2019-12-24 10:00:00	AAPL	Stock	71.0275	71.1375	70.95	71.048	7996184.0
2019-12-24 11:00:00	AAPL	Stock	71.046	71.0825	70.9275	70.9722	4709604.0
2019-12-24 12:00:00	AAPL	Stock	70.97	71.139	70.9225	71.069	6648132.0
2019-12-24 13:00:00	AAPL	Stock	71.0675	71.1175	71.0525	71.085	2065456.0
2019-12-24 14:00:00	AAPL	Stock	71.07	71.125	71.0675	71.1125	173664.0
2019-12-24 15:00:00	AAPL	Stock	71.1125	71.1125	71.1075	71.1075	18260.0
2019-12-24 16:00:00	AAPL	Stock	71.09	71.105	71.0875	71.105	5084.0
2019-12-24 08:00:00	MSFT	Stock	157.695	157.695	157.6	157.6	4305.0
2019-12-24 09:00:00	MSFT	Stock	157.56	157.595	157.115	157.31	1114297.0
2019-12-24 10:00:00	MSFT	Stock	157.29	157.59	157.22	157.59	981188.0
2019-12-24 11:00:00	MSFT	Stock	157.592	157.71	157.49	157.5	896141.0
2019-12-24 12:00:00	MSFT	Stock	157.505	157.53	157.22	157.39	1256744.0
2019-12-24 13:00:00	MSFT	Stock	157.38	157.55	157.35	157.5	919408.0
2019-12-24 14:00:00	MSFT	Stock	157.38	157.47	157.3	157.36	65421.0
2019-12-24 15:00:00	MSFT	Stock	157.32	157.32	157.26	157.26	2847.0
2019-12-24 16:00:00	MSFT	Stock	157.27	157.35	157.27	157.35	330.0
2019-12-24 04:00:00	NVDA	Stock	5.9702	5.9702	5.9702	5.9702	8520.0
2019-12-24 05:00:00	NVDA	Stock	5.9702	5.9702	5.9702	5.9702	8000.0
2019-12-24 07:00:00	NVDA	Stock	5.9752	5.9825	5.9752	5.9788	69120.0
2019-12-24 08:00:00	NVDA	Stock	5.9825	5.985	5.9558	5.9823	299400.0
2019-12-24 09:00:00	NVDA	Stock	5.98	5.9845	5.9205	5.9565	34287720.0
2019-12-24 10:00:00	NVDA	Stock	5.9575	5.9688	5.9312	5.9397	33955640.0
2019-12-24 11:00:00	NVDA	Stock	5.9395	5.9638	5.9378	5.963	27383080.0
2019-12-24 12:00:00	NVDA	Stock	5.962	5.9685	5.94	5.9655	23009720.0
2019-12-24 13:00:00	NVDA	Stock	5.9655	5.9655	5.9563	5.9563	4201120.0
2019-12-24 14:00:00	NVDA	Stock	5.9609	5.9655	5.9609	5.9612	902600.0
2019-12-24 15:00:00	NVDA	Stock	5.9625	5.9642	5.9625	5.9642	8000.0
2019-12-24 16:00:00	NVDA	Stock	5.9655	5.9658	5.9655	5.9658	52040.0
2019-12-24 07:00:00	AMZN	Stock	89.949	89.949	89.831	89.85	31220.0
2019-12-24 08:00:00	AMZN	Stock	89.8225	89.925	89.77	89.8	30160.0
2019-12-24 09:00:00	AMZN	Stock	89.8045	89.8405	89.4575	89.6064	2501600.0
2019-12-24 10:00:00	AMZN	Stock	89.6225	89.7133	89.5386	89.5698	1973180.0
2019-12-24 11:00:00	AMZN	Stock	89.5885	89.6534	89.525	89.5505	1137620.0
2019-12-24 12:00:00	AMZN	Stock	89.55	89.5735	89.3788	89.4815	2393460.0
2019-12-24 13:00:00	AMZN	Stock	89.4605	89.5	89.4605	89.4696	1098460.0
2019-12-24 15:00:00	AMZN	Stock	89.4605	89.4605	89.4605	89.4605	4000.0
2019-12-24 09:00:00	GOOGL	Stock	67.5105	67.6005	67.2083	67.295	866080.0
2019-12-24 10:00:00	GOOGL	Stock	67.2942	67.525	67.289	67.2909	743020.0
2019-12-24 11:00:00	GOOGL	Stock	67.3082	67.3622	67.2875	67.3465	473880.0
2019-12-24 12:00:00	GOOGL	Stock	67.362	67.375	67.2085	67.237	869600.0
2019-12-24 13:00:00	GOOGL	Stock	67.2215	67.2215	67.2215	67.2215	748940.0
2019-12-24 07:00:00	META	Stock	206.3	206.39	206.3	206.37	1634.0
2019-12-24 08:00:00	META	Stock	206.3	206.5	206.22	206.48	8705.0
2019-12-24 09:00:00	META	Stock	206.48	206.79	205.05	205.49	847554.0

> showing 50 of 31,279 rows — these rows as CSV

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