PREVIEW / stock_1hour / 2021-07-15

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-07-15.parquet
  size:    1.4 MB
  rows:    65,311
  symbols: 2,878

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-07-15 04:00:00	AAPL	Stock	149.67	149.95	149.51	149.95	60281.0
2021-07-15 05:00:00	AAPL	Stock	149.95	150.0	149.65	149.87	34360.0
2021-07-15 06:00:00	AAPL	Stock	149.84	149.85	149.22	149.4	30266.0
2021-07-15 07:00:00	AAPL	Stock	149.4	149.59	148.83	149.23	269132.0
2021-07-15 08:00:00	AAPL	Stock	149.15	149.57	148.778	149.3	749668.0
2021-07-15 09:00:00	AAPL	Stock	149.32	150.0	148.12	149.775	16852141.0
2021-07-15 10:00:00	AAPL	Stock	149.78	149.8	147.91	148.185	18577162.0
2021-07-15 11:00:00	AAPL	Stock	148.19	148.88	147.795	148.13	11659546.0
2021-07-15 12:00:00	AAPL	Stock	148.12	148.24	147.43	147.9001	9873389.0
2021-07-15 13:00:00	AAPL	Stock	147.9	148.08	147.09	147.315	8350772.0
2021-07-15 14:00:00	AAPL	Stock	147.315	148.01	147.28	147.99	8388696.0
2021-07-15 15:00:00	AAPL	Stock	147.995	148.53	147.91	148.48	13001146.0
2021-07-15 16:00:00	AAPL	Stock	148.48	148.48	148.26	148.29	6159167.0
2021-07-15 17:00:00	AAPL	Stock	148.3	148.37	148.28	148.3	30323.0
2021-07-15 18:00:00	AAPL	Stock	148.3	148.42	148.19	148.3	40956.0
2021-07-15 19:00:00	AAPL	Stock	148.31	148.33	148.05	148.07	50968.0
2021-07-15 04:00:00	MSFT	Stock	282.84	284.25	282.53	284.25	3427.0
2021-07-15 05:00:00	MSFT	Stock	284.18	284.18	283.6	283.82	5497.0
2021-07-15 06:00:00	MSFT	Stock	283.8	283.8	282.7	283.11	19586.0
2021-07-15 07:00:00	MSFT	Stock	283.2	283.2	281.56	282.17	31495.0
2021-07-15 08:00:00	MSFT	Stock	282.15	283.216	281.92	282.2	26737.0
2021-07-15 09:00:00	MSFT	Stock	282.17	282.55	280.86	281.73	2144147.0
2021-07-15 10:00:00	MSFT	Stock	281.76	281.84	279.83	280.59	3056168.0
2021-07-15 11:00:00	MSFT	Stock	280.58	281.61	280.22	280.77	1698210.0
2021-07-15 12:00:00	MSFT	Stock	280.755	281.99	280.13	281.705	1520182.0
2021-07-15 13:00:00	MSFT	Stock	281.68	281.74	280.28	280.36	1644511.0
2021-07-15 14:00:00	MSFT	Stock	280.355	281.28	280.18	281.1701	1442258.0
2021-07-15 15:00:00	MSFT	Stock	281.176	281.31	280.19	281.06	2916063.0
2021-07-15 16:00:00	MSFT	Stock	281.03	281.05	280.72	280.78	2648360.0
2021-07-15 17:00:00	MSFT	Stock	280.75	280.9	280.71	280.9	4703.0
2021-07-15 18:00:00	MSFT	Stock	280.85	280.99	280.85	280.85	3444.0
2021-07-15 19:00:00	MSFT	Stock	280.875	280.875	280.55	280.55	3301.0
2021-07-15 04:00:00	NVDA	Stock	19.9	19.9365	19.9	19.9365	18640.0
2021-07-15 05:00:00	NVDA	Stock	19.972	19.975	19.95	19.95	92960.0
2021-07-15 06:00:00	NVDA	Stock	19.9275	19.9275	19.8285	19.8375	136560.0
2021-07-15 07:00:00	NVDA	Stock	19.8623	19.863	19.7255	19.8378	768760.0
2021-07-15 08:00:00	NVDA	Stock	19.875	19.9115	19.722	19.875	1072360.0
2021-07-15 09:00:00	NVDA	Stock	19.89	19.8968	19.3852	19.6548	49907360.0
2021-07-15 10:00:00	NVDA	Stock	19.6625	19.6654	19.3378	19.3888	37292280.0
2021-07-15 11:00:00	NVDA	Stock	19.3833	19.4935	19.2744	19.2752	29908800.0
2021-07-15 12:00:00	NVDA	Stock	19.2775	19.2842	19.1305	19.1576	47282040.0
2021-07-15 13:00:00	NVDA	Stock	19.1605	19.172	18.878	18.8886	59985200.0
2021-07-15 14:00:00	NVDA	Stock	18.885	19.0093	18.8585	18.9638	39317000.0
2021-07-15 15:00:00	NVDA	Stock	18.9638	19.0485	18.9008	18.9692	51296120.0
2021-07-15 16:00:00	NVDA	Stock	18.9608	18.9662	18.9138	18.9138	21308040.0
2021-07-15 17:00:00	NVDA	Stock	18.9212	18.9325	18.9188	18.923	251920.0
2021-07-15 18:00:00	NVDA	Stock	18.9238	18.9238	18.9018	18.9125	196120.0
2021-07-15 19:00:00	NVDA	Stock	18.9015	18.9248	18.8402	18.8625	283200.0
2021-07-15 06:00:00	AMZN	Stock	185.0	185.0	184.5	184.5	14740.0
2021-07-15 07:00:00	AMZN	Stock	184.5	184.7125	184.0	184.0	113460.0

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

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