PREVIEW / stock_1hour / 2015-12-24

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-12-24.parquet
  size:    688 KB
  rows:    29,666
  symbols: 3,323

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
2015-12-24 06:00:00	AAPL	Stock	27.1425	27.1425	27.1425	27.1425	2000.0
2015-12-24 07:00:00	AAPL	Stock	27.1275	27.13	27.1275	27.13	1080.0
2015-12-24 08:00:00	AAPL	Stock	27.1225	27.175	27.1225	27.15	65776.0
2015-12-24 09:00:00	AAPL	Stock	27.1625	27.25	27.0675	27.1075	10104292.0
2015-12-24 10:00:00	AAPL	Stock	27.105	27.1475	26.9875	27.1345	15216496.0
2015-12-24 11:00:00	AAPL	Stock	27.1325	27.1625	27.075	27.1275	9744464.0
2015-12-24 12:00:00	AAPL	Stock	27.1275	27.1325	26.99	27.0075	11148492.0
2015-12-24 13:00:00	AAPL	Stock	27.0075	27.025	27.0	27.0125	4090964.0
2015-12-24 14:00:00	AAPL	Stock	27.01	27.025	27.0075	27.0225	17352.0
2015-12-24 15:00:00	AAPL	Stock	27.0225	27.0325	27.0	27.0075	25188.0
2015-12-24 16:00:00	AAPL	Stock	27.005	27.005	27.0025	27.0025	3048.0
2015-12-24 07:00:00	MSFT	Stock	55.04	55.82	55.04	55.82	200.0
2015-12-24 08:00:00	MSFT	Stock	55.75	55.81	55.65	55.65	4715.0
2015-12-24 09:00:00	MSFT	Stock	55.75	55.96	55.75	55.79	1682015.0
2015-12-24 10:00:00	MSFT	Stock	55.79	55.96	55.575	55.66	2347914.0
2015-12-24 11:00:00	MSFT	Stock	55.66	55.71	55.43	55.684	1804492.0
2015-12-24 12:00:00	MSFT	Stock	55.68	55.83	55.65	55.68	2149478.0
2015-12-24 13:00:00	MSFT	Stock	55.67	55.67	55.45	55.67	1032713.0
2015-12-24 14:00:00	MSFT	Stock	55.74	55.74	55.5	55.5	3770.0
2015-12-24 16:00:00	MSFT	Stock	55.62	55.62	55.62	55.62	1000.0
2015-12-24 08:00:00	NVDA	Stock	0.8265	0.83	0.8265	0.83	92000.0
2015-12-24 09:00:00	NVDA	Stock	0.824	0.8298	0.8228	0.827	7463200.0
2015-12-24 10:00:00	NVDA	Stock	0.8268	0.8309	0.8258	0.8298	11971840.0
2015-12-24 11:00:00	NVDA	Stock	0.8298	0.8308	0.8281	0.8305	9241920.0
2015-12-24 12:00:00	NVDA	Stock	0.8304	0.8312	0.8288	0.8292	16485440.0
2015-12-24 13:00:00	NVDA	Stock	0.8292	0.8292	0.8292	0.8292	4750280.0
2015-12-24 07:00:00	AMZN	Stock	33.1	33.1695	33.1	33.159	18000.0
2015-12-24 08:00:00	AMZN	Stock	33.17	33.175	33.0125	33.175	28220.0
2015-12-24 09:00:00	AMZN	Stock	33.1675	33.1685	33.03	33.065	2970500.0
2015-12-24 10:00:00	AMZN	Stock	33.0792	33.1465	33.05	33.0896	4068680.0
2015-12-24 11:00:00	AMZN	Stock	33.08	33.234	33.0675	33.2005	5361760.0
2015-12-24 12:00:00	AMZN	Stock	33.2171	33.2171	33.1275	33.1405	4764380.0
2015-12-24 13:00:00	AMZN	Stock	33.1395	33.1395	33.0885	33.11	1264720.0
2015-12-24 14:00:00	AMZN	Stock	33.1075	33.1275	33.1075	33.1275	5000.0
2015-12-24 16:00:00	AMZN	Stock	33.1395	33.16	33.1395	33.16	30000.0
2015-12-24 05:00:00	GOOGL	Stock	38.425	38.425	38.425	38.425	10000.0
2015-12-24 08:00:00	GOOGL	Stock	38.35	38.3505	38.35	38.3505	12000.0
2015-12-24 09:00:00	GOOGL	Stock	38.413	38.46	38.2385	38.2385	1416080.0
2015-12-24 10:00:00	GOOGL	Stock	38.24	38.36	38.2195	38.3345	1570640.0
2015-12-24 11:00:00	GOOGL	Stock	38.334	38.4305	38.2898	38.43	830440.0
2015-12-24 12:00:00	GOOGL	Stock	38.4044	38.424	38.25	38.292	1562960.0
2015-12-24 13:00:00	GOOGL	Stock	38.292	38.2995	38.25	38.25	1845540.0
2015-12-24 06:00:00	META	Stock	104.62	104.62	104.58	104.6	1100.0
2015-12-24 07:00:00	META	Stock	104.31	104.31	104.31	104.31	100.0
2015-12-24 08:00:00	META	Stock	104.4	104.59	104.39	104.4	7005.0
2015-12-24 09:00:00	META	Stock	104.5	104.99	104.41	104.69	1267320.0
2015-12-24 10:00:00	META	Stock	104.69	105.12	104.56	105.07	1530887.0
2015-12-24 11:00:00	META	Stock	105.07	105.3	104.9	105.28	1327538.0
2015-12-24 12:00:00	META	Stock	105.27	105.32	104.98	105.02	1457287.0
2015-12-24 13:00:00	META	Stock	105.02	105.08	104.98	104.99	307620.0

> showing 50 of 29,666 rows — these rows as CSV

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