PREVIEW / stock_1hour / 2021-06-04

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-06-04.parquet
  size:    1.4 MB
  rows:    64,434
  symbols: 2,962

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
2021-06-04 04:00:00	AAPL	Stock	123.52	123.6	123.45	123.45	2569.0
2021-06-04 05:00:00	AAPL	Stock	123.5	123.72	123.5	123.72	5908.0
2021-06-04 06:00:00	AAPL	Stock	123.77	123.77	123.31	123.7	6513.0
2021-06-04 07:00:00	AAPL	Stock	123.67	123.98	123.66	123.98	91062.0
2021-06-04 08:00:00	AAPL	Stock	123.7299	124.28	123.232	124.15	729396.0
2021-06-04 09:00:00	AAPL	Stock	124.15	125.0	123.85	124.925	10198059.0
2021-06-04 10:00:00	AAPL	Stock	124.9244	125.36	124.76	124.9699	10584225.0
2021-06-04 11:00:00	AAPL	Stock	124.965	125.385	124.87	125.1	6280483.0
2021-06-04 12:00:00	AAPL	Stock	125.11	125.95	124.98	125.6499	8639456.0
2021-06-04 13:00:00	AAPL	Stock	125.65	125.79	125.48	125.68	4306560.0
2021-06-04 14:00:00	AAPL	Stock	125.6825	126.16	125.62	126.0547	5322509.0
2021-06-04 15:00:00	AAPL	Stock	126.05	126.06	125.495	125.88	10415257.0
2021-06-04 16:00:00	AAPL	Stock	125.89	126.0	125.78	125.98	7962650.0
2021-06-04 17:00:00	AAPL	Stock	125.98	126.0	125.92	125.99	49019.0
2021-06-04 18:00:00	AAPL	Stock	125.99	126.01	125.8901	125.95	41806.0
2021-06-04 19:00:00	AAPL	Stock	125.95	126.01	125.9	126.01	48372.0
2021-06-04 04:00:00	MSFT	Stock	245.66	245.66	245.66	245.66	203.0
2021-06-04 07:00:00	MSFT	Stock	245.73	246.34	245.71	246.18	5087.0
2021-06-04 08:00:00	MSFT	Stock	246.18	247.46	245.0	247.25	68255.0
2021-06-04 09:00:00	MSFT	Stock	247.25	249.55	247.02	248.95	2862891.0
2021-06-04 10:00:00	MSFT	Stock	248.93	250.69	248.93	250.39	2840748.0
2021-06-04 11:00:00	MSFT	Stock	250.41	251.65	250.21	251.22	2166318.0
2021-06-04 12:00:00	MSFT	Stock	251.23	251.3	250.77	250.82	1286162.0
2021-06-04 13:00:00	MSFT	Stock	250.83	251.02	250.6019	250.98	985819.0
2021-06-04 14:00:00	MSFT	Stock	250.99	251.4	250.94	251.17	1371853.0
2021-06-04 15:00:00	MSFT	Stock	251.17	251.22	250.55	250.78	3317277.0
2021-06-04 16:00:00	MSFT	Stock	250.77	250.81	250.5	250.62	3707722.0
2021-06-04 17:00:00	MSFT	Stock	250.62	250.64	250.6	250.62	2687.0
2021-06-04 18:00:00	MSFT	Stock	250.64	250.65	250.61	250.65	1201.0
2021-06-04 19:00:00	MSFT	Stock	250.65	250.89	250.65	250.89	2441.0
2021-06-04 04:00:00	NVDA	Stock	17.0095	17.0165	17.0095	17.0165	11360.0
2021-06-04 05:00:00	NVDA	Stock	17.0028	17.0125	17.0028	17.0125	8000.0
2021-06-04 06:00:00	NVDA	Stock	16.9625	16.9625	16.9625	16.9625	11800.0
2021-06-04 07:00:00	NVDA	Stock	17.012	17.075	17.012	17.0702	397920.0
2021-06-04 08:00:00	NVDA	Stock	17.0623	17.15	17.012	17.0778	1595680.0
2021-06-04 09:00:00	NVDA	Stock	17.0875	17.4975	17.0595	17.4838	83535320.0
2021-06-04 10:00:00	NVDA	Stock	17.4884	17.58	17.375	17.5455	68711400.0
2021-06-04 11:00:00	NVDA	Stock	17.5485	17.661	17.5335	17.6378	51493280.0
2021-06-04 12:00:00	NVDA	Stock	17.6385	17.6452	17.5275	17.583	43446760.0
2021-06-04 13:00:00	NVDA	Stock	17.5818	17.66	17.556	17.628	31779160.0
2021-06-04 14:00:00	NVDA	Stock	17.632	17.6488	17.5368	17.5455	27904280.0
2021-06-04 15:00:00	NVDA	Stock	17.5468	17.6278	17.5115	17.5768	52425400.0
2021-06-04 16:00:00	NVDA	Stock	17.5782	17.5998	17.5628	17.5825	18460200.0
2021-06-04 17:00:00	NVDA	Stock	17.5833	17.599	17.5825	17.5925	180080.0
2021-06-04 18:00:00	NVDA	Stock	17.5895	17.5938	17.5895	17.59	107720.0
2021-06-04 19:00:00	NVDA	Stock	17.5938	17.5975	17.5875	17.5925	355000.0
2021-06-04 06:00:00	AMZN	Stock	159.0	159.2315	158.992	159.2315	8000.0
2021-06-04 07:00:00	AMZN	Stock	159.498	160.0875	159.498	159.8885	175880.0
2021-06-04 08:00:00	AMZN	Stock	159.875	160.413	158.8635	160.15	252640.0
2021-06-04 09:00:00	AMZN	Stock	160.15	160.941	160.0995	160.5665	4169460.0

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

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