PREVIEW / stock_1hour / 2016-08-15

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-08-15.parquet
  size:    1.0 MB
  rows:    48,694
  symbols: 3,280

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-08-15 04:00:00	AAPL	Stock	27.1175	27.12	27.1175	27.12	4000.0
2016-08-15 05:00:00	AAPL	Stock	27.1025	27.1025	27.0825	27.0825	2256.0
2016-08-15 06:00:00	AAPL	Stock	27.1075	27.1075	27.1025	27.1025	4144.0
2016-08-15 07:00:00	AAPL	Stock	27.12	27.12	27.1025	27.1125	14000.0
2016-08-15 08:00:00	AAPL	Stock	27.12	27.125	27.1	27.1125	228488.0
2016-08-15 09:00:00	AAPL	Stock	27.1075	27.2925	27.02	27.2375	20791136.0
2016-08-15 10:00:00	AAPL	Stock	27.2398	27.3625	27.2375	27.3188	16528604.0
2016-08-15 11:00:00	AAPL	Stock	27.3178	27.385	27.3025	27.3298	10182376.0
2016-08-15 12:00:00	AAPL	Stock	27.33	27.36	27.3175	27.3462	5353316.0
2016-08-15 13:00:00	AAPL	Stock	27.3475	27.35	27.2975	27.3188	6358524.0
2016-08-15 14:00:00	AAPL	Stock	27.3175	27.355	27.305	27.345	6819096.0
2016-08-15 15:00:00	AAPL	Stock	27.345	27.3825	27.3275	27.3775	20300008.0
2016-08-15 16:00:00	AAPL	Stock	27.3775	27.455	27.37	27.45	7979912.0
2016-08-15 17:00:00	AAPL	Stock	27.45	27.455	27.43	27.4425	126316.0
2016-08-15 18:00:00	AAPL	Stock	27.445	27.4975	27.4375	27.4875	221856.0
2016-08-15 19:00:00	AAPL	Stock	27.4875	27.495	27.4775	27.4925	166864.0
2016-08-15 04:00:00	MSFT	Stock	57.94	58.0	57.94	58.0	650.0
2016-08-15 05:00:00	MSFT	Stock	58.03	58.03	58.03	58.03	100.0
2016-08-15 06:00:00	MSFT	Stock	58.06	58.28	58.06	58.28	600.0
2016-08-15 07:00:00	MSFT	Stock	58.02	58.02	58.02	58.02	1000.0
2016-08-15 08:00:00	MSFT	Stock	58.02	58.06	58.02	58.06	790.0
2016-08-15 09:00:00	MSFT	Stock	58.05	58.3	57.96	58.3	1744332.0
2016-08-15 10:00:00	MSFT	Stock	58.295	58.37	58.11	58.365	2210789.0
2016-08-15 11:00:00	MSFT	Stock	58.361	58.49	58.305	58.475	2453672.0
2016-08-15 12:00:00	MSFT	Stock	58.47	58.5	58.44	58.495	1544261.0
2016-08-15 13:00:00	MSFT	Stock	58.49	58.5	58.43	58.43	1046456.0
2016-08-15 14:00:00	MSFT	Stock	58.434	58.44	58.29	58.33	1688173.0
2016-08-15 15:00:00	MSFT	Stock	58.335	58.36	58.12	58.13	5132143.0
2016-08-15 16:00:00	MSFT	Stock	58.125	58.21	58.07	58.15	1858203.0
2016-08-15 17:00:00	MSFT	Stock	58.15	58.19	58.12	58.12	504190.0
2016-08-15 18:00:00	MSFT	Stock	58.2	58.2	58.2	58.2	148.0
2016-08-15 19:00:00	MSFT	Stock	58.15	58.18	58.15	58.15	2550.0
2016-08-15 04:00:00	NVDA	Stock	1.58	1.5863	1.58	1.5863	80000.0
2016-08-15 05:00:00	NVDA	Stock	1.5863	1.5863	1.5775	1.5775	68000.0
2016-08-15 06:00:00	NVDA	Stock	1.5762	1.585	1.5762	1.58	193080.0
2016-08-15 07:00:00	NVDA	Stock	1.582	1.5838	1.58	1.5803	210520.0
2016-08-15 08:00:00	NVDA	Stock	1.5803	1.582	1.5745	1.5762	1955400.0
2016-08-15 09:00:00	NVDA	Stock	1.5762	1.5818	1.5533	1.5643	95916720.0
2016-08-15 10:00:00	NVDA	Stock	1.5638	1.575	1.5625	1.5711	76294800.0
2016-08-15 11:00:00	NVDA	Stock	1.571	1.5818	1.5706	1.5808	70126640.0
2016-08-15 12:00:00	NVDA	Stock	1.581	1.5874	1.578	1.5829	59839000.0
2016-08-15 13:00:00	NVDA	Stock	1.583	1.583	1.5758	1.576	40739880.0
2016-08-15 14:00:00	NVDA	Stock	1.576	1.5825	1.5758	1.5791	43285680.0
2016-08-15 15:00:00	NVDA	Stock	1.579	1.5792	1.5732	1.5744	83708120.0
2016-08-15 16:00:00	NVDA	Stock	1.5745	1.5758	1.5728	1.5745	1333240.0
2016-08-15 17:00:00	NVDA	Stock	1.5745	1.575	1.5725	1.5725	197680.0
2016-08-15 18:00:00	NVDA	Stock	1.574	1.5743	1.5735	1.5735	34000.0
2016-08-15 19:00:00	NVDA	Stock	1.5728	1.5728	1.5725	1.5725	13200.0
2016-08-15 04:00:00	AMZN	Stock	38.7555	38.7555	38.7555	38.7555	2000.0
2016-08-15 05:00:00	AMZN	Stock	38.7	38.732	38.7	38.732	6740.0

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

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