PREVIEW / stock_1hour / 2023-04-12

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-04-12.parquet
  size:    1.3 MB
  rows:    60,064
  symbols: 1,760

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
2023-04-12 04:00:00	AAPL	Stock	160.7	160.95	160.7	160.85	20819.0
2023-04-12 05:00:00	AAPL	Stock	160.9	160.9	160.82	160.9	7603.0
2023-04-12 06:00:00	AAPL	Stock	160.98	161.1	160.62	160.62	9718.0
2023-04-12 07:00:00	AAPL	Stock	160.63	160.92	160.62	160.91	7823.0
2023-04-12 08:00:00	AAPL	Stock	160.621	162.3	160.398	161.59	427808.0
2023-04-12 09:00:00	AAPL	Stock	161.6	162.06	160.49	160.98	6167121.0
2023-04-12 10:00:00	AAPL	Stock	160.97	162.05	160.66	160.66	6692049.0
2023-04-12 11:00:00	AAPL	Stock	160.66	161.6582	160.265	161.565	4664161.0
2023-04-12 12:00:00	AAPL	Stock	161.57	161.72	161.36	161.54	3300246.0
2023-04-12 13:00:00	AAPL	Stock	161.54	161.8019	161.23	161.3201	2659359.0
2023-04-12 14:00:00	AAPL	Stock	161.32	161.74	160.41	160.785	4724699.0
2023-04-12 15:00:00	AAPL	Stock	160.7704	160.98	159.78	160.13	8453488.0
2023-04-12 16:00:00	AAPL	Stock	160.13	160.34	160.01	160.06	5476992.0
2023-04-12 17:00:00	AAPL	Stock	160.03	160.04	159.94	159.96	15335.0
2023-04-12 18:00:00	AAPL	Stock	159.98	160.0	159.75	159.76	36713.0
2023-04-12 19:00:00	AAPL	Stock	159.85	159.99	159.75	159.8	17467.0
2023-04-12 04:00:00	MSFT	Stock	282.69	283.23	282.69	283.23	1662.0
2023-04-12 05:00:00	MSFT	Stock	283.0	283.23	282.9	283.1	3331.0
2023-04-12 06:00:00	MSFT	Stock	283.23	283.27	283.01	283.05	2817.0
2023-04-12 07:00:00	MSFT	Stock	283.13	283.5	282.6	283.4	12611.0
2023-04-12 08:00:00	MSFT	Stock	283.7	287.3799	282.5	285.24	208577.0
2023-04-12 09:00:00	MSFT	Stock	285.0038	285.989	281.96	283.3801	3090656.0
2023-04-12 10:00:00	MSFT	Stock	283.37	286.05	283.27	283.28	3470635.0
2023-04-12 11:00:00	MSFT	Stock	283.29	285.25	283.03	285.071	1933110.0
2023-04-12 12:00:00	MSFT	Stock	285.07	286.03	284.91	285.95	1204434.0
2023-04-12 13:00:00	MSFT	Stock	285.95	287.01	285.38	286.35	1621429.0
2023-04-12 14:00:00	MSFT	Stock	286.36	286.83	284.27	284.7363	2414107.0
2023-04-12 15:00:00	MSFT	Stock	284.715	285.05	282.97	283.6	3978514.0
2023-04-12 16:00:00	MSFT	Stock	283.49	283.49	283.0	283.11	3374928.0
2023-04-12 17:00:00	MSFT	Stock	283.06	283.06	282.57	282.78	12762.0
2023-04-12 18:00:00	MSFT	Stock	282.78	282.96	282.67	282.75	16161.0
2023-04-12 19:00:00	MSFT	Stock	282.75	282.98	282.66	282.84	8496.0
2023-04-12 04:00:00	NVDA	Stock	27.101	27.134	27.015	27.101	84690.0
2023-04-12 05:00:00	NVDA	Stock	27.107	27.138	27.068	27.106	60380.0
2023-04-12 06:00:00	NVDA	Stock	27.1	27.1	27.036	27.036	14950.0
2023-04-12 07:00:00	NVDA	Stock	27.051	27.163	27.038	27.154	245920.0
2023-04-12 08:00:00	NVDA	Stock	27.0518	27.513	26.995	27.39	3565920.0
2023-04-12 09:00:00	NVDA	Stock	27.404	27.476	26.654	26.719	61556850.0
2023-04-12 10:00:00	NVDA	Stock	26.719	26.933	26.565	26.609	68284400.0
2023-04-12 11:00:00	NVDA	Stock	26.611	26.936	26.517	26.888	45053610.0
2023-04-12 12:00:00	NVDA	Stock	26.89	26.999	26.885	26.9425	34042060.0
2023-04-12 13:00:00	NVDA	Stock	26.942	27.017	26.815	26.85	29646340.0
2023-04-12 14:00:00	NVDA	Stock	26.8515	26.911	26.6095	26.6475	40571680.0
2023-04-12 15:00:00	NVDA	Stock	26.645	26.648	26.4475	26.501	54733830.0
2023-04-12 16:00:00	NVDA	Stock	26.495	26.495	26.404	26.425	15975710.0
2023-04-12 17:00:00	NVDA	Stock	26.41	26.437	26.372	26.41	403990.0
2023-04-12 18:00:00	NVDA	Stock	26.415	26.427	26.367	26.37	216490.0
2023-04-12 19:00:00	NVDA	Stock	26.375	26.39	26.32	26.334	505670.0
2023-04-12 04:00:00	AMZN	Stock	99.85	100.15	99.85	99.89	6795.0
2023-04-12 05:00:00	AMZN	Stock	99.92	99.99	99.86	99.99	6779.0

> showing 50 of 60,064 rows — these rows as CSV

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