PREVIEW / stock_1hour / 2019-04-08

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-04-08.parquet
  size:    1.1 MB
  rows:    49,884
  symbols: 2,651

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-04-08 04:00:00	AAPL	Stock	49.0875	49.15	49.0675	49.15	6020.0
2019-04-08 05:00:00	AAPL	Stock	49.15	49.18	49.075	49.075	7200.0
2019-04-08 06:00:00	AAPL	Stock	49.095	49.13	49.095	49.1	12072.0
2019-04-08 07:00:00	AAPL	Stock	49.16	49.16	49.05	49.1275	42780.0
2019-04-08 08:00:00	AAPL	Stock	49.145	49.3725	49.0325	49.0475	140048.0
2019-04-08 09:00:00	AAPL	Stock	49.045	49.4768	49.0325	49.4475	12301300.0
2019-04-08 10:00:00	AAPL	Stock	49.4475	49.6875	49.2975	49.675	14168252.0
2019-04-08 11:00:00	AAPL	Stock	49.675	49.875	49.6675	49.7925	16156188.0
2019-04-08 12:00:00	AAPL	Stock	49.795	49.8225	49.6525	49.7925	9169896.0
2019-04-08 13:00:00	AAPL	Stock	49.795	49.945	49.7575	49.9425	6613424.0
2019-04-08 14:00:00	AAPL	Stock	49.945	49.99	49.89	49.9675	7305848.0
2019-04-08 15:00:00	AAPL	Stock	49.9675	50.0575	49.9525	50.02	18408024.0
2019-04-08 16:00:00	AAPL	Stock	50.025	50.1125	50.025	50.1	7455412.0
2019-04-08 17:00:00	AAPL	Stock	50.1	50.125	50.09	50.105	69884.0
2019-04-08 18:00:00	AAPL	Stock	50.105	50.1625	50.1025	50.14	86988.0
2019-04-08 19:00:00	AAPL	Stock	50.15	50.1575	50.1125	50.145	58660.0
2019-04-08 04:00:00	MSFT	Stock	119.97	120.13	119.86	119.86	700.0
2019-04-08 05:00:00	MSFT	Stock	119.97	120.0	119.95	119.95	1202.0
2019-04-08 06:00:00	MSFT	Stock	119.9	120.3	119.87	120.01	953.0
2019-04-08 07:00:00	MSFT	Stock	120.1	120.1	119.75	120.0	4356.0
2019-04-08 08:00:00	MSFT	Stock	120.0	120.0	119.65	119.72	27047.0
2019-04-08 09:00:00	MSFT	Stock	119.658	119.955	118.64	119.085	2171333.0
2019-04-08 10:00:00	MSFT	Stock	119.08	119.71	118.93	119.45	2065115.0
2019-04-08 11:00:00	MSFT	Stock	119.45	119.74	119.39	119.556	1520169.0
2019-04-08 12:00:00	MSFT	Stock	119.56	119.71	119.405	119.7	1083766.0
2019-04-08 13:00:00	MSFT	Stock	119.7	119.92	119.655	119.78	834856.0
2019-04-08 14:00:00	MSFT	Stock	119.79	119.98	119.695	119.955	971738.0
2019-04-08 15:00:00	MSFT	Stock	119.95	120.02	119.805	119.89	2373810.0
2019-04-08 16:00:00	MSFT	Stock	119.93	119.98	119.853	119.98	2484479.0
2019-04-08 17:00:00	MSFT	Stock	119.97	119.98	119.86	119.88	1784.0
2019-04-08 18:00:00	MSFT	Stock	119.98	119.98	119.86	119.86	1150.0
2019-04-08 19:00:00	MSFT	Stock	119.88	119.92	119.88	119.92	200.0
2019-04-08 05:00:00	NVDA	Stock	4.7738	4.7738	4.771	4.771	12000.0
2019-04-08 06:00:00	NVDA	Stock	4.7712	4.7712	4.7712	4.7712	4000.0
2019-04-08 07:00:00	NVDA	Stock	4.767	4.7688	4.7325	4.7425	194880.0
2019-04-08 08:00:00	NVDA	Stock	4.7513	4.7855	4.7319	4.7403	1153280.0
2019-04-08 09:00:00	NVDA	Stock	4.7403	4.82	4.7188	4.8006	88631480.0
2019-04-08 10:00:00	NVDA	Stock	4.8017	4.8025	4.743	4.7502	71805680.0
2019-04-08 11:00:00	NVDA	Stock	4.7508	4.7602	4.7321	4.7398	46089800.0
2019-04-08 12:00:00	NVDA	Stock	4.7398	4.749	4.7275	4.7486	34493200.0
2019-04-08 13:00:00	NVDA	Stock	4.7486	4.7645	4.7432	4.7593	23489760.0
2019-04-08 14:00:00	NVDA	Stock	4.7593	4.7858	4.756	4.781	37179600.0
2019-04-08 15:00:00	NVDA	Stock	4.7803	4.797	4.7798	4.7945	56528560.0
2019-04-08 16:00:00	NVDA	Stock	4.7947	4.7947	4.79	4.7913	18198440.0
2019-04-08 17:00:00	NVDA	Stock	4.7915	4.7917	4.7875	4.79	124320.0
2019-04-08 18:00:00	NVDA	Stock	4.7938	4.7998	4.7922	4.7962	255440.0
2019-04-08 19:00:00	NVDA	Stock	4.7988	4.8	4.797	4.7995	266840.0
2019-04-08 04:00:00	AMZN	Stock	91.8	91.8	91.8	91.8	2000.0
2019-04-08 07:00:00	AMZN	Stock	91.7195	91.805	91.6885	91.75	91960.0
2019-04-08 08:00:00	AMZN	Stock	91.75	91.81	91.46	91.4945	245400.0

> showing 50 of 49,884 rows — these rows as CSV

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