PREVIEW / stock_1hour / 2020-02-20

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-02-20.parquet
  size:    1.2 MB
  rows:    51,430
  symbols: 2,432

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-20 04:00:00	AAPL	Stock	80.8225	80.8625	80.75	80.825	20720.0
2020-02-20 05:00:00	AAPL	Stock	80.775	80.775	80.75	80.75	6000.0
2020-02-20 06:00:00	AAPL	Stock	80.71	80.71	80.675	80.675	3076.0
2020-02-20 07:00:00	AAPL	Stock	80.7	80.8125	80.625	80.775	149864.0
2020-02-20 08:00:00	AAPL	Stock	80.75	80.8088	80.51	80.645	306516.0
2020-02-20 09:00:00	AAPL	Stock	80.625	81.1625	80.61	81.095	10782568.0
2020-02-20 10:00:00	AAPL	Stock	81.0975	81.135	80.665	80.6982	10827372.0
2020-02-20 11:00:00	AAPL	Stock	80.7	80.715	79.5525	79.9725	18207948.0
2020-02-20 12:00:00	AAPL	Stock	79.965	80.074	79.6525	80.06	10483088.0
2020-02-20 13:00:00	AAPL	Stock	80.0525	80.265	79.875	79.9262	6537872.0
2020-02-20 14:00:00	AAPL	Stock	79.93	80.2947	79.93	80.095	7146664.0
2020-02-20 15:00:00	AAPL	Stock	80.1025	80.1875	79.925	80.075	10196372.0
2020-02-20 16:00:00	AAPL	Stock	80.075	80.1225	79.9425	79.9425	6464508.0
2020-02-20 17:00:00	AAPL	Stock	79.9375	79.9375	79.845	79.87	68464.0
2020-02-20 18:00:00	AAPL	Stock	79.875	79.9175	79.45	79.5	171208.0
2020-02-20 19:00:00	AAPL	Stock	79.5	79.875	79.4975	79.795	122120.0
2020-02-20 04:00:00	MSFT	Stock	187.15	187.2	187.0	187.0	665.0
2020-02-20 05:00:00	MSFT	Stock	186.95	187.0	186.74	187.0	1906.0
2020-02-20 06:00:00	MSFT	Stock	187.0	187.0	187.0	187.0	300.0
2020-02-20 07:00:00	MSFT	Stock	186.99	186.99	186.75	186.95	11055.0
2020-02-20 08:00:00	MSFT	Stock	186.8	187.74	186.62	186.9	39509.0
2020-02-20 09:00:00	MSFT	Stock	186.84	187.25	185.852	186.55	2805293.0
2020-02-20 10:00:00	MSFT	Stock	186.54	186.89	185.97	186.3	3097669.0
2020-02-20 11:00:00	MSFT	Stock	186.28	186.28	181.1	183.33	8105201.0
2020-02-20 12:00:00	MSFT	Stock	183.31	183.455	182.27	183.415	3844760.0
2020-02-20 13:00:00	MSFT	Stock	183.41	184.32	182.97	183.04	2649886.0
2020-02-20 14:00:00	MSFT	Stock	183.05	184.73	183.04	184.19	2665995.0
2020-02-20 15:00:00	MSFT	Stock	184.2	184.7	183.53	184.33	3748143.0
2020-02-20 16:00:00	MSFT	Stock	184.42	184.59	184.0	184.03	4543338.0
2020-02-20 17:00:00	MSFT	Stock	184.03	184.216	183.97	184.0	11629.0
2020-02-20 18:00:00	MSFT	Stock	184.12	184.12	183.3	183.5	39736.0
2020-02-20 19:00:00	MSFT	Stock	183.5	184.49	183.41	184.29	67490.0
2020-02-20 04:00:00	NVDA	Stock	7.8725	7.9495	7.8725	7.8968	180720.0
2020-02-20 05:00:00	NVDA	Stock	7.8955	7.8955	7.857	7.857	27560.0
2020-02-20 06:00:00	NVDA	Stock	7.8602	7.8672	7.8502	7.8672	64640.0
2020-02-20 07:00:00	NVDA	Stock	7.8745	7.8745	7.834	7.85	1232880.0
2020-02-20 08:00:00	NVDA	Stock	7.87	7.87	7.825	7.8325	2554440.0
2020-02-20 09:00:00	NVDA	Stock	7.8325	7.853	7.7103	7.8445	105753080.0
2020-02-20 10:00:00	NVDA	Stock	7.8448	7.908	7.8188	7.8238	119974400.0
2020-02-20 11:00:00	NVDA	Stock	7.824	7.824	7.4088	7.6425	226436920.0
2020-02-20 12:00:00	NVDA	Stock	7.642	7.6612	7.577	7.6561	80532400.0
2020-02-20 13:00:00	NVDA	Stock	7.6539	7.7243	7.6415	7.686	72349280.0
2020-02-20 14:00:00	NVDA	Stock	7.6864	7.75	7.6842	7.747	62106880.0
2020-02-20 15:00:00	NVDA	Stock	7.7472	7.762	7.6978	7.7145	76079920.0
2020-02-20 16:00:00	NVDA	Stock	7.7175	7.7213	7.6875	7.7013	19722800.0
2020-02-20 17:00:00	NVDA	Stock	7.6998	7.709	7.69	7.69	271160.0
2020-02-20 18:00:00	NVDA	Stock	7.69	7.7	7.6198	7.625	414560.0
2020-02-20 19:00:00	NVDA	Stock	7.6255	7.6912	7.6252	7.675	670320.0
2020-02-20 04:00:00	AMZN	Stock	108.6	108.6	108.6	108.6	2000.0
2020-02-20 05:00:00	AMZN	Stock	108.537	108.537	108.475	108.475	4000.0

> showing 50 of 51,430 rows — these rows as CSV

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