PREVIEW / stock_1hour / 2017-08-28

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-08-28.parquet
  size:    1.0 MB
  rows:    48,742
  symbols: 2,993

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
2017-08-28 06:00:00	AAPL	Stock	39.94	39.9525	39.9125	39.95	8740.0
2017-08-28 07:00:00	AAPL	Stock	39.95	40.05	39.93	40.0125	22816.0
2017-08-28 08:00:00	AAPL	Stock	40.045	40.075	39.9275	40.0725	132512.0
2017-08-28 09:00:00	AAPL	Stock	40.0675	40.205	39.9825	40.1562	13043772.0
2017-08-28 10:00:00	AAPL	Stock	40.157	40.4725	40.105	40.4475	19660020.0
2017-08-28 11:00:00	AAPL	Stock	40.45	40.5	40.3125	40.4125	11994408.0
2017-08-28 12:00:00	AAPL	Stock	40.415	40.4175	40.2375	40.29	6928460.0
2017-08-28 13:00:00	AAPL	Stock	40.29	40.4025	40.2525	40.385	6954980.0
2017-08-28 14:00:00	AAPL	Stock	40.3832	40.4125	40.3475	40.3675	6565496.0
2017-08-28 15:00:00	AAPL	Stock	40.3675	40.394	40.2938	40.3675	11151204.0
2017-08-28 16:00:00	AAPL	Stock	40.3675	40.38	40.35	40.37	14547468.0
2017-08-28 17:00:00	AAPL	Stock	40.37	40.3775	39.9675	40.0	480072.0
2017-08-28 18:00:00	AAPL	Stock	40.0	40.1	39.925	40.05	430540.0
2017-08-28 19:00:00	AAPL	Stock	40.045	40.0625	39.98	40.05	358592.0
2017-08-28 06:00:00	MSFT	Stock	72.77	72.77	72.77	72.77	100.0
2017-08-28 08:00:00	MSFT	Stock	73.02	73.04	73.01	73.04	886.0
2017-08-28 09:00:00	MSFT	Stock	72.96	73.09	72.57	72.61	1572223.0
2017-08-28 10:00:00	MSFT	Stock	72.61	72.93	72.55	72.88	1489343.0
2017-08-28 11:00:00	MSFT	Stock	72.88	72.94	72.8	72.884	831939.0
2017-08-28 12:00:00	MSFT	Stock	72.88	72.89	72.645	72.73	627496.0
2017-08-28 13:00:00	MSFT	Stock	72.73	72.77	72.63	72.73	936188.0
2017-08-28 14:00:00	MSFT	Stock	72.735	72.74	72.65	72.68	891527.0
2017-08-28 15:00:00	MSFT	Stock	72.68	72.86	72.58	72.83	2217732.0
2017-08-28 16:00:00	MSFT	Stock	72.83	72.83	72.79	72.83	3902463.0
2017-08-28 17:00:00	MSFT	Stock	72.74	72.74	72.45	72.45	8101.0
2017-08-28 18:00:00	MSFT	Stock	72.15	72.3	72.12	72.16	4511.0
2017-08-28 19:00:00	MSFT	Stock	72.18	72.4	72.18	72.32	1304.0
2017-08-28 06:00:00	NVDA	Stock	4.0948	4.0948	4.0948	4.0948	108000.0
2017-08-28 07:00:00	NVDA	Stock	4.089	4.089	4.0788	4.086	395560.0
2017-08-28 08:00:00	NVDA	Stock	4.0862	4.112	4.0812	4.11	1199400.0
2017-08-28 09:00:00	NVDA	Stock	4.1085	4.1165	4.0582	4.071	67022600.0
2017-08-28 10:00:00	NVDA	Stock	4.0715	4.103	4.067	4.0803	72208760.0
2017-08-28 11:00:00	NVDA	Stock	4.0803	4.1142	4.0798	4.1092	46000320.0
2017-08-28 12:00:00	NVDA	Stock	4.109	4.1145	4.0865	4.105	30137000.0
2017-08-28 13:00:00	NVDA	Stock	4.1051	4.1215	4.1038	4.1199	31721280.0
2017-08-28 14:00:00	NVDA	Stock	4.1198	4.1248	4.1092	4.1175	32389840.0
2017-08-28 15:00:00	NVDA	Stock	4.1175	4.1275	4.1128	4.124	50408480.0
2017-08-28 16:00:00	NVDA	Stock	4.1242	4.1268	4.1225	4.1225	30630800.0
2017-08-28 17:00:00	NVDA	Stock	4.123	4.123	4.065	4.0675	2540320.0
2017-08-28 18:00:00	NVDA	Stock	4.0675	4.0825	4.065	4.0825	1260160.0
2017-08-28 19:00:00	NVDA	Stock	4.0825	4.085	4.0688	4.08	890480.0
2017-08-28 07:00:00	AMZN	Stock	47.285	47.3125	47.285	47.3125	10000.0
2017-08-28 08:00:00	AMZN	Stock	47.2	47.415	47.2	47.3335	128700.0
2017-08-28 09:00:00	AMZN	Stock	47.3385	47.5245	47.1125	47.456	8649120.0
2017-08-28 10:00:00	AMZN	Stock	47.4645	47.6145	47.3955	47.5661	7119980.0
2017-08-28 11:00:00	AMZN	Stock	47.575	47.65	47.455	47.4745	2810040.0
2017-08-28 12:00:00	AMZN	Stock	47.465	47.5	47.2565	47.307	3371700.0
2017-08-28 13:00:00	AMZN	Stock	47.306	47.427	47.275	47.4091	3579100.0
2017-08-28 14:00:00	AMZN	Stock	47.417	47.45	47.3375	47.365	1737200.0
2017-08-28 15:00:00	AMZN	Stock	47.3653	47.3965	47.219	47.3	4749580.0

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

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