PREVIEW / stock_1hour / 2021-11-01

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-11-01.parquet
  size:    1.5 MB
  rows:    67,717
  symbols: 2,695

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-11-01 04:00:00	AAPL	Stock	149.95	150.15	149.56	149.6	44613.0
2021-11-01 05:00:00	AAPL	Stock	149.6	149.74	149.56	149.6	26860.0
2021-11-01 06:00:00	AAPL	Stock	149.6	149.68	149.51	149.68	35363.0
2021-11-01 07:00:00	AAPL	Stock	149.69	149.85	149.5	149.66	180892.0
2021-11-01 08:00:00	AAPL	Stock	149.72	149.85	149.41	149.45	322671.0
2021-11-01 09:00:00	AAPL	Stock	149.45	149.7	148.08	148.235	10599012.0
2021-11-01 10:00:00	AAPL	Stock	148.24	148.8666	147.8	148.36	9678717.0
2021-11-01 11:00:00	AAPL	Stock	148.35	149.04	148.25	148.89	5079173.0
2021-11-01 12:00:00	AAPL	Stock	148.9	149.025	148.66	148.935	5453416.0
2021-11-01 13:00:00	AAPL	Stock	148.94	149.02	148.51	148.57	4248144.0
2021-11-01 14:00:00	AAPL	Stock	148.56	148.7	148.27	148.345	4253565.0
2021-11-01 15:00:00	AAPL	Stock	148.34	149.01	148.317	148.97	8549496.0
2021-11-01 16:00:00	AAPL	Stock	148.96	148.96	148.62	148.66	8306611.0
2021-11-01 17:00:00	AAPL	Stock	148.66	148.73	148.64	148.67	56632.0
2021-11-01 18:00:00	AAPL	Stock	148.68	148.72	148.5	148.67	54646.0
2021-11-01 19:00:00	AAPL	Stock	148.67	148.67	148.27	148.44	93702.0
2021-11-01 04:00:00	MSFT	Stock	331.6	333.05	331.6	332.96	6994.0
2021-11-01 05:00:00	MSFT	Stock	332.94	333.42	332.94	333.35	7321.0
2021-11-01 06:00:00	MSFT	Stock	333.3	333.45	332.76	332.9	14883.0
2021-11-01 07:00:00	MSFT	Stock	332.9	333.0	332.02	332.47	31487.0
2021-11-01 08:00:00	MSFT	Stock	332.8	333.0446	331.8	332.19	49972.0
2021-11-01 09:00:00	MSFT	Stock	332.18	332.18	327.18	327.61	3478047.0
2021-11-01 10:00:00	MSFT	Stock	327.62	327.98	326.37	326.525	3380559.0
2021-11-01 11:00:00	MSFT	Stock	326.52	328.25	326.515	328.19	2068586.0
2021-11-01 12:00:00	MSFT	Stock	328.22	328.68	327.65	327.71	1757707.0
2021-11-01 13:00:00	MSFT	Stock	327.715	328.335	327.32	328.18	1301029.0
2021-11-01 14:00:00	MSFT	Stock	328.17	328.75	327.81	328.72	1352685.0
2021-11-01 15:00:00	MSFT	Stock	328.72	330.18	328.4	329.38	3034100.0
2021-11-01 16:00:00	MSFT	Stock	329.37	330.45	329.37	329.8	3255913.0
2021-11-01 17:00:00	MSFT	Stock	329.82	330.0	329.8	329.91	9813.0
2021-11-01 18:00:00	MSFT	Stock	329.91	329.92	329.42	329.8	14657.0
2021-11-01 19:00:00	MSFT	Stock	329.66	329.68	329.35	329.45	14539.0
2021-11-01 04:00:00	NVDA	Stock	25.89	25.89	25.699	25.724	57190.0
2021-11-01 05:00:00	NVDA	Stock	25.727	25.91	25.699	25.869	160200.0
2021-11-01 06:00:00	NVDA	Stock	25.849	25.86	25.8	25.83	109690.0
2021-11-01 07:00:00	NVDA	Stock	25.81	25.887	25.81	25.824	353160.0
2021-11-01 08:00:00	NVDA	Stock	25.875	25.893	25.634	25.72	1263910.0
2021-11-01 09:00:00	NVDA	Stock	25.699	25.75	25.227	25.505	35650040.0
2021-11-01 10:00:00	NVDA	Stock	25.505	25.784	25.349	25.5565	35331750.0
2021-11-01 11:00:00	NVDA	Stock	25.5535	25.894	25.5411	25.8685	27772850.0
2021-11-01 12:00:00	NVDA	Stock	25.87	25.882	25.761	25.8315	14950910.0
2021-11-01 13:00:00	NVDA	Stock	25.832	25.845	25.6735	25.721	16811570.0
2021-11-01 14:00:00	NVDA	Stock	25.7204	25.745	25.59	25.618	15229490.0
2021-11-01 15:00:00	NVDA	Stock	25.62	25.854	25.578	25.829	21152430.0
2021-11-01 16:00:00	NVDA	Stock	25.827	25.855	25.731	25.775	14930130.0
2021-11-01 17:00:00	NVDA	Stock	25.799	25.846	25.775	25.81	44810.0
2021-11-01 18:00:00	NVDA	Stock	25.8	25.818	25.752	25.8	144000.0
2021-11-01 19:00:00	NVDA	Stock	25.8	25.825	25.776	25.776	173030.0
2021-11-01 04:00:00	AMZN	Stock	168.5185	168.75	168.5185	168.75	4000.0
2021-11-01 05:00:00	AMZN	Stock	168.9865	168.9865	168.9625	168.9625	6000.0

> showing 50 of 67,717 rows — these rows as CSV

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