PREVIEW / stock_1hour / 2019-03-19

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-03-19.parquet
  size:    1.1 MB
  rows:    50,291
  symbols: 2,641

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
2019-03-19 04:00:00	AAPL	Stock	47.0375	47.085	47.0375	47.085	4928.0
2019-03-19 05:00:00	AAPL	Stock	47.2175	47.24	47.2175	47.24	11372.0
2019-03-19 06:00:00	AAPL	Stock	47.24	47.25	47.2	47.2	64408.0
2019-03-19 07:00:00	AAPL	Stock	47.205	47.315	47.1525	47.23	156424.0
2019-03-19 08:00:00	AAPL	Stock	47.1625	47.3125	47.1625	47.2225	363216.0
2019-03-19 09:00:00	AAPL	Stock	47.23	47.2475	47.0	47.0375	17163200.0
2019-03-19 10:00:00	AAPL	Stock	47.04	47.1125	46.78	46.7975	19833740.0
2019-03-19 11:00:00	AAPL	Stock	46.7975	47.01	46.7075	47.005	13619716.0
2019-03-19 12:00:00	AAPL	Stock	47.0075	47.0975	46.7325	46.9225	12655700.0
2019-03-19 13:00:00	AAPL	Stock	46.9275	46.9462	46.71	46.7675	8439064.0
2019-03-19 14:00:00	AAPL	Stock	46.765	46.8792	46.71	46.825	7843124.0
2019-03-19 15:00:00	AAPL	Stock	46.8275	46.8325	46.48	46.635	19482408.0
2019-03-19 16:00:00	AAPL	Stock	46.6325	46.6875	46.515	46.555	15185880.0
2019-03-19 17:00:00	AAPL	Stock	46.5625	46.575	46.5175	46.52	48928.0
2019-03-19 18:00:00	AAPL	Stock	46.5375	46.5625	46.51	46.51	72912.0
2019-03-19 19:00:00	AAPL	Stock	46.5025	46.5625	46.4875	46.5	38948.0
2019-03-19 05:00:00	MSFT	Stock	118.15	118.15	118.1	118.1	700.0
2019-03-19 06:00:00	MSFT	Stock	117.91	118.1	117.91	118.09	900.0
2019-03-19 07:00:00	MSFT	Stock	118.11	118.19	117.97	117.97	16389.0
2019-03-19 08:00:00	MSFT	Stock	118.08	118.2	117.94	118.06	27744.0
2019-03-19 09:00:00	MSFT	Stock	118.09	118.44	117.62	117.62	3164709.0
2019-03-19 10:00:00	MSFT	Stock	117.64	118.005	117.28	117.32	3977849.0
2019-03-19 11:00:00	MSFT	Stock	117.32	117.845	117.273	117.79	3752186.0
2019-03-19 12:00:00	MSFT	Stock	117.8	118.05	117.08	117.76	3413739.0
2019-03-19 13:00:00	MSFT	Stock	117.76	118.005	117.59	117.766	1900022.0
2019-03-19 14:00:00	MSFT	Stock	117.77	117.935	117.52	117.64	2097472.0
2019-03-19 15:00:00	MSFT	Stock	117.64	117.87	116.99	117.7	4726622.0
2019-03-19 16:00:00	MSFT	Stock	117.65	117.77	116.93	117.1	9379349.0
2019-03-19 17:00:00	MSFT	Stock	117.29	117.35	117.1	117.2	3728.0
2019-03-19 18:00:00	MSFT	Stock	117.22	117.3	117.2	117.25	5902.0
2019-03-19 19:00:00	MSFT	Stock	117.2	117.29	117.2	117.29	400.0
2019-03-19 04:00:00	NVDA	Stock	4.267	4.267	4.267	4.267	12000.0
2019-03-19 05:00:00	NVDA	Stock	4.2803	4.2803	4.2625	4.2803	23680.0
2019-03-19 06:00:00	NVDA	Stock	4.2675	4.28	4.2675	4.275	24000.0
2019-03-19 07:00:00	NVDA	Stock	4.275	4.2968	4.2675	4.2838	460200.0
2019-03-19 08:00:00	NVDA	Stock	4.2862	4.3105	4.2342	4.3045	3749560.0
2019-03-19 09:00:00	NVDA	Stock	4.3048	4.375	4.302	4.3535	147585360.0
2019-03-19 10:00:00	NVDA	Stock	4.3523	4.4145	4.3498	4.3822	162650680.0
2019-03-19 11:00:00	NVDA	Stock	4.3822	4.3962	4.3672	4.3807	72749480.0
2019-03-19 12:00:00	NVDA	Stock	4.381	4.418	4.375	4.3985	108167960.0
2019-03-19 13:00:00	NVDA	Stock	4.398	4.418	4.3925	4.4145	60561120.0
2019-03-19 14:00:00	NVDA	Stock	4.4148	4.4362	4.3895	4.413	107171760.0
2019-03-19 15:00:00	NVDA	Stock	4.4133	4.4375	4.3662	4.3935	130549680.0
2019-03-19 16:00:00	NVDA	Stock	4.3918	4.3928	4.3802	4.39	23925000.0
2019-03-19 17:00:00	NVDA	Stock	4.3888	4.3972	4.3852	4.3852	826760.0
2019-03-19 18:00:00	NVDA	Stock	4.3862	4.3928	4.3768	4.3825	352040.0
2019-03-19 19:00:00	NVDA	Stock	4.3765	4.3825	4.369	4.3725	1039800.0
2019-03-19 05:00:00	AMZN	Stock	87.55	87.55	87.55	87.55	6000.0
2019-03-19 06:00:00	AMZN	Stock	87.55	87.6045	87.55	87.6045	44460.0
2019-03-19 07:00:00	AMZN	Stock	87.575	87.66	87.5	87.5875	161820.0

> showing 50 of 50,291 rows — these rows as CSV

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