PREVIEW / stock_1hour / 2020-01-31

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-01-31.parquet
  size:    1.2 MB
  rows:    51,659
  symbols: 2,437

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-31 04:00:00	AAPL	Stock	80.7025	80.75	80.625	80.635	19044.0
2020-01-31 05:00:00	AAPL	Stock	80.575	80.63	80.3	80.39	54292.0
2020-01-31 06:00:00	AAPL	Stock	80.4325	80.495	80.39	80.495	28976.0
2020-01-31 07:00:00	AAPL	Stock	80.4525	80.695	80.4525	80.55	405296.0
2020-01-31 08:00:00	AAPL	Stock	80.58	80.6875	80.405	80.45	496288.0
2020-01-31 09:00:00	AAPL	Stock	80.44	80.67	79.26	79.605	21453608.0
2020-01-31 10:00:00	AAPL	Stock	79.59	79.61	78.7675	78.965	26922948.0
2020-01-31 11:00:00	AAPL	Stock	78.9618	79.2975	78.62	79.192	18581968.0
2020-01-31 12:00:00	AAPL	Stock	79.19	79.2275	78.55	78.705	11757540.0
2020-01-31 13:00:00	AAPL	Stock	78.695	78.825	77.5125	78.145	20635604.0
2020-01-31 14:00:00	AAPL	Stock	78.15	78.4375	77.8125	78.046	17696084.0
2020-01-31 15:00:00	AAPL	Stock	78.055	78.14	77.0725	77.3325	34671196.0
2020-01-31 16:00:00	AAPL	Stock	77.3775	77.425	77.1525	77.275	11304464.0
2020-01-31 17:00:00	AAPL	Stock	77.2725	77.3775	77.2	77.27	297404.0
2020-01-31 18:00:00	AAPL	Stock	77.295	77.295	77.13	77.185	215132.0
2020-01-31 19:00:00	AAPL	Stock	77.18	77.2075	77.0	77.0375	276288.0
2020-01-31 04:00:00	MSFT	Stock	172.78	172.86	172.14	172.14	7374.0
2020-01-31 05:00:00	MSFT	Stock	172.35	172.47	171.93	172.01	3234.0
2020-01-31 06:00:00	MSFT	Stock	172.2	172.2	172.06	172.2	3367.0
2020-01-31 07:00:00	MSFT	Stock	172.14	172.44	171.85	172.0	46536.0
2020-01-31 08:00:00	MSFT	Stock	172.28	172.48	171.5	172.1	45575.0
2020-01-31 09:00:00	MSFT	Stock	172.08	172.45	171.16	171.71	3829927.0
2020-01-31 10:00:00	MSFT	Stock	171.71	171.71	170.28	170.76	4885860.0
2020-01-31 11:00:00	MSFT	Stock	170.78	170.96	169.58	170.64	3882993.0
2020-01-31 12:00:00	MSFT	Stock	170.64	170.66	169.82	170.47	2633006.0
2020-01-31 13:00:00	MSFT	Stock	170.46	170.77	170.1	170.597	2373901.0
2020-01-31 14:00:00	MSFT	Stock	170.6	171.31	170.53	170.69	2725490.0
2020-01-31 15:00:00	MSFT	Stock	170.69	170.86	169.65	170.17	6198792.0
2020-01-31 16:00:00	MSFT	Stock	170.23	170.7	170.03	170.58	4688779.0
2020-01-31 17:00:00	MSFT	Stock	170.57	170.57	170.23	170.3	23355.0
2020-01-31 18:00:00	MSFT	Stock	170.36	170.4	170.04	170.04	16775.0
2020-01-31 19:00:00	MSFT	Stock	170.04	170.13	169.9	169.9	7161.0
2020-01-31 04:00:00	NVDA	Stock	6.15	6.15	6.1255	6.1255	12000.0
2020-01-31 05:00:00	NVDA	Stock	6.0982	6.0982	6.075	6.075	23360.0
2020-01-31 06:00:00	NVDA	Stock	6.0875	6.0875	6.0875	6.0875	18840.0
2020-01-31 07:00:00	NVDA	Stock	6.119	6.1425	6.0972	6.1175	304960.0
2020-01-31 08:00:00	NVDA	Stock	6.125	6.135	6.097	6.1175	433920.0
2020-01-31 09:00:00	NVDA	Stock	6.109	6.12	6.0102	6.036	31673960.0
2020-01-31 10:00:00	NVDA	Stock	6.031	6.0324	5.955	5.9624	46021920.0
2020-01-31 11:00:00	NVDA	Stock	5.9615	6.0009	5.92	6.0008	37717080.0
2020-01-31 12:00:00	NVDA	Stock	5.9995	5.9995	5.9412	5.9633	43762000.0
2020-01-31 13:00:00	NVDA	Stock	5.9628	5.9835	5.926	5.9585	28325400.0
2020-01-31 14:00:00	NVDA	Stock	5.959	5.972	5.9378	5.94	22221160.0
2020-01-31 15:00:00	NVDA	Stock	5.9396	5.95	5.8688	5.9112	84497880.0
2020-01-31 16:00:00	NVDA	Stock	5.9108	5.937	5.9062	5.9125	34296680.0
2020-01-31 17:00:00	NVDA	Stock	5.9	5.9125	5.9	5.9038	2198440.0
2020-01-31 18:00:00	NVDA	Stock	5.9	5.905	5.888	5.888	83880.0
2020-01-31 19:00:00	NVDA	Stock	5.888	5.8895	5.8763	5.8763	375320.0
2020-01-31 04:00:00	AMZN	Stock	101.675	102.1255	101.5055	101.65	217980.0
2020-01-31 05:00:00	AMZN	Stock	101.703	101.8495	101.0	101.6875	251060.0

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

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