PREVIEW / stock_1hour / 2021-12-23

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-12-23.parquet
  size:    1.4 MB
  rows:    64,135
  symbols: 2,638

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-12-23 04:00:00	AAPL	Stock	175.7	176.11	175.65	176.02	16324.0
2021-12-23 05:00:00	AAPL	Stock	176.08	176.37	176.04	176.33	15004.0
2021-12-23 06:00:00	AAPL	Stock	176.28	176.4	176.12	176.19	25975.0
2021-12-23 07:00:00	AAPL	Stock	176.19	176.3	176.1	176.24	69320.0
2021-12-23 08:00:00	AAPL	Stock	176.19	176.35	175.7	175.94	437366.0
2021-12-23 09:00:00	AAPL	Stock	175.92	176.28	175.27	175.89	9691105.0
2021-12-23 10:00:00	AAPL	Stock	175.8884	176.54	175.75	176.47	9362871.0
2021-12-23 11:00:00	AAPL	Stock	176.48	176.51	175.67	176.18	6355417.0
2021-12-23 12:00:00	AAPL	Stock	176.18	176.31	175.795	176.255	5558926.0
2021-12-23 13:00:00	AAPL	Stock	176.26	176.34	175.99	175.99	3620420.0
2021-12-23 14:00:00	AAPL	Stock	175.99	176.6414	175.76	176.49	6051674.0
2021-12-23 15:00:00	AAPL	Stock	176.5	176.8499	175.97	176.29	11143433.0
2021-12-23 16:00:00	AAPL	Stock	176.28	176.28	175.77	176.02	5466216.0
2021-12-23 17:00:00	AAPL	Stock	176.02	176.02	175.9	175.99	34746.0
2021-12-23 18:00:00	AAPL	Stock	175.98	176.06	175.95	176.02	37452.0
2021-12-23 19:00:00	AAPL	Stock	176.03	176.5	175.85	176.32	91207.0
2021-12-23 04:00:00	MSFT	Stock	333.86	333.86	333.56	333.57	332.0
2021-12-23 05:00:00	MSFT	Stock	333.56	333.56	333.4	333.5	546.0
2021-12-23 06:00:00	MSFT	Stock	333.85	334.01	333.85	333.9	695.0
2021-12-23 07:00:00	MSFT	Stock	333.91	334.03	333.33	333.65	15750.0
2021-12-23 08:00:00	MSFT	Stock	333.9993	334.1	332.7	333.332	29477.0
2021-12-23 09:00:00	MSFT	Stock	333.31	334.97	332.71	334.81	1861721.0
2021-12-23 10:00:00	MSFT	Stock	334.86	336.39	334.6	335.62	2190347.0
2021-12-23 11:00:00	MSFT	Stock	335.631	335.94	334.94	335.23	1154547.0
2021-12-23 12:00:00	MSFT	Stock	335.28	335.4	334.37	334.84	1164734.0
2021-12-23 13:00:00	MSFT	Stock	334.85	334.94	334.0631	334.59	926317.0
2021-12-23 14:00:00	MSFT	Stock	334.6	335.7	334.6	335.43	1062782.0
2021-12-23 15:00:00	MSFT	Stock	335.42	336.09	334.38	334.49	2337772.0
2021-12-23 16:00:00	MSFT	Stock	334.5	335.0	334.05	334.8	3561510.0
2021-12-23 17:00:00	MSFT	Stock	334.6	334.7	334.6	334.6	1805.0
2021-12-23 18:00:00	MSFT	Stock	334.55	334.65	334.55	334.6	519.0
2021-12-23 19:00:00	MSFT	Stock	334.6	334.6	334.32	334.5	2581.0
2021-12-23 04:00:00	NVDA	Stock	29.43	29.65	29.43	29.57	80250.0
2021-12-23 05:00:00	NVDA	Stock	29.581	29.658	29.58	29.6	58120.0
2021-12-23 06:00:00	NVDA	Stock	29.62	29.657	29.611	29.65	26070.0
2021-12-23 07:00:00	NVDA	Stock	29.666	29.817	29.63	29.74	770760.0
2021-12-23 08:00:00	NVDA	Stock	29.75	29.82	29.585	29.647	1122570.0
2021-12-23 09:00:00	NVDA	Stock	29.639	29.917	29.431	29.594	50111580.0
2021-12-23 10:00:00	NVDA	Stock	29.594	29.732	29.466	29.69	38490960.0
2021-12-23 11:00:00	NVDA	Stock	29.6967	30.059	29.691	29.964	48633350.0
2021-12-23 12:00:00	NVDA	Stock	29.964	29.978	29.637	29.7043	27847960.0
2021-12-23 13:00:00	NVDA	Stock	29.7076	29.82	29.653	29.7875	17909740.0
2021-12-23 14:00:00	NVDA	Stock	29.784	29.82	29.592	29.714	19030610.0
2021-12-23 15:00:00	NVDA	Stock	29.712	29.811	29.617	29.638	33166990.0
2021-12-23 16:00:00	NVDA	Stock	29.64	29.7239	29.542	29.551	13308920.0
2021-12-23 17:00:00	NVDA	Stock	29.552	29.552	29.511	29.55	305630.0
2021-12-23 18:00:00	NVDA	Stock	29.552	29.58	29.549	29.567	189980.0
2021-12-23 19:00:00	NVDA	Stock	29.555	29.567	29.54	29.56	165180.0
2021-12-23 07:00:00	AMZN	Stock	171.15	171.386	171.15	171.3245	16020.0
2021-12-23 08:00:00	AMZN	Stock	171.3213	171.3213	170.9945	170.9945	18160.0

> showing 50 of 64,135 rows — these rows as CSV

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