PREVIEW / stock_1hour / 2016-06-06

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-06-06.parquet
  size:    1.0 MB
  rows:    48,980
  symbols: 3,316

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
2016-06-06 04:00:00	AAPL	Stock	24.48	24.5425	24.48	24.5275	12420.0
2016-06-06 07:00:00	AAPL	Stock	24.5125	24.5375	24.5	24.5375	16836.0
2016-06-06 08:00:00	AAPL	Stock	24.5125	24.5225	24.425	24.495	284040.0
2016-06-06 09:00:00	AAPL	Stock	24.475	24.73	24.3875	24.6732	18449492.0
2016-06-06 10:00:00	AAPL	Stock	24.675	24.73	24.6525	24.7248	11950848.0
2016-06-06 11:00:00	AAPL	Stock	24.725	24.765	24.7	24.745	10473264.0
2016-06-06 12:00:00	AAPL	Stock	24.7475	24.7525	24.6275	24.6825	10250628.0
2016-06-06 13:00:00	AAPL	Stock	24.685	24.7475	24.665	24.7425	6922132.0
2016-06-06 14:00:00	AAPL	Stock	24.745	24.785	24.7025	24.7075	8764548.0
2016-06-06 15:00:00	AAPL	Stock	24.7075	24.7338	24.6575	24.6575	13739160.0
2016-06-06 16:00:00	AAPL	Stock	24.6575	24.6875	24.6425	24.6475	5451276.0
2016-06-06 17:00:00	AAPL	Stock	24.64	24.665	24.6325	24.6625	63956.0
2016-06-06 18:00:00	AAPL	Stock	24.6425	24.6425	24.6425	24.6425	4000.0
2016-06-06 19:00:00	AAPL	Stock	24.6575	24.665	24.65	24.655	10220.0
2016-06-06 06:00:00	MSFT	Stock	51.79	51.79	51.79	51.79	200.0
2016-06-06 07:00:00	MSFT	Stock	51.79	51.79	51.79	51.79	300.0
2016-06-06 08:00:00	MSFT	Stock	51.79	51.84	51.72	51.84	12436.0
2016-06-06 09:00:00	MSFT	Stock	51.83	52.27	51.83	52.144	1860255.0
2016-06-06 10:00:00	MSFT	Stock	52.15	52.19	52.04	52.15	1733474.0
2016-06-06 11:00:00	MSFT	Stock	52.15	52.25	52.14	52.174	1700385.0
2016-06-06 12:00:00	MSFT	Stock	52.17	52.21	51.98	52.07	1534102.0
2016-06-06 13:00:00	MSFT	Stock	52.06	52.29	52.05	52.28	1861114.0
2016-06-06 14:00:00	MSFT	Stock	52.27	52.35	52.16	52.167	2307424.0
2016-06-06 15:00:00	MSFT	Stock	52.17	52.29	52.12	52.14	3465318.0
2016-06-06 16:00:00	MSFT	Stock	52.14	52.21	51.792	52.21	2155471.0
2016-06-06 17:00:00	MSFT	Stock	52.13	52.22	52.13	52.13	108835.0
2016-06-06 19:00:00	MSFT	Stock	52.13	52.13	52.13	52.13	300.0
2016-06-06 06:00:00	NVDA	Stock	1.16	1.16	1.16	1.16	37360.0
2016-06-06 07:00:00	NVDA	Stock	1.165	1.165	1.165	1.165	6000.0
2016-06-06 08:00:00	NVDA	Stock	1.1672	1.1742	1.1672	1.1688	208000.0
2016-06-06 09:00:00	NVDA	Stock	1.1685	1.174	1.1638	1.167	31514600.0
2016-06-06 10:00:00	NVDA	Stock	1.167	1.1678	1.153	1.155	58707880.0
2016-06-06 11:00:00	NVDA	Stock	1.155	1.159	1.153	1.1545	39506280.0
2016-06-06 12:00:00	NVDA	Stock	1.1544	1.1553	1.15	1.153	52586640.0
2016-06-06 13:00:00	NVDA	Stock	1.1528	1.1594	1.1519	1.1578	37378600.0
2016-06-06 14:00:00	NVDA	Stock	1.158	1.1638	1.158	1.1599	27014440.0
2016-06-06 15:00:00	NVDA	Stock	1.1599	1.161	1.1558	1.156	66357520.0
2016-06-06 16:00:00	NVDA	Stock	1.156	1.1587	1.1553	1.1558	1954280.0
2016-06-06 17:00:00	NVDA	Stock	1.1568	1.1568	1.156	1.1562	871400.0
2016-06-06 18:00:00	NVDA	Stock	1.1562	1.1562	1.1562	1.1562	60000.0
2016-06-06 19:00:00	NVDA	Stock	1.1598	1.1598	1.156	1.156	46000.0
2016-06-06 07:00:00	AMZN	Stock	36.3955	36.45	36.3955	36.405	60500.0
2016-06-06 08:00:00	AMZN	Stock	36.355	36.425	36.3505	36.3845	133320.0
2016-06-06 09:00:00	AMZN	Stock	36.384	36.575	36.275	36.4208	12262440.0
2016-06-06 10:00:00	AMZN	Stock	36.4185	36.485	36.3025	36.432	8008840.0
2016-06-06 11:00:00	AMZN	Stock	36.4315	36.5	36.3695	36.3834	4963060.0
2016-06-06 12:00:00	AMZN	Stock	36.378	36.421	36.221	36.2705	6312440.0
2016-06-06 13:00:00	AMZN	Stock	36.2745	36.4185	36.262	36.3736	4152020.0
2016-06-06 14:00:00	AMZN	Stock	36.3695	36.445	36.3515	36.406	4274920.0
2016-06-06 15:00:00	AMZN	Stock	36.413	36.45	36.3255	36.336	8050100.0

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

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