PREVIEW / stock_1hour / 2022-08-15

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-08-15.parquet
  size:    1.4 MB
  rows:    64,626
  symbols: 2,278

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-15 04:00:00	AAPL	Stock	171.37	171.39	170.81	171.1	13832.0
2022-08-15 05:00:00	AAPL	Stock	171.14	171.15	170.75	171.09	12866.0
2022-08-15 06:00:00	AAPL	Stock	171.09	171.41	171.02	171.39	13511.0
2022-08-15 07:00:00	AAPL	Stock	171.46	171.68	171.12	171.37	62659.0
2022-08-15 08:00:00	AAPL	Stock	171.4	171.71	170.9	171.04	537536.0
2022-08-15 09:00:00	AAPL	Stock	171.02	172.38	171.01	172.1701	7515598.0
2022-08-15 10:00:00	AAPL	Stock	172.18	172.46	171.655	171.83	6205456.0
2022-08-15 11:00:00	AAPL	Stock	171.83	173.25	171.67	173.025	5751270.0
2022-08-15 12:00:00	AAPL	Stock	173.03	173.3	172.75	173.11	4234605.0
2022-08-15 13:00:00	AAPL	Stock	173.115	173.27	172.91	173.1112	2937635.0
2022-08-15 14:00:00	AAPL	Stock	173.11	173.13	172.83	172.995	3176396.0
2022-08-15 15:00:00	AAPL	Stock	173.0	173.39	172.92	173.19	6938652.0
2022-08-15 16:00:00	AAPL	Stock	173.19	173.2	172.92	172.99	4723228.0
2022-08-15 17:00:00	AAPL	Stock	173.0	173.19	172.96	173.0786	90186.0
2022-08-15 18:00:00	AAPL	Stock	173.01	173.06	172.96	172.96	20824.0
2022-08-15 19:00:00	AAPL	Stock	172.98	173.15	172.96	173.15	26212.0
2022-08-15 04:00:00	MSFT	Stock	291.49	291.49	290.12	290.4	1387.0
2022-08-15 05:00:00	MSFT	Stock	290.42	290.42	290.2	290.2	1120.0
2022-08-15 06:00:00	MSFT	Stock	291.08	291.87	291.08	291.5	2059.0
2022-08-15 07:00:00	MSFT	Stock	291.61	291.67	290.5	290.5	8582.0
2022-08-15 08:00:00	MSFT	Stock	291.7392	291.74	290.25	290.55	33081.0
2022-08-15 09:00:00	MSFT	Stock	290.54	292.6799	290.45	292.12	1620918.0
2022-08-15 10:00:00	MSFT	Stock	292.17	292.2	290.11	290.5	1434231.0
2022-08-15 11:00:00	MSFT	Stock	290.48	292.8	290.22	292.68	1175135.0
2022-08-15 12:00:00	MSFT	Stock	292.7	292.95	292.27	292.8	839452.0
2022-08-15 13:00:00	MSFT	Stock	292.8	293.25	292.57	293.18	696069.0
2022-08-15 14:00:00	MSFT	Stock	293.19	294.18	292.86	293.907	1136427.0
2022-08-15 15:00:00	MSFT	Stock	293.891	294.01	293.04	293.53	1932320.0
2022-08-15 16:00:00	MSFT	Stock	293.52	293.52	293.21	293.21	2770177.0
2022-08-15 17:00:00	MSFT	Stock	293.22	293.3984	293.22	293.2601	2434.0
2022-08-15 18:00:00	MSFT	Stock	293.3	293.46	293.3	293.46	781.0
2022-08-15 19:00:00	MSFT	Stock	293.4	293.61	293.4	293.61	7194.0
2022-08-15 04:00:00	NVDA	Stock	18.719	18.719	18.547	18.578	77940.0
2022-08-15 05:00:00	NVDA	Stock	18.56	18.578	18.505	18.54	47010.0
2022-08-15 06:00:00	NVDA	Stock	18.545	18.609	18.543	18.609	45900.0
2022-08-15 07:00:00	NVDA	Stock	18.625	18.678	18.613	18.62	145730.0
2022-08-15 08:00:00	NVDA	Stock	18.655	18.675	18.5391	18.61	916610.0
2022-08-15 09:00:00	NVDA	Stock	18.609	19.0548	18.6	18.941	60315640.0
2022-08-15 10:00:00	NVDA	Stock	18.941	18.954	18.619	18.663	65232730.0
2022-08-15 11:00:00	NVDA	Stock	18.6638	18.914	18.613	18.865	49517070.0
2022-08-15 12:00:00	NVDA	Stock	18.867	18.905	18.7653	18.869	35325430.0
2022-08-15 13:00:00	NVDA	Stock	18.869	18.928	18.82	18.872	34397930.0
2022-08-15 14:00:00	NVDA	Stock	18.873	18.908	18.759	18.8936	35907510.0
2022-08-15 15:00:00	NVDA	Stock	18.895	19.164	18.886	19.031	77194430.0
2022-08-15 16:00:00	NVDA	Stock	19.031	19.068	18.994	19.02	14600720.0
2022-08-15 17:00:00	NVDA	Stock	19.018	19.034	19.013	19.017	106980.0
2022-08-15 18:00:00	NVDA	Stock	19.014	19.019	19.01	19.019	184930.0
2022-08-15 19:00:00	NVDA	Stock	19.015	19.023	19.007	19.021	208830.0
2022-08-15 04:00:00	AMZN	Stock	143.1	143.1	142.0	142.35	11380.0
2022-08-15 05:00:00	AMZN	Stock	142.46	142.59	142.3	142.56	8736.0

> showing 50 of 64,626 rows — these rows as CSV

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