PREVIEW / stock_1hour / 2020-08-18

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-08-18.parquet
  size:    1.2 MB
  rows:    56,838
  symbols: 2,444

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-08-18 04:00:00	AAPL	Stock	114.6825	114.9975	114.595	114.95	26048.0
2020-08-18 05:00:00	AAPL	Stock	114.9975	115.17	114.95	115.1375	12008.0
2020-08-18 06:00:00	AAPL	Stock	115.1125	115.1825	114.995	115.025	21888.0
2020-08-18 07:00:00	AAPL	Stock	115.1	115.1	114.175	114.325	423484.0
2020-08-18 08:00:00	AAPL	Stock	114.65	115.17	114.125	114.58	637732.0
2020-08-18 09:00:00	AAPL	Stock	114.5575	115.5	114.18	114.62	14571044.0
2020-08-18 10:00:00	AAPL	Stock	114.6175	115.095	114.0075	114.9902	11906244.0
2020-08-18 11:00:00	AAPL	Stock	114.9925	115.2	114.8	115.126	7324040.0
2020-08-18 12:00:00	AAPL	Stock	115.1092	115.705	115.095	115.375	9418444.0
2020-08-18 13:00:00	AAPL	Stock	115.3775	115.875	115.211	115.645	9704800.0
2020-08-18 14:00:00	AAPL	Stock	115.6525	116.0	115.5488	115.6875	9280968.0
2020-08-18 15:00:00	AAPL	Stock	115.6925	115.71	115.4	115.52	12312224.0
2020-08-18 16:00:00	AAPL	Stock	115.5625	115.675	115.5175	115.675	4643180.0
2020-08-18 17:00:00	AAPL	Stock	115.685	115.75	115.6	115.7	42992.0
2020-08-18 18:00:00	AAPL	Stock	115.74	115.765	115.655	115.7	63656.0
2020-08-18 19:00:00	AAPL	Stock	115.6625	115.7475	115.615	115.7125	77232.0
2020-08-18 04:00:00	MSFT	Stock	210.08	210.08	209.83	209.87	1926.0
2020-08-18 05:00:00	MSFT	Stock	209.84	210.4	209.84	210.4	1848.0
2020-08-18 06:00:00	MSFT	Stock	210.26	210.67	210.25	210.67	2542.0
2020-08-18 07:00:00	MSFT	Stock	210.45	210.68	210.07	210.28	27780.0
2020-08-18 08:00:00	MSFT	Stock	210.439	211.0	210.06	210.5	33492.0
2020-08-18 09:00:00	MSFT	Stock	210.42	212.36	209.81	210.62	2762359.0
2020-08-18 10:00:00	MSFT	Stock	210.63	210.75	209.21	210.1	1823673.0
2020-08-18 11:00:00	MSFT	Stock	210.1	210.69	209.96	210.36	987663.0
2020-08-18 12:00:00	MSFT	Stock	210.35	210.88	210.16	210.491	828639.0
2020-08-18 13:00:00	MSFT	Stock	210.494	210.905	210.31	210.33	1037325.0
2020-08-18 14:00:00	MSFT	Stock	210.335	211.74	210.13	211.69	2002637.0
2020-08-18 15:00:00	MSFT	Stock	211.69	211.95	211.25	211.48	3494441.0
2020-08-18 16:00:00	MSFT	Stock	211.49	211.9	211.38	211.85	4145348.0
2020-08-18 17:00:00	MSFT	Stock	211.75	211.82	211.75	211.8	5217.0
2020-08-18 18:00:00	MSFT	Stock	211.79	211.95	211.51	211.8	9690.0
2020-08-18 19:00:00	MSFT	Stock	211.62	212.0	211.62	211.9	4320.0
2020-08-18 04:00:00	NVDA	Stock	12.4375	12.4375	12.3565	12.4132	259560.0
2020-08-18 05:00:00	NVDA	Stock	12.4238	12.48	12.4122	12.479	328760.0
2020-08-18 06:00:00	NVDA	Stock	12.473	12.497	12.4692	12.4825	409800.0
2020-08-18 07:00:00	NVDA	Stock	12.488	12.561	12.425	12.425	3304640.0
2020-08-18 08:00:00	NVDA	Stock	12.4878	12.5599	12.3922	12.464	5178000.0
2020-08-18 09:00:00	NVDA	Stock	12.463	12.5222	12.0862	12.1908	113751200.0
2020-08-18 10:00:00	NVDA	Stock	12.1942	12.2875	12.1408	12.2438	73248520.0
2020-08-18 11:00:00	NVDA	Stock	12.2448	12.3243	12.2283	12.2557	37511520.0
2020-08-18 12:00:00	NVDA	Stock	12.257	12.337	12.187	12.2013	40833120.0
2020-08-18 13:00:00	NVDA	Stock	12.1985	12.25	12.1855	12.2165	26385160.0
2020-08-18 14:00:00	NVDA	Stock	12.2162	12.2485	12.1863	12.2253	30186720.0
2020-08-18 15:00:00	NVDA	Stock	12.225	12.3408	12.2213	12.2605	68916280.0
2020-08-18 16:00:00	NVDA	Stock	12.2608	12.3038	12.255	12.3	13021760.0
2020-08-18 17:00:00	NVDA	Stock	12.3002	12.3062	12.2675	12.275	884000.0
2020-08-18 18:00:00	NVDA	Stock	12.2662	12.2825	12.2628	12.27	669280.0
2020-08-18 19:00:00	NVDA	Stock	12.275	12.275	12.25	12.265	933600.0
2020-08-18 05:00:00	AMZN	Stock	159.5	159.646	159.5	159.646	23080.0
2020-08-18 06:00:00	AMZN	Stock	159.7995	159.7995	159.7995	159.7995	2000.0

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

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