PREVIEW / stock_1hour / 2022-09-07

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-09-07.parquet
  size:    1.3 MB
  rows:    61,207
  symbols: 2,197

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-09-07 04:00:00	AAPL	Stock	154.66	155.42	154.6	155.35	26076.0
2022-09-07 05:00:00	AAPL	Stock	155.34	155.35	155.05	155.27	9368.0
2022-09-07 06:00:00	AAPL	Stock	155.18	155.2	154.98	155.09	26585.0
2022-09-07 07:00:00	AAPL	Stock	155.15	155.17	154.28	154.59	100372.0
2022-09-07 08:00:00	AAPL	Stock	154.9814	155.18	154.144	154.57	357199.0
2022-09-07 09:00:00	AAPL	Stock	154.54	155.9162	154.53	155.31	9261325.0
2022-09-07 10:00:00	AAPL	Stock	155.305	155.459	153.61	154.12	12053325.0
2022-09-07 11:00:00	AAPL	Stock	154.12	155.26	153.9	154.75	6864117.0
2022-09-07 12:00:00	AAPL	Stock	154.755	155.33	154.235	154.86	6076836.0
2022-09-07 13:00:00	AAPL	Stock	154.855	155.71	154.55	155.55	9118084.0
2022-09-07 14:00:00	AAPL	Stock	155.55	156.22	154.75	155.745	13226294.0
2022-09-07 15:00:00	AAPL	Stock	155.74	156.67	155.66	155.92	12326749.0
2022-09-07 16:00:00	AAPL	Stock	155.91	156.02	155.69	155.82	7873433.0
2022-09-07 17:00:00	AAPL	Stock	155.83	156.05	155.82	156.01	78666.0
2022-09-07 18:00:00	AAPL	Stock	156.07	156.11	155.93	156.02	38576.0
2022-09-07 19:00:00	AAPL	Stock	155.98	156.04	155.88	156.04	35983.0
2022-09-07 04:00:00	MSFT	Stock	253.89	254.02	253.31	253.77	6890.0
2022-09-07 05:00:00	MSFT	Stock	253.5	253.7	253.5	253.67	973.0
2022-09-07 06:00:00	MSFT	Stock	253.45	253.7	253.25	253.7	3182.0
2022-09-07 07:00:00	MSFT	Stock	253.65	253.84	252.71	253.75	23521.0
2022-09-07 08:00:00	MSFT	Stock	253.65	254.69	252.617	254.29	66825.0
2022-09-07 09:00:00	MSFT	Stock	254.4191	255.89	254.03	255.07	2034455.0
2022-09-07 10:00:00	MSFT	Stock	255.04	255.28	253.22	254.18	2075222.0
2022-09-07 11:00:00	MSFT	Stock	254.19	255.75	253.87	255.26	1209054.0
2022-09-07 12:00:00	MSFT	Stock	255.27	256.45	254.64	256.11	1133017.0
2022-09-07 13:00:00	MSFT	Stock	256.11	257.12	255.25	256.98	1228050.0
2022-09-07 14:00:00	MSFT	Stock	256.975	258.56	256.84	258.31	1562493.0
2022-09-07 15:00:00	MSFT	Stock	258.35	258.83	257.91	258.05	3106548.0
2022-09-07 16:00:00	MSFT	Stock	258.09	258.79	257.92	258.4	4622058.0
2022-09-07 17:00:00	MSFT	Stock	258.35	258.4	258.2778	258.3	3443.0
2022-09-07 18:00:00	MSFT	Stock	258.42	258.5	258.22	258.22	3382.0
2022-09-07 19:00:00	MSFT	Stock	258.28	258.35	258.12	258.12	9882.0
2022-09-07 04:00:00	NVDA	Stock	13.47	13.557	13.47	13.519	234840.0
2022-09-07 05:00:00	NVDA	Stock	13.502	13.508	13.482	13.508	45570.0
2022-09-07 06:00:00	NVDA	Stock	13.515	13.515	13.49	13.499	19720.0
2022-09-07 07:00:00	NVDA	Stock	13.49	13.49	13.4	13.459	496110.0
2022-09-07 08:00:00	NVDA	Stock	13.49	13.515	13.41	13.515	1302980.0
2022-09-07 09:00:00	NVDA	Stock	13.5	13.697	13.396	13.44	64521330.0
2022-09-07 10:00:00	NVDA	Stock	13.44	13.52	13.346	13.437	65846000.0
2022-09-07 11:00:00	NVDA	Stock	13.4345	13.631	13.394	13.593	59538090.0
2022-09-07 12:00:00	NVDA	Stock	13.594	13.604	13.44	13.537	37856330.0
2022-09-07 13:00:00	NVDA	Stock	13.536	13.661	13.524	13.609	38703750.0
2022-09-07 14:00:00	NVDA	Stock	13.609	13.775	13.601	13.762	44709300.0
2022-09-07 15:00:00	NVDA	Stock	13.763	13.838	13.705	13.715	62771820.0
2022-09-07 16:00:00	NVDA	Stock	13.714	13.74	13.7	13.726	27162670.0
2022-09-07 17:00:00	NVDA	Stock	13.722	13.77	13.722	13.754	198260.0
2022-09-07 18:00:00	NVDA	Stock	13.757	13.778	13.746	13.778	305830.0
2022-09-07 19:00:00	NVDA	Stock	13.77	13.785	13.755	13.765	204550.0
2022-09-07 04:00:00	AMZN	Stock	125.97	126.85	125.97	126.5	7738.0
2022-09-07 05:00:00	AMZN	Stock	126.26	126.44	126.22	126.44	2309.0

> showing 50 of 61,207 rows — these rows as CSV

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