PREVIEW / stock_1hour / 2017-06-21

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-06-21.parquet
  size:    1.0 MB
  rows:    47,896
  symbols: 3,021

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-06-21 04:00:00	AAPL	Stock	36.17	36.175	36.0875	36.175	6820.0
2017-06-21 05:00:00	AAPL	Stock	36.1475	36.1475	36.135	36.135	23024.0
2017-06-21 06:00:00	AAPL	Stock	36.1275	36.1825	36.1	36.1825	9236.0
2017-06-21 07:00:00	AAPL	Stock	36.1875	36.1875	36.15	36.1875	18120.0
2017-06-21 08:00:00	AAPL	Stock	36.2075	36.3575	36.125	36.345	162584.0
2017-06-21 09:00:00	AAPL	Stock	36.3375	36.4325	36.1525	36.1925	9625572.0
2017-06-21 10:00:00	AAPL	Stock	36.1925	36.4438	36.1875	36.395	11874648.0
2017-06-21 11:00:00	AAPL	Stock	36.395	36.4375	36.2725	36.43	7865304.0
2017-06-21 12:00:00	AAPL	Stock	36.43	36.435	36.3125	36.3545	6268548.0
2017-06-21 13:00:00	AAPL	Stock	36.355	36.4275	36.315	36.37	5991252.0
2017-06-21 14:00:00	AAPL	Stock	36.365	36.5	36.325	36.4475	7307720.0
2017-06-21 15:00:00	AAPL	Stock	36.4487	36.5172	36.425	36.4675	12376208.0
2017-06-21 16:00:00	AAPL	Stock	36.4675	36.4975	36.3625	36.465	16125696.0
2017-06-21 17:00:00	AAPL	Stock	36.465	36.47	36.46	36.47	23080.0
2017-06-21 18:00:00	AAPL	Stock	36.47	36.475	36.46	36.46	8684.0
2017-06-21 19:00:00	AAPL	Stock	36.47	36.475	36.455	36.4725	34100.0
2017-06-21 05:00:00	MSFT	Stock	69.76	69.76	69.76	69.76	400.0
2017-06-21 06:00:00	MSFT	Stock	69.75	69.8	69.75	69.8	700.0
2017-06-21 07:00:00	MSFT	Stock	70.09	70.09	69.82	69.82	647.0
2017-06-21 08:00:00	MSFT	Stock	69.97	70.18	69.97	70.1	5595.0
2017-06-21 09:00:00	MSFT	Stock	70.1	70.48	69.94	69.955	2511940.0
2017-06-21 10:00:00	MSFT	Stock	69.97	70.4	69.965	70.34	2436698.0
2017-06-21 11:00:00	MSFT	Stock	70.33	70.62	70.22	70.62	1985645.0
2017-06-21 12:00:00	MSFT	Stock	70.62	70.62	70.31	70.35	1302990.0
2017-06-21 13:00:00	MSFT	Stock	70.345	70.59	70.21	70.27	1562333.0
2017-06-21 14:00:00	MSFT	Stock	70.27	70.45	70.2	70.36	2117135.0
2017-06-21 15:00:00	MSFT	Stock	70.36	70.41	70.26	70.27	3690602.0
2017-06-21 16:00:00	MSFT	Stock	70.27	70.75	70.27	70.67	2011837.0
2017-06-21 17:00:00	MSFT	Stock	70.73	70.75	70.62	70.66	9872.0
2017-06-21 18:00:00	MSFT	Stock	70.7	70.7	70.27	70.27	189793.0
2017-06-21 19:00:00	MSFT	Stock	70.72	70.74	70.63	70.65	800.0
2017-06-21 04:00:00	NVDA	Stock	3.9335	3.9335	3.925	3.925	48760.0
2017-06-21 05:00:00	NVDA	Stock	3.9148	3.9148	3.9148	3.9148	14800.0
2017-06-21 06:00:00	NVDA	Stock	3.9148	3.9148	3.9088	3.9142	83280.0
2017-06-21 07:00:00	NVDA	Stock	3.924	3.9338	3.905	3.9338	512480.0
2017-06-21 08:00:00	NVDA	Stock	3.929	3.9575	3.9125	3.9525	3566720.0
2017-06-21 09:00:00	NVDA	Stock	3.9548	3.982	3.8925	3.9035	161060880.0
2017-06-21 10:00:00	NVDA	Stock	3.9024	3.9625	3.899	3.9445	143612280.0
2017-06-21 11:00:00	NVDA	Stock	3.9446	3.9572	3.9258	3.9555	84652640.0
2017-06-21 12:00:00	NVDA	Stock	3.9562	3.971	3.9405	3.9448	69650240.0
2017-06-21 13:00:00	NVDA	Stock	3.9458	3.9825	3.945	3.9785	68353000.0
2017-06-21 14:00:00	NVDA	Stock	3.978	3.9802	3.9625	3.9752	49843520.0
2017-06-21 15:00:00	NVDA	Stock	3.975	3.9905	3.9625	3.9868	81173560.0
2017-06-21 16:00:00	NVDA	Stock	3.9815	3.9925	3.9815	3.9888	3608200.0
2017-06-21 17:00:00	NVDA	Stock	3.9888	3.9913	3.9788	3.9835	927960.0
2017-06-21 18:00:00	NVDA	Stock	3.9825	3.9875	3.98	3.985	381000.0
2017-06-21 19:00:00	NVDA	Stock	3.9862	3.9875	3.9762	3.9762	1283600.0
2017-06-21 04:00:00	AMZN	Stock	49.6425	49.65	49.558	49.558	22000.0
2017-06-21 06:00:00	AMZN	Stock	49.6085	49.6685	49.6085	49.6685	16800.0
2017-06-21 07:00:00	AMZN	Stock	49.7	49.7	49.685	49.7	8000.0

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

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