PREVIEW / stock_1hour / 2018-11-08

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-11-08.parquet
  size:    1.1 MB
  rows:    49,505
  symbols: 2,748

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
2018-11-08 04:00:00	AAPL	Stock	52.595	52.595	52.26	52.275	47036.0
2018-11-08 05:00:00	AAPL	Stock	52.2775	52.34	52.105	52.13	66788.0
2018-11-08 06:00:00	AAPL	Stock	52.17	52.275	52.105	52.2725	165776.0
2018-11-08 07:00:00	AAPL	Stock	52.25	52.4025	52.2375	52.395	180172.0
2018-11-08 08:00:00	AAPL	Stock	52.2675	52.4	52.2348	52.35	473920.0
2018-11-08 09:00:00	AAPL	Stock	52.3325	52.53	51.945	52.1338	18378340.0
2018-11-08 10:00:00	AAPL	Stock	52.13	52.205	51.785	51.908	13323008.0
2018-11-08 11:00:00	AAPL	Stock	51.9175	51.9742	51.6875	51.82	10616772.0
2018-11-08 12:00:00	AAPL	Stock	51.8225	51.99	51.76	51.9225	6498224.0
2018-11-08 13:00:00	AAPL	Stock	51.9225	52.03	51.8382	52.0265	4792140.0
2018-11-08 14:00:00	AAPL	Stock	52.0275	52.1875	51.8475	51.98	10501236.0
2018-11-08 15:00:00	AAPL	Stock	51.98	52.14	51.8775	52.1225	13269056.0
2018-11-08 16:00:00	AAPL	Stock	52.1225	52.125	51.905	51.975	8293424.0
2018-11-08 17:00:00	AAPL	Stock	51.96	51.975	51.8875	51.9125	71152.0
2018-11-08 18:00:00	AAPL	Stock	51.9325	51.9625	51.85	51.915	98264.0
2018-11-08 19:00:00	AAPL	Stock	51.915	52.05	51.75	51.8125	145680.0
2018-11-08 04:00:00	MSFT	Stock	112.1	112.1	111.76	111.76	700.0
2018-11-08 05:00:00	MSFT	Stock	111.5	111.5	111.42	111.42	2189.0
2018-11-08 06:00:00	MSFT	Stock	111.22	111.45	111.22	111.35	4945.0
2018-11-08 07:00:00	MSFT	Stock	111.36	111.82	111.21	111.69	14763.0
2018-11-08 08:00:00	MSFT	Stock	111.4	111.75	111.23	111.74	20642.0
2018-11-08 09:00:00	MSFT	Stock	111.61	112.12	110.98	111.91	3436136.0
2018-11-08 10:00:00	MSFT	Stock	111.91	112.21	111.27	111.7	3567017.0
2018-11-08 11:00:00	MSFT	Stock	111.71	111.82	111.22	111.515	2787056.0
2018-11-08 12:00:00	MSFT	Stock	111.52	111.56	111.11	111.35	1770897.0
2018-11-08 13:00:00	MSFT	Stock	111.34	111.44	110.91	111.19	2204773.0
2018-11-08 14:00:00	MSFT	Stock	111.19	111.69	110.92	111.33	2724612.0
2018-11-08 15:00:00	MSFT	Stock	111.34	111.79	111.08	111.79	4192003.0
2018-11-08 16:00:00	MSFT	Stock	111.75	111.868	111.66	111.66	2499912.0
2018-11-08 17:00:00	MSFT	Stock	111.52	111.69	111.51	111.69	1887.0
2018-11-08 18:00:00	MSFT	Stock	111.51	111.51	111.51	111.51	100.0
2018-11-08 19:00:00	MSFT	Stock	111.69	111.84	111.51	111.67	4175.0
2018-11-08 04:00:00	NVDA	Stock	5.3375	5.3375	5.3275	5.3322	15600.0
2018-11-08 05:00:00	NVDA	Stock	5.3223	5.3223	5.3223	5.3223	4000.0
2018-11-08 06:00:00	NVDA	Stock	5.3175	5.332	5.275	5.275	74360.0
2018-11-08 07:00:00	NVDA	Stock	5.287	5.322	5.2815	5.3125	470680.0
2018-11-08 08:00:00	NVDA	Stock	5.2812	5.3138	5.2812	5.29	1102160.0
2018-11-08 09:00:00	NVDA	Stock	5.2876	5.2972	5.1538	5.2222	75182080.0
2018-11-08 10:00:00	NVDA	Stock	5.2255	5.2295	5.1272	5.1958	78470240.0
2018-11-08 11:00:00	NVDA	Stock	5.1959	5.2125	5.1363	5.1853	54976080.0
2018-11-08 12:00:00	NVDA	Stock	5.1862	5.2113	5.1718	5.179	28451320.0
2018-11-08 13:00:00	NVDA	Stock	5.1795	5.1909	5.1453	5.1728	22594160.0
2018-11-08 14:00:00	NVDA	Stock	5.1736	5.1847	5.1302	5.1378	40320240.0
2018-11-08 15:00:00	NVDA	Stock	5.137	5.1592	5.0958	5.1495	84540080.0
2018-11-08 16:00:00	NVDA	Stock	5.1495	5.1573	5.1375	5.15	31682720.0
2018-11-08 17:00:00	NVDA	Stock	5.15	5.15	5.1375	5.1375	280800.0
2018-11-08 18:00:00	NVDA	Stock	5.142	5.153	5.1375	5.15	284200.0
2018-11-08 19:00:00	NVDA	Stock	5.1475	5.1622	5.1438	5.1575	367760.0
2018-11-08 04:00:00	AMZN	Stock	88.25	88.25	87.501	87.501	33840.0
2018-11-08 05:00:00	AMZN	Stock	87.439	87.439	87.2615	87.263	18940.0

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

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