PREVIEW / stock_1hour / 2013-01-22

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-01-22.parquet
  size:    978 KB
  rows:    46,448
  symbols: 3,501

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
2013-01-22 04:00:00	AAPL	Stock	17.8714	17.915	17.8	17.9118	120316.0
2013-01-22 05:00:00	AAPL	Stock	17.9118	17.9875	17.9118	17.9643	95172.0
2013-01-22 06:00:00	AAPL	Stock	17.9814	17.9875	17.9379	17.9464	144760.0
2013-01-22 07:00:00	AAPL	Stock	17.9464	17.9664	17.8929	17.9214	1376256.0
2013-01-22 08:00:00	AAPL	Stock	17.9268	18.0136	17.8057	17.9829	6867364.0
2013-01-22 09:00:00	AAPL	Stock	17.9829	18.1386	17.9125	17.9214	84600404.0
2013-01-22 10:00:00	AAPL	Stock	17.9214	17.9318	17.8036	17.8464	79517088.0
2013-01-22 11:00:00	AAPL	Stock	17.8439	17.8564	17.7368	17.7714	51555280.0
2013-01-22 12:00:00	AAPL	Stock	17.7739	17.8529	17.7686	17.8093	34058752.0
2013-01-22 13:00:00	AAPL	Stock	17.8096	17.9129	17.7911	17.8861	39120704.0
2013-01-22 14:00:00	AAPL	Stock	17.8906	18.0071	17.8839	17.9656	54652276.0
2013-01-22 15:00:00	AAPL	Stock	17.9671	18.0318	17.9286	18.0254	72716560.0
2013-01-22 16:00:00	AAPL	Stock	18.0275	18.125	17.8361	18.1243	21880096.0
2013-01-22 17:00:00	AAPL	Stock	18.1161	18.1668	18.1161	18.1357	2252964.0
2013-01-22 18:00:00	AAPL	Stock	18.1339	18.1568	18.1286	18.1536	717108.0
2013-01-22 19:00:00	AAPL	Stock	18.1536	18.1554	18.1179	18.1179	914816.0
2013-01-22 05:00:00	MSFT	Stock	27.25	27.25	27.25	27.25	100.0
2013-01-22 06:00:00	MSFT	Stock	27.27	27.38	27.27	27.38	1000.0
2013-01-22 07:00:00	MSFT	Stock	27.3	27.3	27.28	27.28	1010.0
2013-01-22 08:00:00	MSFT	Stock	27.25	27.32	27.18	27.25	25570.0
2013-01-22 09:00:00	MSFT	Stock	27.25	27.45	27.22	27.34	9970248.0
2013-01-22 10:00:00	MSFT	Stock	27.34	27.35	27.21	27.295	6733388.0
2013-01-22 11:00:00	MSFT	Stock	27.295	27.3	27.05	27.08	11456923.0
2013-01-22 12:00:00	MSFT	Stock	27.08	27.22	27.05	27.2	5110101.0
2013-01-22 13:00:00	MSFT	Stock	27.2	27.205	27.13	27.165	3745170.0
2013-01-22 14:00:00	MSFT	Stock	27.16	27.2	27.14	27.175	3609340.0
2013-01-22 15:00:00	MSFT	Stock	27.17	27.18	27.0	27.16	11014870.0
2013-01-22 16:00:00	MSFT	Stock	27.14	27.218	27.11	27.21	5921718.0
2013-01-22 17:00:00	MSFT	Stock	27.22	27.22	27.17	27.21	28618.0
2013-01-22 18:00:00	MSFT	Stock	27.19	27.21	27.18	27.2	5416.0
2013-01-22 19:00:00	MSFT	Stock	27.2	27.23	27.18	27.23	4678.0
2013-01-22 07:00:00	NVDA	Stock	0.3075	0.3075	0.3075	0.3075	40000.0
2013-01-22 08:00:00	NVDA	Stock	0.3062	0.309	0.3042	0.305	260000.0
2013-01-22 09:00:00	NVDA	Stock	0.304	0.3068	0.303	0.3033	22566640.0
2013-01-22 10:00:00	NVDA	Stock	0.3035	0.304	0.3012	0.302	59880520.0
2013-01-22 11:00:00	NVDA	Stock	0.302	0.3025	0.3012	0.3016	30273160.0
2013-01-22 12:00:00	NVDA	Stock	0.3018	0.304	0.3015	0.3029	20951000.0
2013-01-22 13:00:00	NVDA	Stock	0.3028	0.3038	0.3025	0.303	18633640.0
2013-01-22 14:00:00	NVDA	Stock	0.3031	0.3042	0.3018	0.3028	50984800.0
2013-01-22 15:00:00	NVDA	Stock	0.3026	0.303	0.3015	0.3028	89512000.0
2013-01-22 16:00:00	NVDA	Stock	0.3028	0.3038	0.3022	0.3038	14735520.0
2013-01-22 17:00:00	NVDA	Stock	0.3038	0.3038	0.3032	0.3032	20000.0
2013-01-22 06:00:00	AMZN	Stock	13.639	13.639	13.6	13.6	10000.0
2013-01-22 07:00:00	AMZN	Stock	13.625	13.672	13.615	13.625	115600.0
2013-01-22 08:00:00	AMZN	Stock	13.625	13.6255	13.5925	13.6	60240.0
2013-01-22 09:00:00	AMZN	Stock	13.602	13.605	13.551	13.5915	6310140.0
2013-01-22 10:00:00	AMZN	Stock	13.583	13.5905	13.5065	13.5365	8808240.0
2013-01-22 11:00:00	AMZN	Stock	13.5315	13.538	13.4755	13.505	7233200.0
2013-01-22 12:00:00	AMZN	Stock	13.5075	13.545	13.5	13.5051	3891720.0
2013-01-22 13:00:00	AMZN	Stock	13.505	13.5435	13.494	13.5035	2731660.0

> showing 50 of 46,448 rows — these rows as CSV

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