PREVIEW / stock_1hour / 2019-11-22

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-11-22.parquet
  size:    1.1 MB
  rows:    49,827
  symbols: 2,477

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-11-22 04:00:00	AAPL	Stock	65.7625	65.7625	65.65	65.755	8808.0
2019-11-22 06:00:00	AAPL	Stock	65.7425	65.745	65.665	65.7025	10528.0
2019-11-22 07:00:00	AAPL	Stock	65.7025	65.775	65.7	65.75	65720.0
2019-11-22 08:00:00	AAPL	Stock	65.7375	65.8	65.5025	65.75	563008.0
2019-11-22 09:00:00	AAPL	Stock	65.75	65.795	65.385	65.635	9580604.0
2019-11-22 10:00:00	AAPL	Stock	65.635	65.725	65.4425	65.475	7822696.0
2019-11-22 11:00:00	AAPL	Stock	65.475	65.62	65.2175	65.5825	8313068.0
2019-11-22 12:00:00	AAPL	Stock	65.5775	65.6075	65.435	65.5425	4326440.0
2019-11-22 13:00:00	AAPL	Stock	65.545	65.605	65.3525	65.435	3984136.0
2019-11-22 14:00:00	AAPL	Stock	65.435	65.4425	65.2525	65.3153	5032604.0
2019-11-22 15:00:00	AAPL	Stock	65.32	65.555	65.21	65.46	9822012.0
2019-11-22 16:00:00	AAPL	Stock	65.445	65.4875	65.4125	65.45	7175612.0
2019-11-22 17:00:00	AAPL	Stock	65.4575	65.48	65.44	65.4625	34040.0
2019-11-22 18:00:00	AAPL	Stock	65.47	65.48	65.4625	65.4675	17732.0
2019-11-22 19:00:00	AAPL	Stock	65.4675	65.4775	65.4525	65.4525	14192.0
2019-11-22 04:00:00	MSFT	Stock	149.98	150.1	149.93	150.0	3777.0
2019-11-22 05:00:00	MSFT	Stock	150.0	150.05	149.94	150.05	760.0
2019-11-22 06:00:00	MSFT	Stock	149.9	150.17	149.9	150.16	3404.0
2019-11-22 07:00:00	MSFT	Stock	150.08	150.2	150.0	150.06	7174.0
2019-11-22 08:00:00	MSFT	Stock	150.1	150.18	149.48	149.48	92875.0
2019-11-22 09:00:00	MSFT	Stock	150.03	150.3	149.619	149.75	1866106.0
2019-11-22 10:00:00	MSFT	Stock	149.745	149.875	148.88	149.06	2293529.0
2019-11-22 11:00:00	MSFT	Stock	149.05	149.41	148.82	149.186	1449493.0
2019-11-22 12:00:00	MSFT	Stock	149.19	149.39	149.03	149.345	865823.0
2019-11-22 13:00:00	MSFT	Stock	149.35	149.48	149.21	149.337	774860.0
2019-11-22 14:00:00	MSFT	Stock	149.335	149.47	149.1	149.435	945188.0
2019-11-22 15:00:00	MSFT	Stock	149.44	149.65	149.25	149.63	2264641.0
2019-11-22 16:00:00	MSFT	Stock	149.59	149.76	149.53	149.59	2987409.0
2019-11-22 17:00:00	MSFT	Stock	149.59	149.6	149.48	149.5	6866.0
2019-11-22 18:00:00	MSFT	Stock	149.6	149.6	149.5	149.5	2000.0
2019-11-22 19:00:00	MSFT	Stock	149.46	149.59	149.46	149.55	1833.0
2019-11-22 04:00:00	NVDA	Stock	5.2735	5.2735	5.2735	5.2735	4000.0
2019-11-22 06:00:00	NVDA	Stock	5.27	5.27	5.27	5.27	4000.0
2019-11-22 07:00:00	NVDA	Stock	5.2718	5.28	5.2572	5.27	239640.0
2019-11-22 08:00:00	NVDA	Stock	5.275	5.275	5.25	5.2545	849280.0
2019-11-22 09:00:00	NVDA	Stock	5.2613	5.3241	5.2602	5.3142	36975600.0
2019-11-22 10:00:00	NVDA	Stock	5.315	5.3173	5.26	5.2812	45067320.0
2019-11-22 11:00:00	NVDA	Stock	5.2803	5.2985	5.2625	5.2788	25695880.0
2019-11-22 12:00:00	NVDA	Stock	5.2785	5.291	5.2653	5.277	21292480.0
2019-11-22 13:00:00	NVDA	Stock	5.2766	5.2782	5.2485	5.2662	23028720.0
2019-11-22 14:00:00	NVDA	Stock	5.2664	5.2782	5.256	5.2705	16866640.0
2019-11-22 15:00:00	NVDA	Stock	5.2715	5.275	5.262	5.2722	29478040.0
2019-11-22 16:00:00	NVDA	Stock	5.2722	5.2722	5.2635	5.2662	13569040.0
2019-11-22 17:00:00	NVDA	Stock	5.2662	5.2695	5.265	5.2688	94280.0
2019-11-22 18:00:00	NVDA	Stock	5.2688	5.271	5.2653	5.2653	77880.0
2019-11-22 19:00:00	NVDA	Stock	5.2688	5.275	5.2678	5.2738	168600.0
2019-11-22 06:00:00	AMZN	Stock	86.9	86.925	86.9	86.925	8760.0
2019-11-22 07:00:00	AMZN	Stock	87.013	87.037	87.0	87.0	12600.0
2019-11-22 08:00:00	AMZN	Stock	86.996	86.996	86.7355	86.7355	145460.0
2019-11-22 09:00:00	AMZN	Stock	86.9895	87.0803	86.5728	87.0425	5786040.0

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

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