PREVIEW / stock_1hour / 2019-07-12

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-07-12.parquet
  size:    1.1 MB
  rows:    49,844
  symbols: 2,577

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-07-12 04:00:00	AAPL	Stock	50.54	50.6	50.54	50.6	2396.0
2019-07-12 05:00:00	AAPL	Stock	50.55	50.5925	50.5375	50.5675	12040.0
2019-07-12 06:00:00	AAPL	Stock	50.6	50.6875	50.525	50.55	26088.0
2019-07-12 07:00:00	AAPL	Stock	50.54	50.62	50.53	50.595	105420.0
2019-07-12 08:00:00	AAPL	Stock	50.5918	50.6225	50.5375	50.5575	148292.0
2019-07-12 09:00:00	AAPL	Stock	50.5575	50.9875	50.4925	50.9025	11661560.0
2019-07-12 10:00:00	AAPL	Stock	50.91	50.9875	50.8325	50.93	7944232.0
2019-07-12 11:00:00	AAPL	Stock	50.9325	51.0	50.9	50.9762	5332496.0
2019-07-12 12:00:00	AAPL	Stock	50.975	50.9888	50.885	50.9475	5000656.0
2019-07-12 13:00:00	AAPL	Stock	50.945	50.9575	50.7012	50.775	6552544.0
2019-07-12 14:00:00	AAPL	Stock	50.7775	50.8575	50.775	50.819	5961108.0
2019-07-12 15:00:00	AAPL	Stock	50.815	50.8675	50.7725	50.81	10271536.0
2019-07-12 16:00:00	AAPL	Stock	50.825	50.9625	50.8	50.8225	6348392.0
2019-07-12 17:00:00	AAPL	Stock	50.825	50.825	50.8075	50.8125	26268.0
2019-07-12 18:00:00	AAPL	Stock	50.825	50.825	50.815	50.825	7808.0
2019-07-12 19:00:00	AAPL	Stock	50.825	50.825	50.8125	50.825	9752.0
2019-07-12 04:00:00	MSFT	Stock	139.0	139.0	139.0	139.0	100.0
2019-07-12 05:00:00	MSFT	Stock	138.98	139.04	138.98	139.04	900.0
2019-07-12 06:00:00	MSFT	Stock	139.1	139.1	139.0	139.0	2320.0
2019-07-12 07:00:00	MSFT	Stock	138.84	139.03	138.8	138.86	22911.0
2019-07-12 08:00:00	MSFT	Stock	138.9	139.06	138.74	138.88	31111.0
2019-07-12 09:00:00	MSFT	Stock	138.82	139.13	138.69	138.93	2217616.0
2019-07-12 10:00:00	MSFT	Stock	138.94	139.11	138.01	138.391	2732539.0
2019-07-12 11:00:00	MSFT	Stock	138.395	138.815	138.33	138.76	1553008.0
2019-07-12 12:00:00	MSFT	Stock	138.765	138.87	138.65	138.79	1369596.0
2019-07-12 13:00:00	MSFT	Stock	138.79	138.826	138.63	138.7	893889.0
2019-07-12 14:00:00	MSFT	Stock	138.69	138.844	138.66	138.803	1152693.0
2019-07-12 15:00:00	MSFT	Stock	138.81	138.98	138.64	138.89	3418868.0
2019-07-12 16:00:00	MSFT	Stock	138.9	139.0	138.72	138.859	3094461.0
2019-07-12 17:00:00	MSFT	Stock	138.9	139.0	138.81	138.91	6669.0
2019-07-12 18:00:00	MSFT	Stock	138.9	138.9	138.81	138.81	430.0
2019-07-12 19:00:00	MSFT	Stock	138.81	138.9	138.81	138.9	1892.0
2019-07-12 05:00:00	NVDA	Stock	4.182	4.1822	4.1795	4.1822	36480.0
2019-07-12 06:00:00	NVDA	Stock	4.1958	4.1962	4.1812	4.1875	190840.0
2019-07-12 07:00:00	NVDA	Stock	4.1938	4.196	4.1815	4.195	988840.0
2019-07-12 08:00:00	NVDA	Stock	4.1925	4.197	4.1855	4.1865	1720720.0
2019-07-12 09:00:00	NVDA	Stock	4.1858	4.2483	4.1775	4.2435	112286000.0
2019-07-12 10:00:00	NVDA	Stock	4.2435	4.2618	4.1958	4.2022	131370960.0
2019-07-12 11:00:00	NVDA	Stock	4.203	4.2348	4.1971	4.2335	43261000.0
2019-07-12 12:00:00	NVDA	Stock	4.233	4.2422	4.2122	4.2138	45929360.0
2019-07-12 13:00:00	NVDA	Stock	4.2142	4.2183	4.1884	4.1987	34259360.0
2019-07-12 14:00:00	NVDA	Stock	4.1983	4.212	4.186	4.207	34305320.0
2019-07-12 15:00:00	NVDA	Stock	4.2075	4.208	4.1858	4.19	53058840.0
2019-07-12 16:00:00	NVDA	Stock	4.1903	4.1938	4.1865	4.1865	8096320.0
2019-07-12 17:00:00	NVDA	Stock	4.1875	4.1923	4.1862	4.1875	156640.0
2019-07-12 18:00:00	NVDA	Stock	4.1858	4.1892	4.1858	4.189	130200.0
2019-07-12 19:00:00	NVDA	Stock	4.1875	4.1878	4.183	4.187	317480.0
2019-07-12 04:00:00	AMZN	Stock	100.3335	100.3335	100.3335	100.3335	6000.0
2019-07-12 05:00:00	AMZN	Stock	100.4	100.4	100.4	100.4	4720.0
2019-07-12 07:00:00	AMZN	Stock	100.495	100.56	100.45	100.519	108800.0

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

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