PREVIEW / stock_1hour / 2015-12-23

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-12-23.parquet
  size:    1.0 MB
  rows:    48,892
  symbols: 3,431

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
2015-12-23 04:00:00	AAPL	Stock	26.85	26.9	26.85	26.85	4844.0
2015-12-23 05:00:00	AAPL	Stock	26.875	26.8875	26.875	26.8875	8188.0
2015-12-23 06:00:00	AAPL	Stock	26.8875	26.8875	26.8625	26.8625	10000.0
2015-12-23 07:00:00	AAPL	Stock	26.885	26.925	26.8725	26.895	50024.0
2015-12-23 08:00:00	AAPL	Stock	26.89	26.92	26.8075	26.81	249292.0
2015-12-23 09:00:00	AAPL	Stock	26.81	27.12	26.795	27.0425	17314768.0
2015-12-23 10:00:00	AAPL	Stock	27.0475	27.1525	26.9625	27.12	20996924.0
2015-12-23 11:00:00	AAPL	Stock	27.12	27.125	27.03	27.1225	13128628.0
2015-12-23 12:00:00	AAPL	Stock	27.1238	27.2125	27.0775	27.1	16170344.0
2015-12-23 13:00:00	AAPL	Stock	27.1012	27.11	27.0075	27.0448	9219156.0
2015-12-23 14:00:00	AAPL	Stock	27.0425	27.16	27.0412	27.145	11563556.0
2015-12-23 15:00:00	AAPL	Stock	27.145	27.1625	27.06	27.1525	16330968.0
2015-12-23 16:00:00	AAPL	Stock	27.1525	27.155	27.1225	27.1375	8067008.0
2015-12-23 17:00:00	AAPL	Stock	27.1525	27.155	27.13	27.155	72292.0
2015-12-23 18:00:00	AAPL	Stock	27.1475	27.1625	27.12	27.12	47084.0
2015-12-23 19:00:00	AAPL	Stock	27.125	27.17	27.12	27.1625	27640.0
2015-12-23 07:00:00	MSFT	Stock	55.57	55.65	55.57	55.65	2160.0
2015-12-23 08:00:00	MSFT	Stock	55.55	55.65	55.55	55.61	4462.0
2015-12-23 09:00:00	MSFT	Stock	55.6	55.87	55.53	55.78	2667188.0
2015-12-23 10:00:00	MSFT	Stock	55.78	55.88	55.545	55.61	4658486.0
2015-12-23 11:00:00	MSFT	Stock	55.61	55.73	55.52	55.7	2372927.0
2015-12-23 12:00:00	MSFT	Stock	55.705	55.74	55.44	55.606	2790165.0
2015-12-23 13:00:00	MSFT	Stock	55.604	55.73	55.54	55.72	2226018.0
2015-12-23 14:00:00	MSFT	Stock	55.71	55.87	55.65	55.86	2747287.0
2015-12-23 15:00:00	MSFT	Stock	55.86	55.87	55.69	55.83	3791555.0
2015-12-23 16:00:00	MSFT	Stock	55.82	55.85	55.7	55.82	2582360.0
2015-12-23 18:00:00	MSFT	Stock	55.78	55.78	55.78	55.78	100.0
2015-12-23 19:00:00	MSFT	Stock	55.78	55.78	55.73	55.75	760.0
2015-12-23 08:00:00	NVDA	Stock	0.825	0.8255	0.825	0.825	27200.0
2015-12-23 09:00:00	NVDA	Stock	0.8185	0.8286	0.8185	0.8286	17676160.0
2015-12-23 10:00:00	NVDA	Stock	0.8286	0.8296	0.8265	0.8283	16049480.0
2015-12-23 11:00:00	NVDA	Stock	0.8283	0.8285	0.8249	0.8275	16835560.0
2015-12-23 12:00:00	NVDA	Stock	0.8275	0.8286	0.8252	0.8265	13695560.0
2015-12-23 13:00:00	NVDA	Stock	0.8265	0.8268	0.825	0.8266	9405600.0
2015-12-23 14:00:00	NVDA	Stock	0.8268	0.8275	0.8256	0.8269	11976240.0
2015-12-23 15:00:00	NVDA	Stock	0.8268	0.8271	0.8249	0.8265	24584680.0
2015-12-23 16:00:00	NVDA	Stock	0.8264	0.8264	0.8264	0.8264	4772080.0
2015-12-23 19:00:00	NVDA	Stock	0.83	0.83	0.83	0.83	8000.0
2015-12-23 06:00:00	AMZN	Stock	33.315	33.3395	33.315	33.3395	4000.0
2015-12-23 07:00:00	AMZN	Stock	33.338	33.3745	33.338	33.345	34520.0
2015-12-23 08:00:00	AMZN	Stock	33.3395	33.397	33.312	33.397	85820.0
2015-12-23 09:00:00	AMZN	Stock	33.3775	33.3965	33.16	33.2305	4867540.0
2015-12-23 10:00:00	AMZN	Stock	33.231	33.291	33.0145	33.035	8662540.0
2015-12-23 11:00:00	AMZN	Stock	33.0345	33.065	32.8315	32.9765	6797040.0
2015-12-23 12:00:00	AMZN	Stock	32.9845	33.039	32.8693	32.894	5099660.0
2015-12-23 13:00:00	AMZN	Stock	32.889	33.1125	32.883	33.095	4518360.0
2015-12-23 14:00:00	AMZN	Stock	33.0901	33.2325	33.0855	33.2235	6856220.0
2015-12-23 15:00:00	AMZN	Stock	33.216	33.2445	33.0885	33.185	6689940.0
2015-12-23 16:00:00	AMZN	Stock	33.185	33.1895	33.11	33.14	165200.0
2015-12-23 17:00:00	AMZN	Stock	33.185	33.185	33.115	33.115	32240.0

> showing 50 of 48,892 rows — these rows as CSV

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