PREVIEW / stock_1hour / 2023-03-15

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-03-15.parquet
  size:    1.4 MB
  rows:    62,441
  symbols: 1,739

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-03-15 04:00:00	AAPL	Stock	152.87	152.98	152.46	152.7	10668.0
2023-03-15 05:00:00	AAPL	Stock	152.71	152.71	151.75	151.81	16123.0
2023-03-15 06:00:00	AAPL	Stock	151.93	151.93	150.38	150.48	62600.0
2023-03-15 07:00:00	AAPL	Stock	150.58	151.05	150.5	150.75	82131.0
2023-03-15 08:00:00	AAPL	Stock	150.77	152.94	150.0	150.66	372149.0
2023-03-15 09:00:00	AAPL	Stock	150.65	151.8	150.42	151.21	7755935.0
2023-03-15 10:00:00	AAPL	Stock	151.22	151.6502	149.92	150.92	9361759.0
2023-03-15 11:00:00	AAPL	Stock	150.94	151.8484	150.56	151.17	7010266.0
2023-03-15 12:00:00	AAPL	Stock	151.16	151.35	150.435	150.585	5074680.0
2023-03-15 13:00:00	AAPL	Stock	150.585	152.33	150.5	152.13	6467486.0
2023-03-15 14:00:00	AAPL	Stock	152.14	153.09	151.48	152.87	7125539.0
2023-03-15 15:00:00	AAPL	Stock	152.88	153.245	151.62	152.99	10948573.0
2023-03-15 16:00:00	AAPL	Stock	153.0	153.31	151.7075	152.8	11309159.0
2023-03-15 17:00:00	AAPL	Stock	152.79	152.84	152.66	152.77	27698.0
2023-03-15 18:00:00	AAPL	Stock	152.77	152.95	152.61	152.73	32745.0
2023-03-15 19:00:00	AAPL	Stock	152.75	152.94	152.67	152.7	27098.0
2023-03-15 04:00:00	MSFT	Stock	261.3	261.89	260.89	261.49	7043.0
2023-03-15 05:00:00	MSFT	Stock	261.19	261.33	259.06	259.25	12123.0
2023-03-15 06:00:00	MSFT	Stock	259.3	259.34	256.75	257.4	24437.0
2023-03-15 07:00:00	MSFT	Stock	257.4	258.2	256.0	258.2	44257.0
2023-03-15 08:00:00	MSFT	Stock	257.4381	261.0	256.181	257.7289	80188.0
2023-03-15 09:00:00	MSFT	Stock	257.7	263.59	257.0824	262.39	4488695.0
2023-03-15 10:00:00	MSFT	Stock	262.3	264.88	261.6	264.7549	5647465.0
2023-03-15 11:00:00	MSFT	Stock	264.77	264.79	263.21	264.09	4185112.0
2023-03-15 12:00:00	MSFT	Stock	264.11	264.31	261.16	261.88	2861809.0
2023-03-15 13:00:00	MSFT	Stock	261.88	264.41	261.61	263.86	2898343.0
2023-03-15 14:00:00	MSFT	Stock	263.86	266.3	263.02	266.1118	3117036.0
2023-03-15 15:00:00	MSFT	Stock	266.11	266.48	263.73	265.47	5235109.0
2023-03-15 16:00:00	MSFT	Stock	265.49	266.19	265.22	265.82	6712830.0
2023-03-15 17:00:00	MSFT	Stock	265.79	266.09	265.76	266.07	15615.0
2023-03-15 18:00:00	MSFT	Stock	266.1	266.36	265.44	266.2	23854.0
2023-03-15 19:00:00	MSFT	Stock	266.33	266.36	265.8	266.1	11321.0
2023-03-15 04:00:00	NVDA	Stock	24.126	24.271	24.11	24.23	273230.0
2023-03-15 05:00:00	NVDA	Stock	24.228	24.228	23.97	23.97	269920.0
2023-03-15 06:00:00	NVDA	Stock	24.0	24.0	23.512	23.573	545820.0
2023-03-15 07:00:00	NVDA	Stock	23.56	23.746	23.55	23.72	958150.0
2023-03-15 08:00:00	NVDA	Stock	23.662	24.194	23.584	23.79	3147190.0
2023-03-15 09:00:00	NVDA	Stock	23.8	23.904	23.514	23.566	51349670.0
2023-03-15 10:00:00	NVDA	Stock	23.559	23.656	23.36	23.542	60655620.0
2023-03-15 11:00:00	NVDA	Stock	23.544	23.836	23.479	23.6219	47627860.0
2023-03-15 12:00:00	NVDA	Stock	23.619	23.685	23.424	23.532	35935630.0
2023-03-15 13:00:00	NVDA	Stock	23.528	23.895	23.486	23.831	56535270.0
2023-03-15 14:00:00	NVDA	Stock	23.8307	24.2356	23.743	24.1839	62689080.0
2023-03-15 15:00:00	NVDA	Stock	24.1868	24.286	23.907	24.23	60275140.0
2023-03-15 16:00:00	NVDA	Stock	24.228	24.28	24.1633	24.235	28348570.0
2023-03-15 17:00:00	NVDA	Stock	24.235	24.295	24.22	24.23	401120.0
2023-03-15 18:00:00	NVDA	Stock	24.228	24.345	24.228	24.322	287900.0
2023-03-15 19:00:00	NVDA	Stock	24.34	24.4	24.281	24.35	481630.0
2023-03-15 04:00:00	AMZN	Stock	94.62	95.09	94.56	94.76	18897.0
2023-03-15 05:00:00	AMZN	Stock	94.61	94.67	93.96	94.1	21240.0

> showing 50 of 62,441 rows — these rows as CSV

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