PREVIEW / stock_1hour / 2010-09-13

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-09-13.parquet
  size:    947 KB
  rows:    46,283
  symbols: 3,492

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
2010-09-13 04:00:00	AAPL	Stock	9.4214	9.4464	9.4214	9.4464	8400.0
2010-09-13 05:00:00	AAPL	Stock	9.4664	9.4664	9.4479	9.4479	5600.0
2010-09-13 06:00:00	AAPL	Stock	9.4607	9.4679	9.4607	9.4679	14000.0
2010-09-13 07:00:00	AAPL	Stock	9.4814	9.4961	9.4732	9.475	255920.0
2010-09-13 08:00:00	AAPL	Stock	9.4732	9.5136	9.4725	9.4936	2346372.0
2010-09-13 09:00:00	AAPL	Stock	9.4914	9.5714	9.475	9.5457	84021364.0
2010-09-13 10:00:00	AAPL	Stock	9.545	9.5814	9.545	9.5694	74520656.0
2010-09-13 11:00:00	AAPL	Stock	9.57	9.5743	9.5361	9.5482	37789808.0
2010-09-13 12:00:00	AAPL	Stock	9.5486	9.5489	9.5229	9.5339	37637628.0
2010-09-13 13:00:00	AAPL	Stock	9.5367	9.5571	9.5318	9.5354	28320516.0
2010-09-13 14:00:00	AAPL	Stock	9.5354	9.5482	9.5268	9.5432	25785620.0
2010-09-13 15:00:00	AAPL	Stock	9.5432	9.5504	9.525	9.5464	73048724.0
2010-09-13 16:00:00	AAPL	Stock	9.5471	9.5471	9.5351	9.5429	15898932.0
2010-09-13 17:00:00	AAPL	Stock	9.5429	9.5471	9.5049	9.5393	920304.0
2010-09-13 18:00:00	AAPL	Stock	9.5393	9.5457	9.5371	9.5436	332472.0
2010-09-13 19:00:00	AAPL	Stock	9.5446	9.5464	9.5414	9.5464	124768.0
2010-09-13 04:00:00	MSFT	Stock	24.02	24.02	24.02	24.02	800.0
2010-09-13 05:00:00	MSFT	Stock	24.02	24.14	24.02	24.14	1900.0
2010-09-13 06:00:00	MSFT	Stock	24.17	24.17	24.17	24.17	200.0
2010-09-13 07:00:00	MSFT	Stock	24.2	24.21	24.01	24.21	28580.0
2010-09-13 08:00:00	MSFT	Stock	24.12	24.21	24.07	24.1	31440.0
2010-09-13 09:00:00	MSFT	Stock	24.13	24.35	24.09	24.35	9639075.0
2010-09-13 10:00:00	MSFT	Stock	24.35	24.52	24.34	24.48	14354035.0
2010-09-13 11:00:00	MSFT	Stock	24.479	24.55	24.46	24.51	6618245.0
2010-09-13 12:00:00	MSFT	Stock	24.51	24.51	24.31	24.44	6632545.0
2010-09-13 13:00:00	MSFT	Stock	24.44	24.45	24.36	24.42	3942770.0
2010-09-13 14:00:00	MSFT	Stock	24.415	24.59	24.41	24.525	5873213.0
2010-09-13 15:00:00	MSFT	Stock	24.522	25.29	24.52	25.08	60743753.0
2010-09-13 16:00:00	MSFT	Stock	25.12	25.28	24.56	25.18	4455284.0
2010-09-13 17:00:00	MSFT	Stock	24.329	25.2	24.329	25.12	989372.0
2010-09-13 18:00:00	MSFT	Stock	25.14	25.15	25.1	25.13	69025.0
2010-09-13 19:00:00	MSFT	Stock	25.14	25.18	25.13	25.15	9874.0
2010-09-13 08:00:00	NVDA	Stock	0.255	0.2565	0.255	0.255	131200.0
2010-09-13 09:00:00	NVDA	Stock	0.2553	0.262	0.2553	0.2612	102311640.0
2010-09-13 10:00:00	NVDA	Stock	0.2612	0.2685	0.2612	0.2675	276863240.0
2010-09-13 11:00:00	NVDA	Stock	0.2675	0.2692	0.267	0.2683	115934200.0
2010-09-13 12:00:00	NVDA	Stock	0.2684	0.2685	0.265	0.2668	122452600.0
2010-09-13 13:00:00	NVDA	Stock	0.2668	0.2678	0.2663	0.2665	59526240.0
2010-09-13 14:00:00	NVDA	Stock	0.2665	0.2688	0.2663	0.2685	110385280.0
2010-09-13 15:00:00	NVDA	Stock	0.2685	0.2685	0.266	0.2663	198244360.0
2010-09-13 16:00:00	NVDA	Stock	0.266	0.2673	0.2655	0.2655	13494440.0
2010-09-13 17:00:00	NVDA	Stock	0.2684	0.2684	0.266	0.2668	648160.0
2010-09-13 18:00:00	NVDA	Stock	0.2668	0.267	0.2658	0.2658	154400.0
2010-09-13 19:00:00	NVDA	Stock	0.266	0.2668	0.266	0.2663	228000.0
2010-09-13 04:00:00	AMZN	Stock	7.1435	7.1435	7.1435	7.1435	2000.0
2010-09-13 07:00:00	AMZN	Stock	7.1865	7.1875	7.1865	7.1875	20000.0
2010-09-13 08:00:00	AMZN	Stock	7.1725	7.1875	7.17	7.175	133900.0
2010-09-13 09:00:00	AMZN	Stock	7.1735	7.262	7.1735	7.2505	21301640.0
2010-09-13 10:00:00	AMZN	Stock	7.254	7.287	7.24	7.2605	17362280.0
2010-09-13 11:00:00	AMZN	Stock	7.259	7.282	7.247	7.259	10205960.0

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

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