PREVIEW / stock_1hour / 2020-09-10

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-09-10.parquet
  size:    1.2 MB
  rows:    56,227
  symbols: 2,464

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-09-10 04:00:00	AAPL	Stock	116.82	117.31	115.69	116.73	74658.0
2020-09-10 05:00:00	AAPL	Stock	116.82	118.2	116.64	118.2	40333.0
2020-09-10 06:00:00	AAPL	Stock	118.2	118.6	116.6	117.1	87124.0
2020-09-10 07:00:00	AAPL	Stock	117.31	119.15	117.1	118.95	441584.0
2020-09-10 08:00:00	AAPL	Stock	117.79	120.48	117.22	120.25	1811469.0
2020-09-10 09:00:00	AAPL	Stock	120.28	120.64	118.12	118.963	21486658.0
2020-09-10 10:00:00	AAPL	Stock	118.97	119.64	116.03	116.145	25017475.0
2020-09-10 11:00:00	AAPL	Stock	116.145	117.7	115.56	116.89	18628908.0
2020-09-10 12:00:00	AAPL	Stock	116.89	117.37	115.81	116.445	14574560.0
2020-09-10 13:00:00	AAPL	Stock	116.43	116.9	115.2	115.27	13387690.0
2020-09-10 14:00:00	AAPL	Stock	115.27	115.86	112.962	114.202	24495211.0
2020-09-10 15:00:00	AAPL	Stock	114.2	114.26	112.5	113.48	29716320.0
2020-09-10 16:00:00	AAPL	Stock	113.42	114.0	113.36	113.69	9266085.0
2020-09-10 17:00:00	AAPL	Stock	113.699	114.18	113.55	114.1	308382.0
2020-09-10 18:00:00	AAPL	Stock	114.04	114.34	113.86	114.13	354227.0
2020-09-10 19:00:00	AAPL	Stock	114.11	114.5	114.04	114.1	360899.0
2020-09-10 04:00:00	MSFT	Stock	210.1	210.1	208.0	209.54	11286.0
2020-09-10 05:00:00	MSFT	Stock	209.5	210.78	209.5	210.78	9750.0
2020-09-10 06:00:00	MSFT	Stock	211.44	212.35	209.87	209.9	11767.0
2020-09-10 07:00:00	MSFT	Stock	210.81	211.6	210.0	211.1	47399.0
2020-09-10 08:00:00	MSFT	Stock	210.51	212.99	210.1	212.74	136582.0
2020-09-10 09:00:00	MSFT	Stock	212.93	214.74	210.77	212.125	4101281.0
2020-09-10 10:00:00	MSFT	Stock	212.14	213.2	209.2	209.735	3693745.0
2020-09-10 11:00:00	MSFT	Stock	209.74	211.67	209.02	210.22	2770183.0
2020-09-10 12:00:00	MSFT	Stock	210.22	210.78	207.85	209.21	2372445.0
2020-09-10 13:00:00	MSFT	Stock	209.215	209.9	208.0	208.21	1604880.0
2020-09-10 14:00:00	MSFT	Stock	208.19	208.69	204.95	206.65	3828878.0
2020-09-10 15:00:00	MSFT	Stock	206.66	206.78	204.11	205.38	5468820.0
2020-09-10 16:00:00	MSFT	Stock	205.37	206.02	205.18	205.72	4242546.0
2020-09-10 17:00:00	MSFT	Stock	205.62	207.95	205.4	206.83	35940.0
2020-09-10 18:00:00	MSFT	Stock	206.81	206.99	206.2	206.85	47552.0
2020-09-10 19:00:00	MSFT	Stock	206.82	206.82	206.4	206.7	18441.0
2020-09-10 04:00:00	NVDA	Stock	12.6325	12.658	12.477	12.6375	445080.0
2020-09-10 05:00:00	NVDA	Stock	12.6	12.75	12.6	12.75	246320.0
2020-09-10 06:00:00	NVDA	Stock	12.7805	12.7955	12.6285	12.6665	480720.0
2020-09-10 07:00:00	NVDA	Stock	12.691	12.8732	12.675	12.8495	1371000.0
2020-09-10 08:00:00	NVDA	Stock	12.7322	13.0188	12.6625	12.9975	4844120.0
2020-09-10 09:00:00	NVDA	Stock	12.9875	13.0652	12.79	12.8606	98670240.0
2020-09-10 10:00:00	NVDA	Stock	12.861	12.9748	12.6558	12.6628	113738520.0
2020-09-10 11:00:00	NVDA	Stock	12.6632	12.7853	12.6054	12.673	65058000.0
2020-09-10 12:00:00	NVDA	Stock	12.6825	12.7025	12.5305	12.626	48886840.0
2020-09-10 13:00:00	NVDA	Stock	12.6258	12.6748	12.558	12.5655	39633720.0
2020-09-10 14:00:00	NVDA	Stock	12.5691	12.5907	12.253	12.3778	87079120.0
2020-09-10 15:00:00	NVDA	Stock	12.384	12.388	12.167	12.312	89139760.0
2020-09-10 16:00:00	NVDA	Stock	12.3118	12.3375	12.2713	12.31	25087040.0
2020-09-10 17:00:00	NVDA	Stock	12.312	12.3625	12.283	12.3625	315240.0
2020-09-10 18:00:00	NVDA	Stock	12.355	12.4062	12.3408	12.4062	647960.0
2020-09-10 19:00:00	NVDA	Stock	12.4	12.425	12.3855	12.4	736400.0
2020-09-10 04:00:00	AMZN	Stock	162.5	162.5	162.35	162.35	4360.0
2020-09-10 05:00:00	AMZN	Stock	163.4	163.4	163.4	163.4	2000.0

> showing 50 of 56,227 rows — these rows as CSV

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