PREVIEW / stock_1hour / 2007-04-27

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-04-27.parquet
  size:    683 KB
  rows:    32,133
  symbols: 2,617

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
2007-04-27 05:00:00	AAPL	Stock	3.5221	3.5225	3.5221	3.5225	11200.0
2007-04-27 06:00:00	AAPL	Stock	3.53	3.53	3.53	3.53	11200.0
2007-04-27 07:00:00	AAPL	Stock	3.5304	3.5321	3.5161	3.5164	203812.0
2007-04-27 08:00:00	AAPL	Stock	3.5214	3.5214	3.4911	3.4964	6569052.0
2007-04-27 09:00:00	AAPL	Stock	3.4957	3.5339	3.4889	3.5129	103794460.0
2007-04-27 10:00:00	AAPL	Stock	3.5129	3.5489	3.5057	3.5243	144660180.0
2007-04-27 11:00:00	AAPL	Stock	3.5239	3.5364	3.5179	3.5361	63925904.0
2007-04-27 12:00:00	AAPL	Stock	3.5361	3.5386	3.5279	3.5321	40255432.0
2007-04-27 13:00:00	AAPL	Stock	3.5321	3.5368	3.5286	3.5339	42549416.0
2007-04-27 14:00:00	AAPL	Stock	3.5343	3.5614	3.5329	3.5529	90489728.0
2007-04-27 15:00:00	AAPL	Stock	3.5529	3.5696	3.5507	3.5682	137579568.0
2007-04-27 16:00:00	AAPL	Stock	3.5682	3.5686	3.5675	3.5686	3132192.0
2007-04-27 09:00:00	MSFT	Stock	30.17	30.6	30.0	30.527	32039342.0
2007-04-27 10:00:00	MSFT	Stock	30.53	30.74	30.32	30.46	26614502.0
2007-04-27 11:00:00	MSFT	Stock	30.46	30.47	30.27	30.43	15300439.0
2007-04-27 12:00:00	MSFT	Stock	30.44	30.45	30.18	30.18	7947114.0
2007-04-27 13:00:00	MSFT	Stock	30.19	30.29	30.15	30.23	6556747.0
2007-04-27 14:00:00	MSFT	Stock	30.23	30.33	30.19	30.323	9846020.0
2007-04-27 15:00:00	MSFT	Stock	30.33	30.36	30.07	30.13	16818785.0
2007-04-27 16:00:00	MSFT	Stock	30.15	30.15	30.12	30.12	1111878.0
2007-04-27 08:00:00	NVDA	Stock	0.5583	0.5583	0.5583	0.5583	6000.0
2007-04-27 09:00:00	NVDA	Stock	0.5552	0.563	0.5543	0.5617	50731380.0
2007-04-27 10:00:00	NVDA	Stock	0.5617	0.5617	0.544	0.5458	137241600.0
2007-04-27 11:00:00	NVDA	Stock	0.546	0.546	0.5423	0.5437	81635940.0
2007-04-27 12:00:00	NVDA	Stock	0.5438	0.5488	0.5435	0.5472	61063020.0
2007-04-27 13:00:00	NVDA	Stock	0.5472	0.5473	0.5445	0.5446	58217760.0
2007-04-27 14:00:00	NVDA	Stock	0.5447	0.5483	0.5447	0.5478	56169180.0
2007-04-27 15:00:00	NVDA	Stock	0.5478	0.552	0.5473	0.552	89908740.0
2007-04-27 16:00:00	NVDA	Stock	0.552	0.552	0.5492	0.5517	5479620.0
2007-04-27 19:00:00	NVDA	Stock	0.5505	0.5505	0.5505	0.5505	60000.0
2007-04-27 04:00:00	AMZN	Stock	3.14	3.14	3.13	3.13	12000.0
2007-04-27 05:00:00	AMZN	Stock	3.1075	3.1075	3.1005	3.1005	10000.0
2007-04-27 06:00:00	AMZN	Stock	3.1275	3.1275	3.1175	3.1225	88000.0
2007-04-27 07:00:00	AMZN	Stock	3.125	3.137	3.1	3.12	5453820.0
2007-04-27 08:00:00	AMZN	Stock	3.12	3.1255	3.0625	3.0705	26823880.0
2007-04-27 09:00:00	AMZN	Stock	3.07	3.101	3.035	3.051	198254760.0
2007-04-27 10:00:00	AMZN	Stock	3.0515	3.123	3.031	3.1145	193937140.0
2007-04-27 11:00:00	AMZN	Stock	3.1145	3.115	3.063	3.092	88511640.0
2007-04-27 12:00:00	AMZN	Stock	3.092	3.1125	3.065	3.0984	56589380.0
2007-04-27 13:00:00	AMZN	Stock	3.097	3.125	3.088	3.1115	58829800.0
2007-04-27 14:00:00	AMZN	Stock	3.1115	3.192	3.109	3.1355	198357640.0
2007-04-27 15:00:00	AMZN	Stock	3.136	3.138	3.096	3.134	141656820.0
2007-04-27 16:00:00	AMZN	Stock	3.13	3.137	3.044	3.132	42445780.0
2007-04-27 17:00:00	AMZN	Stock	3.1345	3.1355	3.1275	3.1275	290380.0
2007-04-27 18:00:00	AMZN	Stock	3.13	3.1435	3.13	3.1435	498520.0
2007-04-27 19:00:00	AMZN	Stock	3.1435	3.1435	3.132	3.1365	95000.0
2007-04-27 09:00:00	CL	Stock	33.28	33.335	33.16	33.335	531800.0
2007-04-27 10:00:00	CL	Stock	33.335	33.505	33.325	33.435	750768.0
2007-04-27 11:00:00	CL	Stock	33.435	33.51	33.425	33.47	585568.0
2007-04-27 12:00:00	CL	Stock	33.47	33.615	33.455	33.605	617786.0

> showing 50 of 32,133 rows — these rows as CSV

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