PREVIEW / stock_1hour / 2022-08-11

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-08-11.parquet
  size:    1.4 MB
  rows:    63,635
  symbols: 2,276

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
2022-08-11 04:00:00	AAPL	Stock	169.0	169.35	169.0	169.28	20038.0
2022-08-11 05:00:00	AAPL	Stock	169.3	169.59	169.26	169.31	22781.0
2022-08-11 06:00:00	AAPL	Stock	169.25	169.26	169.06	169.12	14693.0
2022-08-11 07:00:00	AAPL	Stock	169.23	169.8	169.12	169.75	44457.0
2022-08-11 08:00:00	AAPL	Stock	169.1277	170.4	169.1	170.17	585748.0
2022-08-11 09:00:00	AAPL	Stock	170.16	170.55	169.62	170.25	7967632.0
2022-08-11 10:00:00	AAPL	Stock	170.25	170.99	169.714	169.7799	8349572.0
2022-08-11 11:00:00	AAPL	Stock	169.78	169.91	168.97	169.23	6422102.0
2022-08-11 12:00:00	AAPL	Stock	169.22	169.755	168.89	169.61	3553439.0
2022-08-11 13:00:00	AAPL	Stock	169.615	169.725	169.16	169.2391	3242672.0
2022-08-11 14:00:00	AAPL	Stock	169.2304	169.2304	168.39	168.775	4144778.0
2022-08-11 15:00:00	AAPL	Stock	168.7799	168.9161	168.19	168.52	7883002.0
2022-08-11 16:00:00	AAPL	Stock	168.51	168.94	168.33	168.805	4895291.0
2022-08-11 17:00:00	AAPL	Stock	168.8428	168.88	168.49	168.82	654467.0
2022-08-11 18:00:00	AAPL	Stock	168.79	168.81	168.58	168.68	43121.0
2022-08-11 19:00:00	AAPL	Stock	168.7	168.83	168.7	168.78	20141.0
2022-08-11 04:00:00	MSFT	Stock	289.5	289.98	289.0	289.36	3243.0
2022-08-11 05:00:00	MSFT	Stock	289.36	289.8	289.36	289.73	3108.0
2022-08-11 06:00:00	MSFT	Stock	289.5	289.5	289.3	289.3	1117.0
2022-08-11 07:00:00	MSFT	Stock	289.26	289.89	289.26	289.89	5402.0
2022-08-11 08:00:00	MSFT	Stock	289.5	291.44	289.16	291.4	71339.0
2022-08-11 09:00:00	MSFT	Stock	291.25	291.25	288.51	288.92	2345426.0
2022-08-11 10:00:00	MSFT	Stock	288.96	290.45	287.88	288.3881	2187640.0
2022-08-11 11:00:00	MSFT	Stock	288.38	288.725	287.05	288.53	1830918.0
2022-08-11 12:00:00	MSFT	Stock	288.535	289.07	287.8743	288.5794	1081870.0
2022-08-11 13:00:00	MSFT	Stock	288.61	289.2	288.1801	288.33	896693.0
2022-08-11 14:00:00	MSFT	Stock	288.31	288.31	286.51	287.15	1182856.0
2022-08-11 15:00:00	MSFT	Stock	287.14	287.6	286.57	287.22	2041144.0
2022-08-11 16:00:00	MSFT	Stock	287.02	287.6786	287.01	287.5	2645834.0
2022-08-11 17:00:00	MSFT	Stock	287.5986	287.65	287.4114	287.62	4802.0
2022-08-11 18:00:00	MSFT	Stock	287.62	287.62	287.2	287.43	11793.0
2022-08-11 19:00:00	MSFT	Stock	287.49	287.64	287.42	287.64	2409.0
2022-08-11 04:00:00	NVDA	Stock	18.115	18.165	18.063	18.063	164420.0
2022-08-11 05:00:00	NVDA	Stock	18.066	18.12	18.048	18.097	82550.0
2022-08-11 06:00:00	NVDA	Stock	18.06	18.068	18.026	18.068	80510.0
2022-08-11 07:00:00	NVDA	Stock	18.056	18.109	18.039	18.1	140570.0
2022-08-11 08:00:00	NVDA	Stock	18.057	18.319	18.037	18.255	2379550.0
2022-08-11 09:00:00	NVDA	Stock	18.25	18.475	18.01	18.449	65799460.0
2022-08-11 10:00:00	NVDA	Stock	18.45	18.707	18.425	18.4849	86465120.0
2022-08-11 11:00:00	NVDA	Stock	18.486	18.5	18.135	18.219	67609630.0
2022-08-11 12:00:00	NVDA	Stock	18.222	18.2745	18.096	18.207	37487680.0
2022-08-11 13:00:00	NVDA	Stock	18.209	18.254	18.098	18.134	36228910.0
2022-08-11 14:00:00	NVDA	Stock	18.134	18.145	17.95	18.0144	43163670.0
2022-08-11 15:00:00	NVDA	Stock	18.013	18.025	17.876	17.944	59545990.0
2022-08-11 16:00:00	NVDA	Stock	17.9423	18.025	17.933	18.005	13965400.0
2022-08-11 17:00:00	NVDA	Stock	18.005	18.01	17.985	17.996	96390.0
2022-08-11 18:00:00	NVDA	Stock	17.986	17.99	17.965	17.97	103290.0
2022-08-11 19:00:00	NVDA	Stock	17.975	17.994	17.965	17.981	109670.0
2022-08-11 04:00:00	AMZN	Stock	143.2	143.5	142.64	142.7	13670.0
2022-08-11 05:00:00	AMZN	Stock	142.76	143.32	142.76	143.05	4375.0

> showing 50 of 63,635 rows — these rows as CSV

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