PREVIEW / stock_1hour / 2017-07-14

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-07-14.parquet
  size:    1.0 MB
  rows:    47,313
  symbols: 3,003

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-07-14 04:00:00	AAPL	Stock	36.8625	36.8625	36.75	36.75	15676.0
2017-07-14 05:00:00	AAPL	Stock	36.7275	36.745	36.7	36.7425	19516.0
2017-07-14 06:00:00	AAPL	Stock	36.725	36.7825	36.725	36.765	53252.0
2017-07-14 07:00:00	AAPL	Stock	36.7825	36.825	36.7825	36.8225	63444.0
2017-07-14 08:00:00	AAPL	Stock	36.805	37.025	36.7825	36.97	553528.0
2017-07-14 09:00:00	AAPL	Stock	36.97	37.025	36.8362	36.865	10550624.0
2017-07-14 10:00:00	AAPL	Stock	36.865	36.965	36.8325	36.9025	8852712.0
2017-07-14 11:00:00	AAPL	Stock	36.9025	36.95	36.855	36.9462	6171200.0
2017-07-14 12:00:00	AAPL	Stock	36.9462	37.2025	36.9375	37.1755	9897928.0
2017-07-14 13:00:00	AAPL	Stock	37.1755	37.2725	37.125	37.251	8119864.0
2017-07-14 14:00:00	AAPL	Stock	37.2542	37.2788	37.2125	37.215	7107520.0
2017-07-14 15:00:00	AAPL	Stock	37.2175	37.3325	37.215	37.26	15775760.0
2017-07-14 16:00:00	AAPL	Stock	37.265	37.295	37.25	37.2575	6166400.0
2017-07-14 17:00:00	AAPL	Stock	37.275	37.275	37.2525	37.2525	22252.0
2017-07-14 18:00:00	AAPL	Stock	37.26	37.275	37.25	37.26	21292.0
2017-07-14 19:00:00	AAPL	Stock	37.2575	37.2625	37.25	37.26	19324.0
2017-07-14 08:00:00	MSFT	Stock	71.9	72.18	71.9	72.18	2811.0
2017-07-14 09:00:00	MSFT	Stock	72.19	72.39	71.96	72.095	2334337.0
2017-07-14 10:00:00	MSFT	Stock	72.095	72.26	72.08	72.19	2381266.0
2017-07-14 11:00:00	MSFT	Stock	72.19	72.43	72.12	72.225	1778647.0
2017-07-14 12:00:00	MSFT	Stock	72.22	72.83	72.214	72.75	2631414.0
2017-07-14 13:00:00	MSFT	Stock	72.755	72.99	72.74	72.955	2728240.0
2017-07-14 14:00:00	MSFT	Stock	72.95	73.12	72.94	73.08	3085419.0
2017-07-14 15:00:00	MSFT	Stock	73.08	73.27	72.75	72.77	6961352.0
2017-07-14 16:00:00	MSFT	Stock	72.78	72.9	72.74	72.74	1797096.0
2017-07-14 17:00:00	MSFT	Stock	72.74	72.87	72.74	72.78	85300.0
2017-07-14 18:00:00	MSFT	Stock	72.8	72.84	72.79	72.79	400.0
2017-07-14 19:00:00	MSFT	Stock	72.8	72.8	72.7	72.74	6085.0
2017-07-14 04:00:00	NVDA	Stock	4.01	4.01	4.01	4.01	20880.0
2017-07-14 05:00:00	NVDA	Stock	3.9998	4.01	3.9998	4.01	15000.0
2017-07-14 06:00:00	NVDA	Stock	4.01	4.0125	4.0075	4.0125	82600.0
2017-07-14 07:00:00	NVDA	Stock	4.0112	4.0398	4.003	4.0312	377080.0
2017-07-14 08:00:00	NVDA	Stock	4.0125	4.0432	4.0125	4.0378	3533360.0
2017-07-14 09:00:00	NVDA	Stock	4.038	4.076	4.0312	4.042	151284680.0
2017-07-14 10:00:00	NVDA	Stock	4.0438	4.0662	4.0252	4.0618	138322520.0
2017-07-14 11:00:00	NVDA	Stock	4.062	4.1188	4.0538	4.1012	204228120.0
2017-07-14 12:00:00	NVDA	Stock	4.1005	4.1132	4.087	4.0918	97180760.0
2017-07-14 13:00:00	NVDA	Stock	4.093	4.11	4.0805	4.1038	84877000.0
2017-07-14 14:00:00	NVDA	Stock	4.1038	4.1142	4.0927	4.094	75562160.0
2017-07-14 15:00:00	NVDA	Stock	4.0938	4.125	4.0938	4.1234	148769280.0
2017-07-14 16:00:00	NVDA	Stock	4.1238	4.1263	4.1238	4.1258	6609200.0
2017-07-14 17:00:00	NVDA	Stock	4.125	4.1263	4.1203	4.1212	986040.0
2017-07-14 18:00:00	NVDA	Stock	4.1212	4.1263	4.1212	4.1263	441120.0
2017-07-14 19:00:00	NVDA	Stock	4.125	4.1275	4.1235	4.1258	363080.0
2017-07-14 08:00:00	AMZN	Stock	50.089	50.16	50.0	50.16	276040.0
2017-07-14 09:00:00	AMZN	Stock	50.1115	50.2225	49.869	49.9428	7490780.0
2017-07-14 10:00:00	AMZN	Stock	49.9315	49.995	49.8445	49.9688	6569260.0
2017-07-14 11:00:00	AMZN	Stock	49.9598	50.1385	49.938	50.132	4262340.0
2017-07-14 12:00:00	AMZN	Stock	50.1255	50.155	50.0616	50.1	2410900.0
2017-07-14 13:00:00	AMZN	Stock	50.0985	50.1695	50.051	50.1375	2515300.0

> showing 50 of 47,313 rows — these rows as CSV

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