PREVIEW / stock_1hour / 2022-08-18

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-08-18.parquet
  size:    1.4 MB
  rows:    62,236
  symbols: 2,237

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-18 04:00:00	AAPL	Stock	173.81	173.81	173.25	173.63	65459.0
2022-08-18 05:00:00	AAPL	Stock	173.54	174.15	173.54	174.1	13264.0
2022-08-18 06:00:00	AAPL	Stock	174.15	174.2	173.8	173.95	27963.0
2022-08-18 07:00:00	AAPL	Stock	173.98	174.25	173.86	174.13	67167.0
2022-08-18 08:00:00	AAPL	Stock	173.91	174.39	172.52	173.94	456651.0
2022-08-18 09:00:00	AAPL	Stock	173.94	174.56	173.23	173.415	8218374.0
2022-08-18 10:00:00	AAPL	Stock	173.4	174.35	173.12	174.012	7490157.0
2022-08-18 11:00:00	AAPL	Stock	174.02	174.72	173.58	174.3501	5583958.0
2022-08-18 12:00:00	AAPL	Stock	174.37	174.64	173.56	173.98	5255851.0
2022-08-18 13:00:00	AAPL	Stock	173.975	174.54	173.79	174.32	4706638.0
2022-08-18 14:00:00	AAPL	Stock	174.31	174.49	173.93	174.2599	5131076.0
2022-08-18 15:00:00	AAPL	Stock	174.26	174.9	173.91	174.18	11298744.0
2022-08-18 16:00:00	AAPL	Stock	174.16	174.25	174.0	174.1	4358908.0
2022-08-18 17:00:00	AAPL	Stock	174.1	174.15	173.85	174.01	54628.0
2022-08-18 18:00:00	AAPL	Stock	174.01	174.04	173.88	173.95	36305.0
2022-08-18 19:00:00	AAPL	Stock	173.87	174.12	173.87	174.11	26392.0
2022-08-18 04:00:00	MSFT	Stock	290.05	290.5	289.58	290.49	3836.0
2022-08-18 05:00:00	MSFT	Stock	290.5	290.8	290.37	290.8	906.0
2022-08-18 06:00:00	MSFT	Stock	291.32	291.5	291.32	291.5	490.0
2022-08-18 07:00:00	MSFT	Stock	291.1	291.55	291.1	291.5	10600.0
2022-08-18 08:00:00	MSFT	Stock	291.5	292.19	289.64	291.52	30870.0
2022-08-18 09:00:00	MSFT	Stock	291.71	291.71	289.66	289.915	1193716.0
2022-08-18 10:00:00	MSFT	Stock	289.99	290.92	289.08	290.48	1612672.0
2022-08-18 11:00:00	MSFT	Stock	290.5	291.6	289.9	291.1301	1139551.0
2022-08-18 12:00:00	MSFT	Stock	291.17	291.55	290.15	290.7386	955041.0
2022-08-18 13:00:00	MSFT	Stock	290.73	291.41	290.53	290.93	712235.0
2022-08-18 14:00:00	MSFT	Stock	290.93	291.33	290.51	291.125	925830.0
2022-08-18 15:00:00	MSFT	Stock	291.11	291.91	289.55	290.26	2382478.0
2022-08-18 16:00:00	MSFT	Stock	290.17	290.36	289.54	290.36	2254750.0
2022-08-18 17:00:00	MSFT	Stock	290.25	290.26	290.03	290.03	2703.0
2022-08-18 18:00:00	MSFT	Stock	290.11	290.18	290.06	290.18	5129.0
2022-08-18 19:00:00	MSFT	Stock	290.17	290.23	289.9	290.19	4221.0
2022-08-18 04:00:00	NVDA	Stock	18.2	18.245	18.17	18.229	68000.0
2022-08-18 05:00:00	NVDA	Stock	18.269	18.335	18.254	18.334	38710.0
2022-08-18 06:00:00	NVDA	Stock	18.319	18.335	18.275	18.275	64730.0
2022-08-18 07:00:00	NVDA	Stock	18.271	18.327	18.24	18.32	229300.0
2022-08-18 08:00:00	NVDA	Stock	18.28	18.395	18.175	18.318	1044280.0
2022-08-18 09:00:00	NVDA	Stock	18.325	18.53	18.183	18.4415	51324990.0
2022-08-18 10:00:00	NVDA	Stock	18.44	18.733	18.346	18.709	71741420.0
2022-08-18 11:00:00	NVDA	Stock	18.71	18.865	18.614	18.799	54981380.0
2022-08-18 12:00:00	NVDA	Stock	18.8037	18.85	18.6132	18.682	39288690.0
2022-08-18 13:00:00	NVDA	Stock	18.679	18.838	18.627	18.781	33274050.0
2022-08-18 14:00:00	NVDA	Stock	18.778	18.798	18.685	18.75	26470640.0
2022-08-18 15:00:00	NVDA	Stock	18.747	18.818	18.715	18.773	39987720.0
2022-08-18 16:00:00	NVDA	Stock	18.773	18.819	18.745	18.768	14374210.0
2022-08-18 17:00:00	NVDA	Stock	18.759	18.773	18.754	18.756	113840.0
2022-08-18 18:00:00	NVDA	Stock	18.762	18.768	18.75	18.768	60890.0
2022-08-18 19:00:00	NVDA	Stock	18.752	18.768	18.731	18.768	88840.0
2022-08-18 04:00:00	AMZN	Stock	141.6	141.8	141.33	141.63	4968.0
2022-08-18 05:00:00	AMZN	Stock	141.7	142.34	141.7	142.3	7940.0

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

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