PREVIEW / stock_1hour / 2010-08-03

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-08-03.parquet
  size:    903 KB
  rows:    43,096
  symbols: 3,481

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-08-03 04:00:00	AAPL	Stock	9.3561	9.3561	9.3561	9.3561	5600.0
2010-08-03 06:00:00	AAPL	Stock	9.3532	9.3532	9.3532	9.3532	2800.0
2010-08-03 07:00:00	AAPL	Stock	9.3536	9.3536	9.3393	9.3393	63700.0
2010-08-03 08:00:00	AAPL	Stock	9.3393	9.3496	9.3218	9.3475	589428.0
2010-08-03 09:00:00	AAPL	Stock	9.3446	9.3493	9.2757	9.2886	49989576.0
2010-08-03 10:00:00	AAPL	Stock	9.2879	9.323	9.265	9.3186	65849112.0
2010-08-03 11:00:00	AAPL	Stock	9.32	9.4021	9.2959	9.3932	71576428.0
2010-08-03 12:00:00	AAPL	Stock	9.3925	9.3936	9.3104	9.3443	61395124.0
2010-08-03 13:00:00	AAPL	Stock	9.3429	9.3764	9.3271	9.3621	34753404.0
2010-08-03 14:00:00	AAPL	Stock	9.3632	9.3743	9.3421	9.3639	33114060.0
2010-08-03 15:00:00	AAPL	Stock	9.364	9.3668	9.3268	9.3543	57745212.0
2010-08-03 16:00:00	AAPL	Stock	9.3546	9.3829	9.3099	9.3582	38450580.0
2010-08-03 17:00:00	AAPL	Stock	9.3669	9.3669	9.3582	9.3643	540680.0
2010-08-03 18:00:00	AAPL	Stock	9.3646	9.3754	9.3439	9.3446	961044.0
2010-08-03 19:00:00	AAPL	Stock	9.3482	9.3496	9.3457	9.3468	164304.0
2010-08-03 07:00:00	MSFT	Stock	26.27	26.27	26.26	26.26	1600.0
2010-08-03 08:00:00	MSFT	Stock	26.26	26.26	26.19	26.19	8900.0
2010-08-03 09:00:00	MSFT	Stock	26.19	26.35	26.14	26.2	6651345.0
2010-08-03 10:00:00	MSFT	Stock	26.2	26.28	26.13	26.275	7209941.0
2010-08-03 11:00:00	MSFT	Stock	26.29	26.32	26.16	26.19	5295451.0
2010-08-03 12:00:00	MSFT	Stock	26.195	26.2	25.97	26.0	9318608.0
2010-08-03 13:00:00	MSFT	Stock	26.005	26.03	25.97	25.97	6477209.0
2010-08-03 14:00:00	MSFT	Stock	25.97	26.1	25.97	26.06	6742559.0
2010-08-03 15:00:00	MSFT	Stock	26.065	26.15	26.02	26.13	8351516.0
2010-08-03 16:00:00	MSFT	Stock	26.16	26.19	26.048	26.19	6413492.0
2010-08-03 17:00:00	MSFT	Stock	26.19	26.22	26.12	26.2	18750.0
2010-08-03 18:00:00	MSFT	Stock	26.2	26.2	26.16	26.16	10129.0
2010-08-03 19:00:00	MSFT	Stock	26.18	26.21	26.18	26.21	2300.0
2010-08-03 20:00:00	MSFT	Stock	26.5	26.5	26.5	26.5	161300.0
2010-08-03 08:00:00	NVDA	Stock	0.229	0.23	0.2275	0.2283	330040.0
2010-08-03 09:00:00	NVDA	Stock	0.2288	0.2292	0.222	0.223	189629600.0
2010-08-03 10:00:00	NVDA	Stock	0.223	0.2265	0.2218	0.2243	186867320.0
2010-08-03 11:00:00	NVDA	Stock	0.2243	0.225	0.224	0.2248	60542640.0
2010-08-03 12:00:00	NVDA	Stock	0.2248	0.2248	0.2238	0.2243	88948640.0
2010-08-03 13:00:00	NVDA	Stock	0.2244	0.225	0.2238	0.2248	63758680.0
2010-08-03 14:00:00	NVDA	Stock	0.2248	0.2252	0.223	0.2235	93742520.0
2010-08-03 15:00:00	NVDA	Stock	0.2238	0.224	0.2225	0.2232	244131160.0
2010-08-03 16:00:00	NVDA	Stock	0.2235	0.224	0.223	0.224	13701200.0
2010-08-03 17:00:00	NVDA	Stock	0.224	0.224	0.2235	0.224	147560.0
2010-08-03 18:00:00	NVDA	Stock	0.224	0.224	0.2238	0.224	202200.0
2010-08-03 19:00:00	NVDA	Stock	0.224	0.224	0.2238	0.224	380320.0
2010-08-03 07:00:00	AMZN	Stock	6.0375	6.0375	6.0375	6.0375	5100.0
2010-08-03 08:00:00	AMZN	Stock	6.025	6.025	5.9925	5.9995	27500.0
2010-08-03 09:00:00	AMZN	Stock	5.999	6.077	5.984	6.038	20485040.0
2010-08-03 10:00:00	AMZN	Stock	6.037	6.113	6.011	6.111	27447140.0
2010-08-03 11:00:00	AMZN	Stock	6.113	6.1435	6.101	6.1195	17350600.0
2010-08-03 12:00:00	AMZN	Stock	6.12	6.136	6.097	6.1115	9606880.0
2010-08-03 13:00:00	AMZN	Stock	6.1115	6.1375	6.1	6.116	10741020.0
2010-08-03 14:00:00	AMZN	Stock	6.115	6.127	6.111	6.124	8907200.0
2010-08-03 15:00:00	AMZN	Stock	6.1235	6.127	6.0955	6.1155	20392720.0

> showing 50 of 43,096 rows — these rows as CSV

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