PREVIEW / stock_1hour / 2020-01-24

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-01-24.parquet
  size:    1.2 MB
  rows:    50,582
  symbols: 2,440

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-01-24 04:00:00	AAPL	Stock	80.0825	80.165	80.0825	80.1225	11716.0
2020-01-24 05:00:00	AAPL	Stock	80.0975	80.1	80.04	80.04	20580.0
2020-01-24 06:00:00	AAPL	Stock	80.095	80.095	80.025	80.075	27368.0
2020-01-24 07:00:00	AAPL	Stock	80.075	80.075	79.925	79.955	299020.0
2020-01-24 08:00:00	AAPL	Stock	79.945	80.075	79.93	80.055	696552.0
2020-01-24 09:00:00	AAPL	Stock	80.055	80.6575	79.965	80.6525	17056020.0
2020-01-24 10:00:00	AAPL	Stock	80.655	80.6575	80.25	80.555	16764684.0
2020-01-24 11:00:00	AAPL	Stock	80.5672	80.8325	80.4375	80.4925	14769308.0
2020-01-24 12:00:00	AAPL	Stock	80.4875	80.4962	79.8275	80.2755	18857124.0
2020-01-24 13:00:00	AAPL	Stock	80.2825	80.2875	79.7625	79.9625	10875476.0
2020-01-24 14:00:00	AAPL	Stock	79.9675	80.065	79.4725	80.0445	16754556.0
2020-01-24 15:00:00	AAPL	Stock	80.04	80.095	79.3798	79.5825	19891836.0
2020-01-24 16:00:00	AAPL	Stock	79.5625	80.135	79.55	79.55	9265288.0
2020-01-24 17:00:00	AAPL	Stock	79.5875	79.5875	79.4575	79.5	166852.0
2020-01-24 18:00:00	AAPL	Stock	79.48	79.525	79.4375	79.4375	49616.0
2020-01-24 19:00:00	AAPL	Stock	79.4625	79.4975	79.3775	79.395	76216.0
2020-01-24 04:00:00	MSFT	Stock	167.75	168.0	167.71	167.71	2519.0
2020-01-24 05:00:00	MSFT	Stock	167.79	167.85	167.79	167.85	1000.0
2020-01-24 06:00:00	MSFT	Stock	167.71	167.89	167.68	167.89	3288.0
2020-01-24 07:00:00	MSFT	Stock	167.76	167.8	167.5	167.5	24879.0
2020-01-24 08:00:00	MSFT	Stock	167.74	167.815	167.38	167.46	37753.0
2020-01-24 09:00:00	MSFT	Stock	167.48	167.65	166.83	167.405	2532289.0
2020-01-24 10:00:00	MSFT	Stock	167.4	167.425	166.77	167.23	2080937.0
2020-01-24 11:00:00	MSFT	Stock	167.235	167.43	166.55	166.72	2143916.0
2020-01-24 12:00:00	MSFT	Stock	166.71	166.75	165.737	166.36	2038273.0
2020-01-24 13:00:00	MSFT	Stock	166.368	166.375	164.85	165.255	1924519.0
2020-01-24 14:00:00	MSFT	Stock	165.255	165.34	164.45	165.041	2823307.0
2020-01-24 15:00:00	MSFT	Stock	165.03	165.605	164.58	165.04	4559170.0
2020-01-24 16:00:00	MSFT	Stock	165.04	166.165	164.92	164.95	3364456.0
2020-01-24 17:00:00	MSFT	Stock	165.0	165.0	164.9	164.9	9021.0
2020-01-24 18:00:00	MSFT	Stock	164.92	164.97	164.9	164.9	2408.0
2020-01-24 19:00:00	MSFT	Stock	164.89	164.92	164.79	164.83	10066.0
2020-01-24 04:00:00	NVDA	Stock	6.4252	6.4375	6.4162	6.4162	177920.0
2020-01-24 06:00:00	NVDA	Stock	6.42	6.4225	6.4175	6.4225	68840.0
2020-01-24 07:00:00	NVDA	Stock	6.4125	6.4488	6.41	6.4125	610240.0
2020-01-24 08:00:00	NVDA	Stock	6.4438	6.4498	6.4	6.409	1408920.0
2020-01-24 09:00:00	NVDA	Stock	6.4092	6.4875	6.3705	6.3932	72479160.0
2020-01-24 10:00:00	NVDA	Stock	6.392	6.3953	6.3325	6.3792	43143240.0
2020-01-24 11:00:00	NVDA	Stock	6.3778	6.396	6.34	6.3429	30989000.0
2020-01-24 12:00:00	NVDA	Stock	6.3408	6.3438	6.285	6.334	42119200.0
2020-01-24 13:00:00	NVDA	Stock	6.3333	6.3345	6.25	6.2778	33480160.0
2020-01-24 14:00:00	NVDA	Stock	6.275	6.28	6.2075	6.2658	44552880.0
2020-01-24 15:00:00	NVDA	Stock	6.265	6.2875	6.225	6.2638	52991280.0
2020-01-24 16:00:00	NVDA	Stock	6.262	6.262	6.25	6.25	5178160.0
2020-01-24 17:00:00	NVDA	Stock	6.255	6.2563	6.2438	6.25	98920.0
2020-01-24 18:00:00	NVDA	Stock	6.2403	6.2588	6.24	6.2588	203520.0
2020-01-24 19:00:00	NVDA	Stock	6.2465	6.2465	6.2312	6.2312	24960.0
2020-01-24 07:00:00	AMZN	Stock	94.4	94.405	94.3485	94.36	47060.0
2020-01-24 08:00:00	AMZN	Stock	94.35	94.4735	94.35	94.4735	110820.0
2020-01-24 09:00:00	AMZN	Stock	94.5545	94.7495	94.4	94.5468	5083240.0

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

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