PREVIEW / stock_1hour / 2020-09-23

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-09-23.parquet
  size:    1.2 MB
  rows:    57,219
  symbols: 2,512

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-23 04:00:00	AAPL	Stock	111.15	112.2	111.15	112.19	62053.0
2020-09-23 05:00:00	AAPL	Stock	112.17	112.61	112.17	112.48	53355.0
2020-09-23 06:00:00	AAPL	Stock	112.42	112.49	111.79	112.03	42976.0
2020-09-23 07:00:00	AAPL	Stock	112.15	112.19	111.04	111.11	443824.0
2020-09-23 08:00:00	AAPL	Stock	111.11	112.0	110.81	111.25	908124.0
2020-09-23 09:00:00	AAPL	Stock	111.25	112.11	110.6	110.891	14323608.0
2020-09-23 10:00:00	AAPL	Stock	110.87	111.32	110.01	110.48	18778085.0
2020-09-23 11:00:00	AAPL	Stock	110.485	110.92	109.71	109.82	15096024.0
2020-09-23 12:00:00	AAPL	Stock	109.81	110.18	109.04	110.048	13639776.0
2020-09-23 13:00:00	AAPL	Stock	110.045	110.07	108.5	108.75	12836017.0
2020-09-23 14:00:00	AAPL	Stock	108.745	108.75	107.45	107.68	17419398.0
2020-09-23 15:00:00	AAPL	Stock	107.689	108.03	106.77	107.23	26456379.0
2020-09-23 16:00:00	AAPL	Stock	107.24	107.39	106.77	106.85	13725580.0
2020-09-23 17:00:00	AAPL	Stock	106.87	106.92	105.8	106.24	543607.0
2020-09-23 18:00:00	AAPL	Stock	106.23	106.9	106.15	106.43	404124.0
2020-09-23 19:00:00	AAPL	Stock	106.44	106.54	105.55	105.6	441876.0
2020-09-23 04:00:00	MSFT	Stock	207.2	208.0	207.2	207.95	2538.0
2020-09-23 05:00:00	MSFT	Stock	207.95	209.44	207.95	209.44	6389.0
2020-09-23 06:00:00	MSFT	Stock	208.99	209.02	208.05	208.5	4865.0
2020-09-23 07:00:00	MSFT	Stock	208.22	208.7	206.49	206.49	67869.0
2020-09-23 08:00:00	MSFT	Stock	208.35	208.645	206.4	207.49	72782.0
2020-09-23 09:00:00	MSFT	Stock	207.472	208.25	205.23	205.58	3000573.0
2020-09-23 10:00:00	MSFT	Stock	205.53	205.99	204.52	204.71	2833065.0
2020-09-23 11:00:00	MSFT	Stock	204.72	205.58	203.95	204.065	2210610.0
2020-09-23 12:00:00	MSFT	Stock	204.08	204.948	203.7	204.933	1684011.0
2020-09-23 13:00:00	MSFT	Stock	204.939	204.97	203.56	203.83	1791818.0
2020-09-23 14:00:00	MSFT	Stock	203.84	203.85	201.52	201.57	3046465.0
2020-09-23 15:00:00	MSFT	Stock	201.6	202.08	200.03	200.59	6160434.0
2020-09-23 16:00:00	MSFT	Stock	200.59	201.3	200.57	201.0	5050537.0
2020-09-23 17:00:00	MSFT	Stock	201.0	202.01	200.3	200.48	35854.0
2020-09-23 18:00:00	MSFT	Stock	200.5	201.5	200.5	200.73	29186.0
2020-09-23 19:00:00	MSFT	Stock	200.73	200.94	199.52	199.95	39425.0
2020-09-23 04:00:00	NVDA	Stock	12.6368	12.65	12.575	12.626	116200.0
2020-09-23 05:00:00	NVDA	Stock	12.634	12.65	12.629	12.65	139560.0
2020-09-23 06:00:00	NVDA	Stock	12.65	12.65	12.61	12.6313	166440.0
2020-09-23 07:00:00	NVDA	Stock	12.6238	12.625	12.475	12.475	1320760.0
2020-09-23 08:00:00	NVDA	Stock	12.5617	12.6063	12.467	12.5605	9597160.0
2020-09-23 09:00:00	NVDA	Stock	12.5495	12.727	12.4668	12.5733	95973480.0
2020-09-23 10:00:00	NVDA	Stock	12.5683	12.6201	12.468	12.5655	95724760.0
2020-09-23 11:00:00	NVDA	Stock	12.563	12.625	12.475	12.4862	65533480.0
2020-09-23 12:00:00	NVDA	Stock	12.4822	12.5435	12.4378	12.5427	49094320.0
2020-09-23 13:00:00	NVDA	Stock	12.5412	12.5625	12.414	12.4293	55573480.0
2020-09-23 14:00:00	NVDA	Stock	12.4275	12.4275	12.2008	12.2165	79361360.0
2020-09-23 15:00:00	NVDA	Stock	12.2162	12.2373	12.0793	12.1262	93910960.0
2020-09-23 16:00:00	NVDA	Stock	12.1238	12.1375	12.1	12.1128	2615440.0
2020-09-23 17:00:00	NVDA	Stock	12.1118	12.115	12.05	12.0688	372760.0
2020-09-23 18:00:00	NVDA	Stock	12.075	12.125	12.075	12.0975	556840.0
2020-09-23 19:00:00	NVDA	Stock	12.118	12.118	12.0125	12.0125	757560.0
2020-09-23 04:00:00	AMZN	Stock	156.351	156.75	156.351	156.75	32940.0
2020-09-23 05:00:00	AMZN	Stock	156.876	157.4	156.876	157.397	62700.0

> showing 50 of 57,219 rows — these rows as CSV

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