PREVIEW / stock_1hour / 2022-09-09

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-09-09.parquet
  size:    1.4 MB
  rows:    61,506
  symbols: 2,203

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-09-09 04:00:00	AAPL	Stock	155.3	155.88	155.3	155.86	63013.0
2022-09-09 05:00:00	AAPL	Stock	155.83	156.0	155.68	155.8	12750.0
2022-09-09 06:00:00	AAPL	Stock	155.75	156.37	155.75	156.09	58381.0
2022-09-09 07:00:00	AAPL	Stock	156.1	156.1	155.53	155.63	122974.0
2022-09-09 08:00:00	AAPL	Stock	155.98	156.035	154.46	155.62	378392.0
2022-09-09 09:00:00	AAPL	Stock	155.62	156.08	154.75	156.08	8748157.0
2022-09-09 10:00:00	AAPL	Stock	156.07	156.84	155.91	156.645	9717722.0
2022-09-09 11:00:00	AAPL	Stock	156.65	157.18	156.465	156.85	6245061.0
2022-09-09 12:00:00	AAPL	Stock	156.86	156.9397	156.09	156.855	5349710.0
2022-09-09 13:00:00	AAPL	Stock	156.855	157.34	156.7	157.08	4579794.0
2022-09-09 14:00:00	AAPL	Stock	157.075	157.52	156.77	157.16	5105288.0
2022-09-09 15:00:00	AAPL	Stock	157.16	157.82	157.0508	157.35	10181263.0
2022-09-09 16:00:00	AAPL	Stock	157.34	157.55	157.2803	157.5	7193417.0
2022-09-09 17:00:00	AAPL	Stock	157.49	157.55	157.44	157.48	49841.0
2022-09-09 18:00:00	AAPL	Stock	157.47	157.48	157.44	157.44	14693.0
2022-09-09 19:00:00	AAPL	Stock	157.44	157.54	157.42	157.5	26388.0
2022-09-09 04:00:00	MSFT	Stock	260.96	261.87	260.41	261.43	8147.0
2022-09-09 05:00:00	MSFT	Stock	261.55	261.93	261.01	261.35	2742.0
2022-09-09 06:00:00	MSFT	Stock	261.16	261.81	261.16	261.8	2660.0
2022-09-09 07:00:00	MSFT	Stock	261.75	261.8	260.88	261.04	15524.0
2022-09-09 08:00:00	MSFT	Stock	261.65	261.75	257.874	261.28	34918.0
2022-09-09 09:00:00	MSFT	Stock	261.11	262.95	260.08	262.4	1858078.0
2022-09-09 10:00:00	MSFT	Stock	262.41	265.17	262.23	264.83	2506560.0
2022-09-09 11:00:00	MSFT	Stock	264.83	265.06	263.27	263.81	1581386.0
2022-09-09 12:00:00	MSFT	Stock	263.8	264.035	262.73	263.98	1312735.0
2022-09-09 13:00:00	MSFT	Stock	264.0186	264.46	263.54	264.26	1100876.0
2022-09-09 14:00:00	MSFT	Stock	264.26	264.59	263.99	264.41	1130205.0
2022-09-09 15:00:00	MSFT	Stock	264.395	265.23	264.1	264.44	2960868.0
2022-09-09 16:00:00	MSFT	Stock	264.43	264.66	264.1	264.35	3791726.0
2022-09-09 17:00:00	MSFT	Stock	264.47	264.5	264.36	264.4395	1913.0
2022-09-09 18:00:00	MSFT	Stock	264.35	264.48	264.33	264.33	3312.0
2022-09-09 19:00:00	MSFT	Stock	264.33	264.4	264.29	264.32	988.0
2022-09-09 04:00:00	NVDA	Stock	14.062	14.19	14.062	14.19	172890.0
2022-09-09 05:00:00	NVDA	Stock	14.181	14.2	14.165	14.178	101560.0
2022-09-09 06:00:00	NVDA	Stock	14.189	14.228	14.179	14.207	129950.0
2022-09-09 07:00:00	NVDA	Stock	14.201	14.21	14.171	14.203	236270.0
2022-09-09 08:00:00	NVDA	Stock	14.2	14.288	14.1501	14.26	1878880.0
2022-09-09 09:00:00	NVDA	Stock	14.26	14.333	14.126	14.326	63057400.0
2022-09-09 10:00:00	NVDA	Stock	14.328	14.395	14.221	14.348	76926850.0
2022-09-09 11:00:00	NVDA	Stock	14.347	14.445	14.275	14.406	49475740.0
2022-09-09 12:00:00	NVDA	Stock	14.406	14.4325	14.311	14.417	47314280.0
2022-09-09 13:00:00	NVDA	Stock	14.418	14.474	14.384	14.413	37308350.0
2022-09-09 14:00:00	NVDA	Stock	14.411	14.415	14.316	14.352	40792760.0
2022-09-09 15:00:00	NVDA	Stock	14.351	14.4411	14.338	14.388	56091100.0
2022-09-09 16:00:00	NVDA	Stock	14.391	14.394	14.36	14.38	20506390.0
2022-09-09 17:00:00	NVDA	Stock	14.379	14.385	14.378	14.38	142000.0
2022-09-09 18:00:00	NVDA	Stock	14.383	14.383	14.36	14.365	205390.0
2022-09-09 19:00:00	NVDA	Stock	14.37	14.382	14.363	14.371	198240.0
2022-09-09 04:00:00	AMZN	Stock	130.52	131.2	130.52	131.01	8740.0
2022-09-09 05:00:00	AMZN	Stock	131.15	131.25	131.03	131.1	2842.0

> showing 50 of 61,506 rows — these rows as CSV

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