PREVIEW / stock_1hour / 2020-10-05

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-10-05.parquet
  size:    1.3 MB
  rows:    57,844
  symbols: 2,515

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-10-05 04:00:00	AAPL	Stock	113.75	114.4	113.48	114.3	65705.0
2020-10-05 05:00:00	AAPL	Stock	114.27	114.43	114.09	114.4	24267.0
2020-10-05 06:00:00	AAPL	Stock	114.44	114.71	114.25	114.53	52210.0
2020-10-05 07:00:00	AAPL	Stock	114.49	114.6	113.98	113.98	422463.0
2020-10-05 08:00:00	AAPL	Stock	114.0	114.5	113.3	113.89	829640.0
2020-10-05 09:00:00	AAPL	Stock	113.95	114.68	113.55	114.58	13550527.0
2020-10-05 10:00:00	AAPL	Stock	114.6	115.49	114.585	115.13	15175847.0
2020-10-05 11:00:00	AAPL	Stock	115.13	115.49	114.82	115.175	10921206.0
2020-10-05 12:00:00	AAPL	Stock	115.175	115.84	115.06	115.812	8433315.0
2020-10-05 13:00:00	AAPL	Stock	115.81	116.11	115.34	115.47	9481770.0
2020-10-05 14:00:00	AAPL	Stock	115.48	115.98	115.18	115.97	9203394.0
2020-10-05 15:00:00	AAPL	Stock	115.96	116.65	115.87	116.54	17951774.0
2020-10-05 16:00:00	AAPL	Stock	116.55	116.66	116.3	116.38	7507221.0
2020-10-05 17:00:00	AAPL	Stock	116.38	116.49	116.34	116.38	83865.0
2020-10-05 18:00:00	AAPL	Stock	116.39	116.55	116.36	116.49	81767.0
2020-10-05 19:00:00	AAPL	Stock	116.48	116.48	115.61	115.76	412785.0
2020-10-05 04:00:00	MSFT	Stock	208.0	208.09	207.8	208.04	1861.0
2020-10-05 05:00:00	MSFT	Stock	208.09	208.1	207.99	208.1	3232.0
2020-10-05 06:00:00	MSFT	Stock	208.1	208.44	208.01	208.44	6532.0
2020-10-05 07:00:00	MSFT	Stock	208.24	208.39	207.7	207.82	48593.0
2020-10-05 08:00:00	MSFT	Stock	208.25	208.35	205.68	207.93	63430.0
2020-10-05 09:00:00	MSFT	Stock	207.909	208.1	206.98	207.795	2277869.0
2020-10-05 10:00:00	MSFT	Stock	207.82	209.25	207.82	208.66	2314999.0
2020-10-05 11:00:00	MSFT	Stock	208.65	209.225	208.32	208.87	2058584.0
2020-10-05 12:00:00	MSFT	Stock	208.88	209.319	208.63	209.29	1085612.0
2020-10-05 13:00:00	MSFT	Stock	209.27	209.44	208.35	208.568	1083348.0
2020-10-05 14:00:00	MSFT	Stock	208.55	209.49	208.34	209.43	1436923.0
2020-10-05 15:00:00	MSFT	Stock	209.43	210.41	209.29	210.37	3688215.0
2020-10-05 16:00:00	MSFT	Stock	210.38	210.38	209.8	209.9	3552425.0
2020-10-05 17:00:00	MSFT	Stock	209.91	210.38	209.86	210.0	10822.0
2020-10-05 18:00:00	MSFT	Stock	210.02	210.13	210.0	210.11	18960.0
2020-10-05 19:00:00	MSFT	Stock	210.08	210.08	208.27	208.95	50565.0
2020-10-05 04:00:00	NVDA	Stock	13.25	13.2745	13.25	13.25	128880.0
2020-10-05 05:00:00	NVDA	Stock	13.25	13.2972	13.25	13.284	46120.0
2020-10-05 06:00:00	NVDA	Stock	13.2688	13.2713	13.2438	13.2535	75560.0
2020-10-05 07:00:00	NVDA	Stock	13.25	13.2625	13.2102	13.2102	1133720.0
2020-10-05 08:00:00	NVDA	Stock	13.226	13.259	13.0948	13.2052	2001760.0
2020-10-05 09:00:00	NVDA	Stock	13.217	13.49	13.217	13.4819	70030520.0
2020-10-05 10:00:00	NVDA	Stock	13.485	13.5935	13.4665	13.4682	90568400.0
2020-10-05 11:00:00	NVDA	Stock	13.4722	13.6032	13.4432	13.6018	59297800.0
2020-10-05 12:00:00	NVDA	Stock	13.6009	13.6208	13.54	13.5966	33803000.0
2020-10-05 13:00:00	NVDA	Stock	13.598	13.5998	13.515	13.5385	29901720.0
2020-10-05 14:00:00	NVDA	Stock	13.5385	13.6363	13.5032	13.634	45050240.0
2020-10-05 15:00:00	NVDA	Stock	13.6333	13.6442	13.5725	13.6425	55508600.0
2020-10-05 16:00:00	NVDA	Stock	13.6425	13.6445	13.6068	13.625	28548720.0
2020-10-05 17:00:00	NVDA	Stock	13.625	13.63	13.6075	13.63	153080.0
2020-10-05 18:00:00	NVDA	Stock	13.63	13.6698	13.6255	13.665	551880.0
2020-10-05 19:00:00	NVDA	Stock	13.6625	13.6625	13.575	13.595	831360.0
2020-10-05 04:00:00	AMZN	Stock	157.5	157.5	157.5	157.5	4560.0
2020-10-05 06:00:00	AMZN	Stock	158.0	158.256	157.84	158.256	6000.0

> showing 50 of 57,844 rows — these rows as CSV

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