PREVIEW / stock_1hour / 2021-06-23

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-06-23.parquet
  size:    1.4 MB
  rows:    65,178
  symbols: 2,930

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
2021-06-23 04:00:00	AAPL	Stock	133.78	134.2	133.74	133.95	13289.0
2021-06-23 05:00:00	AAPL	Stock	133.98	134.0	133.81	133.98	6781.0
2021-06-23 06:00:00	AAPL	Stock	133.94	134.19	133.94	134.06	4129.0
2021-06-23 07:00:00	AAPL	Stock	134.09	134.22	133.82	134.08	153743.0
2021-06-23 08:00:00	AAPL	Stock	134.0701	134.24	133.87	134.05	391250.0
2021-06-23 09:00:00	AAPL	Stock	134.05	134.32	133.51	134.095	10341313.0
2021-06-23 10:00:00	AAPL	Stock	134.09	134.26	133.65	133.76	8661143.0
2021-06-23 11:00:00	AAPL	Stock	133.77	133.81	133.23	133.73	7331292.0
2021-06-23 12:00:00	AAPL	Stock	133.735	133.82	133.26	133.725	5732508.0
2021-06-23 13:00:00	AAPL	Stock	133.73	134.25	133.67	133.95	5867904.0
2021-06-23 14:00:00	AAPL	Stock	133.94	133.95	133.61	133.93	4228806.0
2021-06-23 15:00:00	AAPL	Stock	133.9356	133.9887	133.5106	133.69	6949341.0
2021-06-23 16:00:00	AAPL	Stock	133.7	133.74	133.5	133.6	4515823.0
2021-06-23 17:00:00	AAPL	Stock	133.61	133.7099	133.61	133.68	38784.0
2021-06-23 18:00:00	AAPL	Stock	133.65	133.75	133.62	133.66	52465.0
2021-06-23 19:00:00	AAPL	Stock	133.68	133.7	133.63	133.65	46485.0
2021-06-23 04:00:00	MSFT	Stock	266.29	266.29	265.8	265.95	4775.0
2021-06-23 05:00:00	MSFT	Stock	265.68	265.89	265.63	265.89	1121.0
2021-06-23 06:00:00	MSFT	Stock	265.94	266.37	265.94	266.21	2728.0
2021-06-23 07:00:00	MSFT	Stock	266.35	266.5	265.11	266.32	49684.0
2021-06-23 08:00:00	MSFT	Stock	265.7399	266.49	265.0528	266.269	110977.0
2021-06-23 09:00:00	MSFT	Stock	266.39	266.83	265.05	266.1655	2365844.0
2021-06-23 10:00:00	MSFT	Stock	266.16	266.37	264.6399	264.85	2524675.0
2021-06-23 11:00:00	MSFT	Stock	264.88	265.63	264.43	265.35	1594561.0
2021-06-23 12:00:00	MSFT	Stock	265.35	265.3699	264.43	264.9285	1307668.0
2021-06-23 13:00:00	MSFT	Stock	264.93	265.605	264.77	265.28	1168673.0
2021-06-23 14:00:00	MSFT	Stock	265.26	265.37	264.835	265.245	1130266.0
2021-06-23 15:00:00	MSFT	Stock	265.25	265.62	265.01	265.27	2151487.0
2021-06-23 16:00:00	MSFT	Stock	265.275	265.275	265.11	265.19	3166401.0
2021-06-23 17:00:00	MSFT	Stock	265.24	265.25	265.16	265.1801	5525.0
2021-06-23 18:00:00	MSFT	Stock	265.25	265.36	265.25	265.34	3030.0
2021-06-23 19:00:00	MSFT	Stock	265.27	265.405	265.27	265.405	2530.0
2021-06-23 04:00:00	NVDA	Stock	18.9452	18.9575	18.9452	18.95	40000.0
2021-06-23 05:00:00	NVDA	Stock	18.9375	18.9375	18.925	18.925	75040.0
2021-06-23 06:00:00	NVDA	Stock	18.925	18.925	18.925	18.925	10360.0
2021-06-23 07:00:00	NVDA	Stock	18.93	18.95	18.8827	18.95	395520.0
2021-06-23 08:00:00	NVDA	Stock	18.95	19.0238	18.8778	19.0	1088320.0
2021-06-23 09:00:00	NVDA	Stock	19.0075	19.1528	18.9078	19.0232	51170760.0
2021-06-23 10:00:00	NVDA	Stock	19.0252	19.1502	18.9956	19.0239	44522640.0
2021-06-23 11:00:00	NVDA	Stock	19.0278	19.135	18.9505	19.103	25210640.0
2021-06-23 12:00:00	NVDA	Stock	19.1029	19.1345	19.015	19.0766	21048720.0
2021-06-23 13:00:00	NVDA	Stock	19.0782	19.125	19.0555	19.0918	14167680.0
2021-06-23 14:00:00	NVDA	Stock	19.0917	19.1035	19.015	19.0884	14248000.0
2021-06-23 15:00:00	NVDA	Stock	19.0898	19.1375	19.0285	19.0578	27550600.0
2021-06-23 16:00:00	NVDA	Stock	19.0572	19.0572	19.0308	19.0388	16215840.0
2021-06-23 17:00:00	NVDA	Stock	19.041	19.045	19.0328	19.0328	145640.0
2021-06-23 18:00:00	NVDA	Stock	19.0328	19.045	19.032	19.032	157680.0
2021-06-23 19:00:00	NVDA	Stock	19.0388	19.0388	19.0315	19.0365	466560.0
2021-06-23 07:00:00	AMZN	Stock	175.6	175.744	175.4225	175.5	53740.0
2021-06-23 08:00:00	AMZN	Stock	175.642	175.75	174.8339	175.5775	234720.0

> showing 50 of 65,178 rows — these rows as CSV

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