PREVIEW / stock_1hour / 2022-08-30

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-08-30.parquet
  size:    1.4 MB
  rows:    61,696
  symbols: 2,196

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-30 04:00:00	AAPL	Stock	161.82	163.34	161.82	162.9	38166.0
2022-08-30 05:00:00	AAPL	Stock	162.99	163.09	162.82	163.08	24324.0
2022-08-30 06:00:00	AAPL	Stock	162.98	163.24	162.98	163.03	11848.0
2022-08-30 07:00:00	AAPL	Stock	163.0	163.1	162.6	162.67	76500.0
2022-08-30 08:00:00	AAPL	Stock	162.67	163.11	162.25	162.34	381058.0
2022-08-30 09:00:00	AAPL	Stock	162.34	162.57	160.97	161.24	7070545.0
2022-08-30 10:00:00	AAPL	Stock	161.25	161.4893	158.2249	159.1611	12559441.0
2022-08-30 11:00:00	AAPL	Stock	159.17	159.4399	158.61	159.2	9027742.0
2022-08-30 12:00:00	AAPL	Stock	159.2	159.66	158.31	158.7803	6097167.0
2022-08-30 13:00:00	AAPL	Stock	158.78	158.8999	157.72	158.49	7446649.0
2022-08-30 14:00:00	AAPL	Stock	158.49	158.815	158.18	158.451	5594413.0
2022-08-30 15:00:00	AAPL	Stock	158.4557	159.425	158.12	158.91	11000131.0
2022-08-30 16:00:00	AAPL	Stock	158.92	159.3	158.91	159.14	5803406.0
2022-08-30 17:00:00	AAPL	Stock	159.14	159.15	158.91	159.1	55193.0
2022-08-30 18:00:00	AAPL	Stock	159.13	159.13	158.92	159.06	30700.0
2022-08-30 19:00:00	AAPL	Stock	159.09	159.09	158.85	158.97	38178.0
2022-08-30 04:00:00	MSFT	Stock	268.3	268.59	268.05	268.4	5225.0
2022-08-30 05:00:00	MSFT	Stock	268.4	268.4	268.0	268.25	1920.0
2022-08-30 06:00:00	MSFT	Stock	268.35	268.4	268.02	268.02	1209.0
2022-08-30 07:00:00	MSFT	Stock	267.88	268.08	267.4	267.41	8716.0
2022-08-30 08:00:00	MSFT	Stock	267.74	268.15	266.48	266.9999	32000.0
2022-08-30 09:00:00	MSFT	Stock	266.67	267.19	265.0	265.4021	1493417.0
2022-08-30 10:00:00	MSFT	Stock	265.33	265.435	260.99	262.33	2201863.0
2022-08-30 11:00:00	MSFT	Stock	262.33	263.34	261.83	262.69	1452388.0
2022-08-30 12:00:00	MSFT	Stock	262.6679	263.625	261.665	262.21	1172694.0
2022-08-30 13:00:00	MSFT	Stock	262.19	262.37	260.66	261.8701	1221025.0
2022-08-30 14:00:00	MSFT	Stock	261.87	262.27	261.15	261.89	1170817.0
2022-08-30 15:00:00	MSFT	Stock	261.86	263.4	261.815	262.97	2462638.0
2022-08-30 16:00:00	MSFT	Stock	263.27	263.49	262.75	263.2	3454877.0
2022-08-30 17:00:00	MSFT	Stock	263.32	263.32	263.12	263.2	2279.0
2022-08-30 18:00:00	MSFT	Stock	263.37	263.38	263.02	263.19	4873.0
2022-08-30 19:00:00	MSFT	Stock	263.2	263.2	262.9	262.9	2324.0
2022-08-30 04:00:00	NVDA	Stock	16.072	16.139	16.01	16.1	191130.0
2022-08-30 05:00:00	NVDA	Stock	16.082	16.13	16.065	16.095	58920.0
2022-08-30 06:00:00	NVDA	Stock	16.119	16.176	16.09	16.115	175140.0
2022-08-30 07:00:00	NVDA	Stock	16.1	16.106	15.98	16.003	303760.0
2022-08-30 08:00:00	NVDA	Stock	16.071	16.106	15.959	15.992	1967590.0
2022-08-30 09:00:00	NVDA	Stock	15.993	16.039	15.678	15.719	59890680.0
2022-08-30 10:00:00	NVDA	Stock	15.719	15.7815	15.316	15.4705	83850820.0
2022-08-30 11:00:00	NVDA	Stock	15.468	15.526	15.373	15.454	56756740.0
2022-08-30 12:00:00	NVDA	Stock	15.45	15.553	15.275	15.33	48157290.0
2022-08-30 13:00:00	NVDA	Stock	15.327	15.352	15.182	15.297	44518670.0
2022-08-30 14:00:00	NVDA	Stock	15.296	15.373	15.26	15.3425	37413900.0
2022-08-30 15:00:00	NVDA	Stock	15.341	15.489	15.333	15.471	69944740.0
2022-08-30 16:00:00	NVDA	Stock	15.471	15.55	15.44	15.51	27357480.0
2022-08-30 17:00:00	NVDA	Stock	15.51	15.511	15.468	15.51	425020.0
2022-08-30 18:00:00	NVDA	Stock	15.51	15.515	15.48	15.5	120450.0
2022-08-30 19:00:00	NVDA	Stock	15.51	15.52	15.485	15.502	173000.0
2022-08-30 04:00:00	AMZN	Stock	130.67	131.92	130.67	131.64	12369.0
2022-08-30 05:00:00	AMZN	Stock	131.45	132.09	131.25	131.85	14667.0

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

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