PREVIEW / stock_1hour / 2017-11-02

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-11-02.parquet
  size:    1.1 MB
  rows:    48,237
  symbols: 2,943

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-11-02 04:00:00	AAPL	Stock	41.7	41.75	41.7	41.7375	10544.0
2017-11-02 05:00:00	AAPL	Stock	41.7275	41.7275	41.6975	41.6975	800.0
2017-11-02 06:00:00	AAPL	Stock	41.7275	41.7875	41.6975	41.705	36704.0
2017-11-02 07:00:00	AAPL	Stock	41.7625	41.975	41.6925	41.9675	250416.0
2017-11-02 08:00:00	AAPL	Stock	41.775	42.07	41.725	41.9	932904.0
2017-11-02 09:00:00	AAPL	Stock	41.9	41.9375	41.475	41.68	13799288.0
2017-11-02 10:00:00	AAPL	Stock	41.6825	41.7175	41.4425	41.625	14536464.0
2017-11-02 11:00:00	AAPL	Stock	41.6225	41.7125	41.32	41.555	11190580.0
2017-11-02 12:00:00	AAPL	Stock	41.56	42.0525	41.48	41.93	20110784.0
2017-11-02 13:00:00	AAPL	Stock	41.9275	41.9775	41.8075	41.9125	11305460.0
2017-11-02 14:00:00	AAPL	Stock	41.915	42.125	41.914	42.01	14945956.0
2017-11-02 15:00:00	AAPL	Stock	42.0125	42.1	41.92	42.0175	24876312.0
2017-11-02 16:00:00	AAPL	Stock	42.0275	43.5875	42.0175	43.425	26890696.0
2017-11-02 17:00:00	AAPL	Stock	43.425	43.52	42.0275	42.815	7839392.0
2017-11-02 18:00:00	AAPL	Stock	42.815	43.2	42.8	43.1375	1667008.0
2017-11-02 19:00:00	AAPL	Stock	43.14	43.355	43.1375	43.345	1131912.0
2017-11-02 04:00:00	MSFT	Stock	83.15	83.17	83.15	83.17	1020.0
2017-11-02 05:00:00	MSFT	Stock	83.15	83.15	83.15	83.15	274.0
2017-11-02 06:00:00	MSFT	Stock	83.15	83.15	83.15	83.15	120.0
2017-11-02 07:00:00	MSFT	Stock	83.04	83.18	83.04	83.18	790.0
2017-11-02 08:00:00	MSFT	Stock	83.01	83.39	83.01	83.39	2213.0
2017-11-02 09:00:00	MSFT	Stock	83.37	83.48	83.15	83.27	2178691.0
2017-11-02 10:00:00	MSFT	Stock	83.27	83.99	83.12	83.83	4507837.0
2017-11-02 11:00:00	MSFT	Stock	83.83	84.03	83.45	83.76	2671920.0
2017-11-02 12:00:00	MSFT	Stock	83.765	84.15	83.75	84.02	2081804.0
2017-11-02 13:00:00	MSFT	Stock	84.02	84.46	84.0	84.02	2446631.0
2017-11-02 14:00:00	MSFT	Stock	84.02	84.3	84.0	84.11	1885679.0
2017-11-02 15:00:00	MSFT	Stock	84.11	84.2	83.95	84.06	4329704.0
2017-11-02 16:00:00	MSFT	Stock	84.05	84.21	83.329	84.2	2085675.0
2017-11-02 17:00:00	MSFT	Stock	84.17	84.3	84.13	84.3	9240.0
2017-11-02 19:00:00	MSFT	Stock	84.26	84.3	84.26	84.3	5611.0
2017-11-02 04:00:00	NVDA	Stock	5.155	5.155	5.155	5.155	4000.0
2017-11-02 05:00:00	NVDA	Stock	5.155	5.1688	5.155	5.1688	115520.0
2017-11-02 06:00:00	NVDA	Stock	5.1625	5.1625	5.1625	5.1625	43200.0
2017-11-02 07:00:00	NVDA	Stock	5.1625	5.175	5.15	5.15	863760.0
2017-11-02 08:00:00	NVDA	Stock	5.15	5.17	5.148	5.1545	1393080.0
2017-11-02 09:00:00	NVDA	Stock	5.1545	5.1953	5.1053	5.1675	59706760.0
2017-11-02 10:00:00	NVDA	Stock	5.1675	5.1725	5.1108	5.1272	63714880.0
2017-11-02 11:00:00	NVDA	Stock	5.1278	5.164	5.0913	5.1318	53443640.0
2017-11-02 12:00:00	NVDA	Stock	5.131	5.1558	5.127	5.1348	25689640.0
2017-11-02 13:00:00	NVDA	Stock	5.1347	5.1523	5.1322	5.1369	15847160.0
2017-11-02 14:00:00	NVDA	Stock	5.136	5.1705	5.1325	5.1502	22920600.0
2017-11-02 15:00:00	NVDA	Stock	5.1515	5.1602	5.1438	5.1478	39144760.0
2017-11-02 16:00:00	NVDA	Stock	5.178	5.178	5.1438	5.168	7940920.0
2017-11-02 17:00:00	NVDA	Stock	5.1663	5.1722	5.1528	5.1575	606240.0
2017-11-02 18:00:00	NVDA	Stock	5.1575	5.1675	5.1538	5.1668	176480.0
2017-11-02 19:00:00	NVDA	Stock	5.1668	5.1728	5.1612	5.1728	442360.0
2017-11-02 05:00:00	AMZN	Stock	55.0	55.0	55.0	55.0	7500.0
2017-11-02 07:00:00	AMZN	Stock	55.0	55.0	54.95	55.0	104240.0
2017-11-02 08:00:00	AMZN	Stock	54.86	55.0385	54.86	55.0385	66520.0

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

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