PREVIEW / stock_1hour / 2020-05-04

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-05-04.parquet
  size:    1.2 MB
  rows:    54,609
  symbols: 2,373

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
2020-05-04 04:00:00	AAPL	Stock	72.0625	72.0625	71.7875	72.05	26916.0
2020-05-04 05:00:00	AAPL	Stock	71.965	71.965	71.7675	71.845	28344.0
2020-05-04 06:00:00	AAPL	Stock	71.755	72.0425	71.755	71.8525	33396.0
2020-05-04 07:00:00	AAPL	Stock	71.8	72.45	71.7375	72.23	332944.0
2020-05-04 08:00:00	AAPL	Stock	71.78	72.495	71.755	72.2625	685356.0
2020-05-04 09:00:00	AAPL	Stock	72.2625	72.495	71.5792	72.1762	19116504.0
2020-05-04 10:00:00	AAPL	Stock	72.185	72.8665	72.13	72.5387	19001424.0
2020-05-04 11:00:00	AAPL	Stock	72.5412	73.025	72.47	72.8775	12616720.0
2020-05-04 12:00:00	AAPL	Stock	72.875	73.0225	72.2725	72.4188	11298772.0
2020-05-04 13:00:00	AAPL	Stock	72.424	72.6888	72.0325	72.675	11929884.0
2020-05-04 14:00:00	AAPL	Stock	72.675	72.925	72.4925	72.8875	10333672.0
2020-05-04 15:00:00	AAPL	Stock	72.8825	73.4225	72.7875	73.2925	18839840.0
2020-05-04 16:00:00	AAPL	Stock	73.2925	73.43	73.145	73.225	4949096.0
2020-05-04 17:00:00	AAPL	Stock	73.225	73.2525	73.1775	73.25	47760.0
2020-05-04 18:00:00	AAPL	Stock	73.1925	73.4075	73.1875	73.325	119404.0
2020-05-04 19:00:00	AAPL	Stock	73.335	73.415	73.3	73.415	47236.0
2020-05-04 04:00:00	MSFT	Stock	174.0	174.38	173.75	173.77	9203.0
2020-05-04 05:00:00	MSFT	Stock	173.5	173.5	173.0	173.45	2750.0
2020-05-04 06:00:00	MSFT	Stock	173.47	173.87	173.47	173.75	1314.0
2020-05-04 07:00:00	MSFT	Stock	173.5	173.9	173.04	173.9	52180.0
2020-05-04 08:00:00	MSFT	Stock	173.65	174.25	173.03	173.7	76032.0
2020-05-04 09:00:00	MSFT	Stock	173.72	176.24	173.12	176.14	3747597.0
2020-05-04 10:00:00	MSFT	Stock	176.17	177.53	176.13	177.04	4116948.0
2020-05-04 11:00:00	MSFT	Stock	177.035	178.075	176.9	177.722	3030070.0
2020-05-04 12:00:00	MSFT	Stock	177.73	177.969	176.63	176.94	2531583.0
2020-05-04 13:00:00	MSFT	Stock	176.935	177.776	176.36	177.75	2475440.0
2020-05-04 14:00:00	MSFT	Stock	177.74	178.25	177.02	178.13	2650469.0
2020-05-04 15:00:00	MSFT	Stock	178.12	179.0	178.0	178.84	4833478.0
2020-05-04 16:00:00	MSFT	Stock	178.749	178.9	178.38	178.65	2068098.0
2020-05-04 17:00:00	MSFT	Stock	178.635	178.73	178.5	178.7	24915.0
2020-05-04 18:00:00	MSFT	Stock	178.71	179.2	178.67	178.85	29729.0
2020-05-04 19:00:00	MSFT	Stock	178.85	179.19	178.85	179.0	14258.0
2020-05-04 04:00:00	NVDA	Stock	7.027	7.027	6.975	7.0	154000.0
2020-05-04 05:00:00	NVDA	Stock	6.9765	6.9765	6.97	6.97	22280.0
2020-05-04 06:00:00	NVDA	Stock	6.9825	7.0165	6.9625	7.0103	305640.0
2020-05-04 07:00:00	NVDA	Stock	7.0228	7.0278	6.9875	7.027	468120.0
2020-05-04 08:00:00	NVDA	Stock	7.0118	7.05	6.9875	7.0263	1100520.0
2020-05-04 09:00:00	NVDA	Stock	7.0368	7.1906	7.0032	7.157	49512880.0
2020-05-04 10:00:00	NVDA	Stock	7.1584	7.2292	7.1455	7.1744	57004280.0
2020-05-04 11:00:00	NVDA	Stock	7.1722	7.2628	7.1715	7.25	32328560.0
2020-05-04 12:00:00	NVDA	Stock	7.2505	7.2662	7.1702	7.1792	24805000.0
2020-05-04 13:00:00	NVDA	Stock	7.1808	7.1988	7.148	7.1975	21992840.0
2020-05-04 14:00:00	NVDA	Stock	7.1958	7.2325	7.1812	7.2252	21852880.0
2020-05-04 15:00:00	NVDA	Stock	7.223	7.296	7.2158	7.282	47994200.0
2020-05-04 16:00:00	NVDA	Stock	7.2821	7.2838	7.2662	7.275	2426280.0
2020-05-04 17:00:00	NVDA	Stock	7.2805	7.2805	7.2688	7.27	105520.0
2020-05-04 18:00:00	NVDA	Stock	7.273	7.296	7.2705	7.282	298480.0
2020-05-04 19:00:00	NVDA	Stock	7.2823	7.2875	7.275	7.2838	253960.0
2020-05-04 04:00:00	AMZN	Stock	113.0	113.25	113.0	113.2	42480.0
2020-05-04 06:00:00	AMZN	Stock	113.1985	113.25	113.1	113.2495	28000.0

> showing 50 of 54,609 rows — these rows as CSV

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